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
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-sql-checkins
