The original query to initialise the new column bug.latest_patch_uploaded contained a "teensy weensy little mistake", to quote jtv.
The naively nested SELECTs let the query run for a ridiculously long time. The new version should be better. There is no need to access the tbale Bug at all in the SELECT statement -- all we need are the IDs of bugs that need to be updated.
The original query to initialise the new column bug.latest_ patch_uploaded contained a "teensy weensy little mistake", to quote jtv.
The naively nested SELECTs let the query run for a ridiculously long time. The new version should be better. There is no need to access the tbale Bug at all in the SELECT statement -- all we need are the IDs of bugs that need to be updated.