-
Bug
-
Resolution: Fixed
-
Minor
-
3.0
-
MOODLE_30_STABLE
-
MOODLE_30_STABLE
-
It was detected that one of the CASE statements introduced by MDL-50993 was breaking under oracle, mssql and sqlsrv (link).
CASE statements cannot be used to build partial/alternative SQL conditions, just to return a value that later (out from the statement) can be evaluated as desired. (link).
So, here there is a patch that makes unit tests to pass under all databases (link).
Updated: Mystery was solved, my fault, read comments below. Note that it's really mysterious how unit tests have been passing everywhere (nightly, runs here filling the release testing matrix...) when the query should not have passed ever. If anybody has time to investigate the mystery, great. I have not.
Ciao
- Discovered while testing
-
MDL-50993 Timed discussions are not displayed to students in a logical order
- Closed