799983050 commented on issue #2359: shardingproxy 4.0.0-RC2：insert error URL: https://github.com/apache/incubator-shardingsphere/issues/2359#issuecomment-490919630 @cherrylzhao not Sharding-rule have nothing to do with.Remove and report errors. insert into Add fields Successful implementation.You can try it out. CREATE TABLE `order_back_batch` ( `id` bigint(20) UNSIGNED NOT NULL DEFAULT 0 COMMENT '主键', `order_type` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '业务类型', `third_party_no` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '', `total_amount` decimal(18, 2) NOT NULL DEFAULT 0.00 COMMENT '', `total_count` int(11) NOT NULL DEFAULT 0 COMMENT '', `handling_time` int(11) NOT NULL DEFAULT 0 COMMENT '', `status_id` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 COMMENT '', `gmt_date` date NULL DEFAULT '0001-01-01' COMMENT '', `gmt_create` datetime(3) NOT NULL DEFAULT '0001-01-01 00:00:00.000' COMMENT '', `gmt_modified` datetime(0) NOT NULL DEFAULT CURRENT_TIMESTAMP(0) ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '', PRIMARY KEY (`id`) USING BTREE, INDEX `idx_order_type`(`order_type`) USING BTREE, INDEX `idx_third_party_no`(`third_party_no`) USING BTREE, INDEX `idx_status_id`(`status_id`) USING BTREE, INDEX `idx_gmt_create`(`gmt_create`) USING BTREE, INDEX `idx_gmt_date`(`gmt_date`) USING BTREE ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '' ROW_FORMAT = Dynamic;
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services
