-
Notifications
You must be signed in to change notification settings - Fork 591
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Support '_' as escape char in LIKE #16093
Comments
This issue has been open for 60 days with no activity. Could you please update the status? Feel free to continue discussion or close as not planned. |
@TennyZhuang new here. can i pick this? |
Sure, thanks! |
@TennyZhuang I got some weird behavior on this featrue deplyment #17377. Such as SELECT '____' LIKE '_____' ESCAPE '_' as "true" In PostgreSQL 16.3 will return
But , in otherwise this query should be return In other test case should return postgres=# SELECT '____r' LIKE '_____r' ESCAPE '_' as "true";
true
------
f
(1 row) I throught this feature need more cornercase to verify. |
Currently, we banned
_
as escape char in LIKE expression, since the output is not as expected.The failed regress tests (commented):
The text was updated successfully, but these errors were encountered: