Sergey Nuyanzin created FLINK-37850:
---------------------------------------
Summary: Several Union, Except, Intersect with one wrong column
type fail with UnsupportedOperationException
Key: FLINK-37850
URL: https://issues.apache.org/jira/browse/FLINK-37850
Project: Flink
Issue Type: Improvement
Components: Table SQL / Planner
Reporter: Sergey Nuyanzin
Assignee: Sergey Nuyanzin
Example of failing query
{code:scala}
val sqlQuery =
"""
| SELECT id, ts, name, timestamp_col, timestamp_ltz_col FROM t2
| UNION ALL
| SELECT id, ts, name, timestamp_col, timestamp_ltz_col FROM t3
| UNION ALL
| SELECT id, ts, timestamp_col as wrong_column_type, timestamp_col,
timestamp_ltz_col FROM t2
""".stripMargin
util.verifyRelPlanWithType(sqlQuery)
{code}
the root cause is issue in Calcite (fixed in 1.40)
CALCITE-7027
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
