12-Interp¶
¶
Interp bugs
1. Verify bug TS-3404 (timestamp precision cause wrong window function result)
¶
Interp fill and psedo column
1. Used with PARTITION BY
2. Used with _isfilled and _irowts in both the select list and as ORDER BY columns
3. Testing more comprehensive fill modes
¶
Interp abnormal query
1. Testing abnormal query
¶
Interp query fill with non-null values
1. testing fill(prev/next/near/linear) filling nulls
with non-null values
¶
Interp query fill with non-null values in scan
1. testing interp query filling nulls with non-null values
2. testing PREV and NEXT scan stop at non-null values
¶
Interp query fill with non-null values in stream
- testing fill(prev/next/near/linear) filling nulls
with non-null values in stream
- using simple data in ntb table to test computing results. ntb
just has 8 rows of data
¶
Interp query fill with non-null values in stream
- testing fill(prev/next/near/linear) filling nulls
with non-null values in stream
- using advanced data in table ntb1 to test computing results. ntb1
has 20000 rows of data and last 10000 rows are null, thus notify
message is needed to notify the scan operator in stream runner
¶
Interp query on super table
1. testing interp query on super table. It will use merge scan instead
of table scan. Test the functionality and guarantee the correctness and
memory safety.
¶
Interp fill extension
1. Query interp fill extension with large data volume
2. Query interp fill extension with near mode
3. Query interp fill extension with linear mode
4. Query interp fill extension with prev mode
5. Query interp fill extension with next mode
6. Query interp fill extension with value mode
7. Query interp fill extension with null mode
8. Multi-threaded query interp fill extension
¶
Interp normal query of interp filling with surround
1. testing interp filling with surrounding time
¶
Interp normal query of interp filling with surround in stream
1. testing interp filling with surrounding time in stream
¶
Interp abnormal query of interp filling with surround
1. testing abnormal parameters of interp filling with surrounding time