[PHP-DEV] PHP 4.0 Bug #6675: mysql_insert_id returns incorrect size for BIGINT fields From: danbeck <email protected>
Date: 09/12/00

From: danbeck <email protected>
Operating system: Linux (redhat 6.1)
PHP version: 4.0.0
PHP Bug Type: MySQL related
Bug description: mysql_insert_id returns incorrect size for BIGINT fields

If you have a table with an auto_increment BIGINT field:

CREATE TABLE bigtest (
  id bigint(20) NOT NULL auto_increment,
  PRIMARY KEY (id)
);

and the last ID you inserted was larger than 32 bits:

i.e. 293949384923

If you insert a new record using:

  insert into bigtest values (null);

mysql_insert_id() will return an incorrect number usually negative. It looks like it's storing that large (64bit) number in a 32bit field of some sort before returning it to the caller. 

-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: php-dev-unsubscribe <email protected>
For additional commands, e-mail: php-dev-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>