Error: Cannot find column

[bajinsheng]

Bug Report

1. Minimal reproduce step (Required)

create table t0(c0 varchar(0));
create view v1 as select 0 c_1, case when(select c0) then 0 end from t0;
select min((select c_1 from v1)) over(); --ERROR 1105 (HY000) at line 1: Can't find column Column#14 in schema Column: [Column#20] PKOrUK: [] NullableUK: []

2. What did you expect to see? (Required)

No error

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

tiup playground nightly --host 0.0.0.0 --kv 3 --tiflash 3

8.0.11-TiDB-v9.0.0-beta.1.pre-554-gb1a5536a64-dirty

[bajinsheng]

/label fuzz/sqlancer

[hawkingrei]

If I refactor the sql like this , It will not trigger the bug. so It is relation with the view.

CREATE TABLE t0 (c0 VARCHAR(0));

SELECT MIN(
    (SELECT c_1 FROM (SELECT 0 AS c_1, CASE WHEN (SELECT c0 FROM t0) THEN 0 END) AS subquery)
) OVER ();