sql-formatter-org / sql-formatter

A whitespace formatter for different query languages
https://sql-formatter-org.github.io/sql-formatter/
MIT License
2.37k stars 405 forks source link

[FORMATTING] Can't handle array type #777

Closed Mooli88 closed 1 month ago

Mooli88 commented 2 months ago

Input data

Which SQL and options did you provide as input?

CREATE TABLE public.todos (
  assigned_to UUID[] NOT NULL
);

Expected Output No change or:

assigned_to UUID [] NOT NULL

Actual Output

Error: Unable to format SQL: Error: Parse error: Unexpected "[] NOT NUL" at line 27 column 21

Usage

nene commented 2 months ago

Please read the FAQ that you can find in the README. Your problem is solved by correct configuration and by not using the outdated VSCode plugin.

On Sat, Sep 7, 2024, 02:24 Mooli @.***> wrote:

Input data

Which SQL and options did you provide as input?

CREATE TABLE public.todos ( assigned_to UUID[] NOT NULL );

Expected Output No change or:

assigned_to UUID [] NOT NULL

Actual Output

Error: Unable to format SQL: Error: Parse error: Unexpected "[] NOT NUL" at line 27 column 21

Usage

  • How are you calling / using the library? - Vscode format document / Shift + Option + F
  • What SQL language(s) does this apply to? - Postgres
  • Which SQL Formatter version are you using? - v1.6.0

— Reply to this email directly, view it on GitHub https://github.com/sql-formatter-org/sql-formatter/issues/777, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAA43OOEV6SBOPGZQAS424LZVI2SBAVCNFSM6AAAAABNZOBTKKVHI2DSMVQWIX3LMV43ASLTON2WKOZSGUYTCMZRGA4DENY . You are receiving this because you are subscribed to this thread.Message ID: @.> [ { @.": "http://schema.org", @.": "EmailMessage", "potentialAction": { @.": "ViewAction", "target": " https://github.com/sql-formatter-org/sql-formatter/issues/777", "url": " https://github.com/sql-formatter-org/sql-formatter/issues/777", "name": "View Issue" }, "description": "View this Issue on GitHub", "publisher": { @.***": "Organization", "name": "GitHub", "url": "https://github.com" } } ]