Join partition table with normal table for update should lock normal table but not

[lcwangchao]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

Prepare:

create table tp (id int primary key) partition by range (id) (partition p0 values less than (100));
create table tn (id int primary key);
insert into tp values(1),(2);
insert into tn values(1),(2);

Session1:

begin;
select * from tp,tn where tp.id=tn.id and tn.id<=1 for update;

Session2:

begin;
select * from tn where id=1 for update;

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

Session2 should be blocked util session1's txn is committed or aborted.

3. What did you see instead (Required)

Session2 not blocked.

4. What is your TiDB version? (Required)

master

[lcwangchao]

Maybe some relationship with #26250

[ti-srebot]

Please edit this comment or add a new comment to complete the following information

Not a bug

1. Remove the 'type/bug' label
2. Add notes to indicate why it is not a bug

Duplicate bug

1. Add the 'type/duplicate' label
2. Add the link to the original bug

Bug

Note: Make Sure that 'component', and 'severity' labels are added
Example for how to fill out the template: #20100

1. Root Cause Analysis (RCA) (optional)

2. Symptom (optional)

3. All Trigger Conditions (optional)

4. Workaround (optional)

5. Affected versions

6. Fixed versions