[CALCITE-6560] Allow types with negative scale

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.38.0
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: xiong duan
• Created: 02/Sep/24 22:35
• Updated: 5 days ago 22:41
• Resolved: 5 days ago 22:41

Description

In interface RelDataTypeSystem, add methods getMinScale(SqlTypeName) and getDefaultScale(SqlTypeName); if getMinScale returns a negative value for the DECIMAL type, the type system will allow DECIMAL values with negative scale.

https://www.postgresql.org/docs/current/datatype-numeric.html

According to the document, a numeric column with a negative scale can be declared beginning in PostgreSQL 15. This PR will add some tests to cover getMinScale is non-negative and will throw an exception if set getMinScale is negative.

Issue Links

• blocks: CALCITE-6582 Release Calcite 1.38.0
• is related to: CALCITE-6602 Deadlock while loading class SqlTypeFixture
• is related to: CALCITE-6406 Negative scales for DECIMAL types are not tested
• relates to: CALCITE-6598 In RelDataTypeSystem, deprecate methods getMaxNumericScale and getMaxNumericPrecision
• links to: GitHub Pull Request #3945