PHP 4.0 Bug #8941: Openlink/ODBC cannot parse complex queries

From: mnewnham@adacorp.com Operating system: HPUX10.20 PHP version: 4.0.2 PHP Bug Type: ODBC related Bug description: Openlink/ODBC cannot parse complex queries 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^ -- Edit Bug report at: http://bugs.php.net/?id=8941&edit=1