mahara-contributors team mailing list archive

[Matt Oquist <moquist@xxxxxxxxx>]

** Patch added: "get_record_sql_limit.diff"
   https://bugs.launchpad.net/bugs/716533/+attachment/1841700/+files/get_record_sql_limit.diff

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

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.