[PHP-DEV] Bug #8941 Updated: Openlink/ODBC cannot parse complex queries
ID: 8941 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Old Status: Analyzed Status: Closed Bug Type: ODBC related Operating System: HPUX10.20 PHP Version: 4.0.2 New Comment: Patch submitted sort of. Go CVS go! Connect and finish the commit! Previous Comments: [2001-07-06 10:37:42] [EMAIL PROTECTED] moving this to analyzed as hopefully once I work out this cursors patch it will be gone too! [2001-05-09 16:32:57] [EMAIL PROTECTED] 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-04-02 17:01:59] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] problem still exists in PHP 404 sp1 The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/?id=8941 Edit this bug report at http://bugs.php.net/?id=8941edit=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]
[PHP-DEV] Bug #8941 Updated: Openlink/ODBC cannot parse complex queries
ID: 8941 Updated by: kalowsky Reported By: [EMAIL PROTECTED] Old-Status: Open Status: Analyzed Bug Type: ODBC related Operating system: PHP Version: 4.0.2 Assigned To: Comments: moving this to analyzed as hopefully once I work out this cursors patch it will be gone too! Previous Comments: --- [2001-05-09 16:32:57] [EMAIL PROTECTED] 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-04-02 17:01:59] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] problem still exists in PHP 404 sp1 --- [2001-01-26 12:27:51] [EMAIL PROTECTED] Configuration above should show PHP4.0.2 not 4.0.1pl2 --- 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=8941edit=2 -- 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]
[PHP-DEV] Bug #8941 Updated: Openlink/ODBC cannot parse complex queries
ID: 8941 Updated by: ahill Reported By: [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] 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] [EMAIL PROTECTED] problem still exists in PHP 404 sp1 --- [2001-01-26 12:27:51] [EMAIL PROTECTED] Configuration above should show PHP4.0.2 not 4.0.1pl2 --- [2001-01-26 12:26:10] [EMAIL PROTECTED] 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=8941edit=2 -- 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]