find_by_email_address() and MySql problem
Bug #1769512 reported by
Robert Lyon
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Mahara |
Fix Released
|
High
|
Robert Lyon | ||
17.10 |
Fix Released
|
High
|
Unassigned | ||
18.04 |
Fix Released
|
High
|
Unassigned |
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
Changed in mahara: | |
status: | New → In Progress |
importance: | Undecided → High |
assignee: | nobody → Robert Lyon (robertl-9) |
milestone: | none → 18.10.0 |
Changed in mahara: | |
status: | In Progress → Fix Committed |
Changed in mahara: | |
status: | Fix Committed → Fix Released |
To post a comment you must log in.
Reviewed: https:/ /reviews. mahara. org/8826 /git.mahara. org/mahara/ mahara/ commit/ 94c1c750000a0a2 7ba0fe7747154f9 88dae059ea
Committed: https:/
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master
commit 94c1c750000a0a2 7ba0fe7747154f9 88dae059ea
Author: Robert Lyon <email address hidden>
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: If3d022f87f83e1 4a512527a47cca2 093b2ba74aa
Signed-off-by: Robert Lyon <email address hidden>