[CALCITE-3522] SqlValidator.validateLiteral rejects literals with a DECIMAL type that require more than 64 bits

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 1.18.0, 1.36.0
• Fix Version/s: 1.38.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Mihai Budiu
• Reporter: Changbo Shu
• Created: 20/Nov/19 04:44
• Updated: 17/Oct/24 22:41
• Resolved: 17/Oct/24 22:41

Description

https://github.com/apache/calcite/blob/master/core/src/main/java/org/apache/calcite/sql/validate/SqlValidatorImpl.java#L2983

for example:

create table tbl(f1 double),

f1 stores a double's max value. (1.7976931348623157E308)

long max value is 9223372036854775807.

select * from table where f1=value, if value is greater than long max, sqlvalidator will throw out of range exception.

Issue Links

• relates to: CALCITE-3135 Calcite decimal literal validation
• links to: GitHub Pull Request #3589