[MDL-42957] Harcoded LIMIT clause in recent statistics report - Moodle Tracker

XML

Word

Printable

Details

Type: Bug
Status: Closed
Priority: Critical
Resolution: Fixed
Affects Version/s: 2.6
Fix Version/s: 2.6.1
Component/s: Quiz
Labels:
- triaged

Affected Branches:
MOODLE_26_STABLE
Fixed Branches:
MOODLE_26_STABLE
Pull from Repository:
https://github.com/jamiepratt/moodle.git
Pull Master Branch:
~~MDL-42957~~-master
Pull Master Diff URL:
https://github.com/jamiepratt/moodle/compare/6ebfe7e...MDL-42957-master
Testing Instructions:

Hide

This needs to be tested in all 4 supported databases.

1. For a quiz with real student attempts, try to view the statistics report. Ensure there are no errors.

Show
This needs to be tested in all 4 supported databases. 1. For a quiz with real student attempts, try to view the statistics report. Ensure there are no errors.

Description

Looking for another failure it was detected that the statistics quiz report is using some harcoded "LIMIT" clauses (questions/calculator.php, esponses/analyser.php at least). That leads to crash under mssql/sqlsrv/oracle.

Please, confirm, fix and add some way to have it covered.

Ciao

Attachments

Issue Links

Discovered while testing

MDL-43079 notice in statistics graph causes graph not to load when all students have same zero grade for all questions

Closed

Activity

People

Assignee:: Jamie Pratt

Reporter:: Eloy Lafuente (stronk7)

Peer reviewer:: Tim Hunt

Integrator:: Dan Poltawski

Tester:: Frédéric Massart

Participants:: Dan Poltawski, Eloy Lafuente (stronk7), Frédéric Massart, Jamie Pratt, Tim Hunt

Component watchers:: Tim Hunt, Ilya Tregubov, Kevin Percy, Mathew May, Mihail Geshoski, Shamim Rezaie

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 19/Nov/13 7:52 AM

Updated:: 29/Nov/13 2:34 PM

Resolved:: 29/Nov/13 2:34 PM

Fix Release Date:: 13/Jan/14