Comment 3 for bug 1571421

Revision history for this message
Mahara Bot (dev-mahara) wrote : A change has been merged

Reviewed: https://reviews.mahara.org/6352
Committed: https://git.mahara.org/mahara/mahara/commit/65c21985055662cdaa71fed5c66c273c28a356ae
Submitter: Robert Lyon (<email address hidden>)
Branch: master

commit 65c21985055662cdaa71fed5c66c273c28a356ae
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: I5097154d939bf7ddba01d5845af7e8cbb42681b8
Signed-off-by: Tobias Zeuch <email address hidden>