MDL-30545 messaging - remove DISTINCT from union statement
authorDan Poltawski <dan@moodle.com>
Tue, 13 Nov 2012 14:34:36 +0000 (22:34 +0800)
committerDan Poltawski <dan@moodle.com>
Tue, 13 Nov 2012 14:34:36 +0000 (22:34 +0800)
lib/messagelib.php

index 38d371a..3ab00ea 100644 (file)
@@ -487,7 +487,7 @@ function message_get_providers_for_user($userid) {
         $params['frontpagepathpattern'] = $frontpagecontext->path . '/';
 
         $sql .= "
-             UNION DISTINCT
+             UNION
 
             SELECT DISTINCT rc.capability, 1