Changeset: 5e6d463f5865 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=5e6d463f5865 Added Files: sql/benchmarks/ssbm/Tests/01-explain.SQL.py.src sql/benchmarks/ssbm/Tests/01-explain.reqtests sql/benchmarks/ssbm/Tests/01-explain.stable.err sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/01-plan.SQL.py.src sql/benchmarks/ssbm/Tests/01-plan.reqtests sql/benchmarks/ssbm/Tests/01-plan.stable.err sql/benchmarks/ssbm/Tests/01-plan.stable.out sql/benchmarks/ssbm/Tests/02-explain.SQL.py.src sql/benchmarks/ssbm/Tests/02-explain.reqtests sql/benchmarks/ssbm/Tests/02-explain.stable.err sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/02-plan.SQL.py.src sql/benchmarks/ssbm/Tests/02-plan.reqtests sql/benchmarks/ssbm/Tests/02-plan.stable.err sql/benchmarks/ssbm/Tests/02-plan.stable.out sql/benchmarks/ssbm/Tests/03-explain.SQL.py.src sql/benchmarks/ssbm/Tests/03-explain.reqtests sql/benchmarks/ssbm/Tests/03-explain.stable.err sql/benchmarks/ssbm/Tests/03-explain.stable.out sql/benchmarks/ssbm/Tests/03-plan.SQL.py.src sql/benchmarks/ssbm/Tests/03-plan.reqtests sql/benchmarks/ssbm/Tests/03-plan.stable.err sql/benchmarks/ssbm/Tests/03-plan.stable.out sql/benchmarks/ssbm/Tests/04-explain.SQL.py.src sql/benchmarks/ssbm/Tests/04-explain.reqtests sql/benchmarks/ssbm/Tests/04-explain.stable.err sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/04-plan.SQL.py.src sql/benchmarks/ssbm/Tests/04-plan.reqtests sql/benchmarks/ssbm/Tests/04-plan.stable.err sql/benchmarks/ssbm/Tests/04-plan.stable.out sql/benchmarks/ssbm/Tests/05-explain.SQL.py.src sql/benchmarks/ssbm/Tests/05-explain.reqtests sql/benchmarks/ssbm/Tests/05-explain.stable.err sql/benchmarks/ssbm/Tests/05-explain.stable.out sql/benchmarks/ssbm/Tests/05-plan.SQL.py.src sql/benchmarks/ssbm/Tests/05-plan.reqtests sql/benchmarks/ssbm/Tests/05-plan.stable.err sql/benchmarks/ssbm/Tests/05-plan.stable.out sql/benchmarks/ssbm/Tests/06-explain.SQL.py.src sql/benchmarks/ssbm/Tests/06-explain.reqtests sql/benchmarks/ssbm/Tests/06-explain.stable.err sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/06-plan.SQL.py.src sql/benchmarks/ssbm/Tests/06-plan.reqtests sql/benchmarks/ssbm/Tests/06-plan.stable.err sql/benchmarks/ssbm/Tests/06-plan.stable.out sql/benchmarks/ssbm/Tests/07-explain.SQL.py.src sql/benchmarks/ssbm/Tests/07-explain.reqtests sql/benchmarks/ssbm/Tests/07-explain.stable.err sql/benchmarks/ssbm/Tests/07-explain.stable.out sql/benchmarks/ssbm/Tests/07-plan.SQL.py.src sql/benchmarks/ssbm/Tests/07-plan.reqtests sql/benchmarks/ssbm/Tests/07-plan.stable.err sql/benchmarks/ssbm/Tests/07-plan.stable.out sql/benchmarks/ssbm/Tests/08-explain.SQL.py.src sql/benchmarks/ssbm/Tests/08-explain.reqtests sql/benchmarks/ssbm/Tests/08-explain.stable.err sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/08-plan.SQL.py.src sql/benchmarks/ssbm/Tests/08-plan.reqtests sql/benchmarks/ssbm/Tests/08-plan.stable.err sql/benchmarks/ssbm/Tests/08-plan.stable.out sql/benchmarks/ssbm/Tests/09-explain.SQL.py.src sql/benchmarks/ssbm/Tests/09-explain.reqtests sql/benchmarks/ssbm/Tests/09-explain.stable.err sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/09-plan.SQL.py.src sql/benchmarks/ssbm/Tests/09-plan.reqtests sql/benchmarks/ssbm/Tests/09-plan.stable.err sql/benchmarks/ssbm/Tests/09-plan.stable.out sql/benchmarks/ssbm/Tests/10-explain.SQL.py.src sql/benchmarks/ssbm/Tests/10-explain.reqtests sql/benchmarks/ssbm/Tests/10-explain.stable.err sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/10-plan.SQL.py.src sql/benchmarks/ssbm/Tests/10-plan.reqtests sql/benchmarks/ssbm/Tests/10-plan.stable.err sql/benchmarks/ssbm/Tests/10-plan.stable.out sql/benchmarks/ssbm/Tests/11-explain.SQL.py.src sql/benchmarks/ssbm/Tests/11-explain.reqtests sql/benchmarks/ssbm/Tests/11-explain.stable.err sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/11-plan.SQL.py.src sql/benchmarks/ssbm/Tests/11-plan.reqtests sql/benchmarks/ssbm/Tests/11-plan.stable.err sql/benchmarks/ssbm/Tests/11-plan.stable.out sql/benchmarks/ssbm/Tests/12-explain.SQL.py.src sql/benchmarks/ssbm/Tests/12-explain.reqtests sql/benchmarks/ssbm/Tests/12-explain.stable.err sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/12-plan.SQL.py.src sql/benchmarks/ssbm/Tests/12-plan.reqtests sql/benchmarks/ssbm/Tests/12-plan.stable.err sql/benchmarks/ssbm/Tests/12-plan.stable.out sql/benchmarks/ssbm/Tests/13-explain.SQL.py.src sql/benchmarks/ssbm/Tests/13-explain.reqtests sql/benchmarks/ssbm/Tests/13-explain.stable.err sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/ssbm/Tests/13-plan.SQL.py.src sql/benchmarks/ssbm/Tests/13-plan.reqtests sql/benchmarks/ssbm/Tests/13-plan.stable.err sql/benchmarks/ssbm/Tests/13-plan.stable.out sql/benchmarks/ssbm/Tests/explain.SQL.py sql/benchmarks/ssbm/Tests/plan.SQL.py sql/benchmarks/tpch/Tests/01-explain.SQL.py.src sql/benchmarks/tpch/Tests/01-explain.reqtests sql/benchmarks/tpch/Tests/01-explain.stable.err sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-plan.SQL.py.src sql/benchmarks/tpch/Tests/01-plan.reqtests sql/benchmarks/tpch/Tests/01-plan.stable.err sql/benchmarks/tpch/Tests/01-plan.stable.out sql/benchmarks/tpch/Tests/02-explain.SQL.py.src sql/benchmarks/tpch/Tests/02-explain.reqtests sql/benchmarks/tpch/Tests/02-explain.stable.err sql/benchmarks/tpch/Tests/02-explain.stable.out sql/benchmarks/tpch/Tests/02-plan.SQL.py.src sql/benchmarks/tpch/Tests/02-plan.reqtests sql/benchmarks/tpch/Tests/02-plan.stable.err sql/benchmarks/tpch/Tests/02-plan.stable.out sql/benchmarks/tpch/Tests/03-explain.SQL.py.src sql/benchmarks/tpch/Tests/03-explain.reqtests sql/benchmarks/tpch/Tests/03-explain.stable.err sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/03-plan.SQL.py.src sql/benchmarks/tpch/Tests/03-plan.reqtests sql/benchmarks/tpch/Tests/03-plan.stable.err sql/benchmarks/tpch/Tests/03-plan.stable.out sql/benchmarks/tpch/Tests/04-explain.SQL.py.src sql/benchmarks/tpch/Tests/04-explain.reqtests sql/benchmarks/tpch/Tests/04-explain.stable.err sql/benchmarks/tpch/Tests/04-explain.stable.out sql/benchmarks/tpch/Tests/04-plan.SQL.py.src sql/benchmarks/tpch/Tests/04-plan.reqtests sql/benchmarks/tpch/Tests/04-plan.stable.err sql/benchmarks/tpch/Tests/04-plan.stable.out sql/benchmarks/tpch/Tests/05-explain.SQL.py.src sql/benchmarks/tpch/Tests/05-explain.reqtests sql/benchmarks/tpch/Tests/05-explain.stable.err sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-plan.SQL.py.src sql/benchmarks/tpch/Tests/05-plan.reqtests sql/benchmarks/tpch/Tests/05-plan.stable.err sql/benchmarks/tpch/Tests/05-plan.stable.out sql/benchmarks/tpch/Tests/06-explain.SQL.py.src sql/benchmarks/tpch/Tests/06-explain.reqtests sql/benchmarks/tpch/Tests/06-explain.stable.err sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06-plan.SQL.py.src sql/benchmarks/tpch/Tests/06-plan.reqtests sql/benchmarks/tpch/Tests/06-plan.stable.err sql/benchmarks/tpch/Tests/06-plan.stable.out sql/benchmarks/tpch/Tests/07-explain.SQL.py.src sql/benchmarks/tpch/Tests/07-explain.reqtests sql/benchmarks/tpch/Tests/07-explain.stable.err sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/07-plan.SQL.py.src sql/benchmarks/tpch/Tests/07-plan.reqtests sql/benchmarks/tpch/Tests/07-plan.stable.err sql/benchmarks/tpch/Tests/07-plan.stable.out sql/benchmarks/tpch/Tests/08-explain.SQL.py.src sql/benchmarks/tpch/Tests/08-explain.reqtests sql/benchmarks/tpch/Tests/08-explain.stable.err sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/08-plan.SQL.py.src sql/benchmarks/tpch/Tests/08-plan.reqtests sql/benchmarks/tpch/Tests/08-plan.stable.err sql/benchmarks/tpch/Tests/08-plan.stable.out sql/benchmarks/tpch/Tests/09-explain.SQL.py.src sql/benchmarks/tpch/Tests/09-explain.reqtests sql/benchmarks/tpch/Tests/09-explain.stable.err sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/09-plan.SQL.py.src sql/benchmarks/tpch/Tests/09-plan.reqtests sql/benchmarks/tpch/Tests/09-plan.stable.err sql/benchmarks/tpch/Tests/09-plan.stable.out sql/benchmarks/tpch/Tests/10-explain.SQL.py.src sql/benchmarks/tpch/Tests/10-explain.reqtests sql/benchmarks/tpch/Tests/10-explain.stable.err sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-plan.SQL.py.src sql/benchmarks/tpch/Tests/10-plan.reqtests sql/benchmarks/tpch/Tests/10-plan.stable.err sql/benchmarks/tpch/Tests/10-plan.stable.out sql/benchmarks/tpch/Tests/11-explain.SQL.py.src sql/benchmarks/tpch/Tests/11-explain.reqtests sql/benchmarks/tpch/Tests/11-explain.stable.err sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11-plan.SQL.py.src sql/benchmarks/tpch/Tests/11-plan.reqtests sql/benchmarks/tpch/Tests/11-plan.stable.err sql/benchmarks/tpch/Tests/11-plan.stable.out sql/benchmarks/tpch/Tests/12-explain.SQL.py.src sql/benchmarks/tpch/Tests/12-explain.reqtests sql/benchmarks/tpch/Tests/12-explain.stable.err sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/12-plan.SQL.py.src sql/benchmarks/tpch/Tests/12-plan.reqtests sql/benchmarks/tpch/Tests/12-plan.stable.err sql/benchmarks/tpch/Tests/12-plan.stable.out sql/benchmarks/tpch/Tests/13-explain.SQL.py.src sql/benchmarks/tpch/Tests/13-explain.reqtests sql/benchmarks/tpch/Tests/13-explain.stable.err sql/benchmarks/tpch/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/13-plan.SQL.py.src sql/benchmarks/tpch/Tests/13-plan.reqtests sql/benchmarks/tpch/Tests/13-plan.stable.err sql/benchmarks/tpch/Tests/13-plan.stable.out sql/benchmarks/tpch/Tests/14-explain.SQL.py.src sql/benchmarks/tpch/Tests/14-explain.reqtests sql/benchmarks/tpch/Tests/14-explain.stable.err sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/14-plan.SQL.py.src sql/benchmarks/tpch/Tests/14-plan.reqtests sql/benchmarks/tpch/Tests/14-plan.stable.err sql/benchmarks/tpch/Tests/14-plan.stable.out sql/benchmarks/tpch/Tests/15-explain.SQL.py.src sql/benchmarks/tpch/Tests/15-explain.reqtests sql/benchmarks/tpch/Tests/15-explain.stable.err sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/15-plan.SQL.py.src sql/benchmarks/tpch/Tests/15-plan.reqtests sql/benchmarks/tpch/Tests/15-plan.stable.err sql/benchmarks/tpch/Tests/15-plan.stable.out sql/benchmarks/tpch/Tests/16-explain.SQL.py.src sql/benchmarks/tpch/Tests/16-explain.reqtests sql/benchmarks/tpch/Tests/16-explain.stable.err sql/benchmarks/tpch/Tests/16-explain.stable.out sql/benchmarks/tpch/Tests/16-plan.SQL.py.src sql/benchmarks/tpch/Tests/16-plan.reqtests sql/benchmarks/tpch/Tests/16-plan.stable.err sql/benchmarks/tpch/Tests/16-plan.stable.out sql/benchmarks/tpch/Tests/17-explain.SQL.py.src sql/benchmarks/tpch/Tests/17-explain.reqtests sql/benchmarks/tpch/Tests/17-explain.stable.err sql/benchmarks/tpch/Tests/17-explain.stable.out sql/benchmarks/tpch/Tests/17-plan.SQL.py.src sql/benchmarks/tpch/Tests/17-plan.reqtests sql/benchmarks/tpch/Tests/17-plan.stable.err sql/benchmarks/tpch/Tests/17-plan.stable.out sql/benchmarks/tpch/Tests/18-explain.SQL.py.src sql/benchmarks/tpch/Tests/18-explain.reqtests sql/benchmarks/tpch/Tests/18-explain.stable.err sql/benchmarks/tpch/Tests/18-explain.stable.out sql/benchmarks/tpch/Tests/18-plan.SQL.py.src sql/benchmarks/tpch/Tests/18-plan.reqtests sql/benchmarks/tpch/Tests/18-plan.stable.err sql/benchmarks/tpch/Tests/18-plan.stable.out sql/benchmarks/tpch/Tests/19-explain.SQL.py.src sql/benchmarks/tpch/Tests/19-explain.reqtests sql/benchmarks/tpch/Tests/19-explain.stable.err sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/19-plan.SQL.py.src sql/benchmarks/tpch/Tests/19-plan.reqtests sql/benchmarks/tpch/Tests/19-plan.stable.err sql/benchmarks/tpch/Tests/19-plan.stable.out sql/benchmarks/tpch/Tests/20-explain.SQL.py.src sql/benchmarks/tpch/Tests/20-explain.reqtests sql/benchmarks/tpch/Tests/20-explain.stable.err sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/20-plan.SQL.py.src sql/benchmarks/tpch/Tests/20-plan.reqtests sql/benchmarks/tpch/Tests/20-plan.stable.err sql/benchmarks/tpch/Tests/20-plan.stable.out sql/benchmarks/tpch/Tests/21-explain.SQL.py.src sql/benchmarks/tpch/Tests/21-explain.reqtests sql/benchmarks/tpch/Tests/21-explain.stable.err sql/benchmarks/tpch/Tests/21-explain.stable.out sql/benchmarks/tpch/Tests/21-plan.SQL.py.src sql/benchmarks/tpch/Tests/21-plan.reqtests sql/benchmarks/tpch/Tests/21-plan.stable.err sql/benchmarks/tpch/Tests/21-plan.stable.out sql/benchmarks/tpch/Tests/22-explain.SQL.py.src sql/benchmarks/tpch/Tests/22-explain.reqtests sql/benchmarks/tpch/Tests/22-explain.stable.err sql/benchmarks/tpch/Tests/22-explain.stable.out sql/benchmarks/tpch/Tests/22-plan.SQL.py.src sql/benchmarks/tpch/Tests/22-plan.reqtests sql/benchmarks/tpch/Tests/22-plan.stable.err sql/benchmarks/tpch/Tests/22-plan.stable.out sql/benchmarks/tpch/Tests/explain.SQL.py sql/benchmarks/tpch/Tests/plan.SQL.py Modified Files: sql/benchmarks/ssbm/Tests/All sql/benchmarks/tpch/Tests/All Branch: default Log Message:
Merge with Feb2013 branch. diffs (truncated from 13210 to 300 lines): diff --git a/sql/benchmarks/ssbm/Tests/01-explain.SQL.py.src b/sql/benchmarks/ssbm/Tests/01-explain.SQL.py.src new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-explain.SQL.py.src @@ -0,0 +1,1 @@ +$RELSRCDIR/explain.SQL.py diff --git a/sql/benchmarks/ssbm/Tests/01-explain.reqtests b/sql/benchmarks/ssbm/Tests/01-explain.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-explain.reqtests @@ -0,0 +1,4 @@ +create +check0 +load +check1 diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.err b/sql/benchmarks/ssbm/Tests/01-explain.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.err @@ -0,0 +1,35 @@ +stderr of test '01-explain` in directory 'sql/benchmarks/ssbm` itself: + + +# 23:10:45 > +# 23:10:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35257" "--set" "mapi_usock=/var/tmp/mtest-17595/.s.monetdb.35257" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm" "--set" "mal_listing=0" +# 23:10:45 > + +# builtin opt gdk_dbpath = /ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = yes +# 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 = 35257 +# cmdline opt mapi_usock = /var/tmp/mtest-17595/.s.monetdb.35257 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbpath = /ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm +# cmdline opt mal_listing = 0 + +# 23:10:45 > +# 23:10:45 > "/usr/bin/python2" "01-explain.SQL.py" "01-explain" +# 23:10:45 > + + +# 23:10:45 > +# 23:10:45 > "Done." +# 23:10:45 > + diff --git a/sql/benchmarks/ssbm/Tests/01-explain.stable.out b/sql/benchmarks/ssbm/Tests/01-explain.stable.out new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-explain.stable.out @@ -0,0 +1,100 @@ +stdout of test '01-explain` in directory 'sql/benchmarks/ssbm` itself: + + +# 23:10:45 > +# 23:10:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35257" "--set" "mapi_usock=/var/tmp/mtest-17595/.s.monetdb.35257" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm" "--set" "mal_listing=0" +# 23:10:45 > + +# MonetDB 5 server v11.15.12 +# This is an unreleased version +# Serving database 'mTests_sql_benchmarks_ssbm', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.591 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://rome.ins.cwi.nl:35257/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-17595/.s.monetdb.35257 +# MonetDB/GIS module loaded +# MonetDB/JAQL module loaded +# MonetDB/SQL module loaded + +Ready. + +# 23:10:45 > +# 23:10:45 > "/usr/bin/python2" "01-explain.SQL.py" "01-explain" +# 23:10:45 > + +#set optimizer = 'no_mitosis_pipe'; +#explain +#select sum(lo_extendedprice*lo_discount) as revenue +# from lineorder, dwdate +# where lo_orderdate = d_datekey +# and d_year = 1993 +# and lo_discount between 1 and 3 +# and lo_quantity < 25; +% .explain # table_name +% mal # name +% clob # type +% 91 # length +function user.s0_1{autoCommit=true}(A0:int,A1:int,A2:int,A3:int):void; + X_62:lng := nil:lng; +barrier X_97 := language.dataflow(); + X_6 := sql.mvc(); + X_10 := sql.bind(X_6,"sys","lineorder","lo_quantity",0); + X_18 := sql.bind(X_6,"sys","lineorder","lo_discount",0); + X_7:bat[:oid,:oid] := sql.tid(X_6,"sys","lineorder"); + X_88 := algebra.subselect(X_18,X_7,A1,A2,true,true,false); + (X_20,r1_23) := sql.bind(X_6,"sys","lineorder","lo_discount",2); + X_89 := algebra.subselect(r1_23,A1,A2,true,true,false); + X_22 := sql.bind(X_6,"sys","lineorder","lo_discount",1); + X_90 := algebra.subselect(X_22,X_7,A1,A2,true,true,false); + X_23 := sql.subdelta(X_88,X_7,X_20,X_89,X_90); + X_91 := algebra.thetasubselect(X_10,X_23,A3,"<"); + (X_13,r1_13) := sql.bind(X_6,"sys","lineorder","lo_quantity",2); + X_92 := algebra.thetasubselect(r1_13,A3,"<"); + X_16 := sql.bind(X_6,"sys","lineorder","lo_quantity",1); + X_93 := algebra.thetasubselect(X_16,X_23,A3,"<"); + X_25 := sql.subdelta(X_91,X_23,X_13,X_92,X_93); + X_27 := sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",0); + (X_29,r1_36) := sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",2); + X_31 := sql.bind_idxbat(X_6,"sys","lineorder","lineorder_lo_orderdate_fkey",1); + X_32 := sql.projectdelta(X_25,X_27,X_29,r1_36,X_31); + X_36 := sql.bind(X_6,"sys","dwdate","d_year",0); + X_33:bat[:oid,:oid] := sql.tid(X_6,"sys","dwdate"); + X_94 := algebra.subselect(X_36,X_33,A0,A0,true,true,false); + (X_39,r1_48) := sql.bind(X_6,"sys","dwdate","d_year",2); + X_95 := algebra.subselect(r1_48,A0,A0,true,true,false); + X_42 := sql.bind(X_6,"sys","dwdate","d_year",1); + X_96 := algebra.subselect(X_42,X_33,A0,A0,true,true,false); + X_44 := sql.subdelta(X_94,X_33,X_39,X_95,X_96); + X_46 := X_44; + (X_47,r1_59) := algebra.join(X_32,X_46); + X_49 := sql.bind(X_6,"sys","lineorder","lo_extendedprice",0); + (X_52,r1_64) := sql.bind(X_6,"sys","lineorder","lo_extendedprice",2); + X_54 := sql.bind(X_6,"sys","lineorder","lo_extendedprice",1); + X_55 := sql.projectdelta(X_25,X_49,X_52,r1_64,X_54); + X_56 := algebra.leftfetchjoin(X_47,X_55); + X_57 := batcalc.lng(X_56); + X_58 := sql.projectdelta(X_25,X_18,X_20,r1_23,X_22); + X_59 := algebra.leftfetchjoin(X_47,X_58); + X_60:bat[:oid,:lng] := batcalc.*(X_57,X_59); + X_61 := algebra.selectNotNil(X_60); + X_62:lng := aggr.sum(X_61); + language.pass(X_7); + language.pass(X_23); + language.pass(X_33); + language.pass(X_25); + language.pass(X_18); + language.pass(X_20); + language.pass(r1_23); + language.pass(X_22); + language.pass(X_47); +exit X_97; + sql.exportValue(1,"sys.L1","revenue","bigint",53,0,6,X_62,""); +end s0_1; + +# 23:10:45 > +# 23:10:45 > "Done." +# 23:10:45 > + diff --git a/sql/benchmarks/ssbm/Tests/01-plan.SQL.py.src b/sql/benchmarks/ssbm/Tests/01-plan.SQL.py.src new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-plan.SQL.py.src @@ -0,0 +1,1 @@ +$RELSRCDIR/plan.SQL.py diff --git a/sql/benchmarks/ssbm/Tests/01-plan.reqtests b/sql/benchmarks/ssbm/Tests/01-plan.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-plan.reqtests @@ -0,0 +1,4 @@ +create +check0 +load +check1 diff --git a/sql/benchmarks/ssbm/Tests/01-plan.stable.err b/sql/benchmarks/ssbm/Tests/01-plan.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-plan.stable.err @@ -0,0 +1,35 @@ +stderr of test '01-plan` in directory 'sql/benchmarks/ssbm` itself: + + +# 23:08:56 > +# 23:08:56 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36026" "--set" "mapi_usock=/var/tmp/mtest-16251/.s.monetdb.36026" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm" "--set" "mal_listing=0" +# 23:08:56 > + +# builtin opt gdk_dbpath = /ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/monetdb5/dbfarm/demo +# builtin opt gdk_debug = 0 +# builtin opt gdk_vmtrim = yes +# 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 = 36026 +# cmdline opt mapi_usock = /var/tmp/mtest-16251/.s.monetdb.36026 +# cmdline opt monet_prompt = +# cmdline opt mal_listing = 2 +# cmdline opt gdk_dbpath = /ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm +# cmdline opt mal_listing = 0 + +# 23:08:56 > +# 23:08:56 > "/usr/bin/python2" "01-plan.SQL.py" "01-plan" +# 23:08:56 > + + +# 23:08:56 > +# 23:08:56 > "Done." +# 23:08:56 > + diff --git a/sql/benchmarks/ssbm/Tests/01-plan.stable.out b/sql/benchmarks/ssbm/Tests/01-plan.stable.out new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/01-plan.stable.out @@ -0,0 +1,55 @@ +stdout of test '01-plan` in directory 'sql/benchmarks/ssbm` itself: + + +# 23:08:56 > +# 23:08:56 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36026" "--set" "mapi_usock=/var/tmp/mtest-16251/.s.monetdb.36026" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm" "--set" "mal_listing=0" +# 23:08:56 > + +# MonetDB 5 server v11.15.12 +# This is an unreleased version +# Serving database 'mTests_sql_benchmarks_ssbm', using 8 threads +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Found 15.591 GiB available main-memory. +# Copyright (c) 1993-July 2008 CWI. +# Copyright (c) August 2008-2013 MonetDB B.V., all rights reserved +# Visit http://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://rome.ins.cwi.nl:36026/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-16251/.s.monetdb.36026 +# MonetDB/GIS module loaded +# MonetDB/JAQL module loaded +# MonetDB/SQL module loaded + +Ready. + +# 23:08:56 > +# 23:08:56 > "/usr/bin/python2" "01-plan.SQL.py" "01-plan" +# 23:08:56 > + +#plan +#select sum(lo_extendedprice*lo_discount) as revenue +# from lineorder, dwdate +# where lo_orderdate = d_datekey +# and d_year = 1993 +# and lo_discount between 1 and 3 +# and lo_quantity < 25; +% .plan # table_name +% rel # name +% clob # type +% 718 # length +project ( +| group by ( +| | join ( +| | | select ( +| | | | table(sys.lineorder) [ lineorder.lo_orderdate, lineorder.lo_quantity, lineorder.lo_extendedprice, lineorder.lo_discount, lineorder.%TID% NOT NULL, lineorder.%lineorder_lo_orderkey_lo_linenumber_pkey NOT NULL HASHIDX , lineorder.%lineorder_lo_orderdate_fkey NOT NULL JOINIDX sys.lineorder.lineorder_lo_orderdate_fkey, lineorder.%lineorder_lo_commitdate_fkey NOT NULL JOINIDX sys.lineorder.lineorder_lo_commitdate_fkey, lineorder.%lineorder_lo_suppkey_fkey NOT NULL JOINIDX sys.lineorder.lineorder_lo_suppkey_fkey, lineorder.%lineorder_lo_custkey_fkey NOT NULL JOINIDX sys.lineorder.lineorder_lo_custkey_fkey, lineorder.%lineorder_lo_partkey_fkey NOT NULL JOINIDX sys.lineorder.lineorder_lo_partkey_fkey ] COUNT +| | | ) [ int[tinyint "1"] <= lineorder.lo_discount <= int[tinyint "3"], lineorder.lo_quantity < int[tinyint "25"] ], +| | | select ( +| | | | table(sys.dwdate) [ dwdate.d_datekey NOT NULL HASHCOL , dwdate.d_year, dwdate.%TID% NOT NULL, dwdate.%dwdate_d_datekey_pkey NOT NULL HASHIDX ] COUNT +| | | ) [ dwdate.d_year = int[smallint "1993"] ] +| | ) [ lineorder.lo_orderdate = dwdate.d_datekey NOT NULL HASHCOL JOINIDX sys.lineorder.lineorder_lo_orderdate_fkey ] +| ) [ ] [ sys.sum no nil (sys.sql_mul(bigint[lineorder.lo_extendedprice] as lineorder.lo_extendedprice, lineorder.lo_discount)) as L1.L1 ] +) [ L1 as L1.revenue ] + +# 23:08:56 > +# 23:08:56 > "Done." +# 23:08:56 > + diff --git a/sql/benchmarks/ssbm/Tests/02-explain.SQL.py.src b/sql/benchmarks/ssbm/Tests/02-explain.SQL.py.src new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/02-explain.SQL.py.src @@ -0,0 +1,1 @@ +$RELSRCDIR/explain.SQL.py diff --git a/sql/benchmarks/ssbm/Tests/02-explain.reqtests b/sql/benchmarks/ssbm/Tests/02-explain.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/02-explain.reqtests @@ -0,0 +1,4 @@ +create +check0 +load +check1 diff --git a/sql/benchmarks/ssbm/Tests/02-explain.stable.err b/sql/benchmarks/ssbm/Tests/02-explain.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/ssbm/Tests/02-explain.stable.err @@ -0,0 +1,35 @@ +stderr of test '02-explain` in directory 'sql/benchmarks/ssbm` itself: + + +# 23:10:45 > +# 23:10:45 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=35257" "--set" "mapi_usock=/var/tmp/mtest-17595/.s.monetdb.35257" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/manegold/_/Monet/HG/Feb2013/prefix/--disable-debug_--enable-assert_--enable-optimize/var/MonetDB/mTests_sql_benchmarks_ssbm" "--set" "mal_listing=0" _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
