Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv27349/BugTracker/Tests

Added Files:
      Tag: SQL_2-18
        alter_table_add_fkey.SF-1737668.stable.err 
        alter_table_add_fkey.SF-1737668.stable.out 
Log Message:
add stable output for new alter_table_add_fkey test


--- NEW FILE: alter_table_add_fkey.SF-1737668.stable.out ---
stdout of test 'alter_table_add_fkey.SF-1737668` in directory 
'src/test/BugTracker` itself:


# 13:25:13 >  
# 13:25:13 >  Mtimeout -timeout 180  mserver5 
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--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 "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs" 
--set 
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs" 
--set mapi_open=true --set mapi_port=32311 --set xrpc_port=44827 --set 
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include 
sql;' ; echo ; echo Over..
# 13:25:13 >  

# MonetDB Server v5.0.0
# Copyright (c) 1993-2007 CWI, all rights reserved
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# dbname:mTests_src_test_BugTracker
# Visit http://monetdb.cwi.nl/ for further information

Ready.

Over..

# 13:25:13 >  
# 13:25:13 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=koala --port=32311 
# 13:25:13 >  

[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]
[ 1     ]

# 13:25:13 >  
# 13:25:13 >  Done.
# 13:25:13 >  


--- NEW FILE: alter_table_add_fkey.SF-1737668.stable.err ---
stderr of test 'alter_table_add_fkey.SF-1737668` in directory 
'src/test/BugTracker` itself:


# 13:25:13 >  
# 13:25:13 >  Mtimeout -timeout 180  mserver5 
"--config=/ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf" --debug=10 
--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 "sql_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/sql_logs" 
--set 
"xquery_logdir=/ufs/niels/scratch/rc/Linux-x86_64/var/MonetDB5/xquery_logs" 
--set mapi_open=true --set mapi_port=32311 --set xrpc_port=44827 --set 
monet_prompt= --trace "--dbname=mTests_src_test_BugTracker" --dbinit=' include 
sql;' ; echo ; echo Over..
# 13:25:13 >  

#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)

# 13:25:13 >  
# 13:25:13 >  Mtimeout -timeout 60 MapiClient -lsql -umonetdb -Pmonetdb 
--host=koala --port=32311 
# 13:25:13 >  

MAPI  = [EMAIL PROTECTED]:32311
QUERY = alter table t1 add constraint fk_t1_id_t2_id FOREIGN key(id) references 
t2(id);
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 
't1.fk_t1_id_t2_id' violated
MAPI  = [EMAIL PROTECTED]:32311
QUERY = alter table t1 add constraint fk_t1_age_t3_age FOREIGN key(age) 
references t3(age);
ERROR = !SQLException:assert:INSERT INTO: FOREIGN KEY constraint 
't1.fk_t1_age_t3_age' violated

# 13:25:13 >  
# 13:25:13 >  Done.
# 13:25:13 >  



-------------------------------------------------------------------------
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

Reply via email to