From:             [EMAIL PROTECTED]
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



-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to