不支持insert all和insert first

openGauss不支持insert all和insert first， 测试大纲要求支持

--INSERT ALL
create table trancfg(
trancfg_testid varchar2(20) not null,
trancfg_id varchar2(4) not null,
trancfg_name varchar2(100),
trancfg_procnum number,
trancfg_runnum number,
trancfg_trannum number,
trancfg_brkpot varchar2(1),
trancfg_brktime number,
trancfg_fld1 varchar2(200),
trancfg_fld2 varchar2(200),
trancfg_fld3 number(19,2),
trancfg_fld4 number(19,2)
);

INSERT ALL   
INTO  trancfg  VALUES ('1', '1001', '转账', '10', '5000', '1', 'N', '0', null, null, null, null)
INTO  trancfg  VALUES ('1', '1002', '查询', '10', '5000', '1', 'N', '0', null, null, null, null)
INTO  trancfg  VALUES ('1', '1003', '代发工资', '5', '10', '1', 'N', '0', null, null, null, null)
INTO  trancfg  VALUES ('1', '1004', '存款', '10', '500', '1', 'N', '0', null, null, null, null)
INTO  trancfg  VALUES ('1', '1005', '取款', '10', '500', '1', 'N', '0', null, null, null, null)
INTO  trancfg  VALUES ('1', '1006', '资产盘点', '1', '1', '1', 'N', '0', null, null, null, null)
SELECT 1 FROM DUAL;

--INSERT FIRST
CREATE TABLE t1(product_id NUMBER, product_name VARCHAR2(80),MONTH NUMBER);  
INSERT INTO t1 VALUES(111, '苹果',1);  
INSERT INTO t1 VALUES(222, '橘子',1);  
INSERT INTO t1 VALUES(333, '香蕉',1);  
create table t2 as select * from t1 where 1=0;
create table t3 as select * from t1 where 1=0;
create table t4 as select * from t1 where 1=0;
create table t5 as select * from t1 where 1=0;

insert first 
when month=1 then
into t3 VALUES(product_id,product_name,month)  
when product_id=111 then 
into t4 VALUES(product_id,product_name,month)  
else 
into t5 VALUES(product_id,product_name,month)  
select product_id,product_name,month from t1;
commit;

openGauss/openGauss-server

内容风险标识

评论 (3)

openGauss/openGauss-server .gitee-modal { width: 500px !important; }

内容风险标识