From: krishimeena at yahoo dot com Operating system: UNIX PHP version: 5.1.5CVS PHP Bug Type: MSSQL related Bug description: retrieving float datatype - similar to #19916
Description: ------------ We upgraded php4 to php5 and this same listed bug has cropped up. When I query and retrieve a float or REAL datatype with a combination of some varchar 50 datatype I see an error exit bus signal error 10. As soon as I change the sequence of the retrieval of the data it works fine. Please refer to bug #19916, it appears to be the same issue. Reproduce code: --------------- This code does not work: $SQL = "BEGIN SELECT tblfirsttable.varCharData , tblSecondtable.floatData from tblfirsttable, tblSecondtable"; $query_rslt = mssql_query($SQL); $numrows = mssql_num_rows($query_rslt); echo $numrows; However if I swap the retrieval of float value first nad then the varchar it works fine: $SQL = "BEGIN SELECT tblSecondtable.floatData, tblfirsttable.varCharData from tblfirsttable, tblSecondtable"; $query_rslt = mssql_query($SQLl); $numrows = mssql_num_rows($query_rslt); echo $numrows; -- Edit bug report at http://bugs.php.net/?id=37890&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=37890&r=trysnapshot44 Try a CVS snapshot (PHP 5.2): http://bugs.php.net/fix.php?id=37890&r=trysnapshot52 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=37890&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=37890&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=37890&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=37890&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=37890&r=needscript Try newer version: http://bugs.php.net/fix.php?id=37890&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=37890&r=support Expected behavior: http://bugs.php.net/fix.php?id=37890&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=37890&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=37890&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=37890&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=37890&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=37890&r=dst IIS Stability: http://bugs.php.net/fix.php?id=37890&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=37890&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=37890&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=37890&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=37890&r=mysqlcfg
