Wes

I have actually run into this issue as well. From my experience, cloud native load balancers (outside of k8s) check for readiness through a very simple system. You define an...

@voluntas pinged me on this issue, but I cannot find where the problem is here. I am having no problems generating the correct return types. I think there needs to...

@aarondl0 Thank you for the response I'm understanding the problem much better now and you are absolutely correct that it is generating the wrong type. I've spent a good hour...

Okay, as I thought I located the issue. It has to do with the follow lines of code: https://github.com/kyleconroy/sqlc/blob/0ae16d272c715c8ef91197512bef98e34b03fbe2/internal/compiler/output_columns.go#L230-L250 With this particular example, we hit the EXPR_SUBLINK switch case where...

It had to do with issue #1208. I saw you had dismissed the issue as invalid, but I found that the issue was in fact valid. It has to do...

Okay so I looked at the failed test. The issue is that when we do a subquery with SELECT COUNT, it is not a nullable value but if we do...

Okay, so I dug into this problem a little further. Firstly, I was using the term "subquery" incorrectly. A subquery is a legitimate Postgresql term, see [here](https://www.postgresql.org/docs/9.0/functions-subquery.html), that returns a...

Apologies for my word vomit. I'm realizing now that the SubLink likely does handle most of those cases correctly because it is just a recursive call. The only case that...

I've also run into this issue. Here is my repro: https://gist.github.com/WesleyMiller1998/7730c3ab8b3183c432075728a4e463bf It appears that a column override messes with the type generation. I may dig into the issue later and...