Changeset: d3d83c351adf for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=d3d83c351adf
Modified Files:
sql/benchmarks/tpcds/Tests/79.sql
sql/benchmarks/tpcds/Tests/79.stable.out
sql/benchmarks/tpcds/Tests/79.stable.out.int128
sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
Branch: linear-hashing
Log Message:
Added another order by column for tpc-ds query 79, because in the previous
output two rows had the same sorting keys which caused the order to be undefined
diffs (50 lines):
diff --git a/sql/benchmarks/tpcds/Tests/79.sql
b/sql/benchmarks/tpcds/Tests/79.sql
--- a/sql/benchmarks/tpcds/Tests/79.sql
+++ b/sql/benchmarks/tpcds/Tests/79.sql
@@ -34,6 +34,7 @@ WHERE ss_customer_sk = c_customer_sk
ORDER BY c_last_name,
c_first_name,
SUBSTRING(s_city,1,30),
- profit
+ profit,
+ ss_ticket_number
LIMIT 100;
diff --git a/sql/benchmarks/tpcds/Tests/79.stable.out
b/sql/benchmarks/tpcds/Tests/79.stable.out
--- a/sql/benchmarks/tpcds/Tests/79.stable.out
+++ b/sql/benchmarks/tpcds/Tests/79.stable.out
@@ -63,8 +63,8 @@ stdout of test '79` in directory 'sql/be
[ 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 ]
diff --git a/sql/benchmarks/tpcds/Tests/79.stable.out.int128
b/sql/benchmarks/tpcds/Tests/79.stable.out.int128
--- a/sql/benchmarks/tpcds/Tests/79.stable.out.int128
+++ b/sql/benchmarks/tpcds/Tests/79.stable.out.int128
@@ -63,8 +63,8 @@ stdout of test '79` in directory 'sql/be
[ 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 ]
diff --git
a/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
b/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
---
a/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
+++
b/sql/test/BugTracker-2009/Tests/use_order_column_first.SF-2686008.stable.out
@@ -97,7 +97,7 @@ project (
project (
| group by (
| | table(sys.sorted) [ "sorted"."a", "sorted"."b" ] COUNT
-| ) [ "sorted"."b", "sorted"."a" ] [ "sorted"."b", "sorted"."a" ]
+| ) [ "sorted"."a", "sorted"."b" ] [ "sorted"."b", "sorted"."a" ]
) [ "sorted"."a", "sorted"."b" ]
#drop table unsorted;
#drop table sorted;
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
