Projection push down to tikv leads to incorrect result when subquery and agg

[yibin87]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

set tidb_opt_projection_push_down = 'on';
CREATE TABLE t(a INT, b INT);
INSERT INTO t VALUES (5,6), (1,7);
CREATE TABLE t2(i INT);
INSERT INTO t2 VALUES (10),(100);
SELECT (SELECT SUM(a) OVER () FROM t2 LIMIT 1) FROM t;

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

10
2

3. What did you see instead (Required)

NULL
NULL

4. What is your TiDB version? (Required)

| Release Version: v7.4.0-alpha-2012-gfe01d11df6-dirty
Edition: Community
Git Commit Hash: fe01d11
Git Branch: div_increase_prec
UTC Build Time: 2024-03-15 08:10:07

[yibin87]

tidb_opt_projection_push_down is not set by default. Not critical issue.

[yibin87]

/assign @yibin87

[yibin87]

/affects 7.5

[yibin87]

/affects-7.5

[yibin87]

/label may-affects-5.4

[yibin87]

/may-affects-5.4

[yibin87]

/affect-7.5

[yibin87]

/label affects-7.5

[yibin87]

/label affects-7.1

[yibin87]

/label affects-6.5

[yibin87]

/label affects-6.1

[yibin87]

/label may-affects-5.4

[yibin87]

/unlabel may-affects-5.4

[yibin87]

/label affects-5.4

[yibin87]

/remove-label affects-5.4