Q010error

SQL parse error

SQL could not be parsed, a query is empty, or a migration's DDL could not be applied.

db/migrations/0003_notes.up.sql:1:31: error[Q010]: failed to interpret DDL: parsing column name: syntax error near ",": expected identifier

   |
 1 | CREATE TABLE notes (id BIGINT,, body TEXT);
   |                               ^

Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

Parse errors in migrations stop the catalogue from being built, so they are reported before any query is analysed.

Fix the SQL at the reported position. Check that the database's dialect is the one set in sgl.yaml.

$ sgl explain Q010

Look for ParseError in Seagull's source to see where it is reported.