Comment 3 for bug 1571421
Revision history for this message
| Mahara Bot (dev-mahara) wrote A change has been merged | #3 |
© 2004
Canonical Ltd.
•
Terms of use
•
Data privacy
•
Contact Launchpad Support
•
Blog
•
Careers
•
System status
•
1b1ed1a
(Get the code!)
Reviewed: https:/
Committed: https:/
Submitter: Robert Lyon (<email address hidden>)
Branch: master
commit 65c21985055662c
Author: Tobias Zeuch <email address hidden>
Date: Mon Apr 18 00:05:28 2016 +0200
Fix illegal reference in join condition on Exists-subquery
Bug 1571421: In the exists-subquery the join-condition contains a reference to an outer table alias, which is not supported in MySql (though it seems to work in Postgres). This leads to a "site unavailable" e.g. when searching on the "shared with me" page.
The solution is to move the condition into the WHERE-part. This might actually improve performance because it allows the database engine to precalculate the join one single time and reuse it for each Exists-subquery
behatnotneeded
Change-Id: I5097154d939bf7
Signed-off-by: Tobias Zeuch <email address hidden>