Details
-
Bug
-
Status: Closed
-
Minor
-
Resolution: Fixed
-
1.38.0
Description
Consider the following SQL expression:
SELECT CAST('1' AS INTERVAL HOURS)
RexSimplify.simplifyCast reduces this to a RelLiteral with value 1 and type INTERVAL HOURS. However, the representation of short intervals should use the canonical value of the interval in milliseconds, so the correct value should be 3600000.
Attachments
Issue Links
- links to