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.

Thanks,

Jon