php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #37890 retrieving float datatype - similar to #19916
Submitted: 2006-06-22 16:54 UTC Modified: 2006-10-28 01:00 UTC
From: krishimeena at yahoo dot com Assigned:
Status: No Feedback Package: MSSQL related
PHP Version: 5.1.5CVS OS: UNIX
Private report: No CVE-ID: None
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: krishimeena at yahoo dot com
New email:
PHP Version: OS:

 

 [2006-06-22 16:54 UTC] krishimeena at yahoo dot com
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;




Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-10-20 15:07 UTC] frediano dot ziglio at vodafone dot com
Which platform are you using?

freddy77
 [2006-10-20 15:15 UTC] tony2001@php.net
Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.php.net/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to "Open".

Thank you for your interest in PHP.



 [2006-10-28 01:00 UTC] php-bugs at lists dot php dot net
No feedback was provided for this bug for over a week, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
 
PHP Copyright © 2001-2023 The PHP Group
All rights reserved.
Last updated: Thu Feb 02 02:05:53 2023 UTC