280495 - Replace "REGEXP" with Bugzilla::DB function call

Status: RESOLVED FIXED

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Tomas Kopal]

User-Agent:       Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.5) Gecko/20050110 Firefox/1.0 (Debian package 1.0+dfsg.1-2)
Build Identifier: 

"REGEXP" and "NOT REGEXP" are MySQL specific and should be replaced with DB
agnostic call to function in the DB compatibility layer.

Reproducible: Always

Steps to Reproduce:

Comment 1

[Tomas Kopal]

Attachment: V1

Patch replacing REGEXP and NOT REGEXP operators with functions from DB
compatibility module.

Comment 2

[Marc Schumann [:Wurblzap]]

Comment on attachment 173948 [details] [diff] [review]
V1

r=wurblzap by inspection.

Comment 3

[Max Kanat-Alexander]

Should be approved after the base dbcompat patch is approved.

Comment 4

[Myk Melez [:myk] [@mykmelez]]

I understand from Max that these changes are relatively low risk for MySQL users
and have gone through multiple levels of revision and review, but I'm concerned
about their impact, so please be around in the days after checking this in to
watch out for and respond to reports of regressions caused by the checkins.

Comment 5

[Max Kanat-Alexander]

Checking in editusers.cgi;
/cvsroot/mozilla/webtools/bugzilla/editusers.cgi,v  <--  editusers.cgi
new revision: 1.75; previous revision: 1.74
done
Checking in Bugzilla/Search.pm;
/cvsroot/mozilla/webtools/bugzilla/Bugzilla/Search.pm,v  <--  Search.pm
new revision: 1.76; previous revision: 1.75
done