1331945 - Error when searching for comment tag

Status: UNCONFIRMED

(Bugzilla :: Query/Bug List, defect)

Description

[Benoit.levesque]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; Trident/7.0; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0; .NET4.0C; .NET4.0E; rv:11.0) like Gecko

Steps to reproduce:

Can be reproduced on landfill with the latest 5.0 version

1- Open the Advanced search
2- Open the "Custom Search" at bottom
3- Fill the fields as : [Comment tag] [is not empty]
4- Search

Note : The criteria [is not empty] isn't important anything else like [contains] [x] will also trigger the error.


Actual results:

Database error, a column doesn't exist. Here's the full message from landfill :

DBD::mysql::db selectcol_arrayref failed: Unknown column 'bugs.comment_tag' in 'where clause' [for Statement "SELECT bugs.bug_id AS bug_id, bugs.priority AS priority, bugs.bug_severity AS bug_severity
  FROM bugs
LEFT JOIN bug_group_map AS security_map ON bugs.bug_id = security_map.bug_id
INNER JOIN priority AS map_priority ON bugs.priority = map_priority.value
INNER JOIN bug_severity AS map_bug_severity ON bugs.bug_severity = map_bug_severity.value
 WHERE bugs.creation_ts IS NOT NULL
   AND security_map.group_id IS NULL
   AND  bugs.resolution IN ('')  AND bugs.comment_tag IS NOT NULL AND bugs.comment_tag != ''
GROUP BY bugs.bug_id
ORDER BY map_priority.sortkey, map_priority.value, map_bug_severity.sortkey, map_bug_severity.value
LIMIT 500
"] at Bugzilla/Search.pm line 775.
	Bugzilla::Search::data(Bugzilla::Search=HASH(0xb55f108)) called at /var/www/html/bugzilla-5.0-branch/buglist.cgi line 742


Expected results:

I should have had a list of bugs containing a comment tag.