Public bug reported:
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
** Affects: mahara
Importance: High
Assignee: Robert Lyon (robertl-9)
Status: In Progress
** Changed in: mahara
Status: New => In Progress
** Changed in: mahara
Importance: Undecided => High
** Changed in: mahara
Assignee: (unassigned) => Robert Lyon (robertl-9)
** Changed in: mahara
Milestone: None => 18.10.0
--
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:
In Progress
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
