Changeset: c7a4e617f828 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/c7a4e617f828 Modified Files: sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test sql/test/mapi/Tests/sql_int128.test sql/test/miscellaneous/Tests/simple_plans.test sql/test/subquery/Tests/subquery5.test Branch: pushcands Log Message:
Approved output diffs (170 lines): diff --git a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test --- a/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test +++ b/sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test @@ -130,8 +130,8 @@ query T python .explain.function_histogr EXPLAIN select * from oblo OFFSET 2 ---- algebra.projection -2 -algebra.subslice +1 +algebra.slice 1 bat.pack 5 @@ -156,8 +156,8 @@ query T python .explain.function_histogr EXPLAIN select * from oblo LIMIT 2 ---- algebra.projection -2 -algebra.subslice +1 +algebra.slice 1 bat.pack 5 @@ -182,8 +182,8 @@ query T python .explain.function_histogr EXPLAIN select * from oblo LIMIT 1 OFFSET 2 ---- algebra.projection -2 -algebra.subslice +1 +algebra.slice 1 bat.pack 5 @@ -208,8 +208,8 @@ query T python .explain.function_histogr EXPLAIN select * from oblo LIMIT 2 OFFSET 1 ---- algebra.projection -2 -algebra.subslice +1 +algebra.slice 1 bat.pack 5 @@ -290,7 +290,7 @@ EXPLAIN select * from oblo ORDER BY a LI algebra.firstn 1 algebra.projection -4 +3 algebra.sort 1 algebra.subslice @@ -320,7 +320,7 @@ EXPLAIN select * from oblo ORDER BY a LI algebra.firstn 1 algebra.projection -4 +3 algebra.sort 1 algebra.subslice @@ -350,7 +350,7 @@ EXPLAIN select * from oblo ORDER BY a LI algebra.firstn 1 algebra.projection -4 +3 algebra.sort 1 algebra.subslice diff --git a/sql/test/mapi/Tests/sql_int128.test b/sql/test/mapi/Tests/sql_int128.test --- a/sql/test/mapi/Tests/sql_int128.test +++ b/sql/test/mapi/Tests/sql_int128.test @@ -42,8 +42,6 @@ sql.mvc 1 sql.tid 1 -sql.bind -2 sql.update 1 user.main @@ -54,8 +52,6 @@ explain UPDATE mytest SET d = c * b ---- aggr.count 1 -algebra.projection -2 querylog.define 1 sql.affectedRows @@ -66,8 +62,6 @@ sql.mvc 1 sql.tid 1 -sql.bind -2 sql.update 1 user.main @@ -78,8 +72,6 @@ explain UPDATE mytest SET e = d + a ---- aggr.count 1 -algebra.projection -2 querylog.define 1 sql.affectedRows @@ -90,27 +82,25 @@ sql.mvc 1 sql.tid 1 -sql.bind -2 sql.update 1 user.main 1 statement ok - UPDATE mytest SET a = 1234567890987654321 +UPDATE mytest SET a = 1234567890987654321 statement ok - UPDATE mytest SET b = 10000000000 +UPDATE mytest SET b = 10000000000 statement ok - UPDATE mytest SET c = a * b +UPDATE mytest SET c = a * b statement ok - UPDATE mytest SET d = c * b +UPDATE mytest SET d = c * b statement ok - UPDATE mytest SET e = d + a +UPDATE mytest SET e = d + a query IIIII rowsort SELECT a, b, c, d, e from mytest diff --git a/sql/test/miscellaneous/Tests/simple_plans.test b/sql/test/miscellaneous/Tests/simple_plans.test --- a/sql/test/miscellaneous/Tests/simple_plans.test +++ b/sql/test/miscellaneous/Tests/simple_plans.test @@ -222,7 +222,7 @@ EXPLAIN SELECT 1 FROM another_t t1 INNER algebra.project 1 algebra.projection -3 +2 algebra.rangejoin 1 bat.pack diff --git a/sql/test/subquery/Tests/subquery5.test b/sql/test/subquery/Tests/subquery5.test --- a/sql/test/subquery/Tests/subquery5.test +++ b/sql/test/subquery/Tests/subquery5.test @@ -361,7 +361,7 @@ False False False -statement error 21000!Cardinality violation, scalar value expected +statement error GDK reported error: BATsubcross: more than one match SELECT (SELECT 1 UNION SELECT 2) IN (SELECT 1) FROM integers i1 query T rowsort _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
