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
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: davidifre at yahoo dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2024 The PHP Group
All rights reserved.
Last updated: Sat Dec 14 02:01:27 2024 UTC