Changeset: 3e17f2e014e2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=3e17f2e014e2 Modified Files: 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 Branch: mtest Log Message:
Converted remaining sql/test/FeatureRequests tests diffs (truncated from 558 to 300 lines): 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 --- 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 @@ -1,15 +1,43 @@ statement ok set optimizer = 'sequential_pipe' -query T rowsort +query T python .explain.function_histogram explain select count(*) from fk ---- -33 values hashing to 6eb3179306647bd4d0072241ad1d489d +user.main +2 +querylog.define +1 +sql.mvc +1 +sql.tid +1 +aggr.count +1 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id from fk order by id ---- -42 values hashing to eed7142bd8ac537c1d687e17ee3d6bc8 +user.main +2 +querylog.define +1 +bat.pack +5 +sql.mvc +1 +sql.tid +1 +sql.bind +1 +algebra.projection +2 +algebra.sort +2 +sql.resultSet +1 statement ok set optimizer = 'default_pipe' 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 --- 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 @@ -1,15 +1,43 @@ statement ok set optimizer = 'sequential_pipe' -query T rowsort +query T python .explain.function_histogram explain select count(*) from v0 ---- -33 values hashing to d26c3310403e203ec9f7f2e5900dfd62 +user.main +2 +querylog.define +1 +sql.mvc +1 +sql.tid +1 +aggr.count +1 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id from v0 order by id ---- -42 values hashing to ad366b478737e2186b1297432183bc93 +user.main +2 +querylog.define +1 +bat.pack +5 +sql.mvc +1 +sql.tid +1 +sql.bind +1 +algebra.projection +2 +algebra.sort +2 +sql.resultSet +1 statement ok set optimizer = 'default_pipe' 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 --- 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 @@ -1,25 +1,123 @@ statement ok set optimizer = 'sequential_pipe' -query T rowsort +query T python .explain.function_histogram explain select count(*) from fk left outer join pk1 on fk.fk1 = pk1.pk1 ---- -33 values hashing to 74ce1297cc1a5913f3fb22a8a8720c32 +user.main +2 +pk1.pk1 +1 +sql.mvc +1 +sql.tid +1 +aggr.count +1 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id ---- -42 values hashing to 00e9f66b6f11a684bec02ca14c36119e +user.main +2 +pk1.pk1 +1 +bat.pack +5 +sql.mvc +1 +sql.tid +1 +sql.bind +1 +algebra.projection +2 +algebra.sort +2 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id , v1 from fk left outer join pk1 on fk.fk1 = pk1.pk1 order by id ---- -63 values hashing to 6ca65f21b0a79c3f62e615903b8a01f2 +user.main +2 +pk1.pk1 +1 +bat.new +2 +sql.mvc +1 +sql.tid +2 +sql.bind_idxbat +3 +sql.delta +1 +algebra.projection +6 +algebra.join +1 +sql.bind +2 +bat.mirror +1 +algebra.difference +1 +bat.append +4 +algebra.projectionpath +1 +algebra.project +1 +bat.pack +5 +algebra.sort +2 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id , v2 from fk left outer join pk2 on fk.fk2 = pk2.pk2 order by id ---- -63 values hashing to 8713d369c52dddc32548eff26ab1be57 +user.main +2 +pk2.pk2 +1 +bat.new +2 +sql.mvc +1 +sql.tid +2 +sql.bind_idxbat +3 +sql.delta +1 +algebra.projection +6 +algebra.join +1 +sql.bind +2 +bat.mirror +1 +algebra.difference +1 +bat.append +4 +algebra.projectionpath +1 +algebra.project +1 +bat.pack +5 +algebra.sort +2 +sql.resultSet +1 statement ok set optimizer = 'default_pipe' 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 --- 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 @@ -1,20 +1,83 @@ statement ok set optimizer = 'sequential_pipe' -query T rowsort +query T python .explain.function_histogram explain select count(*) from v1 ---- -33 values hashing to 2b8c5417de37fe80bfb4c29efb2821a4 +user.main +2 +querylog.define +1 +sql.mvc +1 +sql.tid +1 +aggr.count +1 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id from v1 order by id ---- -42 values hashing to e6e593febde8f49a3c0508b264391c8b +user.main +2 +querylog.define +1 +bat.pack +5 +sql.mvc +1 +sql.tid +1 +sql.bind +1 +algebra.projection +2 +algebra.sort +2 +sql.resultSet +1 -query T rowsort +query T python .explain.function_histogram explain select id , v1 from v1 order by id ---- -63 values hashing to 095c8cbb12305fb10b4bce207a971e20 +user.main +2 +querylog.define +1 +bat.new +2 +sql.mvc +1 +sql.tid _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
