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

Slow query parsing #183

Closed
felipebz opened this issue Jun 19, 2024 · 1 comment
Closed

Slow query parsing #183

felipebz opened this issue Jun 19, 2024 · 1 comment
Milestone

Comments

@felipebz
Copy link
Owner

While using the test files from antlr/grammars-v4, I've noticed a delay in this particular query: https://github.com/felipebz/grammars-v4/blob/086ca965a5fcff502e338879e50a0013b072683d/sql/plsql/long-running/cast_multiset07.sql

On my computer, it takes approximately 35 seconds to parse. This issue is also replicable with the following shorter version:

select *
  from tab
 where col = any(((
         select * from the (select * from dual)
       )))
@felipebz felipebz added this to the 3.5.0 milestone Jun 19, 2024
@felipebz
Copy link
Owner Author

The same query now takes 7ms on my PC.

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