Edit report at https://bugs.php.net/bug.php?id=64522&edit=1
ID: 64522
Updated by: ssuffic...@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] ssuffic...@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] ssuffic...@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] ssuffic...@php.net
See commit 9ef762d:
[master 9ef762d] FIX BUG #64522
1 file changed, 2 insertions(+), 3 deletions(-)
------------------------------------------------------------------------
[2013-05-31 04:35:41] ssuffic...@php.net
Related To: Bug #64522
------------------------------------------------------------------------
[2013-05-30 05:12:16] ssuffic...@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
