php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #30351 PHP crashes on the REAL data type in a MSSQL query
Submitted: 2004-10-07 11:01 UTC Modified: 2005-11-18 20:04 UTC
Votes:1
Avg. Score:4.0 ± 0.0
Reproduced:0 of 0 (0.0%)
From: davidifre at yahoo dot com Assigned: fmk (profile)
Status: Closed Package: MSSQL related
PHP Version: 4.3.9 OS: solaris 5.8
Private report: No CVE-ID: None
 [2004-10-07 11:01 UTC] davidifre at yahoo dot com
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);




Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2004-10-19 14:34 UTC] davidifre at yahoo dot com
Hi,
do you know if this is a bug? Am I alone to experience this problem?

thx
 [2005-05-30 10:34 UTC] freddyz77 at tin dot it
What operation system are you using?
Have you tried to update FreeTDS version?

freddy77
(FreeTDS developer)
 [2005-08-09 09:05 UTC] freddyz77 at tin dot it
Well, which processor are you using? Try with FLOAT type instead of REAL.

freddy77
 [2005-11-18 20:04 UTC] fmk@php.net
There is no longer a problem with the latest version of FreeTDS
 
PHP Copyright © 2001-2022 The PHP Group
All rights reserved.
Last updated: Mon Oct 03 06:05:53 2022 UTC