Bug #39136 [Com]: Calling a stored procedure that creates temp table

Edit report at https://bugs.php.net/bug.php?id=39136&edit=1 ID: 39136 Comment by: tbare83 at gmail dot com Reported by: aspen dot olmsted at alliance dot biz Summary: Calling a stored procedure that creates temp table Status: No Feedback Type: Bug Package: PDO related Operating System: Windows XP SP2 PHP Version: 5CVS-2006-10-12 (snap) Assigned To: wez Block user comment: N Private report: N New Comment: PHP 7.4 on ubuntu 20.04 - bug is still present. Previous Comments: ------------------------------------------------------------------------ [2009-05-03 01:00:01] php-bugs at lists dot php dot net No feedback was provided for this bug for over a week, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". ------------------------------------------------------------------------ [2009-04-25 14:39:14] jani@php.net Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ ------------------------------------------------------------------------ [2006-10-12 13:44:54] aspen dot olmsted at alliance dot biz Description: ------------ If I call a stored proced that creates a temp table and inserts values and returns a record set then pdo_odbc gets confused by the multiple record sets unless I set nocount to on. I am doing this against a MS_SQL 2000 sp4 database Reproduce code: --------------- Here is a sample sql sp: alter procedure pdo_test as CREATE TABLE #tmptbl ( ItemId int ) insert into #tmptbl VALUES (1) select 'Hello' msg Here is sample php: $stmt = $dbh->prepare("exec pdo_test"); $stmt->execute(); echo "Number of columns: " . $stmt->columnCount() . "<br>"; $row = $stmt->fetch(); echo "Value of column: " . var_dump($row) . "<br>"; $stmt->nextRowset(); echo "Number of columns: " . $stmt->columnCount() . "<br>"; $row = $stmt->fetch(); echo "Value of column: " . var_dump($row) . "<br>"; Expected result: ---------------- with the other db layers it is ignoring the first record set. I think it is proper that pdo_odbc sees the number of records modified but it does not return any data and I can not navigate to the actual dataset Actual result: -------------- empty dataset If I add 'set nocount on' to the SP then everything works fine alter procedure pdo_test as set nocount on CREATE TABLE #tmptbl ( ItemId int ) insert into #tmptbl VALUES (1) select 'Hello' msg ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=39136&edit=1