Please note that this new test will not be executed, unless also added to the repstective "All" file. Stefan On Tue, Nov 20, 2007 at 06:50:31AM +0000, Martin Kersten wrote:

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

Added Files: Tag: SQL_2-20 auto_increment.SF-1834820.sql Log Message: Added the test file. Output needs to be produced.

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

------------------------------------------------------------------------- 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 Monetdb-sql-checkins@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins

-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |