[jira] [Created] (CALCITE-6376) Filtering CTE of at least 6 columns with QUALIFY operation results in exception

["Austin Richardson (Jira)" <ji...@apache.org>]

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)