#38380 [NEW]: Large Numbers don't get sent properly in a prepared stmt

From: khalid at pixelcraze dot com Operating system: FC4 PHP version: 5.1.4 PHP Bug Type: MySQLi related Bug description: Large Numbers don't get sent properly in a prepared stmt Description: ------------ When sending a large number (e.g. 10354520101202315) via a prepared stmt, the end result in MySQL is not correct. MySQL 4.1.19 Reproduce code: --------------- CREATE TABLE test (number bigint(20) NOT NULL default '0') ENGINE=MyISAM DEFAULT CHARSET=latin1 $db = &new MySQLi($host,$user,$pass,$dbname); $stmt = $db->stmt_init(); $sql = "INSERT INTO test (number) VALUES (?)"; $stmt->prepare($sql); $stmt->bind_param('d',$number); $number = 10354520101202315; $result = $stmt->execute(); Expected result: ---------------- Result in MySQL is 10354520101202316 - it should be 10354520101202315. If I use a normal INSERT statement, then it works as expected. Changing the bind type to 's' then that works, but I have to change $number to $number = '10354520101202315'; Actual result: -------------- MySQL reports number as 10354520101202316 -- Edit bug report at http://bugs.php.net/?id=38380&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=38380&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=38380&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=38380&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=38380&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=38380&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=38380&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=38380&r=needscript Try newer version: http://bugs.php.net/fix.php?id=38380&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=38380&r=support Expected behavior: http://bugs.php.net/fix.php?id=38380&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=38380&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=38380&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=38380&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38380&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=38380&r=dst IIS Stability: http://bugs.php.net/fix.php?id=38380&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=38380&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=38380&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=38380&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=38380&r=mysqlcfg