-- @owner: wan005

-- @date: 2024-11-05

-- @testpoint: unlogged表插入mediumint类型，部分合理报错



--pre1:切换B库执行

@conn PrimaryDbBmode;



--step1:创建unlogged表 expect:成功

drop table if exists t_mediumint_0017;

create unlogged table t_mediumint_0017(c1 mediumint(100));



--step2:向表中插入数据，查询表中数据 expect:部分合理报错

insert into t_mediumint_0017 values('0001');

insert into t_mediumint_0017 values('100');

insert into t_mediumint_0017 values('0');

insert into t_mediumint_0017 values('1');

insert into t_mediumint_0017 values('false');

insert into t_mediumint_0017 values(' ');

insert into t_mediumint_0017 values(null);

insert into t_mediumint_0017 values('null');

insert into t_mediumint_0017 values('asd');

insert into t_mediumint_0017 values('&%');

insert into t_mediumint_0017 values('2147483647');

select * from t_mediumint_0017;



--step3:清理环境;expect:清理环境完成

drop table if exists t_mediumint_0017;