Changeset: 05317351e0c2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=05317351e0c2 Added Files: sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.test sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-prologue.test Modified Files: testing/SQLogicConvertNotes Branch: mtest Log Message:
add tests for FeatureRequests diffs (truncated from 835 to 300 lines): diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.test @@ -0,0 +1,19 @@ +statement ok +drop view v2 + +statement ok +drop view v1 + +statement ok +drop view v0 + +statement ok +drop table fk + +statement ok +drop table pk2 + +statement ok +drop table pk1 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.test @@ -0,0 +1,14 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from fk +---- +33 values hashing to 6eb3179306647bd4d0072241ad1d489d + +query T rowsort +explain select id from fk order by id +---- +42 values hashing to eed7142bd8ac537c1d687e17ee3d6bc8 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.test @@ -0,0 +1,14 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from v0 +---- +33 values hashing to d26c3310403e203ec9f7f2e5900dfd62 + +query T rowsort +explain select id from v0 order by id +---- +42 values hashing to ad366b478737e2186b1297432183bc93 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.test @@ -0,0 +1,24 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 +---- +33 values hashing to 74ce1297cc1a5913f3fb22a8a8720c32 + +query T rowsort +explain select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id +---- +42 values hashing to 00e9f66b6f11a684bec02ca14c36119e + +query T rowsort +explain select id , v1 from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id +---- +63 values hashing to 6ca65f21b0a79c3f62e615903b8a01f2 + +query T rowsort +explain select id , v2 from fk left outer join pk2 on fk.fk2 = pk2.pk2 order by id +---- +63 values hashing to 8713d369c52dddc32548eff26ab1be57 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.test @@ -0,0 +1,19 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from v1 +---- +33 values hashing to 2b8c5417de37fe80bfb4c29efb2821a4 + +query T rowsort +explain select id from v1 order by id +---- +42 values hashing to e6e593febde8f49a3c0508b264391c8b + +query T rowsort +explain select id , v1 from v1 order by id +---- +63 values hashing to 095c8cbb12305fb10b4bce207a971e20 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.test @@ -0,0 +1,24 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 +---- +33 values hashing to a387e5e79cc2cc62ebd73b8c52a4767c + +query T rowsort +explain select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id +---- +42 values hashing to c7f0e0cd0cc3fa68b00eca8e2dc9108f + +query T rowsort +explain select id , v1 from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id +---- +63 values hashing to 67f3656d4e539a4d3ae36d08cb48e826 + +query T rowsort +explain select id , v2 from fk left outer join pk1 on fk.fk1 = pk1.pk1 left outer join pk2 on fk.fk2 = pk2.pk2 order by id +---- +82 values hashing to 7bd8e34c44320ed98ce95d605d134af4 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.test @@ -0,0 +1,19 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort +explain select count(*) from v2 +---- +33 values hashing to 9c5697a13616420740f746ca8f5d1753 + +query T rowsort +explain select id from v2 order by id +---- +42 values hashing to e6e9828574b555eede23db112b16f9a7 + +query T rowsort +explain select id , v2 from v2 order by id +---- +82 values hashing to ebe48e39bbb9d84a18461b4fd0531d94 + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.test @@ -0,0 +1,20 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort + plan select count(*) from fk +---- +) [ "%1"."%1" NOT NULL ] +project ( +| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ] +| group by ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id from fk order by id +---- +) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.test @@ -0,0 +1,24 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort + plan select count(*) from v0 +---- +) [ "%1"."%1" NOT NULL ] +project ( +| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ] +| group by ( +| | ) [ "fk"."id" NOT NULL HASHCOL as "v0"."id" ] +| | project ( +| | | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id from v0 order by id +---- +) [ "v0"."id" NOT NULL HASHCOL ] [ "v0"."id" ASC NOT NULL HASHCOL ] +project ( +| ) [ "fk"."id" NOT NULL HASHCOL as "v0"."id" ] +| project ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.test @@ -0,0 +1,148 @@ +statement ok +set optimizer = 'sequential_pipe' + +query T rowsort + plan select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 +---- +) [ "%1"."%1" NOT NULL ] +project ( +| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ] +| group by ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id , v1 from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX sys.fk.fk_fk1_fkey ] +| left outer join ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL , "fk"."%fk_fk1_fkey" NOT NULL JOINIDX sys.fk.fk_fk1_fkey ] COUNT , +| | table(sys.pk1) [ "pk1"."v1", "pk1"."%TID%" NOT NULL ] COUNT + +query T rowsort + plan select id , v2 from fk left outer join pk2 on fk.fk2 = pk2.pk2 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX sys.fk.fk_fk2_fkey ] +| left outer join ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL , "fk"."%fk_fk2_fkey" NOT NULL JOINIDX sys.fk.fk_fk2_fkey ] COUNT , +| | table(sys.pk2) [ "pk2"."v2", "pk2"."%TID%" NOT NULL ] COUNT + +query T rowsort + plan select count(*) from pk1 right outer join fk on fk.fk1 = pk1.pk1 +---- +) [ "%1"."%1" NOT NULL ] +project ( +| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ] +| group by ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id from pk1 right outer join fk on fk.fk1 = pk1.pk1 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT + +query T rowsort + plan select id , v1 from pk1 right outer join fk on fk.fk1 = pk1.pk1 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX sys.fk.fk_fk1_fkey ] +| right outer join ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL , "fk"."%fk_fk1_fkey" NOT NULL JOINIDX sys.fk.fk_fk1_fkey ] COUNT +| | table(sys.pk1) [ "pk1"."v1", "pk1"."%TID%" NOT NULL ] COUNT , + +query T rowsort + plan select id , v2 from pk2 right outer join fk on fk.fk2 = pk2.pk2 order by id +---- +) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC NOT NULL HASHCOL ] +project ( +| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX sys.fk.fk_fk2_fkey ] +| right outer join ( +| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL , "fk"."%fk_fk2_fkey" NOT NULL JOINIDX sys.fk.fk_fk2_fkey ] COUNT _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
