Description

mihaibudiu

opened on Oct 28, 2026

Issue body actions

What is the result of INTERVAL 1 YEAR * 1.3?
The standard says that this should be an INTERVAL YEAR, and thus be rounded to a whole number of years, producing INTERVAL 1 YEAR as a result.

Our typing rules match the standard.

But at runtime we actually store an integer number of months and produce an interval storing 15 months.

Spark types things differently, producing a result typed INTERVAL YEAR TO MONTH, which could store this result.

So our typing matches the standard, but our runtime behavior matches Spark. We have to choose one of the two.

Activity

1. mihaibudiu

   self-assigned this

   on Oct 28, 2026
2. mihaibudiu

   added

   SQL compilerRelated to the SQL compilerRelated to the SQL compiler

   on Oct 28, 2026
3. mihaibudiu

   added the

   Bug

   issue type on Oct 28, 2026
4. mihaibudiu

   added 5 commits that reference this issue on Oct 29, 2026

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit bc73945 is merged into the 'main' branch.

   bc73945

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit af09657 is merged into the 'main' branch.

   af09657

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit d66d9ea is merged into the 'main' branch.

   d66d9ea

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit ca12040 is merged into the 'main' branch.

   ca12040

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit 71a6fd1 is merged into the 'main' branch.

   71a6fd1
5. mihaibudiu

   closed this as completedin #7692on Oct 31, 2026
6. yermakoffivan

   added a commit that references this issue on Oct 31, 2026

   [SQL] Date and interval arithmetic follow the SQL standard

   This issue will close once commit 18f734e is merged into the 'main' branch.

   18f734e

Issue actions