[jira] [Created] (CALCITE-6376) Filtering CTE of at least 6 columns with QUALIFY operation results in exception
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)
[jira] [Created] (CALCITE-6303) UNION with CTE(s) results in exception during query validation
Austin Richardson created CALCITE-6303:
--
Summary: UNION with CTE(s) results in exception during query
validation
Key: CALCITE-6303
URL: https://issues.apache.org/jira/browse/CALCITE-6303
Project: Calcite
Issue Type: Bug
Affects Versions: 1.36.0
Reporter: Austin Richardson
Attempting to execute a query that includes a UNION with CTE(s) in one of its
operands results in a ClassCastException during query validation.
Example query:
{code:java}
( SELECT 123 )
UNION
( WITH t (col) AS (VALUES (456)) SELECT col FROM t ) {code}
Snippet from resulting exception:
{code:java}
java.lang.ClassCastException: class org.apache.calcite.sql.SqlNodeList cannot
be cast to class org.apache.calcite.sql.SqlCall
at
org.apache.calcite.sql.validate.SqlValidatorImpl.deduceModality(SqlValidatorImpl.java:4093){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
