PG testing routine for temporal primitives is not complete
Created by: Piiit
All major test cases have been added, we consider the rest as future work.
The following test cases are still missing for the PRIMITIVE TEST:
test-ambiguous-columns.sql
test-indexes.sql
test-subselects-and-aliases.sql
NaN for floats is not checked yet. It should produce an ERROR, but currently it is treated like a regular number. We remove it from the test for now.
INSERT INTO tpg_table12 VALUES
(0, 1.0, 'NaN'),
(1, 'NaN', 2.0);
-- Data types: Double precision with "NaN" (ERROR expected, not implemented yet)
SELECT a, ts, te FROM (
tpg_table12 t1 ALIGN tpg_table12 t2
ON TRUE
WITH (ts, te, ts, te)
) x;
-- Data types: Double precision with "NaN" (ERROR expected, not implemented yet)
SELECT a, ts, te FROM (
tpg_table12 t1 NORMALIZE tpg_table12 t2
ON TRUE
WITH (ts, te, ts, te)
) x;