Closed
Description
Version
1.27.0
What happened?
Parsing DB migration file with setting the default value of a column to ('') causes a syntax error.
It works without enclosing the single-quotes in parentheses, but this value does not work with the goose migration tool
Relevant log output
sqlc generate failed.
# package
schema.sql:7:69: syntax error near "'');" "
Database schema
CREATE TABLE authors (
id INT PRIMARY KEY,
name text NOT NULL,
bio text NOT NULL
);
SQL queries
ALTER TABLE authors ADD COLUMN explanation text NOT NULL DEFAULT ('');
Configuration
{
"version": "2",
"sql": [{
"schema": "schema.sql",
"queries": "query.sql",
"engine": "mysql",
"gen": {
"go": {
"out": "db"
}
}
}]
}
Playground URL
https://play.sqlc.dev/p/3532b091fbc236e2c56c2eeb6a06ecc34ba3eb8deb833725b4b84f917c289bf5
What operating system are you using?
macOS
What database engines are you using?
MySQL
What type of code are you generating?
Go