title: WITH ROLLUP in MySql Repeats column when filling in for NULL
body: <p>I have a Mysql (5.7+) query in which I'm trying to substitute for <code>NULL</code>, but it repeats the same columns data and I'm wondering what I'm doing wrong here. Is it just syntax?</p>
  
  <p>Query:</p>
  
  <pre><code>SELECT IFNULL(t1.ID, '') AS 'ID',
      CASE WHEN t1.ID IS NULL
          THEN 'Totals' 
      ELSE t1.description 
          END AS 'Desc', 
      COUNT(t2.another_int) AS 'Count',
      COUNT(t2.counter) AS 'Another count'
  FROM table1 t1
      LEFT OUTER JOIN table2 t2 
  ON t1.ID = t2.other_id 
      AND t2.name = 'aname' 
  GROUP BY t1.ID WITH ROLLUP;
  </code></pre>
  
  <p>I expect:</p>
  
  <pre><code>+----+-------+-------+---------------+
  | ID | Desc  | Count | Another Count |
  +------------+-------+---------------+
  |  1 | Desc1 | 1     |     2         |
  |  2 | Desc2 | 5     |     0         |
  |  2 | Desc3 | 0     |     1         |
  |    | Totals| 6     |     3         |
  +----+-------+-------+---------------+
  </code></pre>
  
  <p>I'm getting:</p>
  
  <pre><code>+----+-------+-------+---------------+
  | ID | Desc  | Count | Another Count |
  +------------+-------+---------------+
  |  1 | Desc3 | 1     |     2         |   
  |  2 | Desc3 | 5     |     0         |       
  |  2 | Desc3 | 0     |     1         |
  |    | Desc3 | 6     |     3         |
  +----+-------+-------+---------------+
  </code></pre>
  
  <p>Obviously, I'm doing something wrong here, but I'm struggling to find the correct syntax.  Also, making the <code>GROUP BY t1.ID, t1.desc</code> just puts a <code>NULL</code> on every <code>t1.description</code> row. Thank you for any help.</p>