Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16:/tmp/cvs-serv3115/src/test/BugTracker/Tests
Modified Files:
All cardinality_violation.SF-1240701.stable.err.Five
copy_decimal.SF-1582957.stable.err
copy_decimal.SF-1582957.stable.err.Five
Added Files:
crash_on_fkey_update.SF-1703497.sql
crash_on_fkey_update.SF-1703497.stable.err
crash_on_fkey_update.SF-1703497.stable.out
Log Message:
propagated changes of Thursday Apr 12 2007 - Friday Apr 27 2007
from the SQL_2-16 branch to the development trunk
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.45
retrieving revision 1.46
diff -u -d -r1.45 -r1.46
--- All 1 Apr 2007 22:08:58 -0000 1.45
+++ All 27 Apr 2007 09:45:54 -0000 1.46
@@ -51,3 +51,4 @@
limits_of_decimal.SF-1685357
like_join.SF-1684798
prepare_decimal_float.SF-1675795
+crash_on_fkey_update.SF-1703497
--- NEW FILE: crash_on_fkey_update.SF-1703497.stable.out ---
stdout of test 'crash_on_fkey_update.SF-1703497` in directory
'src/test/BugTracker` itself:
# 13:27:58 >
# 13:27:58 > 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=37133 --set xrpc_port=49844 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 13:27:58 >
# 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..
# 13:27:58 >
# 13:27:58 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37133
# 13:27:58 >
[ 1 ]
[ 1 ]
# 13:27:58 >
# 13:27:58 > Done.
# 13:27:58 >
Index: copy_decimal.SF-1582957.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err.Five,v
retrieving revision 1.1
retrieving revision 1.2
diff -u -d -r1.1 -r1.2
--- copy_decimal.SF-1582957.stable.err.Five 17 Dec 2006 14:41:17 -0000
1.1
+++ copy_decimal.SF-1582957.stable.err.Five 27 Apr 2007 09:45:54 -0000
1.2
@@ -63,11 +63,11 @@
# 21:06:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32735 < copy_decimal.SF-1582957.sql
# 21:06:21 >
-MAPI = [EMAIL PROTECTED]:31292
+MAPI = [EMAIL PROTECTED]:30145
QUERY = COPY 1 RECORDS INTO LINEITEM FROM stdin USING DELIMITERS '|','|\n';
ERROR = !SQLException:sql:decimal wrong format (17.000)
!SQLException:importTable:failed to import table
- !ERROR: value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj not inserted
+ !ERROR: value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj from line 0 not inserted
# 21:06:21 >
# 21:06:21 > Done.
--- NEW FILE: crash_on_fkey_update.SF-1703497.stable.err ---
stderr of test 'crash_on_fkey_update.SF-1703497` in directory
'src/test/BugTracker` itself:
# 13:27:58 >
# 13:27:58 > 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=37133 --set xrpc_port=49844 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --dbinit=" module(sql_server);" ; echo ;
echo Over..
# 13:27:58 >
# builtin opt gdk_arch = 64bitx86_64-redhat-linux-gnu
# builtin opt gdk_version = 1.16.3
# builtin opt monet_pid = 5907
# 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 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:${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 = 37133
# cmdline opt xrpc_port = 49844
# cmdline opt monet_prompt =
# cmdline opt gdk_dbname = mTests_src_test_BugTracker
# 13:27:58 >
# 13:27:58 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=37133
# 13:27:58 >
MAPI = [EMAIL PROTECTED]:32317
QUERY = update t2 set id = 10 where id =3;
ERROR = !SQLException:assert:UPDATE: FOREIGN KEY constraint 't2.t2_id_fkey'
violated
# 13:27:58 >
# 13:27:58 > Done.
# 13:27:58 >
Index: cardinality_violation.SF-1240701.stable.err.Five
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/cardinality_violation.SF-1240701.stable.err.Five,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -d -r1.8 -r1.9
--- cardinality_violation.SF-1240701.stable.err.Five 17 Apr 2007 12:58:01
-0000 1.8
+++ cardinality_violation.SF-1240701.stable.err.Five 27 Apr 2007 09:45:54
-0000 1.9
@@ -70,7 +70,7 @@
MAPI = [EMAIL PROTECTED]:33125
QUERY = select * from env() as env where name = ( select 'prefix' from env()
as env );
-ERROR = !SQLException:zero_or_one:cardinality violation (38>1)
+ERROR = !SQLException:zero_or_one:cardinality violation (39>1)
MAPI = [EMAIL PROTECTED]:33125
QUERY = select * from columns where name = (select columns.name from _tables,
columns where _tables.id = columns.table_id);
ERROR = !SQLException:zero_or_one:cardinality violation (170>1)
--- NEW FILE: crash_on_fkey_update.SF-1703497.sql ---
create table t1 (id int, name varchar(1024), PRIMARY KEY(id));
create table t2 (id int, age int, FOREIGN KEY(id) REFERENCES t1(id));
insert into t1 values(3, 'monb');
insert into t2 values(3, 25);
update t2 set id = 10 where id =3;
Index: copy_decimal.SF-1582957.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/copy_decimal.SF-1582957.stable.err,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- copy_decimal.SF-1582957.stable.err 1 Nov 2006 20:45:56 -0000 1.4
+++ copy_decimal.SF-1582957.stable.err 27 Apr 2007 09:45:54 -0000 1.5
@@ -63,10 +63,10 @@
# 21:06:21 > Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb
--host=localhost --port=32735 < copy_decimal.SF-1582957.sql
# 21:06:21 >
-MAPI = [EMAIL PROTECTED]:38505
+MAPI = [EMAIL PROTECTED]:36408
QUERY = COPY 1 RECORDS INTO LINEITEM FROM stdin USING DELIMITERS '|','|\n';
ERROR = !ERROR: decimal wrong format (17.000)
- !ERROR: value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj not inserted
+ !ERROR: value
17.000|17954.55|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN
PERSON|TRUCK|blithely regular ideas caj from line 0 not inserted
!ERROR: importTable: failed to import table
!ERROR: mvc_import_table_wrap: operation failed.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
