Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv17858/src/test/BugTracker/Tests
Modified Files:
All
Added Files:
number_null_first_row.SF-1833286.sql
number_null_first_row.SF-1833286.stable.err
number_null_first_row.SF-1833286.stable.out
Log Message:
propagated changes of Thursday Nov 15 2007 - Saturday Nov 17 2007
from the SQL_2-20 branch to the development trunk
--- NEW FILE: number_null_first_row.SF-1833286.stable.out ---
stdout of test 'number_null_first_row.SF-1833286` in directory
'src/test/BugTracker` itself:
# 21:38:39 >
# 21:38:39 > 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_open=true --set xrpc_open=true --set mapi_port=33724 --set
xrpc_port=47041 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" "--dbinit= module(sql_server);" ; echo ;
echo Over..
# 21:38:39 >
# MonetDB Server v4.20.0
# based on GDK v1.20.0
# 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.
# MonetDB/SQL module v2.20.1 loaded
printf("\nReady.\n");
Ready.
quit();
Over..
# 21:23:57 >
# 21:23:57 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=33754
# 21:23:57 >
[ 1 ]
[ 1 ]
[ 1 ]
[ 1 ]
# 21:23:57 >
# 21:23:57 > Done.
# 21:23:57 >
--- NEW FILE: number_null_first_row.SF-1833286.stable.err ---
stderr of test 'number_null_first_row.SF-1833286` in directory
'src/test/BugTracker` itself:
# 21:23:57 >
# 21:23:57 > 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 mapi_open=true --set xrpc_open=true --set mapi_port=33754 --set
xrpc_port=44548 --set monet_prompt= --trace
"--dbname=mTests_src_test_BugTracker" --set mal_listing=0 "--dbinit= include
sql;" ; echo ; echo Over..
# 21:23:57 >
#warning: please don't forget to set your vault key!
#(see /ufs/niels/scratch/rc/Linux-x86_64/etc/monetdb5.conf)
# 21:23:57 >
# 21:23:57 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=33754
# 21:23:57 >
MAPI = [EMAIL PROTECTED]:33724
QUERY = INSERT into "decimal_null" values (NULL);
MAPI = [EMAIL PROTECTED]:33724
QUERY = INSERT into "decimal_null" values (NULL);
# 21:23:57 >
# 21:23:57 > Done.
# 21:23:57 >
Index: All
===================================================================
RCS file: /cvsroot/monetdb/sql/src/test/BugTracker/Tests/All,v
retrieving revision 1.68
retrieving revision 1.69
diff -u -d -r1.68 -r1.69
--- All 9 Nov 2007 22:23:01 -0000 1.68
+++ All 17 Nov 2007 16:32:57 -0000 1.69
@@ -82,3 +82,4 @@
HAVE_JAVA?jdbc_no_debug.SF-1739356
cascade_operations_in_different_sessions.SF-1823387_create
cascade_operations_in_different_sessions.SF-1823387_drop
+number_null_first_row.SF-1833286
--- NEW FILE: number_null_first_row.SF-1833286.sql ---
CREATE TABLE decimal_null ( promoid NUMERIC(8, 2));
-- this will fail
INSERT into "decimal_null" values (NULL);
-- this will work
INSERT into "decimal_null" values (2.3);
-- now the one that failed will work
INSERT into "decimal_null" values (NULL);
drop table decimal_null;
CREATE TABLE decimal_null ( promoid NUMERIC(8, 2) NOT NULL);
-- this will fail
INSERT into "decimal_null" values (NULL);
-- this will work
INSERT into "decimal_null" values (2.3);
-- this will fail
INSERT into "decimal_null" values (NULL);
drop table decimal_null;
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Monetdb-sql-checkins mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
