On Wed, Nov 21, 2007 at 10:09:09PM -0700, m h wrote:

On Nov 19, 2007 3:48 PM, m h wrote:

...

Hello again -

I've filed another bug here....

http://sourceforge.net/tracker/index.php?func=detail&aid=1834820&group_id=56967&atid=482468

Similar to the NUMERIC not allowing initial NULLs, AUTO_INCREMENT won't allow skipping of Primary Keys (the first time after, the second time it works) after you've inserted with a Primary Key...

-matt

Nels - Thanks for plowing through my bugs! Sadly it appears that this one has disappeared into the ether??? (I'll blame sourceforge)

Here's the gist of my bug:

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

-- This will fail the first time INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone');

-- Now it will succeed???!!! INSERT INTO testusers (name, fullname) VALUES ('fred', 'Fred Flintstone');

I'll file another bug... I moved it to the feature requests. THis is one of the options in the bugs form.

Niels

------------------------------------------------------------------------- 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-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users

-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl