Description
Ensure casting intervals to integers always returns the result in terms
of the trailing unit.
Currently we have the following behavior:
- Casting a standalone day interval literal returns results in terms of the field.
- Casting a standalone year interval literal returned results in terms of months.
- Casting a day interval expression returned results in terms of milliseconds.
- Casting a year interval expression returned results in terms of months.
Attachments
Issue Links
- blocks
-
CALCITE-2339 JDBC adapter should transform timestamp arithmetic for target database
-
- Open
-