mahara-contributors team mailing list archive

[Mahara Bot <1769512@xxxxxxxxxxxxxxxxxx>]

Reviewed:  https://reviews.mahara.org/8826
Committed: https://git.mahara.org/mahara/mahara/commit/94c1c750000a0a27ba0fe7747154f988dae059ea
Submitter: Cecilia Vela Gurovic (ceciliavg@xxxxxxxxxxxxxxx)
Branch:    master

commit 94c1c750000a0a27ba0fe7747154f988dae059ea
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>

-- 
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

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