René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"sqlc crashes when calling a function with OUT arg","articleBody":"### Version\r\n\r\n1.13.0\r\n\r\n### What happened?\r\n\r\nI tried to call a function which has an OUT argument.  I am seeing sqlc crash a lot when I try to do this.  I realize I might have botched the syntax or something somewhat, but the crash is making diagnosis of the problem harder.\r\n\r\n### Relevant log output\r\n\r\n```shell\r\nsqlc generate failed.\r\n\r\npanic: runtime error: invalid memory address or nil pointer dereference\r\n[signal SIGSEGV: segmentation violation code=0x1 addr=0x0 pc=0xe77599]\r\n\r\ngoroutine 1 [running]:\r\ngithub.com/kyleconroy/sqlc/internal/compiler.sourceTables(0xc00051f0a0, {0x14205a0, 0xc00037dd90})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/compiler/output_columns.go:409 +0x639\r\ngithub.com/kyleconroy/sqlc/internal/compiler.outputColumns(0xc00051f0a0, {0x14205a0, 0xc00037dd90})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/compiler/output_columns.go:54 +0x56\r\ngithub.com/kyleconroy/sqlc/internal/compiler.(*Compiler).parseQuery(0xc000424000, {0x1420340, 0xc0002159a0}, {0xc000418480, 0x21a}, {0x0, {0x0, 0x0, {0x0, 0x0}}})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/compiler/parse.go:114 +0x8bf\r\ngithub.com/kyleconroy/sqlc/internal/compiler.(*Compiler).parseQueries(0xc000424000, {0x20, {0x20, 0x45, {0x0, 0x1}}})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/compiler/compile.go:108 +0x513\r\ngithub.com/kyleconroy/sqlc/internal/compiler.(*Compiler).ParseQueries(...)\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/compiler/engine.go:49\r\ngithub.com/kyleconroy/sqlc/internal/cmd.parse({_, _}, {_, _}, {_, _}, {_, _}, {{0xc0002294a6, 0xa}, ...}, ...)\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/cmd/generate.go:262 +0x253\r\ngithub.com/kyleconroy/sqlc/internal/cmd.Generate({0x14343d0, 0xc00004e040}, {0x80, 0x46}, {0xc00004a3c0, 0x57}, {0x0, 0x101e900}, {0x14250e0, 0xc000010020})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/cmd/generate.go:183 +0x7bb\r\ngithub.com/kyleconroy/sqlc/internal/cmd.glob..func3(0x1d3bcc0, {0x116a2e3, 0x0, 0x0})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/cmd/cmd.go:144 +0x194\r\ngithub.com/spf13/cobra.(*Command).execute(0x1d3bcc0, {0x2366b60, 0x0, 0x0})\r\n\t/go/pkg/mod/github.com/spf13/cobra@v1.4.0/command.go:860 +0x5f8\r\ngithub.com/spf13/cobra.(*Command).ExecuteC(0xc0002fea00)\r\n\t/go/pkg/mod/github.com/spf13/cobra@v1.4.0/command.go:974 +0x3bc\r\ngithub.com/spf13/cobra.(*Command).Execute(...)\r\n\t/go/pkg/mod/github.com/spf13/cobra@v1.4.0/command.go:902\r\ngithub.com/spf13/cobra.(*Command).ExecuteContext(...)\r\n\t/go/pkg/mod/github.com/spf13/cobra@v1.4.0/command.go:895\r\ngithub.com/kyleconroy/sqlc/internal/cmd.Do({0xc00003c050, 0x1, 0x1}, {0x14250a0, 0xc000010010}, {0x14250e0, 0xc000010018}, {0x14250e0, 0xc000010020})\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/internal/cmd/cmd.go:47 +0x4ba\r\nmain.main()\r\n\t/go/pkg/mod/github.com/kyleconroy/sqlc@v1.13.0/cmd/sqlc/main.go:10 +0x7a\r\n```\r\n\r\n\r\n### Database schema\r\n\r\n```sql\r\n-- Example queries for sqlc\r\nCREATE TABLE authors (\r\n  id   BIGSERIAL PRIMARY KEY,\r\n  name text      NOT NULL,\r\n  bio  text\r\n);\r\n\r\nCREATE OR REPLACE FUNCTION add_author (name text, bio text, out id int)\r\nAS $$\r\nDECLARE\r\nBEGIN\r\n  id = 123;\r\nEND;\r\n$$ LANGUAGE plpgsql;\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: CreateAuthor :one\r\nSELECT * FROM add_author (\r\n  sqlc.arg(name), sqlc.arg(bio)\r\n);\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n```yaml\r\n{\r\n  \"version\": \"1\",\r\n  \"packages\": [\r\n    {\r\n      \"path\": \"db\",\r\n      \"engine\": \"postgresql\",\r\n      \"schema\": \"query.sql\",\r\n      \"queries\": \"query.sql\"\r\n    }\r\n  ]\r\n}\r\n```\r\n\r\n\r\n### Playground URL\r\n\r\nhttps://play.sqlc.dev/p/a6294fc50b0b186b26f9ff70895aefec3fc9f2e19390bcf81e91021aacde0231\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/danielbprice","@type":"Person","name":"danielbprice"},"datePublished":"2022-05-31T17:07:59.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/1654/sqlc/issues/1654"}