存在隐式类型转换的大 IN 请求硬解析耗时高

c1 in ('1','2','3' ...,'1000"); // c1 为数值型，数值型和字符串比较时，需要将字符串转换为数值型

-- OceanBase 数据库 V3.x 版本
SELECT tenant_id,
       param_count,
       query_sql
FROM
  (SELECT tenant_id,
          query_sql,
          LENGTH(param_infos) - LENGTH(REPLACE(param_infos, '{', '')) AS param_count
   FROM oceanbase.gv$plan_cache_plan_stat)
WHERE query_sql LIKE '%in %(%'
  AND param_count > 200
ORDER BY param_count DESC LIMIT 5;

-- OceanBase 数据库 V4.x 版本 
SELECT tenant_id,
       param_count,
       query_sql
FROM
  (SELECT tenant_id,
          query_sql,
          LENGTH(param_infos) - LENGTH(REPLACE(param_infos, '{', '')) AS param_count
   FROM oceanbase.gv$ob_plan_cache_plan_stat)
WHERE query_sql LIKE '%in %(%'
  AND param_count > 200
ORDER BY param_count DESC LIMIT 5;

explain select * from t1 where c1 in ('1','2','3');
+--------------------------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                                           |
+--------------------------------------------------------------------------------------------------------------------------------------+
| ===================================================                                                                                  |
| |ID|OPERATOR        |NAME   |EST.ROWS|EST.TIME(us)|                                                                                  |
| ---------------------------------------------------                                                                                  |
| |0 |TABLE RANGE SCAN|t1(idx)|1       |17          |                                                                                  |
| ===================================================                                                                                  |
| Outputs & filters:                                                                                                                   |
| -------------------------------------                                                                                                |
|   0 - output([t1.c1], [t1.c2]), filter(nil), rowset=16                                                                               |
|       access([t1.__pk_increment], [t1.c1], [t1.c2]), partitions(p0)                                                                  |
|       is_index_back=true, is_global_index=false,                                                                                     |
|       range_key([t1.c1], [t1.__pk_increment]), range(1,MIN ; 1,MAX), (2,MIN ; 2,MAX), (3,MIN ; 3,MAX),                               |
|       range_cond([cast(t1.c1, DECIMAL(11, 0)) IN (cast('1', DECIMAL(1, -1)), cast('2', DECIMAL(1, -1)), cast('3', DECIMAL(1, -1)))]) |
+--------------------------------------------------------------------------------------------------------------------------------------+