[Monetdb-developers] [Monetdb-sql-checkins] sql/src/test/BugTracker/Tests auto_increment.SF-1834820.sql, SQL_2-20, NONE, 1.1.2.1

Stefan Manegold Stefan.Manegold at cwi.nl
Tue Nov 20 07:55:18 CET 2007


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

-- 
| Dr. Stefan Manegold | mailto:Stefan.Manegold at 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       |




More information about the developers-list mailing list