Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 1.9.1, 2.0
-
Component/s: Database SQL/XMLDB
-
Labels:None
-
Database:Any
-
Affected Branches:MOODLE_19_STABLE, MOODLE_20_STABLE
-
Fixed Branches:MOODLE_19_STABLE, MOODLE_20_STABLE
Description
While fixing and testing MDL-13861, it seems that the statistics generations has some CEIL() SQL uses.
But MSSQL isn't using that function but CEILING() instead.
To fix this:
1) Create one sql_ceil() function.
2) Replace all uses of CEIL() with that function.
Ciao 
Issue Links
| This issue has a non-specific relationship to: | ||||
| MDL-13861 | lib/statslib SQL errors under Oracle |
|
|
|
Resolving as fixed. New sql_ceil() function added and applied. 19_STABLE and HEAD.
Ciao