unstable test TestNonPreparedPlanTypeRandomly

[hawkingrei]

Bug Report

Please answer these questions before submitting your issue. Thanks!

1. Minimal reproduce step (Required)

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

3. What did you see instead (Required)

[2023/05/16 11:22:41.306 +08:00] [INFO] [callback.go:128] ["performing DDL change, must reload"]

[2023/05/16 11:22:41.306 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854522200067] [checkTS=441504854522200068]

[2023/05/16 11:22:41.307 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854522462210] [checkTS=441504854522462211]

[2023/05/16 11:22:41.308 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854522724354] [checkTS=441504854522724355]

[2023/05/16 11:22:41.309 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854522986497] [checkTS=441504854522986498]

[2023/05/16 11:22:41.310 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854523248642] [checkTS=441504854523248643]

[2023/05/16 11:22:41.311 +08:00] [WARN] [2pc.go:1783] ["schemaLeaseChecker is not set for this transaction"] [sessionID=6] [startTS=441504854523510786] [checkTS=441504854523510787]

    result.go:49: 

        	Error Trace:	testkit/result.go:49

        	            				planner/core/plan_cache_test.go:910

        	Error:      	Not equal: 

        	            	expected: ""

        	            	actual  : "[2023-01-16 2023-01-15]\n[2023-01-16 2023-01-20]\n"

        	            	

        	            	Diff:

        	            	--- Expected

        	            	+++ Actual

        	            	@@ -1 +1,3 @@

        	            	+[2023-01-16 2023-01-15]

        	            	+[2023-01-16 2023-01-20]

        	            	 

        	Test:       	TestNonPreparedPlanTypeRandomly

        	Messages:   	sql:select * from t6 where a in ('2023-01-16', 2022), args:[]

4. What is your TiDB version? (Required)

[hawkingrei]

https://do.pingcap.net/jenkins/blue/organizations/jenkins/pingcap%2Ftidb%2Fghpr_unit_test/detail/ghpr_unit_test/24549/pipeline

[qw4990]

The minimal reproducible case:

create table t6 (a date, b date, key(a));
insert into t6 values ('2023-01-21', '2023-01-05');

set tidb_enable_non_prepared_plan_cache=1;
select * from t6 where a in (2015, '8');
select * from t6 where a in (2009, '2023-01-21');

+-------------------------+---------+---------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+--------+------+
| id                      | estRows | actRows | task      | access object | execution info                                                                                                                                                                              | operator info                                    | memory | disk |
+-------------------------+---------+---------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+--------+------+
| TableReader_7           | 0.80    | 0       | root      |               | time:472µs, loops:1, cop_task: {num: 1, max: 406.5µs, proc_keys: 0, rpc_num: 1, rpc_time: 379.7µs, copr_cache_hit_ratio: 0.00, build_task_duration: 7.42µs, max_distsql_concurrency: 1}     | data:Selection_6                                 | N/A    | N/A  |
| └─Selection_6           | 0.80    | 0       | cop[tikv] |               | tikv_task:{time:360µs, loops:0}                                                                                                                                                             | or(eq(cast(test.t6.a, double BINARY), 2009), 0)  | N/A    | N/A  |
|   └─TableFullScan_5     | 1.00    | 1       | cop[tikv] | table:t6      | tikv_task:{time:360µs, loops:0}                                                                                                                                                             | keep order:false, stats:partial[a:unInitialized] | N/A    | N/A  |
+-------------------------+---------+---------+-----------+---------------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+--------+------+

[qw4990]

Introduced by #43009