[
https://issues.apache.org/jira/browse/CALCITE-7683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ASF GitHub Bot updated CALCITE-7683:
------------------------------------
Labels: pull-request-available (was: )
> 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
> Priority: Minor
> Labels: pull-request-available
>
> 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)
