Mihai Budiu created CALCITE-7683:
------------------------------------
Summary: SessionizationEnumerator produces wrong results for
SESSION table function
Key: CALCITE-7683
URL: https://issues.apache.org/jira/browse/CALCITE-7683
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.42.0
Reporter: Mihai Budiu
The following quidem test produces incorrect results:
{code:java}
SELECT * FROM TABLE(
SESSION(
(SELECT * FROM (VALUES
(TIMESTAMP '2020-01-01 10:00:00', 'a'),
(TIMESTAMP '2020-01-01 10:05:00', 'a'),
(TIMESTAMP '2020-01-01 10:30:00', 'a')) AS T(TS, UID)),
DESCRIPTOR(TS), DESCRIPTOR(UID), INTERVAL '15' MINUTE)); {code}
Expected result: two sessions (first 2 rows, last row).
Produced result: one session.
Quidem test output:
{code:java}
+---------------------+-----+---------------------+---------------------+
| TS | UID | window_start | window_end |
+---------------------+-----+---------------------+---------------------+
| 2020-01-01 10:00:00 | a | 2020-01-01 10:00:00 | 2020-01-01 10:45:00 |
| 2020-01-01 10:05:00 | a | 2020-01-01 10:00:00 | 2020-01-01 10:45:00 |
| 2020-01-01 10:30:00 | a | 2020-01-01 10:00:00 | 2020-01-01 10:45:00 |
+---------------------+-----+---------------------+---------------------+
(3 rows){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
