[GitHub] [incubator-shardingsphere] 799983050 commented on issue #2359: shardingproxy 4.0.0-RC2：insert error

[GitBox <gi...@apache.org>]

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:
users@infra.apache.org


With regards,
Apache Git Services