Skip to content
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

escape: Velox throws while Presto outputs #12558

Open
peterenescu opened this issue Mar 5, 2025 · 1 comment
Open

escape: Velox throws while Presto outputs #12558

peterenescu opened this issue Mar 5, 2025 · 1 comment
Assignees
Labels
bug Something isn't working fuzzer-found

Comments

@peterenescu
Copy link
Contributor

peterenescu commented Mar 5, 2025

Description

Presto and Velox behave different for escape.

Error Reproduction

Velox

presto:di> SELECT c0 like c1 escape c2 from (values (varchar 'N#w&{~>|.v^''%Ed{H^v6/\k::<,pf5-p?@g;1MsE$!Y0&9[hks,eHvrTv>H', varchar 'oEP}kS-lLtMzK_9-|Q&p0zA17[]6-"ZeKB&d(3B!I0Wp7Xu%\0xg&dH', varchar '') ) t(c0, c1, c2);
Query 20250305_225027_43941_nqej6 failed: escapeChar.size() == 1 (0 vs. 1) Escape string must be a single character Top-level Expression: presto.default.like(field, field_0, field_1)

Presto

presto> SELECT c0 like c1 escape c2 from (values (varchar 'N#w&{~>|.v^''%Ed{H^v6/\k::<,pf5-p?@g;1MsE$!Y0&9[hks,eHvrTv>H', varchar 'oEP}kS-lLtMzK_9-|Q&p0zA17[]6-"ZeKB&d(3B!I0Wp7Xu%\0xg&dH', varchar '') ) t(c0, c1, c2);
 _col0 
-------
 false 
@peterenescu peterenescu added bug Something isn't working fuzzer-found labels Mar 5, 2025
@peterenescu
Copy link
Contributor Author

@peterenescu peterenescu self-assigned this Mar 10, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working fuzzer-found
Projects
None yet
Development

No branches or pull requests

1 participant