In pessimistic transaction, select for update is different on partition tables and non-partition tables

[zhenjiaogao]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

• Partiton Table
  

• Non-partition Table
  

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

In pessimistic transaction, select for update is the same on partition and non-partition tables

3. What did you see instead (Required)

4. What is your TiDB version? (Required)

mysql> select version();
+--------------------+
| version()          |
+--------------------+
| 5.7.25-TiDB-v4.0.9 |
+--------------------+
1 row in set (0.00 sec)

[zyguan]

TiDB may acquire unnecessary locks #21688, thus we get lock wait timeout for the case of non-partitioned table. For the partitioned table version, I think it because the query condition doesn't match any of partitions, if we create an partition which include '2020-11-30', it gets blocked too.

[zyguan]

dup of #21688

[github-actions]

Please check whether the issue should be labeled with 'affects-x.y' or 'fixes-x.y.z', and then remove 'needs-more-info' label.