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

Continuations: LIKE operation fails with continuations #3099

Open
ohadzeliger opened this issue Feb 4, 2025 · 0 comments
Open

Continuations: LIKE operation fails with continuations #3099

ohadzeliger opened this issue Feb 4, 2025 · 0 comments

Comments

@ohadzeliger
Copy link
Contributor

Forcing continuations on a query with LIKE causes the query to fail
Steps To Reproduce:

  1. Look at like.yamsql

  2. Force continuations on the test:

    • query: select * from A WHERE A1 LIKE '%abc%'
    • unorderedResult: [
      {'abcdefghijklmnopqrstuvwxyz'},
      {'___abcdef'},
      {'%%abcdef'},
      {'*abcdef'},
      {'(abcdefghijk)'},
      {'[abcdefghijk]'},
      {'{abcdefghijk}'}]
  3. The test will fail with:
    Caused by: com.apple.foundationdb.relational.api.exceptions.ContextualSQLException: com.apple.foundationdb.record.RecordCoreException: com.apple.foundationdb.record.query.plan.cascades.SemanticException: The like operator expects an escape character of length 1.

  4. Note: This is hard to reproduce without using the force continuations feature because of the unordered result. Potentially, ignoring the verification of the results can cause the continuations to be queried and reproduce the failure.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant