#30351 [NEW]: PHP crashes on the REAL data type in a MSSQL query

From: davidifre at yahoo dot com Operating system: solaris 5.8 PHP version: 4.3.9 PHP Bug Type: MSSQL related Bug description: PHP crashes on the REAL data type in a MSSQL query Description: ------------ I use freetds 0.62.4. I have a table with rows of different data type (binary, datetime, int, bit, smallint, tinyint, varbinary, varchar and real). A query with a request on the real data row (name is "value") will crash php whereas other requests are ok: here is what i have in my apache logs [Thu Oct 7 09:11:16 2004] [notice] child pid 3045 exit signal Bus Error (10) It is not browser dependent but with Netscape7 I have a message "this document contains no data". any idea? compiled (I removed every path): --with-apache --with-ldap --with-mysql --with-pgsql --with-sybase --with-oracle --with-oci8 --with-mssql --with-gd --with-zlib-dir --with-zip --with-jpeg-dir --with-png-dir --with-tiff-dir --with-pdflib --with-imap --with-snmp --with-mcrypt --with-sablot --with-expat-dir --with-gettext --enable-sysvsem --enable-sysvshm --enable-yp --enable-ftp --enable-calendar --enable-mbstring=all --without-pear --disable-cli Reproduce code: --------------- $req_SQL="SELECT value from table_name"; $id_con=mssql_connect("host:port","username","pwd") or die ("Could not connect to database: ".mssql_get_last_message()); $msdb=mssql_select_db("base_name",$id_con); $result=mssql_query($req_SQL,$id_con); -- Edit bug report at http://bugs.php.net/?id=30351&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=30351&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=30351&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=30351&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=30351&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=30351&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=30351&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=30351&r=needscript Try newer version: http://bugs.php.net/fix.php?id=30351&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=30351&r=support Expected behavior: http://bugs.php.net/fix.php?id=30351&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=30351&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=30351&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=30351&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=30351&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=30351&r=dst IIS Stability: http://bugs.php.net/fix.php?id=30351&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=30351&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=30351&r=float MySQL Configuration Error: http://bugs.php.net/fix.php?id=30351&r=mysqlcfg