bug(frontend): CorrelatedInputRef has not been decorrelated in ArraySubquery

[KeXiangWang]

Describe the bug

No response

Error message/log

Panic: CorrelatedInputRef { index: 0, correlated_id: 0 } has not been decorrelated

To Reproduce

CREATE TABLE IF NOT EXISTS array_types (
    x BIGINT[],
);

SELECT array(
  (
    SELECT t0.x[coalesce(nullif(anon_2 % cardinality(t0.x), 0), cardinality(t0.x))] AS anon_1
    FROM generate_series(1, 1 * cardinality(t0.x)) AS anon_2
  )
  ) AS repeated 
FROM array_types AS t0;

Expected behavior

At least not panic

How did you deploy RisingWave?

Any deployment.

The version of RisingWave

Recentest main.

Additional context

No response

[xxchan]

@chenzl25 Can you take a look? Thanks.

[chenzl25]

OK, let me take a look.

[chenzl25]

A simplified case:

SELECT array(
    (
      select t0.x
    )
  ) 
FROM array_types AS t0;