2 Oct 2005 23:41
mantisbt/core filter_api.php,1.122.2.1,1.122.2.2
Update of /cvsroot/mantisbt/mantisbt/core
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv7785/core
Modified Files:
Tag: BRANCH_1_0_0rc2
filter_api.php
Log Message:
port fixes from head for:
0006288: Patch against CVS HEAD for Saved filter problem with view_state
0006295: Old filters and view_state problems.
0006296: Filter sql includes unnecessary links to custom_field_string_table for date custom fields
0006297: sorting on custom field, bring MySQL to deadlock loop
Index: filter_api.php
===================================================================
RCS file: /cvsroot/mantisbt/mantisbt/core/filter_api.php,v
retrieving revision 1.122.2.1
retrieving revision 1.122.2.2
diff -u -d -r1.122.2.1 -r1.122.2.2
--- filter_api.php 11 Sep 2005 18:49:34 -0000 1.122.2.1
+++ filter_api.php 2 Oct 2005 21:41:25 -0000 1.122.2.2
<at> <at> -621,31 +621,36 <at> <at>
if ( !$t_any_found ) {
$t_def = custom_field_get_definition( $t_cfid );
$t_table_name = $t_custom_field_string_table . '_' . $t_cfid;
- array_push( $t_join_clauses, "LEFT JOIN $t_custom_field_string_table $t_table_name ON
$t_table_name.bug_id = $t_bug_table.id" );
+ # We need to filter each joined table or the result query will explode in dimensions
+ # Each custom field will result in a exponential growth like Number_of_Issues^Number_of_Custom_Fields
+ # and only after this process ends (if it is able to) the result query will be filtered
(Continue reading)
RSS Feed