René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"RETURNING doesn't work when inserting default values.","articleBody":"### Version\n\n1.27.0\n\n### What happened?\n\nA bug happened!\n\n### Relevant log output\n\n```shell\nsql/queries/discussion.sql:1:1: extraneous input 'RETURNING' expecting {\u003cEOF\u003e, ';', ALTER_, ANALYZE_, ATTACH_, BEGIN_, COMMIT_, CREATE_, DEFAULT_, DELETE_, DETACH_, DROP_, END_, EXPLAIN_, INSERT_, PRAGMA_, REINDEX_, RELEASE_, REPLACE_, ROLLBACK_, SAVEPOINT_, SELECT_, UPDATE_, VACUUM_, VALUES_, WITH_}\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE IF NOT EXISTS discussion (\r\n  id INTEGER PRIMARY KEY,\r\n  creation_time INTEGER NOT NULL DEFAULT (unixepoch())\r\n);\n```\n\n\n### SQL queries\n\n```sql\n-- name: Discussion_Create :one\r\nINSERT INTO discussion DEFAULT VALUES RETURNING id;\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"2\",\r\n  \"sql\": [{\r\n    \"engine\": \"sqlite\",\r\n    \"schema\": \"sql/schema\",\r\n    \"queries\": \"sql/queries\",\r\n    \"gen\": {\r\n      \"go\": {\r\n        \"out\": \"go/database/sqlc\",\r\n        \"emit_pointers_for_null_types\": true\r\n      },\r\n      \"json\": {\r\n        \"out\": \"go/database\"\r\n      }\r\n    }\r\n  }]\r\n}\n```\n\n\n### Playground URL\n\n_No response_\n\n### What operating system are you using?\n\nLinux\n\n### What database engines are you using?\n\nSQLite\n\n### What type of code are you generating?\n\nGo","author":{"url":"https://github.com/2LeoCode","@type":"Person","name":"2LeoCode"},"datePublished":"2025-01-12T20:16:43.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/3781/sqlc/issues/3781"}