René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"1.26.0 crashes on subquery without alias","articleBody":"### Version\r\n\r\n1.26.0\r\n\r\n### What happened?\r\n\r\n1.26.0 crashes while\r\n1.25.0 reports `query.sql:5:5: subquery in FROM must have an alias`\r\n\r\n### Relevant log output\r\n\r\n```shell\r\npanic: runtime error: invalid memory address or nil pointer dereference\r\n[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0x10d0027]\r\n\r\ngoroutine 13 [running]:\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).sourceTables(0xc00035f208, 0xc000736f60, {0x1d84e80?, 0xc0006e7b80?})\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/output_columns.go:601 +0xaa7\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).outputColumns(0xc00035f208, 0xc000736f60, {0x1d84e80, 0xc0006e7b80})\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/output_columns.go:55 +0x45\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler)._analyzeQuery(0xc00035f208, 0xc000052be0, {0xc0006e8be3, 0x3f}, 0x1)\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/analyze.go:180 +0xced\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).analyzeQuery(...)\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/analyze.go:110\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).parseQuery(0xc00035f208, {0x1d85040, 0xc000052be0}, {0xc0006e8800, 0x73e}, {{0x0, 0x0, {0x0, 0x0}, 0x0, ...}})\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/parse.go:103 +0x5d5\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).parseQueries(0xc00035f208, {{0x0, 0x0, {0x0, 0x0}, 0x0, 0x0, 0x0, 0x0}})\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/compile.go:81 +0x467\r\ngithub.com/sqlc-dev/sqlc/internal/compiler.(*Compiler).ParseQueries(...)\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/compiler/engine.go:76\r\ngithub.com/sqlc-dev/sqlc/internal/cmd.parse({_, _}, {_, _}, {_, _}, {{0x0, 0x0}, {0xc000322eb6, 0xa}, ...}, ...)\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/cmd/generate.go:322 +0x30b\r\ngithub.com/sqlc-dev/sqlc/internal/cmd.processQuerySets.func1()\r\n        /home/mishak/go/pkg/mod/github.com/sqlc-dev/sqlc@v1.26.0/internal/cmd/process.go:107 +0x877\r\ngolang.org/x/sync/errgroup.(*Group).Go.func1()\r\n        /home/mishak/go/pkg/mod/golang.org/x/sync@v0.6.0/errgroup/errgroup.go:78 +0x56\r\ncreated by golang.org/x/sync/errgroup.(*Group).Go in goroutine 1\r\n        /home/mishak/go/pkg/mod/golang.org/x/sync@v0.6.0/errgroup/errgroup.go:75 +0x96\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\n-- irrelevant\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: NoAlias :one\r\nSELECT\r\n    x\r\nFROM (\r\n    SELECT 1 AS x\r\n);\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/430a752a2c2c961711ea0f5dc5640e191285d42704d65463a6a0bd8c5e3f8992\r\n\r\n### What operating system are you using?\r\n\r\nLinux\r\n\r\n### What database engines are you using?\r\n\r\nPostgreSQL\r\n\r\n### What type of code are you generating?\r\n\r\nGo","author":{"url":"https://github.com/mishak87","@type":"Person","name":"mishak87"},"datePublished":"2024-04-15T15:58:52.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/3337/sqlc/issues/3337"}