Description of problem: When a table is defined as having its primary key "auto_increment", this cannot be overridden by an insert command. Version-Release number of selected component (if applicable): 3.23.58-9 How reproducible: Use the following definition: create table foo ( id int not null primary key auto_increment, s varchar(20) ); insert into foo values (0, 'foo'); insert into foo values (1, 'bar'); Actual results: An error is thrown about having duplicate indicies for the second insert statement; 'foo' was entered with an index of 1, not 0. Expected results: 'foo' is entered with an id of 0. Additional info:
AFAIK this is the intended behavior in MySQL.
Hehe. We had a midair collision. I was just putting that I found NO_AUTO_VALUE_ON_ZERO -- so never mind. Thanks! -jag