Technical notes on web development, DevOps, and AI integration.
1 article
A LIKE pattern over serialized JSON made an integration assertion flaky: object 1 caught object 19 through a substring collision.
TL;DR: A LIKE pattern meant to find JSON object 1 also matched objects 16 and 19, since substring matching treats them as prefixes. The flake hid because fixture ordering kept the right row first until data shifted. Fix by comparing parsed values or using JSON functions like JSON_SEARCH instead of loose string matching.