-
Bug
-
Resolution: Fixed
-
Blocker
-
2.0
-
None
-
MOODLE_20_STABLE
-
MOODLE_20_STABLE
-
Easy
Current regexp present in mssql/sqlsrv drivers, used to apply for the TOP keyword when using limits in the query fails to match properly if there are multiple spaces (it matches only one space).
Going to change it as fas as I got at least one case (in mod/data/view.php), leading to garbled SQL:
SELECT TOP 10 DISTINCT ==> wrong
and it should be:
SELECT DISTINCT TOP 10 ==> correct
Will add test for it too. Ciao
- will help resolve
-
MDL-25411 Error reading from database Debug: Incorrect syntax near the keyword 'FROM'. SELECT TOP 11 FROM mdl_role_assignments
-
- Closed
-