From 5de6e614d42c23bf47312ba962bc9b48493cca33 Mon Sep 17 00:00:00 2001
From: stronk7 <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