Linux ctumhispra01218 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
datakit在线、离线迁移
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 5ef00924) compiled at 2024-08-24 09:10:13 commit 0 last mr
【预置条件】:
datakit迁移环境搭建成功
【操作步骤】(请填写详细的操作步骤):
1. 预置数据带主键
```
drop table if exists numeric_type1;create table numeric_type1(c_1 int default 20,c_2 tinyint default 5,c_3 smallint,c_4 bigint,c_5 mediumint,c_6 integer,c_7 float(5,2),c_8 double(5,2),c_9 numeric(10,7),c_10 decimal(10,7),c_11 bit(8),c_12 dec(5,2) primary key);
insert into numeric_type1 values(default,default,32767,9223372036854775807,8388607,2000,125.367,12.278,165.391258974,123.2115897252,B'10101011',12.568);select * from numeric_type1;
create table tt13 ( d1 datetime not null, d2 date not null, d3 timestamp default current_timestamp comment '时间戳', d4 time primary key, d5 year, d6 timestamp(3) not null default current_timestamp(3) comment '创建时间');
insert into tt13 values('2018-5-5 16:36:30','2018-5-5',default,'17:52:30','2021',default);
insert into tt13 values('9999-12-31','2021-6-23',default,'14:52:30','2020',default);
drop table if exists binary_type;
create table binary_type(
c_1 binary(3) comment '字段1',
c_2 varbinary(10) primary key,
c_3 tinyblob comment '字段3',
c_4 blob comment '字段4',
c_5 mediumblob comment '字段5',
c_6 longblob comment '字段6'
);
insert into binary_type values(1,10,null,null,null,null);
Linux ctumhispra01218 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
datakit在线、离线迁移
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 5ef00924) compiled at 2024-08-24 09:10:13 commit 0 last mr
【预置条件】:
datakit迁移环境搭建成功
【操作步骤】(请填写详细的操作步骤):
1. 预置数据带主键
```
drop table if exists numeric_type1;create table numeric_type1(c_1 int default 20,c_2 tinyint default 5,c_3 smallint,c_4 bigint,c_5 mediumint,c_6 integer,c_7 float(5,2),c_8 double(5,2),c_9 numeric(10,7),c_10 decimal(10,7),c_11 bit(8),c_12 dec(5,2) primary key);
insert into numeric_type1 values(default,default,32767,9223372036854775807,8388607,2000,125.367,12.278,165.391258974,123.2115897252,B'10101011',12.568);select * from numeric_type1;
create table tt13 ( d1 datetime not null, d2 date not null, d3 timestamp default current_timestamp comment '时间戳', d4 time primary key, d5 year, d6 timestamp(3) not null default current_timestamp(3) comment '创建时间');
insert into tt13 values('2018-5-5 16:36:30','2018-5-5',default,'17:52:30','2021',default);
insert into tt13 values('9999-12-31','2021-6-23',default,'14:52:30','2020',default);
drop table if exists binary_type;
create table binary_type(
c_1 binary(3) comment '字段1',
c_2 varbinary(10) primary key,
c_3 tinyblob comment '字段3',
c_4 blob comment '字段4',
c_5 mediumblob comment '字段5',
c_6 longblob comment '字段6'
);
insert into binary_type values(1,10,null,null,null,null);
Linux ctumhispra01218 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
datakit在线、离线迁移
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 5ef00924) compiled at 2024-08-24 09:10:13 commit 0 last mr
【预置条件】:
datakit迁移环境搭建成功
【操作步骤】(请填写详细的操作步骤):
1. 预置数据带主键
```
drop table if exists numeric_type1;create table numeric_type1(c_1 int default 20,c_2 tinyint default 5,c_3 smallint,c_4 bigint,c_5 mediumint,c_6 integer,c_7 float(5,2),c_8 double(5,2),c_9 numeric(10,7),c_10 decimal(10,7),c_11 bit(8),c_12 dec(5,2) primary key);
insert into numeric_type1 values(default,default,32767,9223372036854775807,8388607,2000,125.367,12.278,165.391258974,123.2115897252,B'10101011',12.568);select * from numeric_type1;
create table tt13 ( d1 datetime not null, d2 date not null, d3 timestamp default current_timestamp comment '时间戳', d4 time primary key, d5 year, d6 timestamp(3) not null default current_timestamp(3) comment '创建时间');
insert into tt13 values('2018-5-5 16:36:30','2018-5-5',default,'17:52:30','2021',default);
insert into tt13 values('9999-12-31','2021-6-23',default,'14:52:30','2020',default);
drop table if exists binary_type;
create table binary_type(
c_1 binary(3) comment '字段1',
c_2 varbinary(10) primary key,
c_3 tinyblob comment '字段3',
c_4 blob comment '字段4',
c_5 mediumblob comment '字段5',
c_6 longblob comment '字段6'
);
insert into binary_type values(1,10,null,null,null,null);
Linux ctumhispra01218 3.10.0-957.el7.x86_64 #1 SMP Thu Nov 8 23:39:32 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
【测试环境】(单机/1主x备x级联备):
单机
【被测功能】:
datakit在线、离线迁移
【测试类型】:
功能测试
【数据库版本】(查询命令: gaussdb -V):
gaussdb (openGauss 6.0.0 build 5ef00924) compiled at 2024-08-24 09:10:13 commit 0 last mr
【预置条件】:
datakit迁移环境搭建成功
【操作步骤】(请填写详细的操作步骤):
1. 预置数据带主键
```
drop table if exists numeric_type1;create table numeric_type1(c_1 int default 20,c_2 tinyint default 5,c_3 smallint,c_4 bigint,c_5 mediumint,c_6 integer,c_7 float(5,2),c_8 double(5,2),c_9 numeric(10,7),c_10 decimal(10,7),c_11 bit(8),c_12 dec(5,2) primary key);
insert into numeric_type1 values(default,default,32767,9223372036854775807,8388607,2000,125.367,12.278,165.391258974,123.2115897252,B'10101011',12.568);select * from numeric_type1;
create table tt13 ( d1 datetime not null, d2 date not null, d3 timestamp default current_timestamp comment '时间戳', d4 time primary key, d5 year, d6 timestamp(3) not null default current_timestamp(3) comment '创建时间');
insert into tt13 values('2018-5-5 16:36:30','2018-5-5',default,'17:52:30','2021',default);
insert into tt13 values('9999-12-31','2021-6-23',default,'14:52:30','2020',default);
drop table if exists binary_type;
create table binary_type(
c_1 binary(3) comment '字段1',
c_2 varbinary(10) primary key,
c_3 tinyblob comment '字段3',
c_4 blob comment '字段4',
c_5 mediumblob comment '字段5',
c_6 longblob comment '字段6'
);
insert into binary_type values(1,10,null,null,null,null);
