List 类型分区表无法分区裁剪的原因及解决办法

explain extended select COALESCE(sum(wkpje), 0) as kpje,
    count(rdid) cnt
from TABLE
 where 
  kfhm='0701819022'
  and ywlx='1'
  and lszt in(1,2)
  and cfhbzt=1
  and jyjg not in('01025','01026','01027','01032')
 and jyrq>=to_date('20191001','yyyymmdd')
and jyrq<=to_date('20191021','yyyymmdd');
===============================================================================
|ID|OPERATOR                     |NAME                  |EST.ROWS|EST.TIME(us)|
-------------------------------------------------------------------------------
|0 |SCALAR GROUP BY              |                      |1       |177171      |
|1 |└─PX COORDINATOR             |                      |1       |177171      |
|2 |  └─EXCHANGE OUT DISTR       |:EX10000              |1       |177170      |
|3 |    └─MERGE GROUP BY         |                      |1       |177169      |
|4 |      └─PX PARTITION ITERATOR|                      |1       |177169      |
|5 |        └─TABLE FULL SCAN    |TABLE_XXX             |1       |177169      |
===============================================================================
Outputs & filters:
-------------------------------------
 [TABLE_XXX.RDID(0x7f354d6480d0)]), partitions(p[0-112])    ******这里可以看到没有分区裁剪******
 is_index_back=false, is_global_index=false, filter_before_indexback[false,false,false,false,false,false,false], 
range_key([TABLE_XXX.__pk_increment(0x7f354d6498f0)]), range(MIN ; MAX)always true

create table t1 (c1 tinyint, c2 tinyint) partition by list(c1)
(
  partition p0 values in (1,2),
  partition p1 values in (3,4),
  partition p2 values in (5,6),
  partition p3 values in (7,8),
  partition p4 values in (9,10),
  partition p5 values in (default)
);
insert into t1 values (1,1),(2,2),(3,3),(4,4),(5,5),(6,6),(7,7),(8,8),(9,9),(10,10);
OceanBase(root@test)>explain select * from t1 where c1 < 3;
+------------------------------------------------------------------------------------+
| Query Plan                                                                         |
+------------------------------------------------------------------------------------+
| =============================================================                      |
| |ID|OPERATOR                 |NAME    |EST.ROWS|EST.TIME(us)|                      |
| -------------------------------------------------------------                      |
| |0 |PX COORDINATOR           |        |1       |25          |                      |
| |1 |└─EXCHANGE OUT DISTR     |:EX10000|1       |24          |                      |
| |2 |  └─PX PARTITION ITERATOR|        |1       |24          |                      |
| |3 |    └─TABLE FULL SCAN    |t1      |1       |24          |                      |
| =============================================================                      |
| Outputs & filters:                                                                 |
| -------------------------------------                                              |
|   0 - output([INTERNAL_FUNCTION(t1.c1, t1.c2)]), filter(nil), rowset=16            |
|   1 - output([INTERNAL_FUNCTION(t1.c1, t1.c2)]), filter(nil), rowset=16            |
|       dop=1                                                                        |
|   2 - output([t1.c1], [t1.c2]), filter(nil), rowset=16                             |
|       force partition granule                                                      |
|   3 - output([t1.c1], [t1.c2]), filter([t1.c1 < 3]), rowset=16                     |
|       access([t1.c1], [t1.c2]), partitions(p[0-5])                                 |
|       is_index_back=false, is_global_index=false, filter_before_indexback[false],  |
|       range_key([t1.__pk_increment]), range(MIN ; MAX)always true                  |
+------------------------------------------------------------------------------------+
19 rows in set (0.04 sec)


create table t9 (c1 datetime, c2 datetime) partition by list columns(c1)
(
  partition p0 values in ('2024-01-01 12:00:00','2024-01-02 12:00:00','2024-01-03 12:00:00','2024-01-04 12:00:00','2024-01-05 12:00:00'),
  partition p1 values in ('2024-01-06 12:00:00','2024-01-07 12:00:00','2024-01-08 12:00:00','2024-01-09 12:00:00','2024-01-10 12:00:00')
);
insert into t9 values ('2024-01-01 12:00:00','2024-01-01 12:00:00'),('2024-01-02 12:00:00','2024-01-02 12:00:00'),('2024-01-03 12:00:00','2024-01-03 12:00:00'),
                      ('2024-01-04 12:00:00','2024-01-04 12:00:00'),('2024-01-05 12:00:00','2024-01-05 12:00:00'),('2024-01-06 12:00:00','2024-01-06 12:00:00'),
                      ('2024-01-07 12:00:00','2024-01-07 12:00:00'),('2024-01-08 12:00:00','2024-01-08 12:00:00'),('2024-01-09 12:00:00','2024-01-09 12:00:00'),
                      ('2024-01-10 12:00:00','2024-01-10 12:00:00');
explain select * from t9 where c1 < '2024-01-03 00:00:00';

OceanBase(root@test)>explain select * from t9 where c1 < '2024-01-03 00:00:00';
+------------------------------------------------------------------------------------------------------------------+
| Query Plan                                                                                                       |
+------------------------------------------------------------------------------------------------------------------+
| =============================================================                                                    |
| |ID|OPERATOR                 |NAME    |EST.ROWS|EST.TIME(us)|                                                    |
| -------------------------------------------------------------                                                    |
| |0 |PX COORDINATOR           |        |1       |10          |                                                    |
| |1 |└─EXCHANGE OUT DISTR     |:EX10000|1       |9           |                                                    |
| |2 |  └─PX PARTITION ITERATOR|        |1       |8           |                                                    |
| |3 |    └─TABLE FULL SCAN    |t9      |1       |8           |                                                    |
| =============================================================                                                    |
| Outputs & filters:                                                                                               |
| -------------------------------------                                                                            |
|   0 - output([INTERNAL_FUNCTION(t9.c1, t9.c2)]), filter(nil), rowset=16                                          |
|   1 - output([INTERNAL_FUNCTION(t9.c1, t9.c2)]), filter(nil), rowset=16                                          |
|       dop=1                                                                                                      |
|   2 - output([t9.c1], [t9.c2]), filter(nil), rowset=16                                                           |
|       force partition granule                                                                                    |
|   3 - output([t9.c1], [t9.c2]), filter([t9.c1 < cast('2024-01-03 00:00:00', MYSQL_DATETIME(-1, -1))]), rowset=16 |
|       access([t9.c1], [t9.c2]), partitions(p[0-1])                                                               |
|       is_index_back=false, is_global_index=false, filter_before_indexback[false],                                |
|       range_key([t9.__pk_increment]), range(MIN ; MAX)always true                                                |
+------------------------------------------------------------------------------------------------------------------+
19 rows in set (0.03 sec)