[eluser]Frank Liu[/eluser]
Bug with left outer join when using oci8.
I was trying DMZ out and found that many of the left outer join queries are written as
select *
from "TABLE1" left outer join "TABLE2" as TABLE on ...
However, oracle, does not support this. Removing the "as" keyword resolves the issue, since oracle's alias doesn't work this way.
When i was trying out the original DM I didn't have this issue. In addition i found the following line in the DB_active_rec file (though not 100% sure if this is what prevents the original DM from having this problem):
$table = preg_replace('/ AS /i', ' ', $table); // line 1459
this should properly remove the "as" keyword. Perhaps DMZ can adopt a similar approach?