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

RESOLVED FIXED

Status

Data & BI Services Team
DB: MySQL
RESOLVED FIXED
5 years ago
3 years ago

People

(Reporter: andershol, Unassigned)

Tracking

Details

(Reporter)

Description

5 years ago
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);
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)
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.
Status: UNCONFIRMED → RESOLVED
Last Resolved: 5 years ago
Resolution: --- → FIXED
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.