Skip to main content

Public

Project privacy set to public. By default, its content is available to everyone (authenticated or not). Please note that more restrictive permissions might exist on some items.

    •  
      request #10127 Missing index related to artifact links type
    Actions
    Infos
    #10127
    Manuel Vacelet (vaceletm)
    2017-04-06 16:45
    2017-04-05 18:00
    10407
    Details
    Missing index related to artifact links type

    The code is issuing a lot of queries like:

    SELECT DISTINCT nature
FROM tracker_changeset_value_artifactlink
WHERE group_id = N
ORDER BY nature ASC;

    or

    UPDATE tracker_changeset_value_artifactlink SET keyword='S' WHERE keyword='S' AND group_id='S'

    We need an index to cover that

    Trackers
    9.5
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2017-04-06
    Attachments
    Artifact links

    Releases

    Fixed in

    Artifact ID Project Tracker Summary Status Last Update Date Submitted By Assigned to
    rel #10042 Tuleap Releases 9.7 Delivered 2017-04-27 15:37 Manuel Vacelet (vaceletm)
    Empty
    References
    Referencing request #10127

    Git commit

    tuleap/tuleap/stable

    Merge commit 'refs/changes/02/8102/2' of ssh://gerrit.tuleap.net:29418/tuleap into HEAD 8cf4c3355a
    User avatar Marie Ange Garnier (marieange) , 2017-04-06 16:08
    request #10127 Missing index related to artifact links type 5d5d6e1ba1
    User avatar Manuel Vacelet (vaceletm) , 2017-04-06 15:12
    Referenced by request #10127

    Artifact Tracker v5

    rel #10042 9.7

    Other

    gerrit #8102
    Display settings

    Follow-ups