What are the "casting" issues involved if we return a string? What is the
potential for this breaking someones code who doesn't cross the 32bit
boundary?
Sean
> -----Original Message-----
> From: Daniel Beckham [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 10:30 AM
> To: Bug Database
> Cc: [EMAIL PROTECTED]
> Subject: [PHP-DEV] Re: PHP 4.0 Bug #6675 Updated: mysql_insert_id
> returns incorrect size for BIGINT fields
>
>
> The documentation explains this issue because I wrote the
> addition after
> discovering this issue. I have a phpdoc cvs account...
> Please re-open this
> issue, unless the PHP team has no current plans to fix it.
>
> Daniel
>
> ----- Original Message -----
> From: "Bug Database" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, January 15, 2001 3:30 AM
> Subject: PHP 4.0 Bug #6675 Updated: mysql_insert_id returns
> incorrect size
> for BIGINT fields
>
>
> > ID: 6675
> > Updated by: sniper
> > Reported By: [EMAIL PROTECTED]
> > Old-Status: Open
> > Status: Closed
> > Bug Type: MySQL related
> > Assigned To:
> > Comments:
> >
> > Feedback by Sean R. Bright <[EMAIL PROTECTED]>:
> > ----------------------------------------------
> > the documentation for mysql_insert_id()
> > states that for very large values of the returned id
> (>32bits) this will
> return the wrong data and users should use LAST_INSERT_ID()
> to fetch that
> > info from mysql instead.
> > ----------------------------------------------
> >
> >
> >
> > Previous Comments:
> >
> --------------------------------------------------------------
> ------------
> -
> >
> > [2000-09-12 21:45:15] [EMAIL PROTECTED]
> > I researched this a little more and found this code snippit
> at line 1100:
> >
> > ZEND_FETCH_RESOURCE2(mysql, MYSQL *, mysql_link, id, "MySQL-Link",
> le_link, le_plink);
> >
> > /* conversion from int64 to long happing here */
> > return_value->value.lval = (long) mysql_insert_id(mysql);
> > return_value->type = IS_LONG;
> >
> >
> > Is there any way that this could be converted into a string before
> returning? (Forgive me if I'm over simplifying this...)
> >
> >
> >
> --------------------------------------------------------------
> ------------
> -
> >
> > [2000-09-12 04:54:10] [EMAIL PROTECTED]
> > 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.
> >
> >
> >
> --------------------------------------------------------------
> ------------
> -
> >
> >
> > Full Bug description available at: http://bugs.php.net/?id=6675
> >
> >
> >
>
>
> --
> PHP Development Mailing List <http://www.php.net/>
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail:
> [EMAIL PROTECTED]
>
--
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
