← Back to team overview

mahara-contributors team mailing list archive

[Bug 716533] Re: get_record_sql() breaks when the SQL contains a LIMIT

 

Looks good to me. Thanks Matt!

I've run the Selenium tests and they are just as broken with and without
that patch, so that's as good as it gets :)

** Changed in: mahara
    Milestone: None => 1.4.0

** Changed in: mahara
     Assignee: (unassigned) => François Marier (fmarier)

** Changed in: mahara
   Importance: Undecided => Low

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

-- 
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.
https://bugs.launchpad.net/bugs/716533

Title:
  get_record_sql() breaks when the SQL contains a LIMIT

Status in Mahara ePortfolio:
  Fix Committed

Bug description:
  It would be nice if get_record_sql() allowed queries that use ORDER BY
  and LIMIT 1 to ensure that the desired record is returned. Currently,
  queries with LIMIT break get_record_sql().

  I tested a fresh installation of 1.4.0alpha2dev with this patch and
  everything seemed to be fine.



References