You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@calcite.apache.org by "bingfeng.guo (Jira)" <ji...@apache.org> on 2019/12/11 10:12:00 UTC

[jira] [Created] (CALCITE-3589) SqlValidatorException when conformation is set to LENIENT

bingfeng.guo created CALCITE-3589:
-------------------------------------

             Summary: SqlValidatorException when conformation is set to LENIENT
                 Key: CALCITE-3589
                 URL: https://issues.apache.org/jira/browse/CALCITE-3589
             Project: Calcite
          Issue Type: Bug
            Reporter: bingfeng.guo


{color:#172b4d}When conformance is set to LENIENT, and the alias of the select expression is the same as the table name in the expression, and the expression appears in group by, a SqlValidatorException will occur{color}

{color:#ff8b00}SELECT MY_ID + 1 AS MY_ID, sum(PRICE){color}
{color:#ff8b00}FROM tableA{color}
{color:#ff8b00}GROUP BY MY_ID + 1{color}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)