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: Fatal error when too many artifacts on a table

Download Browse

Given a tracker with lot of artifacts (> 65k) When I go to a report with a table There should be no fatal error > Prepared statement contains too many placeholders This is due to the fact that the table query needs all matching ids to retrieve data to be displayed. Since it is using EasyDB, there is one prepared query placeholder `?` per id. MySQL has a hard limit set to 65k which prevent us to use prepared statement in that case. https://github.com/mysql/mysql-server/blob/8.0/sql/sql_prepare.cc#L1489-L1496 As a workaround, we use `EasyDB->quote()` instead. Introduced by git #tuleap/stable/6f1743ceeaaac0d6a0c326869d9cb4d0e102c2a1 Part of story #32281: Search artifacts with/without parents via TQL Change-Id: Ifb7e2a7369f4851549ba76d2ca4a699050a3019e

+5 −5
Nicolas Terray (nterray) 2023-06-20 12:45
Nicolas Terray (nterray) 2023-06-20 12:45
0c726b15f66a0b390e00dd9dac5ca99a02e365ea
387ed1af3b3fcf346fe0277614cc2362c1a4c3d3
git #tuleap/stable/0c726b15f66a0b390e00dd9dac5ca99a02e365ea

Modified Files

Side by side diff
Inline diff
Name
M plugins/tracker/include/Tracker/Report/Tracker_Report_Renderer_Table.class.php +5 −5 Go to diff View file