#33309 [NEW]: mssql_query crashes php

From: Date: Sat, 11 Jun 2005 12:14:09 +0000
Subject: #33309 [NEW]: mssql_query crashes php
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-80144@lists.php.net to get a copy of this message
From: alexander dot merz at gmail dot com Operating system: Windows XP Home PHP version: 5.0.4 PHP Bug Type: MSSQL related Bug description: mssql_query crashes php 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 bug report at http://bugs.php.net/?id=33309&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=33309&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=33309&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=33309&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=33309&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=33309&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=33309&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=33309&r=needscript Try newer version: http://bugs.php.net/fix.php?id=33309&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=33309&r=support Expected behavior: http://bugs.php.net/fix.php?id=33309&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=33309&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=33309&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=33309&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=33309&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=33309&r=dst IIS Stability: http://bugs.php.net/fix.php?id=33309&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=33309&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=33309&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=33309&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=33309&r=mysqlcfg

« previous php.bugs (#80144) next »