Panic (unnest, cross join): type mismatch Varchar / List(Varchar)

[mgropp]

Describe the bug

RW panics when I try to create an MV like the one described below.

Error message/log

Error message on 2.7.2:

ERROR: Panicked when handling the request: Type mismatch when substituting $1 of Varchar with $1 of List(Varchar)
This is a bug. We would appreciate a bug report at: …


Error message on 2.6.3:

ERROR: Panicked when handling the request: assertion `left == right` failed: Type mismatch when substituting $1 with $1
  left: Varchar
 right: List(Varchar)
This is a bug. We would appreciate a bug report at: …

To Reproduce

create table x (id text, arr text[]);

create table y (id text);

create materialized view mv as (
	with cte as (
		select arr from x
		join y on y.id = x.id
	)
	select * from cte as z, unnest(z.arr)
);

Expected behavior

No response

How did you deploy RisingWave?

Docker/Testcontainers

The version of RisingWave

• PostgreSQL 13.14.0-RisingWave-2.6.3 (a19b313)
• PostgreSQL 13.14.0-RisingWave-2.7.2 (27274d9)

Additional context

No response

[chenzl25]

I have tested it with the main branch, it seems the issue has been resolved already. I will close it first. If you have any other issues, feel free to reopen it.