From: gtsakiris at dolnet dot gr
Operating system: Linux 2.4
PHP version: 4.3.10
PHP Bug Type: MSSQL related
Bug description: Query is correctly executed but FALSE is returned.
Description:
------------
I upgraded php from 4.3.8 to 4.3.10 and then I noticed that the
mssql_query() function returned FALSE in queries that perform a write in
the database (or stored procedures that perform a write), even though the
queries were executed and the changes were written in the tables.
I re-installed 4.3.8 again and I restored the expected behaviour of
mssql_query().
In SELECT queries nothing strange happened, I got a result handle as
expected.
Reproduce code:
---------------
$mssql = mssql_connect( "dbhost", "dbuser", "dbpass" );
mssql_select_db ("dbname" );
$res = mssql_query( "***a valid INSERT/UPDATE query***" );
if ($res === false)
{
echo "mssql_query returned false.\n";
}
else
{
echo "mssql_query returned true.\n";
}
Expected result:
----------------
If the query is correct, I would expect that true was returned.
Actual result:
--------------
Even though the query is correct I get the false message...
--
Edit bug report at http://bugs.php.net/?id=31195&edit=1
--
Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=31195&r=trysnapshot4
Try a CVS snapshot (php5.0):
http://bugs.php.net/fix.php?id=31195&r=trysnapshot50
Try a CVS snapshot (php5.1):
http://bugs.php.net/fix.php?id=31195&r=trysnapshot51
Fixed in CVS: http://bugs.php.net/fix.php?id=31195&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=31195&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=31195&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=31195&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=31195&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=31195&r=support
Expected behavior: http://bugs.php.net/fix.php?id=31195&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=31195&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=31195&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=31195&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=31195&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=31195&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=31195&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=31195&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=31195&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=31195&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=31195&r=mysqlcfg
