达梦数据库-错误码-[119]-分析处理
错误码：119
错误内容：LIST分区没有指定DEFAULT分区,存在定位不到分区的情况
错误级别: WARN
原因：创建LIST分区表时, 没有指定默认值

CREATE  TABLE  callinfo( 
    caller CHAR(15), 
    callee CHAR(15),
    time    DATETIME,
    duration INT
)
PARTITION BY RANGE(time)(
PARTITION p1 VALUES LESS THAN ('2010-04-01'),
PARTITION p2 VALUES LESS THAN ('2010-07-01'),
PARTITION p3 VALUES LESS THAN ('2010-10-01')
11  );
warning: Range partition not include maxvalue,partition may be not located
executed successfully
used time: 28.599(ms). Execute id is 602.
SQL> 

解决方法
添加默认值

CREATE TABLE T1(
id int,
name varchar(12)
)
PARTITION BY LIST(id)
(
   PARTITION p1 VALUES ('11','12','21','22'),
    PARTITION p2 VALUES ('31','32','41','42'),
    PARTITION p3 VALUES ('51','52','61','62'),
    PARTITION p4 VALUES ('71','72','81','82'),
    PARTITION p5 VALUES (DEFAULT)
12  );
executed successfully
used time: 22.245(ms). Execute id is 1002.
SQL>