Changeset: db458d5403e4 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=db458d5403e4
Modified Files:
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
Branch: mtest
Log Message:
Converted plan statements at FeatureRequests directory
diffs (truncated from 582 to 300 lines):
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
---
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
@@ -1,21 +1,21 @@
statement ok
set optimizer = 'sequential_pipe'
-query T rowsort
+query T nosort
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
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
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
+) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ]
statement ok
set optimizer = 'default_pipe'
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
---
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
@@ -1,25 +1,25 @@
statement ok
set optimizer = 'sequential_pipe'
-query T rowsort
+query T nosort
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
+| | ) [ "fk"."id" NOT NULL HASHCOL as "v0"."id" ]
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
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
+| ) [ "fk"."id" NOT NULL HASHCOL as "v0"."id" ]
+) [ "v0"."id" NOT NULL HASHCOL ] [ "v0"."id" ASC NOT NULL HASHCOL ]
statement ok
set optimizer = 'default_pipe'
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
---
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
@@ -1,149 +1,149 @@
statement ok
set optimizer = 'sequential_pipe'
-query T rowsort
+query T nosort
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
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
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
+) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ]
-query T rowsort
+query T nosort
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
+| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk1_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
-query T rowsort
+query T nosort
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
+| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk2_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
-query T rowsort
+query T nosort
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
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
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
+) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ]
-query T rowsort
+query T nosort
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.pk1) [ "pk1"."v1", "pk1"."%TID%" NOT NULL ] COUNT ,
| | 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 ,
+| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk1_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
-query T rowsort
+query T nosort
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.pk2) [ "pk2"."v2", "pk2"."%TID%" NOT NULL ] COUNT ,
| | 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 ,
+| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk2_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
-query T rowsort
+query T nosort
plan select count(*) from pk1 full 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
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
plan select id from pk1 full outer join fk on fk.fk1 = pk1.pk1 order
by id
----
-) [ "fk"."id" HASHCOL ] [ "fk"."id" ASC HASHCOL ]
project (
| table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT
+) [ "fk"."id" HASHCOL ] [ "fk"."id" ASC HASHCOL ]
-query T rowsort
+query T nosort
plan select id , v1 from pk1 full outer join fk on fk.fk1 = pk1.pk1 order
by id
----
-) [ "fk"."id" HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC HASHCOL ]
project (
-| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk1_fkey ]
| full outer join (
+| | table(sys.pk1) [ "pk1"."v1", "pk1"."%TID%" NOT NULL ] COUNT ,
| | 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 ,
+| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk1_fkey ]
+) [ "fk"."id" HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC HASHCOL ]
-query T rowsort
+query T nosort
plan select id , v2 from pk2 full outer join fk on fk.fk2 = pk2.pk2 order
by id
----
-) [ "fk"."id" HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC HASHCOL ]
project (
-| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk2_fkey ]
| full outer join (
+| | table(sys.pk2) [ "pk2"."v2", "pk2"."%TID%" NOT NULL ] COUNT ,
| | 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 ,
+| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk2_fkey ]
+) [ "fk"."id" HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC HASHCOL ]
-query T rowsort
+query T nosort
plan select count(*) from pk1 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
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
plan select id from pk1 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
+) [ "fk"."id" NOT NULL HASHCOL ] [ "fk"."id" ASC NOT NULL HASHCOL ]
-query T rowsort
+query T nosort
plan select id , v1 from pk1 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 ]
| 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
+| ) [ "fk"."%fk_fk1_fkey" NOT NULL = "pk1"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk1_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk1"."v1" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
-query T rowsort
+query T nosort
plan select id , v2 from pk2 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 ]
| 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
+| ) [ "fk"."%fk_fk2_fkey" NOT NULL = "pk2"."%TID%" NOT NULL JOINIDX
sys.fk.fk_fk2_fkey ]
+) [ "fk"."id" NOT NULL HASHCOL , "pk2"."v2" ] [ "fk"."id" ASC NOT NULL HASHCOL
]
statement ok
set optimizer = 'default_pipe'
diff --git
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
---
a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
+++
b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.test
@@ -1,35 +1,35 @@
statement ok
set optimizer = 'sequential_pipe'
-query T rowsort
+query T nosort
plan select count(*) from v1
----
-) [ "%1"."%1" NOT NULL ]
project (
-| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
| group by (
| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT
+| ) [ ] [ sys.count() NOT NULL as "%1"."%1" ]
+) [ "%1"."%1" NOT NULL ]
-query T rowsort
+query T nosort
plan select id from v1 order by id
----
-) [ "v1"."id" NOT NULL HASHCOL ] [ "v1"."id" ASC NOT NULL HASHCOL ]
project (
-| ) [ "fk"."id" NOT NULL HASHCOL as "v1"."id" ]
| project (
| | table(sys.fk) [ "fk"."id" NOT NULL HASHCOL ] COUNT
+| ) [ "fk"."id" NOT NULL HASHCOL as "v1"."id" ]
+) [ "v1"."id" NOT NULL HASHCOL ] [ "v1"."id" ASC NOT NULL HASHCOL ]
-query T rowsort
+query T nosort
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
