Changeset: 36fbf84db514 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/36fbf84db514 Modified Files: sql/test/BugTracker-2025/Tests/7754-overflow-in-conversion-to-decimal.test Branch: unnest2 Log Message:
fixes for without 128 ints testing diffs (78 lines): diff --git a/sql/test/BugTracker-2025/Tests/7754-overflow-in-conversion-to-decimal.test b/sql/test/BugTracker-2025/Tests/7754-overflow-in-conversion-to-decimal.test --- a/sql/test/BugTracker-2025/Tests/7754-overflow-in-conversion-to-decimal.test +++ b/sql/test/BugTracker-2025/Tests/7754-overflow-in-conversion-to-decimal.test @@ -2,9 +2,7 @@ query T nosort explain select 86399999.00000000000 / 86400000.0 ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(double(51) "86399999", double(53) "86400000") ] + [ "sys"."sql_div"(double(51) "86399999", double(53) "86400000") ] -- 0.999999988425926 query T nosort @@ -17,9 +15,7 @@ select cast(86399999.00000000000 / 86400 query T nosort explain select 86399999.0000000000 / 86400000.0 ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,11)[decimal(18,10) "863999990000000000"], decimal(9,1) "864000000") ] + [ "sys"."sql_div"(decimal(18,11)[decimal(18,10) "863999990000000000"], decimal(9,1) "864000000") ] statement error 22003!overflow in conversion to DECIMAL(18,11). @@ -30,9 +26,7 @@ select cast(86399999.0000000000 / 864000 query T nosort explain select 86399999.000000000 / 86400000.0 ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,10)[decimal(17,9) "86399999000000000"], decimal(9,1) "864000000") ] + [ "sys"."sql_div"(decimal(18,10)[decimal(17,9) "86399999000000000"], decimal(9,1) "864000000") ] query T nosort @@ -51,9 +45,7 @@ select cast(86399999.0000000000 / 864000 query T nosort explain select 86399999.0000000000 / 86400000 ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,10) "863999990000000000", int(27) "86400000") ] + [ "sys"."sql_div"(decimal(18,10) "863999990000000000", int(27) "86400000") ] -- workarounds using explicit castings query T nosort @@ -64,9 +56,7 @@ select cast(86399999.0000000000 / cast(8 query T nosort explain select 86399999.0000000000 / cast(86400000.0 as decimal(8,0)) ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,10) "863999990000000000", decimal(8) "86400000") ] + [ "sys"."sql_div"(decimal(18,10) "863999990000000000", decimal(8) "86400000") ] query T nosort select cast(cast(86399999.0000000000 as decimal(18,10)) / cast(86400000.0 as decimal(8,0)) as string) @@ -76,9 +66,7 @@ select cast(cast(86399999.0000000000 as query T nosort explain select cast(86399999.0000000000 as decimal(18,10)) / cast(86400000.0 as decimal(8,0)) ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,10) "863999990000000000", decimal(8) "86400000") ] + [ "sys"."sql_div"(decimal(18,10) "863999990000000000", decimal(8) "86400000") ] query T nosort select cast(cast(86399999.0000000000 as decimal(17,9)) / 86400000.0 as string) @@ -88,7 +76,5 @@ select cast(cast(86399999.0000000000 as query T nosort explain select cast(86399999.0000000000 as decimal(17,9)) / 86400000.0 ---- -project ( -| [ boolean(1) "true" as "%1"."%1" ] -) [ "sys"."sql_div"(decimal(18,10)[decimal(17,9)[decimal(18,10) "863999990000000000"]], decimal(9,1) "864000000") ] + [ "sys"."sql_div"(decimal(18,10)[decimal(17,9)[decimal(18,10) "863999990000000000"]], decimal(9,1) "864000000") ] _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
