v5.1 AUTOINC - handler::get_auto_increment() - question

Hi,

Given the table def:

CREATE TABLE `t1` (
`c1` int(11) NOT NULL AUTO_INCREMENT,
`c2` varchar(10) DEFAULT NULL,

  PRIMARY KEY (`c1`)
) ENGINE=InnoDB;

for the following statement:

INSERT INTO t1(c1,c2) VALUES(1, 'a'), (NULL, 'b'), (3, 'c'), (NULL,'d');

When MySQL calls the engine's get_auto_increment() method it passes a value of 4 for the nb_desired_values parameter.

Breakpoint 4, ha_innobase::get_auto_increment (this=0x86c5740, offset=1,

    increment=1, nb_desired_values=4, first_value=0x8eb1d1c0,     nb_reserved_values=0x8eb1d1b8) at handler/ha_innodb.cc:7631

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related lists.mysql.com Links announce benchmarks bugs certification cluster commits dotnet gui-tools internals java maxdb myodbc mysql mysqldoc packagers perl plusplus replication win32 Request more information about Pantek

Is there a reason for this ? I think it should be 3.

Regards,
-sunny

-- 
MySQL Internals Mailing List
For list archives: 
http://lists.mysql.com/internals
To unsubscribe:    
http://lists.mysql.com/internals?unsub=lists@pantek.com