Bug #18429 Updated: mssql_query() crashes on stored procedure using a cursor on query that contains

ID: 18429 Updated by: sniper@php.net Reported By: hujbanan@yahoo.com Status: Open Bug Type: MSSQL related Operating System: Win2000 -PHP Version: 4.2.2-dev +PHP Version: 4.3.0-dev New Comment: please don't change the version to earlier if you already confirmed it to happen with the LATEST.. Previous Comments: ------------------------------------------------------------------------ [2002-07-19 08:24:51] hujbanan@yahoo.com I have tried new update of stable version, but with the same result, it doesn't work. I send to you some example of code, which cause troubles, because I believe, it can help you to debug this problem. stored procedure: ALTER PROCEDURE sp_fetch_row @row int = 1 AS OPEN GLOBAL rowset FETCH ABSOLUTE @row FROM GLOBAL rowset CLOSE GLOBAL rowset DEALLOCATE GLOBAL rowset GO php: function fetch_row( $link, $query, $row = 1 ) { if ( mssql_query( "DECLARE rowset CURSOR GLOBAL SCROLL FOR $query", $link ) ) { if ( $result = mssql_query( "EXEC sp_fetch_row $row", $link ) ) { $row = mssql_fetch_assoc( $result ); mssql_free_result( $result ); } else mssql_query( 'DEALLOCATE GLOBAL rowset', $link ); } return $row; } $result = fetch_row( $link, 'SELECT id, name FROM store', 3 ); // OK $result = fetch_row( $link, 'SELECT id*2, name FROM store', 3 ); // fails ------------------------------------------------------------------------ [2002-07-19 04:55:10] sniper@php.net version update ------------------------------------------------------------------------ [2002-07-19 02:16:43] hujbanan@yahoo.com I use PHP statement mssql_query( "EXEC db_proc 1, 2, 3" ) {query B} to call stored procedure on MSSQL 2000 server, which produces output using cursor. Before it, I create global cursor using mssql_query( "DECLARE rowset CURSOR GLOBAL SCROLL FOR $query" ) {query A}. I need dynamically choose executed query, so I can't declare cursor in stored procedure. Statement {A} creates global cursor which is fetched and dropped in SP db_proc {B}. When I use as $query SQL command 'SELECT id FROM store', it works fine. But if I use something like 'SELECT id+1 AS col FROM store', PHP function mssql_query crashes. However, both of sequences of SQL queries run without problems in SQL Query Analyzer (SQL 2k). I found this problem on PHP version 4.2.0 for win32. I try latest version of PHP from http://snaps.php.net/win32/ (both, stable v4.2.2-dev and unstable v4.3.0-dev) but problem persists. I'm using Apache 1.3.20/PHP 4.2.0 on Win2k advanced server. I have step by step tryed Apache 2.0.39 with PHP v4.2.1, 4.2.2-dev and 4.3.0-dev, but with the same result. Can you tell me, what is wrong? Is it PHP bug or mistake in PHP/Apache configuration? I used default settings of PHP and Apache, PHP extensions: dba, mssql & gd. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=18429&edit=1