mahara-contributors team mailing list archive

[Matt Oquist <moquist@xxxxxxxxx>]

Public bug reported:

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.

** Affects: mahara
     Importance: Undecided
         Status: New

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