834853 - Fix duplicated "tscroll" name for tests on graphs.mozilla.org and graphs.allizom.org

Status: RESOLVED FIXED

(Data & BI Services Team :: DB: MySQL, task)

Description

[andershol]

Bug 823716 fixed a duplicated test name and some inconsistencies. These should also be fixed in the database. This is the sql for this:

update tests
  set pretty_name='tscroll MozAfterPaint'
  where name='tscroll_paint';
update tests
  set pretty_name='tscroll 2 MozAfterPaint'
  where name='tscroll.2_paint';
update tests
  set pretty_name='tscroll Row Major MozAfterPaint'
  where name='tscrollr_paint';

This will return the two duplicated rows before the change and none after:
select * from tests
where pretty_name in (select pretty_name
  from tests t2
  group by pretty_name
  having count(*)>1);

Comment 1

[Sheeri Cabral [:sheeri]]

Executed on stage, and indeed, after the changes:

mysql> select * from tests
    -> where pretty_name in (select pretty_name
    ->   from tests t2
    ->   group by pretty_name
    ->   having count(*)>1);
Empty set (0.73 sec)

Comment 2

[Sheeri Cabral [:sheeri]]

And on production, the full complement of queries:


mysql> select * from tests
    -> where pretty_name in (select pretty_name
    ->   from tests t2
    ->   group by pretty_name
    ->   having count(*)>1);
+-----+---------------+-------------+-----------+-----------+------------+
| id  | name          | pretty_name | is_chrome | is_active | pageset_id |
+-----+---------------+-------------+-----------+-----------+------------+
|  71 | tscroll       | tscroll     |         1 |         1 |         11 |
| 112 | tscroll_paint | tscroll     |         1 |         1 |         11 |
+-----+---------------+-------------+-----------+-----------+------------+
2 rows in set (0.49 sec)

mysql> update tests
    ->   set pretty_name='tscroll MozAfterPaint'
    ->   where name='tscroll_paint';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update tests
    ->   set pretty_name='tscroll 2 MozAfterPaint'
    ->   where name='tscroll.2_paint';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> update tests
    ->   set pretty_name='tscroll Row Major MozAfterPaint'
    ->   where name='tscrollr_paint';
Query OK, 1 row affected (0.00 sec)
Rows matched: 1  Changed: 1  Warnings: 0

mysql> select * from tests
    -> where pretty_name in (select pretty_name
    ->   from tests t2
    ->   group by pretty_name
    ->   having count(*)>1);
Empty set (0.50 sec)

Resolving.