Changeset: df6911de608a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=df6911de608a Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select2.test.stable.out Branch: default Log Message:
Approve non-int128 outputs (only result header table_name changes) diffs (truncated from 12639 to 300 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out --- a/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select1.test.stable.out @@ -163,8 +163,8 @@ stdout of test 'select1.test` in directo # FROM t1 # ORDER BY 1,2 #; -% sys.L1, sys.L2 # table_name -% L1, L2 # name +% sys.L2, sys.L4 # table_name +% L2, L4 # name % bigint, bigint # type % 4, 3 # length [ 1529, 102 ] @@ -209,8 +209,8 @@ stdout of test 'select1.test` in directo # AND EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) # ORDER BY 4,2,1,3,5 #; -% sys.L2, sys.L3, sys.L4, sys.L5, sys.L6 # table_name -% L2, L3, L4, L5, L6 # name +% sys.L4, sys.L6, sys.L10, sys.L12, sys.L14 # table_name +% L4, L6, L10, L12, L14 # name % bigint, smallint, bigint, bigint, bigint # type % 4, 3, 1, 3, 4 # length [ 1680, 222, 1, 112, 674 ] @@ -241,8 +241,8 @@ stdout of test 'select1.test` in directo # OR (e>c OR e<d) # ORDER BY 1,5,3,2,4 #; -% sys.t1, sys.L1, sys.L2, sys.L3, sys.t1 # table_name -% c, L1, L2, L3, e # name +% sys.t1, sys.L3, sys.L5, sys.L7, sys.t1 # table_name +% c, L3, L5, L7, e # name % int, bigint, smallint, bigint, int # type % 3, 2, 3, 4, 3 # length [ 102, -2, 555, 1014, 103 ] @@ -286,8 +286,8 @@ stdout of test 'select1.test` in directo # AND c>d # ORDER BY 3,4,5,1,2,6 #; -% sys.L1, sys.L2, sys.L3, sys.t1, sys.L4, sys.t1 # table_name -% L1, L2, L3, e, L4, d # name +% sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.t1 # table_name +% L2, L4, L6, e, L11, d # name % bigint, bigint, int, int, smallint, int # type % 4, 3, 3, 3, 3, 3 # length [ 1226, 122, 121, 120, 333, 122 ] @@ -303,8 +303,8 @@ stdout of test 'select1.test` in directo # WHERE (c<=d-2 OR c>=d+2) # ORDER BY 4,2,1,3 #; -% .L1, .L2, .L4, .t1 # table_name -% L1, L2, L3, c # name +% sys.L2, sys.L4, .L10, sys.t1 # table_name +% L2, L4, L10, c # name % bigint, smallint, bigint, int # type % 4, 3, 1, 3 # length [ 1067, 333, 0, 106 ] @@ -451,8 +451,8 @@ stdout of test 'select1.test` in directo # OR d NOT BETWEEN 110 AND 150 # ORDER BY 4,1,5,2,6,3,7 #; -% .L2, .L3, .L4, .L5, .t1, .L10, .L11 # table_name -% L2, L3, L4, L5, c, L10, L11 # name +% .L16, .L20, .L22, .L24, .t1, .L33, .L35 # table_name +% L16, L20, L22, L24, c, L33, L35 # name % smallint, smallint, bigint, bigint, int, bigint, bigint # type % 3, 3, 4, 4, 3, 4, 1 # length [ 555, 444, 1014, 610, 102, 1000, 2 ] @@ -498,8 +498,8 @@ stdout of test 'select1.test` in directo # OR d NOT BETWEEN 110 AND 150 # ORDER BY 5,3,6,1,2,4 #; -% .L4, .L5, .L6, .L10, .t1, .L11 # table_name -% L4, L5, L6, L7, c, L11 # name +% .L22, .L24, .L26, .L32, .t1, .L35 # table_name +% L22, L24, L26, L32, c, L35 # name % bigint, smallint, bigint, bigint, int, bigint # type % 4, 3, 4, 1, 3, 2 # length [ 1000, 444, 610, 0, 102, -2 ] @@ -542,8 +542,8 @@ stdout of test 'select1.test` in directo # OR c>d # ORDER BY 3,5,4,1,2 #; -% .L2, .t1, .L3, .L4, .L6 # table_name -% L1, d, L3, L4, L5 # name +% .L4, sys.t1, sys.L7, sys.L11, .L15 # table_name +% L4, d, L7, L11, L15 # name % bigint, int, bigint, bigint, bigint # type % 1, 3, 4, 2, 2 # length [ 0, 101, 1014, 4, 0 ] @@ -581,8 +581,8 @@ stdout of test 'select1.test` in directo # FROM t1 # ORDER BY 4,3,6,2,5,1 #; -% sys.L3, sys.L4, sys.L5, sys.t1, sys.L6, sys.L7 # table_name -% L3, L4, L5, c, L6, L7 # name +% sys.L6, sys.L10, sys.L12, sys.t1, sys.L15, sys.L17 # table_name +% L6, L10, L12, c, L15, L17 # name % bigint, bigint, bigint, int, smallint, bigint # type % 4, 2, 1, 3, 3, 4 # length [ 1000, 4, 2, 102, 444, 1014 ] @@ -627,8 +627,8 @@ stdout of test 'select1.test` in directo # WHERE a>b # ORDER BY 5,4,6,2,1,7,3 #; -% sys.L1, sys.t1, sys.L2, sys.L3, sys.t1, sys.L4, sys.L5 # table_name -% L1, a, L2, L3, e, L4, L5 # name +% sys.L2, sys.t1, sys.L5, sys.L7, sys.t1, sys.L12, sys.L14 # table_name +% L2, a, L5, L7, e, L12, L14 # name % bigint, int, bigint, bigint, int, bigint, smallint # type % 3, 3, 4, 3, 3, 2, 3 # length [ 304, 104, 1529, 102, 103, 1, 444 ] @@ -735,8 +735,8 @@ stdout of test 'select1.test` in directo # AND d NOT BETWEEN 110 AND 150 # ORDER BY 2,1,6,4,3,5 #; -% sys.L3, sys.L4, sys.L5, sys.L6, sys.L7, sys.L10 # table_name -% L3, L4, L5, L6, L7, L10 # name +% sys.L6, sys.L10, sys.L12, sys.L14, sys.L16, sys.L20 # table_name +% L6, L10, L12, L14, L16, L20 # name % bigint, bigint, bigint, bigint, smallint, bigint # type % 4, 4, 1, 1, 3, 1 # length [ 1510, 2281, 1, 1, 333, 2 ] @@ -758,8 +758,8 @@ stdout of test 'select1.test` in directo # OR e+d BETWEEN a+b-10 AND c+130 # ORDER BY 1,5,4,2,6,3 #; -% sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.t1 # table_name -% L1, L2, L3, L4, L5, a # name +% sys.L2, sys.L4, sys.L6, sys.L10, sys.L12, sys.t1 # table_name +% L2, L4, L6, L10, L12, a # name % bigint, int, bigint, bigint, smallint, int # type % 4, 3, 2, 2, 3, 3 # length [ 1529, 104, -2, 1, 555, 104 ] @@ -841,8 +841,8 @@ stdout of test 'select1.test` in directo # FROM t1 # ORDER BY 6,2,4,5,3,1 #; -% sys.t1, sys.L1, sys.L2, sys.L5, sys.L6, sys.L7 # table_name -% a, L1, L2, L5, L6, L7 # name +% sys.t1, sys.L3, sys.L5, sys.L13, sys.L15, sys.L17 # table_name +% a, L3, L5, L13, L15, L17 # name % int, bigint, bigint, bigint, bigint, bigint # type % 3, 4, 2, 4, 2, 3 # length [ 104, 1529, 1, 1000, -2, 304 ] @@ -889,8 +889,8 @@ stdout of test 'select1.test` in directo # AND c>d # ORDER BY 1,3,7,5,2,6,4 #; -% sys.L1, sys.L2, sys.t1, sys.L3, sys.L4, sys.L5, sys.L6 # table_name -% L1, L2, b, L3, L4, L5, L6 # name +% sys.L2, sys.L4, sys.t1, sys.L7, sys.L11, sys.L13, sys.L15 # table_name +% L2, L4, b, L7, L11, L13, L15 # name % bigint, int, int, bigint, bigint, bigint, smallint # type % 1, 3, 3, 1, 4, 1, 3 # length [ 1, 131, 130, 1, 793, 4, 333 ] @@ -911,8 +911,8 @@ stdout of test 'select1.test` in directo # WHERE d NOT BETWEEN 110 AND 150 # ORDER BY 2,5,1,7,3,6,4 #; -% sys.L1, sys.L2, sys.L3, sys.L4, sys.L5, sys.L6, sys.t1 # table_name -% L1, L2, L3, L4, L5, L6, c # name +% sys.L2, sys.L4, sys.L6, sys.L10, sys.L12, sys.L14, sys.t1 # table_name +% L2, L4, L6, L10, L12, L14, c # name % smallint, bigint, bigint, bigint, bigint, bigint, int # type % 3, 4, 4, 3, 4, 2, 3 # length [ 444, 610, 1529, 102, 1014, -2, 102 ] @@ -1000,8 +1000,8 @@ stdout of test 'select1.test` in directo # AND c BETWEEN b-2 AND d+2 # ORDER BY 6,1,7,3,4,5,2 #; -% .L1, .L2, .L3, .t1, .L4, .L5, .L7 # table_name -% L1, L2, L3, a, L4, L5, L6 # name +% sys.L2, sys.L4, sys.L6, sys.t1, sys.L11, sys.L13, .L17 # table_name +% L2, L4, L6, a, L11, L13, L17 # name % bigint, bigint, smallint, int, bigint, bigint, bigint # type % 4, 1, 3, 3, 4, 3, 2 # length [ 674, 1, 111, 111, 1130, 335, 2 ] @@ -1024,8 +1024,8 @@ stdout of test 'select1.test` in directo # AND b>c # ORDER BY 2,3,1,5,4 #; -% sys.L1, sys.L2, sys.L5, sys.t1, sys.L6 # table_name -% L1, L2, L5, c, L6 # name +% sys.L2, sys.L4, sys.L12, sys.t1, sys.L15 # table_name +% L2, L4, L12, c, L15 # name % bigint, bigint, bigint, int, smallint # type % 3, 4, 4, 3, 3 # length [ 385, 760, 1290, 125, 222 ] @@ -1046,8 +1046,8 @@ stdout of test 'select1.test` in directo # OR a>b # ORDER BY 4,5,3,7,1,6,2 #; -% sys.L1, sys.L2, sys.t1, sys.L3, sys.L4, sys.t1, sys.L7 # table_name -% L1, L2, a, L3, L4, d, L7 # name +% sys.L2, sys.L4, sys.t1, sys.L7, sys.L11, sys.t1, sys.L20 # table_name +% L2, L4, a, L7, L11, d, L20 # name % bigint, smallint, int, bigint, bigint, int, bigint # type % 4, 3, 3, 1, 3, 3, 4 # length [ 1612, 333, 107, 1, 317, 108, 1050 ] @@ -1184,8 +1184,8 @@ stdout of test 'select1.test` in directo # FROM t1 # ORDER BY 3,4,2,6,5,1 #; -% sys.t1, sys.L1, sys.L2, sys.L3, sys.L4, sys.L5 # table_name -% d, L1, L2, L3, L4, L5 # name +% sys.t1, sys.L3, sys.L5, sys.L7, sys.L11, sys.L13 # table_name +% d, L3, L5, L7, L11, L13 # name % int, bigint, bigint, bigint, bigint, bigint # type % 3, 4, 4, 2, 3, 2 # length [ 101, 1529, 610, 1, 102, 4 ] @@ -1230,8 +1230,8 @@ stdout of test 'select1.test` in directo # WHERE c BETWEEN b-2 AND d+2 # ORDER BY 7,2,5,1,3,6,4 #; -% .L1, .L2, .L3, .L4, .L5, .L7, .L10 # table_name -% L1, L2, L3, L4, L5, L6, L10 # name +% sys.L2, sys.L4, sys.L6, sys.L10, sys.L12, .L16, sys.L20 # table_name +% L2, L4, L6, L10, L12, L16, L20 # name % smallint, bigint, bigint, bigint, int, bigint, bigint # type % 3, 4, 3, 1, 3, 1, 4 # length [ 555, 1529, 102, 2, 104, 0, 610 ] @@ -1293,8 +1293,8 @@ stdout of test 'select1.test` in directo # WHERE (e>a AND e<b) # ORDER BY 2,6,4,1,5,3 #; -% sys.L1, sys.t1, sys.L2, sys.t1, sys.t1, sys.L3 # table_name -% L1, a, L2, b, d, L3 # name +% sys.L2, sys.t1, sys.L5, sys.t1, sys.t1, sys.L11 # table_name +% L2, a, L5, b, d, L11 # name % bigint, int, bigint, int, int, bigint # type % 2, 3, 4, 3, 3, 2 # length [ -3, 115, 708, 118, 116, -1 ] @@ -1311,8 +1311,8 @@ stdout of test 'select1.test` in directo # WHERE b>c # ORDER BY 2,6,5,4,3,1 #; -% .L1, .L2, .L3, .t1, .t1, .L5 # table_name -% L1, L2, L3, a, e, L4 # name +% sys.L2, sys.L4, sys.L6, sys.t1, sys.t1, .L14 # table_name +% L2, L4, L6, a, e, L14 # name % bigint, bigint, bigint, int, int, bigint # type % 3, 3, 2, 3, 3, 2 # length [ 122, 369, 1, 121, 120, 4 ] @@ -1339,8 +1339,8 @@ stdout of test 'select1.test` in directo # WHERE a>b # ORDER BY 2,5,3,4,1 #; -% sys.t1, sys.L1, sys.L2, sys.L3, sys.L4 # table_name -% b, L1, L2, L3, L4 # name +% sys.t1, sys.L3, sys.L5, sys.L7, sys.L11 # table_name +% b, L3, L5, L7, L11 # name % int, bigint, smallint, bigint, bigint # type % 3, 3, 3, 1, 2 # length [ 100, 102, 555, 2, -2 ] @@ -1471,8 +1471,8 @@ stdout of test 'select1.test` in directo # OR EXISTS(SELECT 1 FROM t1 AS x WHERE x.b<t1.b) # ORDER BY 3,1,2 #; -% .L2, .t1, .L4 # table_name -% L2, e, L3 # name +% .L11, .t1, .L16 # table_name +% L11, e, L16 # name % bigint, int, bigint # type % 3, 3, 1 # length [ 102, 103, 0 ] @@ -1637,8 +1637,8 @@ stdout of test 'select1.test` in directo # FROM t1 # ORDER BY 5,4,1,3,2 #; -% sys.L1, sys.L2, sys.t1, sys.L3, sys.t1 # table_name -% L1, L2, c, L3, b # name +% sys.L2, sys.L4, sys.t1, sys.L7, sys.t1 # table_name +% L2, L4, c, L7, b # name % bigint, bigint, int, bigint, int # type % 4, 4, 3, 3, 3 # length [ 610, 1529, 102, 102, 100 ] @@ -1727,8 +1727,8 @@ stdout of test 'select1.test` in directo # AND d NOT BETWEEN 110 AND 150 # ORDER BY 4,5,3,1,2,6 #; -% sys.t1, sys.L1, sys.L2, sys.L3, sys.L4, sys.L5 # table_name -% c, L1, L2, L3, L4, L5 # name +% sys.t1, sys.L3, sys.L5, sys.L7, sys.L11, sys.L13 # table_name +% c, L3, L5, L7, L11, L13 # name % int, smallint, int, bigint, bigint, bigint # type % 3, 3, 3, 3, 3, 2 # length [ 155, 333, 159, 157, 475, -1 ] @@ -1745,8 +1745,8 @@ stdout of test 'select1.test` in directo # OR (a>b-2 AND a<b+2) # ORDER BY 3,2,4,1 #; -% sys.L1, sys.L4, sys.L5, sys.t1 # table_name -% L1, L4, L5, d # name +% sys.L2, sys.L10, sys.L12, sys.t1 # table_name +% L2, L10, L12, d # name % smallint, bigint, bigint, int # type % 3, 4, 4, 3 # length [ 111, 1120, 1680, 114 ] _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
