Rafi Shamim

https://github.com/cockroachdb/cockroach/pull/85945 seems to have fixed it

Yes the PR I linked in my issue report under "Desired solution" addresses the problem.

Hi all, I work on cockroachdb. I tested with a bleeding edge version of cockroachdb (which will soon be released as v21.2-alpha). The issue reported in https://github.com/MagicStack/asyncpg/issues/580#issuecomment-636463262 no longer occurs....

> asyncpg uses an unnamed portal in fetch and other methods. Postgres does not require it to be destroyed explicitly, as unnamed portals get auto-destroyed on the next Bind. It...

Actually I was mistaken above. However, I created https://github.com/cockroachdb/cockroach/pull/83164, which should implement the correct unnamed portal behavior for the specific way that asyncpg uses them (sending a Prepare, then Describe,...

Version 21.2 of CockroachDB will support correlated CTEs (https://github.com/cockroachdb/cockroach/pull/63956) -- hopefully that will help.

Just to clarify, what is the error you get with the ``` SELECT DISTINCT ON (ACCOUNT.ID) * FROM ACCOUNT WHERE ID = ANY($1 :: uuid[]) ORDER BY ACCOUNT.ID, ACCOUNT.TIMESTAMP DESC...

Thanks! From what I can see the error message is not coming from within CockroachDB, so I'm not familiar with it. But if it turns out that the issue is...

I can try giving it a shot later, but I don't have a .NET environment easily available. Hahah, if only we could merge our dev environments together.. :) FYI, CockroachDB...

Hi! Right now CockroachDB doesn't support that syntax. It's blocked on the more fundamental feature of supporting user-defined functions and stored procedures. A tracking issue is here https://github.com/cockroachdb/cockroach/issues/17511 -- we...