GitHub user eb-zsl deleted a comment on the discussion: get table meta
error:Value '4294967295' is outside of valid range for type java.lang.Integer
java.sql.SQLDataException: Value '4294967295' is outside of valid range for
type java.lang.Integer
我得表结果是：CREATE TABLE `cms_channel_record_detail` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`use_date` char(8) NOT NULL COMMENT '使用日期YYYYMMDD',
`package_unique_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci
NOT NULL COMMENT '套餐唯一id',
`package_id` varchar(32) DEFAULT NULL COMMENT '套餐ID',
`package_name` varchar(100) DEFAULT NULL COMMENT '套餐名称',
`name_tw` varchar(100) DEFAULT NULL COMMENT '繁体中文',
`name_en` varchar(200) DEFAULT NULL COMMENT '英文名称',
`imsi` varchar(30) NOT NULL COMMENT 'imsi',
`msisdn` varchar(30) NOT NULL COMMENT 'msisdn',
`iccid` varchar(30) NOT NULL COMMENT 'iccid',
`internet_type` varchar(1) NOT NULL COMMENT '上网方式 1:H，2:V ',
`himsi` varchar(30) DEFAULT NULL COMMENT 'v卡使用时绑定的imsi',
`flow_downlink` bigint(20) NOT NULL COMMENT '下行流量byte',
`flow_uplink` bigint(20) NOT NULL COMMENT '上行流量byte',
`flow_count` bigint(20) NOT NULL COMMENT '流量',
`mcc` varchar(50) DEFAULT NULL COMMENT '国家码',
`country_cn` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
COMMENT '国家-中文',
`country_tw` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
COMMENT '国家-繁体',
`country_en` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
COMMENT '国家-英文',
`plmnlist` varchar(10) DEFAULT NULL COMMENT 'MCC+MNC',
`TAPCODE` varchar(20) DEFAULT NULL COMMENT 'TAPCODE',
`APN` varchar(50) DEFAULT NULL COMMENT 'APN',
`package_status` varchar(1) DEFAULT NULL COMMENT '套餐状态',
`start_time` datetime NOT NULL COMMENT '开始时间',
`end_time` datetime NOT NULL COMMENT '结束时间',
`corp_id` varchar(32) NOT NULL COMMENT '厂商id',
`supplier_id` bigint(20) NOT NULL COMMENT '供应商id',
`supplier_name` varchar(30) NOT NULL COMMENT '供应商名称',
`operator_name` varchar(70) NOT NULL COMMENT '运营商名称',
`create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
`update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE
CURRENT_TIMESTAMP COMMENT '修改时间',
`flow_type` char(1) DEFAULT NULL COMMENT '流量类型\r\n1：高速流量\r\n2：限速流量\r\n',
`rg` varchar(10) NOT NULL DEFAULT '201' COMMENT '应用rg值\r\n默认201',
`is_use_common` varchar(1) DEFAULT NULL COMMENT
'定向流量是否已使用通用流量：\r\n1：是\r\nnull：否\r\n',
`net_type` varchar(1) DEFAULT NULL COMMENT
'网络类型:\r\n1：UTRAN\r\n2：GERAN\r\n3：WLAN \r\n4：GAN\r\n5：HSPA
Evolution\r\n6：EUTRAN \r\n2和4是2G网；3属于wifi网络:\r\n1和5是3G网\r\n6是4G网\r\n',
PRIMARY KEY (`id`,`use_date`) USING BTREE,
KEY `imsih` (`imsi`,`himsi`) USING BTREE,
KEY `package_unique_id` (`package_unique_id`) USING BTREE,
KEY `index_himsi` (`himsi`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=414 DEFAULT CHARSET=utf8
/*!50500 PARTITION BY RANGE COLUMNS(use_date)
(PARTITION p20210921 VALUES LESS THAN ('20210922') ENGINE = InnoDB,
PARTITION p20210922 VALUES LESS THAN ('20210923') ENGINE = InnoDB,
PARTITION p20210923 VALUES LESS THAN ('20210924') ENGINE = InnoDB,
PARTITION p20210924 VALUES LESS THAN ('20210925') ENGINE = InnoDB,
PARTITION pm VALUES LESS THAN (MAXVALUE) ENGINE = InnoDB) */
发生错误得场景是：我用seata做多数据源管理时，报错。seata版本是1.4.0
GitHub link:
https://github.com/apache/incubator-seata/discussions/7871#discussioncomment-15277717
----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
