pgsql-ast-parser icon indicating copy to clipboard operation
pgsql-ast-parser copied to clipboard

Foreign key constraint without explicit column reference fails to parse

Open valeneiko opened this issue 3 years ago • 0 comments

Parsing:

ALTER TABLE foo ADD bar_id BIGINT NOT NULL UNIQUE REFERENCES bar;

Fails with:

Error: Syntax error at line 1 col 65:

  ALTER TABLE foo ADD bar_id BIGINT NOT NULL UNIQUE REFERENCES bar;
                                                                  ^
Unexpected semicolon token: ";". Instead, I was expecting to see one of the following:

    - A "dot" token
    - A "lparen" token


    at Parser.feed (/src/node_modules/nearley/lib/nearley.js:343:27)
    at _parse (/src/node_modules/pgsql-ast-parser/src/parser.ts:110:16)
    at doParse (/src/node_modules/pgsql-ast-parser/src/parser.ts:57:27)
    at Object.parse (/src/node_modules/pgsql-ast-parser/src/parser.ts:60:11)

valeneiko avatar Jun 29 '22 11:06 valeneiko