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

Alter Database Unparsable Section #2017

Closed
mariugul opened this issue Dec 1, 2021 · 0 comments · Fixed by #2081
Closed

Alter Database Unparsable Section #2017

mariugul opened this issue Dec 1, 2021 · 0 comments · Fixed by #2081
Labels
bug Something isn't working good first issue Good for newcomers postgres Issues relating to the Postgres dialect

Comments

@mariugul
Copy link

mariugul commented Dec 1, 2021

Expected Behaviour

Using the postgres ALTER DATABASE should work.

Observed Behaviour

$ sqlfluff lint --dialect postgres alter.sql
== [alter.sql] FAIL                                                          
L:   1 | P:   1 |  PRS | Line 1, Position 1: Found unparsable section: 'ALTER
                       | DATABASE postgres SET password_enc...'
All Finished 📜 🎉!

Steps to Reproduce

alter.sql:

ALTER DATABASE postgres SET password_encryption TO 'scram-sha-256';
sqlfluff lint --dialect postgres alter.sql

Dialect

postgres

Version

sqlfluff, version 0.8.2
Python 3.8.10
pip 20.0.2

Configuration

--dialtect postgres

@mariugul mariugul added the bug Something isn't working label Dec 1, 2021
@WittierDinosaur WittierDinosaur added the postgres Issues relating to the Postgres dialect label Dec 2, 2021
@tunetheweb tunetheweb added the good first issue Good for newcomers label Dec 4, 2021
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working good first issue Good for newcomers postgres Issues relating to the Postgres dialect
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants