sql plan changed and performance regression

[kennedy8312]

Bug Report

It seems to be a regression introduced by commit.

1. Minimal reproduce step (Required)

git checkout 86cd94a
make & run
mysql -u root -h 127.0.0.1 -P 4000 test < testcase.sql

sql file is not allowed to upload. Please change the file extension.
testcase_sql.log

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

Update_456 N/A 0 root time:4.85ms
testcase_result_bad.log

3. What did you see instead (Required)

Update_456 N/A 0 root time:27.2ms
testcase_result_good.log

4. What is your TiDB version? (Required)

The slowness happened on master as well. It started with #35669 (86cd94a).

[kennedy8312]

/type regression

[kennedy8312]

Regression Analysis
PR caused this regression: #35669

[JasonWu0506]

/label affect-6.2, affect-6.5, affect-7.1, affect-7.5

[JasonWu0506]

/label affects-6.5

[JasonWu0506]

/label affects-7.1

[JasonWu0506]

/label affects-7.5

[JasonWu0506]

/label affects-6.2

[ti-chi-bot]

@JasonWu0506: The label(s) affects-6.2 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, needs-cherry-pick-release-7.6, affects-5.4, affects-6.1, affects-6.5, affects-7.1, affects-7.5, affects-7.6, may-affects-5.4, may-affects-6.1, may-affects-6.5, may-affects-7.1, may-affects-7.5, may-affects-7.6.

In response to this:

/label affects-6.2

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.

[kennedy8312]

/type performance