285547 - Sybase has no REGEXP operator

Status: NEW

(Bugzilla :: Bugzilla-General, enhancement)

Description

[Max Kanat-Alexander]

Sybase has no regular expression search operator.

This is probably the most significant blocker to real Sybase support in upstream
Bugzilla. If we can't figure out a way around this, we will probably never
support Sybase.

<mkanat> justdave: ...How did you deal with that?
<justdave> disabled all the user-selectable regexp operators
<justdave> and changed the internal ones to use LIKE instead with some carefully
massaged patterns
<mkanat> Wow.
<justdave> (which in some cases meant LIKE "foo" AND NOT LIKE "bar")
<mkanat> Yeah, I'm not sure if we could deal with that. :-)
<mkanat> Even modern Sybase versions don't have a REGEXP operator??
<mkanat> (ARE there modern Sybase versions??)
<justdave> nope
<justdave> at least not as of 12.5.0.3
<mkanat> That's so ridiculous.
<justdave> yeah, no kidding.

Comment 1

[Ed Sabol]

I haven't done it, but some googling reveals that you can implement a regexp
function using the Java functionality in Sybase ASE 12.

Personally, I think justdave's solution is good enough for most Sybase people
who want to use Bugzilla.

For the record, regexp operators are not part of standard SQL. :-p