Reviewed: https://reviews.mahara.org/8826 Committed: https://git.mahara.org/mahara/mahara/commit/94c1c750000a0a27ba0fe7747154f988dae059ea Submitter: Cecilia Vela Gurovic ([email protected]) Branch: master
commit 94c1c750000a0a27ba0fe7747154f988dae059ea 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]> -- 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 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
