Cop Apply operator will not fill correlated column value in late materialization filter condition

[Lloyd-Pottiger]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

create table t(id int, value int);
create table t1(id int, value int);
insert into t values(10,5),(9,5),(8,5),(7,5),(6,5),(5,5),(4,5),(3,5),(2,5),(1,5);
insert into t1 values(2,5);
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
insert into t select * from t;
alter database set tiflash replica 1;
set tidb_allow_mpp=off;
select (select t.value from t where t.id = t1.id order by t.value limit 1) xx from t1 order by t1.value limit 5;
+------+
| xx   |
+------+
| NULL |
+------+
1 row in set (0.02 sec)

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

select (select t.value from t where t.id = t1.id order by t.value limit 1) xx from t1 order by t1.value limit 5;
+------+
| xx   |
+------+
|    5 |
+------+
1 row in set (0.01 sec)

3. What did you see instead (Required)

select (select t.value from t where t.id = t1.id order by t.value limit 1) xx from t1 order by t1.value limit 5;
+------+
| xx   |
+------+
| NULL |
+------+
1 row in set (0.02 sec)

4. What is your TiDB version? (Required)

v7.1.2

[Lloyd-Pottiger]

/assign

[Lloyd-Pottiger]

/label affects-7.1

[Lloyd-Pottiger]

/label affects-7.5

[Lloyd-Pottiger]

/label severity/major

[ti-chi-bot]

@Lloyd-Pottiger: The label(s) severity/major cannot be applied. These labels are supported: fuzz/sqlancer, challenge-program, compatibility-breaker, first-time-contributor, contribution, good first issue, correctness, duplicate, proposal, security, ok-to-test, needs-ok-to-test, needs-more-info, needs-cherry-pick-release-5.4, needs-cherry-pick-release-6.1, needs-cherry-pick-release-6.5, needs-cherry-pick-release-7.1, needs-cherry-pick-release-7.5, affects-5.4, affects-6.1, affects-6.5, affects-7.1, affects-7.5, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5.

In response to this:

/label severity/major

Instructions for interacting with me using PR comments are available here. If you have questions or suggestions related to my behavior, please file an issue against the ti-community-infra/tichi repository.