Details
-
Bug
-
Status: Resolved
-
Minor
-
Resolution: Fixed
-
2.0.0, 2.1.0, 2.2.0, 2.3.0, 2.4.0
Description
- The fractional part of interval seconds unit is incorrectly parsed if the number of digits is less than 9, for example:
spark-sql> select interval '10.123456 seconds'; interval 10 seconds 123 microsecondsThe result must be interval 10 seconds 123 milliseconds 456 microseconds
- If the seconds unit of an interval is negative, it is incorrectly converted to `CalendarInterval`, for example:
spark-sql> select interval '-10.123456789 seconds'; interval -9 seconds -876 milliseconds -544 microsecondsTaking into account truncation to microseconds, the result must be interval -10 seconds -123 milliseconds -456 microseconds