MariaDB Documentation says about REGEXP_INSTR: Returns the position of the first occurrence of the regular expression pattern in the string subject, or 0 if pattern was not found.
My task is (simplified): finding o followed by a double consonant
It returns 1 but I would have expected 4 as the position of oll
Doing the same with replace works:
It seems that the trouble starts when using brackets in REGEXP_INSTR:
Checked with latest stable version 10.2.6, default settings.