[CALCITE-6376] Selecting 6 columns with QUALIFY operation results in exception

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.36.0
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Austin Richardson
• Created: 19/Apr/24 13:32
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

Example query:

 

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

 

And exception snippet:

 

Caused by: java.lang.ClassCastException: class org.apache.calcite.rex.RexInputRef cannot be cast to class java.lang.Comparable (org.apache.calcite.rex.RexInputRef is in unnamed module of loader org.springframework.boot.loader.LaunchedURLClassLoader @257f30f7; java.lang.Comparable is in module java.base of loader 'bootstrap')
	at org.apache.calcite.runtime.FlatLists$ComparableListImpl.get(FlatLists.java:1319)
	at org.apache.calcite.runtime.FlatLists$ComparableListImpl.get(FlatLists.java:1309)
	at java.base/java.util.AbstractList$Itr.next(AbstractList.java:373)

 

Either removing one of the columns or the QUALIFY filter results in a successful query.

Issue Links

• links to: GitHub Pull Request #3780
• links to: GitHub Pull Request #3781