I have a Text field (user1) in which two records have an entry. One has a colon in the text and one does not. If I search for the one with a colon with REGEX it works:
select * from thereferences where user1 Regex '[:]' -> 1 hit
But when I search for one *without* the colon using the ^ negate operator, I get 2 hits instead of one. Both records match.
select hit from thereferences where user1 Regex '[^:]' -> 2 hits
I've confirmed this in Studio. Is this not the right REGEX syntax? I'm not looking for a workaround, I need the REGEX negate search to work.
In the expectation that the negate search should work, I've attached a database you can use to test this.