Changeset: deeee40acbe2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/deeee40acbe2 Branch: Aug2024 Log Message:
merge with upstream diffs (truncated from 18884 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 -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
