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
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
