Bug #8941 Updated: Openlink/ODBC cannot parse complex queries

ID: 8941 Updated by: ahill Reported By: mnewnham@adacorp.com Status: Open Bug Type: ODBC related Operating system: PHP Version: 4.0.2 Assigned To: Comments: 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 Previous Comments: --------------------------------------------------------------------------- [2001-04-02 17:01:59] mnewnham@adacorp.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-04-02 16:55:47] kalowsky@php.net have you tried updating to the latest OpenLink libraries? They have supposedly been better enhanced and unified with PHP. --------------------------------------------------------------------------- [2001-02-05 10:36:30] mnewnham@adacorp.com problem still exists in PHP 404 sp1 --------------------------------------------------------------------------- [2001-01-26 12:27:51] mnewnham@adacorp.com Configuration above should show PHP4.0.2 not 4.0.1pl2 --------------------------------------------------------------------------- [2001-01-26 12:26:10] mnewnham@adacorp.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^ --------------------------------------------------------------------------- The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online. ATTENTION! Do NOT reply to this email! To reply, use the web interface found at http://bugs.php.net/?id=8941&edit=2