为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
- 【TiDB 版本】: Release Version: v4.0.0-beta.2-200-gb54ac5b2e Git Commit Hash: b54ac5b2ec3bd1f5de37eb813d17de43cc500bf3
- 【问题描述】: 一、tidb兼容性问题: datetime/timestamp/text 类型的字段不允许设置默认值,否则会报错。以前(大约2年前)测试tidb2.X版本是可以直接导入不报错的。数据源版本信息 10.3.15-MariaDB
失败:
CREATE TABLE activity
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘’,
name
varchar(64) DEFAULT ‘’ COMMENT ‘’,
max_num
smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
status
tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
send_flag
tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
expire_date
timestamp NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘’,
create_time
timestamp NOT NULL DEFAULT current_timestamp() COMMENT ‘’,
update_time
timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT ‘’,
PRIMARY KEY (id
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6005 DEFAULT CHARSET=utf8 COMMENT=’’;
成功:
CREATE TABLE activity
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT ‘’,
name
varchar(64) DEFAULT ‘’ COMMENT ‘’,
max_num
smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
status
tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
send_flag
tinyint(1) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
expire_date
timestamp NOT NULL COMMENT ‘’,
create_time
timestamp NOT NULL DEFAULT current_timestamp() COMMENT ‘’,
update_time
timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT ‘’,
PRIMARY KEY (id
) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=6005 DEFAULT CHARSET=utf8 COMMENT=’’;
错误:
CREATE TABLE sdk_dispatcher_strategy
(
id
int(10) unsigned NOT NULL AUTO_INCREMENT,
biz_id
bigint(20) unsigned NOT NULL COMMENT ‘’,
sdk_id
int(10) unsigned NOT NULL COMMENT ‘’,
config
text NOT NULL DEFAULT ‘’ COMMENT ‘’,
rtc_sdk_type
tinyint(2) unsigned NOT NULL COMMENT ‘’,
state
tinyint(4) unsigned NOT NULL DEFAULT 1 COMMENT ‘’,
create_time
datetime NOT NULL DEFAULT current_timestamp() COMMENT ‘’,
update_time
datetime NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT ‘’,
PRIMARY KEY (id
),
UNIQUE KEY bsd_id
(biz_id
,sdk_id
)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT=’’;
错误:
CREATE TABLE sale_performance_goal
(
id
int(11) unsigned NOT NULL AUTO_INCREMENT,
month
int(6) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
goal
varchar(15) NOT NULL DEFAULT ‘0.00’ COMMENT ‘’,
operator
int(11) unsigned NOT NULL DEFAULT 0 COMMENT ‘’,
create_time
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘’,
update_time
datetime NOT NULL DEFAULT ‘0000-00-00 00:00:00’ COMMENT ‘’,
PRIMARY KEY (id
),
UNIQUE KEY unique_month
(month
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT=’’;