Changeset: 3c8c223e9e4b for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3c8c223e9e4b Added Files: sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.err sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: default Log Message:
Added test for Bug 6935. Most of it has already been fixed on typing branch diffs (64 lines): diff --git a/sql/test/BugTracker-2020/Tests/All b/sql/test/BugTracker-2020/Tests/All --- a/sql/test/BugTracker-2020/Tests/All +++ b/sql/test/BugTracker-2020/Tests/All @@ -14,5 +14,6 @@ ilike-matches.Bug-6864 select-and.Bug-6878 copy-decimal-with-space.Bug-6917 isauuid.Bug-6934 +interval-math.Bug-6935 tpch-cube.Bug-6938 HAVE_PYMONETDB?remote-table-like.Bug-6841 diff --git a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.sql @@ -0,0 +1,4 @@ +SELECT INTERVAL '1' HOUR / 2, INTERVAL '1' HOUR / 2.0, INTERVAL '1' HOUR * 1000 / 2000, INTERVAL '1' HOUR * 1000.0 / 2000.0; --all output 1800.000 +SELECT INTERVAL '1' HOUR * 1000 / 1800000; -- 2.000 +SELECT INTERVAL '1' HOUR * CAST(1000 AS DOUBLE); +SELECT INTERVAL '1' HOUR / INTERVAL '1800' SECOND; --error on typing branch, cannot divide intervals diff --git a/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.err b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.err @@ -0,0 +1,11 @@ +stderr of test 'interval-math.Bug-6935` in directory 'sql/test/BugTracker-2020` itself: + + +# 10:13:31 > +# 10:13:31 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-80282" "--port=37020" +# 10:13:31 > + +# 10:13:31 > +# 10:13:31 > "Done." +# 10:13:31 > + 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 new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/interval-math.Bug-6935.stable.out @@ -0,0 +1,24 @@ +stdout of test 'interval-math.Bug-6935` in directory 'sql/test/BugTracker-2020` itself: + + +# 10:13:31 > +# 10:13:31 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-80282" "--port=37020" +# 10:13:31 > + +#SELECT INTERVAL '1' HOUR / 2, INTERVAL '1' HOUR / 2.0, INTERVAL '1' HOUR * 1000 / 2000, INTERVAL '1' HOUR * 1000.0 / 2000.0; +% .%2, .%3, .%4, .%5 # table_name +% %2, %3, %4, %5 # name +% sec_interval, sec_interval, sec_interval, sec_interval # type +% 8, 8, 8, 8 # length +[ 1800.000, 1800.000, 1800.000, 1800.000 ] +#SELECT INTERVAL '1' HOUR * 1000 / 1800000; -- 2.000 +% .%2 # table_name +% %2 # name +% sec_interval # type +% 5 # length +[ 2.000 ] + +# 10:13:31 > +# 10:13:31 > "Done." +# 10:13:31 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
