Terr/linkable — Issue #5: incorrect queries with cakePHP1.3.12 and 1.3.13
Author: spooknick
Created: 2011-10-18 09:38:44+00:00
State: open

Joined tables have incorrect table names, it might have to do with table prefixes. In my application, the tables have a prefix set in database.php to 'phd_'

Here below a query in a test case. Joined table name should be `test_phd_applicant_degrees`

FROM `test_phd_applicant_educations` AS `ApplicantEducation`
LEFT JOIN `test_phd_`test_phd_applicant_degrees`` AS `ApplicantDegree`

Here's a query in my application. Joined table name should be `phd_applicant_degrees`

FROM `phd_applicant_educations` AS `ApplicantEducation`
LEFT JOIN `phd_`phd_applicant_degrees`` AS `ApplicantDegree`