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 |
Revision history for this message
| Mahara Bot (dev-mahara) wrote A change has been merged | #1 |
| Changed in mahara: | |
| status: | In Progress → Fix Committed |
Revision history for this message
| Mahara Bot (dev-mahara) wrote A patch has been submitted for review | #2 |
Revision history for this message
| Mahara Bot (dev-mahara) wrote | #3 |
Revision history for this message
| Mahara Bot (dev-mahara) wrote A change has been merged | #4 |
Revision history for this message
| Mahara Bot (dev-mahara) wrote | #5 |
| Changed in mahara: | |
| status: | Fix Committed → Fix Released |
To post a comment you must log in.
Reviewed: https:/
Committed: https:/
Submitter: Cecilia Vela Gurovic (<email address hidden>)
Branch: master
commit 94c1c750000a0a2
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
Signed-off-by: Robert Lyon <email address hidden>