ID: 33309 Updated by: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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
