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 Add Comment Developer Edit
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved. 		Last updated: Wed Apr 24 19:01:31 2024 UTC