Change Details

Now, API modules for recent change use tag_summary but the special page itself uses change_tag table. This means API and GUI are reading from different backend. Also with {T185355}, change_tag is getting nimble and more suitable to be used as it's get automatically pulled into the memory. It seems the reason for having it in the first place was (from tables.sql): ``` -- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT -- that only works on MySQL 4.1+ ``` #patch-for-review: - [x] [`ChangeTags::modifyDisplayQuery()`](https://gerrit.wikimedia.org/r/473611) - [x] [`ApiQueryLogEvents`](https://gerrit.wikimedia.org/r/473617) - [x] [API modules](https://gerrit.wikimedia.org/r/476058) - [ ] [`WatchedItemQueryService`](https://gerrit.wikimedia.org/r/476059) - [ ] [Special:Undelete, Diff](https://gerrit.wikimedia.org/r/476069) - [x] [AbuseFilter](https://gerrit.wikimedia.org/r/476073)

Now, API modules for recent change use tag_summary but the special page itself uses change_tag table. This means API and GUI are reading from different backend. Also with {T185355}, change_tag is getting nimble and more suitable to be used as it's get automatically pulled into the memory. It seems the reason for having it in the first place was (from tables.sql): ``` -- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT -- that only works on MySQL 4.1+ ``` #patch-for-review: - [x] [`ChangeTags::modifyDisplayQuery()`](https://gerrit.wikimedia.org/r/473611) - [x] [`ApiQueryLogEvents`](https://gerrit.wikimedia.org/r/473617) - [x] [API modules](https://gerrit.wikimedia.org/r/476058) - [x] [`WatchedItemQueryService`](https://gerrit.wikimedia.org/r/476059) - [ ] [Special:Undelete, Diff](https://gerrit.wikimedia.org/r/476069) - [x] [AbuseFilter](https://gerrit.wikimedia.org/r/476073)

Now, API modules for recent change use tag_summary but the special page itself uses change_tag table. This means API and GUI are reading from different backend. Also with {T185355}, change_tag is getting nimble and more suitable to be used as it's get automatically pulled into the memory. It seems the reason for having it in the first place was (from tables.sql): ``` -- Rollup table to pull a LIST of tags simply without ugly GROUP_CONCAT -- that only works on MySQL 4.1+ ``` #patch-for-review: - [x] [`ChangeTags::modifyDisplayQuery()`](https://gerrit.wikimedia.org/r/473611) - [x] [`ApiQueryLogEvents`](https://gerrit.wikimedia.org/r/473617) - [x] [API modules](https://gerrit.wikimedia.org/r/476058) - [ - [x] [`WatchedItemQueryService`](https://gerrit.wikimedia.org/r/476059) - [ ] [Special:Undelete, Diff](https://gerrit.wikimedia.org/r/476069) - [x] [AbuseFilter](https://gerrit.wikimedia.org/r/476073)