Repository navigation
Itemized columns in function not working #2386
Description
Version
1.18.0
What happened?
When not using * (A_Star) and itemizing columns, functions fail to generate.
Relevant log output
sqlc generate failed.
# package db
query.sql:15:8: column "id" does not existDatabase schema
create table blog (
id serial primary key,
name text not null
);
create function test_select_blog(in p_id int)
returns table (id int, name text) AS $$
BEGIN RETURN QUERY
select id, name from blog where id = p_id;
END;
$$ language plpgsql;SQL queries
-- name: TestFuncSelectBlog :many
select id, name from test_select_blog($1);Configuration
No response
Playground URL
What operating system are you using?
Linux
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Reacted by Saquib Mian
Activity
saquibmian commentedon Oct 3, 2023
Is there any workaround for this? The best I can think of is to create a fake table that matches the composite table declaration and use
setof <table name>instead, but this is far from ideal.test: Add case for #2386
test: Add more test cases for new analyzer (#2879)
kyleconroy commentedon Oct 24, 2023
This is fixed in v1.23.0 by enabling the database-backed query analyzer. We added a test case for this issue so it won’t break in the future.
You can play around with the working example on the playground
test: Add more test cases for new analyzer (sqlc-dev#2879)