02-Fill

Fill: basic test

1. Test fill + value, while generating multiple columns simultaneously

2. Test various methods such as prev, NULL, none, next, linear, null, null_f, and more

3. Test insert two rows and check fill(value, 0, 0) and fill(value, 1000, 10)

path: cases/13-TimeSeriesExt/02-Fill/test_ts_fill.py

Fill with sliding

1. Check the correctness of duration when filling null for sliding interval window

2. Use first and last function to verify the window range

3. Sliding window with duration overlapping

4. Fill with null method

5. Verify the correctness of _wstart, _wduration, _wend columns

path: cases/13-TimeSeriesExt/02-Fill/test_ts_fill.py

Fill datatype

1. Create normal/super tables with various decimal/decimal64 and other data types

2. Insert data into the tables

3. Run fill queries with different fill methods (PREV, NEXT, NULL, LINEAR, NULL_F)

4. Validate the results to ensure correctness of the fill operation

path: cases/13-TimeSeriesExt/02-Fill/test_ts_fill_datatype.py

Fill method

1. Create database with ns precision

2. Create table with different data types

3. Insert data with nulls

4. Perform fill queries with different data types and methods (value, null, prev, next)

5. Query with multi-threaded fill range

6. Validate the filled results for each data type

7. Fill with group by queries

8. Fill with complex expressions

path: cases/13-TimeSeriesExt/02-Fill/test_ts_fill_method.py