From 5de6e614d42c23bf47312ba962bc9b48493cca33 Mon Sep 17 00:00:00 2001 From: stronk7 Date: Tue, 5 Sep 2006 19:04:33 +0000 Subject: [PATCH] No need to specify DISTINCT because u.* guarantees unique ids. Also, DISTINCT clauses cannot be used with TEXT/BINARY columns on MSSQL and Oracle. --- lib/accesslib.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/accesslib.php b/lib/accesslib.php index fb533b37d3..1816143a0a 100755 --- a/lib/accesslib.php +++ b/lib/accesslib.php @@ -2003,7 +2003,7 @@ function get_overridable_roles ($context) { * @param $limitfrom - number of records to skip (offset) * @param $limitnum - number of records to fetch */ -function get_users_by_capability($context, $capability, $fields='distinct u.*', $sort='', $limitfrom='', $limitnum='') { +function get_users_by_capability($context, $capability, $fields='u.*', $sort='', $limitfrom='', $limitnum='') { global $CFG; -- 2.39.5