Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-14055

Assertion `page_rec_is_leaf(rec)' failed in lock_rec_validate_page

    XMLWordPrintable

    Details

      Description

      10.2 4c9d19ee657b8

      mysqld: /data/src/10.2/storage/innobase/lock/lock0lock.cc:6431: ulint lock_rec_validate_page(const buf_block_t*): Assertion `page_rec_is_leaf(rec)' failed.
      171012 20:31:40 [ERROR] mysqld got signal 6 ;
       
      #7  0x00007f78cd319ee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
      #8  0x0000555e05cc351d in lock_rec_validate_page (block=0x7f78c29ec5c0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6431
      #9  0x0000555e05cc3b74 in lock_rec_block_validate (space_id=4, page_no=3) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6582
      #10 0x0000555e05cc3dde in lock_validate () at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6635
      #11 0x0000555e05cc2232 in lock_print_info_all_transactions (file=0x555e08c1a4e0) at /data/src/10.2/storage/innobase/lock/lock0lock.cc:6115
      #12 0x0000555e05dea158 in srv_printf_innodb_monitor (file=0x555e08c1a4e0, nowait=0, trx_start_pos=0x7f78c015d4b0, trx_end=0x7f78c015d4b8) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:1304
      #13 0x0000555e05c537fa in innodb_show_status (hton=0x555e08bc4a70, thd=0x7f7870000b00, stat_print=0x555e0593a92c <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:16472
      #14 0x0000555e05c54268 in innobase_show_status (hton=0x555e08bc4a70, thd=0x7f7870000b00, stat_print=0x555e0593a92c <stat_print(THD*, char const*, size_t, char const*, size_t, char const*, size_t)>, stat_type=HA_ENGINE_STATUS) at /data/src/10.2/storage/innobase/handler/ha_innodb.cc:16886
      #15 0x0000555e0593acc6 in ha_show_status (thd=0x7f7870000b00, db_type=0x555e08bc4a70, stat=HA_ENGINE_STATUS) at /data/src/10.2/sql/handler.cc:5621
      #16 0x0000555e056beff6 in mysql_execute_command (thd=0x7f7870000b00) at /data/src/10.2/sql/sql_parse.cc:3701
      #17 0x0000555e056cbf42 in mysql_parse (thd=0x7f7870000b00, rawbuf=0x7f7870012438 "SHOW ENGINE INNODB STATUS", length=25, parser_state=0x7f78c015e200, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:7868
      #18 0x0000555e056b9eee in dispatch_command (command=COM_QUERY, thd=0x7f7870000b00, packet=0x7f7870084ec1 "", packet_length=25, is_com_multi=false, is_next_command=false) at /data/src/10.2/sql/sql_parse.cc:1812
      #19 0x0000555e056b8864 in do_command (thd=0x7f7870000b00) at /data/src/10.2/sql/sql_parse.cc:1360
      #20 0x0000555e05805be7 in do_handle_one_connection (connect=0x555e090527d0) at /data/src/10.2/sql/sql_connect.cc:1354
      #21 0x0000555e05805974 in handle_one_connection (arg=0x555e090527d0) at /data/src/10.2/sql/sql_connect.cc:1260
      #22 0x0000555e05c22552 in pfs_spawn_thread (arg=0x555e090f4e10) at /data/src/10.2/storage/perfschema/pfs.cc:1862
      #23 0x00007f78cf25e494 in start_thread (arg=0x7f78c015f700) at pthread_create.c:333
      #24 0x00007f78cd3d693f in clone () from /lib/x86_64-linux-gnu/libc.so.6
      

      Test case

      --source include/have_innodb.inc
       
      CREATE TABLE t1 (
       f1 TIMESTAMP(3) NULL DEFAULT 0,
       f2 DATETIME(3),
       f3 DATETIME(3),
       f4 TIMESTAMP(3) NULL DEFAULT 0,
       f5 DATETIME(6),
       pk TIMESTAMP(6) PRIMARY KEY,
       f6 DATETIME(6)
      ) ENGINE=InnoDB;
       
      START TRANSACTION;
      INSERT IGNORE INTO t1 VALUES
      ('20050214173829.020', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1990-11-05 16:00:13.059445', '0000-00-00 00:00:00', '2017-10-12 16:12:01.839914', '0000-00-00 00:00:00.000000'),
      ('2013-09-14 12:41:49.009', '0000-00-00 00:00:00', '20120228152148.000019', '19840124231603.001227', '19950913163538.029452', '2017-10-12 16:12:02.839914', '0000-00-00 00:00:00.000000'),
      ('20000305095241.016', '20340313052450.002304', '1981-11-16 22:19:06.056504', '1995-10-22 22:32:22.055162', '0000-00-00 00:00:00', '2017-10-12 16:12:03.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '2019-04-14 15:06:55.048370', '0000-00-00 00:00:00', '1997-06-11 23:26:17.005193', '1983-12-05 14:45:27.002809', '2017-10-12 16:12:04.839914', '0000-00-00 00:00:00.000000'),
      ('1990-10-06 10:52:58.041', '1998-08-16 13:35:17.012201', '2003-11-01 04:06:50.019319', '20150717154857.026110', '2024-09-11 19:00:00.058590', '2017-10-12 16:12:05.839914', '0000-00-00 00:00:00.000000'),
      ('1985-02-28 05:05:27.049', '0000-00-00 00:00:00', '20240613053647.007035', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:06.839914', '0000-00-00 00:00:00.000000'),
      ('19711219224945.020', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:07.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '19841112062441.010971', '20170603134408.054602', '1987-07-24 05:15:43.017893', '0000-00-00 00:00:00', '2017-10-12 16:12:08.839914', '0000-00-00 00:00:00.000000'),
      ('20170313194100.009', '20340912053310.063264', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2027-12-15 18:29:28.042938', '2017-10-12 16:12:21.839914', '0000-00-00 00:00:00.000000'),
      ('20210823210551.006', '19810825112951.027109', '20000626015208.001729', '20230417084909.063112', '0000-00-00 00:00:00', '2017-10-12 16:12:22.839914', '0000-00-00 00:00:00.000000'),
      ('20290914041302.024', '19710211172754.038014', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2016-10-04 11:20:03.029165', '2017-10-12 16:12:23.839914', '0000-00-00 00:00:00.000000'),
      ('20250310233307.008', '2024-05-01 01:12:38.004163', '20210503132259.003959', '20080826153257.065111', '0000-00-00 00:00:00', '2017-10-12 16:12:24.839914', '0000-00-00 00:00:00.000000'),
      ('1991-06-04 19:54:00.014', '2035-08-04 08:22:17.043484', '19770817022443.025015', '19910102084219.056321', '2018-09-07 13:21:22.062898', '2017-10-12 16:12:25.839914', '0000-00-00 00:00:00.000000'),
      ('19821125041751.005', '20111013075252.024357', '2010-12-27 03:01:17.051583', '1982-11-21 09:03:38.046175', '0000-00-00 00:00:00', '2017-10-12 16:12:26.839914', '0000-00-00 00:00:00.000000'),
      ('1989-12-10 15:47:07.055', '20160826231534.047676', '19980326143950.015592', '2012-11-16 03:39:35.009778', '19961216170420.025696', '2017-10-12 16:12:27.839914', '0000-00-00 00:00:00.000000'),
      ('20250117160509.022', '2022-09-24 04:03:45.061078', '2035-01-17 23:52:08.002274', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:28.839914', '0000-00-00 00:00:00.000000'),
      ('2011-11-07 14:24:13.030', '20200506013652.028753', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:29.839914', '0000-00-00 00:00:00.000000'),
      ('20180126113035.033', '0000-00-00 00:00:00', '20120401053225.030583', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:30.839914', '0000-00-00 00:00:00.000000'),
      ('2003-05-28 02:28:39.061', '0000-00-00 00:00:00', '19780316092749.064704', '2020-03-12 06:34:03.031361', '0000-00-00 00:00:00', '2017-10-12 16:12:31.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20210920092700.052461', '1976-07-22 03:19:32.034523', '2017-10-12 16:12:32.839914', '0000-00-00 00:00:00.000000'),
      ('1996-07-14 19:29:13.051', '2031-04-21 21:59:42.021116', '20060104051029.011527', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:33.839914', '0000-00-00 00:00:00.000000'),
      ('20100622165345.055', '20281001004924.060527', '1986-09-03 14:46:32.006758', '1999-09-13 10:25:54.023646', '20150827203921.048249', '2017-10-12 16:12:34.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '20090121164720.049950', '19711002085304.018470', '19770628022748.044216', '20320706190653.019127', '2017-10-12 16:12:35.839914', '0000-00-00 00:00:00.000000'),
      ('1982-01-27 21:50:47.056', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:12:36.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '2034-08-01 04:59:51.000949', '2013-05-10 22:42:22.026267', '20220722023441.048593', '0000-00-00 00:00:00', '2017-10-12 16:12:37.839914', '0000-00-00 00:00:00.000000'),
      ('19830414161604.041', '19810108180538.030125', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20190617002313.003266', '2017-10-12 16:12:38.839914', '0000-00-00 00:00:00.000000'),
      ('2015-04-10 15:29:44.002', '20300212034711.041297', '0000-00-00 00:00:00', '1985-07-05 17:09:30.000656', '2004-02-14 23:20:00.058580', '2017-10-12 16:12:39.839914', '0000-00-00 00:00:00.000000'),
      ('2005-01-18 15:19:18.040', '20060403204102.047645', '1996-06-07 16:27:47.013922', '1988-12-04 19:48:48.028996', '1981-12-02 17:48:48.013773', '2017-10-12 16:12:40.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '2030-04-11 03:06:41.041620', '20121202020816.015099', '20290615071514.015753', '2017-10-12 16:12:41.839914', '0000-00-00 00:00:00.000000'),
      ('1990-03-23 01:29:14.054', '19990621102501.033424', '20120306074527.047811', '19721215013911.052955', '1980-12-03 00:11:38.042239', '2017-10-12 16:12:42.839914', '0000-00-00 00:00:00.000000'),
      ('19840513183813.022', '19731020222708.022923', '2021-02-27 19:30:19.057039', '2009-11-10 09:09:58.040749', '19940322174250.024863', '2017-10-12 16:12:43.839914', '0000-00-00 00:00:00.000000'),
      ('20201204011347.003', '0000-00-00 00:00:00', '20350228103022.064077', '1999-07-11 07:37:09.019447', '2015-03-08 07:28:57.000971', '2017-10-12 16:12:44.839914', '0000-00-00 00:00:00.000000'),
      ('20190726052002.041', '1989-06-16 23:59:10.018179', '2008-11-27 03:28:58.047731', '0000-00-00 00:00:00', '2003-08-27 06:19:22.028917', '2017-10-12 16:12:45.839914', '0000-00-00 00:00:00.000000'),
      ('20140825224100.057', '20350208224244.012856', '1986-08-05 21:06:58.051957', '0000-00-00 00:00:00', '2000-02-17 10:50:07.032265', '2017-10-12 16:12:46.839914', '0000-00-00 00:00:00.000000'),
      ('1989-07-15 21:50:32.055', '0000-00-00 00:00:00', '1977-04-13 07:55:45.049853', '0000-00-00 00:00:00', '20101110144113.015434', '2017-10-12 16:12:47.839914', '0000-00-00 00:00:00.000000'),
      ('2027-08-07 18:15:30.001', '0000-00-00 00:00:00', '2024-07-07 15:05:25.025292', '0000-00-00 00:00:00', '20311222115744.064260', '2017-10-12 16:12:48.839914', '0000-00-00 00:00:00.000000'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1972-08-07 09:05:10.041000', '19990424200736.043801', '2017-10-12 16:12:49.839914', '0000-00-00 00:00:00.000000'),
      ('2018-05-15 21:50:31.044', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1992-12-11 03:16:51.050433', '20240904001336.054001', '2017-10-12 16:12:50.839914', '0000-00-00 00:00:00.000000')
      ;
      INSERT IGNORE INTO t1 VALUES
      ('20191027185337.058466', '0000-00-00 00:00:00', '1983-01-21 21:53:08.053210', '2032-02-28 04:17:33.061683', '2030-04-22 21:42:16.027980', '2017-10-12 16:17:01.848166', '2024-10-18 00:13:32.010327'),
      ('0000-00-00 00:00:00', '2025-07-15 10:07:28.012246', '1977-12-18 03:18:25.018723', '2029-03-10 03:19:28.045739', '0000-00-00 00:00:00', '2017-10-12 16:17:02.848166', '2020-12-12 00:29:00.034661'),
      ('1979-03-22 03:14:20.048600', '20270206013025.033468', '1982-02-13 00:40:15.022539', '2027-01-27 23:23:03.028180', '0000-00-00 00:00:00', '2017-10-12 16:17:03.848166', '2000-02-22 05:47:01.002689'),
      ('19720607170039.036739', '0000-00-00 00:00:00', '2031-01-18 05:34:05.035101', '19960414022341.038519', '20220221153016.031742', '2017-10-12 16:17:04.848166', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '1980-02-02 17:28:43.003685', '20081021130013.061993', '0000-00-00 00:00:00', '2017-10-12 16:17:05.848166', '2023-01-08 22:34:23.052699'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2001-02-11 10:12:07.014533', '0000-00-00 00:00:00', '2017-10-12 16:17:06.848166', '2006-12-13 02:11:38.035740'),
      ('1981-01-28 07:22:15.052921', '2026-12-04 09:35:37.014872', '1973-02-06 21:16:14.012969', '2018-01-19 14:48:49.029809', '19861128012346.056721', '2017-10-12 16:17:07.848166', '20160624161859.039231'),
      ('0000-00-00 00:00:00', '20340624011940.062316', '20160128014705.029047', '19920320110028.027173', '19981228161739.038182', '2017-10-12 16:17:08.848166', '20320203095210.030817'),
      ('2033-04-10 21:33:43.063222', '1981-08-20 23:55:45.049213', '20210128143503.040646', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:17:09.848166', '20130517230025.003209'),
      ('20010208160048.032998', '0000-00-00 00:00:00', '2012-02-02 16:53:37.036741', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:17:10.848166', '2010-06-01 23:58:59.017811'),
      ('19870414061715.031284', '0000-00-00 00:00:00', '20191117042020.036656', '1980-05-27 07:50:04.058531', '0000-00-00 00:00:00', '2017-10-12 16:17:11.848166', '19990416015353.059102'),
      ('1998-05-22 16:46:02.010228', '20131219030606.044663', '20191022131201.029055', '1983-10-26 19:42:33.056378', '0000-00-00 00:00:00', '2017-10-12 16:17:12.848166', '2001-06-26 16:08:55.012614'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '20071205132250.037210', '19820107112445.056593', '1991-04-06 08:43:19.063854', '2017-10-12 16:17:13.848166', '19810622090322.038230'),
      ('2013-01-23 06:32:50.007849', '2004-08-01 06:22:32.043322', '19990818084125.046553', '0000-00-00 00:00:00', '2010-04-22 23:13:07.061908', '2017-10-12 16:17:14.848166', '20080103105809.005577'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20330119082051.029448', '19870108041422.055064', '2017-10-12 16:17:15.848166', '1972-12-23 15:24:11.031617'),
      ('0000-00-00 00:00:00', '2033-05-21 01:10:06.049240', '2034-05-20 14:06:40.012191', '19940318150113.018957', '0000-00-00 00:00:00', '2017-10-12 16:17:16.848166', '20311127051528.006405'),
      ('2023-09-18 07:03:06.040255', '0000-00-00 00:00:00', '19971009153927.058303', '2020-06-25 14:45:48.040377', '19861112040247.039668', '2017-10-12 16:17:17.848166', '0000-00-00 00:00:00'),
      ('19840121115746.001076', '1980-11-20 00:53:42.061811', '20220304183614.044448', '2015-06-10 07:23:39.053243', '0000-00-00 00:00:00', '2017-10-12 16:17:18.848166', '20240619181255.055102'),
      ('20241106011156.053220', '1984-08-12 14:05:14.002718', '0000-00-00 00:00:00', '1999-12-20 10:21:46.010004', '19920411074859.060928', '2017-10-12 16:17:19.848166', '1985-08-25 21:47:03.062803'),
      ('0000-00-00 00:00:00', '2006-05-02 22:15:29.050785', '19840624211914.005229', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:17:20.848166', '0000-00-00 00:00:00'),
      ('20210923191628.027922', '1981-08-05 20:24:02.016832', '2017-09-17 17:25:12.016483', '20060611030633.030954', '1996-06-06 02:47:23.037247', '2017-10-12 16:17:21.848166', '2009-08-23 23:21:05.021887'),
      ('1981-02-05 04:41:11.009347', '20271227161417.016731', '20180403120613.000270', '2012-04-06 18:05:35.055773', '2028-08-21 18:54:51.021054', '2017-10-12 16:17:22.848166', '2010-06-05 04:43:08.053218'),
      ('1998-10-08 18:32:09.018097', '0000-00-00 00:00:00', '1981-02-02 05:55:26.051911', '1978-03-09 03:47:12.033312', '2031-07-09 11:14:05.042405', '2017-10-12 16:17:23.848166', '20270201150318.016609'),
      ('0000-00-00 00:00:00', '20150326181342.049242', '20130208041308.049060', '1978-05-27 21:58:08.021378', '0000-00-00 00:00:00', '2017-10-12 16:17:24.848166', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '19820404165047.043535', '19800927054756.001497', '2010-02-26 07:39:33.025550', '19920314042539.015088', '2017-10-12 16:17:25.848166', '2025-07-08 00:16:25.018840'),
      ('0000-00-00 00:00:00', '19960119063637.024091', '19820913113440.059658', '2012-09-09 09:04:16.040401', '1980-06-27 02:37:27.031388', '2017-10-12 16:17:26.848166', '20251226103348.024843'),
      ('19810504195622.003385', '19941207174523.060599', '2001-12-11 21:33:06.054672', '1989-08-27 18:03:50.040259', '1985-02-09 12:54:19.036813', '2017-10-12 16:17:27.848166', '19771022213929.050845'),
      ('0000-00-00 00:00:00', '20170104065359.052617', '1998-10-16 01:00:19.016771', '2028-12-02 02:39:48.049427', '19930414035855.026759', '2017-10-12 16:17:28.848166', '20300816080718.014150'),
      ('0000-00-00 00:00:00', '1990-08-22 21:03:27.019039', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20241108090111.060266', '2017-10-12 16:17:29.848166', '2027-04-02 18:09:47.012321'),
      ('19940502170337.043304', '19830303051641.063486', '2027-10-23 05:38:04.014360', '20171207231751.017892', '1975-10-01 19:58:55.058824', '2017-10-12 16:17:30.848166', '1988-11-15 14:40:12.052002'),
      ('1988-01-26 00:50:19.032583', '0000-00-00 00:00:00', '2007-08-16 01:57:53.018135', '2013-08-07 03:06:38.009676', '19921018060028.014229', '2017-10-12 16:17:31.848166', '0000-00-00 00:00:00'),
      ('19710626191216.012496', '1974-02-20 15:36:04.021512', '2024-10-05 23:54:23.034388', '20010309050036.014440', '2031-05-16 08:47:10.017840', '2017-10-12 16:17:32.848166', '20041005203701.037711'),
      ('20050220052821.036640', '2014-03-13 16:34:35.036537', '2020-07-28 03:24:41.003684', '1974-01-17 01:08:54.053286', '2017-09-14 16:16:16.055993', '2017-10-12 16:17:33.848166', '0000-00-00 00:00:00'),
      ('19920926062755.043867', '2025-08-24 23:01:38.042023', '1977-04-21 13:00:46.030218', '2016-07-18 22:00:47.015060', '1983-11-03 23:43:49.056750', '2017-10-12 16:17:34.848166', '0000-00-00 00:00:00'),
      ('1976-05-12 16:40:52.042972', '0000-00-00 00:00:00', '19920407075523.049329', '20100221021724.039907', '20170821084528.034509', '2017-10-12 16:17:35.848166', '20150321234409.040735'),
      ('0000-00-00 00:00:00', '19761001125751.006013', '0000-00-00 00:00:00', '2009-10-21 02:04:11.010882', '19950207103603.046948', '2017-10-12 16:17:36.848166', '0000-00-00 00:00:00'),
      ('2000-12-10 15:52:53.018418', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1992-12-16 12:06:41.035806', '0000-00-00 00:00:00', '2017-10-12 16:17:37.848166', '19841116083450.061652'),
      ('0000-00-00 00:00:00', '1975-06-13 22:28:22.060058', '2002-03-03 15:51:22.060949', '19760316184745.061111', '19930406234044.022233', '2017-10-12 16:17:38.848166', '0000-00-00 00:00:00'),
      ('20130216051610.037095', '0000-00-00 00:00:00', '2017-12-04 17:31:51.016199', '20180406030138.043432', '0000-00-00 00:00:00', '2017-10-12 16:17:39.848166', '1989-04-26 11:48:29.051317'),
      ('19800906101948.010527', '20340515125125.018591', '0000-00-00 00:00:00', '19810916002057.011157', '2033-05-09 01:17:46.048362', '2017-10-12 16:17:40.848166', '0000-00-00 00:00:00'),
      ('1975-03-18 07:39:26.036784', '2002-03-18 02:25:30.052351', '20060214182043.056522', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 16:17:41.848166', '1987-08-26 00:48:36.048842'),
      ('0000-00-00 00:00:00', '20090623175000.056419', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2028-06-06 05:47:33.052552', '2017-10-12 16:17:42.848166', '1974-02-05 01:39:02.031477'),
      ('2009-08-22 06:42:31.059621', '19841111043236.053849', '20180507200811.041672', '2017-02-12 15:32:38.017633', '0000-00-00 00:00:00', '2017-10-12 16:17:43.848166', '2021-04-14 09:56:05.024505'),
      ('20301108010155.057241', '19930619101555.034102', '0000-00-00 00:00:00', '1975-04-18 12:32:15.053613', '2025-08-06 08:15:31.057720', '2017-10-12 16:17:44.848166', '19850719040317.039948'),
      ('1981-09-16 17:09:11.021125', '1985-05-03 13:38:56.060474', '2010-02-13 21:57:31.044408', '0000-00-00 00:00:00', '2027-08-27 03:10:24.061823', '2017-10-12 16:17:45.848166', '0000-00-00 00:00:00'),
      ('2018-11-10 01:29:41.008151', '2033-01-08 06:05:42.001938', '2016-06-18 16:53:23.000342', '2015-03-14 05:50:47.057374', '1994-10-22 09:43:30.058013', '2017-10-12 16:17:46.848166', '20290220095834.029248'),
      ('0000-00-00 00:00:00', '19770919005426.058334', '20231214184444.064859', '19860803150824.056945', '2024-07-15 05:23:22.032226', '2017-10-12 16:17:47.848166', '19810707000143.020934'),
      ('19930823083710.057998', '19911017094115.048643', '1978-08-09 02:56:02.051781', '19980819232541.063693', '20040722084326.022893', '2017-10-12 16:17:48.848166', '20200628093904.036172'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '2004-05-19 14:44:07.028574', '0000-00-00 00:00:00', '20220617041347.022344', '2017-10-12 16:17:49.848166', '1999-09-16 15:45:58.049936'),
      ('0000-00-00 00:00:00', '19780624131807.057182', '19860905020631.013251', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:05:52.501417', '2011-01-26 18:45:31.039918'),
      ('2034-04-16 03:28:23.043348', '20290427073756.018515', '0000-00-00 00:00:00', '19780918172629.060353', '20281106041058.047690', '2017-10-12 17:05:53.501417', '0000-00-00 00:00:00'),
      ('19851104233104.010241', '2022-10-21 08:59:33.008572', '19801007095441.026741', '2002-11-17 06:34:19.015597', '0000-00-00 00:00:00', '2017-10-12 17:05:54.501417', '0000-00-00 00:00:00'),
      ('1993-04-14 12:09:17.048789', '2012-05-04 03:41:00.037133', '20140118121916.056970', '19800426032651.025450', '19890223160451.062177', '2017-10-12 17:05:55.501417', '20231115210909.031228'),
      ('0000-00-00 00:00:00', '19710505151647.013498', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20350612233116.050912', '2017-10-12 17:05:56.501417', '19880213103516.010868'),
      ('1997-09-17 03:20:20.032477', '2033-01-10 09:47:53.014061', '2028-10-11 14:42:29.062520', '0000-00-00 00:00:00', '2004-02-04 16:27:32.036710', '0000-00-00 00:00:00.000000', '1971-09-17 13:33:59.059590'),
      ('2004-08-16 02:46:01.045459', '1972-07-16 17:29:19.043597', '0000-00-00 00:00:00', '1998-12-05 20:02:54.002438', '20130604042944.043066', '0000-00-00 00:00:00.000000', '20010111092908.064767'),
      ('0000-00-00 00:00:00', '20260318001649.029585', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2009-07-10 13:03:50.013155', '2017-10-12 17:06:01.501417', '20340214120721.062016');
       
      INSERT IGNORE INTO t1 VALUES
      ('20120108233709.041868', '2007-09-13 22:16:30.013335', '2031-04-07 21:30:31.049673', '20090414192218.028644', '20270615135944.038784', '2017-10-12 17:06:02.508762', '2003-12-14 01:23:43.023822'),
      ('19790501202514.041495', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20111010083152.044462', '0000-00-00 00:00:00', '2017-10-12 17:06:03.508762', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '20220423212500.019109', '0000-00-00 00:00:00', '1982-01-17 15:43:16.019057', '20020321144236.024844', '2017-10-12 17:06:04.508762', '1994-04-06 23:01:58.036370'),
      ('2002-08-05 17:28:27.036694', '19841124124015.012865', '0000-00-00 00:00:00', '20320905030500.019547', '2008-04-01 08:25:09.003809', '2017-10-12 17:06:05.508762', '2032-07-10 13:48:06.004749'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '19770304024232.045183', '20100201003912.014070', '2018-06-23 23:17:41.000896', '2017-10-12 17:06:06.508762', '1979-09-07 18:55:41.035040'),
      ('19750302030031.006224', '0000-00-00 00:00:00', '2032-02-18 17:48:05.039114', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:07.508762', '19850203050909.042392'),
      ('0000-00-00 00:00:00', '20160202095155.063621', '0000-00-00 00:00:00', '1997-01-01 16:49:56.034918', '0000-00-00 00:00:00', '2017-10-12 17:06:08.508762', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '20000411220618.061413', '1986-02-08 08:47:32.034162', '20261024142259.032701', '20241222033507.019767', '2017-10-12 17:06:09.508762', '0000-00-00 00:00:00'),
      ('19750219121821.033689', '0000-00-00 00:00:00', '20020604071907.045669', '19880508043339.040082', '0000-00-00 00:00:00', '2017-10-12 17:06:10.508762', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '1998-02-24 02:26:41.037566', '20050320060033.003711', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:11.508762', '2014-05-15 04:54:52.041869'),
      ('1989-06-20 04:15:52.034284', '19730603160735.015223', '0000-00-00 00:00:00', '1982-03-21 21:21:55.006408', '20260920050225.036333', '2017-10-12 17:06:12.508762', '20130311131037.029158'),
      ('0000-00-00 00:00:00', '1973-09-05 12:20:18.056845', '2013-06-09 00:44:13.008825', '19820921052825.052771', '19970825174601.043386', '2017-10-12 17:06:13.508762', '1975-07-22 13:29:41.050182'),
      ('19780612150421.016228', '2008-04-09 17:47:57.031309', '0000-00-00 00:00:00', '19861217063541.007142', '20220825141733.056666', '2017-10-12 17:06:14.508762', '20121108204559.012605'),
      ('1976-09-07 17:04:13.031935', '1989-08-10 05:13:27.009032', '2015-10-16 18:53:15.005494', '20210721235711.016419', '2017-01-17 22:44:56.056157', '2017-10-12 17:06:15.508762', '2012-08-19 16:11:51.039277'),
      ('0000-00-00 00:00:00', '19890810121945.063334', '20120306211055.030469', '0000-00-00 00:00:00', '20141228171401.040662', '2017-10-12 17:06:16.508762', '1977-03-14 13:52:45.047730'),
      ('2031-12-04 17:23:12.016368', '19731218125051.045327', '2013-04-20 20:17:28.053636', '20070124172346.060925', '1995-10-28 18:08:15.000801', '2017-10-12 17:06:17.508762', '1981-02-09 20:05:47.050315'),
      ('1982-12-27 22:55:44.033748', '19760521003753.063367', '19890315093244.057899', '0000-00-00 00:00:00', '19870919220550.044065', '2017-10-12 17:06:18.508762', '1979-06-12 09:45:41.027414'),
      ('2009-03-03 13:05:46.049701', '0000-00-00 00:00:00', '1975-11-24 14:07:54.053138', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:19.508762', '20190511083036.037456'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '20270904082709.064608', '0000-00-00 00:00:00', '20191008124652.028261', '2017-10-12 17:06:20.508762', '2011-06-05 07:57:24.032676'),
      ('1972-06-03 10:10:04.050764', '19750704000007.030633', '19750419025605.003554', '19830504022634.002801', '1991-06-08 01:50:22.007085', '2017-10-12 17:06:21.508762', '19970615010436.039617'),
      ('1989-02-26 13:57:28.029620', '1995-05-14 13:50:10.026080', '2006-02-12 20:59:38.042876', '0000-00-00 00:00:00', '19760103072419.025702', '2017-10-12 17:06:22.508762', '20080812124243.044147'),
      ('2032-08-09 04:42:40.014898', '1991-12-15 07:50:24.057976', '0000-00-00 00:00:00', '19901221183411.062307', '19820310032437.018224', '2017-10-12 17:06:23.508762', '2004-12-10 16:42:48.058716'),
      ('20060903162536.034250', '19970905045038.008693', '20020126030252.036848', '20241024130515.032101', '0000-00-00 00:00:00', '2017-10-12 17:06:24.508762', '2020-08-03 08:55:22.049840'),
      ('20300326164200.054023', '1972-12-03 10:34:08.029869', '19890906014025.050357', '1987-03-03 12:43:39.030444', '0000-00-00 00:00:00', '2017-10-12 17:06:25.508762', '19730928123938.007897'),
      ('20120507130925.061618', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20190124063246.043456', '2010-07-01 21:15:05.026185', '2017-10-12 17:06:26.508762', '1987-06-03 13:52:02.009910'),
      ('1980-03-11 10:09:08.062118', '19890217082544.052944', '2000-07-06 11:37:58.018434', '20010403061131.024099', '2030-10-12 12:38:03.053042', '2017-10-12 17:06:27.508762', '2026-01-19 11:45:14.049734'),
      ('1980-01-07 21:03:02.053901', '19860819235309.031311', '19910306115605.056809', '20241021153631.063187', '19890925050726.007835', '2017-10-12 17:06:28.508762', '0000-00-00 00:00:00'),
      ('1991-04-26 18:02:17.063979', '0000-00-00 00:00:00', '20030817190248.033428', '2016-04-16 08:30:38.064490', '2015-06-01 14:11:48.011895', '2017-10-12 17:06:29.508762', '2012-01-03 20:21:39.050048'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '1979-05-26 01:21:32.027498', '20110328124729.004293', '2010-02-15 09:14:18.019125', '2017-10-12 17:06:30.508762', '2021-06-24 10:25:04.012876'),
      ('1981-07-16 14:23:19.006198', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:31.508762', '1981-03-09 00:06:33.060083'),
      ('19710208055718.010285', '20160204165416.021547', '0000-00-00 00:00:00', '1987-07-03 00:00:25.020115', '19790116203654.058347', '2017-10-12 17:06:32.508762', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '20130908080003.008451', '20080506065007.019001', '0000-00-00 00:00:00', '19980607170051.023511', '2017-10-12 17:06:33.508762', '2005-09-13 12:17:30.005447'),
      ('0000-00-00 00:00:00', '19950725055147.042788', '0000-00-00 00:00:00', '1988-12-02 06:46:08.046904', '0000-00-00 00:00:00', '2017-10-12 17:06:34.508762', '20190711121219.057627'),
      ('20280724060807.046612', '2002-04-26 11:33:14.000707', '2020-05-17 15:13:47.005218', '1972-11-04 20:05:47.060834', '1988-05-15 21:21:40.032173', '2017-10-12 17:06:35.508762', '20070422205146.046885'),
      ('2034-06-16 21:40:17.034595', '0000-00-00 00:00:00', '20100702081549.014303', '20130401105657.017597', '20210410062921.018744', '2017-10-12 17:06:36.508762', '19780203082723.037924'),
      ('1981-04-23 19:42:32.008306', '19960213202442.000041', '1996-12-16 06:44:14.010086', '1993-02-01 20:44:51.038753', '0000-00-00 00:00:00', '2017-10-12 17:06:37.508762', '2008-01-20 09:07:52.005534'),
      ('1979-06-28 11:02:58.013449', '2011-10-19 14:07:59.006790', '19971223132732.040262', '1979-11-01 15:21:36.008369', '20021016051835.009701', '2017-10-12 17:06:38.508762', '0000-00-00 00:00:00'),
      ('20300905153436.043947', '20030118192156.027163', '0000-00-00 00:00:00', '19840925101855.042225', '0000-00-00 00:00:00', '2017-10-12 17:06:39.508762', '0000-00-00 00:00:00'),
      ('1986-06-22 08:29:17.013450', '0000-00-00 00:00:00', '1992-10-23 15:49:35.050996', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:40.508762', '0000-00-00 00:00:00'),
      ('20340402051823.025806', '20240126005834.043276', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:06:41.508762', '19900504013654.018092'),
      ('2031-04-28 05:28:19.027658', '1973-09-27 02:38:03.032577', '1985-06-18 21:34:01.064996', '2021-01-23 07:34:03.044316', '0000-00-00 00:00:00', '2017-10-12 17:06:42.508762', '0000-00-00 00:00:00'),
      ('19830103155858.064984', '0000-00-00 00:00:00', '1991-04-26 03:15:52.037213', '2007-02-17 15:39:28.045832', '0000-00-00 00:00:00', '2017-10-12 17:06:43.508762', '19870706020626.050306'),
      ('19840527031124.048571', '19880611112312.063274', '19810609213932.037261', '19770814205502.044731', '0000-00-00 00:00:00', '2017-10-12 17:06:44.508762', '19860726015846.048940'),
      ('20351009050053.021322', '0000-00-00 00:00:00', '2031-12-25 00:27:20.036518', '0000-00-00 00:00:00', '2026-12-06 18:10:01.055318', '2017-10-12 17:06:45.508762', '2030-08-25 02:55:39.036366'),
      ('19870804215155.003472', '1997-03-09 10:11:18.017978', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20210905170556.048401', '2017-10-12 17:06:46.508762', '0000-00-00 00:00:00'),
      ('19960610200056.027440', '19880824154243.034894', '20080524005805.056330', '0000-00-00 00:00:00', '19821204013404.053091', '2017-10-12 17:06:47.508762', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20101007142139.060892', '2017-10-12 17:06:48.508762', '0000-00-00 00:00:00'),
      ('20041012062516.002023', '2008-08-11 17:50:11.033783', '0000-00-00 00:00:00', '2029-01-16 16:36:45.023961', '20110821091035.055290', '2017-10-12 17:06:49.508762', '0000-00-00 00:00:00'),
      ('1984-03-12 14:14:34.003377', '19740616172207.009726', '0000-00-00 00:00:00', '1990-12-22 14:52:50.050360', '0000-00-00 00:00:00', '2017-10-12 17:06:50.508762', '0000-00-00 00:00:00'),
      ('2009-03-09 05:21:44.045176', '1981-11-20 11:03:55.059502', '2028-07-18 03:05:52.056094', '1998-09-16 21:56:31.040971', '20210703204100.041619', '2017-10-12 17:06:51.508762', '2029-08-24 02:33:31.017641');
       
      INSERT IGNORE INTO t1 VALUES
      ('0000-00-00 00:00:00', '2024-09-05 15:30:55.032457', '20240707205955.031710', '20331122025542.029075', '2019-04-08 17:40:07.049623', '2017-10-12 17:07:02.519709', '20231013052118.033780'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '2027-05-07 18:39:32.006641', '20200101044430.060357', '0000-00-00 00:00:00', '2017-10-12 17:07:03.519709', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '19970404050925.000512', '0000-00-00 00:00:00', '1984-04-19 23:23:18.047201', '1995-08-25 02:31:24.051646', '2017-10-12 17:07:04.519709', '0000-00-00 00:00:00'),
      ('19720616134502.038451', '1988-12-28 23:53:25.064411', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2004-10-27 05:58:18.064857', '2017-10-12 17:07:05.519709', '1997-01-19 00:01:56.047549'),
      ('2033-01-05 18:20:50.039175', '2013-08-09 13:40:02.016207', '1972-10-25 13:24:33.000551', '0000-00-00 00:00:00', '19881108102357.007154', '2017-10-12 17:07:06.519709', '2023-05-27 17:05:27.012699'),
      ('1972-01-23 15:55:26.011470', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20170810190423.014064', '2017-10-12 17:07:07.519709', '0000-00-00 00:00:00'),
      ('2002-01-01 00:39:31.052239', '2007-07-25 16:39:03.044319', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:07:08.519709', '20280606181717.042546'),
      ('19730501170911.045075', '1980-07-05 00:00:20.045822', '19970817010307.021164', '2011-01-14 07:02:30.014416', '19831202201113.018834', '2017-10-12 17:07:09.519709', '19891107133632.049046'),
      ('0000-00-00 00:00:00', '1981-03-19 20:34:47.042440', '0000-00-00 00:00:00', '19880503103340.018641', '1989-09-20 01:05:22.045692', '2017-10-12 17:07:10.519709', '1980-03-27 08:37:43.005391'),
      ('20280203163839.060156', '0000-00-00 00:00:00', '20330527194812.035240', '0000-00-00 00:00:00', '2032-10-13 01:45:24.007545', '2017-10-12 17:07:11.519709', '1972-05-01 18:34:19.034092'),
      ('0000-00-00 00:00:00', '20060605232422.060376', '1971-01-27 11:19:13.044666', '2026-04-17 06:56:13.034591', '2004-09-24 08:25:28.062962', '2017-10-12 17:07:12.519709', '0000-00-00 00:00:00'),
      ('19931221180523.015923', '20201213155823.008027', '2009-05-26 10:15:49.022007', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:07:13.519709', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20130503092152.023962', '1998-02-27 01:00:13.023120', '2017-10-12 17:07:14.519709', '1999-10-21 07:47:02.057466'),
      ('2010-07-02 17:48:16.045814', '20230806132149.055961', '2008-03-04 19:50:40.027953', '0000-00-00 00:00:00', '2028-07-05 16:15:04.019216', '2017-10-12 17:07:15.519709', '19990122182628.029749'),
      ('2007-12-12 23:50:06.058812', '2007-09-15 08:04:00.015648', '20280121200904.029812', '1974-04-13 03:29:11.056674', '2018-02-01 13:41:36.031788', '2017-10-12 17:07:16.519709', '20090909010256.049839'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '20170801050832.006111', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:07:17.519709', '2017-02-19 14:43:03.020624'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '19921111132824.042241', '19770105084732.049401', '0000-00-00 00:00:00', '2017-10-12 17:07:18.519709', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '20321023112832.048699', '2015-02-01 11:15:38.060326', '2023-12-23 21:15:33.004003', '20081022005006.058702', '2017-10-12 17:07:19.519709', '0000-00-00 00:00:00'),
      ('1988-01-15 09:49:45.038445', '1976-03-07 07:43:16.052998', '1990-05-20 05:57:00.052949', '1972-09-12 01:11:24.044106', '1994-01-28 00:27:03.002925', '2017-10-12 17:07:20.519709', '0000-00-00 00:00:00'),
      ('19721126005532.022313', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2015-06-08 13:26:47.045676', '2017-10-12 17:07:21.519709', '0000-00-00 00:00:00'),
      ('19890823094844.013941', '19770603045800.039301', '19830226141547.016219', '1974-09-28 20:04:31.064220', '20090401063808.056808', '2017-10-12 17:07:22.519709', '1990-12-04 11:49:19.008274'),
      ('1993-06-10 18:48:13.059114', '1973-02-13 16:00:14.060021', '0000-00-00 00:00:00', '19950311115240.015203', '2003-09-10 18:23:38.046551', '2017-10-12 17:07:23.519709', '2020-02-13 13:12:24.012032'),
      ('2018-06-20 11:12:12.058352', '2026-05-13 11:58:15.051539', '0000-00-00 00:00:00', '1980-06-04 21:20:06.056714', '2005-10-06 05:31:34.029387', '2017-10-12 17:07:24.519709', '19770118063655.029684'),
      ('0000-00-00 00:00:00', '19841127111143.050956', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '19821211095004.040349', '2017-10-12 17:07:25.519709', '1978-06-09 05:26:59.032028'),
      ('0000-00-00 00:00:00', '20040408110334.032596', '20010408083528.016740', '0000-00-00 00:00:00', '20100612075052.009274', '2017-10-12 17:07:26.519709', '20251217161725.011507'),
      ('2001-04-25 00:03:25.001777', '0000-00-00 00:00:00', '2003-09-13 07:33:11.031747', '20100112022115.043977', '2012-03-18 14:11:26.042341', '2017-10-12 17:07:27.519709', '1982-02-18 22:49:32.038388'),
      ('0000-00-00 00:00:00', '1993-02-17 05:46:28.010802', '20300702001048.053644', '20090321005824.015060', '0000-00-00 00:00:00', '2017-10-12 17:07:28.519709', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '2002-02-09 06:53:46.026829', '0000-00-00 00:00:00', '19810408135205.048482', '0000-00-00 00:00:00', '2017-10-12 17:07:29.519709', '20200405191825.015141'),
      ('20200222135112.055449', '20090825193834.039185', '0000-00-00 00:00:00', '19801001110110.000726', '19790707103220.019214', '2017-10-12 17:07:30.519709', '20301008121957.010519'),
      ('2008-06-26 10:50:02.004069', '19900211220742.050244', '20111014185010.049115', '20321123011128.062500', '19940318180553.060790', '2017-10-12 17:07:31.519709', '2005-03-21 09:59:09.022012'),
      ('1999-10-24 07:58:14.055484', '19860404210650.025746', '2012-05-10 14:42:43.053044', '1987-05-22 03:45:58.055341', '2029-07-18 15:00:06.035811', '2017-10-12 17:07:32.519709', '0000-00-00 00:00:00'),
      ('1997-05-14 12:51:02.038035', '2004-05-23 10:32:36.058954', '0000-00-00 00:00:00', '1989-07-19 22:00:17.003327', '0000-00-00 00:00:00', '2017-10-12 17:07:33.519709', '2012-06-26 15:39:00.018873'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2013-06-20 11:02:08.038044', '2017-10-12 17:07:34.519709', '19750907184813.041014'),
      ('2020-05-11 06:26:28.057286', '20080506085446.055621', '19931017094540.025059', '2032-01-16 09:42:38.019720', '0000-00-00 00:00:00', '2017-10-12 17:07:35.519709', '2032-06-11 14:46:18.035032'),
      ('2029-07-04 14:15:11.014298', '1971-07-04 05:43:21.054195', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20220111212735.061233', '2017-10-12 17:07:36.519709', '2018-06-19 21:08:12.031596'),
      ('19921111113919.060690', '0000-00-00 00:00:00', '1971-05-07 04:57:44.000519', '19940921155356.037474', '19980524063920.030167', '2017-10-12 17:07:37.519709', '0000-00-00 00:00:00'),
      ('20330319025112.045768', '2009-06-27 11:41:34.038020', '2030-12-22 00:15:00.023217', '0000-00-00 00:00:00', '1989-02-24 09:58:21.016177', '2017-10-12 17:07:38.519709', '1992-11-11 21:28:31.023311'),
      ('19790311141453.013249', '20220407231911.043763', '2008-07-27 02:47:54.030149', '0000-00-00 00:00:00', '2027-06-12 18:22:34.023158', '2017-10-12 17:07:39.519709', '20130508153359.044949'),
      ('1977-10-20 07:39:46.028725', '0000-00-00 00:00:00', '2016-05-01 14:56:30.054393', '19990605004417.065197', '2029-10-22 05:00:25.057024', '2017-10-12 17:07:40.519709', '20261212195237.042644'),
      ('20121107214413.027712', '0000-00-00 00:00:00', '20270419112636.036770', '1984-04-17 13:23:31.035180', '20061008030717.035216', '2017-10-12 17:07:41.519709', '19930325072650.049676'),
      ('1973-08-04 10:53:05.036787', '0000-00-00 00:00:00', '20240727234820.040522', '20210215204434.024838', '2031-03-23 09:14:14.008013', '2017-10-12 17:07:42.519709', '2028-05-05 23:18:02.028692'),
      ('0000-00-00 00:00:00', '20021215204533.031955', '19940928141342.064746', '19791025145949.059717', '20301220023827.045416', '2017-10-12 17:07:43.519709', '2032-01-24 10:04:38.023148'),
      ('0000-00-00 00:00:00', '1993-05-24 06:52:09.025212', '0000-00-00 00:00:00', '19740901024235.046963', '1988-05-05 11:48:51.022218', '2017-10-12 17:07:44.519709', '2008-01-18 00:11:07.006954'),
      ('2016-04-13 23:01:19.018884', '1980-06-20 06:50:27.001313', '0000-00-00 00:00:00', '19851107205414.005257', '19901122095334.030391', '2017-10-12 17:07:45.519709', '19720502173420.038973'),
      ('20320528152351.047029', '2008-04-03 20:02:13.038194', '20330628203502.010557', '0000-00-00 00:00:00', '1980-01-15 15:55:19.063983', '2017-10-12 17:07:46.519709', '19731213123227.011303'),
      ('0000-00-00 00:00:00', '20330216202604.007938', '0000-00-00 00:00:00', '20191222222140.030879', '0000-00-00 00:00:00', '2017-10-12 17:07:47.519709', '1997-10-26 09:26:05.002836'),
      ('19980622075107.024737', '1977-07-23 21:56:52.002438', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2019-07-08 23:16:40.056926', '2017-10-12 17:07:48.519709', '1989-11-15 17:39:40.048905'),
      ('2014-02-13 00:59:36.057087', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '19720422003305.042166', '0000-00-00 00:00:00', '2017-10-12 17:07:49.519709', '1995-06-23 21:32:58.055252'),
      ('19940915215708.005834', '0000-00-00 00:00:00', '20211104201534.061043', '0000-00-00 00:00:00', '20280427192423.030870', '2017-10-12 17:07:50.519709', '0000-00-00 00:00:00'),
      ('19920920133638.041054', '0000-00-00 00:00:00', '2002-10-14 06:05:32.045376', '20290308005007.005801', '19930521071441.008831', '2017-10-12 17:07:52.519709', '2029-02-14 09:11:39.055564');
       
      INSERT IGNORE INTO t1 VALUES
      ('2001-09-12 04:48:42.048186', '19810718160648.015674', '1989-07-14 11:09:39.007095', '2005-12-08 04:19:07.046946', '20030718175549.007491','2017-10-12 17:08:02.529966', '0000-00-00 00:00:00'),
      ('20320304055608.016617', '0000-00-00 00:00:00', '2028-01-15 02:02:22.049172', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:08:03.529966', '0000-00-00 00:00:00'),
      ('2011-01-13 07:58:12.006018', '0000-00-00 00:00:00', '19800623004951.061531', '2029-03-05 11:43:03.042303', '2026-02-24 12:37:58.053309', '2017-10-12 17:08:04.529966', '0000-00-00 00:00:00'),
      ('2008-02-03 00:46:02.057888', '0000-00-00 00:00:00', '20300914021142.038555', '1971-03-15 15:05:49.006177', '1992-10-26 07:36:33.032238', '2017-10-12 17:08:05.529966', '0000-00-00 00:00:00'),
      ('20220321145035.011697', '0000-00-00 00:00:00', '19980811122051.065217', '19971112065805.050476', '1976-12-13 16:34:49.012824', '2017-10-12 17:08:06.529966', '2024-08-12 06:49:40.051998'),
      ('0000-00-00 00:00:00', '20021124080047.047329', '2009-11-13 18:27:30.029116', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:08:07.529966', '2016-07-12 14:13:29.012069'),
      ('1977-08-27 01:56:38.015422', '0000-00-00 00:00:00', '19720508080709.025017', '2012-02-11 01:44:08.029381', '2021-03-26 12:39:32.052801', '2017-10-12 17:08:07.529966', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '20020105160842.043309', '0000-00-00 00:00:00', '20151001020507.010293', '2017-10-12 17:08:08.529966', '1993-02-23 17:39:16.041719'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '19770210012733.053006', '19710313053135.051989', '0000-00-00 00:00:00', '2017-10-12 17:08:09.529966', '0000-00-00 00:00:00'),
      ('2013-10-15 17:30:24.029347', '19990708182608.050660', '0000-00-00 00:00:00', '1999-02-19 19:34:10.018752', '0000-00-00 00:00:00', '2017-10-12 17:08:10.529966', '1983-05-01 15:36:48.013413'),
      ('19730916175330.002362', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '19770220004152.049094', '1990-07-01 16:26:05.037088', '2017-10-12 17:08:11.529966', '1976-10-02 06:26:48.044480'),
      ('1995-04-16 06:19:06.006435', '2021-05-06 20:44:26.005857', '20210124125037.014056', '19940119094341.049216', '1999-05-18 07:10:24.031750', '2017-10-12 17:08:12.529966', '19720609021435.057458'),
      ('2030-04-14 13:14:21.039891', '19901116213554.032655', '19780801212201.052004', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:08:13.529966', '1992-01-04 12:02:22.053914'),
      ('1975-12-18 04:52:05.011019', '2030-11-23 11:00:49.059581', '0000-00-00 00:00:00', '20320916201230.020867', '0000-00-00 00:00:00', '2017-10-12 17:08:14.529966', '0000-00-00 00:00:00'),
      ('19981018010416.051014', '2016-08-12 05:51:19.007359', '20130823053743.018014', '19981207063056.001303', '20120208064936.019606', '2017-10-12 17:08:15.529966', '1975-06-01 16:30:05.057918'),
      ('0000-00-00 00:00:00', '20000719143123.049120', '0000-00-00 00:00:00', '1980-10-07 12:48:40.013851', '0000-00-00 00:00:00', '2017-10-12 17:08:16.529966', '0000-00-00 00:00:00'),
      ('2020-01-04 14:10:25.032744', '20290918081845.037292', '19850417161507.034951', '2025-10-27 23:51:22.030376', '0000-00-00 00:00:00', '2017-10-12 17:08:17.529966', '1992-05-03 09:59:12.033643'),
      ('1989-06-02 14:00:53.021565', '1986-07-01 16:53:57.027321', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20280126113236.013917', '2017-10-12 17:08:18.529966', '19970905171923.040010'),
      ('20211206065453.024577', '0000-00-00 00:00:00', '1973-10-23 23:38:44.044337', '2009-12-09 14:29:42.031430', '0000-00-00 00:00:00', '2017-10-12 17:08:19.529966', '20131121101425.012196'),
      ('0000-00-00 00:00:00', '19870214194835.000826', '0000-00-00 00:00:00', '19851015215737.030756', '0000-00-00 00:00:00', '2017-10-12 17:08:20.529966', '0000-00-00 00:00:00'),
      ('2004-11-20 22:57:34.016678', '2004-01-28 23:06:26.011821', '1980-06-06 02:20:22.061704', '1997-03-22 17:55:12.039434', '2003-04-02 04:09:09.055138', '2017-10-12 17:08:21.529966', '20241210075859.055315'),
      ('1974-04-24 11:47:52.036602', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2033-02-01 10:05:42.044493', '19891228062325.028380', '2017-10-12 17:08:22.529966', '20241205033011.050081'),
      ('2004-04-05 09:58:43.061575', '2033-10-05 07:24:39.033935', '2013-06-17 22:53:35.005206', '2000-04-26 13:14:59.021772', '0000-00-00 00:00:00', '2017-10-12 17:08:23.529966', '0000-00-00 00:00:00'),
      ('2016-05-16 03:22:32.009927', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '19970624003556.053771', '0000-00-00 00:00:00', '2017-10-12 17:08:24.529966', '20260417201936.037463'),
      ('2024-05-09 00:48:07.024587', '1973-03-14 01:16:18.028286', '2015-11-13 11:50:33.009496', '19780316121446.063607', '19780418233259.055669', '2017-10-12 17:08:25.529966', '2019-08-15 11:03:57.033824'),
      ('1982-07-19 01:40:29.044736', '0000-00-00 00:00:00', '20090108181758.017759', '0000-00-00 00:00:00', '19800217145747.058711', '2017-10-12 17:08:26.529966', '19970924063652.011694'),
      ('0000-00-00 00:00:00', '2014-02-12 20:17:51.023599', '1987-10-17 04:05:14.040804', '20331225084534.010688', '2027-07-02 08:55:44.033831', '2017-10-12 17:08:27.529966', '20330428191822.039186'),
      ('0000-00-00 00:00:00', '19800906083133.002558', '0000-00-00 00:00:00', '1996-03-03 10:14:25.015347', '0000-00-00 00:00:00', '2017-10-12 17:08:28.529966', '2003-08-13 04:23:06.041749'),
      ('0000-00-00 00:00:00', '1990-09-27 21:57:15.060240', '20071007064903.033074', '0000-00-00 00:00:00', '20090927024039.004395', '2017-10-12 17:08:29.529966', '2010-02-09 06:54:40.016321'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '19811127094015.005973', '20001011101142.039717', '1980-02-04 10:24:07.034432', '2017-10-12 17:08:30.529966', '1984-07-09 23:36:43.022452'),
      ('2020-03-26 17:13:34.053511', '2035-09-14 13:58:58.032695', '0000-00-00 00:00:00', '19790716023513.034821', '0000-00-00 00:00:00', '2017-10-12 17:08:31.529966', '1974-10-15 13:43:27.017499'),
      ('0000-00-00 00:00:00', '2015-07-24 04:00:17.033327', '20190504230759.041371', '0000-00-00 00:00:00', '2025-09-01 20:48:27.037578', '2017-10-12 17:08:32.529966', '0000-00-00 00:00:00'),
      ('1981-05-25 01:48:26.051916', '20131012174511.065234', '1976-10-28 08:32:35.033136', '2004-06-12 01:09:51.036149', '2033-08-03 08:02:09.051142', '2017-10-12 17:08:33.529966', '1980-10-07 10:38:50.036068'),
      ('20151019012057.039268', '20180103022640.005686', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:08:34.529966', '1976-04-16 00:24:17.064467'),
      ('1980-04-18 00:50:12.064411', '0000-00-00 00:00:00', '19860120034004.006826', '0000-00-00 00:00:00', '20211125141102.055033', '2017-10-12 17:08:35.529966', '19781205112745.013418'),
      ('1979-12-12 11:30:55.062815', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '19890811040349.055056', '2017-10-12 17:08:36.529966', '0000-00-00 00:00:00'),
      ('1991-05-12 09:43:10.025923', '0000-00-00 00:00:00', '1975-11-16 10:12:47.037596', '2031-12-24 08:07:29.045835', '2009-08-11 02:56:44.050403', '2017-10-12 17:08:37.529966', '19961101092224.061128'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '1979-02-05 06:21:23.009005', '19910722161358.051279', '1973-07-20 18:00:50.017119', '2017-10-12 17:08:38.529966', '0000-00-00 00:00:00'),
      ('19801018142011.061736', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2017-10-12 17:08:39.529966', '20280427214701.002954'),
      ('1989-09-27 19:46:12.004843', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '20350607125051.024020', '2017-10-12 17:08:40.529966', '20330627204111.002793'),
      ('0000-00-00 00:00:00', '20301204202022.064417', '20190824050847.041163', '2006-02-20 03:44:18.025057', '19860625111639.037749', '2017-10-12 17:08:41.529966', '19780115100412.037076'),
      ('19921015130955.056065', '1986-08-17 17:35:48.006073', '1985-11-23 02:19:22.061550', '2019-12-02 13:01:46.053580', '0000-00-00 00:00:00', '2017-10-12 17:08:42.529966', '1994-09-24 13:40:12.022461'),
      ('0000-00-00 00:00:00', '2011-06-05 23:25:40.004359', '1978-04-24 21:59:46.025141', '20000710211045.038994', '2005-04-28 17:08:01.024358', '2017-10-12 17:08:43.529966', '0000-00-00 00:00:00'),
      ('0000-00-00 00:00:00', '0000-00-00 00:00:00', '2031-12-12 13:19:35.025597', '2002-07-04 14:36:15.046188', '0000-00-00 00:00:00', '2017-10-12 17:08:44.529966', '0000-00-00 00:00:00'),
      ('20221010124714.000763', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2001-05-18 19:29:13.019673', '2031-11-21 06:52:21.035676', '2017-10-12 17:08:45.529966', '0000-00-00 00:00:00'),
      ('1987-12-15 07:47:06.058809', '19760225213503.030956', '1987-02-22 08:17:39.044808', '20090205045705.051588', '20341216034252.001876', '2017-10-12 17:08:46.529966', '20050628074941.056289'),
      ('1980-03-06 12:49:37.001549', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1998-10-07 20:49:02.016401', '1984-12-24 21:03:22.011612', '2017-10-12 17:08:47.529966', '19960306182601.002727'),
      ('19761003134630.055017', '20350325230611.000081', '20080518013512.004935', '0000-00-00 00:00:00', '20130224141916.003157', '2017-10-12 17:08:48.529966', '20010907155539.060204'),
      ('0000-00-00 00:00:00', '2024-07-07 15:36:06.052174', '2026-06-27 13:33:39.060352', '20120816000034.020757', '0000-00-00 00:00:00', '2017-10-12 17:08:49.529966', '20230120083808.004585'),
      ('2018-12-02 05:16:39.064702', '2019-05-21 06:12:14.007237', '1999-04-09 04:45:29.053296', '1998-10-07 21:09:56.058315', '0000-00-00 00:00:00', '2017-10-12 17:08:50.529966', '0000-00-00 00:00:00');
       
      SHOW ENGINE INNODB STATUS;
       
      # Cleanup
      DROP TABLE t1;
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              marko Marko Mäkelä
              Reporter:
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: