-
Bug
-
Resolution: Fixed
-
Critical
-
1.7
-
None
-
MSSQL
-
Microsoft SQL
-
MOODLE_17_STABLE
-
MOODLE_17_STABLE
PIVOT is reserved word for MSSQL 2005 (due to some functions using that name).
The glossary module is full of: SELECT xxx AS pivot FROM.... and all those sentences are broken!
Solution: Change all those AS PIVOT ocurrences to another thing (ideas are welcome) and change all the ocurrences of PIVOT inside the module too.
Trick: To be able to do it easily, I propose to change all the "pivot" ocurrences to "glossarypivot" or something similar. Trying it tomorrow.