0006297: sorting on custom field, bring MySQL to deadlock loop - MantisBT

ID	Project	Category	View Status	Date Submitted	Last Update

0006297	mantisbt	filters	public	2005-09-27 12:35	2006-02-04 05:54

Reporter	MTW	Assigned To	thraxisp
Priority	normal	Severity	major	Reproducibility	always
Status	closed	Resolution	fixed
Product Version	1.0.0rc1
Fixed in Version	1.0.0rc3

Summary	0006297: sorting on custom field, bring MySQL to deadlock loop
Description	I'm using many custom fields, I have added a couple of them to "View Issues" page customizing custom_function_override_get_columns_to_view function. When triyng to sort on one of them, the generated query push MySQL in a deadlock loop due to incorrect (not optimized) JOIN clause See attached code for details (search MTW)
Additional Information	I have started using mantis with version 1.0.0rc1, now I'm using rc2 Both versions have same problem and perhaps also older versions but I don't know for sure.
Tags	No tags attached.
Attached Files	filter_api.zip (20,162 bytes) filter_api_upd.zip (20,235 bytes)

MTW 2005-09-27 13:00 reporter ~0011435	:) me and rscott have posted same issue almost in the same moment.. I'have seen his post only after the submission of mine, sorry.. About this issue I think that the 1st problem is the incorrect JOIN because it has an exponential behaviour but a good further optimization would be also not to include unneeded JOINS at all

thraxisp 2005-10-02 17:43 reporter ~0011459	fixed in CVS on 1.0.0rc3 branch and HEAD core/filter_api.php -> 1.122.2.2 or 1.125