René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Functions returning `TABLE` types do not work","articleBody":"### Version\r\n\r\n1.11.0\r\n\r\n### What happened?\r\n\r\nWhen a function returns a `TABLE` type, you get an \"empty list\" error or something like that. I'm sorry I saw this earlier today and don't have the exact output, but the repro below should work.\r\n\r\n`sqlc generate` fails due to an error.\r\n\r\n### Relevant log output\r\n\r\n_No response_\r\n\r\n### Database schema\r\n\r\n```sql\r\nCREATE TABLE accounts (\r\n  id         INTEGER GENERATED ALWAYS AS IDENTITY PRIMAR KEY,\r\n  username   TEXT NOT NULL UNIQUE,\r\n  password   TEXT NOT NULL\r\n);\r\n\r\n-- this is a useless and horrifying function cause we don't hash\r\n-- the password, this is just to repro the bug in sqlc\r\nCREATE OR REPLACE FUNCTION register_account(\r\n    _username TEXT,\r\n    _password VARCHAR(70)\r\n)\r\nRETURNS TABLE (\r\n    account_id   INTEGER\r\n)\r\nAS $$\r\nBEGIN\r\n  INSERT INTO accounts (username, password)\r\n       VALUES (\r\n         _username,\r\n         _password\r\n       )\r\n    RETURNING id INTO account_id;\r\n\r\n  RETURN NEXT;\r\nEND;\r\n$$ LANGUAGE plpgsql;\r\n```\r\n\r\n\r\n### SQL queries\r\n\r\n```sql\r\n-- name: Foo :one\r\nSELECT * FROM register_account('a', 'b');\r\n```\r\n\r\n\r\n### Configuration\r\n\r\n_No response_\r\n\r\n### Playground URL\r\n\r\n_No response_\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/mitchellh","@type":"Person","name":"mitchellh"},"datePublished":"2021-12-01T00:58:11.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/1322/sqlc/issues/1322"}