Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs7.sourceforge.net:/tmp/cvs-serv27554/src/test/BugTracker/Tests
Modified Files:
All rank_over.SF-1691098.stable.out
Added Files:
like_join.SF-1684798.sql like_join.SF-1684798.stable.err
like_join.SF-1684798.stable.out
limits_of_decimal.SF-1685357.sql
limits_of_decimal.SF-1685357.stable.err
limits_of_decimal.SF-1685357.stable.out
prepare_decimal_float.SF-1675795.sql
prepare_decimal_float.SF-1675795.stable.err
prepare_decimal_float.SF-1675795.stable.out
revoke_role.SF-1691646.sql revoke_role.SF-1691646.stable.err
revoke_role.SF-1691646.stable.out
subquery_orderby.SF-1688915.sql
subquery_orderby.SF-1688915.stable.err
subquery_orderby.SF-1688915.stable.out
Log Message:
propagated changes of Friday Mar 30 2007 - Monday Apr 02 2007
from the SQL_2-16 branch to the development trunk
--- NEW FILE: limits_of_decimal.SF-1685357.stable.err ---
stderr of test 'limits_of_decimal.SF-1685357` in directory
'src/test/BugTracker` itself:
# 10:32:42 >
# 10:32:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=34802 --set xrpc_port=48372 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:32:42 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 11434
# 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_mem_bigsize = 262144
# builtin opt gdk_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# 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 = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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/MonetDB.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = true
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 34802
# cmdline opt xrpc_port = 48372
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 10:32:42 >
# 10:32:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34802
# 10:32:42 >
MAPI = [EMAIL PROTECTED]:34802
QUERY = create table tab1 ( col1 decimal(20,0) not null );
ERROR = !decimal(20,0) isn't supported because P=20 + S=0 > 18 in: "create
table tab1 ( col1 decimal(20,0)"
!syntax error, unexpected NOT in: "not"
# 10:32:42 >
# 10:32:42 > Done.
# 10:32:42 >
--- NEW FILE: revoke_role.SF-1691646.stable.out ---
stdout of test 'revoke_role.SF-1691646` in directory 'src/test/BugTracker`
itself:
# 09:58:20 >
# 09:58:20 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=31889 --set xrpc_port=46427 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 09:58:20 >
# Monet Database Server V4.16.3
# Copyright (c) 1993-2007, 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");
Ready.
quit();
Over..
# 09:58:20 >
# 09:58:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31889
# 09:58:20 >
# 09:58:20 >
# 09:58:20 > Done.
# 09:58:20 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.44
retrieving revision 1.45
diff -u -d -r1.44 -r1.45
--- All 30 Mar 2007 17:49:11 -0000 1.44
+++ All 1 Apr 2007 22:08:58 -0000 1.45
@@ -46,3 +46,8 @@
decimal_prepare.SF-1655818
union_order
rank_over.SF-1691098
+revoke_role.SF-1691646
+subquery_orderby.SF-1688915
+limits_of_decimal.SF-1685357
+like_join.SF-1684798
+prepare_decimal_float.SF-1675795
--- NEW FILE: limits_of_decimal.SF-1685357.sql ---
create table tab1 ( col1 decimal(20,0) not null );
--- NEW FILE: prepare_decimal_float.SF-1675795.sql ---
create table xy ( time timestamp, x decimal(6,4), y decimal(6,4));
prepare insert into xy values (?,?,?);
exec 0 (timestamp '2007-03-07 15:28:16.577', 0.6841, 0.684);
select * from xy;
--- NEW FILE: limits_of_decimal.SF-1685357.stable.out ---
stdout of test 'limits_of_decimal.SF-1685357` in directory
'src/test/BugTracker` itself:
# 10:32:42 >
# 10:32:42 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=34802 --set xrpc_port=48372 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:32:42 >
# Monet Database Server V4.16.3
# Copyright (c) 1993-2007, 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");
Ready.
quit();
Over..
# 10:32:42 >
# 10:32:42 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=34802
# 10:32:42 >
# 10:32:42 >
# 10:32:42 > Done.
# 10:32:42 >
--- NEW FILE: revoke_role.SF-1691646.stable.err ---
stderr of test 'revoke_role.SF-1691646` in directory 'src/test/BugTracker`
itself:
# 09:58:20 >
# 09:58:20 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=31889 --set xrpc_port=46427 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 09:58:20 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 20902
# 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_mem_bigsize = 262144
# builtin opt gdk_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# 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 = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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/MonetDB.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = true
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 31889
# cmdline opt xrpc_port = 46427
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 09:58:20 >
# 09:58:20 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=31889
# 09:58:20 >
MAPI = [EMAIL PROTECTED]:31889
QUERY = REVOKE auth1 from user1;
ERROR = !REVOKE no such role 'auth1' or grantee 'user1'
# 09:58:20 >
# 09:58:20 > Done.
# 09:58:20 >
--- NEW FILE: revoke_role.SF-1691646.sql ---
------------------------------
/* revoke authorization crashes server */
REVOKE auth1 from user1;
------------------------------
--- NEW FILE: prepare_decimal_float.SF-1675795.stable.out ---
stdout of test 'prepare_decimal_float.SF-1675795` in directory
'src/test/BugTracker` itself:
# 16:00:53 >
# 16:00:53 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32565 --set xrpc_port=47589 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 16:00:53 >
# Monet Database Server V4.16.3
# Copyright (c) 1993-2007, 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");
Ready.
quit();
Over..
# 16:00:53 >
# 16:00:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32565
# 16:00:53 >
% prepare, prepare, prepare # table_name
% type, digits, scale # name
% varchar, int, int # type
% 0, 0, 0 # length
[ "timestamp", 7, 0 ]
[ "decimal", 6, 4 ]
[ "decimal", 6, 4 ]
[ 1 ]
% sys.xy, sys.xy, sys.xy # table_name
% time, x, y # name
% timestamp, decimal, decimal # type
% 26, 8, 8 # length
[ 2007-03-07 15:28:16.577000, 0.6841, 0.6840 ]
# 16:00:53 >
# 16:00:53 > Done.
# 16:00:53 >
--- NEW FILE: subquery_orderby.SF-1688915.stable.out ---
stdout of test 'subquery_orderby.SF-1688915` in directory 'src/test/BugTracker`
itself:
# 10:11:41 >
# 10:11:41 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=35778 --set xrpc_port=45704 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:11:41 >
# Monet Database Server V4.16.3
# Copyright (c) 1993-2007, 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");
Ready.
quit();
Over..
# 10:11:41 >
# 10:11:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35778
# 10:11:41 >
% .x # table_name
% name # name
% varchar # type
% 13 # length
[ "schemas" ]
[ "types" ]
[ "functions" ]
[ "args" ]
[ "sequences" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
[ "idxs" ]
[ "triggers" ]
[ "keycolumns" ]
[ "dependencies" ]
[ "connections" ]
[ "_tables" ]
[ "_columns" ]
[ "keys" ]
[ "idxs" ]
[ "triggers" ]
[ "keycolumns" ]
[ "tables" ]
[ "columns" ]
[ "db_users" ]
[ "users" ]
[ "user_role" ]
[ "auths" ]
[ "privileges" ]
[ "profile" ]
[ "test1440214" ]
[ "system" ]
[ "target" ]
[ "configuration" ]
[ "test" ]
# 10:11:41 >
# 10:11:41 > Done.
# 10:11:41 >
Index: rank_over.SF-1691098.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/rank_over.SF-1691098.stable.out,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- rank_over.SF-1691098.stable.out 30 Mar 2007 17:49:12 -0000 1.2
+++ rank_over.SF-1691098.stable.out 1 Apr 2007 22:08:58 -0000 1.3
@@ -23,42 +23,42 @@
% sys. # table_name
% foo # name
-% smallint # type
+% int # type
% 2 # length
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
-[ [EMAIL PROTECTED] ]
+[ 0 ]
+[ 1 ]
+[ 2 ]
+[ 3 ]
+[ 4 ]
+[ 5 ]
+[ 6 ]
+[ 7 ]
+[ 8 ]
+[ 9 ]
+[ 10 ]
+[ 11 ]
+[ 12 ]
+[ 13 ]
+[ 14 ]
+[ 15 ]
+[ 16 ]
+[ 17 ]
+[ 18 ]
+[ 19 ]
+[ 20 ]
+[ 21 ]
+[ 22 ]
+[ 23 ]
+[ 24 ]
+[ 25 ]
+[ 26 ]
+[ 27 ]
+[ 28 ]
+[ 29 ]
+[ 30 ]
+[ 31 ]
-# 16:03:46 >
-# 16:03:46 > Done.
-# 16:03:46 >
+# 22:21:05 >
+# 22:21:05 > Done.
+# 22:21:05 >
--- NEW FILE: subquery_orderby.SF-1688915.stable.err ---
stderr of test 'subquery_orderby.SF-1688915` in directory 'src/test/BugTracker`
itself:
# 10:11:41 >
# 10:11:41 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=35778 --set xrpc_port=45704 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 10:11:41 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 23630
# 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_mem_bigsize = 262144
# builtin opt gdk_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# 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 = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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/MonetDB.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = true
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 35778
# cmdline opt xrpc_port = 45704
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 10:11:41 >
# 10:11:41 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=35778
# 10:11:41 >
# 10:11:41 >
# 10:11:41 > Done.
# 10:11:41 >
--- NEW FILE: like_join.SF-1684798.stable.err ---
stderr of test 'like_join.SF-1684798` in directory 'src/test/BugTracker` itself:
# 11:22:29 >
# 11:22:29 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32360 --set xrpc_port=46538 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 11:22:29 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 5593
# 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_mem_bigsize = 262144
# builtin opt gdk_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# 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 = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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/MonetDB.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = true
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 32360
# cmdline opt xrpc_port = 46538
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 11:22:29 >
# 11:22:29 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32360
# 11:22:29 >
# 11:22:29 >
# 11:22:29 > Done.
# 11:22:29 >
--- NEW FILE: subquery_orderby.SF-1688915.sql ---
select name from (select name, id from tables order by id) as x;
--- NEW FILE: like_join.SF-1684798.sql ---
create table t1 (name varchar(1024), address varchar(1024), age int);
create table t2 (street varchar(1024), id int);
insert into t1 values('romulo', 'amsterdam', 23);
insert into t2 values('amsterdam', 1);
select name from t1, t2 where t1.address LIKE 'amsterdam';
select name from t1, t2 where t1.address LIKE t2.street;
drop table t1;
drop table t2;
--- NEW FILE: prepare_decimal_float.SF-1675795.stable.err ---
stderr of test 'prepare_decimal_float.SF-1675795` in directory
'src/test/BugTracker` itself:
# 16:00:53 >
# 16:00:53 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32565 --set xrpc_port=47589 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 16:00:53 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 26030
# 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_mem_bigsize = 262144
# builtin opt gdk_vm_minsize = 137438953472
# builtin opt gdk_alloc_map = yes
# builtin opt gdk_mem_pagebits = 14
# builtin opt monet_admin = adm
# builtin opt monet_prompt = >
# builtin opt monet_welcome = yes
# builtin opt monet_mod_path =
${exec_prefix}/lib/MonetDB:${exec_prefix}/lib/bin
# 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 = ${prefix}/var/MonetDB/sql_logs
# builtin opt xquery_logdir = ${prefix}/var/MonetDB/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/MonetDB.conf
# config opt prefix = /ufs/niels/scratch/rc/Linux-x86_64
# config opt exec_prefix = ${prefix}
# config opt datadir = ${prefix}/share
# config opt gdk_dbfarm = ${prefix}/var/MonetDB4/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_admin = adm
# config opt monet_prompt = MonetDB>
# config opt monet_welcome = yes
# config opt monet_mod_path =
${exec_prefix}/lib/MonetDB4:${exec_prefix}/lib/MonetDB4/lib:${exec_prefix}/lib/MonetDB4/bin
# config opt monet_daemon = no
# config opt mapi_port = 50000
# config opt mapi_open = false
# config opt mapi_debug = 0
# config opt sql_debug = 0
# config opt sql_logdir = ${prefix}/var/MonetDB4/sql_logs
# config opt xquery_output = dm
# config opt xquery_cacheMB = 100
# config opt xquery_cacherules =
# config opt xquery_procMB = 128
# config opt xquery_logdir = ${prefix}/var/MonetDB4/xquery_logs
# config opt xrpc_port =
# config opt xrpc_open = true
# config opt xrpc_admin = 127.0.0.1
# config opt xrpc_user = 127.0.0.1
# config opt xrpc_trusted =
http://monetdb.cwi.nl;${prefix}/share/MonetDB/xrpc/export
# config opt standoff_ns =
# config opt standoff_start = start
# config opt standoff_end = end
# cmdline opt config = /ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf
# cmdline opt gdk_debug = 10
# cmdline opt monet_mod_path =
/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin
# cmdline opt gdk_dbfarm =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm
# cmdline opt sql_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs
# cmdline opt xquery_logdir =
/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs
# cmdline opt mapi_port = 32565
# cmdline opt xrpc_port = 47589
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 16:00:53 >
# 16:00:53 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32565
# 16:00:53 >
# 16:00:53 >
# 16:00:53 > Done.
# 16:00:53 >
--- NEW FILE: like_join.SF-1684798.stable.out ---
stdout of test 'like_join.SF-1684798` in directory 'src/test/BugTracker` itself:
# 11:22:29 >
# 11:22:29 > Mtimeout -timeout 180 Mserver
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/MonetDB.conf" --debug=10 --set
"monet_mod_path=/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/lib:/ufs/niels/scratch/rc/Linux-x86_64/lib/MonetDB4/bin"
--set "gdk_dbfarm=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/dbfarm"
--set "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/sql_logs"
--set
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB4/xquery_logs"
--set mapi_port=32360 --set xrpc_port=46538 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 11:22:29 >
# Monet Database Server V4.16.3
# Copyright (c) 1993-2007, 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");
Ready.
quit();
Over..
# 11:22:29 >
# 11:22:29 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32360
# 11:22:29 >
[ 1 ]
[ 1 ]
% sys.t1 # table_name
% name # name
% varchar # type
% 6 # length
[ "romulo" ]
% sys.t1 # table_name
% name # name
% varchar # type
% 6 # length
[ "romulo" ]
# 11:22:29 >
# 11:22:29 > Done.
# 11:22:29 >
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys-and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
