测试类型

SQL功能

测试版本

7.0.0LTS

问题描述

开启bsion，执行sql异常，关闭之后能正常执行

操作系统和硬件信息

all

测试环境

oGRAC双节点

被测功能

预置条件

操作步骤

drop table if exists NEBULA.COMP_SUBPART_INTERVAL_RANGE_001; create table NEBULA.COMP_SUBPART_INTERVAL_RANGE_001(num int,c_id int,c_d_id bigint NOT NULL,c_w_id tinyint unsigned NOT NULL,c_uint UINT not null,c_first varchar(16) NOT NULL,c_middle char(2),c_last varchar(16) NOT NULL,c_street_1 varchar(20) NOT NULL,c_street_2 varchar(20),c_zero timestamp NOT NULL,c_start date NOT NULL,c_zip char(9) NOT NULL,c_phone char(16) NOT NULL,c_since timestamp,c_credit char(2),c_credit_lim numeric,c_discount numeric(5,2),c_balance number(12,2),c_ytd_payment real NOT NULL,c_payment_cnt number NOT NULL,c_delivery_cnt bool NOT NULL,c_end date NOT NULL,c_data1 varchar(7744),c_data2 varchar(7744),c_data3 varchar(7744),c_data4 varchar(7744),c_data5 varchar(7744),c_data6 varchar(7744),c_data7 varchar(7744),c_data8 varchar(7744),c_clob clob,c_blob blob,PRIMARY KEY (C_ID)) PARTITION BY RANGE(C_ID) INTERVAL(100) SUBPARTITION BY RANGE(c_d_id,c_w_id)( PARTITION P1 VALUES LESS THAN(401) storage(initial 64k maxsize 2g)(SUBPARTITION P11 VALUES LESS THAN(17,4),SUBPARTITION P12 VALUES LESS THAN(33,7) TABLESPACE SYSAUX,SUBPARTITION P13 VALUES LESS THAN(49,10) TABLESPACE TABLESPACE_SUBPART_COMMON_1,SUBPARTITION P14 VALUES LESS THAN(65,13) TABLESPACE TABLESPACE_SUBPART_BITMAP_2,SUBPARTITION P15 VALUES LESS THAN(MAXVALUE,MAXVALUE) TABLESPACE TABLESPACE_SUBPART_COMMON_2), PARTITION P2 VALUES LESS THAN(801) storage(initial 128k maxsize 2g) TABLESPACE TABLESPACE_SUBPART_COMMON_1 (SUBPARTITION P21 VALUES LESS THAN(17,4),SUBPARTITION P22 VALUES LESS THAN(33,7) TABLESPACE SYSAUX,SUBPARTITION P23 VALUES LESS THAN(49,10) TABLESPACE TABLESPACE_SUBPART_COMMON_1 ,SUBPARTITION P24 VALUES LESS THAN(65,13) TABLESPACE TABLESPACE_SUBPART_BITMAP_2,SUBPARTITION P25 VALUES LESS THAN(MAXVALUE,MAXVALUE) TABLESPACE TABLESPACE_SUBPART_COMMON_3), PARTITION P3 VALUES LESS THAN(1201) storage(initial 96k maxsize 2g) TABLESPACE TABLESPACE_SUBPART_BITMAP_2 (SUBPARTITION P31 VALUES LESS THAN(17,4),SUBPARTITION P32 VALUES LESS THAN(33,7) TABLESPACE SYSAUX,SUBPARTITION P33 VALUES LESS THAN(49,10) TABLESPACE TABLESPACE_SUBPART_COMMON_1 ,SUBPARTITION P34 VALUES LESS THAN(65,13) TABLESPACE TABLESPACE_SUBPART_BITMAP_2,SUBPARTITION P35 VALUES LESS THAN(MAXVALUE,MAXVALUE) TABLESPACE TABLESPACE_SUBPART_COMMON_3), PARTITION P4 VALUES LESS THAN(1601) storage(initial 96k maxsize 2g) TABLESPACE SYSAUX (SUBPARTITION P41 VALUES LESS THAN(17,4),SUBPARTITION P42 VALUES LESS THAN(33,7) TABLESPACE SYSAUX,SUBPARTITION P43 VALUES LESS THAN(49,10) TABLESPACE TABLESPACE_SUBPART_COMMON_2,SUBPARTITION P44 VALUES LESS THAN(65,13) TABLESPACE TABLESPACE_SUBPART_BITMAP_3,SUBPARTITION P45 VALUES LESS THAN(MAXVALUE,MAXVALUE) TABLESPACE TABLESPACE_SUBPART_COMMON_3), PARTITION P5 VALUES LESS THAN(1801) storage(initial 96k maxsize 2g) TABLESPACE SYSAUX (SUBPARTITION P51 VALUES LESS THAN(17,4),SUBPARTITION P52 VALUES LESS THAN(33,7) TABLESPACE SYSAUX,SUBPARTITION P53 VALUES LESS THAN(49,10) TABLESPACE TABLESPACE_SUBPART_COMMON_2,SUBPARTITION P54 VALUES LESS THAN(65,13) TABLESPACE TABLESPACE_SUBPART_BITMAP_3,SUBPARTITION P55 VALUES LESS THAN(MAXVALUE,MAXVALUE) TABLESPACE TABLESPACE_SUBPART_COMMON_3) ) storage(initial 164k maxsize 10g) tablespace tablespace_subpart_bitmap_2;

预期输出

实际输出

报错：
OG-00601, [9:1]Sql syntax error: value count must equal to partition keys

日志信息

OG-00601, [9:1]Sql syntax error: value count must equal to partition keys

提单组织

内部开发

测试代码