SET OPERATIONS: Temporal queries can have distinct names for all boundaries, check mismatches and wrong positions
Created by: Piiit
The test case test-temporal-setop.sql
fails!
-- Testing: scalars and functions for temporal boundaries
select a,b,lower(t) ts1, upper(t) te1 from e
UNION PERIOD WITH (ts1,te1,ts2,te2)
select a,b,lower(t) ts2, upper(t) te2 from f
order by 1,2,3,4;
psql:unibz/tests/test-temporal-setop.sql:74: ERROR: column temporal_setop_x2.ts2 does not exist
LINE 2: UNION PERIOD WITH (ts1,te1,ts2,te2)
^
HINT: Perhaps you meant to reference the column "temporal_setop_x2"."ts1".