Changeset: 7ff3e94ad025 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7ff3e94ad025 Added Files: sql/benchmarks/tpcds/Tests/01.reqtests sql/benchmarks/tpcds/Tests/01.sql sql/benchmarks/tpcds/Tests/01.stable.err sql/benchmarks/tpcds/Tests/01.stable.out sql/benchmarks/tpcds/Tests/02.reqtests sql/benchmarks/tpcds/Tests/02.sql sql/benchmarks/tpcds/Tests/02.stable.err sql/benchmarks/tpcds/Tests/02.stable.out sql/benchmarks/tpcds/Tests/03.reqtests sql/benchmarks/tpcds/Tests/03.sql sql/benchmarks/tpcds/Tests/03.stable.err sql/benchmarks/tpcds/Tests/03.stable.out sql/benchmarks/tpcds/Tests/04.reqtests sql/benchmarks/tpcds/Tests/04.sql sql/benchmarks/tpcds/Tests/04.stable.err sql/benchmarks/tpcds/Tests/04.stable.out sql/benchmarks/tpcds/Tests/05.reqtests sql/benchmarks/tpcds/Tests/05.sql sql/benchmarks/tpcds/Tests/05.stable.err sql/benchmarks/tpcds/Tests/05.stable.out sql/benchmarks/tpcds/Tests/06.reqtests sql/benchmarks/tpcds/Tests/06.sql sql/benchmarks/tpcds/Tests/06.stable.err sql/benchmarks/tpcds/Tests/06.stable.out sql/benchmarks/tpcds/Tests/07.reqtests sql/benchmarks/tpcds/Tests/07.sql sql/benchmarks/tpcds/Tests/07.stable.err sql/benchmarks/tpcds/Tests/07.stable.out sql/benchmarks/tpcds/Tests/08.reqtests sql/benchmarks/tpcds/Tests/08.sql sql/benchmarks/tpcds/Tests/08.stable.err sql/benchmarks/tpcds/Tests/08.stable.out sql/benchmarks/tpcds/Tests/09.reqtests sql/benchmarks/tpcds/Tests/09.sql sql/benchmarks/tpcds/Tests/09.stable.err sql/benchmarks/tpcds/Tests/09.stable.out sql/benchmarks/tpcds/Tests/10.reqtests sql/benchmarks/tpcds/Tests/10.sql sql/benchmarks/tpcds/Tests/10.stable.err sql/benchmarks/tpcds/Tests/10.stable.out sql/benchmarks/tpcds/Tests/11.stable.err sql/benchmarks/tpcds/Tests/11.stable.out sql/benchmarks/tpcds/Tests/12.reqtests sql/benchmarks/tpcds/Tests/12.sql sql/benchmarks/tpcds/Tests/12.stable.err sql/benchmarks/tpcds/Tests/12.stable.out sql/benchmarks/tpcds/Tests/13.reqtests sql/benchmarks/tpcds/Tests/13.sql sql/benchmarks/tpcds/Tests/13.stable.err sql/benchmarks/tpcds/Tests/13.stable.out sql/benchmarks/tpcds/Tests/14a.reqtests sql/benchmarks/tpcds/Tests/14a.sql sql/benchmarks/tpcds/Tests/14a.stable.err sql/benchmarks/tpcds/Tests/14a.stable.out sql/benchmarks/tpcds/Tests/14b.reqtests sql/benchmarks/tpcds/Tests/14b.sql sql/benchmarks/tpcds/Tests/14b.stable.err sql/benchmarks/tpcds/Tests/14b.stable.out sql/benchmarks/tpcds/Tests/15.reqtests sql/benchmarks/tpcds/Tests/15.sql sql/benchmarks/tpcds/Tests/15.stable.err sql/benchmarks/tpcds/Tests/15.stable.out sql/benchmarks/tpcds/Tests/16.reqtests sql/benchmarks/tpcds/Tests/16.sql sql/benchmarks/tpcds/Tests/16.stable.err sql/benchmarks/tpcds/Tests/16.stable.out sql/benchmarks/tpcds/Tests/17.reqtests sql/benchmarks/tpcds/Tests/17.sql sql/benchmarks/tpcds/Tests/17.stable.err sql/benchmarks/tpcds/Tests/17.stable.out sql/benchmarks/tpcds/Tests/18.reqtests sql/benchmarks/tpcds/Tests/18.sql sql/benchmarks/tpcds/Tests/18.stable.err sql/benchmarks/tpcds/Tests/18.stable.out sql/benchmarks/tpcds/Tests/19.reqtests sql/benchmarks/tpcds/Tests/19.sql sql/benchmarks/tpcds/Tests/19.stable.err sql/benchmarks/tpcds/Tests/19.stable.out sql/benchmarks/tpcds/Tests/20.reqtests sql/benchmarks/tpcds/Tests/20.sql sql/benchmarks/tpcds/Tests/20.stable.err sql/benchmarks/tpcds/Tests/20.stable.out sql/benchmarks/tpcds/Tests/21.reqtests sql/benchmarks/tpcds/Tests/21.sql sql/benchmarks/tpcds/Tests/21.stable.err sql/benchmarks/tpcds/Tests/21.stable.out sql/benchmarks/tpcds/Tests/22.reqtests sql/benchmarks/tpcds/Tests/22.sql sql/benchmarks/tpcds/Tests/22.stable.err sql/benchmarks/tpcds/Tests/22.stable.out sql/benchmarks/tpcds/Tests/23a.reqtests sql/benchmarks/tpcds/Tests/23a.sql sql/benchmarks/tpcds/Tests/23a.stable.err sql/benchmarks/tpcds/Tests/23a.stable.out sql/benchmarks/tpcds/Tests/23b.reqtests sql/benchmarks/tpcds/Tests/23b.sql sql/benchmarks/tpcds/Tests/23b.stable.err sql/benchmarks/tpcds/Tests/23b.stable.out sql/benchmarks/tpcds/Tests/24a.reqtests sql/benchmarks/tpcds/Tests/24a.sql sql/benchmarks/tpcds/Tests/24a.stable.err sql/benchmarks/tpcds/Tests/24a.stable.out sql/benchmarks/tpcds/Tests/24b.reqtests sql/benchmarks/tpcds/Tests/24b.sql sql/benchmarks/tpcds/Tests/24b.stable.err sql/benchmarks/tpcds/Tests/24b.stable.out sql/benchmarks/tpcds/Tests/25.reqtests sql/benchmarks/tpcds/Tests/25.sql sql/benchmarks/tpcds/Tests/25.stable.err sql/benchmarks/tpcds/Tests/25.stable.out sql/benchmarks/tpcds/Tests/26.reqtests sql/benchmarks/tpcds/Tests/26.sql sql/benchmarks/tpcds/Tests/26.stable.err sql/benchmarks/tpcds/Tests/26.stable.out sql/benchmarks/tpcds/Tests/27.reqtests sql/benchmarks/tpcds/Tests/27.sql sql/benchmarks/tpcds/Tests/27.stable.err sql/benchmarks/tpcds/Tests/27.stable.out sql/benchmarks/tpcds/Tests/28.reqtests sql/benchmarks/tpcds/Tests/28.sql sql/benchmarks/tpcds/Tests/28.stable.err sql/benchmarks/tpcds/Tests/28.stable.out sql/benchmarks/tpcds/Tests/29.reqtests sql/benchmarks/tpcds/Tests/29.sql sql/benchmarks/tpcds/Tests/29.stable.err sql/benchmarks/tpcds/Tests/29.stable.out sql/benchmarks/tpcds/Tests/30.reqtests sql/benchmarks/tpcds/Tests/30.sql sql/benchmarks/tpcds/Tests/30.stable.err sql/benchmarks/tpcds/Tests/30.stable.out sql/benchmarks/tpcds/Tests/31.reqtests sql/benchmarks/tpcds/Tests/31.sql sql/benchmarks/tpcds/Tests/31.stable.err sql/benchmarks/tpcds/Tests/31.stable.out sql/benchmarks/tpcds/Tests/32.reqtests sql/benchmarks/tpcds/Tests/32.sql sql/benchmarks/tpcds/Tests/32.stable.err sql/benchmarks/tpcds/Tests/32.stable.out sql/benchmarks/tpcds/Tests/33.reqtests sql/benchmarks/tpcds/Tests/33.sql sql/benchmarks/tpcds/Tests/33.stable.err sql/benchmarks/tpcds/Tests/33.stable.out sql/benchmarks/tpcds/Tests/34.reqtests sql/benchmarks/tpcds/Tests/34.sql sql/benchmarks/tpcds/Tests/34.stable.err sql/benchmarks/tpcds/Tests/34.stable.out sql/benchmarks/tpcds/Tests/35.reqtests sql/benchmarks/tpcds/Tests/35.sql sql/benchmarks/tpcds/Tests/35.stable.err sql/benchmarks/tpcds/Tests/35.stable.out sql/benchmarks/tpcds/Tests/36.reqtests sql/benchmarks/tpcds/Tests/36.sql sql/benchmarks/tpcds/Tests/36.stable.err sql/benchmarks/tpcds/Tests/36.stable.out sql/benchmarks/tpcds/Tests/37.reqtests sql/benchmarks/tpcds/Tests/37.sql sql/benchmarks/tpcds/Tests/37.stable.err sql/benchmarks/tpcds/Tests/37.stable.out sql/benchmarks/tpcds/Tests/38.stable.err sql/benchmarks/tpcds/Tests/38.stable.out sql/benchmarks/tpcds/Tests/39a.reqtests sql/benchmarks/tpcds/Tests/39a.sql sql/benchmarks/tpcds/Tests/39a.stable.err sql/benchmarks/tpcds/Tests/39a.stable.out sql/benchmarks/tpcds/Tests/39b.reqtests sql/benchmarks/tpcds/Tests/39b.sql sql/benchmarks/tpcds/Tests/39b.stable.err sql/benchmarks/tpcds/Tests/39b.stable.out sql/benchmarks/tpcds/Tests/40.reqtests sql/benchmarks/tpcds/Tests/40.sql sql/benchmarks/tpcds/Tests/40.stable.err sql/benchmarks/tpcds/Tests/40.stable.out sql/benchmarks/tpcds/Tests/41.reqtests sql/benchmarks/tpcds/Tests/41.sql sql/benchmarks/tpcds/Tests/41.stable.err sql/benchmarks/tpcds/Tests/41.stable.out sql/benchmarks/tpcds/Tests/42.reqtests sql/benchmarks/tpcds/Tests/42.sql sql/benchmarks/tpcds/Tests/42.stable.err sql/benchmarks/tpcds/Tests/42.stable.out sql/benchmarks/tpcds/Tests/43.reqtests sql/benchmarks/tpcds/Tests/43.sql sql/benchmarks/tpcds/Tests/43.stable.err sql/benchmarks/tpcds/Tests/43.stable.out sql/benchmarks/tpcds/Tests/44.reqtests sql/benchmarks/tpcds/Tests/44.sql sql/benchmarks/tpcds/Tests/44.stable.err sql/benchmarks/tpcds/Tests/44.stable.out sql/benchmarks/tpcds/Tests/45.reqtests sql/benchmarks/tpcds/Tests/45.sql sql/benchmarks/tpcds/Tests/45.stable.err sql/benchmarks/tpcds/Tests/45.stable.out sql/benchmarks/tpcds/Tests/46.reqtests sql/benchmarks/tpcds/Tests/46.sql sql/benchmarks/tpcds/Tests/46.stable.err sql/benchmarks/tpcds/Tests/46.stable.out sql/benchmarks/tpcds/Tests/47.reqtests sql/benchmarks/tpcds/Tests/47.sql sql/benchmarks/tpcds/Tests/47.stable.err sql/benchmarks/tpcds/Tests/47.stable.out sql/benchmarks/tpcds/Tests/48.reqtests sql/benchmarks/tpcds/Tests/48.sql sql/benchmarks/tpcds/Tests/48.stable.err sql/benchmarks/tpcds/Tests/48.stable.out sql/benchmarks/tpcds/Tests/49.reqtests sql/benchmarks/tpcds/Tests/49.sql sql/benchmarks/tpcds/Tests/49.stable.err sql/benchmarks/tpcds/Tests/49.stable.out sql/benchmarks/tpcds/Tests/50.reqtests sql/benchmarks/tpcds/Tests/50.sql sql/benchmarks/tpcds/Tests/50.stable.err sql/benchmarks/tpcds/Tests/50.stable.out sql/benchmarks/tpcds/Tests/51.reqtests sql/benchmarks/tpcds/Tests/51.sql sql/benchmarks/tpcds/Tests/51.stable.err sql/benchmarks/tpcds/Tests/51.stable.out sql/benchmarks/tpcds/Tests/52.reqtests sql/benchmarks/tpcds/Tests/52.sql sql/benchmarks/tpcds/Tests/52.stable.err sql/benchmarks/tpcds/Tests/52.stable.out sql/benchmarks/tpcds/Tests/53.reqtests sql/benchmarks/tpcds/Tests/53.sql sql/benchmarks/tpcds/Tests/53.stable.err sql/benchmarks/tpcds/Tests/53.stable.out sql/benchmarks/tpcds/Tests/54.reqtests sql/benchmarks/tpcds/Tests/54.sql sql/benchmarks/tpcds/Tests/54.stable.err sql/benchmarks/tpcds/Tests/54.stable.out sql/benchmarks/tpcds/Tests/55.reqtests sql/benchmarks/tpcds/Tests/55.sql sql/benchmarks/tpcds/Tests/55.stable.err sql/benchmarks/tpcds/Tests/55.stable.out sql/benchmarks/tpcds/Tests/56.reqtests sql/benchmarks/tpcds/Tests/56.sql sql/benchmarks/tpcds/Tests/56.stable.err sql/benchmarks/tpcds/Tests/56.stable.out sql/benchmarks/tpcds/Tests/57.reqtests sql/benchmarks/tpcds/Tests/57.sql sql/benchmarks/tpcds/Tests/57.stable.err sql/benchmarks/tpcds/Tests/57.stable.out sql/benchmarks/tpcds/Tests/58.reqtests sql/benchmarks/tpcds/Tests/58.sql sql/benchmarks/tpcds/Tests/58.stable.err sql/benchmarks/tpcds/Tests/58.stable.out sql/benchmarks/tpcds/Tests/59.reqtests sql/benchmarks/tpcds/Tests/59.sql sql/benchmarks/tpcds/Tests/59.stable.err sql/benchmarks/tpcds/Tests/59.stable.out sql/benchmarks/tpcds/Tests/60.reqtests sql/benchmarks/tpcds/Tests/60.sql sql/benchmarks/tpcds/Tests/60.stable.err sql/benchmarks/tpcds/Tests/60.stable.out sql/benchmarks/tpcds/Tests/61.reqtests sql/benchmarks/tpcds/Tests/61.sql sql/benchmarks/tpcds/Tests/61.stable.err sql/benchmarks/tpcds/Tests/61.stable.out sql/benchmarks/tpcds/Tests/62.reqtests sql/benchmarks/tpcds/Tests/62.sql sql/benchmarks/tpcds/Tests/62.stable.err sql/benchmarks/tpcds/Tests/62.stable.out sql/benchmarks/tpcds/Tests/63.reqtests sql/benchmarks/tpcds/Tests/63.sql sql/benchmarks/tpcds/Tests/63.stable.err sql/benchmarks/tpcds/Tests/63.stable.out sql/benchmarks/tpcds/Tests/64.reqtests sql/benchmarks/tpcds/Tests/64.sql sql/benchmarks/tpcds/Tests/64.stable.err sql/benchmarks/tpcds/Tests/64.stable.out sql/benchmarks/tpcds/Tests/65.reqtests sql/benchmarks/tpcds/Tests/65.sql sql/benchmarks/tpcds/Tests/65.stable.err sql/benchmarks/tpcds/Tests/65.stable.out sql/benchmarks/tpcds/Tests/66.reqtests sql/benchmarks/tpcds/Tests/66.sql sql/benchmarks/tpcds/Tests/66.stable.err sql/benchmarks/tpcds/Tests/66.stable.out sql/benchmarks/tpcds/Tests/67.reqtests sql/benchmarks/tpcds/Tests/67.sql sql/benchmarks/tpcds/Tests/67.stable.err sql/benchmarks/tpcds/Tests/67.stable.out sql/benchmarks/tpcds/Tests/68.reqtests sql/benchmarks/tpcds/Tests/68.sql sql/benchmarks/tpcds/Tests/68.stable.err sql/benchmarks/tpcds/Tests/68.stable.out sql/benchmarks/tpcds/Tests/69.reqtests sql/benchmarks/tpcds/Tests/69.sql sql/benchmarks/tpcds/Tests/69.stable.err sql/benchmarks/tpcds/Tests/69.stable.out sql/benchmarks/tpcds/Tests/70.reqtests sql/benchmarks/tpcds/Tests/70.sql sql/benchmarks/tpcds/Tests/70.stable.err sql/benchmarks/tpcds/Tests/70.stable.out sql/benchmarks/tpcds/Tests/71.reqtests sql/benchmarks/tpcds/Tests/71.sql sql/benchmarks/tpcds/Tests/71.stable.err sql/benchmarks/tpcds/Tests/71.stable.out sql/benchmarks/tpcds/Tests/72.stable.err sql/benchmarks/tpcds/Tests/72.stable.out sql/benchmarks/tpcds/Tests/73.reqtests sql/benchmarks/tpcds/Tests/73.sql sql/benchmarks/tpcds/Tests/73.stable.err sql/benchmarks/tpcds/Tests/73.stable.out sql/benchmarks/tpcds/Tests/74.reqtests sql/benchmarks/tpcds/Tests/74.sql sql/benchmarks/tpcds/Tests/74.stable.err sql/benchmarks/tpcds/Tests/74.stable.out sql/benchmarks/tpcds/Tests/75.reqtests sql/benchmarks/tpcds/Tests/75.sql sql/benchmarks/tpcds/Tests/75.stable.err sql/benchmarks/tpcds/Tests/75.stable.out sql/benchmarks/tpcds/Tests/76.reqtests sql/benchmarks/tpcds/Tests/76.sql sql/benchmarks/tpcds/Tests/76.stable.err sql/benchmarks/tpcds/Tests/76.stable.out sql/benchmarks/tpcds/Tests/77.reqtests sql/benchmarks/tpcds/Tests/77.sql sql/benchmarks/tpcds/Tests/77.stable.err sql/benchmarks/tpcds/Tests/77.stable.out sql/benchmarks/tpcds/Tests/78.reqtests sql/benchmarks/tpcds/Tests/78.sql sql/benchmarks/tpcds/Tests/78.stable.err sql/benchmarks/tpcds/Tests/78.stable.out sql/benchmarks/tpcds/Tests/79.reqtests sql/benchmarks/tpcds/Tests/79.sql sql/benchmarks/tpcds/Tests/79.stable.err sql/benchmarks/tpcds/Tests/79.stable.out sql/benchmarks/tpcds/Tests/80.reqtests sql/benchmarks/tpcds/Tests/80.sql sql/benchmarks/tpcds/Tests/80.stable.err sql/benchmarks/tpcds/Tests/80.stable.out sql/benchmarks/tpcds/Tests/81.reqtests sql/benchmarks/tpcds/Tests/81.sql sql/benchmarks/tpcds/Tests/81.stable.err sql/benchmarks/tpcds/Tests/81.stable.out sql/benchmarks/tpcds/Tests/82.reqtests sql/benchmarks/tpcds/Tests/82.sql sql/benchmarks/tpcds/Tests/82.stable.err sql/benchmarks/tpcds/Tests/82.stable.out sql/benchmarks/tpcds/Tests/83.stable.err sql/benchmarks/tpcds/Tests/83.stable.out sql/benchmarks/tpcds/Tests/84.reqtests sql/benchmarks/tpcds/Tests/84.sql sql/benchmarks/tpcds/Tests/84.stable.err sql/benchmarks/tpcds/Tests/84.stable.out sql/benchmarks/tpcds/Tests/85.reqtests sql/benchmarks/tpcds/Tests/85.sql sql/benchmarks/tpcds/Tests/85.stable.err sql/benchmarks/tpcds/Tests/85.stable.out sql/benchmarks/tpcds/Tests/86.reqtests sql/benchmarks/tpcds/Tests/86.sql sql/benchmarks/tpcds/Tests/86.stable.err sql/benchmarks/tpcds/Tests/86.stable.out sql/benchmarks/tpcds/Tests/87.reqtests sql/benchmarks/tpcds/Tests/87.sql sql/benchmarks/tpcds/Tests/87.stable.err sql/benchmarks/tpcds/Tests/87.stable.out sql/benchmarks/tpcds/Tests/88.reqtests sql/benchmarks/tpcds/Tests/88.sql sql/benchmarks/tpcds/Tests/88.stable.err sql/benchmarks/tpcds/Tests/88.stable.out sql/benchmarks/tpcds/Tests/89.reqtests sql/benchmarks/tpcds/Tests/89.sql sql/benchmarks/tpcds/Tests/89.stable.err sql/benchmarks/tpcds/Tests/89.stable.out sql/benchmarks/tpcds/Tests/90.reqtests sql/benchmarks/tpcds/Tests/90.sql sql/benchmarks/tpcds/Tests/90.stable.err sql/benchmarks/tpcds/Tests/90.stable.out sql/benchmarks/tpcds/Tests/91.reqtests sql/benchmarks/tpcds/Tests/91.sql sql/benchmarks/tpcds/Tests/91.stable.err sql/benchmarks/tpcds/Tests/91.stable.out sql/benchmarks/tpcds/Tests/92.reqtests sql/benchmarks/tpcds/Tests/92.sql sql/benchmarks/tpcds/Tests/92.stable.err sql/benchmarks/tpcds/Tests/92.stable.out sql/benchmarks/tpcds/Tests/93.reqtests sql/benchmarks/tpcds/Tests/93.sql sql/benchmarks/tpcds/Tests/93.stable.err sql/benchmarks/tpcds/Tests/93.stable.out sql/benchmarks/tpcds/Tests/94.reqtests sql/benchmarks/tpcds/Tests/94.sql sql/benchmarks/tpcds/Tests/94.stable.err sql/benchmarks/tpcds/Tests/94.stable.out sql/benchmarks/tpcds/Tests/95.reqtests sql/benchmarks/tpcds/Tests/95.sql sql/benchmarks/tpcds/Tests/95.stable.err sql/benchmarks/tpcds/Tests/95.stable.out sql/benchmarks/tpcds/Tests/96.reqtests sql/benchmarks/tpcds/Tests/96.sql sql/benchmarks/tpcds/Tests/96.stable.err sql/benchmarks/tpcds/Tests/96.stable.out sql/benchmarks/tpcds/Tests/97.reqtests sql/benchmarks/tpcds/Tests/97.sql sql/benchmarks/tpcds/Tests/97.stable.err sql/benchmarks/tpcds/Tests/97.stable.out sql/benchmarks/tpcds/Tests/98.stable.err sql/benchmarks/tpcds/Tests/98.stable.out sql/benchmarks/tpcds/Tests/99.stable.err sql/benchmarks/tpcds/Tests/99.stable.out Modified Files: sql/benchmarks/tpcds/Tests/11.reqtests sql/benchmarks/tpcds/Tests/11.sql sql/benchmarks/tpcds/Tests/38.reqtests sql/benchmarks/tpcds/Tests/38.sql sql/benchmarks/tpcds/Tests/72.reqtests sql/benchmarks/tpcds/Tests/72.sql sql/benchmarks/tpcds/Tests/83.reqtests sql/benchmarks/tpcds/Tests/83.sql sql/benchmarks/tpcds/Tests/98.reqtests sql/benchmarks/tpcds/Tests/98.sql sql/benchmarks/tpcds/Tests/99.reqtests sql/benchmarks/tpcds/Tests/99.sql sql/benchmarks/tpcds/Tests/All sql/benchmarks/tpcds/Tests/alter.reqtests sql/benchmarks/tpcds/Tests/check1.reqtests sql/benchmarks/tpcds/Tests/check1.stable.out sql/benchmarks/tpcds/Tests/load.reqtests sql/benchmarks/tpcds/Tests/load.sql.in Branch: default Log Message:
Add all TPC-DS tests and provide stable output. The output is based on Hannes' work. diffs (truncated from 29467 to 300 lines): diff --git a/sql/benchmarks/tpcds/Tests/01.reqtests b/sql/benchmarks/tpcds/Tests/01.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/01.reqtests @@ -0,0 +1,1 @@ +check1 diff --git a/sql/benchmarks/tpcds/Tests/01.sql b/sql/benchmarks/tpcds/Tests/01.sql new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/01.sql @@ -0,0 +1,24 @@ +WITH customer_total_return AS + (SELECT sr_customer_sk AS ctr_customer_sk, + sr_store_sk AS ctr_store_sk, + sum(sr_return_amt) AS ctr_total_return + FROM store_returns, + date_dim + WHERE sr_returned_date_sk = d_date_sk + AND d_year = 2000 + GROUP BY sr_customer_sk, + sr_store_sk) +SELECT c_customer_id +FROM customer_total_return ctr1, + store, + customer +WHERE ctr1.ctr_total_return > + (SELECT avg(ctr_total_return)*1.2 + FROM customer_total_return ctr2 + WHERE ctr1.ctr_store_sk = ctr2.ctr_store_sk) + AND s_store_sk = ctr1.ctr_store_sk + AND s_state = 'TN' + AND ctr1.ctr_customer_sk = c_customer_sk +ORDER BY c_customer_id +LIMIT 100; + diff --git a/sql/benchmarks/tpcds/Tests/01.stable.err b/sql/benchmarks/tpcds/Tests/01.stable.err new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/01.stable.err @@ -0,0 +1,35 @@ +stderr of test '01` in directory 'sql/benchmarks/tpcds` itself: + + +# 11:37:22 > +# 11:37:22 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30709" "--set" "mapi_usock=/var/tmp/mtest-16393/.s.monetdb.30709" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/@Monet-devel/var/MonetDB/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" +# 11:37:22 > + +# builtin opt gdk_dbpath = /ufs/sjoerd/@Monet-devel/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 = 30709 +# cmdline opt mapi_usock = /var/tmp/mtest-16393/.s.monetdb.30709 +# cmdline opt monet_prompt = +# cmdline opt gdk_dbpath = /ufs/sjoerd/@Monet-devel/var/MonetDB/mTests_sql_benchmarks_tpcds +# cmdline opt embedded_c = true +# cmdline opt gdk_debug = 553648138 + +# 11:37:22 > +# 11:37:22 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 11:37:22 > + + +# 11:39:35 > +# 11:39:35 > "Done." +# 11:39:35 > + diff --git a/sql/benchmarks/tpcds/Tests/01.stable.out b/sql/benchmarks/tpcds/Tests/01.stable.out new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/01.stable.out @@ -0,0 +1,152 @@ +stdout of test '01` in directory 'sql/benchmarks/tpcds` itself: + + +# 11:40:04 > +# 11:40:04 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30709" "--set" "mapi_usock=/var/tmp/mtest-16393/.s.monetdb.30709" "--set" "monet_prompt=" "--forcemito" "--dbpath=/ufs/sjoerd/@Monet-devel/var/MonetDB/mTests_sql_benchmarks_tpcds" "--set" "embedded_c=true" +# 11:40:04 > + +# MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) +# This is an unreleased version +# Serving database 'mTests_sql_benchmarks_tpcds', using 8 threads +# Compiled for x86_64-pc-linux-gnu/64bit with 128bit integers +# Found 62.694 GiB available main-memory. +# Copyright (c) 1993 - July 2008 CWI. +# Copyright (c) August 2008 - 2019 MonetDB B.V., all rights reserved +# Visit https://www.monetdb.org/ for further information +# Listening for connection requests on mapi:monetdb://methuselah.da.cwi.nl:30709/ +# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-16393/.s.monetdb.30709 +# MonetDB/GIS module loaded +# MonetDB/SQL module loaded + +Ready. + +# 11:40:04 > +# 11:40:04 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 11:40:04 > + +#WITH customer_total_return AS +# (SELECT sr_customer_sk AS ctr_customer_sk, +# sr_store_sk AS ctr_store_sk, +# sum(sr_return_amt) AS ctr_total_return +# FROM store_returns, +# date_dim +# WHERE sr_returned_date_sk = d_date_sk +# AND d_year = 2000 +# GROUP BY sr_customer_sk, +# sr_store_sk) +#SELECT c_customer_id +#FROM customer_total_return ctr1, +# store, +# customer +#WHERE ctr1.ctr_total_return > +# (SELECT avg(ctr_total_return)*1.2 +# FROM customer_total_return ctr2 +# WHERE ctr1.ctr_store_sk = ctr2.ctr_store_sk) +% sys.customer # table_name +% c_customer_id # name +% char # type +% 16 # length +[ "AAAAAAAAAAABBAAA" ] +[ "AAAAAAAAAAADBAAA" ] +[ "AAAAAAAAAAADBAAA" ] +[ "AAAAAAAAAAAKAAAA" ] +[ "AAAAAAAAAABDAAAA" ] +[ "AAAAAAAAAABHBAAA" ] +[ "AAAAAAAAAABLAAAA" ] +[ "AAAAAAAAAABMAAAA" ] +[ "AAAAAAAAAACHAAAA" ] +[ "AAAAAAAAAACMAAAA" ] +[ "AAAAAAAAAADDAAAA" ] +[ "AAAAAAAAAADGAAAA" ] +[ "AAAAAAAAAADGBAAA" ] +[ "AAAAAAAAAADGBAAA" ] +[ "AAAAAAAAAADPAAAA" ] +[ "AAAAAAAAAAEBAAAA" ] +[ "AAAAAAAAAAEFBAAA" ] +[ "AAAAAAAAAAEGBAAA" ] +[ "AAAAAAAAAAEIAAAA" ] +[ "AAAAAAAAAAEMAAAA" ] +[ "AAAAAAAAAAFAAAAA" ] +[ "AAAAAAAAAAFPAAAA" ] +[ "AAAAAAAAAAGGBAAA" ] +[ "AAAAAAAAAAGHBAAA" ] +[ "AAAAAAAAAAGJAAAA" ] +[ "AAAAAAAAAAGMAAAA" ] +[ "AAAAAAAAAAHEBAAA" ] +[ "AAAAAAAAAAHFBAAA" ] +[ "AAAAAAAAAAIEBAAA" ] +[ "AAAAAAAAAAJGBAAA" ] +[ "AAAAAAAAAAJHBAAA" ] +[ "AAAAAAAAAAKCAAAA" ] +[ "AAAAAAAAAAKCAAAA" ] +[ "AAAAAAAAAAKJAAAA" ] +[ "AAAAAAAAAAKMAAAA" ] +[ "AAAAAAAAAAKMAAAA" ] +[ "AAAAAAAAAALAAAAA" ] +[ "AAAAAAAAAALABAAA" ] +[ "AAAAAAAAAALGAAAA" ] +[ "AAAAAAAAAALHBAAA" ] +[ "AAAAAAAAAALJAAAA" ] +[ "AAAAAAAAAANHAAAA" ] +[ "AAAAAAAAAANHBAAA" ] +[ "AAAAAAAAAANJAAAA" ] +[ "AAAAAAAAAANMAAAA" ] +[ "AAAAAAAAAANMAAAA" ] +[ "AAAAAAAAAANNAAAA" ] +[ "AAAAAAAAAAOBBAAA" ] +[ "AAAAAAAAAAODBAAA" ] +[ "AAAAAAAAAAOLAAAA" ] +[ "AAAAAAAAAAPGBAAA" ] +[ "AAAAAAAAABAAAAAA" ] +[ "AAAAAAAAABAEAAAA" ] +[ "AAAAAAAAABAEBAAA" ] +[ "AAAAAAAAABAFBAAA" ] +[ "AAAAAAAAABAIAAAA" ] +[ "AAAAAAAAABAOAAAA" ] +[ "AAAAAAAAABBDBAAA" ] +[ "AAAAAAAAABCFAAAA" ] +[ "AAAAAAAAABCHBAAA" ] +[ "AAAAAAAAABDHAAAA" ] +[ "AAAAAAAAABENAAAA" ] +[ "AAAAAAAAABFEBAAA" ] +[ "AAAAAAAAABFGAAAA" ] +[ "AAAAAAAAABFMAAAA" ] +[ "AAAAAAAAABFPAAAA" ] +[ "AAAAAAAAABGFAAAA" ] +[ "AAAAAAAAABGFBAAA" ] +[ "AAAAAAAAABGJAAAA" ] +[ "AAAAAAAAABIBBAAA" ] +[ "AAAAAAAAABICBAAA" ] +[ "AAAAAAAAABIIAAAA" ] +[ "AAAAAAAAABJNAAAA" ] +[ "AAAAAAAAABKGBAAA" ] +[ "AAAAAAAAABLOAAAA" ] +[ "AAAAAAAAABLPAAAA" ] +[ "AAAAAAAAABMABAAA" ] +[ "AAAAAAAAABMPAAAA" ] +[ "AAAAAAAAABNAAAAA" ] +[ "AAAAAAAAABNCBAAA" ] +[ "AAAAAAAAABNEBAAA" ] +[ "AAAAAAAAABNLAAAA" ] +[ "AAAAAAAAABNOAAAA" ] +[ "AAAAAAAAABNPAAAA" ] +[ "AAAAAAAAABOAAAAA" ] +[ "AAAAAAAAABOFBAAA" ] +[ "AAAAAAAAABOOAAAA" ] +[ "AAAAAAAAABOPAAAA" ] +[ "AAAAAAAAABPEAAAA" ] +[ "AAAAAAAAACADAAAA" ] +[ "AAAAAAAAACAFAAAA" ] +[ "AAAAAAAAACAFAAAA" ] +[ "AAAAAAAAACAHBAAA" ] +[ "AAAAAAAAACAJAAAA" ] +[ "AAAAAAAAACBDAAAA" ] +[ "AAAAAAAAACBDAAAA" ] +[ "AAAAAAAAACBEBAAA" ] +[ "AAAAAAAAACBNAAAA" ] +[ "AAAAAAAAACBPAAAA" ] +[ "AAAAAAAAACCHAAAA" ] + +# 11:40:04 > +# 11:40:04 > "Done." +# 11:40:04 > diff --git a/sql/benchmarks/tpcds/Tests/02.reqtests b/sql/benchmarks/tpcds/Tests/02.reqtests new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/02.reqtests @@ -0,0 +1,1 @@ +check1 diff --git a/sql/benchmarks/tpcds/Tests/02.sql b/sql/benchmarks/tpcds/Tests/02.sql new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/02.sql @@ -0,0 +1,79 @@ +WITH wscs AS + (SELECT sold_date_sk, + sales_price + FROM + (SELECT ws_sold_date_sk sold_date_sk, + ws_ext_sales_price sales_price + FROM web_sales + UNION ALL SELECT cs_sold_date_sk sold_date_sk, + cs_ext_sales_price sales_price + FROM catalog_sales) sq1), + wswscs AS + (SELECT d_week_seq, + sum(CASE + WHEN (d_day_name='Sunday') THEN sales_price + ELSE NULL + END) sun_sales, + sum(CASE + WHEN (d_day_name='Monday') THEN sales_price + ELSE NULL + END) mon_sales, + sum(CASE + WHEN (d_day_name='Tuesday') THEN sales_price + ELSE NULL + END) tue_sales, + sum(CASE + WHEN (d_day_name='Wednesday') THEN sales_price + ELSE NULL + END) wed_sales, + sum(CASE + WHEN (d_day_name='Thursday') THEN sales_price + ELSE NULL + END) thu_sales, + sum(CASE + WHEN (d_day_name='Friday') THEN sales_price + ELSE NULL + END) fri_sales, + sum(CASE + WHEN (d_day_name='Saturday') THEN sales_price + ELSE NULL + END) sat_sales + FROM wscs, + date_dim + WHERE d_date_sk = sold_date_sk + GROUP BY d_week_seq) +SELECT d_week_seq1, + round(sun_sales1/sun_sales2, 2), + round(mon_sales1/mon_sales2, 2), + round(tue_sales1/tue_sales2, 2), + round(wed_sales1/wed_sales2, 2), + round(thu_sales1/thu_sales2, 2), + round(fri_sales1/fri_sales2, 2), + round(sat_sales1/sat_sales2, 2) +FROM + (SELECT wswscs.d_week_seq d_week_seq1, + sun_sales sun_sales1, + mon_sales mon_sales1, + tue_sales tue_sales1, _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list