SQLite Forum

Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization
A problem with using the SQLITE_DETERMINISTIC flag on REGEXP and thus permitting
its use in the schema, for example in the WHERE clause of a partial index, is
that different installations might easily use different definitions of REGEXP.
The commonly used ICU extension defines a slightly different REGEXP operator,
for example.  And I think versions of REGEXP based on Perl regular expressions
are in wide circulation.  If you create an index using the built-in REGEXP and
then some other application tries to use it using a different definition of
REGEXP, then the index might not work right.