Assertion `!writer.checksum_len || writer.remains == 0' failed in MYSQL_BIN_LOG::write_cache

--source include/have_innodb.inc

--source include/have_log_bin.inc

CREATE /* QNO 2 CON_ID 10 */ TABLE t1_InnoDB (col_datetime DATETIME(3) NULL, col_varchar VARCHAR(2249) NULL, id SERIAL, col_char CHAR(189) NOT NULL DEFAULT '', col_int INT(9) UNSIGNED ZEROFILL NULL) ENGINE=InnoDB;

ALTER /* QNO 3 CON_ID 10 */ TABLE t1_InnoDB ADD PRIMARY KEY (col_varchar,col_char,col_int);

CREATE /* QNO 5 CON_ID 10 */ VIEW view_t1_InnoDB AS SELECT * FROM t1_InnoDB;

CREATE /* QNO 16 CON_ID 10 */ TABLE t1_MyISAM (col_char CHAR(189) NOT NULL DEFAULT '', col_int INT(9) UNSIGNED ZEROFILL NULL, id SERIAL, col_datetime DATETIME(3) NULL, col_varchar VARCHAR(2249) NULL) ENGINE=MyISAM;

CREATE /* QNO 37 CON_ID 10 */ TABLE t2_InnoDB (col_char CHAR(19) NULL, col_int MEDIUMINT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0, col_varchar VARCHAR(1465) NULL, id BIGINT) ENGINE=InnoDB;

CREATE /* QNO 40 CON_ID 10 */ VIEW view_t2_InnoDB AS SELECT * FROM t2_InnoDB;

CREATE /* QNO 47 CON_ID 10 */ TABLE t2_MyISAM (col_int MEDIUMINT(4) UNSIGNED ZEROFILL NOT NULL DEFAULT 0, col_char CHAR(19) NULL, col_varchar VARCHAR(1465) NULL, id BIGINT) ENGINE=MyISAM;

INSERT /* QNO 53 CON_ID 10 */ IGNORE INTO t2_MyISAM (col_char,col_int,col_varchar,id) VALUES

('tpp',7,'g',8);

CREATE /* QNO 106 CON_ID 10 */ TABLE t4_InnoDB (id INTEGER AUTO_INCREMENT, col_char BINARY(15) NOT NULL DEFAULT '', col_int INT(44) UNSIGNED NULL, col_timestamp TIMESTAMP NOT NULL DEFAULT '1971-01-01 00:00:00', col_varchar VARCHAR(830) NULL, PRIMARY KEY(id,col_char)) ENGINE=InnoDB;

CREATE /* QNO 108 CON_ID 10 */ VIEW view_t4_InnoDB AS SELECT * FROM t4_InnoDB;

ALTER /* QNO 112 CON_ID 10 */ TABLE t4_InnoDB ADD UNIQUE(col_int,id,col_char(15),col_varchar(64),col_timestamp);

INSERT /* QNO 115 CON_ID 10 */ IGNORE INTO t4_InnoDB (col_char,col_int,col_timestamp,col_varchar) VALUES

('',4,'1946-08-27 04:32:10.002398','eiw'),

('iwv',3,'1941-12-14 00:00:00',''),

('w',8,'1940-01-09 04:54:08.055595','vdmd'),

('d',120,'1922-07-28 00:00:00','md'),

('divjqsx',1,'1931-02-27 00:00:00','iv'),

('vjqsx',3,'1931-04-28 00:00:00',NULL),

('jq',2,'2004-11-17 11:50:15.051431','qsx'),

('s',4,'1991-07-07 00:00:00','xmhj'),

('',8,'2011-05-21 00:00:00','mhjwa'),

('',2,'2037-10-07 00:00:00','hjw'),

('jw',3,'1900-01-01 00:00:00','wagewcl'),

('age',0,'2001-08-11 10:08:07.064342','k'),

('ge',5,'1955-03-20 18:10:25.045001',NULL),

('ewclcf',NULL,'1974-05-12 02:17:47.016280','w'),

('s',1,'1900-01-01 00:00:00','r'),

('cl',9,'1915-08-30 00:41:41.009818','l'),

('c',4,'2013-11-19 06:56:28.003046','fykyw'),

('ykywlcne',8,'1900-01-01 00:00:00','kywl'),

('ywl',7,'1917-01-19 00:00:00','wl'),

('lcnem',1,'2033-05-27 21:23:42.049194','cnemiu'),

('ne',5,'1917-07-22 15:19:55.028632','em'),

('miuaab',2,'1922-12-26 15:14:17.055064','iuaa'),

('uaa',119,'1987-12-08 17:44:47.040991',''),

('aabrr',7,'2018-01-29 00:31:14.013120','ab'),

('br',NULL,'1989-05-31 15:07:05.012226','r'),

('rif',5,'1964-06-06 00:00:00','if'),

('fnhu',1,'1945-12-22 04:35:35.052670','nhuufz'),

('hu',5,'2029-07-14 19:53:29.019029',NULL),

('uu',3,'1950-07-18 06:44:11.020753','ufz'),

('fzas',68,'2020-11-20 00:00:00','za'),

('asu',4,'2028-03-08 03:17:33.060539','h'),

('s',7,'2016-02-28 10:12:42.050003','unkr'),

('nkrcpvas',0,'1953-07-13 00:00:00','k'),

('r',0,'1974-09-23 22:24:32.014332',REPEAT('a',544)),

('',0,'2018-10-11 16:07:51.040867',NULL),

('pvasdqk',6,'1924-08-23 19:00:29.047077','vas'),

('asdq',5,'1968-05-22 00:00:00',''),

('',1,'1949-03-23 11:27:14.061685','sd'),

('dqk',NULL,'1901-08-19 13:07:46.020110',NULL),

('q',5,'1900-01-01 00:00:00','y'),

('g',8,'1982-03-25 10:21:48.019146',REPEAT('x',456)),

('xbwp',9,'1900-01-01 00:00:00',NULL),

('bw',0,'1950-02-06 00:26:22.026557','w'),

('pti',6,'1900-04-04 00:00:00','t'),

('i',NULL,'2028-05-31 00:00:00','gb'),

('b',9,'1989-05-27 15:15:03.000652','p'),

('nesqi',8,'2037-06-02 17:25:59.013790','esq'),

('sqi',0,'1995-07-01 03:16:37.006849','qig'),

('i',NULL,'1999-02-25 19:41:18.038714','gweg'),

('weg',6,'1945-01-18 09:54:23.051174','egcn'),

('gcn',4,'1929-09-06 00:00:00','cnfe'),

('nfeuvrgnecp',6,'1900-01-01 00:00:00','feuvrg'),

('',7,'1992-12-09 18:46:18.025872','eu'),

('uv',7,'2024-06-18 13:18:46.022767',''),

('v',1,'1926-08-29 00:00:00','rgnecpth'),

('gn',2,'2023-10-03 00:00:00','v'),

('necp',1,'1959-05-30 00:00:00','e'),

('cpthm',9,'2009-09-19 01:12:22.007793','p'),

('thmh',4,'1978-07-29 07:49:57.063437','hmhffqbyth'),

('m',7,'1938-09-13 00:00:00',NULL),

('',6,'2007-12-08 16:49:57.010540','hffq'),

('ffq',6,'2028-07-09 00:00:00','fq'),

('q',7,'2015-08-27 03:57:34.033579','by'),

('ythjw',NULL,'1914-02-23 21:36:07.018379','th'),

('',9,'2006-10-26 11:50:37.041789','hjwp'),

('jwp',5,'2005-09-11 19:01:31.021985','wpukqub'),

('pu',6,'2010-02-14 11:59:08.008470','ukq'),

('kqub',5,'1975-04-04 17:13:14.020176','q'),

('u',148,'1957-02-26 16:26:27.017894','bzpo'),

('zp',4,'1900-01-01 00:00:00','po'),

('omntr',245,'1921-03-15 11:03:24.028456','mnt'),

('ntrddrw',9,'1900-01-01 00:00:00',''),

('',9,'1966-02-14 00:50:56.032173',NULL),

('trdd',NULL,'1973-03-24 00:00:00','rddrwhzjtqvbjiklcekxqyoxsolbxthd'),

('ddrw',9,'1942-06-10 09:04:20.025884',REPEAT('x',109)),

('rw',1,'1942-12-30 21:19:13.020628',''),

('w',5,'1963-03-16 00:00:00',NULL),

('hz',7,'1989-10-12 13:18:38.010403','z'),

('s',4,'1900-01-01 00:00:00','jtqvbji'),

('t',215,'1942-01-26 17:12:56.050877','qv'),

('v',0,'1950-09-14 17:34:05.019053','bj'),

('v',4,'2001-05-05 01:03:47.019826','jikl'),

('ikl',4,'1900-01-01 00:00:00','klc'),

('',9,'2021-11-15 00:00:00',''),

('l',2,'1976-11-04 01:01:34.058066','cekxqyo'),

('ekxq',7,'1918-04-06 06:56:22.004836',''),

('kxqyo',8,'1997-11-02 20:21:58.036091','xqy'),

('qy',4,'2004-01-23 00:00:00','yox'),

('',7,'1967-04-28 09:40:41.049964','oxsol'),

('x',4,'1945-04-30 00:00:00','s'),

('o',6,'1900-01-01 00:00:00','lb'),

('bxth',8,'1972-05-08 00:23:04.031579','xthdc'),

('th',4,'1900-01-01 00:00:00','hd'),

('dcprswpj',5,'1907-06-01 17:43:13.008659',''),

('cprsw',56,'2024-11-17 00:00:00',NULL),

('p',0,'1966-03-25 03:37:53.048711','rswpj'),

('s',6,'2026-10-15 00:00:00','wpjxix'),

('pjx',75,'2029-12-28 13:30:25.063311','jxi'),

('',4,'1940-11-20 00:00:00','xi'),

('ixmvf',2,'2026-12-09 06:25:55.046119','');

CREATE /* QNO 120 CON_ID 10 */ TABLE t5_InnoDB (col_timestamp TIMESTAMP(5) NOT NULL DEFAULT '1971-01-01 00:00:00', id SERIAL, col_date DATE NULL, col_varchar VARCHAR(29) NULL, col_char BINARY(88) NOT NULL DEFAULT '', col_year YEAR NOT NULL DEFAULT '1970') ENGINE=InnoDB;

ALTER /* QNO 121 CON_ID 10 */ TABLE t5_InnoDB ADD PRIMARY KEY (id,col_year,col_date,col_timestamp);

CREATE /* QNO 122 CON_ID 10 */ VIEW view_t5_InnoDB AS SELECT * FROM t5_InnoDB;

INSERT /* QNO 132 CON_ID 10 */ IGNORE INTO t5_InnoDB (col_char,col_date,col_timestamp,col_varchar,col_year,id) VALUES

('yvb',NULL,'1929-02-13 14:35:14.028072','v',1976,1976),

('bitxqj','1905-10-21','1900-01-01 00:00:00','itxq',2000,2000),

('','1930-01-28','1974-11-02 19:08:53.006711','tx',2006,2006),

('qr','1959-04-05','1945-11-15 09:55:16.008317','re',2012,2012),

('zby','1900-01-01','1900-01-01 00:00:00','bycekyjgbp',2025,2025),

('wasfkvetfobocgpftrhvxugmmsz',NULL,'2002-07-26 23:57:15.061286','',2011,2011),

('m','1979-04-13','1957-08-06 18:02:44.055290','a',2034,2034),

('s',NULL,'1937-05-08 03:41:49.022467','t',1971,1971),

('','2032-09-15','1957-11-01 00:00:00','',2019,2019),

('fkv','1900-01-01','1979-04-19 01:51:27.025077','kve',1987,1987),

('cgpftrhvxugmmszwpoglv','1913-12-06','1900-01-01 00:00:00',NULL,2001,2001),

('gp','2008-10-14','1943-05-14 22:26:37.042398','pft',2009,2009),

('ftrhvxugmmszwpoglvarsfiljrzimqeplevleqdhepkhcfrahcpjjvhkkwblfenfpet','1950-05-08','1936-01-28 06:38:18.035205','',2008,2008),

('t','1957-07-30','1948-09-05 06:57:27.025863','rhvx',2002,2002),

('','1925-10-05','1979-09-16 00:00:00','v',2027,2027),

('xugmms','1988-02-11','2004-06-09 20:38:32.039757','u',2014,2014),

('mms','1987-02-11','2030-09-30 05:57:07.029025','mszw',1996,1996),

('poglv','1900-01-01','1972-04-20 00:00:00','',2032,2032),

('oglvar','2004-12-01','1945-07-26 19:04:23.065378','gl',1995,1995),

('lvar','1964-02-01','1942-04-14 05:56:01.018054','vars',2029,2029),

('','1900-01-01','1909-01-29 00:00:00','ars',1974,1974),

('rsfil',NULL,'1988-01-02 06:19:07.058747','sfiljrz',2035,2035),

('','1900-01-01','1990-02-25 00:00:00','',2024,2024),

('eq','1927-10-15','1907-03-20 00:00:00','qdhepkhc',1982,1982),

('dh','1919-03-11','1900-01-01 00:00:00','hepkh',1973,1973),

('epkhcfrahcpjjvhkkwblfen','1918-07-23','1938-07-22 10:33:01.019518','b',1979,1979),

('p','1978-04-06','2020-03-02 00:00:00',NULL,2010,2010),

('v','1988-11-21','2002-11-09 00:00:00','nfp',1983,1983),

('m',NULL,'1918-11-22 20:18:26.027745','',1991,1991),

('fp','1907-08-02','2008-08-31 17:44:59.011797','',2004,2004),

('tw','1900-01-01','1918-12-16 04:48:09.064277','w',2020,2020),

('sksusqvaz','1964-08-03','1920-04-05 05:39:18.027102','ksu',2023,2023),

('s','2000-12-05','1980-05-09 05:53:04.055896','u',1988,1988),

('s','1916-01-03','1974-03-07 21:46:41.050407','q',1989,1989),

('va','1999-12-13','1941-04-03 00:00:00','az',1999,1999),

('ja',NULL,'1914-04-03 00:00:00','',1986,1986),

('e','2005-09-24','1990-12-13 22:26:25.008696','kx',1990,1990),

('yeqtf','1921-06-25','1900-01-01 00:00:00','eqtf',2028,2028),

('qtfo','1998-06-11','1966-03-10 03:47:31.035070','tfop',2030,2030),

('gthomsfusbhugmvurbryqqcbkhankkwoalodixeuh','1900-01-01','1908-07-08 21:28:41.015611','th',2007,2007),

('ho','1994-01-16','1994-02-08 16:31:07.008962','oms',1998,1998),

('yqqcbkhankkwoal',NULL,'1997-09-17 00:00:00','qqc',1984,1984),

('qcbkhankkwoalodixeuhwkzwfd','1972-02-08','1933-02-14 14:59:47.039547','',2026,2026),

('c','1951-11-06','1913-07-21 07:53:33.014389','bkha',2003,2003),

('ha',NULL,'2013-11-18 00:00:00','an',1994,1994),

('i','2039-07-17','1933-03-28 15:08:55.047213','xe',2015,2015),

('k','1929-12-13','1926-07-05 02:53:36.059168',NULL,1981,1981),

('d','1918-09-14','1910-12-14 10:43:18.018380','uhwkzw',1993,1993),

('kzw','1961-11-15','1976-05-26 18:46:01.032935',NULL,2022,2022),

('dfoc','2006-07-15','1935-01-21 00:00:00','f',1972,1972),

('ocdcjrx','1900-06-25','1967-02-11 20:08:57.028724','cdc',2031,2031),

('xxihtv','1987-09-05','1905-02-13 00:00:00','r',1980,1980),

('xihtvzdfvdanvsodxuroztqcmuxmpjisqdkfykpraagyrwsw',NULL,'1975-02-06 19:00:04.061755','iht',2033,2033),

('tvzdfvdanvsodxuro','1917-12-15','2034-09-14 03:08:25.025687','vzdfvd',1977,1977),

('zdfvdanvsodxur','1976-04-12','1912-10-28 00:00:00',NULL,1985,1985),

('v','1900-01-01','1937-12-29 00:00:00','so',1975,1975),

('odx','1953-01-16','1900-01-01 00:00:00','dxuroz',2005,2005),

('dkf','2028-04-06','1900-01-01 00:00:00','kf',1992,1992),

('','2033-11-01','1900-01-01 00:00:00','fykpr',2016,2016),

('ykpra','1920-03-14','1943-03-29 00:00:00','k',1997,1997),

('oqnghixsjyoix','2007-08-15','2033-05-31 00:58:23.005461',NULL,1978,1978),

('qnghixsjyoixuyqrdnahim','1900-01-01','1985-01-28 12:10:58.005674','nghi',2021,2021),

('jbeirucdkuyk','2035-12-12','1963-06-15 09:12:46.064437','',2018,2018),

('be',NULL,'1931-07-22 00:00:00','eirucd',2023,2023);

CREATE /* QNO 136 CON_ID 10 */ TABLE t5_MyISAM (col_date DATE NULL, col_varchar VARCHAR(29) NULL, col_year YEAR NOT NULL DEFAULT '1970', col_timestamp TIMESTAMP(5) NOT NULL DEFAULT '1971-01-01 00:00:00', id SERIAL, col_char BINARY(88) NOT NULL DEFAULT '') ENGINE=MyISAM;

CREATE /* QNO 138 CON_ID 10 */ VIEW view_t5_MyISAM AS SELECT * FROM t5_MyISAM;

INSERT /* QNO 152 CON_ID 10 */ IGNORE INTO t5_MyISAM (col_char,col_date,col_timestamp,col_varchar,col_year,id) VALUES

('ae','1994-01-31','1928-06-29 12:03:12.040890','eud',2032,2032),

('s','2003-04-22','1997-09-28 01:47:52.051666','ud',2009,2009),

('vaddl',NULL,'1907-01-21 18:21:55.052132','addl',1984,1984),

('dd','1945-09-08','1941-10-22 22:14:25.012151','dlda',2035,2035),

('ldame','1918-06-18','2038-06-22 03:24:04.010395','damecc',1975,1975),

('t','2035-08-10','1922-10-22 00:00:00','',2002,2002),

('','1986-10-23','2009-08-09 08:12:54.043600','s',2001,2001),

('epd','2035-12-12','1993-03-03 22:41:55.005114','pdpav',1998,1998),

('bvp','1929-09-28','1958-09-22 03:43:45.021422','vp',2017,2017),

('d','2012-07-06','1993-11-18 20:19:27.061212','fau',1987,1987),

('q','1904-01-09','1984-06-26 17:06:06.012334','hlwsgpdyenbrsxhvymu',1993,1993),

('lwsgpd','1905-04-07','1912-03-22 07:07:22.026665','wsg',2028,2028),

('p','1980-11-23','1998-08-17 01:15:31.004903','',1992,1992),

('','2003-05-04','1906-07-01 08:48:05.042375','d',1973,1973),

('kf','2038-06-13','2032-01-18 04:13:43.034659','fwijf',1972,1972),

('wi','1950-01-16','1902-04-24 12:03:49.060683','ijfv',2006,2006),

('xr','2006-01-18','1940-08-19 00:00:00','k',1999,1999),

('n','1948-02-06','2000-04-04 01:39:46.003164','pczmz',1980,1980),

('x','1978-06-10','1950-05-18 13:43:05.058386','mzuccu',1988,1988),

('zuccu','1985-12-21','1999-02-11 17:37:07.010690','uc',2029,2029),

('upn','1900-01-01','1904-07-18 16:14:30.064796','p',2014,2014),

('n','1959-01-01','1926-05-14 00:00:00','mvrn',2015,2015),

('wmgfvmxfjouuvqoifddmpfnvluqgtuduwxhchqituunenpulezx','1942-08-28','1900-01-01 00:00:00','r',2030,2030),

('fvm',NULL,'1927-08-23 10:06:49.050960','vmxfjouuvqoifddmpf',2024,2024),

('','2007-07-11','2033-08-27 00:26:27.055686','',2019,2019),

('mpfnvl','1991-04-05','1931-08-14 02:28:10.024748','pfn',2004,2004),

('fn','1907-12-29','1907-07-03 16:19:01.005781','',1978,1978),

('nvluqgtuduwxhchqituunenpulezxhpdezppkkfhpidlac','1941-06-24','1981-03-12 20:45:10.024118',NULL,1994,1994),

('vlu','1954-01-29','1924-06-25 23:19:40.058581','luqgtuduw',1989,1989),

('uqgtuduwxhch','2000-08-26','2007-09-12 01:41:42.028840','t',2033,2033),

('ituun','1900-01-01','1904-05-19 05:02:54.029731','',2000,2000),

('tuunenpulezxhpdezppkkfhpidlaczfybmpylawoicpfbqdyydyexmgoue','2004-09-19','1922-12-31 14:19:15.004235',NULL,2008,2008),

('z','1907-08-03','2022-12-28 07:41:52.026951','nen',1991,1991),

('','1967-02-28','2011-07-20 00:00:00','en',1983,1983),

('npulezx','1945-12-09','1932-08-10 00:00:00','pule',1997,1997),

('l',NULL,'1943-06-24 18:08:17.061031','z',1976,1976),

('lez','1916-03-04','1900-01-01 00:00:00','w',2005,2005),

('ezxhp','1971-11-18','1971-12-23 05:05:09.050066','zxhpd',1985,1985),

('xhp','1955-02-08','1901-12-13 00:00:00','h',2013,2013),

('idla','1970-08-02','1936-05-18 19:46:06.049777',NULL,1990,1990),

('ac','2000-07-28','1971-11-11 21:24:48.055378',NULL,2034,2034),

('mpy','2030-12-13','1914-02-04 00:00:00','',2020,2020),

('q','1901-06-19','1903-09-01 04:37:25.006842','py',1981,1981),

('','1907-03-12','1900-01-01 00:00:00',NULL,1986,1986),

('icp','1900-01-01','2006-05-24 16:38:07.050010','c',2021,2021),

('pf','2022-01-10','1948-12-12 19:44:52.035927','fbqdyy',1971,1971),

('b','1910-11-03','1991-09-09 13:50:41.003427','qdy',1979,1979),

('x','1943-08-22','1928-05-23 13:46:51.001275','mgou',1995,1995),

('i','1928-06-17','1987-09-12 13:11:00.026124','',1974,1974),

('el','1900-01-01','1970-11-03 00:00:00','lsx',2022,2022),

('gsr',NULL,'1950-09-11 00:00:00','s',2011,2011),

('x','1928-02-19','1907-07-08 00:00:00','veb',2010,2010),

('ebzqk',NULL,'1909-03-06 08:58:20.060638','bz',2025,2025),

('z','2009-05-12','2024-07-16 16:45:48.053277','q',2026,2026),

('kg','1986-09-30','1900-01-01 00:00:00','gv',2027,2027),

('vnwhiu','1911-03-07','1900-01-01 00:00:00','',1996,1996),

('nwhiu','2020-04-18','2034-05-16 04:59:36.044223','whiuql',2016,2016),

('r','1951-02-03','2003-03-18 14:13:05.030928','',2031,2031),

('hiu','1948-10-17','1962-09-05 19:58:39.019797',NULL,2003,2003),

('iuqlaekvfzxxup','1920-08-24','2020-08-05 02:34:08.028954','uql',2018,2018),

('qlaekvfzxxup','2005-09-09','1951-03-20 00:00:00','',1977,1977),

('d',NULL,'2004-09-20 13:16:53.035958','laekv',2012,2012),

('u','2035-03-02','1934-07-18 17:35:39.027958','ttfjbtwzqkistrxf',2007,2007),

('tfjb','2030-10-17','1995-10-22 00:19:40.040592','fjbt',2023,2023),

('n','2003-01-13','1922-08-06 00:00:00','jb',1982,1982);

CREATE /* QNO 168 CON_ID 10 */ TABLE t7_InnoDB (col_varchar VARBINARY(2427) NULL, col_int BIGINT(5) ZEROFILL NULL, col_timestamp TIMESTAMP(5) NOT NULL DEFAULT '1971-01-01 00:00:00', col_char BINARY(47) NULL, id BIGINT) ENGINE=InnoDB;

ALTER /* QNO 169 CON_ID 10 */ TABLE t7_InnoDB ADD PRIMARY KEY (id,col_char);

CREATE /* QNO 171 CON_ID 10 */ VIEW view_t7_InnoDB AS SELECT * FROM t7_InnoDB;

INSERT /* QNO 180 CON_ID 10 */ IGNORE INTO t7_InnoDB (col_char,col_int,col_timestamp,col_varchar,id) VALUES

('',5,'1916-01-05 11:01:05.065275','h',9);

CREATE /* QNO 213 CON_ID 10 */ TABLE t8_InnoDB (col_year YEAR NOT NULL DEFAULT '1970', col_char BINARY(161) NOT NULL DEFAULT '' /*!100303  */, col_int BIGINT(44) ZEROFILL NOT NULL DEFAULT 0, id SERIAL /*!100303  */, col_blob MEDIUMTEXT NULL) ENGINE=InnoDB;

ALTER /* QNO 214 CON_ID 10 */ TABLE t8_InnoDB ADD PRIMARY KEY (col_char,col_year);

INSERT /* QNO 221 CON_ID 10 */ IGNORE INTO t8_InnoDB (col_blob,col_char,col_int,col_year,id) VALUES

(REPEAT('m',35339),'z',1,2031,2031),

(NULL,'kil',9,2018,2018),

(NULL,'iloa',8,1990,1990),

(REPEAT('l',401),'',2,2004,2004),

(REPEAT('k',56565),'loabe',0,2024,2024),

(REPEAT('j',40368),'oa',1,2006,2006),

(REPEAT('i',15972),'a',4,1988,1988),

(NULL,'p',254,2013,2013),

(NULL,'',1,2030,2030),

(REPEAT('h',38111),'eukdch',8,2003,2003),

(REPEAT('g',55516),'x',4,1993,1993),

(REPEAT('f',40562),'a',8,2029,2029),

(REPEAT('e',46179),'dch',0,2000,2000),

(REPEAT('d',33697),'',4,2020,2020),

(REPEAT('c',22872),'c',109,2015,2015),

(REPEAT('b',7957),'nsv',8,2010,2010),

(REPEAT('a',16768),'s',9,2025,2025);

CREATE /* QNO 224 CON_ID 10 */ TABLE t8_MyISAM (col_char BINARY(161) NOT NULL DEFAULT '' /*!100303  */, col_year YEAR NOT NULL DEFAULT '1970', id SERIAL /*!100303  */, col_blob MEDIUMTEXT NULL, col_int BIGINT(44) ZEROFILL NOT NULL DEFAULT 0) ENGINE=MyISAM;

CREATE /* QNO 226 CON_ID 10 */ VIEW view_t8_MyISAM AS SELECT * FROM t8_MyISAM;

INSERT /* QNO 230 CON_ID 10 */ IGNORE INTO t8_MyISAM (col_blob,col_char,col_int,col_year,id) VALUES

(REPEAT('i',46055),'',8,2002,2002),

(REPEAT('h',64690),'sh',3,2028,2028),

(REPEAT('g',59119),'hv',0,1980,1980),

(REPEAT('f',61648),'g',5,2017,2017),

(REPEAT('e',7449),REPEAT('x',129),9,1987,1987),

(REPEAT('d',61279),'shz',4,1972,1972),

(REPEAT('c',12240),'zz',7,1983,1983),

(REPEAT('b',28981),REPEAT('x',124),2,2014,2014),

(REPEAT('a',36756),'ksv',1,2030,2030);

CREATE /* QNO 233 CON_ID 10 */ TABLE t3_InnoDB (col_blob MEDIUMTEXT NULL, col_int BIGINT(44) ZEROFILL NOT NULL DEFAULT 0, col_char BINARY(161) NOT NULL DEFAULT '' /*!100303  */, id SERIAL /*!100303  */, col_year YEAR NOT NULL DEFAULT '1970') ENGINE=InnoDB;

CREATE /* QNO 235 CON_ID 10 */ VIEW view_t3_InnoDB AS SELECT * FROM t3_InnoDB;

INSERT /* QNO 247 CON_ID 10 */ IGNORE INTO t3_InnoDB (col_blob,col_char,col_int,col_year,id) VALUES

('s','svjnb',8,2013,2013),

('g','',254,1983,1983),

('n','v',1,1994,1994),

(REPEAT('m',16372),'jnbk',7,1986,1986),

(REPEAT('l',34709),'o',7,1996,1996),

(REPEAT('k',63148),'n',0,1995,1995),

(REPEAT('j',884),'m',50,1981,1981),

(REPEAT('i',60507),'',137,2025,2025),

(REPEAT('h',27477),'b',9,1975,1975),

(REPEAT('g',43838),'kahdlu',6,1999,1999),

(REPEAT('f',40798),'h',7,2030,2030),

(REPEAT('e',62446),'ah',4,1992,1992),

(REPEAT('d',26717),'hd',6,2020,2020),

(REPEAT('c',7477),'dl',133,2034,2034),

(REPEAT('',41783),'lu',5,2028,2028),

(NULL,'uka',0,2031,2031),

(REPEAT('b',59124),'kabve',9,1988,1988),

(REPEAT('a',30054),'abveh',2,2029,2029);

CREATE /* QNO 250 CON_ID 10 */ TABLE t9_InnoDB (col_int BIGINT(19) NOT NULL DEFAULT 0, col_datetime DATETIME NULL, col_year YEAR NOT NULL DEFAULT '1970', col_enum SET('','a','b','c','d','e','f','foo','bar') NOT NULL DEFAULT '' /*!100303  */, col_char CHAR(25) NULL, id SERIAL, col_dec DECIMAL(26,0) UNSIGNED ZEROFILL NULL, col_timestamp TIMESTAMP(3) NOT NULL DEFAULT '1971-01-01 00:00:00') ENGINE=InnoDB;

ALTER /* QNO 251 CON_ID 10 */ TABLE t9_InnoDB ADD PRIMARY KEY (col_year,col_datetime,col_enum,col_dec);

CREATE /* QNO 253 CON_ID 10 */ VIEW view_t9_InnoDB AS SELECT * FROM t9_InnoDB;

INSERT /* QNO 261 CON_ID 10 */ IGNORE INTO t9_InnoDB (col_char,col_datetime,col_dec,col_enum,col_int,col_timestamp,col_year,id) VALUES

('','1981-07-31 18:08:23.029303',0.540618896484375,'',5,'2018-12-29 04:50:15.009933',2019,2019),

('b','2031-10-17 00:00:00',0.832290649414062,'',5,'1900-01-01 00:00:00',1992,1992),

('v','2037-03-03 17:11:01.058350',0.630599975585938,'',1,'2000-08-25 03:10:43.000227',1974,1974),

('eh','1922-07-28 22:08:32.018961',0.779861450195312,'',2,'2012-06-24 00:54:44.035321',2001,2001),

('he','1969-02-15 00:00:00',0.868942260742188,'',0,'1935-08-13 03:22:38.064356',1988,1988),

('xsiv','1946-09-01 05:12:54.063781',0.742202758789062,'',7,'2024-01-31 16:34:20.026451',2021,2021),

('s','1932-03-08 17:08:23.045135',NULL,'',1,'1952-11-07 18:00:42.058624',2015,2015),

('i','1908-11-07 05:57:36.002126',0.928436279296875,'',3,'1977-05-08 09:07:06.025919',1994,1994),

('vg','1965-12-04 00:00:00',0.620834350585938,'',0,'2028-01-10 08:22:07.052980',2020,2020),

('gmhk','1900-01-01 00:00:00',0.53131103515625,'',5,'2038-12-18 00:00:00',2017,2017),

('mhk','1900-01-01 00:00:00',0.108291625976562,'',0,'1936-03-09 00:00:00',1989,1989),

('h','1900-01-01 00:00:00',NULL,'',9,'1940-10-03 22:23:33.027345',2013,2013),

('vwsoln','1958-06-25 00:13:55.016588',0.927810668945312,'',2,'1911-10-01 14:09:59.010125',2007,2007),

('t','1921-01-30 00:00:00',0.965225219726562,'',5,'1993-02-19 21:56:07.049854',2006,2006),

('so','2023-05-07 00:00:00',0.451675415039062,'',2,'1957-02-03 05:56:45.047348',1977,1977),

(NULL,'1943-07-10 00:08:32.036615',0.21392822265625,'',55,'2002-06-22 00:00:00',2031,2031),

('','1967-03-25 21:33:01.017606',0.147018432617188,'',142,'1992-07-17 00:00:00',1986,1986),

('sm','2010-10-25 04:17:07.021032',0.877655029296875,'',172,'1930-01-30 00:00:00',2004,2004),

('snc','1900-01-01 00:00:00',0.434921264648438,'',3,'1931-12-14 14:44:35.056008',1991,1991),

('cj','1900-01-01 00:00:00',0.6968994140625,'',0,'1980-06-21 22:47:01.046517',2014,2014),

('bjs','1918-05-07 00:39:48.055512',0.137603759765625,'',6,'2032-08-18 06:16:49.008551',2027,2027),

('jsg','1905-05-28 00:00:00',0.194122314453125,'',8,'1987-03-16 11:56:25.054947',1997,1997),

('s',NULL,0.7625732421875,'',3,'1900-01-01 00:00:00',2005,2005),

('g','1953-07-02 06:56:59.054982',0.282669067382812,'',2,'1920-09-13 00:00:00',1978,1978),

('om','2000-09-07 00:00:00',0.177886962890625,'',6,'1911-07-13 19:22:11.008851',2003,2003),

('','2018-10-29 20:10:22.017156',0.404067993164062,'',5,'2007-03-24 03:49:20.055100',2032,2032),

('lgsob',NULL,0.904434204101562,'',1,'1992-10-31 19:42:05.019221',1973,1973),

('gsobtzfpjiwgbcai','1953-08-16 00:00:00',NULL,'',7,'1958-04-10 07:12:21.040674',1996,1996),

('so','2008-09-06 00:00:00',0.251190185546875,'',7,'1947-05-20 22:52:30.004294',1975,1975),

('o','2031-04-21 02:25:43.045848',NULL,'',5,'2003-05-27 08:59:50.057291',2025,2025),

('w','1900-01-01 00:00:00',0.0229644775390625,'',5,'1900-01-01 00:00:00',1972,1972),

('gbc','1977-08-18 18:33:46.045923',0.638214111328125,'',0,'2027-08-02 23:06:28.058449',2012,2012),

('bcai','1906-04-09 14:42:02.062465',0.28570556640625,'',140,'1911-02-06 00:00:00',2023,2023),

('caiwz','1944-01-27 00:00:00',0.169906616210938,'',3,'1967-12-27 00:00:00',2030,2030),

('n','2039-02-15 07:12:21.026056',0.8135986328125,'',4,'1996-05-16 06:21:42.023279',1999,1999),

('ai','1990-09-18 00:44:42.011695',0.065399169921875,'',2,'2025-09-29 14:37:09.053892',2029,2029),

('i',NULL,0.247848510742188,'',4,'2013-03-28 00:00:00',2022,2022),

(NULL,'1906-05-28 00:00:00',0.93902587890625,'',1,'1900-01-01 00:00:00',2034,2034),

('wzd','1900-01-01 00:00:00',0.230819702148438,'',8,'2004-04-30 02:06:58.001668',2016,2016),

('zdofqzimle','1905-05-01 09:03:54.039086',0.1688232421875,'',1,'1942-10-26 01:53:24.044091',1983,1983),

(NULL,'1919-10-07 00:00:00',0.865219116210938,'',2,'1900-01-01 00:00:00',1980,1980),

('qzimlepenzagwimwxt','1954-04-15 00:00:00',0.299026489257812,'',8,'1900-01-01 00:00:00',1995,1995),

('ziml','1954-10-25 07:44:17.000066',0.605331420898438,'',8,'1961-09-08 12:46:03.047970',2010,2010),

('im','1997-01-24 10:46:30.053943',0.651290893554688,'',3,'2008-08-21 00:00:00',2024,2024),

(NULL,'1970-04-14 06:03:41.056160',0.578689575195312,'',1,'2033-07-11 08:18:55.039425',2002,2002),

('epe','2029-01-14 12:18:56.042523',0.911285400390625,'',6,'1957-12-20 00:00:00',2033,2033),

('pen','2024-08-29 11:47:09.044246',0.962722778320312,'',1,'1937-06-20 13:33:20.035962',2026,2026),

('enz','1978-12-07 00:00:00',0.545059204101562,'',7,'1962-10-15 03:38:07.024104',2035,2035),

(NULL,'1958-09-25 09:24:36.006407',0.581161499023438,'',4,'1952-07-02 18:11:34.039466',1985,1985),

('n','1900-01-01 00:00:00',0.118942260742188,'',9,'1963-11-24 20:26:36.013321',1981,1981);

SET /* QNO 405 CON_ID 16 */ GLOBAL max_binlog_cache_size= 1048576, innodb_cmp_per_index_enabled= 0, innodb_log_optimize_ddl= 0, innodb_monitor_disable= '%';

--connect (con18_0,localhost,root,,test)

SELECT /* QNO 2005 CON_ID 17 */ * FROM t5_InnoDB INTO OUTFILE 'load_t5_InnoDB';

SET /* QNO 3454 CON_ID 17 */ SESSION SQL_MODE='';

ALTER /* QNO 3617 CON_ID 17 */ TABLE t7_InnoDB /*!100301 */ ADD CONSTRAINT z UNIQUE INDEX s ( id ) COMMENT 'railroad' /*!100307, ALGORITHM=NOCOPY */, LOCK=NONE;

INSERT /* QNO 3687 CON_ID 17 */ INTO t5_InnoDB SELECT * FROM view_t5_MyISAM;

XA /* QNO 3696 CON_ID 17 */ BEGIN 'xid28';

SELECT /* QNO 4028 CON_ID 17 */ * FROM view_t4_InnoDB INTO OUTFILE 'load_view_t4_InnoDB';

LOAD /* QNO 4029 CON_ID 17 */ DATA INFILE 'load_view_t4_InnoDB' REPLACE INTO TABLE view_t4_InnoDB;

SELECT /* QNO 4349 CON_ID 17 */ * FROM t7_InnoDB INTO OUTFILE 'load_t7_InnoDB';

LOAD /* QNO 4350 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

INSERT /* QNO 4861 CON_ID 17 */ INTO view_t1_InnoDB SELECT * FROM view_t3_InnoDB;

SAVEPOINT /* QNO 4896 CON_ID 17 */ B;

INSERT /* QNO 5017 CON_ID 17 */ INTO t1_MyISAM SELECT * FROM view_t3_InnoDB;

SAVEPOINT /* QNO 5520 CON_ID 17 */ A;

SELECT /* QNO 5689 CON_ID 17 */ * FROM t4_InnoDB INTO OUTFILE 'load_t4_InnoDB';

LOAD /* QNO 5690 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

LOAD /* QNO 5808 CON_ID 17 */ DATA INFILE 'load_view_t4_InnoDB' REPLACE INTO TABLE view_t4_InnoDB;

CREATE /* QNO 5838 CON_ID 17 */ OR REPLACE TEMPORARY TABLE alt_t6 (col_int MEDIUMINT ZEROFILL NOT NULL DEFAULT 3, scol5 TEXT NULL DEFAULT NULL, icol7 INT NOT NULL ) ROW_FORMAT = DYNAMIC ENGINE=InnoDB;

INSERT /* QNO 6779 CON_ID 17 */ INTO t1_InnoDB SELECT * FROM view_t8_MyISAM;

SELECT /* QNO 7012 CON_ID 17 */ * FROM t1_InnoDB INTO OUTFILE 'load_t1_InnoDB';

LOAD /* QNO 7013 CON_ID 17 */ DATA INFILE 'load_t1_InnoDB' REPLACE INTO TABLE t1_InnoDB;

SAVEPOINT /* QNO 7811 CON_ID 17 */ sp;

LOAD /* QNO 7888 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

SELECT /* QNO 8092 CON_ID 17 */ * FROM t9_InnoDB INTO OUTFILE 'load_t9_InnoDB';

LOAD /* QNO 8093 CON_ID 17 */ DATA INFILE 'load_t9_InnoDB' REPLACE INTO TABLE t9_InnoDB;

SAVEPOINT /* QNO 8212 CON_ID 17 */ A;

SAVEPOINT /* QNO 8259 CON_ID 17 */ sp;

SAVEPOINT /* QNO 8274 CON_ID 17 */ A;

SAVEPOINT /* QNO 8302 CON_ID 17 */ A;

SELECT /* QNO 101428 CON_ID 17 */ * FROM t8_InnoDB INTO OUTFILE 'load_t8_InnoDB';

LOAD /* QNO 101429 CON_ID 17 */ DATA INFILE 'load_t8_InnoDB' REPLACE INTO TABLE t8_InnoDB;

ROLLBACK /* QNO 101448 CON_ID 17 */ TO A;

SAVEPOINT /* QNO 101527 CON_ID 17 */ A;

SELECT /* QNO 101606 CON_ID 17 */ * FROM view_t9_InnoDB INTO OUTFILE 'load_view_t9_InnoDB';

LOAD /* QNO 101607 CON_ID 17 */ DATA INFILE 'load_view_t9_InnoDB' REPLACE INTO TABLE view_t9_InnoDB;

SAVEPOINT /* QNO 101755 CON_ID 17 */ B;

SET /* QNO 101769 CON_ID 17 */ SESSION character_set_database= macroman;

SELECT /* QNO 101829 CON_ID 17 */ * FROM view_t5_InnoDB INTO OUTFILE 'load_view_t5_InnoDB';

LOAD /* QNO 101830 CON_ID 17 */ DATA INFILE 'load_view_t5_InnoDB' REPLACE INTO TABLE view_t5_InnoDB;

SAVEPOINT /* QNO 102123 CON_ID 17 */ B;

SAVEPOINT /* QNO 102624 CON_ID 17 */ A;

SAVEPOINT /* QNO 102647 CON_ID 17 */ B;

LOAD /* QNO 102690 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

SAVEPOINT /* QNO 103338 CON_ID 17 */ B;

--error ER_DUP_ENTRY

INSERT /* QNO 103373 CON_ID 17 */ INTO t8_InnoDB SELECT * FROM t1_MyISAM;

SAVEPOINT /* QNO 103791 CON_ID 17 */ A;

SAVEPOINT /* QNO 103820 CON_ID 17 */ A;

ROLLBACK /* QNO 103833 CON_ID 17 */ TO B;

LOAD /* QNO 103886 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

SAVEPOINT /* QNO 104202 CON_ID 17 */ A;

ROLLBACK /* QNO 104775 CON_ID 17 */ WORK TO SAVEPOINT A;

SAVEPOINT /* QNO 104991 CON_ID 17 */ B;

ROLLBACK /* QNO 105100 CON_ID 17 */ TO A;

SAVEPOINT /* QNO 105110 CON_ID 17 */ B;

ROLLBACK /* QNO 105209 CON_ID 17 */ TO A;

ROLLBACK /* QNO 106262 CON_ID 17 */ WORK TO SAVEPOINT A;

INSERT /* QNO 106286 CON_ID 17 */ INTO view_t2_InnoDB SELECT * FROM t2_MyISAM;

LOAD /* QNO 106397 CON_ID 17 */ DATA INFILE 'load_t1_InnoDB' REPLACE INTO TABLE t1_InnoDB;

ROLLBACK /* QNO 106453 CON_ID 17 */ TO SAVEPOINT sp;

SAVEPOINT /* QNO 106488 CON_ID 17 */ B;

SAVEPOINT /* QNO 107284 CON_ID 17 */ B;

LOAD /* QNO 108204 CON_ID 17 */ DATA INFILE 'load_t5_InnoDB' REPLACE INTO TABLE t5_InnoDB;

ROLLBACK /* QNO 108218 CON_ID 17 */ TO SAVEPOINT B;

ROLLBACK /* QNO 108276 CON_ID 17 */ TO B;

SAVEPOINT /* QNO 108294 CON_ID 17 */ B;

SAVEPOINT /* QNO 108353 CON_ID 17 */ B;

ROLLBACK /* QNO 108401 CON_ID 17 */ TO SAVEPOINT B;

SAVEPOINT /* QNO 108587 CON_ID 17 */ A;

LOAD /* QNO 108622 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

ROLLBACK /* QNO 132343 CON_ID 17 */ WORK TO SAVEPOINT B;

LOAD /* QNO 132482 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

SAVEPOINT /* QNO 132816 CON_ID 17 */ sp;

SAVEPOINT /* QNO 132884 CON_ID 17 */ B;

ROLLBACK /* QNO 132890 CON_ID 17 */ WORK TO B;

ROLLBACK /* QNO 132900 CON_ID 17 */ TO SAVEPOINT B;

SAVEPOINT /* QNO 132921 CON_ID 17 */ sp;

ROLLBACK /* QNO 133113 CON_ID 17 */ TO SAVEPOINT sp;

LOAD /* QNO 133459 CON_ID 17 */ DATA INFILE 'load_t4_InnoDB' REPLACE INTO TABLE t4_InnoDB;

SAVEPOINT /* QNO 133594 CON_ID 17 */ A;

SAVEPOINT /* QNO 133600 CON_ID 17 */ A;

SAVEPOINT /* QNO 133676 CON_ID 17 */ sp;

LOAD /* QNO 133680 CON_ID 17 */ DATA INFILE 'load_view_t5_InnoDB' REPLACE INTO TABLE view_t5_InnoDB;

DELETE /* QNO 134056 CON_ID 17 */ FROM t7_InnoDB LIMIT 4;

SAVEPOINT /* QNO 134099 CON_ID 17 */ B;

ROLLBACK /* QNO 134122 CON_ID 17 */ TO SAVEPOINT sp;

ROLLBACK /* QNO 134125 CON_ID 17 */ WORK TO SAVEPOINT A;

LOAD /* QNO 134197 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

LOAD /* QNO 134252 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

SAVEPOINT /* QNO 134300 CON_ID 17 */ B;

ROLLBACK /* QNO 134350 CON_ID 17 */ TO SAVEPOINT B;

SELECT /* QNO 135174 CON_ID 17 */ * FROM view_t7_InnoDB INTO OUTFILE 'load_view_t7_InnoDB';

LOAD /* QNO 135175 CON_ID 17 */ DATA INFILE 'load_view_t7_InnoDB' REPLACE INTO TABLE view_t7_InnoDB;

SAVEPOINT /* QNO 135346 CON_ID 17 */ A;

LOAD /* QNO 135500 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

ROLLBACK /* QNO 135541 CON_ID 17 */ TO SAVEPOINT A;

ROLLBACK /* QNO 135556 CON_ID 17 */ WORK TO A;

LOAD /* QNO 136040 CON_ID 17 */ DATA INFILE 'load_view_t4_InnoDB' REPLACE INTO TABLE view_t4_InnoDB;

ROLLBACK /* QNO 136127 CON_ID 17 */ WORK TO SAVEPOINT A;

SAVEPOINT /* QNO 155480 CON_ID 17 */ sp;

SAVEPOINT /* QNO 155567 CON_ID 17 */ A;

LOAD /* QNO 156125 CON_ID 17 */ DATA INFILE 'load_t9_InnoDB' REPLACE INTO TABLE t9_InnoDB;

UPDATE /* QNO 156144 CON_ID 17 */ t9_InnoDB SET col_int = DEFAULT LIMIT 1;

LOAD /* QNO 156547 CON_ID 17 */ DATA INFILE 'load_view_t7_InnoDB' REPLACE INTO TABLE view_t7_InnoDB;

SAVEPOINT /* QNO 156581 CON_ID 17 */ A;

LOAD /* QNO 156614 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

ROLLBACK /* QNO 156803 CON_ID 17 */ TO SAVEPOINT sp;

SAVEPOINT /* QNO 156822 CON_ID 17 */ A;

LOAD /* QNO 157153 CON_ID 17 */ DATA INFILE 'load_view_t5_InnoDB' REPLACE INTO TABLE view_t5_InnoDB;

SAVEPOINT /* QNO 157361 CON_ID 17 */ B;

SAVEPOINT /* QNO 157408 CON_ID 17 */ B;

LOAD /* QNO 157941 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

SAVEPOINT /* QNO 158034 CON_ID 17 */ B;

SAVEPOINT /* QNO 158041 CON_ID 17 */ A;

ROLLBACK /* QNO 158079 CON_ID 17 */ TO A;

SAVEPOINT /* QNO 158240 CON_ID 17 */ B;

ROLLBACK /* QNO 158243 CON_ID 17 */ TO SAVEPOINT sp;

SAVEPOINT /* QNO 158261 CON_ID 17 */ sp;

SAVEPOINT /* QNO 158316 CON_ID 17 */ A;

ROLLBACK /* QNO 158319 CON_ID 17 */ WORK TO A;

LOAD /* QNO 158707 CON_ID 17 */ DATA INFILE 'load_t9_InnoDB' REPLACE INTO TABLE t9_InnoDB;

SAVEPOINT /* QNO 158718 CON_ID 17 */ B;

ROLLBACK /* QNO 158796 CON_ID 17 */ WORK TO B;

--error ER_TRANS_CACHE_FULL

LOAD /* QNO 158707 CON_ID 17 */ DATA INFILE 'load_t9_InnoDB' REPLACE INTO TABLE t9_InnoDB;

SAVEPOINT /* QNO 158718 CON_ID 17 */ B;

# Error in 10.4, no error in 10.2-10.3

--error 0,ER_TRANS_CACHE_FULL

ROLLBACK /* QNO 158796 CON_ID 17 */ WORK TO B;

# Error in 10.4, no error in 10.2-10.3

--error 0,ER_BINLOG_ROW_LOGGING_FAILED

LOAD /* QNO 158993 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

--error ER_TRANS_CACHE_FULL

SAVEPOINT /* QNO 159009 CON_ID 17 */ sp;

--error ER_BINLOG_ROW_LOGGING_FAILED

LOAD /* QNO 159059 CON_ID 17 */ DATA INFILE 'load_t7_InnoDB' REPLACE INTO TABLE t7_InnoDB;

--error ER_TRANS_CACHE_FULL

SAVEPOINT /* QNO 159223 CON_ID 17 */ A;

--source include/restart_mysqld.inc

mysqld: /data/src/10.2/sql/log.cc:7082: int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*): Assertion `!writer.checksum_len || writer.remains == 0' failed.

200821 14:40:36 [ERROR] mysqld got signal 6 ;

#6  0x00007f5aec429e67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x559640cd3740 "!writer.checksum_len || writer.remains == 0", file=file@entry=0x559640cd0b2c "/data/src/10.2/sql/log.cc", line=line@entry=7082, function=function@entry=0x559640cd6220 <MYSQL_BIN_LOG::write_cache(THD*, st_io_cache*)::__PRETTY_FUNCTION__> "int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*)") at assert.c:92

#7  0x00007f5aec429f12 in __GI___assert_fail (assertion=0x559640cd3740 "!writer.checksum_len || writer.remains == 0", file=0x559640cd0b2c "/data/src/10.2/sql/log.cc", line=7082, function=0x559640cd6220 <MYSQL_BIN_LOG::write_cache(THD*, st_io_cache*)::__PRETTY_FUNCTION__> "int MYSQL_BIN_LOG::write_cache(THD*, IO_CACHE*)") at assert.c:101

#8  0x00005596404d5c65 in MYSQL_BIN_LOG::write_cache (this=0x559641707300 <mysql_bin_log>, thd=0x7f5a90000af0, cache=0x7f5a9002fdb0) at /data/src/10.2/sql/log.cc:7082

#9  0x00005596404d8283 in MYSQL_BIN_LOG::write_transaction_or_stmt (this=0x559641707300 <mysql_bin_log>, entry=0x7f5ae69e4910, commit_id=0) at /data/src/10.2/sql/log.cc:8124

#10 0x00005596404d7579 in MYSQL_BIN_LOG::trx_group_commit_leader (this=0x559641707300 <mysql_bin_log>, leader=0x7f5ae69e4910) at /data/src/10.2/sql/log.cc:7840

#11 0x00005596404d6ebd in MYSQL_BIN_LOG::write_transaction_to_binlog_events (this=0x559641707300 <mysql_bin_log>, entry=0x7f5ae69e4910) at /data/src/10.2/sql/log.cc:7641

#12 0x00005596404d64e8 in MYSQL_BIN_LOG::write_transaction_to_binlog (this=0x559641707300 <mysql_bin_log>, thd=0x7f5a90000af0, cache_mngr=0x7f5a9002fc10, end_ev=0x7f5ae69e4ab0, all=true, using_stmt_cache=false, using_trx_cache=true) at /data/src/10.2/sql/log.cc:7310

#13 0x00005596404c7b14 in binlog_flush_cache (thd=0x7f5a90000af0, cache_mngr=0x7f5a9002fc10, end_ev=0x7f5ae69e4ab0, all=true, using_stmt=false, using_trx=true) at /data/src/10.2/sql/log.cc:1743

#14 0x00005596404c7f75 in binlog_rollback_flush_trx_cache (thd=0x7f5a90000af0, all=true, cache_mngr=0x7f5a9002fc10) at /data/src/10.2/sql/log.cc:1831

#15 0x00005596404c8930 in binlog_rollback (hton=0x5596432a97a0, thd=0x7f5a90000af0, all=true) at /data/src/10.2/sql/log.cc:2089

#16 0x00005596403cd8c8 in ha_rollback_trans (thd=0x7f5a90000af0, all=true) at /data/src/10.2/sql/handler.cc:1707

#17 0x00005596402b6946 in trans_rollback (thd=0x7f5a90000af0) at /data/src/10.2/sql/transaction.cc:415

#18 0x000055964010682e in THD::cleanup (this=0x7f5a90000af0) at /data/src/10.2/sql/sql_class.cc:1381

#19 0x000055964005c3bc in unlink_thd (thd=0x7f5a90000af0) at /data/src/10.2/sql/mysqld.cc:2916

#20 0x000055964005c862 in one_thread_per_connection_end (thd=0x7f5a90000af0, put_in_cache=true) at /data/src/10.2/sql/mysqld.cc:3061

#21 0x00005596402a12f1 in do_handle_one_connection (connect=0x55964386ad50) at /data/src/10.2/sql/sql_connect.cc:1355

#22 0x00005596402a0f76 in handle_one_connection (arg=0x55964386ad50) at /data/src/10.2/sql/sql_connect.cc:1241

#23 0x0000559640ab756c in pfs_spawn_thread (arg=0x5596437b7fc0) at /data/src/10.2/storage/perfschema/pfs.cc:1869

#24 0x00007f5aee3b24a4 in start_thread (arg=0x7f5ae69e5700) at pthread_create.c:456

#25 0x00007f5aec4e6d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97