Details
-
Type:
Bug
-
Status:
Resolved
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 1.8.2, 1.8.3, 1.8.4, 1.8.5, 1.9
-
Fix Version/s: None
-
Component/s: Patch: MrCute
-
Labels:None
-
Environment:Microsoft SQL Server, mssql_n ADODB driver
-
Database:Microsoft SQL
-
Affected Branches:MOODLE_18_STABLE, MOODLE_19_STABLE
Description
Search fails on SQL server due to the way the sql is built, and the way that the unicode N'string' is rewritten by the mssql_n module.
Error: Incorrect syntax near 'LIKEN'.
Fix: Add spaces around LIKE keywords!
Added spaces before strings to avoid problems with unicode N string replacement with mssql_n