Mihai Budiu created CALCITE-5343: ------------------------------------ Summary: Type of division operator Key: CALCITE-5343 URL: https://issues.apache.org/jira/browse/CALCITE-5343 Project: Calcite Issue Type: Bug Components: core Reporter: Mihai Budiu
The Calcite type checker assigns a type of INTEGER (not nullable) to the DIVIDE RexCall in the following statement: `SELECT 1/0`. Some databases, such as MySQL, evaluate this expression to NULL. This result is obtained even when using SqlConformanceEnum.MYSQL_5 for the parser and the validator. My question is whether there is some other way to influence how type inference is performed for division. -- This message was sent by Atlassian Jira (v8.20.10#820010)