[CALCITE-5870] Allow literals like DECIMAL '12.3' (consistent with Postgres)

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: LakeShen
• Reporter: LakeShen
• Created: 24/Jul/23 11:20
• Updated: 10/Nov/23 11:34
• Resolved: 19/Aug/23 03:23

Description

In Postgresql,It supports the following sql grammar:

select DECIMAL '99.999' 

Postgresql converts DECIMAL '99.999' to numeric constants：

Now core sql parser converts DECIMAL '99.999' to AS SqlBasicCall,like this:

this jira allow literals like DECIMAL '12.3' (consistent with Postgres)

Issue Links

• is related to: CALCITE-5424 Customize handling of literals based on type system
• links to: GitHub Pull Request #3337