wilsonfu88 commented on issue #5831:
URL: https://github.com/apache/seatunnel/issues/5831#issuecomment-1809624581
use seatunnel 2.3.1 can run success，it's a bug in 2.3.3？
DDL:
-- test_db2.book definition
CREATE TABLE `book` (
`id` int NOT NULL AUTO_INCREMENT,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
`author` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci
DEFAULT NULL,
`publishDate` datetime DEFAULT CURRENT_TIMESTAMP,
`sex` bit(1) DEFAULT NULL,
`total_page` int DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=158 DEFAULT CHARSET=utf8mb4
COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
tableData:
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVA 入门指南测试3','wilson.fu','2019-09-06 22:33:02',1,1),
('VUE入门','wilson.fu01',NULL,0,2),
('VUE入门','wilson.fu01',NULL,0,3),
('VUE入门','wilson.fu01','2019-09-06 22:52:26',0,4),
('VUE入门','wilson.fu01','2019-09-06 22:52:27',0,5),
('VUE入门','wilson.fu01','2019-09-06 23:01:46',0,6),
('VUE入门','wilson.fu01','2019-09-06 23:01:47',0,7),
('VUE入门','wilson.fu01','2019-09-06 23:01:52',0,8),
('VUE入门','wilson.fu01','2019-09-06 23:01:53',0,9),
('VUE入门','wilson.fu01','2019-09-06 23:01:54',0,10);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('VUE入门','wilson.fu01','2019-09-06 23:01:54',0,11),
('VUE入门','wilson.fu01','2019-09-06 23:01:54',0,12),
('VUE入门','wilson.fu01','2019-09-06 23:01:54',0,13),
('VUE入门','wilson.fu01','2019-09-06 23:18:07',0,14),
('VUE入门','wilson.fu01','2019-09-06 23:18:09',0,15),
('VUE入门','wilson.fu01','2019-09-06 23:18:10',0,16),
('VUE入门','wilson.fu01','2019-09-06 23:18:10',0,17),
('VUE入门','wilson.fu01','2019-09-06 23:18:10',0,18),
('VUE入门','wilson.fu01','2019-09-06 23:18:10',0,19),
('VUE入门','wilson.fu01','2019-09-06 23:18:10',0,20);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('VUE入门','wilson.fu01','2019-09-06 23:18:16',0,21),
('VUE入门','wilson.fu01','2019-09-07 14:25:43',0,22),
('VUE入门','wilson.fu01','2019-09-07 14:25:49',0,23),
('VUE入门','wilson.fu01','2019-09-07 14:26:13',0,24),
('VUE入门','wilson.fu01','2019-09-07 14:30:31',0,25),
('VUE入门','wilson.fu01','2019-09-07 14:30:38',0,26),
('VUE入门','wilson.fu01','2019-09-07 14:30:42',0,27),
('VUE入门','wilson.fu01','2019-09-07 14:30:42',0,28),
('VUE入门','wilson.fu01','2019-09-07 14:30:43',0,29),
('VUE入门','wilson.fu01','2019-09-07 14:30:43',0,30);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('VUE入门','wilson.fu01','2019-09-07 14:30:43',0,31),
('C#入门。','wilson.fu88','2019-09-07 15:16:09',0,32),
('C#入门。','wilson.fu88','2019-09-07 15:16:12',0,33),
('C#入门。','wilson.fu88','2019-09-07 15:20:23',0,34),
(NULL,NULL,'2019-09-07 22:51:26',0,35),
('c#','wilson.fu','2019-09-07 22:57:50',0,36),
('c#','wilson.fu','2019-09-07 22:57:59',0,37),
('c#','wilson.fu','2019-09-07 22:58:01',0,38),
('c#','wilson.fu','2019-09-07 22:58:06',0,39),
('c#','wilson.fu','2019-09-07 22:58:11',0,40);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:07:51',0,41),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:07:54',0,42),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:07:56',0,43),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:08:42',0,44),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:08:44',0,45),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:08:45',0,46),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:08:52',0,47),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:09:36',0,48),
('c#','wilson.fu','2019-09-07 23:12:39',0,49),
('Spring Boot 入门。','wilson.fu1982',NULL,0,50);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('Spring Boot 入门。','wilson.fu1982',NULL,0,51),
('Spring Boot 入门。','wilson.fu1982',NULL,0,52),
('Spring Boot 入门。','wilson.fu1982',NULL,0,53),
('Spring Boot 入门。','wilson.fu1982',NULL,0,54),
('Spring Boot 入门。','wilson.fu1982',NULL,0,55),
('Spring Boot 入门。','wilson.fu1982',NULL,0,56),
('Spring Boot 入门。','wilson.fu1982',NULL,0,57),
('Spring Boot 入门。','wilson.fu1982',NULL,0,58),
('Spring Boot 入门。','wilson.fu1982',NULL,0,59),
('Spring Boot 入门。','wilson.fu1982',NULL,0,60);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('Spring Boot 入门。','wilson.fu1982',NULL,0,61),
('Spring Boot 入门。','wilson.fu1982',NULL,0,62),
('Spring Boot 入门。','wilson.fu1982',NULL,0,63),
('Spring Boot 入门。','wilson.fu1982',NULL,0,64),
('Spring Boot 入门。','wilson.fu1982',NULL,0,65),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:12',0,66),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:13',0,67),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:13',0,68),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:13',0,69),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:14',0,70);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:14',0,71),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:14',0,72),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:14',0,73),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:14',0,74),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:15',0,75),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:15',0,76),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:15',0,77),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:15:15',0,78),
('C#入门。','wilson.fu88','2019-09-07 23:43:13',0,79),
('Spring Boot 入门。','wilson.fu1982','2019-09-07 23:43:20',0,80);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVA0078dc1e-d93f-4ac3-9993-6160264d63a7','WILSON.FU0908Sun Sep 08
19:00:28 CST 2019','2019-09-08 19:00:28',0,81),
('JAVA1d651323-45ec-448b-b590-591f48f66a75','WILSON.FU0908Sun Sep 08
19:02:44 CST 2019','2019-09-08 19:02:44',0,82),
('JAVA2078c661-1515-4a0a-8323-ae1eeb8691ff','WILSON.FU0908Sun Sep 08
19:02:48 CST 2019','2019-09-08 19:02:49',0,83),
('JAVA3b988be7-c6c7-4560-8efb-b248bc1b9d30','WILSON.FU0908Sun Sep 08
19:02:49 CST 2019','2019-09-08 19:02:50',0,84),
('JAVA9d6fe599-fef9-4ce9-90ca-3daa42561a89','WILSON.FU0908Sun Sep 08
19:02:51 CST 2019','2019-09-08 19:02:51',0,85),
('JAVAe3acc578-2242-4263-bbd0-8289760881ec','WILSON.FU0908Sun Sep 08
19:02:52 CST 2019','2019-09-08 19:02:52',0,86),
('JAVA3ed87c2a-c5e9-4db3-840c-209883bc24b3','WILSON.FU0908Sun Sep 08
19:02:53 CST 2019','2019-09-08 19:02:53',0,87),
('JAVA45ba371f-ce41-4915-9172-77899188831b','WILSON.FU0908Sun Sep 08
19:02:53 CST 2019','2019-09-08 19:02:54',0,88),
('JAVAf20d6940-10ad-491c-83cd-38fd873f651f','WILSON.FU0908Sun Sep 08
19:02:54 CST 2019','2019-09-08 19:02:55',0,89),
('JAVA53af9317-9890-4436-840a-a620669dba0b','WILSON.FU0908Sun Sep 08
19:02:54 CST 2019','2019-09-08 19:02:55',0,90);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVAe9b37003-303b-47eb-b3a6-509d1d3f9636','WILSON.FU0908Sun Sep 08
19:02:56 CST 2019','2019-09-08 19:02:57',0,91),
('JAVA0a392db1-5357-448c-ad11-4cbf4c44c224','WILSON.FU0908Sun Sep 08
19:03:30 CST 2019','2019-09-08 19:03:30',0,92),
('JAVAf961febe-4362-44c6-bbb3-871b12b23eb2','WILSON.FU0908Sun Sep 08
19:03:31 CST 2019','2019-09-08 19:03:31',0,93),
('JAVA7e19fa3a-9c95-44da-bf77-95a4e4b04b43','WILSON.FU0908Sun Sep 08
19:03:34 CST 2019','2019-09-08 19:03:34',0,94),
('JAVA6fa6384c-1a2c-4032-b456-bd7d992a22b0','WILSON.FU0908Sun Sep 08
19:03:37 CST 2019','2019-09-08 19:03:37',0,95),
('JAVA48ca6979-749b-488d-bd5d-f99402997ef4','WILSON.FU0908Sun Sep 08
19:03:38 CST 2019','2019-09-08 19:03:39',0,96),
('JAVA2b1b53f3-d752-4dd2-b890-24fe84071c13','WILSON.FU0908Sun Sep 08
19:03:39 CST 2019','2019-09-08 19:03:39',0,97),
('JAVA3a1b55e1-db10-4fcf-b180-498d21c01635','WILSON.FU0908Sun Sep 08
19:03:39 CST 2019','2019-09-08 19:03:40',0,98),
('JAVA5dbdcc40-81cd-405e-9cd1-31d449a25632','WILSON.FU0908Sun Sep 08
19:03:40 CST 2019','2019-09-08 19:03:40',0,99),
('JAVA690b4b18-ccc4-4111-96fa-e1f568883569','WILSON.FU0908Sun Sep 08
19:03:40 CST 2019','2019-09-08 19:03:40',0,100);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVAdcfcd67d-dd2c-4439-ab89-1f7128b58ce2','WILSON.FU0908Sun Sep 08
19:03:40 CST 2019','2019-09-08 19:03:41',0,101),
('JAVAf73622bd-fea6-412e-8f96-9070dc9e8b6a','WILSON.FU0908Sun Sep 08
19:03:41 CST 2019','2019-09-08 19:03:41',0,102),
('JAVAdbafce77-3391-4a48-8670-b7f819565c9a','WILSON.FU0908Sun Sep 08
19:03:45 CST 2019','2019-09-08 19:03:45',0,103),
('JAVAdd013c04-1dc2-4e16-b2a2-07dc2a969046','WILSON.FU0908Sun Sep 08
19:04:22 CST 2019','2019-09-08 19:04:23',0,104),
('JAVA694c760a-f4ba-44cf-aa7f-a144994924a5','WILSON.FU0908Sun Sep 08
19:04:22 CST 2019','2019-09-08 19:04:23',0,105),
('JAVA2e8d4c80-a003-4940-8c8d-0e810f5b3bfe','WILSON.FU0908Sun Sep 08
19:04:22 CST 2019','2019-09-08 19:04:23',0,106),
('JAVAb952405c-144a-40f2-a13b-29a8f562f651','WILSON.FU0908Sun Sep 08
19:04:23 CST 2019','2019-09-08 19:04:23',0,107),
('JAVAbd0480f9-0ffb-429b-b4ff-2c4444e60a33','WILSON.FU0908Sun Sep 08
19:04:23 CST 2019','2019-09-08 19:04:23',0,108),
('JAVA202a6000-1311-4df6-b129-8a915fdbdb53','WILSON.FU0908Sun Sep 08
19:04:23 CST 2019','2019-09-08 19:04:24',0,109),
('JAVA1d684bde-1936-4701-a48d-85c9f5b54ec8','WILSON.FU0908Sun Sep 08
19:04:23 CST 2019','2019-09-08 19:04:24',0,110);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVAc6823417-958d-4812-a928-2f9e1ddaadfb','WILSON.FU0908Sun Sep 08
19:04:23 CST 2019','2019-09-08 19:04:24',0,111),
('JAVAc16e615e-86bb-4ec6-85ef-9fc4f8bb3bab','WILSON.FU0908Sun Sep 08
19:04:24 CST 2019','2019-09-08 19:04:24',0,112),
('JAVA1e48f2bd-5362-48d6-b19c-de2017bfc155','WILSON.FU0908Sun Sep 08
19:04:24 CST 2019','2019-09-08 19:04:25',0,113),
('JAVAb664730c-3468-4d29-9bfc-914a400bbbe1','WILSON.FU0908Sun Sep 08
19:04:25 CST 2019','2019-09-08 19:04:26',0,114),
('JAVA0ae4a82f-b56f-4cb4-ae5a-56d8e9900fa4','WILSON.FU0908Sun Sep 08
19:04:26 CST 2019','2019-09-08 19:04:26',0,115),
('JAVA8a2dedfb-2abb-4376-845b-40be69c3cab4','WILSON.FU0908Sun Sep 08
19:04:54 CST 2019','2019-09-08 19:04:54',0,116),
('JAVA72d0eb10-7654-4ff2-9355-bfe0a3311fa0','WILSON.FU0908Sun Sep 08
19:04:54 CST 2019','2019-09-08 19:04:55',0,117),
('JAVAa58c96fd-cc74-404d-ad8d-31f30957b01f','WILSON.FU0908Sun Sep 08
19:04:55 CST 2019','2019-09-08 19:04:55',0,118),
('JAVA070f1629-e068-41ea-8303-a3675537f210','WILSON.FU0908Sun Sep 08
19:04:55 CST 2019','2019-09-08 19:04:55',0,119),
('JAVA5b3fe961-e8a2-4a3b-bea8-b05eeac8689c','WILSON.FU0908Sun Sep 08
19:04:55 CST 2019','2019-09-08 19:04:56',0,120);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVAa0e19952-ca87-4d21-8a80-3d34f2c9226e','WILSON.FU0908Sun Sep 08
19:04:55 CST 2019','2019-09-08 19:04:56',0,121),
('JAVAf799ecfc-c211-49a8-85ba-8c676b14492f','WILSON.FU0908Sun Sep 08
19:04:56 CST 2019','2019-09-08 19:04:56',0,122),
('JAVA8fbf80d8-ae57-4831-9585-e920a922a52e','WILSON.FU0908Sun Sep 08
19:04:56 CST 2019','2019-09-08 19:04:56',0,123),
('JAVAdd1c45fd-32cc-4c25-8146-e106c2c0d8a1','WILSON.FU0908Sun Sep 08
19:05:34 CST 2019','2019-09-08 19:05:35',0,124),
('JAVA21fe0d2c-fb78-40b4-aa66-c51758255823','WILSON.FU0908Sun Sep 08
19:05:36 CST 2019','2019-09-08 19:05:36',0,125),
('JAVAfa18b183-25e0-4d1c-aada-049ea210b794','WILSON.FU0908Sun Sep 08
19:05:37 CST 2019','2019-09-08 19:05:37',0,126),
('JAVAd13e517f-8db4-40df-8005-a4997845b4c9','WILSON.FU0908Sun Sep 08
19:05:37 CST 2019','2019-09-08 19:05:38',0,127),
('JAVA52893b13-6aa7-46fa-ae9f-759bc6d9f5b7','WILSON.FU0908Sun Sep 08
19:05:38 CST 2019','2019-09-08 19:05:38',0,128),
('JAVA063f9927-8734-4fad-96f3-38fecd02e01c','wilson.fu-0908Sun Sep 08
19:24:35 CST 2019','2019-09-08 19:24:36',0,129),
('JAVA48e6d5ba-cfdb-4fb5-9a22-1267b905a929','wilson.fu-0908Sun Sep 08
19:24:38 CST 2019','2019-09-08 19:24:38',0,130);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVA2cc46624-b490-4adb-a655-cd10ee3db092','wilson.fu-0908Sun Sep 08
19:24:38 CST 2019','2019-09-08 19:24:39',0,131),
('JAVA65a84c9e-b65d-41a9-a03a-9e855299d58e','wilson.fu-0908Sun Sep 08
19:24:39 CST 2019','2019-09-08 19:24:39',0,132),
('JAVA6e92bb16-875f-4ebf-907a-7af0d5ec7fb3','wilson.fu-0908Sun Sep 08
19:24:40 CST 2019','2019-09-08 19:24:40',0,133),
('JAVA94037d6f-6d4e-4fdb-8c3d-826a99100df2','wilson.fu-0908Sun Sep 08
19:24:40 CST 2019','2019-09-08 19:24:41',0,134),
('JAVA8d72c2d9-bfe5-49e7-899d-7b6d26db2b84','wilson.fu-0908Sun Sep 08
19:24:41 CST 2019','2019-09-08 19:24:41',0,135),
('JAVAa4ab0c4d-03d4-4f9a-af9f-285b716b0178','wilson.fu-0908Sun Sep 08
19:24:41 CST 2019','2019-09-08 19:24:42',0,136),
('JAVAc3d351b3-66b6-4cae-9003-bb8761ea8557','wilson.fu-0908Sun Sep 08
19:24:42 CST 2019','2019-09-08 19:24:42',0,137),
('JAVA7313d7d5-22bf-47fb-bba6-39bd482a9178','wilson.fu-0908Sun Sep 08
19:24:42 CST 2019','2019-09-08 19:24:43',0,138),
('JAVA307f40e1-13e7-4307-a8a2-d881bd959508','wilson.fu-0908Sun Sep 08
19:24:43 CST 2019','2019-09-08 19:24:43',0,139),
('JAVAe9c30ee0-4459-4582-8b99-f0362d5a4e1b','wilson.fu-0908Sun Sep 08
19:24:44 CST 2019','2019-09-08 19:24:44',0,140);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVA954eb90f-ce8f-465c-bae6-231deea428b4','wilson.fu-0908Sun Sep 08
22:27:18 CST 2019','2019-09-08 22:27:18',0,141),
('JAVA8bfdd54b-7b68-40b7-a46e-789d3968b4c6','wilson.fu-0908Sun Sep 08
22:27:20 CST 2019','2019-09-08 22:27:20',0,142),
('JAVA1a947afb-a4ae-45e6-bdd1-d89c04c47f9f','wilson.fu-0908Sun Sep 08
22:27:20 CST 2019','2019-09-08 22:27:21',0,143),
('JAVAd329187f-6bd9-4d5b-aa54-c1a550c74764','wilson.fu-0908Sun Sep 08
22:27:48 CST 2019','2019-09-08 22:27:48',0,144),
('JAVAd4e51f99-83d1-434c-a43c-62b118370c60','WILSON.FU0908Sun Sep 08
22:27:50 CST 2019','2019-09-08 22:27:51',0,145),
('JAVAc4c8797b-3dbd-46ab-a240-83f09c7809c4','WILSON.FU0908Sun Sep 08
22:34:47 CST 2019','2019-09-08 22:34:47',0,146),
('JAVAc549b6e2-5006-4e50-bee7-29c210179640','WILSON.FU0908Sun Sep 08
22:34:47 CST 2019','2019-09-08 22:34:47',0,147),
('JAVA3d174778-490a-4c33-951a-224e1df53920','WILSON.FU0908Sun Sep 08
22:34:48 CST 2019','2019-09-08 22:34:49',0,148),
('JAVAeeef825f-ea4d-4763-aa12-dd3a65fed837','WILSON.FU0908Sun Sep 08
22:34:49 CST 2019','2019-09-08 22:34:49',0,149),
('JAVA08e12602-a833-41ca-ae24-38948ccf95c2','WILSON.FU0908Sun Sep 08
22:34:49 CST 2019','2019-09-08 22:34:50',0,150);
INSERT INTO test_db2.book (name,author,publishDate,sex,total_page) VALUES
('JAVAaaeec543-f0ea-4d6e-826f-e6f15e7de5f6','WILSON.FU0908Sun Sep 08
22:34:50 CST 2019','2019-09-08 22:34:50',0,151),
('JAVA45bb7dda-7572-49b3-af7f-bac63b241017','WILSON.FU0908Sun Sep 08
22:34:50 CST 2019','2019-09-08 22:34:51',0,152),
('JAVAf2b24fd0-0b14-443d-ba08-70c9ec31c72e','WILSON.FU0908Sun Sep 08
22:34:51 CST 2019','2019-09-08 22:34:51',0,153),
('JAVAe6722dd2-c2f3-4121-8be9-19e34acbb1d0','WILSON.FU0908Sun Sep 08
22:34:51 CST 2019','2019-09-08 22:34:52',0,154),
('JAVA9394f35b-28ef-4721-acbc-2d11f5278be8','WILSON.FU0908Sun Sep 08
22:35:08 CST 2019','2019-09-08 22:35:09',0,155),
('JAVAfa5f33f7-8288-47e0-8451-16176dc82b41','wilson.fu-0908Sun Sep 08
23:45:01 CST 2019','2019-09-08 23:45:02',0,156),
('JAVAb3d88d55-4802-4ae3-9847-69b6056941d3','WILSON.FU0908Sun Sep 08
23:45:13 CST 2019','2019-09-08 23:45:13',0,157);
--
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]
