php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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
View Developer Edit
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: gc at ebac dot co dot uk
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 21:01:31 2025 UTC