mahara-contributors team mailing list archive

[Mahara Bot <1769512@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/8876
Committed: https://git.mahara.org/mahara/mahara/commit/7773892d9202572a9417b12a9a4e7df4483c30fa
Submitter: Cecilia Vela Gurovic (ceciliavg@xxxxxxxxxxxxxxx)
Branch:    18.04_STABLE

commit 7773892d9202572a9417b12a9a4e7df4483c30fa
Author: Robert Lyon <robertl@xxxxxxxxxxxxxxx>
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 <robertl@xxxxxxxxxxxxxxx>
(cherry picked from commit 94c1c750000a0a27ba0fe7747154f988dae059ea)

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