Enze Liu created CALCITE-4724:
---------------------------------
Summary: ClickHouseSqlDialect `supportsAliasedValues` should
return false.
Key: CALCITE-4724
URL: https://issues.apache.org/jira/browse/CALCITE-4724
Project: Calcite
Issue Type: Bug
Components: core
Affects Versions: 1.27.0
Reporter: Enze Liu
We use ClickHouseSqlDialect to do some sql optimize.
for sql `select 1`, in the process of sqlNode -> relNode -> sqlNode, the sql
string will be transformed to
{code:java}
SELECT *
FROM (VALUES (1)) AS `t` (`EXPR$0`)
{code}
Since clickhouse is not support AliasedValues, all we need to do is to extend
ClickHouseSqlDialect and make `supportsAliasedValues` return false.
Maybe this kind of behavior can integrated into core?
If needed, the pull request is ready.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
