Changeset: 19aac9604151 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/19aac9604151 Added Files: sql/benchmarks/tpcds/Tests/alter.test sql/benchmarks/tpcds/Tests/check.test sql/benchmarks/tpcds/Tests/counts.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/q51a.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 Removed Files: sql/benchmarks/tpcds/Tests/one.test.in sql/benchmarks/tpcds/Tests/one.timeout Modified Files: sql/benchmarks/tpcds/Tests/All sql/benchmarks/tpcds/Tests/SingleServer Branch: Aug2024 Log Message:
Split tpc/ds test file into smaller ones. diffs (truncated from 18866 to 300 lines): diff --git a/sql/benchmarks/tpcds/Tests/All b/sql/benchmarks/tpcds/Tests/All --- a/sql/benchmarks/tpcds/Tests/All +++ b/sql/benchmarks/tpcds/Tests/All @@ -1,1 +1,124 @@ -HAVE_DATA_PATH?one +create +counts +HAVE_DATA_PATH?load +HAVE_DATA_PATH?alter +HAVE_DATA_PATH?check +HAVE_DATA_PATH?q1 +HAVE_DATA_PATH?q2 +HAVE_DATA_PATH?q3 +HAVE_DATA_PATH?q4 +HAVE_DATA_PATH?q5 +HAVE_DATA_PATH?q5a +HAVE_DATA_PATH?q6 +HAVE_DATA_PATH?q7 +HAVE_DATA_PATH?q8 +HAVE_DATA_PATH?q9 +HAVE_DATA_PATH?q10 +HAVE_DATA_PATH?q10a +HAVE_DATA_PATH?q11 +HAVE_DATA_PATH?q12 +HAVE_DATA_PATH?q13 +HAVE_DATA_PATH?q14-1 +HAVE_DATA_PATH?q14-2 +HAVE_DATA_PATH?q14a-1 +HAVE_DATA_PATH?q14a-2 +HAVE_DATA_PATH?q15 +HAVE_DATA_PATH?q16 +HAVE_DATA_PATH?q17 +HAVE_DATA_PATH?q18 +HAVE_DATA_PATH?q18a +HAVE_DATA_PATH?q19 +HAVE_DATA_PATH?q20 +HAVE_DATA_PATH?q21 +HAVE_DATA_PATH?q22 +HAVE_DATA_PATH?q22a +HAVE_DATA_PATH?q23-1 +HAVE_DATA_PATH?q23-2 +HAVE_DATA_PATH?q24-1 +HAVE_DATA_PATH?q24-2 +HAVE_DATA_PATH?q25 +HAVE_DATA_PATH?q26 +HAVE_DATA_PATH?q27 +HAVE_DATA_PATH?q27a +HAVE_DATA_PATH?q28 +HAVE_DATA_PATH?q29 +HAVE_DATA_PATH?q30 +HAVE_DATA_PATH?q31 +HAVE_DATA_PATH?q32 +HAVE_DATA_PATH?q33 +HAVE_DATA_PATH?q34 +HAVE_DATA_PATH?q35 +HAVE_DATA_PATH?q35a +HAVE_DATA_PATH?q36 +HAVE_DATA_PATH?q36a +HAVE_DATA_PATH?q37 +HAVE_DATA_PATH?q38 +HAVE_DATA_PATH?q39-1 +HAVE_DATA_PATH?q39-2 +HAVE_DATA_PATH?q40 +HAVE_DATA_PATH?q41 +HAVE_DATA_PATH?q42 +HAVE_DATA_PATH?q43 +HAVE_DATA_PATH?q44 +HAVE_DATA_PATH?q45 +HAVE_DATA_PATH?q46 +HAVE_DATA_PATH?q47 +HAVE_DATA_PATH?q48 +HAVE_DATA_PATH?q49 +HAVE_DATA_PATH?q50 +HAVE_DATA_PATH?q51 +HAVE_DATA_PATH?q51a +HAVE_DATA_PATH?q52 +HAVE_DATA_PATH?q53 +HAVE_DATA_PATH?q54 +HAVE_DATA_PATH?q55 +HAVE_DATA_PATH?q56 +HAVE_DATA_PATH?q57 +HAVE_DATA_PATH?q58 +HAVE_DATA_PATH?q59 +HAVE_DATA_PATH?q60 +HAVE_DATA_PATH?q61 +HAVE_DATA_PATH?q62 +HAVE_DATA_PATH?q63 +HAVE_DATA_PATH?q64 +HAVE_DATA_PATH?q65 +HAVE_DATA_PATH?q66 +HAVE_DATA_PATH?q67 +HAVE_DATA_PATH?q67a +HAVE_DATA_PATH?q68 +HAVE_DATA_PATH?q69 +HAVE_DATA_PATH?q70 +HAVE_DATA_PATH?q70a +HAVE_DATA_PATH?q71 +HAVE_DATA_PATH?q72 +HAVE_DATA_PATH?q73 +HAVE_DATA_PATH?q74 +HAVE_DATA_PATH?q75 +HAVE_DATA_PATH?q76 +HAVE_DATA_PATH?q77 +HAVE_DATA_PATH?q77a +HAVE_DATA_PATH?q78 +HAVE_DATA_PATH?q79 +HAVE_DATA_PATH?q80 +HAVE_DATA_PATH?q80a +HAVE_DATA_PATH?q81 +HAVE_DATA_PATH?q82 +HAVE_DATA_PATH?q83 +HAVE_DATA_PATH?q84 +HAVE_DATA_PATH?q85 +HAVE_DATA_PATH?q86 +HAVE_DATA_PATH?q86a +HAVE_DATA_PATH?q87 +HAVE_DATA_PATH?q88 +HAVE_DATA_PATH?q89 +HAVE_DATA_PATH?q90 +HAVE_DATA_PATH?q91 +HAVE_DATA_PATH?q92 +HAVE_DATA_PATH?q93 +HAVE_DATA_PATH?q94 +HAVE_DATA_PATH?q95 +HAVE_DATA_PATH?q96 +HAVE_DATA_PATH?q97 +HAVE_DATA_PATH?q98 +HAVE_DATA_PATH?q99 +drop diff --git a/sql/benchmarks/tpcds/Tests/SingleServer b/sql/benchmarks/tpcds/Tests/SingleServer --- a/sql/benchmarks/tpcds/Tests/SingleServer +++ b/sql/benchmarks/tpcds/Tests/SingleServer @@ -0,0 +1,1 @@ +nodrop diff --git a/sql/benchmarks/tpcds/Tests/alter.test b/sql/benchmarks/tpcds/Tests/alter.test new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/alter.test @@ -0,0 +1,312 @@ +statement ok +start transaction + +statement ok +alter table call_center add constraint cc_d1 foreign key (cc_closed_date_sk) references date_dim (d_date_sk) + +statement ok +alter table call_center add constraint cc_d2 foreign key (cc_open_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_page add constraint cp_d1 foreign key (cp_end_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_page add constraint cp_d2 foreign key (cp_start_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_returns add constraint cr_cc foreign key (cr_call_center_sk) references call_center (cc_call_center_sk) + +statement ok +alter table catalog_returns add constraint cr_cp foreign key (cr_catalog_page_sk) references catalog_page (cp_catalog_page_sk) + +statement ok +alter table catalog_returns add constraint cr_i foreign key (cr_item_sk) references item (i_item_sk) + +statement ok +alter table catalog_returns add constraint cr_r foreign key (cr_reason_sk) references reason (r_reason_sk) + +statement ok +alter table catalog_returns add constraint cr_a1 foreign key (cr_refunded_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table catalog_returns add constraint cr_cd1 foreign key (cr_refunded_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table catalog_returns add constraint cr_c1 foreign key (cr_refunded_customer_sk) references customer (c_customer_sk) + +statement ok +alter table catalog_returns add constraint cr_hd1 foreign key (cr_refunded_hdemo_sk) references household_demographics (hd_demo_sk) + +statement ok +alter table catalog_returns add constraint cr_d1 foreign key (cr_returned_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_returns add constraint cr_t foreign key (cr_returned_time_sk) references time_dim (t_time_sk) + +statement ok +alter table catalog_returns add constraint cr_a2 foreign key (cr_returning_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table catalog_returns add constraint cr_cd2 foreign key (cr_returning_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table catalog_returns add constraint cr_c2 foreign key (cr_returning_customer_sk) references customer (c_customer_sk) + +statement ok +alter table catalog_returns add constraint cr_hd2 foreign key (cr_returning_hdemo_sk) references household_demographics (hd_demo_sk) + +statement ok +alter table catalog_returns add constraint cr_sm foreign key (cr_ship_mode_sk) references ship_mode (sm_ship_mode_sk) + +statement ok +alter table catalog_returns add constraint cr_w2 foreign key (cr_warehouse_sk) references warehouse (w_warehouse_sk) + +statement ok +alter table catalog_sales add constraint cs_b_a foreign key (cs_bill_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table catalog_sales add constraint cs_b_cd foreign key (cs_bill_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table catalog_sales add constraint cs_b_c foreign key (cs_bill_customer_sk) references customer (c_customer_sk) + +statement ok +alter table catalog_sales add constraint cs_b_hd foreign key (cs_bill_hdemo_sk) references household_demographics (hd_demo_sk) + +statement ok +alter table catalog_sales add constraint cs_cc foreign key (cs_call_center_sk) references call_center (cc_call_center_sk) + +statement ok +alter table catalog_sales add constraint cs_cp foreign key (cs_catalog_page_sk) references catalog_page (cp_catalog_page_sk) + +statement ok +alter table catalog_sales add constraint cs_i foreign key (cs_item_sk) references item (i_item_sk) + +statement ok +alter table catalog_sales add constraint cs_p foreign key (cs_promo_sk) references promotion (p_promo_sk) + +statement ok +alter table catalog_sales add constraint cs_s_a foreign key (cs_ship_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table catalog_sales add constraint cs_s_cd foreign key (cs_ship_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table catalog_sales add constraint cs_s_c foreign key (cs_ship_customer_sk) references customer (c_customer_sk) + +statement ok +alter table catalog_sales add constraint cs_d1 foreign key (cs_ship_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_sales add constraint cs_s_hd foreign key (cs_ship_hdemo_sk) references household_demographics (hd_demo_sk) + +statement ok +alter table catalog_sales add constraint cs_sm foreign key (cs_ship_mode_sk) references ship_mode (sm_ship_mode_sk) + +statement ok +alter table catalog_sales add constraint cs_d2 foreign key (cs_sold_date_sk) references date_dim (d_date_sk) + +statement ok +alter table catalog_sales add constraint cs_t foreign key (cs_sold_time_sk) references time_dim (t_time_sk) + +statement ok +alter table catalog_sales add constraint cs_w foreign key (cs_warehouse_sk) references warehouse (w_warehouse_sk) + +statement ok +alter table customer add constraint c_a foreign key (c_current_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table customer add constraint c_cd foreign key (c_current_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table customer add constraint c_hd foreign key (c_current_hdemo_sk) references household_demographics (hd_demo_sk) + +statement ok +alter table customer add constraint c_fsd foreign key (c_first_sales_date_sk) references date_dim (d_date_sk) + +statement ok +alter table customer add constraint c_fsd2 foreign key (c_first_shipto_date_sk) references date_dim (d_date_sk) + +statement ok +alter table household_demographics add constraint hd_ib foreign key (hd_income_band_sk) references income_band (ib_income_band_sk) + +statement ok +alter table inventory add constraint inv_d foreign key (inv_date_sk) references date_dim (d_date_sk) + +statement ok +alter table inventory add constraint inv_i foreign key (inv_item_sk) references item (i_item_sk) + +statement ok +alter table inventory add constraint inv_w foreign key (inv_warehouse_sk) references warehouse (w_warehouse_sk) + +statement ok +alter table promotion add constraint p_end_date foreign key (p_end_date_sk) references date_dim (d_date_sk) + +statement ok +alter table promotion add constraint p_i foreign key (p_item_sk) references item (i_item_sk) + +statement ok +alter table promotion add constraint p_start_date foreign key (p_start_date_sk) references date_dim (d_date_sk) + +statement ok +alter table store add constraint s_close_date foreign key (s_closed_date_sk) references date_dim (d_date_sk) + +statement ok +alter table store_returns add constraint sr_a foreign key (sr_addr_sk) references customer_address (ca_address_sk) + +statement ok +alter table store_returns add constraint sr_cd foreign key (sr_cdemo_sk) references customer_demographics (cd_demo_sk) + +statement ok +alter table store_returns add constraint sr_c foreign key (sr_customer_sk) references customer (c_customer_sk) _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
