Itemized columns in function not working

[jwc-clinnection]

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 exist

Database 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

https://play.sqlc.dev/p/122897d98d937d01051777c6ab253ccb16e5c20d513c03c4e1049bf36349f4f5

What operating system are you using?

Linux

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[saquibmian]

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.

[kyleconroy]

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