[jira] [Created] (CALCITE-4724) ClickHouseSqlDialect `supportsAliasedValues` should return false.

["Enze Liu (Jira)" <ji...@apache.org>]

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)