Changeset: 7b089c8a0221 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=7b089c8a0221 Modified Files: sql/src/benchmarks/tpch/LOCKED/Tests/check1.sql sql/src/benchmarks/tpch/LOCKED/Tests/check1.stable.out sql/src/benchmarks/tpch/LOCKED/Tests/check2.sql sql/src/benchmarks/tpch/LOCKED/Tests/check2.stable.out sql/src/benchmarks/tpch/Tests/check1.sql sql/src/benchmarks/tpch/Tests/check1.stable.out Branch: default Log Message:
extended sanity check, whether TPCH data is loaded loaded correctly diffs (truncated from 417 to 300 lines): diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/LOCKED/Tests/check1.sql --- a/sql/src/benchmarks/tpch/LOCKED/Tests/check1.sql Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/LOCKED/Tests/check1.sql Mon Dec 27 00:38:23 2010 +0100 @@ -6,3 +6,12 @@ select count(*) from region; select count(*) from supplier; select count(*) from lineitem; + +select * from region limit 9; +select * from nation limit 9; +select * from supplier limit 9; +select * from customer limit 9; +select * from part limit 9; +select * from partsupp limit 9; +select * from orders limit 9; +select * from lineitem limit 9; diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/LOCKED/Tests/check1.stable.out --- a/sql/src/benchmarks/tpch/LOCKED/Tests/check1.stable.out Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/LOCKED/Tests/check1.stable.out Mon Dec 27 00:38:23 2010 +0100 @@ -64,8 +64,116 @@ % wrd # type % 5 # length [ 60175 ] +#select * from region limit 9; +% sys.region, sys.region, sys.region # table_name +% r_regionkey, r_name, r_comment # name +% int, varchar, varchar # type +% 1, 11, 111 # length +[ 0, "AFRICA", "special Tiresias about the furiously even dolphins are furi" ] +[ 1, "AMERICA", "even, ironic theodolites according to the bold platelets wa" ] +[ 2, "ASIA", "silent, bold requests sleep slyly across the quickly sly dependencies. furiously silent instructions alongside " ] +[ 3, "EUROPE", "special, bold deposits haggle foxes. platelet" ] +[ 4, "MIDDLE EAST", "furiously unusual packages use carefully above the unusual, exp" ] +#select * from nation limit 9; +% sys.nation, sys.nation, sys.nation, sys.nation # table_name +% n_nationkey, n_name, n_regionkey, n_comment # name +% int, varchar, int, varchar # type +% 1, 9, 1, 112 # length +[ 0, "ALGERIA", 0, "final accounts wake quickly. special reques" ] +[ 1, "ARGENTINA", 1, "idly final instructions cajole stealthily. regular instructions wake carefully blithely express accounts. fluffi" ] +[ 2, "BRAZIL", 1, "always pending pinto beans sleep sil" ] +[ 3, "CANADA", 1, "foxes among the bold requests" ] +[ 4, "EGYPT", 4, "pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref" ] +[ 5, "ETHIOPIA", 0, "fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco" ] +[ 6, "FRANCE", 3, "even requests detect near the pendin" ] +[ 7, "GERMANY", 3, "blithely ironic foxes grow. quickly pending accounts are b" ] +[ 8, "INDIA", 2, "ironic packages should have to are slyly around the special, ironic accounts. iron" ] +#select * from supplier limit 9; +% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name +% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 18, 35, 2, 15, 17, 93 # length +[ 1, "Supplier#000000001", " N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ", 17, "27-918-335-1736", 5755.94, "requests haggle carefully. accounts sublate finally. carefully ironic pa" ] +[ 2, "Supplier#000000002", "89eJ5ksX3ImxJQBvxObC,", 5, "15-679-861-2259", 4032.68, "furiously stealthy frays thrash alongside of the slyly express deposits. blithely regular req" ] +[ 3, "Supplier#000000003", "q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3", 1, "11-383-516-1199", 4192.40, "furiously regular instructions impress slyly! carefu" ] +[ 4, "Supplier#000000004", "Bk7ah4CK8SYQTepEmvMkkgMwg", 15, "25-843-787-7479", 4641.08, "final ideas cajole. furiously close dep" ] +[ 5, "Supplier#000000005", "Gcdm2rJRzl5qlTVzc", 11, "21-151-690-3663", -283.84, "carefully silent instructions are slyly according t" ] +[ 6, "Supplier#000000006", "tQxuVm7s7CnK", 14, "24-696-997-4969", 1365.79, "even requests wake carefully! fluffily final pinto beans run slyly among t" ] +[ 7, "Supplier#000000007", "s,4TicNGB4uO6PaSqNBUq", 23, "33-990-965-2201", 6820.35, "carefully express packages believe furiously after the fur" ] +[ 8, "Supplier#000000008", "9Sq4bBH2FQEmaFOocY45sRTxo6yuoG", 17, "27-498-742-3860", 7627.85, "carefully express escapades are slyly " ] +[ 9, "Supplier#000000009", "1KhUgZegwM3ua7dsYmekYBsK", 10, "20-403-398-8662", 5302.37, "slyly regular decoys mold slyly ironic dugouts. requests are carefully-- carefully" ] +#select * from customer limit 9; +% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name +% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar, varchar # type +% 1, 18, 37, 2, 15, 17, 10, 114 # length +[ 1, "Customer#000000001", "IVhzIApeRb ot,c,E", 15, "25-989-741-2988", 711.56, "BUILDING", "regular, regular platelets are fluffily according to the even attainments. blithely iron" ] +[ 2, "Customer#000000002", "XSTf4,NCwDVaWNe6tEgvwfmRchLXak", 13, "23-768-687-3665", 121.65, "AUTOMOBILE", "furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending" ] +[ 3, "Customer#000000003", "MG9kdTD2WBHm", 1, "11-719-748-3364", 7498.12, "AUTOMOBILE", "special packages wake. slyly reg" ] +[ 4, "Customer#000000004", "XxVSJsLAGtn", 4, "14-128-190-5944", 2866.83, "MACHINERY", "slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack" ] +[ 5, "Customer#000000005", "KvpyuHCplrB84WgAiGV6sYpZq7Tj", 3, "13-750-942-6364", 794.47, "HOUSEHOLD", "blithely final instructions haggle; stealthy sauternes nod; carefully regu" ] +[ 6, "Customer#000000006", "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn", 20, "30-114-968-4951", 7638.57, "AUTOMOBILE", "special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith" ] +[ 7, "Customer#000000007", "TcGe5gaZNgVePxU5kRrvXBfkasDTea", 18, "28-190-982-9759", 9561.95, "AUTOMOBILE", "theodolites kindle carefully carefully regular deposits. regular depe" ] +[ 8, "Customer#000000008", "I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5", 17, "27-147-574-9335", 6819.74, "BUILDING", "ironic deposits are quickly after the gifts. regular dependencies hinder slyly after the quickly ex" ] +[ 9, "Customer#000000009", "xKiAFTjUsCuxfeleNqefumTrjS", 8, "18-338-906-3675", 8324.07, "FURNITURE", "deposits affix fluffily. blithely final ideas are furiously dolphins. i" ] +#select * from part limit 9; +% sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part # table_name +% p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment # name +% int, varchar, varchar, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 38, 14, 8, 23, 2, 9, 17, 22 # length +[ 1, "goldenrod lace spring peru powder", "Manufacturer#1", "Brand#13", "PROMO BURNISHED COPPER", 7, "JUMBO PKG", 901.00, "final deposits s" ] +[ 2, "blush rosy metallic lemon navajo", "Manufacturer#1", "Brand#13", "LARGE BRUSHED BRASS", 1, "LG CASE", 902.00, "final platelets hang f" ] +[ 3, "dark green antique puff wheat", "Manufacturer#4", "Brand#42", "STANDARD POLISHED BRASS", 21, "WRAP CASE", 903.00, "unusual excuses ac" ] +[ 4, "chocolate metallic smoke ghost drab", "Manufacturer#3", "Brand#34", "SMALL PLATED BRASS", 14, "MED DRUM", 904.00, "ironi" ] +[ 5, "forest blush chiffon thistle chocolate", "Manufacturer#3", "Brand#32", "STANDARD POLISHED TIN", 15, "SM PKG", 905.00, "pending, spe" ] +[ 6, "white ivory azure firebrick black", "Manufacturer#2", "Brand#24", "PROMO PLATED STEEL", 4, "MED BAG", 906.00, "pending pinto be" ] +[ 7, "blue blanched tan indian olive", "Manufacturer#1", "Brand#11", "SMALL PLATED COPPER", 45, "SM BAG", 907.00, "blithely ironic" ] +[ 8, "ivory khaki cream midnight rosy", "Manufacturer#4", "Brand#44", "PROMO BURNISHED TIN", 41, "LG DRUM", 908.00, "furiously eve" ] +[ 9, "thistle rose moccasin light floral", "Manufacturer#4", "Brand#43", "SMALL BURNISHED STEEL", 12, "WRAP CASE", 909.00, "thinly even request" ] +#select * from partsupp limit 9; +% sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp # table_name +% ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment # name +% int, int, int, decimal, varchar # type +% 1, 2, 4, 17, 191 # length +[ 1, 2, 3325, 771.64, "requests after the carefully ironic ideas cajole alongside of the enticingly special accounts. fluffily regular deposits haggle about the blithely ironic deposits. regular requests sleep c" ] +[ 1, 27, 8076, 993.49, "careful pinto beans wake slyly furiously silent pinto beans. accounts wake pendi" ] +[ 1, 52, 3956, 337.09, "boldly silent requests detect. quickly regular courts are. instructions haggle ironic foxes. sometimes final orbits cajole fluffily around the unusual foxes. slyly silent theodolites cajole r" ] +[ 1, 77, 4069, 357.84, "regular deposits are. furiously even packages cajole furiously. even pinto beans boost furiously final dependencies. f" ] +[ 2, 3, 8895, 378.49, "furiously even asymptotes are furiously regular plate" ] +[ 2, 28, 4969, 915.27, "even accounts wake furiously. idle instructions sleep in " ] +[ 2, 53, 8539, 438.37, "furiously even pinto beans serve about the ironic idea" ] +[ 2, 78, 3025, 306.39, "deposits according to the final, special foxes detec" ] +[ 3, 4, 4651, 920.92, "ironic, pending theodolites sleep slyly at the slyly final foxes. slyly ironic accounts sleep express accounts. quickly fina" ] +#select * from orders limit 9; +% sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders # table_name +% o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate, o_orderpriority, o_clerk, o_shippriority, o_comment # name +% int, int, varchar, decimal, date, varchar, varchar, int, varchar # type +% 2, 4, 1, 17, 10, 15, 15, 1, 69 # length +[ 1, 370, "O", 172799.49, 1996-01-02, "5-LOW", "Clerk#000000951", 0, "blithely final dolphins solve-- blithely blithe packages nag blith" ] +[ 2, 781, "O", 38426.09, 1996-12-01, "1-URGENT", "Clerk#000000880", 0, "quickly regular depend" ] +[ 3, 1234, "F", 205654.30, 1993-10-14, "5-LOW", "Clerk#000000955", 0, "deposits alongside of the dependencies are slowly about " ] +[ 4, 1369, "O", 56000.91, 1995-10-11, "5-LOW", "Clerk#000000124", 0, "final requests detect slyly across the blithely bold pinto beans. eve" ] +[ 5, 445, "F", 105367.67, 1994-07-30, "5-LOW", "Clerk#000000925", 0, "even deposits cajole furiously. quickly spe" ] +[ 6, 557, "F", 45523.10, 1992-02-21, "4-NOT SPECIFIED", "Clerk#000000058", 0, "ironically bold asymptotes sleep blithely beyond the regular, clos" ] +[ 7, 392, "O", 271885.66, 1996-01-10, "2-HIGH", "Clerk#000000470", 0, "ironic, regular deposits are. ironic foxes sl" ] +[ 32, 1301, "O", 198665.57, 1995-07-16, "2-HIGH", "Clerk#000000616", 0, "slyly final foxes are slyly. packag" ] +[ 33, 670, "F", 146567.24, 1993-10-27, "3-MEDIUM", "Clerk#000000409", 0, "packages maintain about the deposits; foxes hang after " ] +#select * from lineitem limit 9; +% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem # table_name +% l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment # name +% int, int, int, int, int, decimal, decimal, decimal, varchar, varchar, date, date, date, varchar, varchar, varchar # type +% 1, 4, 2, 1, 2, 17, 17, 17, 1, 1, 10, 10, 10, 17, 7, 36 # length +[ 1, 1552, 93, 1, 17, 24710.35, 0.04, 0.02, "N", "O", 1996-03-13, 1996-02-12, 1996-03-22, "DELIVER IN PERSON", "TRUCK", "blithely regular ideas caj" ] +[ 1, 674, 75, 2, 36, 56688.12, 0.09, 0.06, "N", "O", 1996-04-12, 1996-02-28, 1996-04-20, "TAKE BACK RETURN", "MAIL", "slyly bold pinto beans detect s" ] +[ 1, 637, 38, 3, 8, 12301.04, 0.10, 0.02, "N", "O", 1996-01-29, 1996-03-05, 1996-01-31, "TAKE BACK RETURN", "REG AIR", "deposits wake furiously dogged," ] +[ 1, 22, 48, 4, 28, 25816.56, 0.09, 0.06, "N", "O", 1996-04-21, 1996-03-30, 1996-05-16, "NONE", "AIR", "even ideas haggle. even, bold reque" ] +[ 1, 241, 23, 5, 24, 27389.76, 0.10, 0.04, "N", "O", 1996-03-30, 1996-03-14, 1996-04-01, "NONE", "FOB", "carefully final gr" ] +[ 1, 157, 10, 6, 32, 33828.80, 0.07, 0.02, "N", "O", 1996-01-30, 1996-02-07, 1996-02-03, "DELIVER IN PERSON", "MAIL", "furiously regular accounts haggle bl" ] +[ 2, 1062, 33, 1, 38, 36596.28, 0.00, 0.05, "N", "O", 1997-01-28, 1997-01-14, 1997-02-02, "TAKE BACK RETURN", "RAIL", "carefully ironic platelets against t" ] +[ 3, 43, 19, 1, 45, 42436.80, 0.06, 0.00, "R", "F", 1994-02-02, 1994-01-04, 1994-02-23, "NONE", "AIR", "blithely s" ] +[ 3, 191, 70, 2, 49, 53468.31, 0.10, 0.00, "R", "F", 1993-11-09, 1993-12-20, 1993-11-24, "TAKE BACK RETURN", "RAIL", "final, regular pinto" ] -# 12:34:27 > -# 12:34:27 > Done. -# 12:34:27 > +# 00:31:22 > +# 00:31:22 > Done. +# 00:31:22 > diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/LOCKED/Tests/check2.sql --- a/sql/src/benchmarks/tpch/LOCKED/Tests/check2.sql Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/LOCKED/Tests/check2.sql Mon Dec 27 00:38:23 2010 +0100 @@ -6,3 +6,12 @@ select count(*) from region; select count(*) from supplier; select count(*) from lineitem; + +select * from region limit 9; +select * from nation limit 9; +select * from supplier limit 9; +select * from customer limit 9; +select * from part limit 9; +select * from partsupp limit 9; +select * from orders limit 9; +select * from lineitem limit 9; diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/LOCKED/Tests/check2.stable.out --- a/sql/src/benchmarks/tpch/LOCKED/Tests/check2.stable.out Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/LOCKED/Tests/check2.stable.out Mon Dec 27 00:38:23 2010 +0100 @@ -64,8 +64,116 @@ % wrd # type % 5 # length [ 60175 ] +#select * from region limit 9; +% sys.region, sys.region, sys.region # table_name +% r_regionkey, r_name, r_comment # name +% int, varchar, varchar # type +% 1, 11, 111 # length +[ 0, "AFRICA", "special Tiresias about the furiously even dolphins are furi" ] +[ 1, "AMERICA", "even, ironic theodolites according to the bold platelets wa" ] +[ 2, "ASIA", "silent, bold requests sleep slyly across the quickly sly dependencies. furiously silent instructions alongside " ] +[ 3, "EUROPE", "special, bold deposits haggle foxes. platelet" ] +[ 4, "MIDDLE EAST", "furiously unusual packages use carefully above the unusual, exp" ] +#select * from nation limit 9; +% sys.nation, sys.nation, sys.nation, sys.nation # table_name +% n_nationkey, n_name, n_regionkey, n_comment # name +% int, varchar, int, varchar # type +% 1, 9, 1, 112 # length +[ 0, "ALGERIA", 0, "final accounts wake quickly. special reques" ] +[ 1, "ARGENTINA", 1, "idly final instructions cajole stealthily. regular instructions wake carefully blithely express accounts. fluffi" ] +[ 2, "BRAZIL", 1, "always pending pinto beans sleep sil" ] +[ 3, "CANADA", 1, "foxes among the bold requests" ] +[ 4, "EGYPT", 4, "pending accounts haggle furiously. furiously bold accounts detect. platelets at the packages haggle caref" ] +[ 5, "ETHIOPIA", 0, "fluffily ruthless requests integrate fluffily. pending ideas wake blithely acco" ] +[ 6, "FRANCE", 3, "even requests detect near the pendin" ] +[ 7, "GERMANY", 3, "blithely ironic foxes grow. quickly pending accounts are b" ] +[ 8, "INDIA", 2, "ironic packages should have to are slyly around the special, ironic accounts. iron" ] +#select * from supplier limit 9; +% sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier, sys.supplier # table_name +% s_suppkey, s_name, s_address, s_nationkey, s_phone, s_acctbal, s_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 18, 35, 2, 15, 17, 93 # length +[ 1, "Supplier#000000001", " N kD4on9OM Ipw3,gf0JBoQDd7tgrzrddZ", 17, "27-918-335-1736", 5755.94, "requests haggle carefully. accounts sublate finally. carefully ironic pa" ] +[ 2, "Supplier#000000002", "89eJ5ksX3ImxJQBvxObC,", 5, "15-679-861-2259", 4032.68, "furiously stealthy frays thrash alongside of the slyly express deposits. blithely regular req" ] +[ 3, "Supplier#000000003", "q1,G3Pj6OjIuUYfUoH18BFTKP5aU9bEV3", 1, "11-383-516-1199", 4192.40, "furiously regular instructions impress slyly! carefu" ] +[ 4, "Supplier#000000004", "Bk7ah4CK8SYQTepEmvMkkgMwg", 15, "25-843-787-7479", 4641.08, "final ideas cajole. furiously close dep" ] +[ 5, "Supplier#000000005", "Gcdm2rJRzl5qlTVzc", 11, "21-151-690-3663", -283.84, "carefully silent instructions are slyly according t" ] +[ 6, "Supplier#000000006", "tQxuVm7s7CnK", 14, "24-696-997-4969", 1365.79, "even requests wake carefully! fluffily final pinto beans run slyly among t" ] +[ 7, "Supplier#000000007", "s,4TicNGB4uO6PaSqNBUq", 23, "33-990-965-2201", 6820.35, "carefully express packages believe furiously after the fur" ] +[ 8, "Supplier#000000008", "9Sq4bBH2FQEmaFOocY45sRTxo6yuoG", 17, "27-498-742-3860", 7627.85, "carefully express escapades are slyly " ] +[ 9, "Supplier#000000009", "1KhUgZegwM3ua7dsYmekYBsK", 10, "20-403-398-8662", 5302.37, "slyly regular decoys mold slyly ironic dugouts. requests are carefully-- carefully" ] +#select * from customer limit 9; +% sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer, sys.customer # table_name +% c_custkey, c_name, c_address, c_nationkey, c_phone, c_acctbal, c_mktsegment, c_comment # name +% int, varchar, varchar, int, varchar, decimal, varchar, varchar # type +% 1, 18, 37, 2, 15, 17, 10, 114 # length +[ 1, "Customer#000000001", "IVhzIApeRb ot,c,E", 15, "25-989-741-2988", 711.56, "BUILDING", "regular, regular platelets are fluffily according to the even attainments. blithely iron" ] +[ 2, "Customer#000000002", "XSTf4,NCwDVaWNe6tEgvwfmRchLXak", 13, "23-768-687-3665", 121.65, "AUTOMOBILE", "furiously special deposits solve slyly. furiously even foxes wake alongside of the furiously ironic ideas. pending" ] +[ 3, "Customer#000000003", "MG9kdTD2WBHm", 1, "11-719-748-3364", 7498.12, "AUTOMOBILE", "special packages wake. slyly reg" ] +[ 4, "Customer#000000004", "XxVSJsLAGtn", 4, "14-128-190-5944", 2866.83, "MACHINERY", "slyly final accounts sublate carefully. slyly ironic asymptotes nod across the quickly regular pack" ] +[ 5, "Customer#000000005", "KvpyuHCplrB84WgAiGV6sYpZq7Tj", 3, "13-750-942-6364", 794.47, "HOUSEHOLD", "blithely final instructions haggle; stealthy sauternes nod; carefully regu" ] +[ 6, "Customer#000000006", "sKZz0CsnMD7mp4Xd0YrBvx,LREYKUWAh yVn", 20, "30-114-968-4951", 7638.57, "AUTOMOBILE", "special deposits wake along the ironic foxes. slyly regular deposits are furiously about the blith" ] +[ 7, "Customer#000000007", "TcGe5gaZNgVePxU5kRrvXBfkasDTea", 18, "28-190-982-9759", 9561.95, "AUTOMOBILE", "theodolites kindle carefully carefully regular deposits. regular depe" ] +[ 8, "Customer#000000008", "I0B10bB0AymmC, 0PrRYBCP1yGJ8xcBPmWhl5", 17, "27-147-574-9335", 6819.74, "BUILDING", "ironic deposits are quickly after the gifts. regular dependencies hinder slyly after the quickly ex" ] +[ 9, "Customer#000000009", "xKiAFTjUsCuxfeleNqefumTrjS", 8, "18-338-906-3675", 8324.07, "FURNITURE", "deposits affix fluffily. blithely final ideas are furiously dolphins. i" ] +#select * from part limit 9; +% sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part, sys.part # table_name +% p_partkey, p_name, p_mfgr, p_brand, p_type, p_size, p_container, p_retailprice, p_comment # name +% int, varchar, varchar, varchar, varchar, int, varchar, decimal, varchar # type +% 1, 38, 14, 8, 23, 2, 9, 17, 22 # length +[ 1, "goldenrod lace spring peru powder", "Manufacturer#1", "Brand#13", "PROMO BURNISHED COPPER", 7, "JUMBO PKG", 901.00, "final deposits s" ] +[ 2, "blush rosy metallic lemon navajo", "Manufacturer#1", "Brand#13", "LARGE BRUSHED BRASS", 1, "LG CASE", 902.00, "final platelets hang f" ] +[ 3, "dark green antique puff wheat", "Manufacturer#4", "Brand#42", "STANDARD POLISHED BRASS", 21, "WRAP CASE", 903.00, "unusual excuses ac" ] +[ 4, "chocolate metallic smoke ghost drab", "Manufacturer#3", "Brand#34", "SMALL PLATED BRASS", 14, "MED DRUM", 904.00, "ironi" ] +[ 5, "forest blush chiffon thistle chocolate", "Manufacturer#3", "Brand#32", "STANDARD POLISHED TIN", 15, "SM PKG", 905.00, "pending, spe" ] +[ 6, "white ivory azure firebrick black", "Manufacturer#2", "Brand#24", "PROMO PLATED STEEL", 4, "MED BAG", 906.00, "pending pinto be" ] +[ 7, "blue blanched tan indian olive", "Manufacturer#1", "Brand#11", "SMALL PLATED COPPER", 45, "SM BAG", 907.00, "blithely ironic" ] +[ 8, "ivory khaki cream midnight rosy", "Manufacturer#4", "Brand#44", "PROMO BURNISHED TIN", 41, "LG DRUM", 908.00, "furiously eve" ] +[ 9, "thistle rose moccasin light floral", "Manufacturer#4", "Brand#43", "SMALL BURNISHED STEEL", 12, "WRAP CASE", 909.00, "thinly even request" ] +#select * from partsupp limit 9; +% sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp, sys.partsupp # table_name +% ps_partkey, ps_suppkey, ps_availqty, ps_supplycost, ps_comment # name +% int, int, int, decimal, varchar # type +% 1, 2, 4, 17, 191 # length +[ 1, 2, 3325, 771.64, "requests after the carefully ironic ideas cajole alongside of the enticingly special accounts. fluffily regular deposits haggle about the blithely ironic deposits. regular requests sleep c" ] +[ 1, 27, 8076, 993.49, "careful pinto beans wake slyly furiously silent pinto beans. accounts wake pendi" ] +[ 1, 52, 3956, 337.09, "boldly silent requests detect. quickly regular courts are. instructions haggle ironic foxes. sometimes final orbits cajole fluffily around the unusual foxes. slyly silent theodolites cajole r" ] +[ 1, 77, 4069, 357.84, "regular deposits are. furiously even packages cajole furiously. even pinto beans boost furiously final dependencies. f" ] +[ 2, 3, 8895, 378.49, "furiously even asymptotes are furiously regular plate" ] +[ 2, 28, 4969, 915.27, "even accounts wake furiously. idle instructions sleep in " ] +[ 2, 53, 8539, 438.37, "furiously even pinto beans serve about the ironic idea" ] +[ 2, 78, 3025, 306.39, "deposits according to the final, special foxes detec" ] +[ 3, 4, 4651, 920.92, "ironic, pending theodolites sleep slyly at the slyly final foxes. slyly ironic accounts sleep express accounts. quickly fina" ] +#select * from orders limit 9; +% sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders, sys.orders # table_name +% o_orderkey, o_custkey, o_orderstatus, o_totalprice, o_orderdate, o_orderpriority, o_clerk, o_shippriority, o_comment # name +% int, int, varchar, decimal, date, varchar, varchar, int, varchar # type +% 2, 4, 1, 17, 10, 15, 15, 1, 69 # length +[ 1, 370, "O", 172799.49, 1996-01-02, "5-LOW", "Clerk#000000951", 0, "blithely final dolphins solve-- blithely blithe packages nag blith" ] +[ 2, 781, "O", 38426.09, 1996-12-01, "1-URGENT", "Clerk#000000880", 0, "quickly regular depend" ] +[ 3, 1234, "F", 205654.30, 1993-10-14, "5-LOW", "Clerk#000000955", 0, "deposits alongside of the dependencies are slowly about " ] +[ 4, 1369, "O", 56000.91, 1995-10-11, "5-LOW", "Clerk#000000124", 0, "final requests detect slyly across the blithely bold pinto beans. eve" ] +[ 5, 445, "F", 105367.67, 1994-07-30, "5-LOW", "Clerk#000000925", 0, "even deposits cajole furiously. quickly spe" ] +[ 6, 557, "F", 45523.10, 1992-02-21, "4-NOT SPECIFIED", "Clerk#000000058", 0, "ironically bold asymptotes sleep blithely beyond the regular, clos" ] +[ 7, 392, "O", 271885.66, 1996-01-10, "2-HIGH", "Clerk#000000470", 0, "ironic, regular deposits are. ironic foxes sl" ] +[ 32, 1301, "O", 198665.57, 1995-07-16, "2-HIGH", "Clerk#000000616", 0, "slyly final foxes are slyly. packag" ] +[ 33, 670, "F", 146567.24, 1993-10-27, "3-MEDIUM", "Clerk#000000409", 0, "packages maintain about the deposits; foxes hang after " ] +#select * from lineitem limit 9; +% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem # table_name +% l_orderkey, l_partkey, l_suppkey, l_linenumber, l_quantity, l_extendedprice, l_discount, l_tax, l_returnflag, l_linestatus, l_shipdate, l_commitdate, l_receiptdate, l_shipinstruct, l_shipmode, l_comment # name +% int, int, int, int, int, decimal, decimal, decimal, varchar, varchar, date, date, date, varchar, varchar, varchar # type +% 1, 4, 2, 1, 2, 17, 17, 17, 1, 1, 10, 10, 10, 17, 7, 36 # length +[ 1, 1552, 93, 1, 17, 24710.35, 0.04, 0.02, "N", "O", 1996-03-13, 1996-02-12, 1996-03-22, "DELIVER IN PERSON", "TRUCK", "blithely regular ideas caj" ] +[ 1, 674, 75, 2, 36, 56688.12, 0.09, 0.06, "N", "O", 1996-04-12, 1996-02-28, 1996-04-20, "TAKE BACK RETURN", "MAIL", "slyly bold pinto beans detect s" ] +[ 1, 637, 38, 3, 8, 12301.04, 0.10, 0.02, "N", "O", 1996-01-29, 1996-03-05, 1996-01-31, "TAKE BACK RETURN", "REG AIR", "deposits wake furiously dogged," ] +[ 1, 22, 48, 4, 28, 25816.56, 0.09, 0.06, "N", "O", 1996-04-21, 1996-03-30, 1996-05-16, "NONE", "AIR", "even ideas haggle. even, bold reque" ] +[ 1, 241, 23, 5, 24, 27389.76, 0.10, 0.04, "N", "O", 1996-03-30, 1996-03-14, 1996-04-01, "NONE", "FOB", "carefully final gr" ] +[ 1, 157, 10, 6, 32, 33828.80, 0.07, 0.02, "N", "O", 1996-01-30, 1996-02-07, 1996-02-03, "DELIVER IN PERSON", "MAIL", "furiously regular accounts haggle bl" ] +[ 2, 1062, 33, 1, 38, 36596.28, 0.00, 0.05, "N", "O", 1997-01-28, 1997-01-14, 1997-02-02, "TAKE BACK RETURN", "RAIL", "carefully ironic platelets against t" ] +[ 3, 43, 19, 1, 45, 42436.80, 0.06, 0.00, "R", "F", 1994-02-02, 1994-01-04, 1994-02-23, "NONE", "AIR", "blithely s" ] +[ 3, 191, 70, 2, 49, 53468.31, 0.10, 0.00, "R", "F", 1993-11-09, 1993-12-20, 1993-11-24, "TAKE BACK RETURN", "RAIL", "final, regular pinto" ] -# 12:34:27 > -# 12:34:27 > Done. -# 12:34:27 > +# 00:31:22 > +# 00:31:22 > Done. +# 00:31:22 > diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/Tests/check1.sql --- a/sql/src/benchmarks/tpch/Tests/check1.sql Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/Tests/check1.sql Mon Dec 27 00:38:23 2010 +0100 @@ -6,3 +6,12 @@ select count(*) from region; select count(*) from supplier; select count(*) from lineitem; + +select * from region limit 9; +select * from nation limit 9; +select * from supplier limit 9; +select * from customer limit 9; +select * from part limit 9; +select * from partsupp limit 9; +select * from orders limit 9; +select * from lineitem limit 9; diff -r c16f7f456fb9 -r 7b089c8a0221 sql/src/benchmarks/tpch/Tests/check1.stable.out --- a/sql/src/benchmarks/tpch/Tests/check1.stable.out Mon Dec 27 00:08:58 2010 +0100 +++ b/sql/src/benchmarks/tpch/Tests/check1.stable.out Mon Dec 27 00:38:23 2010 +0100 @@ -64,8 +64,116 @@ % wrd # type % 5 # length _______________________________________________ Checkin-list mailing list [email protected] http://mail.monetdb.org/mailman/listinfo/checkin-list
