ZF-7668: Support DB Link identifier as part of table name
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.