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)