René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Unknown node type *ast.SetOprStmt","articleBody":"### Version\n\n1.17.2\n\n### What happened?\n\nsqlc fails to generate on MySQL when there is a UNION inside a subquery that we're selecting from.\r\n\n\n### Relevant log output\n\n```shell\nsqlc generate failed.\r\n2023/05/04 09:31:21 dolphin.convert: Unknown node type *ast.SetOprStmt\r\n2023/05/04 09:31:21 dolphin.convert: Unknown node type *ast.SetOprStmt\r\n# package db\r\nquery.sql:9:1: edited query syntax is invalid: syntax error near \"FROM (\"\n```\n\n\n### Database schema\n\n_No response_\n\n### SQL queries\n\n```sql\n-- name: TestSubqueryUnion :many\r\nSELECT tmp.* FROM (\r\n  SELECT * FROM authors\r\n  UNION\r\n  SELECT * FROM authors\r\n) tmp LIMIT 5;\n```\n\n\n### Configuration\n\n_No response_\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/4963c8a8ba696143e0a564fa4c164c51c54d9460b5494c32ddc2c0269a20f866\n\n### What operating system are you using?\n\n_No response_\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/dansimau","@type":"Person","name":"dansimau"},"datePublished":"2023-05-04T09:35:57.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2260/sqlc/issues/2260"}