Repository navigation
[PostgresSQL] Failure to use GROUP BY for column output names when using subqueries #1886
Description
Version
1.15.0
What happened?
When using a subquery, if I specify an output column name for GROUP BY, sqlc cannot compile it. if I execute SQL directly, it works fine.
I am aware that when using PostgreSQL, column output names can be specified as GROUP BY. However, if I am mistaken, please let me know.
Relevant log output
No response
Database schema
CREATE TABLE spam (
id SERIAL PRIMARY KEY
);SQL queries
-- name: Spam :many
SELECT
s.id AS "s_id"
FROM
-- Using subqueries doesn't work.
(
SELECT
spam.id
FROM spam
) AS "s"
-- Change this to s.id and it will work.
GROUP BY s_id;Configuration
No response
Playground URL
What operating system are you using?
macOS
What database engines are you using?
PostgreSQL
What type of code are you generating?
Go
Activity
fix: count columns aliases only once
fix(compiler): correctly validate alias in order/group by clauses for…
fix(compiler): correctly validate alias in order/group by clauses for…
fix(compiler): correctly validate alias in order/group by clauses for…