Changeset: 9ba001aa2723 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9ba001aa2723 Modified Files: sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out.int128 Branch: Dec2016 Log Message:
Approve output diffs (97 lines): diff --git a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out --- a/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out +++ b/sql/test/SQLite_regress/sqllogictest/Tests/select3.test.stable.out @@ -47459,7 +47459,7 @@ Ready. [ NULL, 155, NULL, 0, 3 ] [ NULL, 166, NULL, 0, 1 ] [ NULL, 176, NULL, 0, -1 ] -[ NULL, 244, NULL, 0, -4 ] +[ NULL, 102, 101, 0, NULL ] [ 107, 106, 108, 0, -1 ] [ 127, 125, 128, 0, 4 ] [ 132, 134, 133, 0, -4 ] @@ -58997,9 +58997,9 @@ Ready. [ 2, 140, 0, 111 ] [ -3, 183, 0, 333 ] [ -4, 133, 0, 444 ] +[ 1, NULL, 0, 555 ] +[ 3, NULL, 0, 555 ] [ 3, 226, 0, 555 ] -[ 3, NULL, 0, 555 ] -[ 1, NULL, 0, 555 ] [ 3, 196, 0, 555 ] #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 # WHEN a<b+3 THEN 333 ELSE 444 END, 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 @@ -5440,8 +5440,8 @@ Ready. % L2, L7, L13, L15, L25 # name % hugeint, bigint, bigint, bigint, bigint # type % 4, 1, 1, 2, 4 # length +[ NULL, 0, 2, 1, NULL ] [ NULL, 0, NULL, 1, NULL ] -[ NULL, 0, 2, 1, NULL ] [ 1828, 0, 3, 1, 364 ] [ 1861, 0, 1, 2, 376 ] [ 1918, 0, 1, 3, 382 ] @@ -43848,8 +43848,8 @@ Ready. % L2, L7, L13, L15, L17 # name % hugeint, bigint, bigint, smallint, bigint # type % 3, 1, 1, 3, 2 # length +[ NULL, 0, NULL, 222, NULL ] [ NULL, 0, NULL, 555, NULL ] -[ NULL, 0, NULL, 222, NULL ] [ NULL, 0, NULL, 555, NULL ] [ NULL, 0, NULL, 333, NULL ] [ NULL, 0, 1, 555, -1 ] @@ -47449,7 +47449,7 @@ Ready. % L17, c, d, L26, L32 # name % hugeint, int, int, bigint, bigint # type % 3, 3, 3, 1, 2 # length -[ NULL, 102, 101, 0, NULL ] +[ NULL, 244, NULL, 0, -4 ] [ NULL, 202, 203, 0, NULL ] [ NULL, 208, 207, 0, -2 ] [ NULL, NULL, 238, 0, NULL ] @@ -47460,7 +47460,7 @@ Ready. [ NULL, 155, NULL, 0, 3 ] [ NULL, 166, NULL, 0, 1 ] [ NULL, 176, NULL, 0, -1 ] -[ NULL, 244, NULL, 0, -4 ] +[ NULL, 102, 101, 0, NULL ] [ 107, 106, 108, 0, -1 ] [ 127, 125, 128, 0, 4 ] [ 132, 134, 133, 0, -4 ] @@ -58998,9 +58998,9 @@ Ready. [ 2, 140, 0, 111 ] [ -3, 183, 0, 333 ] [ -4, 133, 0, 444 ] +[ 1, NULL, 0, 555 ] +[ 3, NULL, 0, 555 ] [ 3, 226, 0, 555 ] -[ 3, NULL, 0, 555 ] -[ 1, NULL, 0, 555 ] [ 3, 196, 0, 555 ] #SELECT CASE WHEN a<b-3 THEN 111 WHEN a<=b THEN 222 # WHEN a<b+3 THEN 333 ELSE 444 END, @@ -62780,8 +62780,8 @@ Ready. % L12, L14, L21, a, L26, L30 # name % hugeint, int, bigint, int, bigint, bigint # type % 3, 3, 1, 3, 2, 3 # length +[ NULL, NULL, 0, NULL, 1, NULL ] [ NULL, NULL, 0, NULL, -1, NULL ] -[ NULL, NULL, 0, NULL, 1, NULL ] [ NULL, 121, 0, 121, 1, 369 ] [ 127, 127, 0, 127, -3, 385 ] [ 132, 131, 0, 131, 1, 391 ] @@ -70368,8 +70368,8 @@ Ready. % L2, L4, L11, L15, L17 # name % smallint, bigint, bigint, hugeint, hugeint # type % 3, 1, 1, 4, 4 # length +[ 111, 2, 0, 1371, 2046 ] [ 111, 2, 0, 1411, 2131 ] -[ 111, 2, 0, 1371, 2046 ] [ 333, 3, 0, 1828, 2728 ] [ 444, 4, 0, 1325, 1985 ] #SELECT CASE a+1 WHEN b THEN 111 WHEN c THEN 222 _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
