Changeset: 477932282ab6 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=477932282ab6 Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 Branch: default Log Message:
Approve output. diffs (truncated from 763 to 300 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 --- a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 @@ -61109,7 +61109,6 @@ Ready. [ 685, 229 ] [ 698, 234 ] [ 711, 239 ] -[ 723, 243 ] [ 743, 245 ] #SELECT a+b*2, # abs(a) @@ -61137,7 +61136,6 @@ Ready. [ 685, 229 ] [ 698, 234 ] [ 711, 239 ] -[ 723, 243 ] [ 743, 245 ] #SELECT (SELECT count(*) FROM t1 AS x WHERE x.b<t1.b), # a, @@ -63523,7 +63521,6 @@ Ready. [ 1360, 555, 3399, 1, 0, 226 ] [ 1391, 555, 3473, 2, 0, 233 ] [ NULL, 555, NULL, 3, 0, 238 ] -[ 1455, 222, NULL, 3, 0, NULL ] [ 1484, 444, 3706, -4, 0, 248 ] #SELECT a+b*2+c*3, # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 @@ -63557,7 +63554,6 @@ Ready. [ 1338, 444, 3331, -3, 0, 222 ] [ 1360, 555, 3399, 1, 0, 226 ] [ 1391, 555, 3473, 2, 0, 233 ] -[ 1455, 222, NULL, 3, 0, NULL ] [ 1484, 444, 3706, -4, 0, 248 ] #SELECT a+b*2+c*3, # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 @@ -63590,7 +63586,6 @@ Ready. [ 1360, 555, 3399, 1, 0, 226 ] [ 1391, 555, 3473, 2, 0, 233 ] [ NULL, 555, NULL, 3, 0, 238 ] -[ 1455, 222, NULL, 3, 0, NULL ] [ 1484, 444, 3706, -4, 0, 248 ] #SELECT a+b*2+c*3, # CASE a+1 WHEN b THEN 111 WHEN c THEN 222 @@ -63608,7 +63603,6 @@ Ready. % L1, L2, L3, L4, L6, d # name % hugeint, smallint, hugeint, bigint, wrd, int # type % 4, 3, 4, 2, 1, 3 # length -[ 1455, 222, NULL, 3, 0, NULL ] [ NULL, 555, NULL, NULL, 0, 101 ] [ 635, 333, 1612, 2, 0, 108 ] [ 966, 333, 2432, 3, 0, 164 ] @@ -65468,7 +65462,6 @@ Ready. [ 333, 3399, 229, 225 ] [ 333, 3473, 234, 231 ] [ 444, NULL, 239, NULL ] -[ 444, NULL, 243, 244 ] [ 111, 3706, 245, 247 ] #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 # WHEN a<b+3 THEN 333 ELSE 444 END, @@ -65491,7 +65484,6 @@ Ready. [ 444, NULL, 179, 176 ] [ 444, NULL, 201, 202 ] [ 444, NULL, NULL, 208 ] -[ 444, NULL, 243, 244 ] [ 333, 1612, 107, 106 ] [ 222, 1902, 127, 125 ] [ 333, 1985, 131, 134 ] @@ -65545,7 +65537,6 @@ Ready. [ 333, 3399, 229, 225 ] [ 333, 3473, 234, 231 ] [ 444, NULL, 239, NULL ] -[ 444, NULL, 243, 244 ] [ 111, 3706, 245, 247 ] #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 # WHEN a<b+3 THEN 333 ELSE 444 END, @@ -65585,7 +65576,6 @@ Ready. [ 444, NULL, 179, 176 ] [ 444, NULL, 201, 202 ] [ 444, NULL, NULL, 208 ] -[ 444, NULL, 243, 244 ] #SELECT (a+b+c+d+e)/5, # CASE WHEN c>(SELECT avg(c) FROM t1) THEN a*2 ELSE b*10 END, # CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 @@ -66278,7 +66268,6 @@ Ready. [ 2264 ] [ 2323 ] [ NULL ] -[ NULL ] [ 2476 ] #SELECT a+b*2+c*3+d*4 # FROM t1 @@ -66300,7 +66289,6 @@ Ready. [ NULL ] [ NULL ] [ NULL ] -[ NULL ] [ 1067 ] [ 1226 ] [ 1272 ] @@ -66355,7 +66343,6 @@ Ready. [ 2264 ] [ 2323 ] [ NULL ] -[ NULL ] [ 2476 ] #SELECT a+b*2+c*3+d*4 # FROM t1 @@ -66377,7 +66364,6 @@ Ready. [ NULL ] [ NULL ] [ NULL ] -[ NULL ] [ 1067 ] [ 1226 ] [ 1272 ] @@ -66432,7 +66418,6 @@ Ready. [ 2264 ] [ 2323 ] [ NULL ] -[ NULL ] [ 2476 ] #SELECT a+b*2+c*3+d*4 # FROM t1 @@ -66454,7 +66439,6 @@ Ready. [ NULL ] [ NULL ] [ NULL ] -[ NULL ] [ 1067 ] [ 1226 ] [ 1272 ] @@ -66846,7 +66830,6 @@ Ready. [ 3, 685, 227, 229 ] [ 1, 698, 232, 234 ] [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] #SELECT b-c, # a+b*2, # (a+b+c+d+e)/5, @@ -66862,7 +66845,6 @@ Ready. % bigint, bigint, hugeint, int # type % 2, 3, 3, 3 # length [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] [ -3, 544, 182, 182 ] [ -3, 635, 212, 213 ] [ -2, 514, 172, 174 ] @@ -66893,7 +66875,6 @@ Ready. [ 3, 685, 227, 229 ] [ 1, 698, 232, 234 ] [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] #SELECT b-c, # a+b*2, # (a+b+c+d+e)/5, @@ -66917,7 +66898,6 @@ Ready. [ 3, 685, 227, 229 ] [ 1, 698, 232, 234 ] [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] #SELECT b-c, # a+b*2, # (a+b+c+d+e)/5, @@ -66940,7 +66920,6 @@ Ready. [ 3, 685, 227, 229 ] [ 1, 698, 232, 234 ] [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] #SELECT b-c, # a+b*2, # (a+b+c+d+e)/5, @@ -66964,7 +66943,6 @@ Ready. [ 3, 685, 227, 229 ] [ 1, 698, 232, 234 ] [ NULL, 711, NULL, 239 ] -[ -4, 723, NULL, 243 ] #SELECT b # FROM t1 # WHERE (a>b-2 AND a<b+2) @@ -70054,7 +70032,6 @@ Ready. [ 333, -1, 3, 226, 3399, 22, 227 ] [ 333, 3, 1, 233, 3473, 23, 232 ] [ 444, 1, NULL, 238, NULL, 24, NULL ] -[ 444, NULL, -4, NULL, NULL, 25, NULL ] [ 111, 2, 2, 248, 3706, 26, 247 ] [ 444, NULL, NULL, 101, NULL, 0, NULL ] [ 333, -1, -1, 108, 1612, 0, 107 ] @@ -70079,7 +70056,6 @@ Ready. [ 444, NULL, NULL, 101, NULL, 0, NULL ] [ 444, -1, NULL, 203, NULL, 0, NULL ] [ 444, 1, NULL, 238, NULL, 24, NULL ] -[ 444, NULL, -4, NULL, NULL, 25, NULL ] [ 333, 3, -3, 183, 2728, 14, 182 ] [ 333, 2, -3, 212, 3175, 19, 212 ] [ 444, -2, -2, 171, 2579, 12, 172 ] @@ -70125,7 +70101,6 @@ Ready. [ 333, -1, 3, 226, 3399, 22, 227 ] [ 333, 3, 1, 233, 3473, 23, 232 ] [ 444, 1, NULL, 238, NULL, 24, NULL ] -[ 444, NULL, -4, NULL, NULL, 25, NULL ] [ 111, 2, 2, 248, 3706, 26, 247 ] [ 444, NULL, NULL, 101, NULL, 0, NULL ] [ 333, -1, -1, 108, 1612, 0, 107 ] @@ -70151,7 +70126,6 @@ Ready. [ 444, -1, NULL, 203, NULL, 0, NULL ] [ 444, NULL, -2, 207, NULL, 18, NULL ] [ 444, 1, NULL, 238, NULL, 24, NULL ] -[ 444, NULL, -4, NULL, NULL, 25, NULL ] [ 333, -1, -1, 108, 1612, 0, 107 ] [ 222, 2, 4, 128, 1902, 3, 127 ] [ 444, 2, -1, 164, 2432, 10, 162 ] @@ -71538,7 +71512,6 @@ Ready. [ 333, 458, 3 ] [ 333, 468, 1 ] [ 444, 2360, NULL ] -[ 444, 486, 4 ] [ 111, 490, 2 ] #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 # WHEN a<b+3 THEN 333 ELSE 444 END, @@ -71564,7 +71537,6 @@ Ready. [ 222, 440, 1 ] [ 333, 458, 3 ] [ 333, 468, 1 ] -[ 444, 486, 4 ] [ 111, 490, 2 ] [ 333, 1050, 1 ] [ 444, 1600, 1 ] @@ -72047,7 +72019,6 @@ Ready. [ 228, 3399, 229, 458, 1 ] [ 232, 3473, 234, 468, 2 ] [ 236, NULL, 239, 2360, 3 ] -[ 240, NULL, 243, 486, 3 ] [ 249, 3706, 245, 490, -4 ] [ 112, NULL, NULL, 1120, NULL ] [ 124, NULL, 121, 1240, -3 ] @@ -72060,6 +72031,7 @@ Ready. [ 158, NULL, 159, 1580, 1 ] [ 167, NULL, 168, 1670, 1 ] [ 175, NULL, 179, 358, 4 ] +[ 240, NULL, 243, 486, 3 ] #SELECT b, # a+b*2+c*3+d*4+e*5, # a, @@ -72706,7 +72678,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72745,7 +72716,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72783,7 +72753,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72822,7 +72791,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72860,7 +72828,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72899,7 +72866,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72937,7 +72903,6 @@ Ready. [ 228, 685 ] [ 232, 698 ] [ 236, 711 ] -[ 240, 723 ] [ 249, 743 ] #SELECT b, # a+b*2 @@ -72976,7 +72941,6 @@ Ready. _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
