ID: 37890 Comment by: frediano dot ziglio at vodafone dot com Reported By: krishimeena at yahoo dot com Status: Open Bug Type: MSSQL related Operating System: UNIX PHP Version: 5.1.5CVS New Comment:
Which platform are you using? freddy77 Previous Comments: ------------------------------------------------------------------------ [2006-06-22 16:54:03] 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; ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37890&edit=1
