Changeset: eb7b7c474646 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=eb7b7c474646 Added Files: sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.sql sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.err sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.out Modified Files: sql/test/BugTracker-2020/Tests/All Branch: Oct2020 Log Message:
Add test and output for bug 7003 diffs (85 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 @@ -28,5 +28,6 @@ HAVE_PYMONETDB?table-udf-on-remote.Bug-6 integers-intervals.Bug-6979 KNOWNFAIL?wrong-key-error.Bug-6983 semijoin.Bug-7001 +decimal-multiplication.Bug-7003 drop-stream-table.Bug-7005 deallocate-id.Bug-7010 diff --git a/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.sql b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.sql @@ -0,0 +1,12 @@ +select 0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1; +-- 0.000000000000000000000000000000000000000 + +select 0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1; +-- 8.6 + +select cast(0.1 as double)*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1; +-- 1.0e-86 + +select power(0.1, 86); +-- 1.0e-86 + diff --git a/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.err b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.err @@ -0,0 +1,12 @@ +stderr of test 'decimal-multiplication.Bug-7003` in directory 'sql/test/BugTracker-2020` itself: + + +# 21:08:04 > +# 21:08:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13109" "--port=35110" +# 21:08:04 > + + +# 21:08:04 > +# 21:08:04 > "Done." +# 21:08:04 > + diff --git a/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.out b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2020/Tests/decimal-multiplication.Bug-7003.stable.out @@ -0,0 +1,36 @@ +stdout of test 'decimal-multiplication.Bug-7003` in directory 'sql/test/BugTracker-2020` itself: + + +# 21:08:04 > +# 21:08:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13109" "--port=35110" +# 21:08:04 > + +#select 0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1; +% .%2 # table_name +% %2 # name +% decimal # type +% 41 # length +[ 0.00000000000000000000000000000000000000 ] +#select 0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1+0.1; +% .%2 # table_name +% %2 # name +% decimal # type +% 4 # length +[ 8.6 ] +#select cast(0.1 as double)*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1*0.1; +% .%2 # table_name +% %2 # name +% double # type +% 24 # length +[ 1e-86 ] +#select power(0.1, 86); +% .%2 # table_name +% %2 # name +% double # type +% 24 # length +[ 1e-86 ] + +# 21:08:04 > +# 21:08:04 > "Done." +# 21:08:04 > + _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
