Changeset: 3eeb667398b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3eeb667398b5 Removed Files: sql/test/pg_regress/Tests/int8-nohge.test Modified Files: sql/test/BugTracker-2014/Tests/All sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.test sql/test/BugTracker-2016/Tests/All sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test sql/test/BugTracker-2017/Tests/All sql/test/BugTracker-2019/Tests/All sql/test/pg_regress/Tests/All sql/test/pg_regress/Tests/int8.test testing/Mtest.py.in testing/sqllogictest.py Branch: Dec2023 Log Message:
Implemented skipif/onlyif has-hugeint and --ignore-conditions in Mtest. diffs (truncated from 920 to 300 lines): diff --git a/sql/test/BugTracker-2014/Tests/All b/sql/test/BugTracker-2014/Tests/All --- a/sql/test/BugTracker-2014/Tests/All +++ b/sql/test/BugTracker-2014/Tests/All @@ -52,7 +52,7 @@ insert_into_temp_table.Bug-3600 too_general_errmsg.Bug-3605 querylog.Bug-3607 fk-property-assert.Bug-3612 -HAVE_HGE?hexadecimal_literals.Bug-3621 +hexadecimal_literals.Bug-3621 orderby_column_exp.Bug-3620 typecast_error.Bug-3622 case-sqrt.Bug-3627 diff --git a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.test b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.test --- a/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.test +++ b/sql/test/BugTracker-2014/Tests/hexadecimal_literals.Bug-3621.test @@ -416,41 +416,76 @@ select 0x00000000000000007ffffffffffffff ---- 9223372036854775807 +onlyif has-hugeint query I rowsort select 0x8000000000000000 ---- 9223372036854775808 +skipif has-hugeint +statement error +select 0x8000000000000000 + +onlyif has-hugeint query I rowsort select 0x00000000000000008000000000000000 ---- 9223372036854775808 +skipif has-hugeint +statement error +select 0x00000000000000008000000000000000 + +onlyif has-hugeint query I rowsort select 0x8000000000000001 ---- 9223372036854775809 +skipif has-hugeint +statement error +select 0x8000000000000001 + +onlyif has-hugeint query I rowsort select 0x00000000000000008000000000000001 ---- 9223372036854775809 +skipif has-hugeint +statement error +select 0x00000000000000008000000000000001 + +onlyif has-hugeint query I rowsort select 0xffffffffffffffff ---- 18446744073709551615 +skipif has-hugeint +statement error +select 0xffffffffffffffff + +onlyif has-hugeint query I rowsort select 0x0000000000000000ffffffffffffffff ---- 18446744073709551615 +skipif has-hugeint +statement error +select 0x0000000000000000ffffffffffffffff + +onlyif has-hugeint query I rowsort select 0x7fffffffffffffffffffffffffffffff ---- 170141183460469231731687303715884105727 +skipif has-hugeint +statement error +select 0x7fffffffffffffffffffffffffffffff + statement error select 0x80000000000000000000000000000000 @@ -495,16 +530,26 @@ select 0x123456789abcdef0 ---- 1311768467463790320 +onlyif has-hugeint query I rowsort select 0x123456789abcdef01 ---- 20988295479420645121 +skipif has-hugeint +statement error +select 0x123456789abcdef01 + +onlyif has-hugeint query I rowsort select 0x123456789abcdef0123456789abcdef0 ---- 24197857203266734864793317670504947440 +skipif has-hugeint +statement error +select 0x123456789abcdef0123456789abcdef0 + statement error select 0x123456789abcdef0123456789abcdef01 @@ -926,41 +971,76 @@ select -0x00000000000000007fffffffffffff ---- -9223372036854775807 +onlyif has-hugeint query I rowsort select -0x8000000000000000 ---- -9223372036854775808 +skipif has-hugeint +statement error +select -0x8000000000000000 + +onlyif has-hugeint query I rowsort select -0x00000000000000008000000000000000 ---- -9223372036854775808 +skipif has-hugeint +statement error +select -0x00000000000000008000000000000000 + +onlyif has-hugeint query I rowsort select -0x8000000000000001 ---- -9223372036854775809 +skipif has-hugeint +statement error +select -0x8000000000000001 + +onlyif has-hugeint query I rowsort select -0x00000000000000008000000000000001 ---- -9223372036854775809 +skipif has-hugeint +statement error +select -0x00000000000000008000000000000001 + +onlyif has-hugeint query I rowsort select -0xffffffffffffffff ---- -18446744073709551615 +skipif has-hugeint +statement error +select -0xffffffffffffffff + +onlyif has-hugeint query I rowsort select -0x0000000000000000ffffffffffffffff ---- -18446744073709551615 +skipif has-hugeint +statement error +select -0x0000000000000000ffffffffffffffff + +onlyif has-hugeint query I rowsort select -0x7fffffffffffffffffffffffffffffff ---- -170141183460469231731687303715884105727 +skipif has-hugeint +statement error +select -0x7fffffffffffffffffffffffffffffff + statement error select -0x80000000000000000000000000000000 @@ -1005,16 +1085,26 @@ select -0x123456789abcdef0 ---- -1311768467463790320 +onlyif has-hugeint query I rowsort select -0x123456789abcdef01 ---- -20988295479420645121 +skipif has-hugeint +statement error +select -0x123456789abcdef01 + +onlyif has-hugeint query I rowsort select -0x123456789abcdef0123456789abcdef0 ---- -24197857203266734864793317670504947440 +skipif has-hugeint +statement error +select -0x123456789abcdef0123456789abcdef0 + statement error select -0x123456789abcdef0123456789abcdef01 diff --git a/sql/test/BugTracker-2016/Tests/All b/sql/test/BugTracker-2016/Tests/All --- a/sql/test/BugTracker-2016/Tests/All +++ b/sql/test/BugTracker-2016/Tests/All @@ -1,5 +1,5 @@ HAVE_GEOM?storagemodel -HAVE_HGE?convert-function-test.Bug-3460 +convert-function-test.Bug-3460 HAVE_HGE?convert-function-test-hge.Bug-3460 groupby_on_column_expression.Bug-3832 LEFT-JOIN_with_OR_conditions_triggers_assertion.Bug-3908 diff --git a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test --- a/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test +++ b/sql/test/BugTracker-2016/Tests/convert-function-test.Bug-3460.test @@ -98,6 +98,7 @@ 1 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, convert(v, hugeint) from T_BOOLEAN ---- @@ -321,6 +322,7 @@ 1 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, cast(v as hugeint) from T_BOOLEAN ---- @@ -956,6 +958,7 @@ 127 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, convert(v, hugeint) from T_tinyint ---- @@ -1336,6 +1339,7 @@ 127 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, cast(v as hugeint) from T_tinyint ---- @@ -1754,6 +1758,7 @@ 32767 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, convert(v, hugeint) from T_smallint ---- @@ -2212,6 +2217,7 @@ 32767 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, cast(v as hugeint) from T_smallint ---- @@ -2706,6 +2712,7 @@ 32767 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, convert(v, hugeint) from T_int ---- @@ -3238,6 +3245,7 @@ 32767 NULL NULL +onlyif has-hugeint query II rowsort SELECT v, cast(v as hugeint) from T_int ---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
