Skip to content

Posgresql security label not parsed #6694

@rpradal

Description

@rpradal

Search before asking

  • I searched the issues and found no similar issues.

What Happened

Hello,

I use the security label postgresql feature and it looks like this statement is not parsed by sqlfluff.

Expected Behaviour

sqlfluff is able to parse my sql file

Observed Behaviour

I get the following error

L:   6 | P:   1 |  PRS | Line 6, Position 1: Found unparsable section: 'SECURITY
                       | LABEL FOR anon ON COLUMN custom...'

How to reproduce

My sql file contains the following statement:

SECURITY LABEL FOR anon ON COLUMN customer.first_name
IS 'MASKED WITH FUNCTION anon.dummy_first_name()';

Dialect

postgresql

Version

3.3.1

Configuration

[tool.sqlfluff.core]
dialect = "postgres"
max_line_length = 120

Are you willing to work on and submit a PR to address the issue?

  • Yes I am willing to submit a PR!

Code of Conduct

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingpostgresIssues relating to the Postgres dialect

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions