SQL & PL/SQL

I am encountering a strange bug where the same SQL query runs on 18c/23c but fails on 21c.

I'm wondering if there is any better way to achieve what I am doing than embedding a string directly, as seen here:

coalesce("Albums_rows", to_clob('{ "rows": [] }'))

NOTE: The following SQL is highly unusual and could be better written using correlated subqueries. But I am generating the same SQL template across multiple dialects, some of which don't support correlated subqueries. Oracle is the only one giving issue so far -- and only Oracle 21c!

Links to runnable examples with output:

• ✅ Oracle 18c | db<>fiddle (dbfiddle.uk)
• ❌ Oracle 21c | db<>fiddle (dbfiddle.uk)
• ✅ Oracle 21c (hack) | db<>fiddle (dbfiddle.uk)
• ✅ Oracle 23c | db<>fiddle (dbfiddle.uk)

Thanks in advance for anyone who has suggestions/recommendations.

Also, is there any way to report this to Oracle so that a patch can be made for 21c?