From: Operating system: All (linux tested) PHP version: 5.3.8 Package: InterBase related Bug Type: Bug Bug description:Integer returned as a 64bit integer on X64_86
Description: ------------ Integer on firebird is treated as a 32 bit int and int64 is used as a 64 bit integer. In the pdo_firebird driver INT64 is not implemented and LONG (int32) is treated as a long integer. On an x86_64 machine this means that a SQL_LONG doesn't honor the bit-sign in a value and INT64 doesn't return anything. This patch should fix this value for x86_64 systems while leaving x86 systems unchanged. Test script: --------------- any firebirdSQL database with a integer field containing a negative value. retrieve the value with the pdo_firebird driver on a 64 bit machine and echo it to the screen. Expected result: ---------------- negative values with integer and should be returned as a negative number. Actual result: -------------- negative values are returned as their unsigned counterpart. -- Edit bug report at https://bugs.php.net/bug.php?id=60052&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=60052&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=60052&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=60052&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=60052&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=60052&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=60052&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=60052&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=60052&r=needscript Try newer version: https://bugs.php.net/fix.php?id=60052&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=60052&r=support Expected behavior: https://bugs.php.net/fix.php?id=60052&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=60052&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=60052&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=60052&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=60052&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=60052&r=dst IIS Stability: https://bugs.php.net/fix.php?id=60052&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=60052&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=60052&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=60052&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=60052&r=mysqlcfg