From: [EMAIL PROTECTED] Operating system: irrelevant PHP version: 5.0.5 PHP Bug Type: MySQLi related Bug description: mysqli integet (tinyint and others) problem on 64bit
Description: ------------ In 5.0.5 (existant in 5.0.0-5.0.4) was fixed a bug appearing on 64bit architectures when using prepared statements and binding result data. In more details tinyint, year, mediumint, and int(eger) where fetched incorrectly and incorrect data was returned to the script. Use the reproduce code to test your installation. This bug report has been create TO KEEP TRACK of this bug which was fixed without corresponding bug report. For more information see : http://bugs.mysql.com/bug.php?id=14343 Reproduce code: --------------- php -r '$c= new mysqli("localhost","root","secret");$c->query("DROP TABLE IF EXIST test.tint_test;");$c->query("CREATE TABLE test.tint_test (a tinyint(3));");$c->query("INSERT INTO test.tint_test VALUES (123)");$s=$c->stmt_init();$s->prepare("select a from test.tint_test");$s->execute();$s->bind_result($v);$s->fetch();var_dump($v);$c-> query("DROP TABLE EXIST test.tint_test;");' Expected result: ---------------- int(123) Actual result: -------------- int(4357062704804921467) -- Edit bug report at http://bugs.php.net/?id=35171&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=35171&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=35171&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=35171&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=35171&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=35171&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=35171&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=35171&r=needscript Try newer version: http://bugs.php.net/fix.php?id=35171&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=35171&r=support Expected behavior: http://bugs.php.net/fix.php?id=35171&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=35171&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=35171&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=35171&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=35171&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=35171&r=dst IIS Stability: http://bugs.php.net/fix.php?id=35171&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=35171&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=35171&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=35171&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=35171&r=mysqlcfg
