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

Sunny Bains wrote:
> 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
>
> Is there a reason for this ? I think it should be 3.

Small clarification:

I say 3 because get_auto_increment() will be called for the first time when write_row() is called for (NULL, 'b').

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