TEMPORAL JOINS: where clause handling
Created by: Piiit
How do we handle an additional where clause? Where do we attach it? To the ABSORB where clause on the outer select statement or can we put it inside?
For example:
SELECT * FROM r
JOIN PERIOD WITH (ts,te,ts,te) s ON b=d WHERE a=1;
Belongs to #55.