Escape SQL-LIKE metacharacters (a keyId can contain _, a LIKE wildcard) so a path prefix matches LITERALLY — pair with ESCAPE '\' in the query. Without this, a sibling whose id shares a _-adjacent prefix could leak into a subtree match.
_
ESCAPE '\'
Escape SQL-LIKE metacharacters (a keyId can contain
_, a LIKE wildcard) so a path prefix matches LITERALLY — pair withESCAPE '\'in the query. Without this, a sibling whose id shares a_-adjacent prefix could leak into a subtree match.