Changeset: 4d45d1f2da53 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=4d45d1f2da53 Added Files: sql/benchmarks/tpcds/Tests/02.stable.out.int128 sql/benchmarks/tpcds/Tests/03.stable.out.int128 sql/benchmarks/tpcds/Tests/05.stable.out.int128 sql/benchmarks/tpcds/Tests/08.stable.out.int128 sql/benchmarks/tpcds/Tests/12.stable.out.int128 sql/benchmarks/tpcds/Tests/13.stable.out.int128 sql/benchmarks/tpcds/Tests/14a.stable.out.int128 sql/benchmarks/tpcds/Tests/14b.stable.out.int128 sql/benchmarks/tpcds/Tests/15.stable.out.int128 sql/benchmarks/tpcds/Tests/16.stable.out.int128 sql/benchmarks/tpcds/Tests/18.stable.out.int128 sql/benchmarks/tpcds/Tests/19.stable.out.int128 sql/benchmarks/tpcds/Tests/20.stable.out.int128 sql/benchmarks/tpcds/Tests/21.stable.out.int128 sql/benchmarks/tpcds/Tests/22.stable.out.int128 sql/benchmarks/tpcds/Tests/23a.stable.out.int128 sql/benchmarks/tpcds/Tests/23b.stable.out.int128 sql/benchmarks/tpcds/Tests/24a.stable.out.int128 sql/benchmarks/tpcds/Tests/24b.stable.out.int128 sql/benchmarks/tpcds/Tests/25.stable.out.int128 sql/benchmarks/tpcds/Tests/29.stable.out.int128 sql/benchmarks/tpcds/Tests/30.stable.out.int128 sql/benchmarks/tpcds/Tests/31.stable.out.int128 sql/benchmarks/tpcds/Tests/32.stable.out.int128 sql/benchmarks/tpcds/Tests/33.stable.out.int128 sql/benchmarks/tpcds/Tests/36.stable.out.int128 sql/benchmarks/tpcds/Tests/38.stable.out.int128 sql/benchmarks/tpcds/Tests/40.stable.out.int128 sql/benchmarks/tpcds/Tests/42.stable.out.int128 sql/benchmarks/tpcds/Tests/43.stable.out.int128 sql/benchmarks/tpcds/Tests/45.stable.out.int128 sql/benchmarks/tpcds/Tests/46.stable.out.int128 sql/benchmarks/tpcds/Tests/47.stable.out.int128 sql/benchmarks/tpcds/Tests/48.stable.out.int128 sql/benchmarks/tpcds/Tests/49.stable.out.int128 sql/benchmarks/tpcds/Tests/50.stable.out.int128 sql/benchmarks/tpcds/Tests/51.stable.out.int128 sql/benchmarks/tpcds/Tests/52.stable.out.int128 sql/benchmarks/tpcds/Tests/53.stable.out.int128 sql/benchmarks/tpcds/Tests/55.stable.out.int128 sql/benchmarks/tpcds/Tests/56.stable.out.int128 sql/benchmarks/tpcds/Tests/57.stable.out.int128 sql/benchmarks/tpcds/Tests/58.stable.out.int128 sql/benchmarks/tpcds/Tests/59.stable.out.int128 sql/benchmarks/tpcds/Tests/60.stable.out.int128 sql/benchmarks/tpcds/Tests/61.stable.out.int128 sql/benchmarks/tpcds/Tests/62.stable.out.int128 sql/benchmarks/tpcds/Tests/63.stable.out.int128 sql/benchmarks/tpcds/Tests/64.stable.out.int128 sql/benchmarks/tpcds/Tests/65.stable.out.int128 sql/benchmarks/tpcds/Tests/66.stable.out.int128 sql/benchmarks/tpcds/Tests/67.stable.out.int128 sql/benchmarks/tpcds/Tests/68.stable.out.int128 sql/benchmarks/tpcds/Tests/70.stable.out.int128 sql/benchmarks/tpcds/Tests/71.stable.out.int128 sql/benchmarks/tpcds/Tests/72.stable.out.int128 sql/benchmarks/tpcds/Tests/75.stable.out.int128 sql/benchmarks/tpcds/Tests/76.stable.out.int128 sql/benchmarks/tpcds/Tests/77.stable.out.int128 sql/benchmarks/tpcds/Tests/78.stable.out.int128 sql/benchmarks/tpcds/Tests/79.stable.out.int128 sql/benchmarks/tpcds/Tests/80.stable.out.int128 sql/benchmarks/tpcds/Tests/81.stable.out.int128 sql/benchmarks/tpcds/Tests/83.stable.out.int128 sql/benchmarks/tpcds/Tests/86.stable.out.int128 sql/benchmarks/tpcds/Tests/87.stable.out.int128 sql/benchmarks/tpcds/Tests/89.stable.out.int128 sql/benchmarks/tpcds/Tests/90.stable.out.int128 sql/benchmarks/tpcds/Tests/91.stable.out.int128 sql/benchmarks/tpcds/Tests/92.stable.out.int128 sql/benchmarks/tpcds/Tests/93.stable.out.int128 sql/benchmarks/tpcds/Tests/94.stable.out.int128 sql/benchmarks/tpcds/Tests/95.stable.out.int128 sql/benchmarks/tpcds/Tests/97.stable.out.int128 sql/benchmarks/tpcds/Tests/98.stable.out.int128 sql/benchmarks/tpcds/Tests/99.stable.out.int128 Modified Files: sql/benchmarks/tpcds/Tests/01.stable.out sql/benchmarks/tpcds/Tests/02.stable.out sql/benchmarks/tpcds/Tests/03.stable.out sql/benchmarks/tpcds/Tests/04.stable.out sql/benchmarks/tpcds/Tests/05.stable.out sql/benchmarks/tpcds/Tests/06.stable.out sql/benchmarks/tpcds/Tests/07.stable.out sql/benchmarks/tpcds/Tests/08.stable.out sql/benchmarks/tpcds/Tests/09.stable.out sql/benchmarks/tpcds/Tests/10.stable.out sql/benchmarks/tpcds/Tests/11.stable.out sql/benchmarks/tpcds/Tests/12.stable.out sql/benchmarks/tpcds/Tests/13.stable.out sql/benchmarks/tpcds/Tests/14a.stable.out sql/benchmarks/tpcds/Tests/14b.stable.out sql/benchmarks/tpcds/Tests/15.stable.out sql/benchmarks/tpcds/Tests/16.stable.out sql/benchmarks/tpcds/Tests/17.stable.out sql/benchmarks/tpcds/Tests/18.stable.out sql/benchmarks/tpcds/Tests/19.stable.out sql/benchmarks/tpcds/Tests/20.stable.out sql/benchmarks/tpcds/Tests/21.stable.out sql/benchmarks/tpcds/Tests/22.stable.out sql/benchmarks/tpcds/Tests/23a.stable.out sql/benchmarks/tpcds/Tests/23b.stable.out sql/benchmarks/tpcds/Tests/24a.stable.out sql/benchmarks/tpcds/Tests/24b.stable.out sql/benchmarks/tpcds/Tests/25.stable.out sql/benchmarks/tpcds/Tests/26.stable.out sql/benchmarks/tpcds/Tests/27.stable.out sql/benchmarks/tpcds/Tests/28.stable.out sql/benchmarks/tpcds/Tests/29.stable.out sql/benchmarks/tpcds/Tests/30.stable.out sql/benchmarks/tpcds/Tests/31.stable.out sql/benchmarks/tpcds/Tests/32.stable.out sql/benchmarks/tpcds/Tests/33.stable.out sql/benchmarks/tpcds/Tests/34.stable.out sql/benchmarks/tpcds/Tests/35.stable.out sql/benchmarks/tpcds/Tests/36.stable.out sql/benchmarks/tpcds/Tests/37.stable.out sql/benchmarks/tpcds/Tests/38.stable.out sql/benchmarks/tpcds/Tests/39a.stable.out sql/benchmarks/tpcds/Tests/39b.stable.out sql/benchmarks/tpcds/Tests/40.stable.out sql/benchmarks/tpcds/Tests/41.stable.out sql/benchmarks/tpcds/Tests/42.stable.out sql/benchmarks/tpcds/Tests/43.stable.out sql/benchmarks/tpcds/Tests/44.stable.out sql/benchmarks/tpcds/Tests/45.stable.out sql/benchmarks/tpcds/Tests/46.stable.out sql/benchmarks/tpcds/Tests/47.stable.out sql/benchmarks/tpcds/Tests/48.stable.out sql/benchmarks/tpcds/Tests/49.stable.out sql/benchmarks/tpcds/Tests/50.stable.out sql/benchmarks/tpcds/Tests/51.stable.out sql/benchmarks/tpcds/Tests/52.stable.out sql/benchmarks/tpcds/Tests/53.stable.out sql/benchmarks/tpcds/Tests/54.stable.out sql/benchmarks/tpcds/Tests/55.stable.out sql/benchmarks/tpcds/Tests/56.stable.out sql/benchmarks/tpcds/Tests/57.stable.out sql/benchmarks/tpcds/Tests/58.stable.out sql/benchmarks/tpcds/Tests/59.stable.out sql/benchmarks/tpcds/Tests/60.stable.out sql/benchmarks/tpcds/Tests/61.stable.out sql/benchmarks/tpcds/Tests/62.stable.out sql/benchmarks/tpcds/Tests/63.stable.out sql/benchmarks/tpcds/Tests/64.stable.out sql/benchmarks/tpcds/Tests/65.stable.out sql/benchmarks/tpcds/Tests/66.stable.out sql/benchmarks/tpcds/Tests/67.stable.out sql/benchmarks/tpcds/Tests/68.stable.out sql/benchmarks/tpcds/Tests/69.stable.out sql/benchmarks/tpcds/Tests/70.stable.out sql/benchmarks/tpcds/Tests/71.stable.out sql/benchmarks/tpcds/Tests/72.stable.out sql/benchmarks/tpcds/Tests/73.stable.out sql/benchmarks/tpcds/Tests/74.stable.out sql/benchmarks/tpcds/Tests/75.stable.out sql/benchmarks/tpcds/Tests/76.stable.out sql/benchmarks/tpcds/Tests/77.stable.out sql/benchmarks/tpcds/Tests/78.stable.out sql/benchmarks/tpcds/Tests/79.stable.out sql/benchmarks/tpcds/Tests/80.stable.out sql/benchmarks/tpcds/Tests/81.stable.out sql/benchmarks/tpcds/Tests/82.stable.out sql/benchmarks/tpcds/Tests/83.stable.out sql/benchmarks/tpcds/Tests/84.stable.out sql/benchmarks/tpcds/Tests/85.stable.out sql/benchmarks/tpcds/Tests/86.stable.out sql/benchmarks/tpcds/Tests/87.stable.out sql/benchmarks/tpcds/Tests/88.stable.out sql/benchmarks/tpcds/Tests/89.stable.out sql/benchmarks/tpcds/Tests/90.stable.out sql/benchmarks/tpcds/Tests/91.stable.out sql/benchmarks/tpcds/Tests/92.stable.out sql/benchmarks/tpcds/Tests/93.stable.out sql/benchmarks/tpcds/Tests/94.stable.out sql/benchmarks/tpcds/Tests/95.stable.out sql/benchmarks/tpcds/Tests/96.stable.out sql/benchmarks/tpcds/Tests/97.stable.out sql/benchmarks/tpcds/Tests/98.stable.out sql/benchmarks/tpcds/Tests/99.stable.out Branch: default Log Message:
Reapproved tests, also non-128 bit versions. diffs (truncated from 10617 to 300 lines): diff --git a/sql/benchmarks/tpcds/Tests/01.stable.out b/sql/benchmarks/tpcds/Tests/01.stable.out --- a/sql/benchmarks/tpcds/Tests/01.stable.out +++ b/sql/benchmarks/tpcds/Tests/01.stable.out @@ -1,9 +1,9 @@ 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '01` in directory 'sql/be 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 > +# 18:29:57 > +# 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 18:29:57 > #WITH customer_total_return AS # (SELECT sr_customer_sk AS ctr_customer_sk, @@ -36,12 +36,6 @@ Ready. # 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 @@ -147,6 +141,6 @@ Ready. [ "AAAAAAAAACBPAAAA" ] [ "AAAAAAAAACCHAAAA" ] -# 11:40:04 > -# 11:40:04 > "Done." -# 11:40:04 > +# 18:29:57 > +# 18:29:57 > "Done." +# 18:29:57 > diff --git a/sql/benchmarks/tpcds/Tests/02.stable.out b/sql/benchmarks/tpcds/Tests/02.stable.out --- a/sql/benchmarks/tpcds/Tests/02.stable.out +++ b/sql/benchmarks/tpcds/Tests/02.stable.out @@ -1,9 +1,9 @@ stdout of test '02` 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '02` in directory 'sql/be 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 > +# 18:29:57 > +# 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 18:29:57 > #WITH wscs AS # (SELECT sold_date_sk, @@ -36,16 +36,10 @@ Ready. # 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 % .y, .L116, .L120, .L122, .L124, .L126, .L130, .L132 # table_name % d_week_seq1, L116, L120, L122, L124, L126, L130, L132 # name % int, decimal, decimal, decimal, decimal, decimal, decimal, decimal # type -% 4, 40, 40, 40, 40, 40, 40, 40 # length +% 4, 20, 20, 20, 20, 20, 20, 20 # length [ 5270, 3.480, 2.150, 1.810, 1.680, 3.180, 3.290, 3.130 ] [ 5270, 3.480, 2.150, 1.810, 1.680, 3.180, 3.290, 3.130 ] [ 5270, 3.480, 2.150, 1.810, 1.680, 3.180, 3.290, 3.130 ] @@ -2560,10 +2554,6 @@ Ready. [ 5322, 5.610, 4.310, 0.990, 1.940, 1.740, 6.280, 5.350 ] [ 5322, 5.610, 4.310, 0.990, 1.940, 1.740, 6.280, 5.350 ] -# 12:33:01 > -# 12:33:01 > "Done." -# 12:33:01 > - -# 11:40:04 > -# 11:40:04 > "Done." -# 11:40:04 > +# 18:29:57 > +# 18:29:57 > "Done." +# 18:29:57 > diff --git a/sql/benchmarks/tpcds/Tests/02.stable.out b/sql/benchmarks/tpcds/Tests/02.stable.out.int128 copy from sql/benchmarks/tpcds/Tests/02.stable.out copy to sql/benchmarks/tpcds/Tests/02.stable.out.int128 --- a/sql/benchmarks/tpcds/Tests/02.stable.out +++ b/sql/benchmarks/tpcds/Tests/02.stable.out.int128 @@ -1,9 +1,9 @@ stdout of test '02` 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '02` in directory 'sql/be 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 > +# 18:29:57 > +# 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 18:29:57 > #WITH wscs AS # (SELECT sold_date_sk, @@ -36,12 +36,6 @@ Ready. # 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 % .y, .L116, .L120, .L122, .L124, .L126, .L130, .L132 # table_name % d_week_seq1, L116, L120, L122, L124, L126, L130, L132 # name % int, decimal, decimal, decimal, decimal, decimal, decimal, decimal # type @@ -2560,10 +2554,6 @@ Ready. [ 5322, 5.610, 4.310, 0.990, 1.940, 1.740, 6.280, 5.350 ] [ 5322, 5.610, 4.310, 0.990, 1.940, 1.740, 6.280, 5.350 ] -# 12:33:01 > -# 12:33:01 > "Done." -# 12:33:01 > - -# 11:40:04 > -# 11:40:04 > "Done." -# 11:40:04 > +# 18:29:57 > +# 18:29:57 > "Done." +# 18:29:57 > diff --git a/sql/benchmarks/tpcds/Tests/03.stable.out b/sql/benchmarks/tpcds/Tests/03.stable.out --- a/sql/benchmarks/tpcds/Tests/03.stable.out +++ b/sql/benchmarks/tpcds/Tests/03.stable.out @@ -1,9 +1,9 @@ stdout of test '03` 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '03` in directory 'sql/be 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 > +# 18:29:57 > +# 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 18:29:57 > #SELECT dt.d_year, # item.i_brand_id brand_id, @@ -36,16 +36,10 @@ Ready. # AND item.i_manufact_id = 128 # AND dt.d_moy=11 #GROUP BY dt.d_year, -# item.i_brand, -# item.i_brand_id -#ORDER BY dt.d_year, -# sum_agg DESC, -# brand_id -#LIMIT 100; % sys.dt, sys.L3, sys.L5, sys.L10 # table_name % d_year, brand_id, brand, sum_agg # name % int, int, char, decimal # type -% 4, 8, 50, 40 # length +% 4, 8, 50, 20 # length [ 1998, 2001001, "amalgimporto #1", 45162.45 ] [ 1998, 5003001, "exportischolar #1", 40600.56 ] [ 1998, 5001001, "amalgscholar #1", 32515.11 ] @@ -136,6 +130,6 @@ Ready. [ 2002, 2001001, "exportischolar #2", 4162.39 ] [ 2002, 5001001, "amalgscholar #1", 3537.49 ] -# 11:40:04 > -# 11:40:04 > "Done." -# 11:40:04 > +# 18:29:57 > +# 18:29:57 > "Done." +# 18:29:57 > diff --git a/sql/benchmarks/tpcds/Tests/03.stable.out b/sql/benchmarks/tpcds/Tests/03.stable.out.int128 copy from sql/benchmarks/tpcds/Tests/03.stable.out copy to sql/benchmarks/tpcds/Tests/03.stable.out.int128 --- a/sql/benchmarks/tpcds/Tests/03.stable.out +++ b/sql/benchmarks/tpcds/Tests/03.stable.out.int128 @@ -1,9 +1,9 @@ stdout of test '03` 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '03` in directory 'sql/be 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 > +# 18:29:57 > +# 18:29:57 > "mclient" "-lsql" "-ftest" "-tnone" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-16393" "--port=30709" +# 18:29:57 > #SELECT dt.d_year, # item.i_brand_id brand_id, @@ -36,12 +36,6 @@ Ready. # AND item.i_manufact_id = 128 # AND dt.d_moy=11 #GROUP BY dt.d_year, -# item.i_brand, -# item.i_brand_id -#ORDER BY dt.d_year, -# sum_agg DESC, -# brand_id -#LIMIT 100; % sys.dt, sys.L3, sys.L5, sys.L10 # table_name % d_year, brand_id, brand, sum_agg # name % int, int, char, decimal # type @@ -136,6 +130,6 @@ Ready. [ 2002, 2001001, "exportischolar #2", 4162.39 ] [ 2002, 5001001, "amalgscholar #1", 3537.49 ] -# 11:40:04 > -# 11:40:04 > "Done." -# 11:40:04 > +# 18:29:57 > +# 18:29:57 > "Done." +# 18:29:57 > diff --git a/sql/benchmarks/tpcds/Tests/04.stable.out b/sql/benchmarks/tpcds/Tests/04.stable.out --- a/sql/benchmarks/tpcds/Tests/04.stable.out +++ b/sql/benchmarks/tpcds/Tests/04.stable.out @@ -1,9 +1,9 @@ stdout of test '04` 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 > +# 18:29:57 > +# 18:29:57 > "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" +# 18:29:57 > # MonetDB 5 server v11.32.0 (hg id: edafb9f9a3c6+79d16e518d38+) # This is an unreleased version @@ -20,9 +20,9 @@ stdout of test '04` in directory 'sql/be _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
