database

Zero Duplicates Was a Regex Dialect Bug

The duplicate query returned zero. That looked like excellent news. Then a second path found 230. The second path changed the boundary escape. The result changed from zero to 230. I had written \b as a word boundary. PostgreSQL read it as backspace. This is the part that makes the bug expensive. \b is not invalid…