Changeset: c366d5dddc40 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c366d5dddc40 Modified Files: sql/test/remote/Tests/ssbm.SQL.py sql/test/remote/Tests/ssbm.stable.out Branch: default Log Message:
Remote test: simple queries sanity check diffs (99 lines): diff --git a/sql/test/remote/Tests/ssbm.SQL.py b/sql/test/remote/Tests/ssbm.SQL.py --- a/sql/test/remote/Tests/ssbm.SQL.py +++ b/sql/test/remote/Tests/ssbm.SQL.py @@ -190,6 +190,12 @@ for workerrec in workers: c.execute("select count(*) from lineorder") print str(c.fetchall()[0][0]) + ' rows in mergetable' +c.execute("select * from lineorder where lo_orderkey=356") +print str(c.fetchall()[0][0]) + +c.execute("select * from " + shardtable + workers[0]['tpf'] + " where lo_orderkey=356") +print str(c.fetchall()[0][0]) + # run queries, use mclient so output is comparable queries = glob.glob(os.path.join(ssbmpath, '[0-1][0-9].sql')) queries.sort() diff --git a/sql/test/remote/Tests/ssbm.stable.out b/sql/test/remote/Tests/ssbm.stable.out --- a/sql/test/remote/Tests/ssbm.stable.out +++ b/sql/test/remote/Tests/ssbm.stable.out @@ -2,10 +2,25 @@ stdout of test 'ssbm` in directory 'sql/ Ready. +# 14:14:37 > +# 14:14:37 > "/usr/local/opt/python/bin/python2.7" "ssbm.SQL.py" "ssbm" +# 14:14:37 > + 60175 rows in mergetable +356 +356 +# Running Q01 -# manually adapted test output from ssbm test cases -# Q1 +# 14:14:39 > +# 14:14:39 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --port=60251 --database=master --host=localhost < "/Users/hannes/source/MonetDB/sql/benchmarks/ssbm/Tests/01.sql" +# 14:14:39 > + +#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; % .L1 # table_name % revenue # name % bigint # type @@ -459,8 +474,23 @@ 60175 rows in mergetable [ 1998, "CANADA", 93061401 ] [ 1998, "PERU", 41688725 ] -# Q12 -% .dwdate, .supplier, .part, . # table_name +# 14:14:41 > +# 14:14:41 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --port=60251 --database=master --host=localhost < "/Users/hannes/source/MonetDB/sql/benchmarks/ssbm/Tests/12.sql" +# 14:14:41 > + +#select d_year, s_nation, p_category, sum(lo_revenue-lo_supplycost) as profit1 +# from dwdate, customer, supplier, part, lineorder +# where lo_custkey = c_custkey +# and lo_suppkey = s_suppkey +# and lo_partkey = p_partkey +# and lo_orderdate = d_datekey +# and c_region = 'AMERICA' +# and s_region = 'AMERICA' +# and (d_year = 1997 or d_year = 1998) +# and (p_mfgr = 'MFGR#1' or p_mfgr = 'MFGR#2') +# group by d_year, s_nation, p_category +# order by d_year, s_nation, p_category; +% .dwdate, .supplier, .part, .L1 # table_name % d_year, s_nation, p_category, profit1 # name % int, clob, clob, bigint # type % 4, 13, 7, 8 # length @@ -541,8 +571,23 @@ 60175 rows in mergetable [ 1998, "UNITED STATES", "MFGR#24", 8482069 ] [ 1998, "UNITED STATES", "MFGR#25", 3295629 ] -# Q13 -% .dwdate, .supplier, .part, . # table_name +# 14:14:42 > +# 14:14:42 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --port=60251 --database=master --host=localhost < "/Users/hannes/source/MonetDB/sql/benchmarks/ssbm/Tests/13.sql" +# 14:14:42 > + +#select d_year, s_city, p_brand1, sum(lo_revenue-lo_supplycost) as profit1 +# from dwdate, customer, supplier, part, lineorder +# where lo_custkey = c_custkey +# and lo_suppkey = s_suppkey +# and lo_partkey = p_partkey +# and lo_orderdate = d_datekey +# and c_region = 'AMERICA' +# and s_nation = 'UNITED STATES' +# and (d_year = 1997 or d_year = 1998) +# and p_category = 'MFGR#14' +# group by d_year, s_city, p_brand1 +# order by d_year, s_city, p_brand1; +% .dwdate, .supplier, .part, .L1 # table_name % d_year, s_city, p_brand1, profit1 # name % int, clob, clob, bigint # type % 4, 10, 9, 7 # length _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list