coprocessor streaming scans duplicated ranges when meeting lock

[you06]

Bug Report

Please answer these questions before submitting your issue. Thanks!

Related to #30207.

1. Minimal reproduce step (Required)

1. Build the failpoint package and run with failpoint enabled.

make failpoint-enable
make && cd bin
GO_FAILPOINTS="github.com/pingcap/tidb/server/enableTestAPI=return(true)" tiup playground nightly --monitor=false --tiflash=0 --db.binpath=./tidb-server

2. Prepare data with this script.

3. Inject with 5 secs sleep before commit phase(this will not affect 1pc).

curl -X PUT -d "sleep(5000)" "http://127.0.0.1:10080/fail/tikvclient/beforeCommit"

4. Execute the insert from the first connection then select from the second session.

Conn1	Conn2
set tidb_enable_1pc=off;	set tidb_enable_streaming=1;
insert into t values(1001, 1001);
	select * from t;
Query OK, 1 row affected (5.006 sec)	2153 rows in set (1.734 sec)

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

Select statement in the second connection should return either 1,000 or 1,001 rows.

3. What did you see instead (Required)

It returns more than 1,001 rows.

4. What is your TiDB version? (Required)

master