Changeset: 0adae9690ba4 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0adae9690ba4 Added Files: sql/test/FeatureRequests/Tests/All sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-1join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-2join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-0join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-1join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-query.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.reqtests sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-plan-2join-view.stable.out sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-prologue.sql sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-prologue.stable.err sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-prologue.stable.out Branch: default Log Message:
added tests with "desired" sample PLANs & EXPLAINs for feature request / bug 6528 The tests that are still bound to fail until the feature is actually implemented are (for now) disabled with ("unknown") conditional "FEATURE_REQUEST". diffs (truncated from 2931 to 300 lines): diff --git a/sql/test/FeatureRequests/Tests/All b/sql/test/FeatureRequests/Tests/All new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/All @@ -0,0 +1,14 @@ +foreign_key_outer_join_dead_code_elimination-prologue +foreign_key_outer_join_dead_code_elimination-plan-0join-query +foreign_key_outer_join_dead_code_elimination-plan-0join-view +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-plan-1join-query +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-plan-1join-view +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-plan-2join-query +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-plan-2join-view +foreign_key_outer_join_dead_code_elimination-explain-0join-query +foreign_key_outer_join_dead_code_elimination-explain-0join-view +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-explain-1join-query +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-explain-1join-view +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-explain-2join-query +FEATURE_REQUEST?foreign_key_outer_join_dead_code_elimination-explain-2join-view +foreign_key_outer_join_dead_code_elimination-epilogue diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.reqtests b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.reqtests @@ -0,0 +1,1 @@ +foreign_key_outer_join_dead_code_elimination-prologue diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.sql b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.sql new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.sql @@ -0,0 +1,6 @@ +drop view v2; +drop view v1; +drop view v0; +drop table fk; +drop table pk2; +drop table pk1; diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.err b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.err @@ -0,0 +1,34 @@ +stderr of test 'foreign_key_outer_join_dead_code_elimination-epilogue` in directory 'sql/test/FeatureRequests` itself: + + +# 14:51:36 > +# 14:51:36 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34071" "--set" "mapi_usock=/var/tmp/mtest-8963/.s.monetdb.34071" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/manegold/_/Monet/release/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests" +# 14:51:36 > + +# builtin opt gdk_dbpath = /ufs/manegold/_/Monet/release/prefix/_/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = no +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 34071 +# cmdline opt mapi_usock = /var/tmp/mtest-8963/.s.monetdb.34071 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /ufs/manegold/_/Monet/release/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests +# cmdline opt gdk_debug = 536870922 + +# 14:51:36 > +# 14:51:36 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-8963" "--port=34071" +# 14:51:36 > + + +# 14:51:37 > +# 14:51:37 > "Done." +# 14:51:37 > + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.out b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-epilogue.stable.out @@ -0,0 +1,39 @@ +stdout of test 'foreign_key_outer_join_dead_code_elimination-epilogue` in directory 'sql/test/FeatureRequests` itself: + + +# 01:44:33 > +# 01:44:33 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31552" "--set" "mapi_usock=/var/tmp/mtest-6324/.s.monetdb.31552" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/manegold/_/Monet/default/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests" "--set" "embedded_r=yes" "--set" "embedded_py=true" +# 01:44:33 > + +# MonetDB 5 server v11.28.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_FeatureRequests', using 4 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 31.309 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://earth.da.cwi.nl:31552/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-6324/.s.monetdb.31552 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded +# MonetDB/Python2 module loaded +# MonetDB/R module loaded + +Ready. + +# 01:44:33 > +# 01:44:33 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-6324" "--port=31552" +# 01:44:33 > + +#drop view v2; +#drop view v1; +#drop view v0; +#drop table fk; +#drop table pk2; +#drop table pk1; + +# 01:44:33 > +# 01:44:33 > "Done." +# 01:44:33 > + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.reqtests b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.reqtests new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.reqtests @@ -0,0 +1,1 @@ +foreign_key_outer_join_dead_code_elimination-prologue diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.sql @@ -0,0 +1,5 @@ +set optimizer = 'sequential_pipe'; + +explain select count(*) from fk; + +explain select id from fk order by id; diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.err b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.err new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.err @@ -0,0 +1,34 @@ +stderr of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-query` in directory 'sql/test/FeatureRequests` itself: + + +# 15:03:49 > +# 15:03:49 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=34311" "--set" "mapi_usock=/var/tmp/mtest-11457/.s.monetdb.34311" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/manegold/_/Monet/release/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests" +# 15:03:49 > + +# builtin opt gdk_dbpath = /ufs/manegold/_/Monet/release/prefix/_/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = no +# builtin opt monet_prompt = > +# builtin opt monet_daemon = no +# builtin opt mapi_port = 50000 +# builtin opt mapi_open = false +# builtin opt mapi_autosense = false +# builtin opt sql_optimizer = default_pipe +# builtin opt sql_debug = 0 +# cmdline opt gdk_nr_threads = 0 +# cmdline opt mapi_open = true +# cmdline opt mapi_port = 34311 +# cmdline opt mapi_usock = /var/tmp/mtest-11457/.s.monetdb.34311 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /ufs/manegold/_/Monet/release/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests +# cmdline opt gdk_debug = 536870922 + +# 15:03:50 > +# 15:03:50 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-11457" "--port=34311" +# 15:03:50 > + + +# 15:03:50 > +# 15:03:50 > "Done." +# 15:03:50 > + diff --git a/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out new file mode 100644 --- /dev/null +++ b/sql/test/FeatureRequests/Tests/foreign_key_outer_join_dead_code_elimination-explain-0join-query.stable.out @@ -0,0 +1,124 @@ +stdout of test 'foreign_key_outer_join_dead_code_elimination-explain-0join-query` in directory 'sql/test/FeatureRequests` itself: + + +# 01:44:33 > +# 01:44:33 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=31552" "--set" "mapi_usock=/var/tmp/mtest-6324/.s.monetdb.31552" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/manegold/_/Monet/default/prefix/_/var/MonetDB/mTests_sql_test_FeatureRequests" "--set" "embedded_r=yes" "--set" "embedded_py=true" +# 01:44:33 > + +# MonetDB 5 server v11.28.0 +# This is an unreleased version +# Serving database 'mTests_sql_test_FeatureRequests', using 4 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 31.309 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://earth.da.cwi.nl:31552/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-6324/.s.monetdb.31552 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded +# MonetDB/Python2 module loaded +# MonetDB/R module loaded + +Ready. + +# 01:44:33 > +# 01:44:33 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-6324" "--port=31552" +# 01:44:33 > + +#set optimizer = 'sequential_pipe'; + +#explain select count(*) from fk; +% .explain # table_name +% mal # name +% clob # type +% 103 # length +function user.s4_1():void; + X_1:void := querylog.define("explain select count(*) from fk;":str, "sequential_pipe":str, 12:int); + X_4:int := sql.mvc(); + C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str); + X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); + X_18:lng := aggr.count(X_8:bat[:int], C_5:bat[:oid]); + sql.resultSet("sys.L4":str, "L3":str, "bigint":str, 64:int, 0:int, 7:int, X_18:lng); +end user.s4_1; +#inline actions= 0 time=0 usec +#remap actions= 0 time=0 usec +#costmodel actions= 1 time=0 usec +#coercion actions= 0 time=1 usec +#evaluate actions= 0 time=2 usec +#emptybind actions= 1 time=4 usec +#pushselect actions= 0 time=2 usec +#aliases actions= 1 time=3 usec +#mergetable actions= 0 time=15 usec +#deadcode actions= 2 time=4 usec +#aliases actions= 0 time=0 usec +#constants actions= 0 time=2 usec +#commonTerms actions= 0 time=2 usec +#projectionpath actions= 0 time=1 usec +#reorder actions= 1 time=24 usec +#deadcode actions= 0 time=3 usec +#matpack actions= 0 time=0 usec +#multiplex actions= 0 time=1 usec +#profiler actions=1 time=1 usec +#candidates actions=1 time=1 usec +#postfix actions= 1 time=2 usec +#deadcode actions= 1 time=2 usec +#wlc actions= 0 time=0 usec +#garbagecollector actions= 1 time=18 usec +#total actions=26 time=149 usec + +#explain select id from fk order by id; +% .explain # table_name +% mal # name +% clob # type +% 114 # length +function user.s6_1():void; + X_1:void := querylog.define("explain select id from fk order by id;":str, "sequential_pipe":str, 23:int); + X_25:bat[:str] := bat.new(nil:str); + X_31:bat[:int] := bat.new(nil:int); + X_29:bat[:int] := bat.new(nil:int); + X_28:bat[:str] := bat.new(nil:str); + X_27:bat[:str] := bat.new(nil:str); + X_4:int := sql.mvc(); + C_5:bat[:oid] := sql.tid(X_4:int, "sys":str, "fk":str); + X_8:bat[:int] := sql.bind(X_4:int, "sys":str, "fk":str, "id":str, 0:int); + X_17:bat[:int] := algebra.projection(C_5:bat[:oid], X_8:bat[:int]); + (X_18:bat[:int], X_19:bat[:oid], X_20:bat[:oid]) := algebra.sort(X_17:bat[:int], false:bit, false:bit); + X_23:bat[:int] := algebra.projection(X_19:bat[:oid], X_17:bat[:int]); + X_32:bat[:str] := bat.append(X_25:bat[:str], "sys.fk":str); + X_34:bat[:str] := bat.append(X_27:bat[:str], "id":str); + X_35:bat[:str] := bat.append(X_28:bat[:str], "int":str); + X_37:bat[:int] := bat.append(X_29:bat[:int], 32:int); + X_39:bat[:int] := bat.append(X_31:bat[:int], 0:int); + sql.resultSet(X_32:bat[:str], X_34:bat[:str], X_35:bat[:str], X_37:bat[:int], X_39:bat[:int], X_23:bat[:int]); +end user.s6_1; +#inline actions= 0 time=0 usec +#remap actions= 0 time=1 usec +#costmodel actions= 1 time=1 usec +#coercion actions= 0 time=1 usec +#evaluate actions= 0 time=4 usec +#emptybind actions= 1 time=5 usec +#pushselect actions= 0 time=2 usec +#aliases actions= 1 time=4 usec +#mergetable actions= 0 time=19 usec +#deadcode actions= 2 time=5 usec +#aliases actions= 0 time=0 usec +#constants actions= 1 time=4 usec +#commonTerms actions= 0 time=2 usec +#projectionpath actions= 0 time=2 usec +#reorder actions= 1 time=16 usec +#deadcode actions= 0 time=4 usec +#matpack actions= 0 time=0 usec +#multiplex actions= 0 time=1 usec +#profiler actions=1 time=0 usec +#candidates actions=1 time=0 usec +#postfix actions= 0 time=0 usec +#deadcode actions= 0 time=4 usec +#wlc actions= 0 time=0 usec +#garbagecollector actions= 1 time=36 usec +#total actions=26 time=165 usec + +# 01:44:33 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list