Changeset: fda30a6d48b5 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/fda30a6d48b5 Modified Files: sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test sql/test/SQLancer/Tests/sqlancer10.test sql/test/SQLancer/Tests/sqlancer18.test Branch: pushcands Log Message:
Approved output diffs (170 lines): diff --git a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test --- a/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test +++ b/sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.test @@ -132,25 +132,21 @@ query T python .explain.function_histogr explain select name,func from functions where contains(name, 'optimizers') ---- algebra.likeselect -2 +1 +algebra.projection +1 bat.pack 5 querylog.define 1 sql.bind 4 +sql.mvc +1 sql.projectdelta 3 -algebra.likeselect -1 -algebra.projection -1 -bat.pack -5 sql.resultSet 1 -sql.subdelta -1 sql.tid 1 user.main @@ -160,25 +156,21 @@ query T python .explain.function_histogr explain select name,func from functions where not_contains(name, 'optimizers') ---- algebra.likeselect -2 +1 +algebra.projection +1 bat.pack 5 querylog.define 1 sql.bind 4 +sql.mvc +1 sql.projectdelta 3 -algebra.likeselect -1 -algebra.projection -1 -bat.pack -5 sql.resultSet 1 -sql.subdelta -1 sql.tid 1 user.main @@ -188,25 +180,21 @@ query T python .explain.function_histogr explain select name,func from functions where icontains(name, 'optimizers') ---- algebra.likeselect -2 +1 +algebra.projection +1 bat.pack 5 querylog.define 1 sql.bind 4 +sql.mvc +1 sql.projectdelta 3 -algebra.likeselect -1 -algebra.projection -1 -bat.pack -5 sql.resultSet 1 -sql.subdelta -1 sql.tid 1 user.main @@ -216,25 +204,21 @@ query T python .explain.function_histogr explain select name,func from functions where not_icontains(name, 'optimizers') ---- algebra.likeselect -2 +1 +algebra.projection +1 bat.pack 5 querylog.define 1 sql.bind 4 +sql.mvc +1 sql.projectdelta 3 -algebra.likeselect -1 -algebra.projection -1 -bat.pack -5 sql.resultSet 1 -sql.subdelta -1 sql.tid 1 user.main diff --git a/sql/test/SQLancer/Tests/sqlancer10.test b/sql/test/SQLancer/Tests/sqlancer10.test --- a/sql/test/SQLancer/Tests/sqlancer10.test +++ b/sql/test/SQLancer/Tests/sqlancer10.test @@ -67,8 +67,6 @@ algebra.likeselect 1 algebra.project 5 -algebra.projection -1 algebra.thetaselect 2 bat.pack @@ -83,17 +81,7 @@ sql.resultSet 1 sql.tid 1 -algebra.project -5 -algebra.thetaselect -2 -bat.replace -2 -algebra.likeselect -1 -bat.pack -5 -sql.resultSet +user.main 1 statement ok diff --git a/sql/test/SQLancer/Tests/sqlancer18.test b/sql/test/SQLancer/Tests/sqlancer18.test --- a/sql/test/SQLancer/Tests/sqlancer18.test +++ b/sql/test/SQLancer/Tests/sqlancer18.test @@ -38,7 +38,7 @@ 0.071 statement ok ALTER TABLE t0 ADD COLUMN c2 UUID -statement ok +statement error GDK reported error: BATsubcross: more than one match UPDATE t2 SET c0 = 1 FROM t0 WHERE (least(TRUE, FALSE) AND 0.63 = t2.c0) OR (0.23 <= 0.1) statement ok _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
