Update of /cvsroot/monetdb/sql/src/test/BugTracker/Tests
In directory
sc8-pr-cvs16.sourceforge.net:/tmp/cvs-serv19709/src/test/BugTracker/Tests
Modified Files:
number_null_first_row.SF-1833286.stable.err
Added Files:
auto_increment.SF-1834820.sql
Log Message:
propagated changes of Saturday Nov 17 2007 - Tuesday Nov 20 2007
from the SQL_2-20 branch to the development trunk
--- NEW FILE: auto_increment.SF-1834820.sql ---
CREATE TABLE testusers (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(40),
fullname VARCHAR(100),
PRIMARY KEY (id)
);
INSERT INTO testusers (id, name, fullname) VALUES (1, 'wendy', 'Wendy
Wones');
select * from testusers;
-- This will fail the first time
INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone');
select * from testusers;
-- Now it will succeed
INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone');
select * from testusers;
drop table testusers;
Index: number_null_first_row.SF-1833286.stable.err
===================================================================
RCS file:
/cvsroot/monetdb/sql/src/test/BugTracker/Tests/number_null_first_row.SF-1833286.stable.err,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -d -r1.2 -r1.3
--- number_null_first_row.SF-1833286.stable.err 17 Nov 2007 16:32:59 -0000
1.2
+++ number_null_first_row.SF-1833286.stable.err 20 Nov 2007 13:27:00 -0000
1.3
@@ -12,11 +12,12 @@
# 21:23:57 > mclient -lsql -umonetdb -Pmonetdb --host=koala --port=33754
# 21:23:57 >
-MAPI = [EMAIL PROTECTED]:33724
+MAPI = [EMAIL PROTECTED]:37532
QUERY = INSERT into "decimal_null" values (NULL);
-
-MAPI = [EMAIL PROTECTED]:33724
+ERROR = !ERROR: INSERT INTO: NOT NULL constraint violated for column
decimal_null.promoid
+MAPI = [EMAIL PROTECTED]:37532
QUERY = INSERT into "decimal_null" values (NULL);
+ERROR = !ERROR: INSERT INTO: NOT NULL constraint violated for column
decimal_null.promoid
# 21:23:57 >
-------------------------------------------------------------------------
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
