crate
Treat `~` operator in a regex pattern in `RegexpMatchOperator`
Lucene 10 deprecated the COMPLEMENT flag, see: https://github.com/apache/lucene/pull/13732
With: https://github.com/apache/lucene/pull/13739 bwc was added and the flag was renamed from COMPLEMENT to DEPRECATED_COMPLEMENT, but the support will be dropped in future Lucene 11. Additionally, the RegExp.ALL flags no longer contain the DEPRECATED_COMPLEMENT.
With: https://github.com/crate/crate/pull/17472 we fixed this issue to make
the ~ work as before (Lucene 9), but with Lucene 11 the flag and functionality will be removed.
So, we'd probably need to forbid (first deprecate) the usage of ~ for lucene regexp, as complement will work only
for character classes and not expressions.
More info:
When the ~ wraps a whole pattern then we could treat it like in: https://github.com/crate/crate/pull/17436 but when it's inside a pattern
and applied to an sub-expression, this approach won't work.
