Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv21863
Modified 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:
extended test also to the case where null isn't allowed.
Index: number_null_first_row.SF-1833286.stable.out
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/number_null_first_row.SF-1833286.stable.out,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- number_null_first_row.SF-1833286.stable.out 16 Nov 2007 20:26:15 -0000
1.1.2.1
+++ number_null_first_row.SF-1833286.stable.out 16 Nov 2007 20:39:33 -0000
1.1.2.2
@@ -1,24 +1,23 @@
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 >
+# 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 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 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.
-#function user.main():void;
-# clients.quit();
-#end main;
+quit();
Over..
@@ -29,6 +28,7 @@
[ 1 ]
[ 1 ]
[ 1 ]
+[ 1 ]
# 21:23:57 >
# 21:23:57 > Done.
Index: number_null_first_row.SF-1833286.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/number_null_first_row.SF-1833286.stable.err,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- number_null_first_row.SF-1833286.stable.err 16 Nov 2007 20:26:15 -0000
1.1.2.1
+++ number_null_first_row.SF-1833286.stable.err 16 Nov 2007 20:39:33 -0000
1.1.2.2
@@ -12,6 +12,12 @@
# 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.
Index: number_null_first_row.SF-1833286.sql
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/Attic/number_null_first_row.SF-1833286.sql,v
retrieving revision 1.1.2.1
retrieving revision 1.1.2.2
diff -u -d -r1.1.2.1 -r1.1.2.2
--- number_null_first_row.SF-1833286.sql 16 Nov 2007 20:26:15 -0000
1.1.2.1
+++ number_null_first_row.SF-1833286.sql 16 Nov 2007 20:39:33 -0000
1.1.2.2
@@ -10,3 +10,16 @@
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
