supabase / etl / 24781192345

76%

push

github

fix(postgres): escape `_` in replication slot LIKE pattern (#679)

`delete_pipeline_replication_slots` built its table-sync LIKE pattern by
appending `%` to `table_sync_prefix(pipeline_id)`, which contains literal
`_` characters. In SQL LIKE, `_` is a single-char wildcard, so the
pattern over-matches any slot whose name coincidentally lines up with
the same positions (e.g. a sibling pipeline whose id shares a decimal
prefix with the target).

Escape the literal `_` in the prefix and use `LIKE ... ESCAPE '\'` so
only the trailing `%` acts as a wildcard. Extract the pattern into a
small helper with a unit test to guard against regression.

9 of 9 new or added lines in 1 file covered. (100.0%)

24395 of 31133 relevant lines covered (78.36%)

1069.26 hits per line