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:35:35 +0000 (22:35 +0800)
lib/messagelib.php

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