Changeset: 7c71b741b5fd for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7c71b741b5fd Modified Files: sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out Branch: typing Log Message:
Approved output. The results for division with month intervals needs validation diffs (43 lines): diff --git a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql --- a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql +++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql @@ -20,3 +20,11 @@ SELECT INTERVAL '1' MONTH * cast(1.0 as SELECT INTERVAL '1' SECOND * cast(2.44 as double); -- 2.440 SELECT INTERVAL '5' SECOND * cast(2.29 as real); -- 11.450 SELECT INTERVAL '5' SECOND * cast(1.0 as double); -- 5.000 + +SELECT INTERVAL '1' MONTH / cast(2.0 as double); -- 0 +SELECT INTERVAL '1' MONTH / cast(1.5 as double); -- 0 +SELECT INTERVAL '1' MONTH / cast(1.0 as double); -- 1 + +SELECT INTERVAL '1' SECOND / cast(2.0 as double); -- 0.500 +SELECT INTERVAL '5' SECOND / cast(1.5 as double); -- 3.330 +SELECT INTERVAL '5' SECOND / cast(1.0 as double); -- 5.000 diff --git a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out --- a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out +++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out @@ -119,6 +119,24 @@ stdout of test 'interval-math.Bug-6935` % sec_interval # type % 5 # length [ 5.000 ] +#SELECT INTERVAL '1' SECOND / cast(2.0 as double); -- 0.500 +% .%2 # table_name +% %2 # name +% sec_interval # type +% 5 # length +[ 0.500 ] +#SELECT INTERVAL '5' SECOND / cast(1.5 as double); -- 3.330 +% .%2 # table_name +% %2 # name +% sec_interval # type +% 5 # length +[ 3.333 ] +#SELECT INTERVAL '5' SECOND / cast(1.0 as double); -- 5.000 +% .%2 # table_name +% %2 # name +% sec_interval # type +% 5 # length +[ 5.000 ] # 10:13:31 > # 10:13:31 > "Done." _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list