Changeset: 4b0b40d3c297 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/4b0b40d3c297 Modified Files: sql/benchmarks/tpcds/Tests/alter.reqtests sql/benchmarks/tpcds/Tests/check.test sql/benchmarks/tpcds/Tests/load.test.in Branch: Dec2025 Log Message:
Change load order to obey foreign key refs; make check test more robust. Loading of tables is now done in an order so that foreign keys of any table being loaded only refer to already loaded tables. The check test select a limited number of rows from each table. It now adds an order by clause on the primary keys so that the selection is consistent. diffs (truncated from 3705 to 300 lines): diff --git a/sql/benchmarks/tpcds/Tests/alter.reqtests b/sql/benchmarks/tpcds/Tests/alter.reqtests --- a/sql/benchmarks/tpcds/Tests/alter.reqtests +++ b/sql/benchmarks/tpcds/Tests/alter.reqtests @@ -1,1 +1,1 @@ -load +create diff --git a/sql/benchmarks/tpcds/Tests/check.test b/sql/benchmarks/tpcds/Tests/check.test --- a/sql/benchmarks/tpcds/Tests/check.test +++ b/sql/benchmarks/tpcds/Tests/check.test @@ -1,146 +1,264 @@ +hash-threshold 1000 + statement ok start transaction -query I rowsort +query I nosort select count(*) from dbgen_version ---- 1 -query I rowsort +query I nosort select count(*) from customer_address ---- 50000 -query I rowsort +query I nosort select count(*) from customer_demographics ---- 1920800 -query I rowsort +query I nosort select count(*) from date_dim ---- 73049 -query I rowsort +query I nosort select count(*) from warehouse ---- 5 -query I rowsort +query I nosort select count(*) from ship_mode ---- 20 -query I rowsort +query I nosort select count(*) from time_dim ---- 86400 -query I rowsort +query I nosort select count(*) from reason ---- 35 -query I rowsort +query I nosort select count(*) from income_band ---- 20 -query I rowsort +query I nosort select count(*) from item ---- 18000 -query I rowsort +query I nosort select count(*) from store ---- 12 -query I rowsort +query I nosort select count(*) from call_center ---- 6 -query I rowsort +query I nosort select count(*) from customer ---- 100000 -query I rowsort +query I nosort select count(*) from web_site ---- 30 -query I rowsort +query I nosort select count(*) from store_returns ---- 287514 -query I rowsort +query I nosort select count(*) from household_demographics ---- 7200 -query I rowsort +query I nosort select count(*) from web_page ---- 60 -query I rowsort +query I nosort select count(*) from promotion ---- 300 -query I rowsort +query I nosort select count(*) from catalog_page ---- 11718 -query I rowsort +query I nosort select count(*) from inventory ---- 11745000 -query I rowsort +query I nosort select count(*) from catalog_returns ---- 144067 -query I rowsort +query I nosort select count(*) from web_returns ---- 71763 -query I rowsort +query I nosort select count(*) from web_sales ---- 719384 -query I rowsort +query I nosort select count(*) from catalog_sales ---- 1441548 -query I rowsort +query I nosort select count(*) from store_sales ---- 2880404 -query TTTT rowsort -select * from dbgen_version limit 9 +query TTTT nosort +select * from dbgen_version ---- 2.10.0 2018-10-22 17:17:42 -DIR qual -query ITTTTTTTTTTDT rowsort +query ITTTTTTTTTTDT nosort select * from customer_address limit 9 ---- -117 values hashing to 80773b266492865dfe2a221a7fcb7ae4 +1 +AAAAAAAABAAAAAAA +18 +Jackson +Parkway +Suite 280 +Fairfield +Maricopa County +AZ +86192 +United States +-7.00 +condo +2 +AAAAAAAACAAAAAAA +362 +Washington 6th +RD +Suite 80 +Fairview +Taos County +NM +85709 +United States +-7.00 +condo +3 +AAAAAAAADAAAAAAA +585 +Dogwood Washington +Circle +Suite Q +Pleasant Valley +York County +PA +12477 +United States +-5.00 +single family +4 +AAAAAAAAEAAAAAAA +111 +Smith +Wy +Suite A +Oak Ridge +Kit Carson County +CO +88371 +United States +-7.00 +condo +5 +AAAAAAAAFAAAAAAA +31 +College +Blvd +Suite 180 +Glendale +Barry County +MO +63951 +United States +-6.00 +single family +6 +AAAAAAAAGAAAAAAA +59 +Williams Sixth +Parkway +Suite 100 +Lakeview +Chelan County +WA +98579 +United States +-8.00 +single family +7 +AAAAAAAAHAAAAAAA +NULL +Hill 7th +Road +Suite U +Farmington +NULL +NULL +39145 +United States +NULL +NULL +8 +AAAAAAAAIAAAAAAA +875 +Lincoln +Ct. +Suite Y +Union +Bledsoe County +TN +38721 +United States +-5.00 +apartment +9 +AAAAAAAAJAAAAAAA +819 +1st Laurel +Ave +Suite 70 +New Hope +Perry County +AL +39431 +United States +-6.00 +condo -query ITTTITIII rowsort -select * from customer_demographics limit 9 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
