duan xiong created CALCITE-4838: ----------------------------------- Summary: add roundingMode in SqlConformance to document how to cast an approximate numeric to int Key: CALCITE-4838 URL: https://issues.apache.org/jira/browse/CALCITE-4838 Project: Calcite Issue Type: Bug Components: core Affects Versions: 1.27.0 Reporter: duan xiong Assignee: duan xiong
According to the SQL Strandard about how to cast an approximate numeric to int in different database have different RoundingMode. for example: In PostgreSQL、Mysql、Oracle(RoundingMode.UP): {code:java} select cast(5.1 as int) return 5 select cast(5.5 as int) return 6 {code} In Calcite、Sql Server 2008(RoundingMode.DOWN): {code:java} select cast(5.1 as int) return 5 select cast(5.5 as int) return 5 {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)