Bug #69743 [NEW]: Prepared statements in IN not returning values

From: Date: Mon, 01 Jun 2015 19:48:25 +0000
Subject: Bug #69743 [NEW]: Prepared statements in IN not returning values
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-193057@lists.php.net to get a copy of this message
From: dmitriy dot y at gmail dot com Operating system: CentOS 7 PHP version: 5.5.25 Package: ODBC related Bug Type: Bug Bug description:Prepared statements in IN not returning values Description: ------------ This works fine on Windows 8.1 64-bit, but when migrated to CentOS 7, it returns null. Connecting to MS SQL Server 2012. Test script: --------------- Works: $res = @odbc_exec($db, 'SELECT CustomerID FROM Customers WHERE CustomerID IN (1000,999,1013)'); Does not work: $query = odbc_prepare($db, 'SELECT CustomerID FROM Customers WHERE CustomerID IN (?,?,?)'); $res = @odbc_execute($query, array(1000,999,1013)); -- Edit bug report at https://bugs.php.net/bug.php?id=69743&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=69743&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=69743&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=69743&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=69743&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=69743&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=69743&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=69743&r=needscript Try newer version: https://bugs.php.net/fix.php?id=69743&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=69743&r=support Expected behavior: https://bugs.php.net/fix.php?id=69743&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=69743&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=69743&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=69743&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=69743&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=69743&r=dst IIS Stability: https://bugs.php.net/fix.php?id=69743&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=69743&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=69743&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=69743&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=69743&r=mysqlcfg

« previous php.bugs (#193057) next »