Changeset: 810eb1e176dc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=810eb1e176dc Added Files: sql/benchmarks/tpcds/Tests/one.test.in Modified Files: sql/benchmarks/tpcds/Tests/All Branch: mtest Log Message:
convert tpcds into single sqllogic test diffs (truncated from 8285 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,109 +1,110 @@ -create -check0 -HAVE_DATA_PATH?load -alter -check1 -01 -02 -03 -04 -05 -06 -07 -08 -09 -10 -11 -12 -13 -14a -14b -15 -16 -17 -18 -19 -20 -21 -22 -23a -23b -24a -24b -25 -26 -27 -28 -29 -30 -31 -32 -33 -34 -35 -36 -37 -38 -39a -39b -40 -41 -42 -43 -44 -45 -46 -47 -48 -49 -50 -51 -52 -53 -54 -55 -56 -57 -58 -59 -60 -61 -62 -63 -64 -65 -66 -67 -68 -69 -70 -71 -72 -73 -74 -75 -76 -77 -78 -79 -80 -81 -82 -83 -84 -85 -86 -87 -88 -89 -90 -91 -92 -93 -94 -95 -96 -97 -98 -99 -drop +HAVE_DATA_PATH?one +#create +#check0 +#HAVE_DATA_PATH?load +#alter +#check1 +#01 +#02 +#03 +#04 +#05 +#06 +#07 +#08 +#09 +#10 +#11 +#12 +#13 +#14a +#14b +#15 +#16 +#17 +#18 +#19 +#20 +#21 +#22 +#23a +#23b +#24a +#24b +#25 +#26 +#27 +#28 +#29 +#30 +#31 +#32 +#33 +#34 +#35 +#36 +#37 +#38 +#39a +#39b +#40 +#41 +#42 +#43 +#44 +#45 +#46 +#47 +#48 +#49 +#50 +#51 +#52 +#53 +#54 +#55 +#56 +#57 +#58 +#59 +#60 +#61 +#62 +#63 +#64 +#65 +#66 +#67 +#68 +#69 +#70 +#71 +#72 +#73 +#74 +#75 +#76 +#77 +#78 +#79 +#80 +#81 +#82 +#83 +#84 +#85 +#86 +#87 +#88 +#89 +#90 +#91 +#92 +#93 +#94 +#95 +#96 +#97 +#98 +#99 +#drop diff --git a/sql/benchmarks/tpcds/Tests/one.test.in b/sql/benchmarks/tpcds/Tests/one.test.in new file mode 100644 --- /dev/null +++ b/sql/benchmarks/tpcds/Tests/one.test.in @@ -0,0 +1,8057 @@ +statement ok +start transaction + +statement ok +create table dbgen_version +( + dv_version varchar(16) , + dv_create_date date , + dv_create_time time , + dv_cmdline_args varchar(200) +) + +statement ok +create table customer_address +( + ca_address_sk integer not null, + ca_address_id char(16) not null, + ca_street_number char(10) , + ca_street_name varchar(60) , + ca_street_type char(15) , + ca_suite_number char(10) , + ca_city varchar(60) , + ca_county varchar(30) , + ca_state char(2) , + ca_zip char(10) , + ca_country varchar(20) , + ca_gmt_offset decimal(5,2) , + ca_location_type char(20) , + primary key (ca_address_sk) +) + +statement ok +create table customer_demographics +( + cd_demo_sk integer not null, + cd_gender char(1) , + cd_marital_status char(1) , + cd_education_status char(20) , + cd_purchase_estimate integer , + cd_credit_rating char(10) , + cd_dep_count integer , + cd_dep_employed_count integer , + cd_dep_college_count integer , + primary key (cd_demo_sk) +) + +statement ok +create table date_dim +( + d_date_sk integer not null, + d_date_id char(16) not null, + d_date date , + d_month_seq integer , + d_week_seq integer , + d_quarter_seq integer , + d_year integer , + d_dow integer , + d_moy integer , + d_dom integer , + d_qoy integer , + d_fy_year integer , + d_fy_quarter_seq integer , + d_fy_week_seq integer , + d_day_name char(9) , + d_quarter_name char(6) , + d_holiday char(1) , + d_weekend char(1) , + d_following_holiday char(1) , + d_first_dom integer , + d_last_dom integer , + d_same_day_ly integer , + d_same_day_lq integer , _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
