211018 - 'repetition-operator operand invalid' from regexp" from *. query

Status: RESOLVED DUPLICATE of bug 157092

(Bugzilla :: Query/Bug List, defect)

Description

[Jim Walters]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030314
Build Identifier: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3) Gecko/20030314

Went to http://bugzilla.buzzmaven.com/ and did a regular expression search with
string *.

Text from query results was:

Please stand by ...
Content-type: text/html
Software error:

DBD::mysql::st execute failed: Got error 'repetition-operator operand invalid'
from regexp [for statement ``SELECT bugs.bug_id, bugs.bug_severity,
bugs.priority, bugs.rep_platform, map_assigned_to.login_name, bugs.bug_status,
bugs.resolution, bugs.short_desc FROM bugs, profiles AS map_assigned_to LEFT
JOIN bug_group_map  ON bug_group_map.bug_id = bugs.bug_id  WHERE
bugs.assigned_to = map_assigned_to.userid AND (bugs.bug_status IN
('NEW','ASSIGNED','REOPENED')) AND (LOWER(bugs.short_desc) REGEXP '*.') AND
((bug_group_map.group_id IS NULL)) GROUP BY bugs.bug_id ORDER BY bugs.bug_id
'']) at Bugzilla/DB.pm line 66
	Bugzilla::DB::SendSQL('SELECT bugs.bug_id, bugs.bug_severity, bugs.priority,
bugs.re...') called at /home/virtual/bugzilla.buzzmaven.com/html/buglist.cgi
line 643

For help, please send mail to the webmaster ([e-mail]), giving this
error message and the time and date of the error. 

Reproducible: Always

Steps to Reproduce:
1. enter the following URL into a browser:

http://bugzilla.buzzmaven.com/buglist.cgi?query_format=&short_desc_type=regexp&short_desc=*.&long_desc_type=substring&long_desc=&bug_file_loc_type=allwordssubstr&bug_file_loc=&bug_status=NEW&bug_status=ASSIGNED&bug_status=REOPENED&emailassigned_to1=1&emailtype1=substring&email1=&emailassigned_to2=1&emailreporter2=1&emailcc2=1&emailtype2=substring&email2=&bugidtype=include&bug_id=&votes=&changedin=&chfieldfrom=&chfieldto=Now&chfieldvalue=&cmdtype=doit&order=Bug+Number&field0-0-0=noop&type0-0-0=noop&value0-0-0=

Comment 1

[Dave Miller [:justdave]]

That error is correct.  The regexp you entered was invalid.

* means "0 or more of the preceding character" and you had nothing preceding it.
. means "any character", but you had it after the * instead of before it.

Comment 2

[Paulo Casanova]

Shouldn't we validate the regex entered by the user? I know BZ does not need to
validate configuration stuff (we assume the administrator knows what he's doing)
but we can't do that for end users, right?

Comment 3

[Dave Miller [:justdave]]

Hmmm, yes, and I think there's another bug on that somewhere (which this should
be a dupe of instead of being resolved invalid).  In any case, we should have a
more friendly error message.

Comment 4

[Frédéric Buclin]

per comment 3


*** This bug has been marked as a duplicate of 157092 ***