grahamc/hydra - Change APURLT2Q3OKS6VF4HUWI3MGENXAKSSUDXI7CQOEGCRTYJRGUNT6QC

Revert "Apply IndexBuildsOnJobFinishedId to unfinished builds only"

This reverts commit 1de5ce7a0e4c28acd3766fa19a9b94fd75436430.

Created by Eelco Dolstra on March 16, 2016

APURLT2Q3OKS6VF4HUWI3MGENXAKSSUDXI7CQOEGCRTYJRGUNT6QC

Dependencies

[2] K2WAI5SOA6DT7RZI2HD66Q6HKU7TTO7DQE2YDR24BWLEHYSCLAOAC
[3] D5QIOJGPKQJIYBUCSC3MFJ3TXLPNZ2XMI37GXMFRVRFWWR2VMTFAC
[4] P57OYJ4PDLDFTTWRJB4NHAIN4HHDASVRB5T5E4FAPR2DOZQLJLVAC
[5] N22GPKYTOLZLBGTGDATQDVZ4R5APZEAOIA7L32X4UXBH4XNI7MWAC
[6] C5W3WZ3YKLMDB7P6COIHDKSKSYDGAJBSIFIHFTEKRGSEJX7J7BNAC

In channels

main

upstream

Change contents

File deletion: upgrade-47.sql

BF:BFD[3.3004] → [2.281:319]

BF:BFD[2.319] → [2.121:121]

B:BD[2.121] → [2.122:280]

drop index IndexBuildsOnJobFinishedId;
create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC) where finished = 0;

Replacement in src/sql/hydra.sql at line 640 [5.1]

B:BD[4.79] → [2.0:119]

create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC) where finished = 0;

[4.79]

[6.0]

create index IndexBuildsOnJobFinishedId on builds(project, jobset, job, system, finished, id DESC);