Reviewed: https://reviews.mahara.org/8877 Committed: https://git.mahara.org/mahara/mahara/commit/2bc9d3aabfc79e8df289231362e043dfe6bbaf36 Submitter: Cecilia Vela Gurovic ([email protected]) Branch: 17.10_STABLE
commit 2bc9d3aabfc79e8df289231362e043dfe6bbaf36 Author: Robert Lyon <[email protected]> Date: Mon May 7 09:43:58 2018 +1200 Bug 1769512: Need to nest the query better for mysql to handle Otherwise the query just hangs behatnotneeded Change-Id: If3d022f87f83e14a512527a47cca2093b2ba74aa Signed-off-by: Robert Lyon <[email protected]> (cherry picked from commit 94c1c750000a0a27ba0fe7747154f988dae059ea) -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1769512 Title: find_by_email_address() and MySql problem Status in Mahara: Fix Committed Status in Mahara 17.10 series: Fix Committed Status in Mahara 18.04 series: Fix Committed Bug description: The SQL for finding a user by email address fails to execute in a timely manner in mysql. This is due to grouping on subquery when trying to return ID's for IN() clause. We need to nest another query between so the IN() clause gets a known list if IDs with out any group by clause To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1769512/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp
