Changeset: 59e0ac4418d0 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=59e0ac4418d0 Added Files: sql/benchmarks/tpch/fileleak/Tests/All sql/benchmarks/tpch/fileleak/Tests/check0.reqtests sql/benchmarks/tpch/fileleak/Tests/check0.sql sql/benchmarks/tpch/fileleak/Tests/check0.stable.err sql/benchmarks/tpch/fileleak/Tests/check0.stable.out sql/benchmarks/tpch/fileleak/Tests/check1.reqtests sql/benchmarks/tpch/fileleak/Tests/check1.sql sql/benchmarks/tpch/fileleak/Tests/check1.stable.err sql/benchmarks/tpch/fileleak/Tests/check1.stable.out sql/benchmarks/tpch/fileleak/Tests/create.sql.src sql/benchmarks/tpch/fileleak/Tests/create.stable.err sql/benchmarks/tpch/fileleak/Tests/create.stable.out sql/benchmarks/tpch/fileleak/Tests/delete_all.SQL.py sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.err sql/benchmarks/tpch/fileleak/Tests/delete_all.stable.out sql/benchmarks/tpch/fileleak/Tests/leaks.SQL.py sql/benchmarks/tpch/fileleak/Tests/leaks.stable.err sql/benchmarks/tpch/fileleak/Tests/leaks.stable.out sql/benchmarks/tpch/fileleak/Tests/load.SQL.py sql/benchmarks/tpch/fileleak/Tests/load.reqtests sql/benchmarks/tpch/fileleak/Tests/load.stable.err sql/benchmarks/tpch/fileleak/Tests/load.stable.out sql/benchmarks/tpch/fileleak/Tests/test.py sql/benchmarks/tpch/fileleak/Tests/test.sql sql/test/BugTracker-2013/Tests/correlated_subquery.Bug-3317.sql sql/test/BugTracker-2013/Tests/correlated_subquery.Bug-3317.stable.err sql/test/BugTracker-2013/Tests/correlated_subquery.Bug-3317.stable.out Branch: default Log Message:
merged with Feb2013 diffs (truncated from 1085 to 300 lines): diff --git a/sql/benchmarks/tpch/fileleak/Tests/All b/sql/benchmarks/tpch/fileleak/Tests/All new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/All @@ -0,0 +1,6 @@ +create +check0 +load +check1 +delete_all +leaks diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests b/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check0.reqtests @@ -0,0 +1,1 @@ +create diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.sql b/sql/benchmarks/tpch/fileleak/Tests/check0.sql new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check0.sql @@ -0,0 +1,8 @@ +select * from customer; +select * from nation; +select * from orders; +select * from partsupp; +select * from part; +select * from region; +select * from supplier; +select * from lineitem; diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.err @@ -0,0 +1,17 @@ +stderr of test 'check0` in directory 'sql/benchmarks/tpch/fileleak` itself: + + +# 19:09:06 > +# 19:09:06 > Mtimeout -timeout 180 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_MONET_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/log" --set mapi_port=56086 --set sql_port=51688 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB/sqlserver.mil" ; echo ; echo Over.. +# 19:09:06 > + + +# 19:09:06 > +# 19:09:06 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < check0.sql +# 19:09:06 > + + +# 19:09:06 > +# 19:09:06 > Done. +# 19:09:06 > + diff --git a/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check0.stable.out @@ -0,0 +1,57 @@ +stdout of test 'check0` in directory 'sql/benchmarks/tpch/fileleak` itself: + + +# 12:34:18 > +# 12:34:18 > Mtimeout -timeout 180 Mserver "--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf" --debug=10 --set "monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin" --set "gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm" --set "sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log" --set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" --dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over.. +# 12:34:18 > + +# Monet Database Server V4.9.3 +# Copyright (c) 1993-2005, CWI. All rights reserved. +# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically linked. +# Visit http://monetdb.cwi.nl/ for further information. + + +Ready. + + +# 11:47:51 > +# 11:47:51 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35781 < check0.sql +# 11:47:51 > + +% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name +% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar, varchar # type +% 1, 0, 0, 1, 0, 17, 0, 0 # length +% sys.nation, sys.nation, sys.nation, sys.nation # table_name +% n_nationkey, n_name, n_regionkey, n_comment # name +% int, varchar, int, varchar # type +% 1, 0, 1, 0 # length +% sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders # table_name +% o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate, o_orderpriority, o_clerk, o_shippriority, o_comment # name +% int, int, varchar, decimal, date, varchar, varchar, int, varchar # type +% 1, 1, 0, 17, 10, 0, 0, 1, 0 # length +% sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp # table_name +% ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment # name +% int, int, int, decimal, varchar # type +% 1, 1, 1, 17, 0 # length +% sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part # table_name +% p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment # name +% int, varchar, varchar, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 0, 0, 0, 0, 1, 0, 17, 0 # length +% sys.region, sys.region, sys.region # table_name +% r_regionkey, r_name, r_comment # name +% int, varchar, varchar # type +% 1, 0, 0 # length +% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name +% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 0, 0, 1, 0, 17, 0 # length +% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem # table_name +% l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment # name +% int, int, int, int, int, decimal, decimal, decimal, varchar, varchar, date, date, date, varchar, varchar, varchar # type +% 1, 1, 1, 1, 1, 17, 17, 17, 0, 0, 10, 10, 10, 0, 0, 0 # length + +# 11:47:51 > +# 11:47:51 > Done. +# 11:47:51 > + diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests b/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check1.reqtests @@ -0,0 +1,3 @@ +create +check0 +load diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.sql b/sql/benchmarks/tpch/fileleak/Tests/check1.sql new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check1.sql @@ -0,0 +1,17 @@ +select count(*) from customer; +select count(*) from nation; +select count(*) from orders; +select count(*) from partsupp; +select count(*) from part; +select count(*) from region; +select count(*) from supplier; +select count(*) from lineitem; + +select * from region limit 9; +select * from nation limit 9; +select * from supplier limit 9; +select * from customer limit 9; +select * from part limit 9; +select * from partsupp limit 9; +select * from orders limit 9; +select * from lineitem limit 9; diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.err @@ -0,0 +1,17 @@ +stderr of test 'check1` in directory 'sql/benchmarks/tpch/fileleak` itself: + + +# 19:09:29 > +# 19:09:29 > Mtimeout -timeout 180 Mserver "--config=/var/tmp/_PREFIX_MONET_GNU_32_d__/etc/monet.conf" --debug=10 --set "monet_mod_path=/var/tmp/_PREFIX_MONET_GNU_32_d__/lib/MonetDB:/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB" --set "gdk_dbfarm=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/dbfarm" --set "sql_logdir=/var/tmp/_PREFIX_MONET_GNU_32_d__/var/MonetDB/log" --set mapi_port=56086 --set sql_port=51688 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" "/var/tmp/_PREFIX_SQL_GNU_32_d__/lib/MonetDB/sqlserver.mil" ; echo ; echo Over.. +# 19:09:29 > + + +# 19:09:29 > +# 19:09:29 > Mtimeout -timeout 60 Msql -u monetdb -P monetdb --host=draco --port=51688 --trace < check1.sql +# 19:09:29 > + + +# 19:09:30 > +# 19:09:30 > Done. +# 19:09:30 > + diff --git a/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpch/fileleak/Tests/check1.stable.out @@ -0,0 +1,186 @@ +stdout of test 'check1` in directory 'sql/benchmarks/tpch/fileleak` itself: + + +# 11:55:48 > +# 11:55:48 > mserver5 "--config=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5/etc/monetdb5.conf" --debug=10 --set "monet_mod_path=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/lib:/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//lib/MonetDB5/bin" --set "gdk_dbfarm=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/dbfarm" --set "sql_logdir=/ufs/goncalve/scratch/MonetDB/stable/debug/MonetDB5//var/MonetDB5/sql_logs" --set mapi_open=true --set xrpc_open=true --set mapi_port=30364 --set xrpc_port=49769 --set monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include sql;" ; echo ; echo Over.. +# 11:55:48 > + +# MonetDB server v5.6.1, based on kernel v1.24.1 +# Serving database 'mTests_src_benchmarks_tpch' +# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked +# Copyright (c) 1993-2008 CWI, all rights reserved +# Visit http://monetdb.cwi.nl/ for further information +# Listening for connection requests on mapi:monetdb://alviss.ins.cwi.nl:30364/ +# MonetDB/SQL module v2.24.1 loaded + +Ready. +#function user.main():void; +# clients.quit(); +#end main; + + +# 11:47:54 > +# 11:47:54 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb --host=localhost --port=35781 < check1.sql +# 11:47:54 > + +#select count(*) from customer; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 4 # length +[ 1500 ] +#select count(*) from nation; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 2 # length +[ 25 ] +#select count(*) from orders; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 5 # length +[ 15000 ] +#select count(*) from partsupp; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 4 # length +[ 8000 ] +#select count(*) from part; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 4 # length +[ 2000 ] +#select count(*) from region; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 1 # length +[ 5 ] +#select count(*) from supplier; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 3 # length +[ 100 ] +#select count(*) from lineitem; +% sys.L1 # table_name +% L1 # name +% wrd # type +% 5 # length +[ 60175 ] +#select * from region limit 9; +% sys.region, sys.region, sys.region # table_name +% r_regionkey, r_name, r_comment # name +% int, varchar, varchar # type +% 1, 11, 111 # length +[ 0, "AFRICA", "special Tiresias about the furiously even dolphins are furi" ] +[ 1, "AMERICA", "even, ironic theodolites according to the bold platelets wa" ] +[ 2, "ASIA", "silent, bold requests sleep slyly across the quickly sly dependencies. furiously silent instructions alongside " ] +[ 3, "EUROPE", "special, bold deposits haggle foxes. platelet" ] +[ 4, "MIDDLE EAST", "furiously unusual packages use carefully above the unusual, exp" ] +#select * from nation limit 9; +% sys.nation, sys.nation, sys.nation, sys.nation # table_name +% n_nationkey, n_name, n_regionkey, n_comment # name +% int, varchar, int, varchar # type +% 1, 9, 1, 112 # length +[ 0, "ALGERIA", 0, "final accounts wake quickly. special reques" ] +[ 1, "ARGENTINA", 1, "idly final instructions cajole stealthily. regular instructions wake carefully blithely express accounts. fluffi" ] +[ 2, "BRAZIL", 1, "always pending pinto beans sleep sil" ] +[ 3, "CANADA", 1, "foxes among the bold requests" ] +[ 4, "EGYPT", 4, "pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref" ] +[ 5, "ETHIOPIA", 0, "fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco" ] +[ 6, "FRANCE", 3, "even requests detect near the pendin" ] +[ 7, "GERMANY", 3, "blithely ironic foxes grow. quickly pending accounts are b" ] +[ 8, "INDIA", 2, "ironic packages should have to are slyly around the special, ironic accounts. iron" ] +#select * from supplier limit 9; +% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name +% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 18, 35, 2, 15, 17, 93 # length +[ 1, "Supplier#000000001", " N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ", 17, "27-918-335-1736", 5755.94, "requests haggle carefully. accounts sublate finally. carefully ironic pa" ] +[ 2, "Supplier#000000002", "89eJ5ksX3ImxJQBvxObC,", 5, "15-679-861-2259", 4032.68, "furiously stealthy frays thrash alongside of the slyly express deposits. blithely regular req" ] +[ 3, "Supplier#000000003", "q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3", 1, "11-383-516-1199", 4192.40, "furiously regular instructions impress slyly! carefu" ] +[ 4, "Supplier#000000004", "Bk7ah4CK8SYQTepEmvMkkgMwg", 15, "25-843-787-7479", 4641.08, "final ideas cajole. furiously close dep" ] +[ 5, "Supplier#000000005", "Gcdm2rJRzl5qlTVzc", 11, "21-151-690-3663", -283.84, "carefully silent instructions are slyly according t" ] +[ 6, "Supplier#000000006", "tQxuVm7s7CnK", 14, "24-696-997-4969", 1365.79, "even requests wake carefully! fluffily final pinto beans run slyly among t" ] +[ 7, "Supplier#000000007", "s,4TicNGB4uO6PaSqNBUq", 23, "33-990-965-2201", 6820.35, "carefully express packages believe furiously after the fur" ] +[ 8, "Supplier#000000008", "9Sq4bBH2FQEmaFOocY45sRTxo6yuoG", 17, "27-498-742-3860", 7627.85, "carefully express escapades are slyly " ] +[ 9, "Supplier#000000009", "1KhUgZegwM3ua7dsYmekYBsK", 10, "20-403-398-8662", 5302.37, "slyly regular decoys mold slyly ironic dugouts. requests are carefully-- carefully" ] +#select * from customer limit 9; +% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name +% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar, varchar # type +% 1, 18, 37, 2, 15, 17, 10, 114 # length +[ 1, "Customer#000000001", "IVhzIApeRb ot,c,E", 15, "25-989-741-2988", 711.56, "BUILDING", "regular, regular platelets are fluffily according to the even attainments. blithely iron" ] +[ 2, "Customer#000000002", "XSTf4,NCwDVaWNe6tEgvwfmRchLXak", 13, "23-768-687-3665", 121.65, "AUTOMOBILE", "furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending" ] +[ 3, "Customer#000000003", "MG9kdTD2WBHm", 1, "11-719-748-3364", 7498.12, "AUTOMOBILE", "special packages wake. slyly reg" ] +[ 4, "Customer#000000004", "XxVSJsLAGtn", 4, "14-128-190-5944", 2866.83, "MACHINERY", "slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack" ] +[ 5, "Customer#000000005", "KvpyuHCplrB84WgAiGV6sYpZq7Tj", 3, "13-750-942-6364", 794.47, "HOUSEHOLD", "blithely final instructions haggle; stealthy sauternes nod; carefully regu" ] +[ 6, "Customer#000000006", "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn", 20, "30-114-968-4951", 7638.57, "AUTOMOBILE", "special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith" ] +[ 7, "Customer#000000007", "TcGe5gaZNgVePxU5kRrvXBfkasDTea", 18, "28-190-982-9759", 9561.95, "AUTOMOBILE", "theodolites kindle carefully carefully regular deposits. regular depe" ] +[ 8, "Customer#000000008", "I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5", 17, "27-147-574-9335", 6819.74, "BUILDING", "ironic deposits are quickly after the gifts. regular dependencies hinder slyly after the quickly ex" ] +[ 9, "Customer#000000009", "xKiAFTjUsCuxfeleNqefumTrjS", 8, "18-338-906-3675", 8324.07, "FURNITURE", "deposits affix fluffily. blithely final ideas are furiously dolphins. i" ] +#select * from part limit 9; +% sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part # table_name +% p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment # name +% int, varchar, varchar, varchar, varchar, int, varchar, decimal, varchar # type _______________________________________________ checkin-list mailing list checkin-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/checkin-list
