[jira] [Created] (CALCITE-6829) MSSQL dialect incorrectly translates of SELECT TRUE

[Sree Harsha Ramanavarapu (Jira)]

Sree Harsha Ramanavarapu created CALCITE-6829:
-------------------------------------------------

             Summary: MSSQL dialect incorrectly translates of SELECT TRUE
                 Key: CALCITE-6829
                 URL: https://issues.apache.org/jira/browse/CALCITE-6829
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Sree Harsha Ramanavarapu


MSSQL allows only expressions in the SELECT List (or VALUES clause). This is 
transformed into:
SELECT * FROM (VALUES (TRUE)) AS t (EXPR$0)
error: Invalid column name 'TRUE'

 

But this works:
 
SELECT * FROM (VALUES (1)) AS t (EXPR$0)
 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)