Changeset: 8c76985a39ed for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/8c76985a39ed
Modified Files:
sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.test
Branch: ordered-set-aggregates
Log Message:
Merge with default branch.
diffs (truncated from 2059 to 300 lines):
diff --git a/sql/benchmarks/tpcds/Tests/q12.test
b/sql/benchmarks/tpcds/Tests/q12.test
--- a/sql/benchmarks/tpcds/Tests/q12.test
+++ b/sql/benchmarks/tpcds/Tests/q12.test
@@ -1,4 +1,4 @@
-query TTTTRRR nosort
+query TTTTRRR rowsort
-- query 12
select i_item_id
,i_item_desc
@@ -32,5 +32,5 @@ order by
,revenueratio
limit 100
----
-700 values hashing to cc38887f721783ffdee1b5c309408027
+700 values hashing to 7d238d4326fe5e153af125b9bf93ad1b
diff --git a/sql/benchmarks/tpcds/Tests/q14-1.test
b/sql/benchmarks/tpcds/Tests/q14-1.test
--- a/sql/benchmarks/tpcds/Tests/q14-1.test
+++ b/sql/benchmarks/tpcds/Tests/q14-1.test
@@ -1,4 +1,4 @@
-query TIIIRI nosort
+query TIIIRI rowsort
-- query 14-1
with cross_items as
(select i_item_sk ss_item_sk
@@ -102,5 +102,5 @@ with cross_items as
order by channel,i_brand_id,i_class_id,i_category_id
limit 100
----
-600 values hashing to 52579efe8953b7c7dd760a3a5f5f5a7a
+600 values hashing to 921d62692c44049ed3bc8157bb3c9f4c
diff --git a/sql/benchmarks/tpcds/Tests/q14a-1.test
b/sql/benchmarks/tpcds/Tests/q14a-1.test
--- a/sql/benchmarks/tpcds/Tests/q14a-1.test
+++ b/sql/benchmarks/tpcds/Tests/q14a-1.test
@@ -1,4 +1,4 @@
-query TIIIRI nosort
+query TIIIRI rowsort
-- query 14a-1
with cross_items as
(select i_item_sk ss_item_sk
@@ -118,5 +118,5 @@ from (
order by channel, i_brand_id, i_class_id, i_category_id
limit 100
----
-600 values hashing to 52579efe8953b7c7dd760a3a5f5f5a7a
+600 values hashing to 921d62692c44049ed3bc8157bb3c9f4c
diff --git a/sql/benchmarks/tpcds/Tests/q15.test
b/sql/benchmarks/tpcds/Tests/q15.test
--- a/sql/benchmarks/tpcds/Tests/q15.test
+++ b/sql/benchmarks/tpcds/Tests/q15.test
@@ -1,4 +1,4 @@
-query TR nosort
+query TR rowsort
-- query 15
select ca_zip
,sum(cs_sales_price)
@@ -18,5 +18,5 @@ select ca_zip
order by ca_zip
limit 100
----
-200 values hashing to 947c45a1161972fa2d6d9aefeaf39d49
+200 values hashing to 84948a87a3387b914146971155fa42f7
diff --git a/sql/benchmarks/tpcds/Tests/q18.test
b/sql/benchmarks/tpcds/Tests/q18.test
--- a/sql/benchmarks/tpcds/Tests/q18.test
+++ b/sql/benchmarks/tpcds/Tests/q18.test
@@ -1,4 +1,4 @@
-query TTTTRRRRRRR nosort
+query TTTTRRRRRRR rowsort
-- query 18
select i_item_id,
ca_country,
@@ -32,5 +32,5 @@ select i_item_id,
i_item_id
limit 100
----
-1100 values hashing to ac4152e80ebb79336fbaf17253014111
+1100 values hashing to 0f8c410ff9a097468fafde146a80a3a8
diff --git a/sql/benchmarks/tpcds/Tests/q18a.test
b/sql/benchmarks/tpcds/Tests/q18a.test
--- a/sql/benchmarks/tpcds/Tests/q18a.test
+++ b/sql/benchmarks/tpcds/Tests/q18a.test
@@ -1,4 +1,4 @@
-query TTTTRRRRRRR nosort
+query TTTTRRRRRRR rowsort
-- query 18a
with results as
(select i_item_id,
@@ -54,5 +54,5 @@ with results as
order by ca_country, ca_state, ca_county, i_item_id
limit 100
----
-1100 values hashing to ac4152e80ebb79336fbaf17253014111
+1100 values hashing to 0f8c410ff9a097468fafde146a80a3a8
diff --git a/sql/benchmarks/tpcds/Tests/q19.test
b/sql/benchmarks/tpcds/Tests/q19.test
--- a/sql/benchmarks/tpcds/Tests/q19.test
+++ b/sql/benchmarks/tpcds/Tests/q19.test
@@ -1,4 +1,4 @@
-query ITITR nosort
+query ITITR rowsort
-- query 19
select i_brand_id brand_id, i_brand brand, i_manufact_id, i_manufact,
sum(ss_ext_sales_price) ext_price
@@ -23,5 +23,5 @@ select i_brand_id brand_id, i_brand bra
,i_manufact
limit 100
----
-500 values hashing to 7079f7f6c66ba635b092e2a2f474d3ba
+500 values hashing to 8e3fed4d69766d0426b20c8199a60d4d
diff --git a/sql/benchmarks/tpcds/Tests/q20.test
b/sql/benchmarks/tpcds/Tests/q20.test
--- a/sql/benchmarks/tpcds/Tests/q20.test
+++ b/sql/benchmarks/tpcds/Tests/q20.test
@@ -1,4 +1,4 @@
-query TTTTRRR nosort
+query TTTTRRR rowsort
-- query 20
select i_item_id
,i_item_desc
@@ -28,5 +28,5 @@ select i_item_id
,revenueratio
limit 100
----
-700 values hashing to 4ebe9ff747adc57b86a5ba3433d9aaed
+700 values hashing to 78f72ae6989511bbf964b2458f74c99d
diff --git a/sql/benchmarks/tpcds/Tests/q22.test
b/sql/benchmarks/tpcds/Tests/q22.test
--- a/sql/benchmarks/tpcds/Tests/q22.test
+++ b/sql/benchmarks/tpcds/Tests/q22.test
@@ -1,4 +1,4 @@
-query TTTTR nosort
+query TTTTR rowsort
-- query 22
select i_product_name
,i_brand
@@ -18,5 +18,5 @@ select i_product_name
order by qoh, i_product_name, i_brand, i_class, i_category
limit 100
----
-500 values hashing to e7a50f3285e4c45f5d327c1ed71f0338
+500 values hashing to e1068d9b6bd311e171034af47cfa9e0e
diff --git a/sql/benchmarks/tpcds/Tests/q22a.test
b/sql/benchmarks/tpcds/Tests/q22a.test
--- a/sql/benchmarks/tpcds/Tests/q22a.test
+++ b/sql/benchmarks/tpcds/Tests/q22a.test
@@ -1,4 +1,4 @@
-query TTTTR nosort
+query TTTTR rowsort
-- query 22a
with results as
(select i_product_name
@@ -38,5 +38,5 @@ from results)
order by qoh, i_product_name, i_brand, i_class, i_category
limit 100
----
-500 values hashing to e7a50f3285e4c45f5d327c1ed71f0338
+500 values hashing to e1068d9b6bd311e171034af47cfa9e0e
diff --git a/sql/benchmarks/tpcds/Tests/q23-2.test
b/sql/benchmarks/tpcds/Tests/q23-2.test
--- a/sql/benchmarks/tpcds/Tests/q23-2.test
+++ b/sql/benchmarks/tpcds/Tests/q23-2.test
@@ -1,4 +1,4 @@
-query TTR nosort
+query TTR rowsort
-- query 23-2
with frequent_ss_items as
(select substr(i_item_desc,1,30) itemdesc,i_item_sk item_sk,d_date
solddate,count(*) cnt
@@ -56,9 +56,6 @@ query TTR nosort
order by c_last_name,c_first_name,sales
limit 100
----
-NULL
-Robert
-598.860
Brown
Monika
6031.520
@@ -68,4 +65,7 @@ 727.570
Green
Jesse
9672.960
+NULL
+Robert
+598.860
diff --git a/sql/benchmarks/tpcds/Tests/q27.test
b/sql/benchmarks/tpcds/Tests/q27.test
--- a/sql/benchmarks/tpcds/Tests/q27.test
+++ b/sql/benchmarks/tpcds/Tests/q27.test
@@ -1,4 +1,4 @@
-query TTIRRRR nosort
+query TTIRRRR rowsort
-- query 27
select i_item_id,
s_state, grouping(s_state) g_state,
@@ -21,5 +21,5 @@ select i_item_id,
,s_state
limit 100
----
-700 values hashing to 1dd7e54139ea526385fb65f2d9d3fa7e
+700 values hashing to 4768cbb63a3c1944e5a2bfbd752ba99a
diff --git a/sql/benchmarks/tpcds/Tests/q27a.test
b/sql/benchmarks/tpcds/Tests/q27a.test
--- a/sql/benchmarks/tpcds/Tests/q27a.test
+++ b/sql/benchmarks/tpcds/Tests/q27a.test
@@ -1,4 +1,4 @@
-query TTIRRRR nosort
+query TTIRRRR rowsort
-- query 27a
with results as
(select i_item_id,
@@ -34,5 +34,5 @@ with results as
order by i_item_id, s_state
limit 100
----
-700 values hashing to 1dd7e54139ea526385fb65f2d9d3fa7e
+700 values hashing to 4768cbb63a3c1944e5a2bfbd752ba99a
diff --git a/sql/benchmarks/tpcds/Tests/q3.test
b/sql/benchmarks/tpcds/Tests/q3.test
--- a/sql/benchmarks/tpcds/Tests/q3.test
+++ b/sql/benchmarks/tpcds/Tests/q3.test
@@ -1,4 +1,4 @@
-query IITR nosort
+query IITR rowsort
-- query 3
select dt.d_year
,item.i_brand_id brand_id
@@ -19,5 +19,5 @@ select dt.d_year
,brand_id
limit 100
----
-356 values hashing to 5ae1597125b92c88076a00ca5577433f
+356 values hashing to f622c5c5ffff908edcd28dd716f580df
diff --git a/sql/benchmarks/tpcds/Tests/q30.test
b/sql/benchmarks/tpcds/Tests/q30.test
--- a/sql/benchmarks/tpcds/Tests/q30.test
+++ b/sql/benchmarks/tpcds/Tests/q30.test
@@ -1,4 +1,4 @@
-query TTTTTIIITTTIR nosort
+query TTTTTIIITTTIR rowsort
-- query 30
with customer_total_return as
(select wr_returning_customer_sk as ctr_customer_sk
@@ -29,5 +29,5 @@ with customer_total_return as
,c_last_review_date,ctr_total_return
limit 100
----
-1300 values hashing to 28e7c87e0d9219a5b33c816332174184
+1300 values hashing to 46f76e63ac60a7b540f258c4ad0fbfdb
diff --git a/sql/benchmarks/tpcds/Tests/q33.test
b/sql/benchmarks/tpcds/Tests/q33.test
--- a/sql/benchmarks/tpcds/Tests/q33.test
+++ b/sql/benchmarks/tpcds/Tests/q33.test
@@ -1,4 +1,4 @@
-query IR nosort
+query IR rowsort
-- query 33
with ss as (
select
@@ -73,5 +73,5 @@ where i_category in ('Electronics'))
order by total_sales
limit 100
----
-200 values hashing to 8f68d4704fa7569916502c33808a5df4
+200 values hashing to cb0042b696c91912080cb5edb1ca409d
diff --git a/sql/benchmarks/tpcds/Tests/q34.test
b/sql/benchmarks/tpcds/Tests/q34.test
--- a/sql/benchmarks/tpcds/Tests/q34.test
+++ b/sql/benchmarks/tpcds/Tests/q34.test
@@ -1,4 +1,4 @@
-query TTTTII nosort
+query TTTTII rowsort
-- query 34
select c_last_name
,c_first_name
@@ -29,5 +29,5 @@ select c_last_name
and cnt between 15 and 20
order by c_last_name,c_first_name,c_salutation,c_preferred_cust_flag desc,
ss_ticket_number
----
-2706 values hashing to c6193fa5c1176ce7a13e736a507a5739
+2706 values hashing to 9e935240f07fd89130c1d0103fe0e495
diff --git a/sql/benchmarks/tpcds/Tests/q35.test
b/sql/benchmarks/tpcds/Tests/q35.test
--- a/sql/benchmarks/tpcds/Tests/q35.test
+++ b/sql/benchmarks/tpcds/Tests/q35.test
@@ -1,4 +1,4 @@
-query TTTIIIIRIIIIRIIIIR nosort
+query TTTIIIIRIIIIRIIIIR rowsort
-- query 35
select
ca_state,
@@ -56,5 +56,5 @@ select
cd_dep_college_count
limit 100
----
-1800 values hashing to 86c162969882cb545e292aecd3488c56
+1800 values hashing to 1d2ac51e16f61668fdfcded8eb917f10
diff --git a/sql/benchmarks/tpcds/Tests/q35a.test
b/sql/benchmarks/tpcds/Tests/q35a.test
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org
