php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #8612 Incorrect retrieval of data
Submitted: 2001-01-09 04:26 UTC Modified: 2001-03-16 08:33 UTC
From: gc at ebac dot co dot uk Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.4 OS: Redhat 7.0
Private report: No CVE-ID: None
 [2001-01-09 04:26 UTC] gc at ebac dot co dot uk
Complied version 4.0.4 with openlink support. I had a problem in the compile with SQLINTEGER not defined error message. Followed the following from phpbuilder as a workaround
................
I've post a message in PHP.net's bug database and they have analysised and assigned to some guy named Zeev. I think it should be resolved already or in near future. 

There is a temp workaround: 

search for "SQLINTEGER len;" string in /ext/odbc/php_odbc.c file in php4 source directory and replace it with "SDWORD len;" 

happy with your compiling! 

silen 
......................

This compiles ok, but when trying to retrieve data, the wrong records are returned.

e.g. If a table contains the following values. Primary Key is Firstname,Surname.

Firstname     Surname
Fred          Smith
Fred          Jones
Bill          Bloggs
Bill          Brown

Querying the table for all values will return

Fred Smith
Fred Smith
Bill Bloggs
Bill Bloggs

Testing the odbc connection with odbctest program from openlink yields the correct answers.

I then compiled PHP 3.0.18, and the problem is fixed here.  Therefore the bug does not exist in 3.0.18, but does in 4.0.4.

Nb My database is Oracle 8.0.5



Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-17 09:36 UTC] kalowsky@php.net
The first part of this bug (SQLINTEGER section) should now be set in the PHP4.0.4pl1, please try the latest builds and see if this action continues for you.  
 [2001-03-16 08:33 UTC] kalowsky@php.net
No user feedback, considered fixed in current.  If untrue, please reopen the bug...
 [2001-03-16 08:33 UTC] kalowsky@php.net
No user feedback, considered fixed in current.  If untrue, please reopen the bug...
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 18 22:01:28 2024 UTC