Homec4science

Add a missing key to the ManiphestTransaction table

Authored by epriestley <git@epriestley.com> on Oct 23 2011, 23:09.

Description

Add a missing key to the ManiphestTransaction table

Summary:
Caught a bad (8ms) query that didn't have a good key available. Add an
appropriate key.

The query in question is:

SELECT * FROM `maniphest_transaction` WHERE taskID = 262 ORDER BY id ASC;

...which is used in the task detail view.

Test Plan: Ran EXPLAIN on this query before/after upgrading, it now uses the
newly available key.

Reviewers: jungejason, nh, tuomaspelkonen, aran

Reviewed By: aran

CC: aran

Differential Revision: 1037

Details

Committed
epriestley <git@epriestley.com>Oct 23 2011, 23:43
Pushed
aubortJan 31 2017, 17:16
Parents
rPH0669abc5f0e1: Use a proper entropy source to generate file keys
Branches
Unknown
Tags
Unknown

Event Timeline

epriestley <git@epriestley.com> committed rPH720af267a709: Add a missing key to the ManiphestTransaction table (authored by epriestley <git@epriestley.com>).Oct 23 2011, 23:43