[ https://issues.apache.org/jira/browse/CALCITE-5959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
LakeShen updated CALCITE-5959: ------------------------------ Description: For the sql : {code:java} select cast(200 as boolean) {code} The above results are true in Mysql and Postgres. !image-2023-08-27-12-56-11-390.png|width=503,height=213! But in calcite,the result is false: {code:java} LogicalValues(tuples=[[{ false }]]) {code} was: For the sql : {code:java} select cast(200 as boolean) {code} The result The Postgres and Mysql > Cast(200 as boolean) should return true(consistent with Postgres and Mysql) > --------------------------------------------------------------------------- > > Key: CALCITE-5959 > URL: https://issues.apache.org/jira/browse/CALCITE-5959 > Project: Calcite > Issue Type: Bug > Reporter: LakeShen > Priority: Major > Attachments: image-2023-08-27-12-56-11-390.png > > > For the sql : > {code:java} > select cast(200 as boolean) {code} > The above results are true in Mysql and Postgres. > !image-2023-08-27-12-56-11-390.png|width=503,height=213! > But in calcite,the result is false: > {code:java} > LogicalValues(tuples=[[{ false }]]) {code} -- This message was sent by Atlassian Jira (v8.20.10#820010)