dynamobi/dynamobi — Issue #580: [FRG-292] incorrect type derivation for highly fractional numeric literal
Author: dynamobi-build
Created: 2011-12-30 03:36:37+00:00
State: open
Labels: FRG, SQL Validator

[reporter="jvs", created="Wed, 5 Sep 2007 12:06:32 -0500 (GMT-05:00)"]
The type is derived as DECIMAL(20,19), which is an illegal datatype, since our max precision is currently 19. Either it should be producing NUMERIC(19,19) after recognizing that the leading zero is insignificant, or it should be an error.

0: jdbc:luciddb:> explain plan with type for values 0.1234567890123456789;

+----------------------------------+

| column0 |

+----------------------------------+

| EXPR$0 DECIMAL(20, 19) NOT NULL |

+----------------------------------+