Import SQL doesn't support comments

[alexkreidler]

I have a .sql file with a table like this:

CREATE TABLE surveys (
  id int,
  title text,
  "description" text,
  created_at timestamp,
  updated_at timestamp,
  owner_id uuid,
  is_demo boolean default false,
  is_public boolean default false
  -- last_edited_by uuid,
);

When I import it into azimutt, I get this cryptic error:

Loaded simple.sql file.
Found 12 lines in the file.
Found 2 SQL statements.
Parsing error line 2:
Can't parse table: 'CREATE TABLE surveys ( id int, title text, "description" text, created_at timestamp, updated_at timestamp, owner_id uuid, is_demo boolean default false, is_public boolean default false'
Parsing error line 12:
Statement not handled: ');'
0 statements were correctly parsed, 2 were in error.

When I change it to delete the commented line, it works. It would be great to support importing files with comments!

[loicknuchel]

Hi @alexkreidler

The SQL parser should handle comments but it seems you found an edge case that cause a bad identification of statements and thus fails :(

Thanks for your code example, it will allow me to fix :D

[asfaltboy]

I have the same issue, seems comments within table definition breaks the statement