Skip to content

06-Precision

Precision bugs
1. Verify bug TS-3311 (timestamp precision cause wrong window function result)
path: cases/02-Databases/06-Precision/test_db_precision_bugs.py

Precision: ns
1. Create a nanosecond-precision database.
2. Insert data using numeric timestamps.
3. Verify the row count.
4. Insert data using now().
5. Filter data by timestamp.
6. Validate INTERVAL … SLIDING queries.
7. Validate time macro functions.
8. Validate where clause with timestamp comparisons.
path: cases/02-Databases/06-Precision/test_db_precision_ns.py

Precision: ms and us
1. Millisecond-precision test
2. Create a millisecond-precision database
3. Insert both valid and invalid timestamps
4. Query the data
5. Microsecond-precision test
6. Create a microsecond-precision database
7. Repeat the same insert and query steps as above
8. Validate time macro functions.
9. Validate where clause with timestamp comparisons.
path: cases/02-Databases/06-Precision/test_db_precision_us.py