SQLite Forum

Hidden noCase bug in ext/misc/regexp.c in pRe->zInit prefix optimization
Login
Thank you for your lightning response! With such developers, sqlite is not in danger)

A question along the way - is there any reason not to use flag `SQLITE_DETERMINISTIC` when declaring functions `regexp` and `regexpi`?

what bad (or good or nothing) things can happen if I use it?

I have found that without this flag i can't use `regexp` in the partial index (as  the [docs](https://www.sqlite.org/c3ref/c_deterministic.html#sqlitedeterministic) says).