90yangkang commented on issue #26076:
URL:
https://github.com/apache/shardingsphere/issues/26076#issuecomment-1578219469
**supplement**
**There are two databases db1 and db2, both of which have the same datatable
- table1.
db1.table1 execute command [show create table page_data_put] result:**
CREATE TABLE `page_data_put` (
`id` BIGINT ( 20 ) NOT NULL COMMENT '主键',
`page_data_version_id` BIGINT ( 20 ) DEFAULT NULL COMMENT '页面版本id',
`name` VARCHAR ( 50 ) NOT NULL COMMENT '配置名称',
`mark` VARCHAR ( 30 ) NOT NULL COMMENT '标识',
`cos_path` VARCHAR ( 255 ) NOT NULL COMMENT 'cos配置地址',
`create_by` VARCHAR ( 30 ) DEFAULT NULL COMMENT '创建者',
`create_time` datetime ( 6 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ( 6 )
COMMENT '创建时间',
`update_by` VARCHAR ( 30 ) DEFAULT NULL COMMENT '更新者',
`update_time` datetime ( 6 ) NOT NULL DEFAULT CURRENT_TIMESTAMP ( 6 )
ON UPDATE CURRENT_TIMESTAMP ( 6 ) COMMENT '更新时间',
`delete_flag` CHAR ( 1 ) DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
`business_source` VARCHAR ( 100 ) DEFAULT NULL COMMENT
'业务来源，商城cms：mall',
`scene_id` BIGINT ( 20 ) DEFAULT NULL COMMENT '投放场景id',
`page_put_path` VARCHAR ( 250 ) DEFAULT NULL COMMENT '页面投放地址',
`business_channel` VARCHAR ( 20 ) DEFAULT NULL COMMENT '业务渠道',
PRIMARY KEY ( `id` ) USING BTREE,
UNIQUE KEY `UN_page_data_put_mark` ( `mark` ) USING BTREE
) ENGINE = INNODB DEFAULT CHARSET = utf8mb4
**db2.table1 execute command [show create table page_data_put] result:**
CREATE TABLE `page_data_put` (
`id` bigint(20) NOT NULL COMMENT '主键',
`scene_id` bigint(20) DEFAULT NULL COMMENT '投放场景id',
`page_data_version_id` bigint(20) DEFAULT NULL COMMENT '投放使用的页面版本id',
`name` varchar(50) NOT NULL COMMENT '配置名称',
`mark` varchar(30) NOT NULL COMMENT '标识',
`cos_path` varchar(255) NOT NULL COMMENT 'cos配置地址',
`create_by` varchar(30) DEFAULT NULL COMMENT '创建者',
`create_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) COMMENT
'创建时间',
`update_by` varchar(30) DEFAULT NULL COMMENT '更新者',
`update_time` datetime(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE
CURRENT_TIMESTAMP(6) COMMENT '更新时间',
`delete_flag` char(1) DEFAULT NULL COMMENT '删除标志 true/false 删除/未删除',
`business_source` varchar(100) DEFAULT NULL COMMENT '业务来源，商城cms：mall',
`page_put_path` varchar(250) DEFAULT NULL COMMENT '页面投放地址',
`business_channel` varchar(20) DEFAULT NULL COMMENT '业务渠道',
PRIMARY KEY (`id`) USING BTREE,
UNIQUE KEY `UN_page_data_put_mark` (`mark`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
### The number of fields in both tables is the same
### But the order of the fields in the two tables is inconsistent
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
