[ 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 result The Postgres and Mysql was: For the sql : {code:java} select cast(200 as boolean) {code} The Postgres and > 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 > > For the sql : > {code:java} > select cast(200 as boolean) {code} > The result The Postgres and Mysql -- This message was sent by Atlassian Jira (v8.20.10#820010)