03-TimeWindow

Interval: auto

1. Testing the mixed use of interval and auto

2. Combined with LIMIT, ts filtering conditions

3. Combined with sliding

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_auto.py

Interval: basic test

1. Testing the use of interval, offset, and sliding

2. Testing their use with GROUP BY, ORDER BY, and PARTITION BY

3. Testing different fill methods, such as NULL, prev, next

4. Testing mixed use with functions such as count, sum, max, min, count, stddev, last, spread

5. Testing unit interval:

- percision ms/us/ns

- different interval/sliding/offset units: a/s/m/h/d/w/M/y

- invalid unit handling

6. Testing explain plan for interval/sliding/offset

7. Testing limit/offset with interval queries

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_basic.py

Interval: test fill with surrounding time

1. Testing basic query of interval fill with surrounding time

2. Testing abnormal query of interval fill with surrounding time,

e.g. 'near' mode, wrong parameters, etc.

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_basic.py

Interval: bug fixed

1. Jira TS-5400

2. Jira TS-7676

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_bugfix.py

Interval: project merge resblock flag

1. Build a subquery + interval shape that has a non-terminal projection node

2. Verify explain plan sets Projection Merge ResBlocks to False

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_project_merge_resblock.py

Interval: timezone

test interval with client and server using different timezone

path: cases/13-TimeSeriesExt/03-TimeWindow/test_interval_timezone.py