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

sqlfluff Performance Issue on Nested Query Pattern #348

Closed
reata opened this issue Mar 26, 2023 · 1 comment · Fixed by #414
Closed

sqlfluff Performance Issue on Nested Query Pattern #348

reata opened this issue Mar 26, 2023 · 1 comment · Fixed by #414
Labels
enhancement New feature or request

Comments

@reata
Copy link
Owner

reata commented Mar 26, 2023

We see sqlfluff is slow in parsing certain query with nested pattern. Check test case:

  • test_nested_cast_to_data_type
  • test_cast_to_data_type_with_case_when
  • test_column_try_cast_with_func

Let's see if we can submit a PR (or issue at minimum) to sqlfluff community.

@reata reata added the enhancement New feature or request label Mar 26, 2023
@reata
Copy link
Owner Author

reata commented Jul 26, 2023

sqlfluff v2.1.4 brings some meaningful performance improvements and these test cases are running much faster than previous. See https://github.com/sqlfluff/sqlfluff/releases/tag/2.1.4

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

Successfully merging a pull request may close this issue.

1 participant