MDL-35453 quiz reports: don't order by id.
authorTim Hunt <T.J.Hunt@open.ac.uk>
Wed, 12 Feb 2014 17:26:30 +0000 (17:26 +0000)
committerTim Hunt <T.J.Hunt@open.ac.uk>
Fri, 20 Jun 2014 15:09:03 +0000 (16:09 +0100)
commit2ce9a94d962405a1fb2f3f375068d3ad031d966e
treec57977f77ce20cf235dd603319fcc3413e1e4602
parent7784c3ad18371607780f2845d44db291112b816e
MDL-35453 quiz reports: don't order by id.

We were using ORDER BY id even though there was a perfectly good
attempt column to order the attempts by one user at one quiz.

Also, Oracle was complaining:
Debug info: ORA-01799: a column may not be outer-joined to a subquery
mod/quiz/report/overview/report.php
mod/quiz/report/reportlib.php
mod/quiz/tests/reportlib_test.php