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

Modified Files:
      Tag: SQL_2-20
        All 
Added Files:
      Tag: SQL_2-20
        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:
test script for new bug in string 2 number conversion


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



# MonetDB server v5.2.0, based on kernel v1.20.0
# Serving database 'mTests_src_test_BugTracker'
# Compiled for x86_64-redhat-linux-gnu/64bit with 64bit OIDs dynamically linked
# Copyright (c) 1993-2007 CWI, all rights reserved
# Visit http://monetdb.cwi.nl/ for further information
# Listening for connection requests on mapi:monetdb://koala.ins.cwi.nl:33754/
# MonetDB/SQL module v2.20.1 loaded

Ready.
#function user.main():void;
#    clients.quit();
#end main;

Over..

# 21:23:57 >  
# 21:23:57 >  mclient -lsql -umonetdb -Pmonetdb --host=koala --port=33754 
# 21:23:57 >  

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


# 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.63.2.5
retrieving revision 1.63.2.6
diff -u -d -r1.63.2.5 -r1.63.2.6
--- All 9 Nov 2007 06:36:42 -0000       1.63.2.5
+++ All 16 Nov 2007 20:26:14 -0000      1.63.2.6
@@ -83,3 +83,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;


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

Reply via email to