Unable to left join on windowed session

[Tal Shargal]

Hi,

I'm trying to run time-windowed-left-join but the results are identical to those that are returned from the same query but using INNER JOIN.
Means, the records from the "left" side that have no match are not included in the output stream.

SELECT a.name, b.name
FROM TEST_A a left join TEST_B b
ON UPPER(a.name)=UPPER(b.name) AND a.event_time BETWEEN b.event_time - INTERVAL '5' SECOND AND b.event_time + INTERVAL '5' SECOND

I'd appreciate your assistance.

Thank you,

Tal