Overrides aren't applied to the output of some aggregate functions

[andrewmbenton]

Version

1.23.0

What happened?

While investigating #2973, I discovered that the new database-backed query analysis engine correctly determines the types returned from aggregate functions (like SUM() and MAX()) but overrides appear not to be applied.

See the playground link below for a contrived example.

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

https://play.sqlc.dev/p/805a63c93e881d175878c977a7da684b8616b8dcb4f538520eacb5a5101a954b

What operating system are you using?

No response

What database engines are you using?

PostgreSQL

What type of code are you generating?

Go

[kyleconroy]

If you use integer instead of pg_catalog.int4, the overrides work correctly https://play.sqlc.dev/p/20a4bc6945b5102aac27e034893f1eba42b59c4457573b1df25db04a38a047a7

[andrewmbenton]

If you use integer instead of pg_catalog.int4, the overrides work correctly

They work in the result struct, but not in the model. So we have a different problem.

But as a workaround you can add both overrides.