Bug #64522 [Asn->Csd]: After first query to MSSQL (DBLIB) all the other queries return null values

Edit report at https://bugs.php.net/bug.php?id=64522&edit=1 ID: 64522 Updated by: ssufficool@php.net Reported by: capile at tecnodz dot com Summary: After first query to MSSQL (DBLIB) all the other queries return null values -Status: Assigned +Status: Closed Type: Bug Package: PDO related Operating System: Ubuntu Linux PHP Version: 5.4.13 Assigned To: ssufficool Block user comment: N Private report: N New Comment: The fix for this bug has been committed. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. For Windows: http://windows.php.net/snapshots/ Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2013-05-31 04:59:35] ssufficool@php.net Automatic comment on behalf of ssufficool Revision: http://git.php.net/?p=php-src.git;a=commit;h=0074cd2675687a25155cdde2ebc6b9f4a709c743 Log: pdo_dblib: fix bug #64522DBLIB statement destructor was being called late and clobbered results from subsequent statement objects sharing the same connection ------------------------------------------------------------------------ [2013-05-31 04:47:27] ssufficool@php.net The following patch has been added/updated: Patch Name: FIX_BUG_64522 Revision: 1369975647 URL: https://bugs.php.net/patch-display.php?bug=64522&patch=FIX_BUG_64522&revision=1369975647 ------------------------------------------------------------------------ [2013-05-31 04:35:41] ssufficool@php.net See commit 9ef762d: [master 9ef762d] FIX BUG #64522 1 file changed, 2 insertions(+), 3 deletions(-) ------------------------------------------------------------------------ [2013-05-31 04:35:41] ssufficool@php.net Related To: Bug #64522 ------------------------------------------------------------------------ [2013-05-30 05:12:16] ssufficool@php.net The pull request attached to this bug report will introduce another error when the another statement is issued without fetching ALL the previous results: SQLSTATE[HY000]: General error: 20019 Attempt to initiate a new Adaptive Server operation with results pending [20019] (severity 7) [select 1+1 as result1] The last statement should be able to be flushed using dbcancel(), but for some reason this is not working as documented. I also tried dbcanquery(). Both render the statement not re-useable, but weirdly enough the column metatdata is repopulated with the new column names and types code: print_r($pdo->getColumnMeta(0)) ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at https://bugs.php.net/bug.php?id=64522 -- Edit this bug report at https://bugs.php.net/bug.php?id=64522&edit=1