René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Add text column with default empty string value causes syntax error","articleBody":"### Version\n\n1.27.0\n\n### What happened?\n\nParsing DB migration file with setting the default value of a column to ('') causes a syntax error.\n\nIt works without enclosing the single-quotes in parentheses, but this value does not work with the goose migration tool\n\n### Relevant log output\n\n```shell\nsqlc generate failed.\n# package \nschema.sql:7:69: syntax error near \"'');\" \"\n```\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\n  id   INT PRIMARY KEY,\n  name text      NOT NULL,\n  bio  text NOT NULL\n);\n```\n\n### SQL queries\n\n```sql\nALTER TABLE authors ADD COLUMN explanation text NOT NULL DEFAULT ('');\n```\n\n### Configuration\n\n```yaml\n{\n  \"version\": \"2\",\n  \"sql\": [{\n    \"schema\": \"schema.sql\",\n    \"queries\": \"query.sql\",\n    \"engine\": \"mysql\",\n    \"gen\": {\n      \"go\": {\n        \"out\": \"db\"\n      }\n    }\n  }]\n}\n```\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/3532b091fbc236e2c56c2eeb6a06ecc34ba3eb8deb833725b4b84f917c289bf5\n\n### What operating system are you using?\n\nmacOS\n\n### What database engines are you using?\n\nMySQL\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/andylin-0","@type":"Person","name":"andylin-0"},"datePublished":"2025-02-24T18:38:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/3859/sqlc/issues/3859"}