Changeset: 9a146f60864e for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9a146f60864e Modified Files: testing/SQLogicConvertNotes Branch: mtest Log Message:
merge heads diffs (truncated from 37242 to 300 lines): diff --git a/sql/benchmarks/arno_flt/Tests/All b/sql/benchmarks/arno_flt/Tests/All --- a/sql/benchmarks/arno_flt/Tests/All +++ b/sql/benchmarks/arno_flt/Tests/All @@ -1,3 +1,4 @@ -init -#doAll -#doAll_sorted +one +#init +##doAll +##doAll_sorted diff --git a/sql/benchmarks/arno_flt/Tests/one.sql b/sql/benchmarks/arno_flt/Tests/one.sql new file mode 100644 --- /dev/null +++ b/sql/benchmarks/arno_flt/Tests/one.sql @@ -0,0 +1,10366 @@ +CREATE TABLE MODEL ( + MODEL_ID int DEFAULT '0' NOT NULL, + IS_MUTAGEN char(3), + LUMO float, + LOGP float, + PRIMARY KEY (MODEL_ID) +); + +CREATE TABLE ATOM ( + ATOM_ID varchar(10) NOT NULL, + MODEL_ID int, + ELEMENT char(2), + TYPE char(3), + CHARGE float, + PRIMARY KEY (ATOM_ID) +); + +CREATE TABLE BOND ( + BOND_ID int DEFAULT '0' NOT NULL, + MODEL_ID int, + ATOM1 varchar(10), + ATOM2 varchar(10), + TYPE char(3), + PRIMARY KEY (BOND_ID) +); + +select * from model; +select * from atom; +select * from bond; + +START TRANSACTION; + +COPY 4893 RECORDS INTO "sys"."atom" FROM stdin USING DELIMITERS E'\t',E'\n','"'; +"d1_1" 1 "c" "22" 2.53477172584837e-09 +"d1_2" 1 "c" "22" 2.53477172584837e-09 +"d1_3" 1 "c" "22" 2.53477172584837e-09 +"d1_4" 1 "c" "195" 6.33692931462093e-10 +"d1_5" 1 "c" "195" 2.5637625356012e-09 +"d1_6" 1 "c" "22" 2.53477172584837e-09 +"d1_7" 1 "h" "3" 1.65012124853092e-07 +"d1_8" 1 "h" "3" 1.65012124853092e-07 +"d1_9" 1 "h" "3" 1.65012124853092e-07 +"d1_10" 1 "h" "3" 1.65012124853092e-07 +"d1_11" 1 "c" "27" 6.33692931462093e-10 +"d1_12" 1 "c" "27" 2.5637625356012e-09 +"d1_13" 1 "c" "22" 2.53477172584837e-09 +"d1_14" 1 "c" "22" 2.53477172584837e-09 +"d1_15" 1 "h" "3" 1.65012124853092e-07 +"d1_16" 1 "h" "3" 1.65012124853092e-07 +"d1_17" 1 "c" "22" 2.53477172584837e-09 +"d1_18" 1 "c" "22" 2.53477172584837e-09 +"d1_19" 1 "c" "22" 2.53477172584837e-09 +"d1_20" 1 "c" "22" 2.53477172584837e-09 +"d1_21" 1 "h" "3" 1.65012124853092e-07 +"d1_22" 1 "h" "3" 1.65012124853092e-07 +"d1_23" 1 "h" "3" 1.65012124853092e-07 +"d1_24" 1 "n" "38" 2.68017785742813e-09 +"d1_25" 1 "o" "40" 4.0556347613574e-08 +"d1_26" 1 "o" "40" 4.0556347613574e-08 +"d2_1" 2 "c" "22" 6.33692931462093e-10 +"d2_2" 2 "c" "22" 6.33692931462093e-10 +"d2_3" 2 "c" "27" 6.33692931462093e-10 +"d2_4" 2 "c" "27" 4.10202005696192e-08 +"d2_5" 2 "c" "22" 6.33692931462093e-10 +"d2_6" 2 "c" "22" 6.33692931462093e-10 +"d2_7" 2 "h" "3" 2.64019399764948e-06 +"d2_8" 2 "h" "3" 2.64019399764948e-06 +"d2_9" 2 "h" "3" 2.64019399764948e-06 +"d2_10" 2 "n" "35" 1.03824249890749e-05 +"d2_11" 2 "c" "22" 4.24815225414932e-05 +"d2_12" 2 "c" "22" 6.33692931462093e-10 +"d2_13" 2 "c" "22" 6.33692931462093e-10 +"d2_14" 2 "h" "3" 2.64019399764948e-06 +"d2_15" 2 "h" "3" 2.64019399764948e-06 +"d2_16" 2 "h" "3" 2.64019399764948e-06 +"d2_17" 2 "n" "38" 4.28828457188501e-08 +"d2_18" 2 "o" "40" 4.0556347613574e-08 +"d2_19" 2 "o" "40" 4.0556347613574e-08 +"d3_1" 3 "c" "22" 6.33692931462093e-10 +"d3_2" 3 "c" "22" 6.33692931462093e-10 +"d3_3" 3 "c" "27" 6.33692931462093e-10 +"d3_4" 3 "c" "27" 4.10202005696192e-08 +"d3_5" 3 "c" "22" 6.33692931462093e-10 +"d3_6" 3 "c" "22" 6.33692931462093e-10 +"d3_7" 3 "h" "3" 2.64019399764948e-06 +"d3_8" 3 "h" "3" 2.64019399764948e-06 +"d3_9" 3 "h" "3" 2.64019399764948e-06 +"d3_10" 3 "n" "35" 1.03824249890749e-05 +"d3_11" 3 "c" "22" 4.24815225414932e-05 +"d3_12" 3 "c" "22" 6.33692931462093e-10 +"d3_13" 3 "c" "22" 6.33692931462093e-10 +"d3_14" 3 "h" "3" 2.64019399764948e-06 +"d3_15" 3 "h" "3" 2.64019399764948e-06 +"d3_16" 3 "h" "3" 2.64019399764948e-06 +"d3_17" 3 "n" "38" 4.28828457188501e-08 +"d3_18" 3 "o" "40" 4.0556347613574e-08 +"d3_19" 3 "o" "40" 4.0556347613574e-08 +"d4_1" 4 "c" "22" 2.53477172584837e-09 +"d4_2" 4 "c" "22" 2.53477172584837e-09 +"d4_3" 4 "c" "27" 6.409406339003e-10 +"d4_4" 4 "c" "27" 6.33692931462093e-10 +"d4_5" 4 "c" "28" 6.409406339003e-10 +"d4_6" 4 "c" "22" 2.53477172584837e-09 +"d4_7" 4 "c" "22" 2.53477172584837e-09 +"d4_8" 4 "c" "22" 2.53477172584837e-09 +"d4_9" 4 "c" "22" 2.53477172584837e-09 +"d4_10" 4 "c" "29" 6.409406339003e-10 +"d4_11" 4 "c" "22" 2.53477172584837e-09 +"d4_12" 4 "c" "29" 6.409406339003e-10 +"d4_13" 4 "c" "28" 6.409406339003e-10 +"d4_14" 4 "c" "22" 2.53477172584837e-09 +"d4_15" 4 "c" "22" 2.53477172584837e-09 +"d4_16" 4 "c" "22" 2.53477172584837e-09 +"d4_17" 4 "n" "38" 6.70044464357034e-10 +"d4_18" 4 "o" "40" 4.0556347613574e-08 +"d4_19" 4 "o" "40" 4.0556347613574e-08 +"d4_20" 4 "h" "3" 4.12530312132731e-08 +"d4_21" 4 "h" "3" 4.12530312132731e-08 +"d4_22" 4 "h" "3" 4.12530312132731e-08 +"d4_23" 4 "h" "3" 4.12530312132731e-08 +"d4_24" 4 "h" "3" 4.12530312132731e-08 +"d4_25" 4 "h" "3" 4.12530312132731e-08 +"d4_26" 4 "h" "3" 4.12530312132731e-08 +"d4_27" 4 "h" "3" 4.12530312132731e-08 +"d4_28" 4 "h" "3" 4.12530312132731e-08 +"d5_1" 5 "c" "22" 6.51854570321575e-10 +"d5_2" 5 "c" "22" 2.53477172584837e-09 +"d5_3" 5 "c" "22" 2.53477172584837e-09 +"d5_4" 5 "c" "22" 2.6074182812863e-09 +"d5_5" 5 "c" "22" 2.53477172584837e-09 +"d5_6" 5 "c" "22" 2.53477172584837e-09 +"d5_7" 5 "h" "3" 4.12530312132731e-08 +"d5_8" 5 "h" "3" 4.12530312132731e-08 +"d5_9" 5 "h" "3" 4.12530312132731e-08 +"d5_10" 5 "n" "38" 2.68017785742813e-09 +"d5_11" 5 "f" "92" 1.01390869033935e-08 +"d5_12" 5 "f" "92" 1.01390869033935e-08 +"d5_13" 5 "o" "40" 4.0556347613574e-08 +"d5_14" 5 "o" "40" 4.0556347613574e-08 +"d6_1" 6 "c" "22" 2.53477172584837e-09 +"d6_2" 6 "c" "22" 2.53477172584837e-09 +"d6_3" 6 "c" "27" 1.02550501424048e-08 +"d6_4" 6 "c" "27" 6.33692931462093e-10 +"d6_5" 6 "c" "27" 1.02550501424048e-08 +"d6_6" 6 "c" "22" 2.53477172584837e-09 +"d6_7" 6 "c" "27" 6.33692931462093e-10 +"d6_8" 6 "c" "27" 1.02550501424048e-08 +"d6_9" 6 "c" "22" 2.53477172584837e-09 +"d6_10" 6 "c" "22" 2.53477172584837e-09 +"d6_11" 6 "c" "22" 2.53477172584837e-09 +"d6_12" 6 "c" "22" 2.53477172584837e-09 +"d6_13" 6 "c" "27" 1.02550501424048e-08 +"d6_14" 6 "c" "22" 2.53477172584837e-09 +"d6_15" 6 "c" "22" 2.53477172584837e-09 +"d6_16" 6 "c" "22" 2.53477172584837e-09 +"d6_17" 6 "h" "3" 6.60048499412369e-07 +"d6_18" 6 "h" "3" 6.60048499412369e-07 +"d6_19" 6 "h" "3" 6.60048499412369e-07 +"d6_20" 6 "h" "3" 6.60048499412369e-07 +"d6_21" 6 "h" "3" 6.60048499412369e-07 +"d6_22" 6 "h" "3" 6.60048499412369e-07 +"d6_23" 6 "n" "38" 1.07207114297125e-08 +"d6_24" 6 "n" "38" 1.07207114297125e-08 +"d6_25" 6 "o" "40" 4.0556347613574e-08 +"d6_26" 6 "o" "40" 4.0556347613574e-08 +"d6_27" 6 "o" "40" 4.0556347613574e-08 +"d6_28" 6 "o" "40" 4.0556347613574e-08 +"d6_29" 6 "o" "40" 4.0556347613574e-08 +"d6_30" 6 "o" "40" 4.0556347613574e-08 +"d6_31" 6 "o" "40" 4.0556347613574e-08 +"d6_32" 6 "o" "40" 4.0556347613574e-08 +"d6_33" 6 "n" "38" 1.07207114297125e-08 +"d6_34" 6 "n" "38" 1.07207114297125e-08 +"d7_1" 7 "c" "22" 2.53477172584837e-09 +"d7_2" 7 "c" "22" 2.53477172584837e-09 +"d7_3" 7 "c" "22" 2.53477172584837e-09 +"d7_4" 7 "c" "29" 6.409406339003e-10 +"d7_5" 7 "c" "22" 2.53477172584837e-09 +"d7_6" 7 "c" "22" 2.53477172584837e-09 +"d7_7" 7 "h" "3" 4.12530312132731e-08 +"d7_8" 7 "h" "3" 4.12530312132731e-08 +"d7_9" 7 "h" "3" 4.12530312132731e-08 +"d7_10" 7 "h" "3" 4.12530312132731e-08 +"d7_11" 7 "h" "3" 4.12530312132731e-08 +"d7_12" 7 "c" "29" 6.409406339003e-10 +"d7_13" 7 "c" "22" 2.53477172584837e-09 +"d7_14" 7 "c" "22" 2.53477172584837e-09 +"d7_15" 7 "c" "22" 2.53477172584837e-09 +"d7_16" 7 "c" "22" 2.53477172584837e-09 +"d7_17" 7 "c" "22" 2.53477172584837e-09 +"d7_18" 7 "h" "3" 4.12530312132731e-08 +"d7_19" 7 "h" "3" 4.12530312132731e-08 +"d7_20" 7 "h" "3" 4.12530312132731e-08 +"d7_21" 7 "c" "10" 6.409406339003e-10 +"d7_22" 7 "h" "3" 6.56323209113907e-07 +"d7_23" 7 "h" "3" 6.56323209113907e-07 +"d7_24" 7 "h" "3" 6.56323209113907e-07 +"d7_25" 7 "n" "38" 6.70044464357034e-10 +"d7_26" 7 "o" "40" 4.0556347613574e-08 +"d7_27" 7 "o" "40" 4.0556347613574e-08 +"d8_1" 8 "c" "22" 2.53477172584837e-09 +"d8_2" 8 "c" "22" 2.53477172584837e-09 +"d8_3" 8 "c" "22" 2.53477172584837e-09 +"d8_4" 8 "c" "29" 6.409406339003e-10 +"d8_5" 8 "c" "22" 2.53477172584837e-09 +"d8_6" 8 "c" "22" 2.53477172584837e-09 +"d8_7" 8 "c" "22" 2.53477172584837e-09 +"d8_8" 8 "c" "22" 2.53477172584837e-09 +"d8_9" 8 "c" "22" 6.63773789710831e-07 +"d8_10" 8 "c" "22" 2.53477172584837e-09 +"d8_11" 8 "c" "22" 2.53477172584837e-09 +"d8_12" 8 "c" "29" 6.409406339003e-10 +"d8_13" 8 "c" "10" 6.409406339003e-10 +"d8_14" 8 "n" "38" 6.70044464357034e-10 +"d8_15" 8 "o" "40" 4.0556347613574e-08 +"d8_16" 8 "o" "40" 4.0556347613574e-08 +"d8_17" 8 "h" "3" 4.12530312132731e-08 +"d8_18" 8 "h" "3" 4.12530312132731e-08 +"d8_19" 8 "h" "3" 4.12530312132731e-08 +"d8_20" 8 "h" "3" 4.12530312132731e-08 +"d8_21" 8 "h" "3" 4.12530312132731e-08 +"d8_22" 8 "h" "3" 4.12530312132731e-08 +"d8_23" 8 "h" "3" 6.56323209113907e-07 +"d8_24" 8 "h" "3" 6.56323209113907e-07 +"d8_25" 8 "o" "49" 4.0556347613574e-08 +"d8_26" 8 "c" "14" 6.66406485549942e-10 +"d8_27" 8 "c" "10" 6.409406339003e-10 +"d8_28" 8 "h" "3" 6.56323209113907e-07 +"d8_29" 8 "h" "3" 6.56323209113907e-07 +"d8_30" 8 "h" "3" 6.56323209113907e-07 +"d8_31" 8 "o" "51" 6.48901561817183e-07 +"d9_1" 9 "c" "22" 2.53477172584837e-09 +"d9_2" 9 "c" "22" 2.53477172584837e-09 +"d9_3" 9 "c" "26" 6.33692931462093e-10 +"d9_4" 9 "c" "26" 6.33692931462093e-10 +"d9_5" 9 "c" "22" 2.53477172584837e-09 +"d9_6" 9 "c" "22" 2.53477172584837e-09 +"d9_7" 9 "n" "34" 6.48901561817183e-07 +"d9_8" 9 "c" "21" 0.000169926090165973 +"d9_9" 9 "n" "34" 6.48901561817183e-07 +"d9_10" 9 "n" "38" 1.07207114297125e-08 +"d9_11" 9 "o" "40" 4.0556347613574e-08 +"d9_12" 9 "o" "40" 4.0556347613574e-08 +"d9_13" 9 "h" "3" 6.60048499412369e-07 +"d9_14" 9 "h" "3" 6.60048499412369e-07 +"d9_15" 9 "h" "3" 6.60048499412369e-07 +"d9_16" 9 "h" "3" 1.03132578033183e-08 +"d9_17" 9 "h" "1" 1.05460884469721e-08 +"d10_1" 10 "c" "22" 2.53477172584837e-09 +"d10_2" 10 "c" "22" 2.53477172584837e-09 +"d10_3" 10 "c" "22" 2.53477172584837e-09 +"d10_4" 10 "c" "29" 2.5637625356012e-09 +"d10_5" 10 "c" "22" 2.53477172584837e-09 +"d10_6" 10 "c" "22" 2.53477172584837e-09 +"d10_7" 10 "c" "22" 2.53477172584837e-09 +"d10_8" 10 "c" "22" 2.53477172584837e-09 +"d10_9" 10 "c" "22" 2.53477172584837e-09 +"d10_10" 10 "c" "22" 2.53477172584837e-09 +"d10_11" 10 "c" "22" 2.53477172584837e-09 +"d10_12" 10 "c" "29" 2.5637625356012e-09 +"d10_13" 10 "c" "10" 2.5637625356012e-09 +"d10_14" 10 "n" "38" 2.68017785742813e-09 +"d10_15" 10 "o" "40" 4.0556347613574e-08 +"d10_16" 10 "o" "40" 4.0556347613574e-08 +"d10_17" 10 "c" "10" 2.5637625356012e-09 +"d10_18" 10 "h" "3" 1.65012124853092e-07 +"d10_19" 10 "h" "3" 1.65012124853092e-07 +"d10_20" 10 "h" "3" 1.65012124853092e-07 +"d10_21" 10 "h" "3" 1.65012124853092e-07 +"d10_22" 10 "h" "3" 1.65012124853092e-07 +"d10_23" 10 "h" "3" 1.65012124853092e-07 +"d10_24" 10 "h" "3" 2.62529283645563e-06 +"d10_25" 10 "h" "3" 2.62529283645563e-06 +"d10_26" 10 "h" "3" 2.62529283645563e-06 +"d10_27" 10 "h" "3" 2.62529283645563e-06 +"d10_28" 10 "h" "3" 2.62529283645563e-06 +"d11_1" 11 "c" "22" 2.53477172584837e-09 +"d11_2" 11 "c" "22" 2.53477172584837e-09 +"d11_3" 11 "c" "22" 2.53477172584837e-09 +"d11_4" 11 "c" "195" 6.33692931462093e-10 +"d11_5" 11 "c" "195" 2.5637625356012e-09 +"d11_6" 11 "c" "22" 2.53477172584837e-09 +"d11_7" 11 "h" "3" 1.65012124853092e-07 +"d11_8" 11 "h" "3" 1.65012124853092e-07 _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
