Changeset: 3e099b2ec0ff for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3e099b2ec0ff Modified Files: sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.sql sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out Branch: int128 Log Message:
large-number-operation-strange-results.Bug-2929: refined test for 38-digit decimals (128-bit integers) diffs (59 lines): diff --git a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.sql b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.sql --- a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.sql +++ b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.sql @@ -1,4 +1,5 @@ -select 10000000 * 100000 * 11.51 + 51.097 * 100000; -select convert(100000000000,HUGEINT) * 1000000000 * 11.51 + 51.097 * 1000000000; -select convert (10000000 * 100000 * 11.51,decimal(15)) +convert (51.097 * 100000, decimal(15)); -select convert (convert(100000000000,HUGEINT) * 1000000000 * 11.51,decimal(35)) +convert (51.097 * 1000000000, decimal(35)); +select 10000000 * 100000 * 11.51 + 51.097 * 100000; +select convert(1000000000000000000 , decimal(20)) * 100000000000000 * 11.51 + 51.097 * 100000000000000; + +select convert ( 10000000 * 100000 * 11.51 , decimal(15)) + convert (51.097 * 100000 , decimal(15)); +select convert (convert(1000000000000000000 , decimal(20)) * 100000000000000 * 11.51 , decimal(35)) + convert (51.097 * 100000000000000 , decimal(35)); diff --git a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err --- a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err +++ b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.err @@ -29,9 +29,9 @@ stderr of test 'large-number-operation-s # 14:36:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=riga" "--port=32568" # 14:36:23 > -MAPI = monetdb@niels:34633 -QUERY = select 10000000 * 100000 * 11.51 + 51.097 * 100000; -ERROR = !overflow in calculation 115100000000000000*100. +MAPI = (monetdb) /var/tmp/mtest-28228/.s.monetdb.38744 +QUERY = select convert(1000000000000000000 , decimal(20)) * 100000000000000 * 11.51 + 51.097 * 100000000000000; +ERROR = !overflow in calculation 115099999999999999673254835333890048*10000. # 14:36:23 > diff --git a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out --- a/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out +++ b/sql/test/BugTracker-2012/Tests/large-number-operation-strange-results.Bug-2929.stable.out @@ -48,12 +48,24 @@ Ready. # 14:36:23 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=riga" "--port=32568" # 14:36:23 > -#select convert (10000000 * 100000 * 11.51,decimal(15)) +convert (51.097 * 100000, decimal(15)); -% . # table_name +#select 10000000 * 100000 * 11.51 + 51.097 * 100000; +% .L # table_name +% sql_mul_single_value # name +% decimal # type +% 40 # length +[ 11510005109700.000000 ] +#select convert ( 10000000 * 100000 * 11.51 , decimal(15)) + convert (51.097 * 100000 , decimal(15)); +% .L # table_name % sql_mul_single_value # name % decimal # type % 19 # length [ 11510005109700 ] +#select convert (convert(1000000000000000000 , decimal(20)) * 100000000000000 * 11.51 , decimal(35)) + convert (51.097 * 100000000000000 , decimal(35)); +% .L # table_name +% sql_mul_single_value # name +% decimal # type +% 39 # length +[ 1151000000000000005109700000000000 ] # 14:36:23 > # 14:36:23 > "Done." _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
