MonetDB: default - Updated TPC-DS queries.

[Sjoerd Mullender]

Changeset: fec453659af1 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=fec453659af1
Modified Files:
        sql/benchmarks/tpcds/Tests/39a.sql
        sql/benchmarks/tpcds/Tests/58.sql
        sql/benchmarks/tpcds/Tests/72.sql
        sql/benchmarks/tpcds/Tests/99.sql
Branch: default
Log Message:

Updated TPC-DS queries.


diffs (64 lines):

diff --git a/sql/benchmarks/tpcds/Tests/39a.sql 
b/sql/benchmarks/tpcds/Tests/39a.sql
--- a/sql/benchmarks/tpcds/Tests/39a.sql
+++ b/sql/benchmarks/tpcds/Tests/39a.sql
@@ -14,7 +14,7 @@ WITH inv AS
              w_warehouse_sk,
              i_item_sk,
              d_moy,
-             stddev_samp(inv_quantity_on_hand) stdev,
+             stddev_samp(inv_quantity_on_hand)*1.000 stdev,
              avg(inv_quantity_on_hand) mean
       FROM inventory,
            item,
diff --git a/sql/benchmarks/tpcds/Tests/58.sql 
b/sql/benchmarks/tpcds/Tests/58.sql
--- a/sql/benchmarks/tpcds/Tests/58.sql
+++ b/sql/benchmarks/tpcds/Tests/58.sql
@@ -65,7 +65,7 @@ WHERE ss_items.item_id=cs_items.item_id
   AND cs_item_rev BETWEEN 0.9 * ws_item_rev AND 1.1 * ws_item_rev
   AND ws_item_rev BETWEEN 0.9 * ss_item_rev AND 1.1 * ss_item_rev
   AND ws_item_rev BETWEEN 0.9 * cs_item_rev AND 1.1 * cs_item_rev
-ORDER BY item_id,
+ORDER BY ss_items.item_id,
          ss_item_rev
 LIMIT 100;
 
diff --git a/sql/benchmarks/tpcds/Tests/72.sql 
b/sql/benchmarks/tpcds/Tests/72.sql
--- a/sql/benchmarks/tpcds/Tests/72.sql
+++ b/sql/benchmarks/tpcds/Tests/72.sql
@@ -34,6 +34,6 @@ GROUP BY i_item_desc,
 ORDER BY total_cnt DESC,
          i_item_desc,
          w_warehouse_name,
-         d_week_seq
+         d1.d_week_seq
 LIMIT 100;
 
diff --git a/sql/benchmarks/tpcds/Tests/99.sql 
b/sql/benchmarks/tpcds/Tests/99.sql
--- a/sql/benchmarks/tpcds/Tests/99.sql
+++ b/sql/benchmarks/tpcds/Tests/99.sql
@@ -1,6 +1,6 @@
 SELECT w_substr ,
        sm_type ,
-       cc_name ,
+       LOWER(cc_name) cc_name_lower ,
        sum(CASE
                WHEN (cs_ship_date_sk - cs_sold_date_sk <= 30) THEN 1
                ELSE 0
@@ -25,8 +25,7 @@ SELECT w_substr ,
                ELSE 0
            END) AS ">120 days"
 FROM catalog_sales ,
-  (SELECT SUBSTRING(w_warehouse_name,1,20) w_substr,
-          *
+  (SELECT SUBSTRING(w_warehouse_name,1,20) w_substr, *
    FROM warehouse) AS sq1 ,
      ship_mode ,
      call_center ,
@@ -41,6 +40,6 @@ GROUP BY w_substr ,
          cc_name
 ORDER BY w_substr ,
          sm_type ,
-         cc_name
+        cc_name_lower
 LIMIT 100;
 
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list