Changeset: 2c86eef1016a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2c86eef1016a Modified Files: sql/benchmarks/tpcds/Tests/check.test sql/benchmarks/tpcds/Tests/create.test sql/benchmarks/tpcds/Tests/drop.test sql/benchmarks/tpcds/Tests/load.test.in sql/benchmarks/tpcds/Tests/q1.test sql/benchmarks/tpcds/Tests/q10.test sql/benchmarks/tpcds/Tests/q10a.test sql/benchmarks/tpcds/Tests/q11.test sql/benchmarks/tpcds/Tests/q12.test sql/benchmarks/tpcds/Tests/q13.test sql/benchmarks/tpcds/Tests/q14-1.test sql/benchmarks/tpcds/Tests/q14-2.test sql/benchmarks/tpcds/Tests/q14a-1.test sql/benchmarks/tpcds/Tests/q14a-2.test sql/benchmarks/tpcds/Tests/q15.test sql/benchmarks/tpcds/Tests/q16.test sql/benchmarks/tpcds/Tests/q17.test sql/benchmarks/tpcds/Tests/q18.test sql/benchmarks/tpcds/Tests/q18a.test sql/benchmarks/tpcds/Tests/q19.test sql/benchmarks/tpcds/Tests/q2.test sql/benchmarks/tpcds/Tests/q20.test sql/benchmarks/tpcds/Tests/q21.test sql/benchmarks/tpcds/Tests/q22.test sql/benchmarks/tpcds/Tests/q22a.test sql/benchmarks/tpcds/Tests/q23-1.test sql/benchmarks/tpcds/Tests/q23-2.test sql/benchmarks/tpcds/Tests/q24-1.test sql/benchmarks/tpcds/Tests/q24-2.test sql/benchmarks/tpcds/Tests/q25.test sql/benchmarks/tpcds/Tests/q26.test sql/benchmarks/tpcds/Tests/q27.test sql/benchmarks/tpcds/Tests/q27a.test sql/benchmarks/tpcds/Tests/q28.test sql/benchmarks/tpcds/Tests/q29.test sql/benchmarks/tpcds/Tests/q3.test sql/benchmarks/tpcds/Tests/q30.test sql/benchmarks/tpcds/Tests/q31.test sql/benchmarks/tpcds/Tests/q32.test sql/benchmarks/tpcds/Tests/q33.test sql/benchmarks/tpcds/Tests/q34.test sql/benchmarks/tpcds/Tests/q35.test sql/benchmarks/tpcds/Tests/q35a.test sql/benchmarks/tpcds/Tests/q36.test sql/benchmarks/tpcds/Tests/q36a.test sql/benchmarks/tpcds/Tests/q37.test sql/benchmarks/tpcds/Tests/q38.test sql/benchmarks/tpcds/Tests/q39-1.test sql/benchmarks/tpcds/Tests/q39-2.test sql/benchmarks/tpcds/Tests/q4.test sql/benchmarks/tpcds/Tests/q40.test sql/benchmarks/tpcds/Tests/q41.test sql/benchmarks/tpcds/Tests/q42.test sql/benchmarks/tpcds/Tests/q43.test sql/benchmarks/tpcds/Tests/q44.test sql/benchmarks/tpcds/Tests/q45.test sql/benchmarks/tpcds/Tests/q46.test sql/benchmarks/tpcds/Tests/q47.test sql/benchmarks/tpcds/Tests/q48.test sql/benchmarks/tpcds/Tests/q49.test sql/benchmarks/tpcds/Tests/q5.test sql/benchmarks/tpcds/Tests/q50.test sql/benchmarks/tpcds/Tests/q51.test sql/benchmarks/tpcds/Tests/q52.test sql/benchmarks/tpcds/Tests/q53.test sql/benchmarks/tpcds/Tests/q54.test sql/benchmarks/tpcds/Tests/q55.test sql/benchmarks/tpcds/Tests/q56.test sql/benchmarks/tpcds/Tests/q57.test sql/benchmarks/tpcds/Tests/q58.test sql/benchmarks/tpcds/Tests/q59.test sql/benchmarks/tpcds/Tests/q5a.test sql/benchmarks/tpcds/Tests/q6.test sql/benchmarks/tpcds/Tests/q60.test sql/benchmarks/tpcds/Tests/q61.test sql/benchmarks/tpcds/Tests/q62.test sql/benchmarks/tpcds/Tests/q63.test sql/benchmarks/tpcds/Tests/q64.test sql/benchmarks/tpcds/Tests/q65.test sql/benchmarks/tpcds/Tests/q66.test sql/benchmarks/tpcds/Tests/q67.test sql/benchmarks/tpcds/Tests/q67a.test sql/benchmarks/tpcds/Tests/q68.test sql/benchmarks/tpcds/Tests/q69.test sql/benchmarks/tpcds/Tests/q7.test sql/benchmarks/tpcds/Tests/q70.test sql/benchmarks/tpcds/Tests/q70a.test sql/benchmarks/tpcds/Tests/q71.test sql/benchmarks/tpcds/Tests/q72.test sql/benchmarks/tpcds/Tests/q73.test sql/benchmarks/tpcds/Tests/q74.test sql/benchmarks/tpcds/Tests/q75.test sql/benchmarks/tpcds/Tests/q76.test sql/benchmarks/tpcds/Tests/q77.test sql/benchmarks/tpcds/Tests/q77a.test sql/benchmarks/tpcds/Tests/q78.test sql/benchmarks/tpcds/Tests/q79.test sql/benchmarks/tpcds/Tests/q8.test sql/benchmarks/tpcds/Tests/q80.test sql/benchmarks/tpcds/Tests/q80a.test sql/benchmarks/tpcds/Tests/q81.test sql/benchmarks/tpcds/Tests/q82.test sql/benchmarks/tpcds/Tests/q83.test sql/benchmarks/tpcds/Tests/q84.test sql/benchmarks/tpcds/Tests/q85.test sql/benchmarks/tpcds/Tests/q86.test sql/benchmarks/tpcds/Tests/q86a.test sql/benchmarks/tpcds/Tests/q87.test sql/benchmarks/tpcds/Tests/q88.test sql/benchmarks/tpcds/Tests/q89.test sql/benchmarks/tpcds/Tests/q9.test sql/benchmarks/tpcds/Tests/q90.test sql/benchmarks/tpcds/Tests/q91.test sql/benchmarks/tpcds/Tests/q92.test sql/benchmarks/tpcds/Tests/q93.test sql/benchmarks/tpcds/Tests/q94.test sql/benchmarks/tpcds/Tests/q95.test sql/benchmarks/tpcds/Tests/q96.test sql/benchmarks/tpcds/Tests/q97.test sql/benchmarks/tpcds/Tests/q98.test sql/benchmarks/tpcds/Tests/q99.test Branch: Dec2025 Log Message:
Updated tpc-ds test. Current TPC-DS (4.0.0) has two more columns with NOT NULL, and one column as CHAR(10) instead of INTEGER. Also, all tests do their own sorting, so use nosort option in test file. diffs (truncated from 42804 to 300 lines): 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 @@ -131,3782 +131,195 @@ select count(*) from store_sales query TTTT nosort select * from dbgen_version ---- -2.10.0 -2018-10-22 -17:17:42 --DIR qual +2.10.0 2018-10-22 17:17:42 -DIR qual query ITTTTTTTTTTDT nosort select * from customer_address limit 9 ---- -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 +117 values hashing to 80773b266492865dfe2a221a7fcb7ae4 query ITTTITIII nosort select * from customer_demographics order by cd_demo_sk limit 9 ---- -1 -M -M -Primary -500 -Good -0 -0 -0 -2 -F -M -Primary -500 -Good -0 -0 -0 -3 -M -S -Primary -500 -Good -0 -0 -0 -4 -F -S -Primary -500 -Good -0 -0 -0 -5 -M -D -Primary -500 -Good -0 -0 -0 -6 -F -D -Primary -500 -Good -0 -0 -0 -7 -M -W -Primary -500 -Good -0 -0 -0 -8 -F -W -Primary -500 -Good -0 -0 -0 -9 -M -U -Primary -500 -Good -0 -0 -0 +1 M M Primary 500 Good 0 0 0 +2 F M Primary 500 Good 0 0 0 +3 M S Primary 500 Good 0 0 0 +4 F S Primary 500 Good 0 0 0 +5 M D Primary 500 Good 0 0 0 +6 F D Primary 500 Good 0 0 0 +7 M W Primary 500 Good 0 0 0 +8 F W Primary 500 Good 0 0 0 +9 M U Primary 500 Good 0 0 0 query ITTIIIIIIIIIIITTTTTIIIITTTTT nosort select * from date_dim order by d_date_sk limit 9 ---- -2415022 -AAAAAAAAOKJNECAA -1900-01-02 -0 -1 -1 -1900 -1 -1 -2 -1 -1900 -1 -1 -Monday -1900Q1 -N -N -Y -2415021 -2415020 -2414657 -2414930 -N -N -N -N -N -2415023 -AAAAAAAAPKJNECAA -1900-01-03 -0 -1 -1 -1900 -2 -1 -3 -1 -1900 -1 -1 -Tuesday -1900Q1 -N -N -N -2415021 -2415020 -2414658 -2414931 -N -N -N -N -N -2415024 -AAAAAAAAALJNECAA -1900-01-04 -0 -1 -1 -1900 -3 -1 -4 -1 -1900 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
