Home » Database » DB_DataObject » Bug #3706
multidatabase join support breaks postgresql join queries
Details
| Submitted | 2005-03-04 22:56 UTC |
|---|---|
| From | bugs at niluje dot net |
| Assigned | alan_k |
| Status | Closed |
| Package | DB_DataObject |
| PHP Version | 5.0.3 |
| OS | linux |
| Roadmaps | (Not assigned) |
Comments
[2005-03-04 22:56 UTC] bugs at niluje dot net
Description:
------------
After upgrading from version 1.7.2 to 1.7.5 it appears that all my apps using joinAdd are broken.
With postgresql, it's not possible to multidatabase joins but joins betweens schemas.
currently the joinAdd creates a query like that :
SELECT .... FROM ... LEFT JOIN database.table ...
for postgresql database.table means schema.table !
DB_Dataobject should not mention the database for postgresql.