ID: 33309
Updated by: fmk@php.net
Reported By: alexander dot merz at gmail dot com
Status: Feedback
Bug Type: MSSQL related
Operating System: Windows XP Home
PHP Version: 5.0.4
New Comment:
The same code works fine with previous versions of MS SQL Server.
MS SQL Server 2005 Beta is not a stable target to test against.
Previous Comments:
------------------------------------------------------------------------
[2005-06-11 15:25:05] sniper@php.net
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
------------------------------------------------------------------------
[2005-06-11 14:14:06] alexander dot merz at gmail dot com
Description:
------------
Running the current PEAR::MDB2 testsuite in CVS against MS SQLServer
2005 Beta causes a crash of php.
The source causing the crash reduced to a minimum is given in the
"Reproduced code" section.
The crash does also happend if you list the field names directly:
'SELECT user_name, user_password, subscribed, user_id, quota, weight,
access_date, access_time, approved FROM users'
It does crash too, if the statment above contains only the first two
fields (user_name, user_password) and *one* of the others, ie:
'SELECT user_name, user_password, subscribed FROM users'
It *works*, if the field list does NOT contain the user_password field,
independed of length of the field list, ie:
'SELECT user_name, subscribed, user_id, quota, weight, access_date,
access_time, approved FROM users'
user_password is of the type 'text'.
The table is empty, and the statement works like a charm in the SQL
Query console of Server Management Studio.
Reproduce code:
---------------
$c = mssql_connect("ALEX", "amerz", "amerz");
mssql_select_db("driver_test", $c);
mssql_query('SELECT * FROM users');
mssql_close($c);
Expected result:
----------------
No crash :)
Actual result:
--------------
a crash :(
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33309&edit=1