0007929: Filter does not work well - MantisBT - Signup temporarily disabled due to spam

ID	Project	Category	View Status	Date Submitted	Last Update

0007929	mantisbt	filters	public	2007-05-01 18:27	2007-08-02 02:30

Reporter	edwardgao	Assigned To	giallu
Priority	normal	Severity	major	Reproducibility	sometimes
Status	closed	Resolution	fixed
Platform	MS SQL DB @ Windows XP	OS	XP	OS Version	XP
Product Version	1.1.0a2

Summary	0007929: Filter does not work well
Description	When we go to "view Issues" page, there is a input for the "Filter". When I input a key word to search, it looks like the total number is correct, but it won't show all the issues that match the keyword. It only show a part of the issues. Something like this Viewing Issues (1 - 3 / 6) [ Print Reports ] [ CSV Export ] but I allow to show "50 record" by default.
Additional Information	To use MS SQL instead of MySQL, I changed a little bit as other issues indicated.
Tags	No tags attached.

edwardgao 2007-05-01 18:30 reporter ~0014412	I also added some more statuses like "deferred" and so on, I hope the newly added statues won't cause this "Filter" trouble.

edwardgao 2007-05-01 18:34 reporter ~0014413	12 0.0147 SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, mantis_bug_table WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id in (2, 3, 4, 5, 6, 7, 1) ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 60, 80) ) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) AND ((summary LIKE '%test%') OR (mantis_bug_text_table.description LIKE '%test%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%test%') OR (mantis_bug_text_table.additional_information LIKE '%test%') OR (mantis_bug_table.id = '0')) 13 0.0249 SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, mantis_bug_table INNER JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id INNER JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id in (2, 3, 4, 5, 6, 7, 1) ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 60, 80) ) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) AND ((summary LIKE '%test%') OR (mantis_bug_text_table.description LIKE '%test%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%test%') OR (mantis_bug_text_table.additional_information LIKE '%test%') OR (mantis_bug_table.id LIKE '%test%') OR (mantis_bugnote_text_table.note LIKE '%test%')) 14 0.1050 SELECT DISTINCT mantis_bug_table.* FROM mantis_bug_table WHERE mantis_bug_table.id in (SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, mantis_bug_table INNER JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id INNER JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id in (2, 3, 4, 5, 6, 7, 1) ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 60, 80) ) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) AND ((summary LIKE '%test%') OR (mantis_bug_text_table.description LIKE '%test%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%test%') OR (mantis_bug_text_table.additional_information LIKE '%test%') OR (mantis_bug_table.id LIKE '%test%') OR (mantis_bugnote_text_table.note LIKE '%test%'))) ORDER BY sticky DESC, last_updated DESC, date_submitted DESC 15 0.1198 SELECT DISTINCT bug_id,MAX(last_modified) as last_modified, COUNT(last_modified) as count FROM mantis_bugnote_table WHERE mantis_bugnote_table.bug_id in (SELECT DISTINCT mantis_bug_table.id AS id FROM mantis_bug_text_table, mantis_project_table, mantis_bug_table INNER JOIN mantis_bugnote_table ON mantis_bugnote_table.bug_id = mantis_bug_table.id INNER JOIN mantis_bugnote_text_table ON mantis_bugnote_text_table.id = mantis_bugnote_table.bugnote_text_id WHERE mantis_project_table.enabled = 1 AND mantis_project_table.id = mantis_bug_table.project_id AND ( mantis_bug_table.project_id in (2, 3, 4, 5, 6, 7, 1) ) AND ( mantis_bug_table.status in (10, 20, 30, 40, 50, 60, 80) ) AND (mantis_bug_text_table.id = mantis_bug_table.bug_text_id) AND ((summary LIKE '%test%') OR (mantis_bug_text_table.description LIKE '%test%') OR (mantis_bug_text_table.steps_to_reproduce LIKE '%test%') OR (mantis_bug_text_table.additional_information LIKE '%test%') OR (mantis_bug_table.id LIKE '%test%') OR (mantis_bugnote_text_table.note LIKE '%test%'))) GROUP BY bug_id

grangeway 2007-07-17 16:22 reporter ~0015085	Hello Edward, Do you know if this issue still occurs in latest CVS code? Paul