"could not decorrelate subquery" when Yii2 gets column info

[Sarke]

Describe the problem

I get a SQLSTATE[XXUUU]: <<Unknown error>>: 7 ERROR: could not decorrelate subquery error.

The code in question is from https://github.com/yiisoft/yii2/blob/master/framework/db/pgsql/Schema.php#L473-L533

Specifically, the issue is with this part, as removing it removes the error:

    CASE WHEN COALESCE(td.typtype, tb.typtype, t.typtype) = 'e'::char
        THEN array_to_string((SELECT array_agg(enumlabel) FROM pg_enum WHERE enumtypid = COALESCE(td.oid, tb.oid, a.atttypid))::varchar[], ',')
        ELSE NULL
    END AS enum_values,

To Reproduce

1. Set up CockroachDB cluster
2. Set up basic Yii2 app
3. Make any model query (Yii2 will grab column info)

Expected behavior
No error.

Environment:

• CockroachDB version: serverless
• Server OS: Linux
• Client app: fails in both PHP/Yii2 and in DBeaver

Additional context
Total failure of app.

Jira issue: CRDB-18329

[blathers-crl]

Hello, I am Blathers. I am here to help you get the issue triaged.

Hoot - a bug! Though bugs are the bane of my existence, rest assured the wretched thing will get the best of care here.

I have CC'd a few people who may be able to assist you:

• @cockroachdb/sql-experience (found keywords: pg_)

If we have not gotten back to your issue within a few business days, you can try the following:

• Join our community slack channel and ask on #cockroachdb.
• Try find someone from here if you know they worked closely on the area and CC them.

_{🦉 Hoot! I am a Blathers, a bot for CockroachDB. My owner is otan.}

[Sarke]

Possibly related? #67951

[mgartner]

This was fixed by #95234, which should be included in v23.1. Closing.