Update of /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27299/src/benchmarks/tpch/Tests
Modified Files:
01-22.stable.out 01.stable.out 04.stable.out 13.stable.out
16.stable.out 21.stable.out 22.stable.out check1.stable.out
Log Message:
count now returns wrd
U 04.stable.out
Index: 04.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/04.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- 04.stable.out 24 Oct 2006 16:02:32 -0000 1.8
+++ 04.stable.out 7 Sep 2008 14:27:53 -0000 1.9
@@ -1,19 +1,22 @@
stdout of test '04` in directory 'src/benchmarks/tpch` itself:
-# 12:34:31 >
-# 12:34:31 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:34:31 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 16:02:03 >
+# 16:02:03 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34442 --set
xrpc_port=47029 --set monet_prompt= --trace
"--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 16:02:03 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.orders, sys.orders # table_name
% o_orderpriority, order_count # name
-% varchar, int # type
+% varchar, wrd # type
% 15, 3 # length
[ "1-URGENT", 93 ]
[ "2-HIGH", 103 ]
U 16.stable.out
Index: 16.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/16.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- 16.stable.out 24 Oct 2006 16:02:36 -0000 1.8
+++ 16.stable.out 7 Sep 2008 14:27:54 -0000 1.9
@@ -5,15 +5,18 @@
# 12:34:52 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
# 12:34:52 >
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
-
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.part, sys.part, sys.part, sys.partsupp # table_name
% p_brand, p_type, p_size, supplier_cnt # name
-% varchar, varchar, int, int # type
+% varchar, varchar, int, wrd # type
% 8, 25, 2, 1 # length
[ "Brand#14", "PROMO BRUSHED STEEL", 9, 8 ]
[ "Brand#35", "SMALL POLISHED COPPER", 14, 8 ]
U 13.stable.out
Index: 13.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/13.stable.out,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -d -r1.10 -r1.11
--- 13.stable.out 24 Oct 2006 16:02:36 -0000 1.10
+++ 13.stable.out 7 Sep 2008 14:27:53 -0000 1.11
@@ -1,19 +1,22 @@
stdout of test '13` in directory 'src/benchmarks/tpch` itself:
-# 12:34:49 >
-# 12:34:49 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:34:49 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 16:02:04 >
+# 16:02:04 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34442 --set
xrpc_port=47029 --set monet_prompt= --trace
"--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 16:02:04 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.c_orders, sys.c_orders # table_name
% c_count, custdist # name
-% int, int # type
+% wrd, wrd # type
% 2, 3 # length
[ 0, 500 ]
[ 11, 70 ]
U 21.stable.out
Index: 21.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/21.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- 21.stable.out 24 Oct 2006 16:02:37 -0000 1.9
+++ 21.stable.out 7 Sep 2008 14:27:56 -0000 1.10
@@ -1,19 +1,22 @@
stdout of test '21` in directory 'src/benchmarks/tpch` itself:
-# 12:35:03 >
-# 12:35:03 > Mtimeout -timeout 1260 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:35:03 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 16:02:06 >
+# 16:02:06 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34442 --set
xrpc_port=47029 --set monet_prompt= --trace
"--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 16:02:06 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.supplier, sys.supplier # table_name
% s_name, numwait # name
-% varchar, int # type
+% varchar, wrd # type
% 18, 1 # length
[ "Supplier#000000074", 9 ]
% .stats, .stats # table_name
U 22.stable.out
Index: 22.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/22.stable.out,v
retrieving revision 1.9
retrieving revision 1.10
diff -u -d -r1.9 -r1.10
--- 22.stable.out 24 Oct 2006 16:02:37 -0000 1.9
+++ 22.stable.out 7 Sep 2008 14:27:56 -0000 1.10
@@ -1,19 +1,22 @@
stdout of test '22` in directory 'src/benchmarks/tpch` itself:
-# 12:35:05 >
-# 12:35:05 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:35:05 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 16:02:06 >
+# 16:02:06 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34442 --set
xrpc_port=47029 --set monet_prompt= --trace
"--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 16:02:06 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.custsale, sys.custsale, sys.custsale # table_name
% cntrycode, numcust, totacctbal # name
-% varchar, int, decimal # type
+% varchar, wrd, decimal # type
% 2, 2, 17 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
U check1.stable.out
Index: check1.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/check1.stable.out,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- check1.stable.out 3 Jul 2008 04:42:11 -0000 1.8
+++ check1.stable.out 7 Sep 2008 14:27:57 -0000 1.9
@@ -26,42 +26,42 @@
% sys.customer # table_name
% count_ # name
-% int # type
+% wrd # type
% 4 # length
[ 1500 ]
% sys.nation # table_name
% count_ # name
-% int # type
+% wrd # type
% 2 # length
[ 25 ]
% sys.orders # table_name
% count_ # name
-% int # type
+% wrd # type
% 5 # length
[ 15000 ]
% sys.partsupp # table_name
% count_ # name
-% int # type
+% wrd # type
% 4 # length
[ 8000 ]
% sys.part # table_name
% count_ # name
-% int # type
+% wrd # type
% 4 # length
[ 2000 ]
% sys.region # table_name
% count_ # name
-% int # type
+% wrd # type
% 1 # length
[ 5 ]
% sys.supplier # table_name
% count_ # name
-% int # type
+% wrd # type
% 3 # length
[ 100 ]
% sys.lineitem # table_name
% count_ # name
-% int # type
+% wrd # type
% 5 # length
[ 60175 ]
U 01.stable.out
Index: 01.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/01.stable.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- 01.stable.out 29 Jun 2007 11:28:52 -0000 1.11
+++ 01.stable.out 7 Sep 2008 14:27:53 -0000 1.12
@@ -1,19 +1,22 @@
stdout of test '01` in directory 'src/benchmarks/tpch` itself:
-# 12:34:27 >
-# 12:34:27 > Mtimeout -timeout 180 Mserver
"--config=/ufs/fabian/scratch/monetdb/current/program-x86_64/etc/MonetDB.conf"
--debug=10 --set
"monet_mod_path=/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/MonetDB:/ufs/fabian/scratch/monetdb/current/program-x86_64/lib/bin"
--set
"gdk_dbfarm=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/dbfarm"
--set
"sql_logdir=/ufs/fabian/scratch/monetdb/current/program-x86_64/var/MonetDB/log"
--set mapi_port=38933 --set sql_port=45579 --set xquery_port=52530 --set
monet_prompt= --trace "--dbname=mTests_src_benchmarks_tpch"
--dbinit="module(sql_server); sql_server_start();" ; echo ; echo Over..
-# 12:34:27 >
-
-# Monet Database Server V4.9.3
-# Copyright (c) 1993-2005, CWI. All rights reserved.
-# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs; dynamically
linked.
-# Visit http://monetdb.cwi.nl/ for further information.
+# 16:02:02 >
+# 16:02:02 > mserver5
"--config=/ufs/niels/scratch/monetdb/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=4 --set
"monet_mod_path=/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/monetdb/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/dbfarm"
--set
"sql_logdir=/ufs/niels/scratch/monetdb/Linux-x86_64/var/MonetDB5/sql_logs"
--set mapi_open=true --set xrpc_open=true --set mapi_port=34442 --set
xrpc_port=47029 --set monet_prompt= --trace
"--dbname=mTests_src_benchmarks_tpch" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
+# 16:02:02 >
-printf("\nReady.\n");
+# MonetDB server v5.7.0, based on kernel v1.25.0
+# Serving database 'mTests_src_benchmarks_tpch', using 4 threads
+# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically
linked
+# Copyright (c) 1993-2008 CWI, all rights reserved
+# Visit http://monetdb.cwi.nl/ for further information
+# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:34442/
+# MonetDB/SQL module v2.25.0 loaded
Ready.
-quit();
+#function user.main():void;
+# clients.quit();
+#end main;
Over..
@@ -23,7 +26,7 @@
% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys.lineitem, sys., sys., sys.lineitem # table_name
% l_returnflag, l_linestatus, sum_qty, sum_base_price,
sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc,
count_order # name
-% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, int # type
+% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, wrd # type
% 1, 1, 6, 17, 21, 21, 22, 22, 22, 5 #
length
[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937351, 0.050081339069642378, 14876
]
[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908051, 0.047758620689655168, 348
]
U 01-22.stable.out
Index: 01-22.stable.out
===================================================================
RCS file: /cvsroot/monetdb/sql/src/benchmarks/tpch/Tests/01-22.stable.out,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -d -r1.11 -r1.12
--- 01-22.stable.out 17 Mar 2008 09:48:45 -0000 1.11
+++ 01-22.stable.out 7 Sep 2008 14:27:53 -0000 1.12
@@ -31,7 +31,7 @@
% sys.lineitem, sys.lineitem, sys.lineitem, sys.lineitem, sys.,
sys., sys.lineitem, sys., sys., sys.lineitem # table_name
% l_returnflag, l_linestatus, sum_qty, sum_base_price,
sum_disc_price, sum_charge, avg_qty, avg_price, avg_disc,
count_order # name
-% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, int # type
+% varchar, varchar, bigint, decimal, decimal,
decimal, double, double, double, wrd # type
% 1, 1, 6, 17, 21, 21, 22, 22, 22, 5 #
length
[ "A", "F", 380456, 532348211.65, 505822441.4861, 526165934.000839,
25.575154611454693, 35785.709306937351, 0.050081339069642378, 14876
]
[ "N", "F", 8971, 12384801.37, 11798257.2080, 12282485.056933,
25.778735632183906, 35588.509683908051, 0.047758620689655168, 348
]
@@ -91,7 +91,7 @@
% sys.orders, sys.orders # table_name
% o_orderpriority, order_count # name
-% varchar, int # type
+% varchar, wrd # type
% 15, 3 # length
[ "1-URGENT", 93 ]
[ "2-HIGH", 103 ]
@@ -789,7 +789,7 @@
% sys.c_orders, sys.c_orders # table_name
% c_count, custdist # name
-% int, int # type
+% wrd, wrd # type
% 2, 3 # length
[ 0, 500 ]
[ 11, 70 ]
@@ -865,7 +865,7 @@
% sys.part, sys.part, sys.part, sys.partsupp # table_name
% p_brand, p_type, p_size, supplier_cnt # name
-% varchar, varchar, int, int # type
+% varchar, varchar, int, wrd # type
% 8, 25, 2, 1 # length
[ "Brand#14", "PROMO BRUSHED STEEL", 9, 8 ]
[ "Brand#35", "SMALL POLISHED COPPER", 14, 8 ]
@@ -1236,7 +1236,7 @@
% sys.supplier, sys.supplier # table_name
% s_name, numwait # name
-% varchar, int # type
+% varchar, wrd # type
% 18, 1 # length
[ "Supplier#000000074", 9 ]
% .stats, .stats # table_name
@@ -1251,7 +1251,7 @@
% sys.custsale, sys.custsale, sys.custsale # table_name
% cntrycode, numcust, totacctbal # name
-% varchar, int, decimal # type
+% varchar, wrd, decimal # type
% 2, 2, 17 # length
[ "13", 10, 75359.29 ]
[ "17", 8, 62288.98 ]
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
