Changeset: 47581683aae4 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=47581683aae4
Modified Files:
sql/src/benchmarks/tpch/LOCKED/Tests/load.SQL.py
sql/src/benchmarks/tpch/LOCKED/Tests/load.stable.out
sql/src/benchmarks/tpch/Tests/load.SQL.py
sql/src/benchmarks/tpch/Tests/load.stable.out
Branch: default
Log Message:
check loaded data also directly after load, i.e., before server is restarted
diffs (truncated from 342 to 300 lines):
diff -r 7b089c8a0221 -r 47581683aae4
sql/src/benchmarks/tpch/LOCKED/Tests/load.SQL.py
--- a/sql/src/benchmarks/tpch/LOCKED/Tests/load.SQL.py Mon Dec 27 00:38:23
2010 +0100
+++ b/sql/src/benchmarks/tpch/LOCKED/Tests/load.SQL.py Mon Dec 27 00:53:19
2010 +0100
@@ -12,3 +12,8 @@
out, err = c.communicate()
sys.stdout.write(out)
sys.stderr.write(err)
+
+c = process.client('sql', stdin =
open(os.path.join(os.environ['TSTSRCDIR'],"check1.sql")), stdout =
process.PIPE, stderr = process.PIPE)
+out, err = c.communicate()
+sys.stdout.write(out)
+sys.stderr.write(err)
diff -r 7b089c8a0221 -r 47581683aae4
sql/src/benchmarks/tpch/LOCKED/Tests/load.stable.out
--- a/sql/src/benchmarks/tpch/LOCKED/Tests/load.stable.out Mon Dec 27
00:38:23 2010 +0100
+++ b/sql/src/benchmarks/tpch/LOCKED/Tests/load.stable.out Mon Dec 27
00:53:19 2010 +0100
@@ -33,6 +33,155 @@
[ 15000 ]
[ 60175 ]
+% sys.customer # table_name
+% L1 # name
+% wrd # type
+% 4 # length
+[ 1500 ]
+% sys.nation # table_name
+% L2 # name
+% wrd # type
+% 2 # length
+[ 25 ]
+% sys.orders # table_name
+% L3 # name
+% wrd # type
+% 5 # length
+[ 15000 ]
+% sys.partsupp # table_name
+% L4 # name
+% wrd # type
+% 4 # length
+[ 8000 ]
+% sys.part # table_name
+% L5 # name
+% wrd # type
+% 4 # length
+[ 2000 ]
+% sys.region # table_name
+% L6 # name
+% wrd # type
+% 1 # length
+[ 5 ]
+% sys.supplier # table_name
+% L7 # name
+% wrd # type
+% 3 # length
+[ 100 ]
+% sys.lineitem # table_name
+% L10 # name
+% 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:25 >
# 12:34:25 > Done.
# 12:34:25 >
diff -r 7b089c8a0221 -r 47581683aae4 sql/src/benchmarks/tpch/Tests/load.SQL.py
--- a/sql/src/benchmarks/tpch/Tests/load.SQL.py Mon Dec 27 00:38:23 2010 +0100
+++ b/sql/src/benchmarks/tpch/Tests/load.SQL.py Mon Dec 27 00:53:19 2010 +0100
@@ -12,3 +12,8 @@
out, err = c.communicate()
sys.stdout.write(out)
sys.stderr.write(err)
+
+c = process.client('sql', stdin =
open(os.path.join(os.environ['TSTSRCDIR'],"check1.sql")), stdout =
process.PIPE, stderr = process.PIPE)
+out, err = c.communicate()
+sys.stdout.write(out)
+sys.stderr.write(err)
diff -r 7b089c8a0221 -r 47581683aae4
sql/src/benchmarks/tpch/Tests/load.stable.out
--- a/sql/src/benchmarks/tpch/Tests/load.stable.out Mon Dec 27 00:38:23
2010 +0100
+++ b/sql/src/benchmarks/tpch/Tests/load.stable.out Mon Dec 27 00:53:19
2010 +0100
@@ -33,6 +33,155 @@
[ 15000 ]
[ 60175 ]
+% sys.customer # table_name
+% L1 # name
+% wrd # type
+% 4 # length
+[ 1500 ]
+% sys.nation # table_name
+% L2 # name
+% wrd # type
+% 2 # length
+[ 25 ]
+% sys.orders # table_name
+% L3 # name
+% wrd # type
+% 5 # length
+[ 15000 ]
+% sys.partsupp # table_name
+% L4 # name
+% wrd # type
+% 4 # length
+[ 8000 ]
+% sys.part # table_name
+% L5 # name
+% wrd # type
+% 4 # length
+[ 2000 ]
+% sys.region # table_name
+% L6 # name
+% wrd # type
+% 1 # length
+[ 5 ]
+% sys.supplier # table_name
+% L7 # name
+% wrd # type
+% 3 # length
+[ 100 ]
+% sys.lineitem # table_name
+% L10 # name
+% 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
_______________________________________________
Checkin-list mailing list
[email protected]
http://mail.monetdb.org/mailman/listinfo/checkin-list
