[CALCITE-4081] Round-tripping a DECIMAL literal through Planner -> RelToSqlConverter -> Planner throws validation error

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.25.0
• Labels: pull-request-available
• Assignee: Chunwei Lei
• Reporter: Steven Talbot
• Created: 22/Jun/20 16:34
• Updated: 22/Aug/20 18:48
• Resolved: 06/Aug/20 06:36

Description

Take the following SQL:
SELECT CAST('11111111111111111111111111111111.111111' AS DECIMAL(38,6)) AS "num"
And, in the default Calcite SQL dialect with all defaults, send it through Planner parse -> valiate -> rel to get a RelNode. The RelNode will have a Project with the "111111111111111.11111" literal in there as a RexLiteral with Decimal type. 

 

The use RelToSqlConverter to convert that RelNode back to SQL. The SQL now looks like 
SELECT 11111111111111111111111111111111.111111 AS "num"
 

If you attempt to parse and validate that SQL, you get "Numeric literal '11111111111111111111111111111111.111111' out of range" throw by SqlValidatorImpl.validateLiteral()

Issue Links

• is related to: CALCITE-4118 RexSimplify might remove CAST from RexNode incorrectly
• links to: GitHub Pull Request #2089