github.com/influxdata/influxdb/v2@v2.7.6/influxql/v1validation/goldenfiles/join.yaml (about)

     1  description: |
     2    This test suite verifies correctness of queries containing
     3    fields in the WHERE condition. In most cases, the field
     4    in the SELECT projection is different, to test joins across
     5    fields.
     6  
     7  tests:
     8    - name: "no_aggregate"
     9      query: "select f1 from m0 where f0 > 1 AND time >= 30000000000 AND time <= 50000000000"
    10      result: |
    11        name,tags,time,f1
    12        m0,,50000000000,30
    13  
    14    - name: "aggregate"
    15      description: |
    16        This test verifies that an aggregate
    17  
    18      query: "SELECT sum(f1) FROM m0 WHERE f0 >= 1"
    19      result: |
    20        name,tags,time,sum
    21        m0,,0,50
    22  
    23  dataset: |
    24    m0,t0=tv0 f0=0i,f1=10i 30000000000
    25    m0,t0=tv1 f0=1i,f1=20i 40000000000
    26    m0,t0=tv1 f0=2i,f1=30i 50000000000
    27    m1,t0=tv0 f0=0i,f1=10i 40000000000