Changeset: f7c5885bb448 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=f7c5885bb448 Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 sql/test/SQLite_regress/sqllogictest/Tests/select4.test.stable.out.int128 Branch: default Log Message:
Approve .int128 stable outputs. In the default branch the mserver5 with int128 compiler support now produces less hugeint result columns compared to the Jul2015 version. diffs (truncated from 12512 to 300 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 --- a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out.int128 @@ -634,7 +634,7 @@ Ready. #; % sys.L1, sys.t1, sys.L2, sys.L3, sys.t1, sys.L4, sys.L5 # table_name % L1, a, L2, L3, e, L4, L5 # name -% hugeint, int, hugeint, hugeint, int, bigint, smallint # type +% bigint, int, hugeint, hugeint, int, bigint, smallint # type % 3, 3, 4, 3, 3, 2, 3 # length [ 304, 104, 1529, 102, 103, 1, 444 ] [ 317, 107, 1612, 107, 109, -2, 333 ] @@ -805,7 +805,7 @@ Ready. #; % .L1, .t1, .L3, .L4, .t1, .L5, .L6 # table_name % L1, c, L3, L4, b, L5, L6 # name -% smallint, int, wrd, bigint, int, smallint, hugeint # type +% smallint, int, wrd, bigint, int, smallint, bigint # type % 3, 3, 2, 2, 3, 3, 3 # length [ 333, 134, 6, -4, 130, 444, 391 ] [ 444, 244, 28, -4, 240, 222, 723 ] @@ -848,7 +848,7 @@ Ready. #; % sys.t1, sys.L1, sys.L2, sys.L4, sys.L5, sys.L6 # table_name % a, L1, L2, L4, L5, L6 # name -% int, hugeint, bigint, bigint, bigint, hugeint # type +% int, hugeint, bigint, bigint, bigint, bigint # type % 3, 4, 2, 4, 2, 3 # length [ 104, 1529, 1, 1000, -2, 304 ] [ 107, 1612, -2, 1050, -1, 317 ] @@ -1007,7 +1007,7 @@ Ready. #; % .L1, .L2, .L3, .t1, .L4, .L5, .L7 # table_name % L1, L2, L3, a, L4, L5, L7 # name -% hugeint, bigint, smallint, int, hugeint, hugeint, wrd # type +% hugeint, bigint, smallint, int, hugeint, bigint, wrd # type % 4, 1, 3, 3, 4, 3, 2 # length [ 674, 1, 111, 111, 1130, 335, 2 ] [ 793, 4, 444, 131, 1325, 391, 6 ] @@ -1031,7 +1031,7 @@ Ready. #; % sys.L1, sys.L2, sys.L4, sys.t1, sys.L5 # table_name % L1, L2, L4, c, L5 # name -% hugeint, hugeint, bigint, int, smallint # type +% bigint, hugeint, bigint, int, smallint # type % 3, 4, 4, 3, 3 # length [ 385, 760, 1290, 125, 222 ] [ 455, 905, 1510, 150, 333 ] @@ -1053,7 +1053,7 @@ Ready. #; % sys.L1, sys.L2, sys.t1, sys.L3, sys.L4, sys.t1, sys.L6 # table_name % L1, L2, a, L3, L4, d, L6 # name -% hugeint, smallint, int, bigint, hugeint, int, bigint # type +% hugeint, smallint, int, bigint, bigint, int, bigint # type % 4, 3, 3, 1, 3, 3, 4 # length [ 1612, 333, 107, 1, 317, 108, 1050 ] [ 1680, 222, 111, 1, 335, 114, 1120 ] @@ -1150,7 +1150,7 @@ Ready. #; % .L1, .t1, .L2, .L4, .L5 # table_name % L1, b, L2, L4, L5 # name -% smallint, int, hugeint, wrd, smallint # type +% smallint, int, bigint, wrd, smallint # type % 3, 3, 3, 2, 3 # length [ 555, 100, 304, 0, 444 ] [ 333, 105, 317, 1, 333 ] @@ -1318,7 +1318,7 @@ Ready. #; % .L1, .L2, .L3, .t1, .t1, .L5 # table_name % L1, L2, L3, a, e, L5 # name -% hugeint, hugeint, bigint, int, int, wrd # type +% hugeint, bigint, bigint, int, int, wrd # type % 3, 3, 2, 3, 3, 2 # length [ 122, 369, 1, 121, 120, 4 ] [ 127, 385, -3, 127, 126, 5 ] @@ -1377,7 +1377,7 @@ Ready. #; % sys.L1, sys.t1, sys.L2, sys.L3 # table_name % L1, a, L2, L3 # name -% bigint, int, hugeint, smallint # type +% bigint, int, bigint, smallint # type % 1, 3, 3, 3 # length [ 1, 111, 335, 222 ] [ 1, 115, 351, 222 ] @@ -1521,7 +1521,7 @@ Ready. #; % .L1, .L2, .L4, .L5 # table_name % L1, L2, L4, L5 # name -% bigint, hugeint, wrd, bigint # type +% bigint, bigint, wrd, bigint # type % 2, 3, 1, 2 # length [ -3, 579, 0, -2 ] [ -3, 351, 0, -1 ] @@ -1549,7 +1549,7 @@ Ready. #; % sys.L1 # table_name % L1 # name -% hugeint # type +% bigint # type % 3 # length [ 304 ] [ 317 ] @@ -1588,7 +1588,7 @@ Ready. #; % .L1, .L3, .L4, .t1, .L6, .L7 # table_name % L1, L3, L4, b, L6, L7 # name -% smallint, wrd, bigint, int, wrd, hugeint # type +% smallint, wrd, bigint, int, wrd, bigint # type % 3, 1, 2, 3, 2, 3 # length [ 333, 0, -1, 105, 1, 317 ] [ 111, 0, 4, 112, 2, 335 ] @@ -1734,7 +1734,7 @@ Ready. #; % sys.t1, sys.L1, sys.L2, sys.L3, sys.L4, sys.L5 # table_name % c, L1, L2, L3, L4, L5 # name -% int, smallint, int, hugeint, hugeint, bigint # type +% int, smallint, int, hugeint, bigint, bigint # type % 3, 3, 3, 3, 3, 2 # length [ 155, 333, 159, 157, 475, -1 ] [ 166, 333, 168, 167, 502, 4 ] @@ -1869,7 +1869,7 @@ Ready. #; % .L1, .L2, .L4, .L5, .L6 # table_name % L1, L2, L4, L5, L6 # name -% smallint, hugeint, wrd, hugeint, hugeint # type +% smallint, hugeint, wrd, hugeint, bigint # type % 3, 4, 2, 4, 3 # length [ 222, 1680, 2, 1130, 335 ] [ 222, 1826, 4, 1226, 369 ] @@ -1992,7 +1992,7 @@ Ready. #; % sys.t1, sys.L1, sys.t1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name % d, L1, a, b, L2, L3, L4 # name -% int, hugeint, int, int, bigint, smallint, hugeint # type +% int, bigint, int, int, bigint, smallint, hugeint # type % 3, 3, 3, 3, 2, 3, 3 # length [ 133, 391, 131, 130, -4, 444, 132 ] [ 241, 723, 243, 240, -4, 222, 242 ] @@ -2237,7 +2237,7 @@ Ready. #; % sys.L1, sys.t1, sys.L2, sys.L3, sys.L4 # table_name % L1, c, L2, L3, L4 # name -% int, int, smallint, hugeint, bigint # type +% int, int, smallint, bigint, bigint # type % 3, 3, 3, 3, 1 # length [ 220, 224, 444, 666, 1 ] [ 179, 176, 555, 529, 1 ] @@ -2330,7 +2330,7 @@ Ready. #; % sys.L1, sys.t1, sys.t1, sys.L2, sys.L3 # table_name % L1, d, a, L2, L3 # name -% hugeint, int, int, bigint, smallint # type +% bigint, int, int, bigint, smallint # type % 3, 3, 3, 2, 3 # length [ 317, 108, 107, -1, 333 ] #SELECT c-d, @@ -2724,7 +2724,7 @@ Ready. #; % .L1, .L3, .L4, .L5 # table_name % L1, L3, L4, L5 # name -% hugeint, wrd, bigint, hugeint # type +% hugeint, wrd, bigint, bigint # type % 4, 2, 2, 3 # length [ 1226, 4, 1, 369 ] [ 1272, 5, -3, 385 ] @@ -2857,7 +2857,7 @@ Ready. #; % .L1, .L2, .L4 # table_name % L1, L2, L4 # name -% smallint, hugeint, wrd # type +% smallint, bigint, wrd # type % 3, 3, 1 # length [ 444, 304, 0 ] [ 333, 317, 0 ] @@ -3028,7 +3028,7 @@ Ready. #; % sys.L1, sys.L2, sys.L3, sys.L4, sys.t1, sys.t1, sys.t1 # table_name % L1, L2, L3, L4, c, b, e # name -% hugeint, hugeint, bigint, bigint, int, int, int # type +% bigint, hugeint, bigint, bigint, int, int, int # type % 3, 4, 2, 1, 3, 3, 3 # length [ 335, 1680, -1, 1, 113, 112, 110 ] [ 369, 1826, -3, 1, 123, 124, 120 ] @@ -3104,7 +3104,7 @@ Ready. #; % .L1, .L2, .L3, .t1, .t1, .t1, .L4 # table_name % L1, L2, L3, b, a, c, L4 # name -% wrd, hugeint, bigint, int, int, int, hugeint # type +% wrd, hugeint, bigint, int, int, int, bigint # type % 1, 4, 2, 3, 3, 3, 3 # length [ 0, 635, -1, 105, 107, 106, 317 ] [ 0, 674, 4, 112, 111, 113, 335 ] @@ -3185,7 +3185,7 @@ Ready. #; % .L1, .L2, .L3, .L5, .L6, .L7, .t1 # table_name % L1, L2, L3, L5, L6, L7, d # name -% bigint, smallint, hugeint, wrd, int, bigint, int # type +% bigint, smallint, bigint, wrd, int, bigint, int # type % 2, 3, 3, 1, 3, 2, 3 # length [ 1, 333, 455, 0, 153, -4, 154 ] [ 4, 222, 385, 0, 127, -3, 128 ] @@ -3311,7 +3311,7 @@ Ready. #; % .L1, .t1, .L2, .L4, .L5, .L6, .L7 # table_name % L1, c, L2, L4, L5, L6, L7 # name -% hugeint, int, smallint, wrd, hugeint, hugeint, bigint # type +% hugeint, int, smallint, wrd, hugeint, bigint, bigint # type % 4, 3, 3, 2, 4, 3, 2 # length [ 1067, 106, 333, 1, 635, 317, -1 ] [ 1130, 113, 222, 2, 674, 335, 4 ] @@ -3357,7 +3357,7 @@ Ready. #; % .L1, .L2, .L3, .L5, .L6, .t1, .t1 # table_name % L1, L2, L3, L5, L6, d, a # name -% int, smallint, hugeint, wrd, bigint, int, int # type +% int, smallint, bigint, wrd, bigint, int, int # type % 3, 3, 3, 2, 2, 3, 3 # length [ 107, 333, 317, 1, 2, 108, 107 ] [ 153, 333, 455, 10, 2, 154, 153 ] @@ -3382,7 +3382,7 @@ Ready. #; % sys.L1, sys.L2, sys.t1, sys.L3, sys.t1 # table_name % L1, L2, b, L3, a # name -% hugeint, bigint, int, hugeint, int # type +% hugeint, bigint, int, bigint, int # type % 3, 2, 3, 3, 3 # length [ 112, -1, 112, 335, 111 ] [ 132, 1, 130, 391, 131 ] @@ -3570,7 +3570,7 @@ Ready. #; % .L1, .L2, .L4, .L5, .L6 # table_name % L1, L2, L4, L5, L6 # name -% hugeint, smallint, wrd, bigint, hugeint # type +% bigint, smallint, wrd, bigint, hugeint # type % 3, 3, 1, 2, 4 # length [ 455, 333, 0, -4, 905 ] [ 385, 222, 0, -3, 760 ] @@ -3638,7 +3638,7 @@ Ready. #; % .L1, .t1, .t1, .L2, .L3, .L5 # table_name % L1, b, d, L2, L3, L5 # name -% bigint, int, int, hugeint, hugeint, wrd # type +% bigint, int, int, hugeint, bigint, wrd # type % 1, 3, 3, 4, 3, 2 # length [ 1, 100, 101, 1529, 304, 0 ] [ 3, 118, 116, 1757, 351, 3 ] @@ -3764,7 +3764,7 @@ Ready. #; % .L1, .L2, .L4, .L6, .L7, .L10 # table_name % L1, L2, L4, L6, L7, L10 # name -% hugeint, hugeint, wrd, wrd, bigint, bigint # type +% bigint, hugeint, wrd, wrd, bigint, bigint # type % 3, 3, 1, 2, 1, 2 # length [ 351, 117, 0, 3, 1, -3 ] [ 369, 122, 0, 4, 1, -3 ] @@ -3831,7 +3831,7 @@ Ready. #; % .L1, .L2, .L3, .L4 # table_name % L1, L2, L3, L4 # name -% hugeint, hugeint, bigint, hugeint # type +% hugeint, bigint, bigint, hugeint # type % 4, 3, 2, 4 # length [ 610, 304, 4, 1529 ] [ 635, 317, 2, 1612 ] @@ -3873,7 +3873,7 @@ Ready. #; % .L1, .L2, .L4 # table_name % L1, L2, L4 # name -% hugeint, hugeint, wrd # type +% hugeint, bigint, wrd # type % 3, 3, 1 # length [ 102, 304, 0 ] [ 107, 317, 0 ] @@ -4023,7 +4023,7 @@ Ready. #; % .L1, .L2, .L3, .t1, .L4, .L5, .L7 # table_name % L1, L2, L3, a, L4, L5, L7 # name -% bigint, smallint, hugeint, int, bigint, hugeint, wrd # type +% bigint, smallint, bigint, int, bigint, hugeint, wrd # type % 2, 3, 3, 3, 1, 4, 1 # length [ 1, 444, 304, 104, 2, 1529, 0 ] [ -2, 333, 317, 107, 1, 1612, 0 ] @@ -4109,7 +4109,7 @@ Ready. #; % .L1, .L2, .t1, .L4, .L5, .L6 # table_name % L1, L2, a, L4, L5, L6 # name -% bigint, hugeint, int, wrd, bigint, smallint # type +% bigint, bigint, int, wrd, bigint, smallint # type % 2, 3, 3, 2, 2, 3 # length [ -1, 666, 220, 24, 2, 222 ] [ 1, 579, 191, 18, 3, 222 ] @@ -4199,7 +4199,7 @@ Ready. #; % .L1, .L2, .t1, .L3, .L4, .L6, .L7 # table_name % L1, L2, b, L3, L4, L6, L7 # name -% hugeint, hugeint, int, bigint, bigint, wrd, smallint # type +% bigint, hugeint, int, bigint, bigint, wrd, smallint # type % 3, 4, 3, 2, 1, 1, 3 # length [ 317, 1612, 105, -2, 1, 0, 333 ] [ 335, 1680, 112, -1, 1, 0, 222 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
