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.

stable

Clone or download

Read-only

fix: request #40097 Missing index on value_id for List bind decorator SQL table

Download Browse

How to test: SQL queries selecting a list color at a certain changeset for an artifact should be faster and use the index. For example, if you write a Cross-Tracker search expert query that SELECTs on @status or any static list field, if you echo the query [0] and parameters, and you add EXPLAIN, you should see that MySQL uses the index instead of ALL. [0] See CrossTrackerExpertQueryReportDao::searchArtifactsColumnsMatchingIds Change-Id: I97fc84ae014bfa61155e3cabcf4580de49d79fde

+37 −2
Joris MASSON (jmasson) 2024-10-23 16:55
Joris MASSON (jmasson) 2024-10-23 17:11
fe1b169b5c0b23ca698e25dd8cb183e29588631d
eece9826dc3df288e4fcb335ffb2db857f4d6716
git #tuleap/stable/fe1b169b5c0b23ca698e25dd8cb183e29588631d

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/db/install.sql +2 −2 Go to diff View file
A plugins/tracker/db/mysql/updates/2024/202410231610_add_index_on_list_bind_decorator.php +35 −0 Go to diff View file