TEMPORAL JOINS: Different results with same input but different bound-types
Created by: Piiit
Taken from test-temporal-join.sql
. We get different results, but they should be equal, except the column types of the temporal attributes.
A=# \i unibz/tests/test-temporal-join.sql
CREATE TABLE
INSERT 0 3
CREATE TABLE
INSERT 0 1
CREATE VIEW
CREATE VIEW
a | b | a | b | tts
---+---+---+---+-------
1 | A | 1 | A | [3,4)
2 | A | 1 | A | [3,4)
(2 rows)
a | b | a | b | tts | tte
---+---+---+---+-----+-----
2 | A | 1 | A | 4 | 3
(1 row)
DROP VIEW
DROP TABLE
Belongs to #55.