Update of /cvsroot/monetdb/sql/src/test/BugTracker-2009/Tests
In directory 23jxhf1.ch3.sourceforge.com:/tmp/cvs-serv16830
Added Files:
Tag: Aug2009
orIssue.SF-2812504.stable.err orIssue.SF-2812504.stable.out
reorder.SF-2770608.stable.err reorder.SF-2770608.stable.out
Log Message:
approved output
--- NEW FILE: reorder.SF-2770608.stable.err ---
stderr of test 'reorder.SF-2770608` in directory 'src/test/BugTracker-2009`
itself:
# 22:07:50 >
# 22:07:50 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31814 --set
xrpc_port=47766 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 22:07:50 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = sql_logs
# builtin opt xquery_logdir = xquery_logs
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
# config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal
# config opt mal_listing = 2
# config opt mapi_port = 50000
# config opt mapi_autosense = false
# config opt mapi_open = false
# config opt sql_optimizer =
inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 31814
# cmdline opt xrpc_port = 47766
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 22:07:50 >
# 22:07:50 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31814
# 22:07:50 >
# 22:07:50 >
# 22:07:50 > Done.
# 22:07:50 >
--- NEW FILE: reorder.SF-2770608.stable.out ---
stdout of test 'reorder.SF-2770608` in directory 'src/test/BugTracker-2009`
itself:
# 22:07:50 >
# 22:07:50 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31814 --set
xrpc_port=47766 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 22:07:50 >
# MonetDB server v5.14.0, based on kernel v1.32.0
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31814/
# MonetDB/SQL module v2.32.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 22:07:50 >
# 22:07:50 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31814
# 22:07:50 >
% sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t1, sys.t2,
sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2, sys.t2 # table_name
% id, systemname, sqlname, digits, scale, radix, eclass,
schema_id, id, systemname, sqlname, digits, scale, radix,
eclass, schema_id # name
% int, varchar, varchar, int, int, int, int, int,
int, varchar, varchar, int, int, int, int, int #
type
% 2, 9, 14, 2, 1, 2, 2, 1, 2, 9,
14, 2, 1, 2, 2, 1 # length
[ 0, "any", "any", 0, 0, 0, 0, 0, 0, "any",
"any", 0, 0, 0, 0, 0 ]
[ 1, "bat", "table", 0, 0, 0, 1, 0, 1,
"bat", "table", 0, 0, 0, 1, 0 ]
[ 2, "bit", "boolean", 1, 0, 2, 2, 0, 2,
"bit", "boolean", 1, 0, 2, 2, 0 ]
[ 3, "str", "char", 0, 0, 0, 3, 0, 3, "str",
"char", 0, 0, 0, 3, 0 ]
[ 4, "str", "varchar", 0, 0, 0, 4, 0, 4,
"str", "varchar", 0, 0, 0, 4, 0 ]
[ 5, "str", "clob", 0, 0, 0, 4, 0, 5, "str",
"clob", 0, 0, 0, 4, 0 ]
[ 6, "bte", "tinyint", 8, 1, 2, 6, 0, 6,
"bte", "tinyint", 8, 1, 2, 6, 0 ]
[ 7, "sht", "smallint", 16, 1, 2, 6, 0, 7,
"sht", "smallint", 16, 1, 2, 6, 0 ]
[ 8, "oid", "oid", 31, 0, 2, 6, 0, 8, "oid",
"oid", 31, 0, 2, 6, 0 ]
[ 9, "int", "int", 32, 1, 2, 6, 0, 9, "int",
"int", 32, 1, 2, 6, 0 ]
[ 10, "lng", "bigint", 64, 1, 2, 6, 0, 10,
"lng", "bigint", 64, 1, 2, 6, 0 ]
[ 11, "wrd", "wrd", 64, 1, 2, 6, 0, 11, "wrd",
"wrd", 64, 1, 2, 6, 0 ]
[ 12, "bte", "decimal", 2, 1, 10, 8, 0, 12,
"bte", "decimal", 2, 1, 10, 8, 0 ]
[ 13, "sht", "decimal", 4, 1, 10, 8, 0, 13,
"sht", "decimal", 4, 1, 10, 8, 0 ]
[ 14, "int", "decimal", 9, 1, 10, 8, 0, 14,
"int", "decimal", 9, 1, 10, 8, 0 ]
[ 15, "lng", "decimal", 19, 1, 10, 8, 0, 15,
"lng", "decimal", 19, 1, 10, 8, 0 ]
[ 16, "flt", "real", 24, 2, 2, 9, 0, 16, "flt",
"real", 24, 2, 2, 9, 0 ]
[ 17, "dbl", "double", 53, 2, 2, 9, 0, 17,
"dbl", "double", 53, 2, 2, 9, 0 ]
[ 18, "int", "month_interval", 32, 0, 2, 7, 0,
18, "int", "month_interval", 32, 0, 2, 7, 0
]
[ 19, "lng", "sec_interval", 19, 1, 10, 7, 0, 19,
"lng", "sec_interval", 19, 1, 10, 7, 0 ]
[ 20, "daytime", "time", 7, 0, 0, 10, 0, 20,
"daytime", "time", 7, 0, 0, 10, 0 ]
[ 21, "daytime", "timetz", 7, 1, 0, 10, 0,
21, "daytime", "timetz", 7, 1, 0, 10, 0
]
[ 22, "date", "date", 0, 0, 0, 11, 0, 22, "date",
"date", 0, 0, 0, 11, 0 ]
[ 23, "timestamp", "timestamp", 7, 0, 0, 12, 0,
23, "timestamp", "timestamp", 7, 0, 0, 12, 0
]
[ 24, "timestamp", "timestamptz", 7, 1, 0, 12, 0,
24, "timestamp", "timestamptz", 7, 1, 0, 12, 0
]
[ 25, "sqlblob", "blob", 0, 0, 0, 5, 0, 25,
"sqlblob", "blob", 0, 0, 0, 5, 0 ]
# 22:07:50 >
# 22:07:50 > Done.
# 22:07:50 >
--- NEW FILE: orIssue.SF-2812504.stable.out ---
stdout of test 'orIssue.SF-2812504` in directory 'src/test/BugTracker-2009`
itself:
# 22:07:51 >
# 22:07:51 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31814 --set
xrpc_port=47766 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 22:07:51 >
# MonetDB server v5.14.0, based on kernel v1.32.0
# Serving database 'mTests_src_test_BugTracker-2009', using 4 threads
# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-July 2008 CWI.
# Copyright (c) August 2008-2009 MonetDB B.V., all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://alf.ins.cwi.nl:31814/
# MonetDB/SQL module v2.32.0 loaded
Ready.
#function user.main():void;
# clients.quit();
#end main;
Over..
# 22:07:51 >
# 22:07:51 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31814
# 22:07:51 >
% sys.kvk, sys.kvk, sys.kvk, sys.kvk, sys.kvk,
sys.kvk, sys.anbi, sys.anbi, sys.anbi, sys.anbi #
table_name
% kvk, bedrijfsnaam, adres, postcode, plaats, type, naam,
vestigingsplaats, beschikking, intrekking # name
% bigint, varchar, varchar, varchar, varchar,
varchar, varchar, varchar, date, date # type
% 1, 0, 0, 0, 0, 0, 0, 0, 10, 10 #
length
# 22:07:51 >
# 22:07:51 > Done.
# 22:07:51 >
--- NEW FILE: orIssue.SF-2812504.stable.err ---
stderr of test 'orIssue.SF-2812504` in directory 'src/test/BugTracker-2009`
itself:
# 22:07:51 >
# 22:07:51 > mserver5
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10
--set gdk_nr_threads=0 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm"
--set mapi_open=true --set xrpc_open=true --set mapi_port=31814 --set
xrpc_port=47766 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker-2009" --set mal_listing=0 "--dbinit=
include sql;" ; echo ; echo Over..
# 22:07:51 >
# builtin opt gdk_arch = 64bitx86_64-unknown-linux-gnu
# builtin opt gdk_version = 1.32.0
# builtin opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# builtin opt exec_prefix = ${prefix}
# builtin opt gdk_dbname = tst
# builtin opt gdk_dbfarm = ${prefix}/var/MonetDB
# builtin opt gdk_debug = 8
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_vmtrim = yes
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path = ${exec_prefix}/lib/MonetDB
# builtin opt monet_daemon = yes
# builtin opt host = localhost
# builtin opt mapi_port = 50000
# builtin opt mapi_noheaders = no
# builtin opt mapi_debug = 0
# builtin opt mapi_clients = 2
# builtin opt sql_debug = 0
# builtin opt sql_logdir = sql_logs
# builtin opt xquery_logdir = xquery_logs
# builtin opt standoff_ns = http://monetdb.cwi.nl/standoff
# builtin opt standoff_start = start
# builtin opt standoff_end = end
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt config = ${prefix}/etc/monetdb5.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt gdk_dbfarm = ${prefix}/var/MonetDB5/dbfarm
# config opt gdk_dbname = demo
# config opt gdk_alloc_map = no
# config opt gdk_embedded = no
# config opt gdk_debug = 0
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB5:${exec_prefix}/lib/MonetDB5/lib:${exec_prefix}/lib/MonetDB5/bin
# config opt monet_daemon = no
# config opt monet_welcome = yes
# config opt mero_msglog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_errlog = ${prefix}/var/log/MonetDB/merovingian.log
# config opt mero_pidfile = ${prefix}/var/run/MonetDB/merovingian.pid
# config opt mal_init = ${exec_prefix}/lib/MonetDB5/mal_init.mal
# config opt mal_listing = 2
# config opt mapi_port = 50000
# config opt mapi_autosense = false
# config opt mapi_open = false
# config opt sql_optimizer =
inline,remap,evaluate,costModel,coercions,emptySet,cluster,aliases,mergetable,deadcode,constants,commonTerms,joinPath,deadcode,reduce,garbageCollector,dataflow,history,multiplex
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf
# cmdline opt gdk_nr_threads = 0
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB5/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/dbfarm
# cmdline opt mapi_open = true
# cmdline opt xrpc_open = true
# cmdline opt mapi_port = 31814
# cmdline opt xrpc_port = 47766
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker-2009
# cmdline opt mal_listing = 0
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 22:07:51 >
# 22:07:51 > mclient -lsql -umonetdb -Pmonetdb --host=alf --port=31814
# 22:07:51 >
# 22:07:51 >
# 22:07:51 > Done.
# 22:07:51 >
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
