nag763 / doteur Goto Github PK

Describe the bug
A clear and concise description of what the bug is.
doteur can successfully compile the following command:

``` test.sql
CREATE TABLE my_table_name ( ... );
```

but the following will throw an error:

``` test.sql
CREATE TABLE "my_table_name" ( ... );
```

doteur, however, does NOT panic if column-names are wrapped in double-quotations.
i.e., doteur will successfully compile the following (even though the column-name is wrapped in double-quotations):

``` test.sql
CREATE TABLE my_table_name (
    "my_column" INT
);
```

It seems that the panic only happens when the TABLE-NAME is wrapped in double-quotes...

To Reproduce
Steps to reproduce the behavior:

1. create a test.sql file
2. write:
   CREATE TABLE "my_table_name" ( "id" INT );
3. the above will fail, but if you change it to:
   CREATE TABLE my_table_name ( "id" INT );
   if will compile and produce an output

Expected behavior
doteur should not panic if a table-name is wrapped with double-quotations.

Desktop (please complete the following information):

• OS: macOS

Description

Alter table ADD COLUMN not understood correctly, tries to be parsed as a relation

ie

ALTER TABLE CHATTER
ADD COLUMN tz_name VARCHAR NOT NULL DEFAULT 'Europe/London',
ADD COLUMN tz_offset BIGINT NOT NULL DEFAULT 0;