mahara-contributors team mailing list archive

[Cecilia Vela Gurovic <1769512@xxxxxxxxxxxxxxxxxx>]

** Changed in: mahara
       Status: Fix Committed => Fix Released

-- 
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 Released
Status in Mahara 17.10 series:
  Fix Released
Status in Mahara 18.04 series:
  Fix Released

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