Austin Richardson created CALCITE-6376:
------------------------------------------
Summary: Filtering CTE of at least 6 columns with QUALIFY
operation results in exception
Key: CALCITE-6376
URL: https://issues.apache.org/jira/browse/CALCITE-6376
Project: Calcite
Issue Type: Bug
Affects Versions: 1.36.0
Reporter: Austin Richardson
Example query:
{code:java}
WITH MyCTE AS (
SELECT
column1,
column2,
column3,
column4,
column5,
column6
FROM (
VALUES
('value1', 10, 5.0, 'data1', 'info1', 'test1'),
('value2', 20, 4.0, 'data2', 'info2', 'test2'),
('value3', 30, 3.0, 'data3', 'info3', 'test3'),
('value4', 40, 2.0, 'data4', 'info4', 'test4'),
('value5', 50, 1.0, 'data5', 'info5', 'test5')
) AS t(column1, column2, column3, column4, column5, column6)
)
SELECT *
FROM MyCTE
QUALIFY RANK() OVER (ORDER BY column3) = 1{code}
Either removing one of the columns or the QUALIFY filter results in a
successful query.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
