René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc panics on union all with subqueries using mysql","articleBody":"### Version\n\nOther\n\n### What happened?\n\nFrom https://github.com/kyleconroy/sqlc/issues/2416#issuecomment-1633767537, sqlc panics on the below query going back to at least version v1.14.0.\n\n### Relevant log output\n\n```shell\npanic: interface conversion: ast.Node is *ast.SetOprSelectList, not *ast.SelectStmt\r\n\r\ngoroutine 6 [running]:\r\ngithub.com/kyleconroy/sqlc/internal/engine/dolphin.(*cc).convertSetOprSelectList(0xc000a7ebc0?, 0xc0001e4930)\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/engine/dolphin/convert.go:1212 +0x505\r\ngithub.com/kyleconroy/sqlc/internal/engine/dolphin.(*cc).convertSetOprStmt(0x20?, 0xc000100000?)\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/engine/dolphin/convert.go:1255 +0x7b\r\ngithub.com/kyleconroy/sqlc/internal/engine/dolphin.(*cc).convert(0xc000810000?, {0x2804eb0?, 0xc0001e48c0?})\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/engine/dolphin/convert.go:1735 +0x20f6\r\ngithub.com/kyleconroy/sqlc/internal/engine/dolphin.(*Parser).Parse(0xc000015130, {0x27f0380?, 0xc000a4e0a0?})\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/engine/dolphin/parse.go:63 +0x205\r\ngithub.com/kyleconroy/sqlc/internal/compiler.(*Compiler).parseQueries(0xc00021dc00, {{0x40?, 0xf1?, {0x0?, 0x1?}, 0x1?}})\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/compiler/compile.go:74 +0x26d\r\ngithub.com/kyleconroy/sqlc/internal/compiler.(*Compiler).ParseQueries(...)\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/compiler/engine.go:49\r\ngithub.com/kyleconroy/sqlc/internal/cmd.parse({_, _}, {_, _}, {_, _}, {{0xc0004520f6, 0x5}, {0xc00043f140, 0x1, ...}, ...}, ...)\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/cmd/generate.go:350 +0x285\r\ngithub.com/kyleconroy/sqlc/internal/cmd.Generate.func1()\r\n        /go/pkg/mod/github.com/kyleconroy/sqlc@v1.19.0/internal/cmd/generate.go:224 +0x827\r\ngolang.org/x/sync/errgroup.(*Group).Go.func1()\r\n        /go/pkg/mod/golang.org/x/sync@v0.3.0/errgroup/errgroup.go:75 +0x64\r\ncreated by golang.org/x/sync/errgroup.(*Group).Go\r\n        /go/pkg/mod/golang.org/x/sync@v0.3.0/errgroup/errgroup.go:72 +0xa5\n```\n\n\n### Database schema\n\n```sql\nCREATE TABLE authors (\r\n  id   INTEGER PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\n```\n\n\n### SQL queries\n\n```sql\n(select id\r\nfrom authors\r\nwhere id \u003c ? or id = (select min(id) from authors)\r\norder by id desc\r\nlimit 1)\r\nunion all\r\n(select id\r\nfrom authors\r\nwhere id \u003e ? or id = (select max(id) from authors)\r\norder by id asc\r\nlimit 1);\n```\n\n\n### Configuration\n\n```yaml\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"mysql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\n```\n\n\n### Playground URL\n\nhttps://play.sqlc.dev/p/77d407f03779300c3bdefb4b7efda45ce2f65e5ee98c2257f0dd01c06cb52b91\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\n_No response_","author":{"url":"https://github.com/andrewmbenton","@type":"Person","name":"andrewmbenton"},"datePublished":"2023-07-13T17:18:49.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/2453/sqlc/issues/2453"}