8000 TSQL Unable to Parse JSON_OBJECT and JSON_ARRAY · Issue #6843 · sqlfluff/sqlfluff · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content
TSQL Unable to Parse JSON_OBJECT and JSON_ARRAY #6843
Closed
@nathanthorell

Description

@nathanthorell

Search before asking

  • I searched the issues and found no similar issues.

What Happened

T-sql has specific syntax for their JSON_ARRAY and JSON_OBJECT functions.

These both throw errors unable to parse.

Expected Behaviour

I expect to be able to properly parse these function calls.

Observed Behaviour

Found unparsable section: "('a', 1, NULL, 2 NULL ON NULL);

Found unparsable section: "('name':'value', 'type':1);

How to reproduce

SELECT JSON_ARRAY('a', 1, NULL, 2 NULL ON NULL);

SELECT JSON_OBJECT('name':'value', 'type':1);

Dialect

tsql

Version

3.4.0

Configuration

Default with just dialect=tsql

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 workingt-sqlIssues related to the T-SQL/TSQL/Transact SQL dialect

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0