Changeset: 15366c847d81 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/15366c847d81
Modified Files:
sql/benchmarks/tpcds/Tests/q77a.test
sql/benchmarks/tpcds/Tests/q79.test
Branch: Dec2025
Log Message:
Fix ordering.
diffs (40 lines):
diff --git a/sql/benchmarks/tpcds/Tests/q77a.test
b/sql/benchmarks/tpcds/Tests/q77a.test
--- a/sql/benchmarks/tpcds/Tests/q77a.test
+++ b/sql/benchmarks/tpcds/Tests/q77a.test
@@ -113,12 +113,12 @@ with ss as
union
select NULL AS channel, NULL AS id, sum(sales) as sales, sum("returns") as
"returns", sum(profit) as profit from results
) foo
-order by channel, id
+order by channel, id, sales desc
limit 100
----
NULL NULL 239408999.27 6268037.63 -66317520.23
+catalog channel NULL 80882163.55 1979001.64 -8728786.05
catalog channel NULL 107782.51 NULL NULL
-catalog channel NULL 80882163.55 1979001.64 -8728786.05
catalog channel 1 26577012.33 748682.72 -2713442.40
catalog channel 2 28100609.53 649998.86 -3157809.22
catalog channel 5 26096759.18 580320.06 -2857534.43
diff --git a/sql/benchmarks/tpcds/Tests/q79.test
b/sql/benchmarks/tpcds/Tests/q79.test
--- a/sql/benchmarks/tpcds/Tests/q79.test
+++ b/sql/benchmarks/tpcds/Tests/q79.test
@@ -20,7 +20,7 @@ select
and store.s_number_employees between 200 and 295
group by ss_ticket_number,ss_customer_sk,ss_addr_sk,store.s_city)
ms,customer
where ss_customer_sk = c_customer_sk
- order by c_last_name,c_first_name,substr(s_city,1,30), profit
+ order by c_last_name,c_first_name,substr(s_city,1,30), profit,
ss_ticket_number
limit 100
----
NULL NULL Fairview 158139 3721.39 -23039.01
@@ -40,8 +40,8 @@ NULL NULL Fairview 230904 0.00 -2575.26
NULL NULL Fairview 66717 1521.09 -2431.95
NULL NULL Fairview 198542 1082.91 -1789.20
NULL NULL Fairview 7153 9.96 -984.62
+NULL NULL Midway 103268 0.00 NULL
NULL NULL Midway 113867 NULL NULL
-NULL NULL Midway 103268 0.00 NULL
NULL NULL Midway 9441 1109.31 -26407.61
NULL NULL Midway 24453 3762.75 -23692.00
NULL NULL Midway 2018 29.76 -22410.59
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
