Repository navigation
starts_with function are simplified incorrectly when the prefix contains an underscore #19076
Description
Describe the bug
starts_with(expr, 'literal') functions are simplified to expr LIKE 'literal%'
The simplification process correctly escapes percent signs (%) in the pattern, but forgets to escape underscores (_). Underscores also have a special meaning in the LIKE operator: match any single character.
To Reproduce
Easy to reproduce with this query:
SELECT starts_with('foobar', 'foo_'), starts_with('foo_bar', 'foo_')
----
# current, incorrect result:
true, true
Expected behavior
The query above should result in
false, true
In other words, simplification of the starts_with function should escape underscores in patterns
Additional context
The ends_with function is not simplified, so is not affected by this bug
Activity
willemv commentedon Dec 3, 2025
take
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (apache#19076)
fix: escape underscores when simplifying `starts_with` (#19077)
fix: escape underscores when simplifying `starts_with` (apache#19077)
fix: escape underscores when simplifying `starts_with` (apache#19077)
fix: escape underscores when simplifying `starts_with` (apache#19077) (…