Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 1.7.4
-
Fix Version/s: 1.9.6
-
Component/s: Zend_Db_Adapter_Oracle, Zend_Db_Table
-
Labels:None
-
Tags:
Description
Oracle supports DB Links in order to query remote schemas via the following syntax
SELECT TABLE_NAME.* FROM SCHEMA.TABLE_NAME@LINK
Using Zend_Db_Table_Abstract, if I use something like
protected $_schema = 'SCHEMA'; protected $_name = 'TABLE_NAME@LINK';
the generated identifiers in SELECT statements appears as
SELECT "TABLE_NAME@LINK".* FROM "SCHEMA"."TABLE_NAME@LINK" ...
when it should be
SELECT "TABLE_NAME".* FROM "SCHEMA"."TABLE_NAME"@"LINK" ...
The issue is that the @ should not be quoted in the FROM clause nor should the link be included in the column prefix.
P.S. We're stuck at ZF 1.7.4 due to RHEL PHP version however a quick glance at 1.9.1 does not seem to indicate that this issue is resolved.
does this not work?