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

go to bug id or search bugs for

Bug #8941 Openlink/ODBC cannot parse complex queries
Submitted: 2001-01-26 12:26 UTC Modified: 2002-01-21 09:07 UTC
From: mnewnham at adacorp dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.2 OS: HPUX10.20
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: mnewnham at adacorp dot com
New email:
PHP Version: OS:

 

 [2001-01-26 12:26 UTC] mnewnham at adacorp dot com 
Platform: HPUX 10.20
Configuration:  PHP4.0.1pl2 --with-iodbc --without-mysql  --with-pdflib=/usr/local --without-gd 
--with-apache=../apache_1.3.14      
Using Openlink MT ODBC driver against a PROGRESS database.

Any version of PHP after 4.0.1pl2 cannot parse queries with a JOIN statement in it. Versions upto and including above work ok.

The log file from the Openlink Server shows this from a sample (good) query:

generic_pro83b: SCR_AnalyseSQL failed: SELECT * FROM VIRTUAL_LAYERS INNER JOIN LAYER_INFORMATION ON LAYER_INFORMATION.LAYER1_DESCRIPTION=VIRTUAL_LAYERS.LAYER1_DESCRIPTION  
generic_pro83b: parse error 
generic_pro83b: SELECT * FROM VIRTUAL_LAYERS INNER JOIN^

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-01-26 12:27 UTC] mnewnham at adacorp dot com 
Configuration above should show PHP4.0.2 not 4.0.1pl2
 [2001-02-05 10:36 UTC] mnewnham at adacorp dot com 
problem still exists in PHP 404 sp1
 [2001-04-02 16:55 UTC] kalowsky@php.net 
have you tried updating to the latest OpenLink libraries?  They have supposedly been better enhanced and unified with PHP.
 [2001-04-02 17:01 UTC] mnewnham at adacorp dot com 
According to openlink, the issue is caused by the dynamic cursors now used in the php odbc functions. 

remarking out the #define HAVE_SQL_EXTENDED_FETCH 1 entry in the iodbc section provides a temporary relief from the problem.
 [2001-05-09 16:32 UTC] ahill@php.net 
this issue is specific to the interaction of the Progress database and the OpenLink Agent-based cursor library

once scrollable cursors are not used this is not a problem
 [2001-07-06 10:37 UTC] kalowsky@php.net 
moving this to analyzed as hopefully once I work out this cursors patch it will be gone too!
 [2002-01-21 09:07 UTC] kalowsky@php.net 
Patch submitted.... sort of.  Go CVS go!  Connect and finish the commit!
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed May 07 03:01:27 2025 UTC