#34758 [NEW]: (DBLIB driver) PDOStatement::rowCount() returns int(0) on each query

From: spheroid@php.net Operating system: Mac OS X 10.4 PHP version: 5CVS-2005-10-06 (snap) PHP Bug Type: PDO related Bug description: (DBLIB driver) PDOStatement::rowCount() returns int(0) on each query Description: ------------ Using PDO DBLIB driver to connect to MSSQL server each SELECT query I've tried this far returns a valid resultset but PDOStatement::rowCount() always returns int(0). PDO::exec() returns the correct row count, however. Reproduce code: --------------- <?php $pdo = new PDO(...); $query = "SELECT 1+1"; $stmt = $pdo->query($query); var_dump($stmt->rowCount()); var_dump($stmt->fetchColumn()); var_dump($pdo->exec($query)); ?> Expected result: ---------------- int(1) string(1) "2" int(1) Actual result: -------------- int(0) string(1) "2" int(1) -- Edit bug report at http://bugs.php.net/?id=34758&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34758&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34758&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34758&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34758&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34758&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34758&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34758&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34758&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34758&r=support Expected behavior: http://bugs.php.net/fix.php?id=34758&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34758&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34758&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34758&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34758&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34758&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34758&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34758&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34758&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34758&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34758&r=mysqlcfg