You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This is likely caused by join() clauses being separate from contain() clauses. The reason for this separation is that not all contain() operations generate joins. #17184 is somewhat related.
Description
What I have
What happens
In the query that CakePHP generates for that find, my manual join I defined last actually comes before the "contained" tables.
As a result,
What I expected to happen
Because I defined the
join()
aftercontain()
, I expected the contained tables to be available before the join kicks in.If I copy the SQL from DebugKit and manually edit it to where the contained tables are joined first, the query works when I run it in Workbench
CakePHP Version
4.4.14
PHP Version
8.3.1
The text was updated successfully, but these errors were encountered: