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

Assertion `!m_innodb' failed in ha_partition::cmp_ref upon SELECT

Details

    Description

      --source include/have_innodb.inc
      --source include/have_partition.inc 
       
      CREATE TABLE t1 ( b1 varchar(5) , c1 varchar(25) , id int , KEY b1 (b1)) engine=innodb ;
      INSERT INTO t1 VALUES ('s','v',7),('t','v',5);
       
      CREATE TABLE t2 ( b1 varchar(5) , id int , i1 int , x varchar(5) , d1 datetime , KEY id (id), KEY b1 (b1)) engine=innodb
       partition by range  columns(i1,x)
      subpartition by hash (to_seconds(d1))
      subpartitions 3
      (partition p0 values less than (2,'b') engine = innodb,
       partition p1 values less than (4,'d') engine = innodb,
       partition p2 values less than (10,'za') engine = innodb);
       
      INSERT INTO t2 VALUES ('j',3,1,'l','1995-05-19 13:24:48'),('s',9,0,'y','2009-03-26 05:09:36'),('f',2,NULL,'u','1981-06-21 09:08:48'),('t',0,NULL,'null','1990-07-02 19:10:24'),('k',5,NULL,'h','2014-09-22 03:48:48'),('e',0,NULL,'null','2036-11-01 01:32:00'),('m',3,1,'v','2025-11-10 16:08:48'),('p',9,0,'null','1974-04-06 12:31:12'),('s',4,NULL,'f','2006-04-01 06:22:24'),('e',6,NULL,'g','2000-09-02 15:26:24'),('b',9,NULL,'j','2019-12-24 13:09:36'),('b',7,NULL,'j','2025-02-24 06:13:36'),('q',0,0,'v','2030-12-03 13:28:48'),('y',7,NULL,'i','2018-05-31 06:54:24'),('i',5,NULL,'l','2035-12-11 15:49:36'),('l',5,1,'t','2021-11-28 23:17:36'),('k',5,NULL,'o','2023-08-08 19:48:48'),('x',1,NULL,'a','1996-03-30 19:40:00'),('y',6,NULL,'n','1993-03-20 21:35:12'),('b',1,NULL,'t','2022-12-06 00:34:24'),('null',6,NULL,'x','2026-03-22 15:43:12'),('null',1,NULL,'null','2029-11-26 12:12:00'),('m',7,0,'h','2026-08-22 03:48:48'),('x',9,NULL,'b','2016-09-13 15:32:48'),('r',3,0,'i','1990-08-27 13:12:00'),('u',5,NULL,'null','2009-08-04 02:25:36'),('c',7,NULL,'k','1992-04-14 17:53:36'),('n',0,NULL,'null','2029-12-12 10:29:36'),('h',3,NULL,'h','2022-08-19 23:26:24'),('q',0,NULL,'f','2010-12-08 13:54:24'),('b',7,NULL,'b','1995-02-23 04:24:48'),('l',8,0,'a','1973-12-20 13:41:36'),('g',2,1,'k','2017-03-28 08:17:36'),('k',3,1,'t','1989-12-16 18:48:48'),('null',4,1,'n','2031-03-11 09:51:12'),('o',7,0,'g','2018-03-18 06:58:24'),('x',2,NULL,'v','1972-08-29 16:53:36'),('o',5,NULL,'z','1995-01-12 02:04:00'),('o',9,NULL,'h','2001-12-03 23:43:12'),('l',6,0,'a','1982-06-19 07:58:24'),('f',9,NULL,'l','1970-02-05 07:30:24'),('z',0,NULL,'m','1989-04-08 05:44:00'),('h',3,0,'s','2031-07-22 13:44:00'),('s',3,NULL,'x','1970-05-03 22:07:12'),('g',5,NULL,'m','1976-05-21 11:40:00'),('k',3,0,'k','2009-01-03 07:04:48'),('r',8,NULL,'k','1981-10-14 06:07:12'),('i',5,NULL,'j','2030-09-17 05:37:36'),('w',8,NULL,'x','2024-06-16 17:08:48'),('null',2,NULL,'n','2019-12-26 19:46:24'),('null',9,1,'j','1992-04-26 02:57:36'),('j',3,0,'m','2002-10-22 00:30:24'),('h',7,1,'s','2019-01-10 09:19:12'),('c',5,NULL,'z','2033-05-26 03:16:48'),('x',4,NULL,'n','2002-08-11 08:11:12'),('s',2,NULL,'null','2035-03-20 10:04:00'),('e',3,1,'m','2011-02-25 02:04:00'),('p',4,NULL,'y','2021-12-30 19:52:48'),('u',4,1,'w','1997-02-13 12:50:24'),('null',6,NULL,'h','1977-05-06 22:07:12'),('v',9,1,'f','2007-10-25 13:37:36'),('null',4,NULL,'j','2008-05-07 03:04:00'),('m',8,NULL,'j','2004-11-25 16:53:36'),('u',1,1,'b','1990-10-18 20:18:24'),('e',7,0,'x','2022-08-30 05:12:00'),('l',9,NULL,'null','2034-08-18 13:24:48'),('null',9,1,'v','2001-09-19 22:28:48'),('v',6,1,'o','1986-10-15 12:37:36'),('u',1,NULL,'c','2021-12-30 19:52:48'),('t',0,NULL,'g','2029-10-14 07:32:48'),('x',4,1,'null','2011-10-08 09:47:12'),('h',4,NULL,'o','1983-02-12 02:04:00'),('o',5,NULL,'h','1981-05-13 16:43:12'),('l',6,NULL,'u','1989-08-05 16:56:00'),('y',1,NULL,'o','1999-03-25 19:27:12'),('w',4,NULL,'null','1979-10-01 03:33:36'),('a',7,NULL,'null','2009-03-12 13:28:48'),('y',8,NULL,'null','2007-10-02 19:29:36'),('o',2,NULL,'null','2008-04-30 07:13:36'),('c',5,NULL,'d','2032-10-06 00:43:12'),('x',0,NULL,'b','1982-10-23 14:00:48'),('null',2,0,'a','2023-04-07 22:41:36'),('q',9,NULL,'s','1996-06-11 16:17:36'),('d',8,0,'s','1996-01-30 12:24:48'),('d',8,1,'g','2027-07-18 02:44:48'),('c',4,NULL,'e','1999-03-27 16:57:52'),('m',5,0,'y','1979-07-02 21:13:52'),('x',8,NULL,'s','2001-04-23 12:12:16'),('o',8,NULL,'s','1982-01-12 21:33:04'),('h',8,NULL,'x','1988-07-08 19:01:52'),('j',2,1,'c','2020-11-21 12:54:40'),('i',4,1,'w','2012-12-19 00:45:04'),('g',7,NULL,'j','1999-05-24 18:36:16'),('j',6,NULL,'v','1997-01-05 11:18:40'),('null',7,0,'c','2031-01-29 01:42:40'),('q',0,NULL,'k','2018-01-21 03:50:40'),('s',4,1,'g','1997-01-30 12:03:28'),('y',6,NULL,'null','2033-09-14 06:13:52'),('null',4,NULL,'e','1975-07-18 21:45:52'),('j',6,NULL,'null','2011-05-01 17:45:04'),('null',4,NULL,'p','1984-06-01 08:09:04'),('null',2,NULL,'r','1976-09-01 15:28:16'),('n',7,NULL,'v','1995-01-11 16:57:52'),('y',1,0,'a','1999-06-26 18:29:52'),('m',2,NULL,'i','1992-08-18 15:49:52'),('d',5,NULL,'o','2013-01-17 14:43:28'),('s',9,NULL,'m','1983-11-10 15:15:28'),('null',9,NULL,'null','2036-03-12 10:33:52'),('null',0,1,'n','1984-11-15 13:13:52'),('r',0,1,'o','1977-01-28 16:38:40'),('t',7,1,'e','1994-12-25 15:21:52'),('k',2,NULL,'m','1975-11-07 09:49:04'),('k',4,0,'z','2030-02-14 21:52:16'),('q',2,NULL,'m','2009-11-27 17:36:16'),('p',9,NULL,'t','1973-06-06 08:32:16'),('q',4,NULL,'s','1997-11-25 17:42:40'),('o',2,NULL,'w','2025-10-14 00:41:04'),('null',8,1,'null','1982-01-26 13:13:52'),('null',9,NULL,'null','1970-06-22 14:30:40'),('j',7,NULL,'y','1984-04-10 00:02:40'),('u',8,NULL,'c','1977-08-15 19:18:40'),('l',4,0,'r','2011-09-30 01:32:16'),('null',5,0,'null','1997-10-08 23:49:52'),('null',7,0,'j','2020-03-03 17:04:16'),('g',5,1,'q','1975-01-29 05:45:52'),('null',6,NULL,'null','2004-02-20 13:39:28'),('q',1,NULL,'i','1998-05-08 14:52:16'),('q',5,NULL,'o','1987-08-18 09:19:28'),('null',8,0,'null','2037-09-14 03:59:28'),('h',4,NULL,'j','1993-05-28 23:11:28'),('n',0,NULL,'f','2008-05-05 14:39:28'),('null',8,1,'x','2018-02-02 16:13:04'),('m',3,NULL,'w','2032-05-25 12:44:16'),('null',7,1,'null','2029-01-09 06:37:04'),('l',5,NULL,'y','2018-06-21 12:37:52'),('null',2,NULL,'b','2010-06-10 08:02:40'),('null',6,0,'m','1977-11-08 00:00:16'),('y',9,1,'null','2023-03-19 04:22:40'),('y',5,0,'null','2020-11-23 19:31:28'),('g',0,NULL,'i','1988-10-19 03:37:52'),('g',0,NULL,'null','2019-06-29 17:13:04'),('f',0,0,'d','2001-04-18 22:58:40'),('x',1,0,'null','2027-10-07 15:43:28'),('f',6,1,'k','2022-07-28 23:30:40'),('v',6,NULL,'b','2022-10-15 11:40:16'),('k',2,NULL,'i','0000-00-00 00:00:00'),('o',9,0,'l','0000-00-00 00:00:00'),('a',3,0,'a','0000-00-00 00:00:00'),('null',3,NULL,'a','0000-00-00 00:00:00'),('null',7,NULL,'z','0000-00-00 00:00:00'),('c',9,0,'g','0000-00-00 00:00:00'),('l',3,NULL,'u','0000-00-00 00:00:00'),('b',2,1,'z','0000-00-00 00:00:00'),('i',4,1,'k','0000-00-00 00:00:00'),('n',7,0,'t','0000-00-00 00:00:00'),('c',1,1,'k','0000-00-00 00:00:00'),('e',0,0,'r','0000-00-00 00:00:00'),('null',3,NULL,'k','0000-00-00 00:00:00'),('j',2,1,'r','0000-00-00 00:00:00'),('a',7,NULL,'v','0000-00-00 00:00:00'),('n',3,0,'null','0000-00-00 00:00:00'),('a',3,0,'b','0000-00-00 00:00:00'),('g',8,NULL,'e','0000-00-00 00:00:00'),('d',4,NULL,'f','0000-00-00 00:00:00'),('e',9,0,'z','0000-00-00 00:00:00'),('r',8,NULL,'j','0000-00-00 00:00:00'),('x',7,1,'u','0000-00-00 00:00:00'),('e',5,NULL,'i','0000-00-00 00:00:00'),('t',2,NULL,'d','0000-00-00 00:00:00'),('null',2,NULL,'w','0000-00-00 00:00:00'),('o',4,NULL,'c','0000-00-00 00:00:00'),('p',4,NULL,'c','0000-00-00 00:00:00'),('s',6,NULL,'t','0000-00-00 00:00:00'),('p',5,NULL,'j','0000-00-00 00:00:00'),('z',6,0,'n','0000-00-00 00:00:00'),('f',2,1,'s','0000-00-00 00:00:00'),('null',4,NULL,'null','0000-00-00 00:00:00'),('g',2,NULL,'null','0000-00-00 00:00:00'),('z',4,1,'j','0000-00-00 00:00:00'),('q',3,0,'a','0000-00-00 00:00:00'),('s',3,1,'k','0000-00-00 00:00:00'),('u',9,NULL,'null','0000-00-00 00:00:00'),('h',5,NULL,'g','0000-00-00 00:00:00'),('s',3,0,'q','0000-00-00 00:00:00'),('y',3,0,'u','0000-00-00 00:00:00'),('p',3,NULL,'c','0000-00-00 00:00:00'),('k',0,NULL,'o','0000-00-00 00:00:00'),('i',7,1,'c','0000-00-00 00:00:00'),('n',7,NULL,'null','0000-00-00 00:00:00'),('null',0,1,'null','0000-00-00 00:00:00'),('v',0,0,'u','0000-00-00 00:00:00'),('e',3,0,'f','0000-00-00 00:00:00'),('null',1,NULL,'null','0000-00-00 00:00:00'),('q',1,NULL,'l','0000-00-00 00:00:00'),('null',2,NULL,'b','0000-00-00 00:00:00'),('b',4,0,'null','0000-00-00 00:00:00'),('r',9,NULL,'t','0000-00-00 00:00:00'),('z',5,NULL,'v','0000-00-00 00:00:00'),('p',7,NULL,'v','0000-00-00 00:00:00'),('null',5,0,'k','0000-00-00 00:00:00'),('z',5,NULL,'w','0000-00-00 00:00:00'),('n',3,NULL,'x','1998-10-21 08:32:32'),('null',3,NULL,'i','0000-00-00 00:00:00'),('e',5,NULL,'f','0000-00-00 00:00:00'),('c',1,NULL,'t','0000-00-00 00:00:00'),('f',9,NULL,'null','0000-00-00 00:00:00'),('n',6,1,'j','0000-00-00 00:00:00'),('null',7,NULL,'a','0000-00-00 00:00:00'),('null',7,0,'null','0000-00-00 00:00:00'),('y',1,0,'l','0000-00-00 00:00:00'),('h',8,NULL,'e','0000-00-00 00:00:00'),('v',7,NULL,'g','0000-00-00 00:00:00'),('f',0,NULL,'null','0000-00-00 00:00:00'),('v',5,NULL,'x','0000-00-00 00:00:00'),('null',3,NULL,'c','0000-00-00 00:00:00'),('v',7,NULL,'f','0000-00-00 00:00:00'),('v',8,NULL,'y','0000-00-00 00:00:00'),('null',0,NULL,'o','0000-00-00 00:00:00'),('c',0,NULL,'f','0000-00-00 00:00:00'),('null',5,NULL,'i','0000-00-00 00:00:00'),('z',2,1,'q','0000-00-00 00:00:00'),('null',9,NULL,'z','0000-00-00 00:00:00'),('p',7,NULL,'a','0000-00-00 00:00:00'),('h',8,NULL,'x','0000-00-00 00:00:00'),('y',5,NULL,'d','0000-00-00 00:00:00'),('null',9,NULL,'f','0000-00-00 00:00:00'),('j',5,NULL,'null','0000-00-00 00:00:00'),('y',3,NULL,'p','0000-00-00 00:00:00'),('e',2,0,'null','0000-00-00 00:00:00'),('a',5,1,'f','2010-04-25 10:40:32'),('null',3,NULL,'e','0000-00-00 00:00:00'),('z',9,NULL,'t','1992-08-11 10:53:20'),('a',2,NULL,'w','0000-00-00 00:00:00'),('z',0,NULL,'s','0000-00-00 00:00:00'),('p',9,0,'e','0000-00-00 00:00:00'),('h',5,0,'null','0000-00-00 00:00:00'),('p',4,NULL,'k','0000-00-00 00:00:00'),('r',9,NULL,'a','0000-00-00 00:00:00'),('q',6,0,'z','0000-00-00 00:00:00'),('g',8,NULL,'x','0000-00-00 00:00:00'),('v',7,NULL,'g','0000-00-00 00:00:00'),('l',3,0,'null','0000-00-00 00:00:00'),('j',9,NULL,'r','0000-00-00 00:00:00'),('null',8,NULL,'t','0000-00-00 00:00:00'),('s',0,NULL,'z','0000-00-00 00:00:00'),('null',2,NULL,'v','0000-00-00 00:00:00'),('null',3,1,'m','0000-00-00 00:00:00'),('null',1,NULL,'u','0000-00-00 00:00:00'),('t',8,1,'o','0000-00-00 00:00:00'),('l',4,2,'a','0000-00-00 00:00:00'),('null',9,2,'a','0000-00-00 00:00:00'),('o',5,NULL,'y','0000-00-00 00:00:00'),('null',9,NULL,'g','0000-00-00 00:00:00'),('null',6,NULL,'t','0000-00-00 00:00:00'),('c',5,NULL,'null','0000-00-00 00:00:00'),('null',5,1,'x','0000-00-00 00:00:00'),('h',0,NULL,'u','1986-08-05 06:24:32'),('r',8,1,'n','0000-00-00 00:00:00'),('t',1,NULL,'m','0000-00-00 00:00:00'),('s',0,NULL,'r','0000-00-00 00:00:00'),('g',2,NULL,'s','0000-00-00 00:00:00'),('f',2,NULL,'y','0000-00-00 00:00:00'),('p',8,0,'b','0000-00-00 00:00:00'),('k',8,1,'null','0000-00-00 00:00:00'),('null',5,NULL,'null','0000-00-00 00:00:00'),('g',6,NULL,'f','0000-00-00 00:00:00'),('k',2,0,'u','0000-00-00 00:00:00'),('y',1,NULL,'x','2035-08-27 03:06:08'),('null',6,NULL,'null','0000-00-00 00:00:00'),('z',9,NULL,'null','0000-00-00 00:00:00'),('n',1,1,'g','0000-00-00 00:00:00'),('k',6,NULL,'n','0000-00-00 00:00:00'),('null',2,0,'x','0000-00-00 00:00:00'),('null',6,0,'v','0000-00-00 00:00:00'),('p',8,NULL,'null','0000-00-00 00:00:00'),('null',1,0,'s','0000-00-00 00:00:00'),('d',6,0,'null','0000-00-00 00:00:00'),('m',6,0,'i','0000-00-00 00:00:00'),('v',9,NULL,'w','0000-00-00 00:00:00'),('l',9,NULL,'q','2038-01-10 01:46:56'),('q',5,0,'y','0000-00-00 00:00:00'),('null',9,NULL,'t','0000-00-00 00:00:00'),('k',9,0,'x','0000-00-00 00:00:00'),('null',2,NULL,'null','0000-00-00 00:00:00'),('null',8,NULL,'c','2035-09-09 18:46:56'),('v',7,NULL,'o','0000-00-00 00:00:00'),('p',8,0,'u','2014-02-27 10:06:08'),('f',5,NULL,'i','0000-00-00 00:00:00'),('x',7,0,'e','0000-00-00 00:00:00'),('null',9,NULL,'z','0000-00-00 00:00:00'),('v',7,NULL,'i','0000-00-00 00:00:00'),('null',8,NULL,'t','0000-00-00 00:00:00'),('l',1,1,'t','0000-00-00 00:00:00'),('o',3,1,'k','0000-00-00 00:00:00'),('p',1,1,'null','0000-00-00 00:00:00'),('r',0,1,'g','0000-00-00 00:00:00'),('null',3,0,'null','0000-00-00 00:00:00'),('null',0,NULL,'w','0000-00-00 00:00:00'),('p',9,NULL,'null','0000-00-00 00:00:00'),('v',5,NULL,'u','0000-00-00 00:00:00'),('null',3,NULL,'x','0000-00-00 00:00:00'),('null',0,NULL,'k','0000-00-00 00:00:00'),('i',6,NULL,'x','0000-00-00 00:00:00'),('null',3,0,'t','0000-00-00 00:00:00'),('null',9,NULL,'null','0000-00-00 00:00:00'),('q',0,NULL,'i','0000-00-00 00:00:00'),('j',2,NULL,'p','0000-00-00 00:00:00'),('r',1,NULL,'z','0000-00-00 00:00:00'),('l',9,NULL,'null','0000-00-00 00:00:00'),('m',5,0,'p','0000-00-00 00:00:00'),('null',7,NULL,'j','0000-00-00 00:00:00'),('w',9,NULL,'b','2002-06-21 12:29:20'),('s',1,NULL,'null','0000-00-00 00:00:00'),('b',8,0,'t','0000-00-00 00:00:00'),('null',2,NULL,'d','0000-00-00 00:00:00'),('l',3,NULL,'null','0000-00-00 00:00:00'),('p',8,NULL,'q','0000-00-00 00:00:00'),('h',6,1,'h','0000-00-00 00:00:00'),('b',6,0,'w','0000-00-00 00:00:00'),('null',1,NULL,'k','0000-00-00 00:00:00'),('v',2,1,'o','0000-00-00 00:00:00'),('t',7,0,'i','0000-00-00 00:00:00'),('p',1,1,'n','0000-00-00 00:00:00'),('l',4,0,'y','0000-00-00 00:00:00'),('v',0,0,'m','0000-00-00 00:00:00'),('x',8,NULL,'c','1971-05-06 19:16:32'),('o',2,0,'k','0000-00-00 00:00:00'),('v',2,NULL,'x','0000-00-00 00:00:00'),('w',3,NULL,'null','0000-00-00 00:00:00'),('o',6,1,'m','0000-00-00 00:00:00'),('d',8,NULL,'e','0000-00-00 00:00:00'),('w',7,1,'g','0000-00-00 00:00:00'),('z',3,1,'r','0000-00-00 00:00:00'),('e',7,NULL,'y','0000-00-00 00:00:00'),('w',3,NULL,'t','0000-00-00 00:00:00'),('null',2,NULL,'v','0000-00-00 00:00:00'),('j',8,NULL,'b','0000-00-00 00:00:00'),('k',0,NULL,'v','0000-00-00 00:00:00'),('null',6,NULL,'x','0000-00-00 00:00:00'),('j',6,0,'h','0000-00-00 00:00:00'),('u',7,1,'j','0000-00-00 00:00:00'),('null',7,0,'q','0000-00-00 00:00:00'),('x',8,NULL,'t','0000-00-00 00:00:00'),('h',0,0,'t','0000-00-00 00:00:00'),('o',4,0,'o','0000-00-00 00:00:00'),('m',7,NULL,'w','0000-00-00 00:00:00'),('r',8,0,'null','0000-00-00 00:00:00'),('s',4,NULL,'g','2006-07-17 14:18:08'),('t',3,NULL,'g','0000-00-00 00:00:00'),('z',8,NULL,'o','0000-00-00 00:00:00'),('f',1,1,'u','0000-00-00 00:00:00'),('null',2,1,'j','0000-00-00 00:00:00'),('y',7,NULL,'w','1980-01-19 21:24:32'),('d',0,NULL,'n','0000-00-00 00:00:00'),('t',6,1,'null','0000-00-00 00:00:00'),('b',7,NULL,'p','2016-06-27 12:29:20'),('c',3,1,'g','0000-00-00 00:00:00'),('null',2,1,'y','0000-00-00 00:00:00'),('null',4,NULL,'q','0000-00-00 00:00:00'),('b',2,1,'t','0000-00-00 00:00:00'),('r',2,0,'f','0000-00-00 00:00:00'),('z',1,1,'v','0000-00-00 00:00:00'),('null',9,1,'b','0000-00-00 00:00:00'),('null',6,0,'d','0000-00-00 00:00:00'),('f',8,1,'u','0000-00-00 00:00:00'),('q',3,1,'null','0000-00-00 00:00:00'),('f',4,NULL,'w','0000-00-00 00:00:00'),('l',5,0,'s','0000-00-00 00:00:00'),('s',2,NULL,'i','0000-00-00 00:00:00'),('null',0,NULL,'y','0000-00-00 00:00:00'),('b',7,0,'null','0000-00-00 00:00:00'),('e',8,NULL,'v','0000-00-00 00:00:00'),('null',5,0,'y','0000-00-00 00:00:00'),('g',6,0,'p','0000-00-00 00:00:00'),('v',6,1,'j','0000-00-00 00:00:00'),('null',5,NULL,'r','0000-00-00 00:00:00'),('null',1,NULL,'null','0000-00-00 00:00:00'),('null',7,NULL,'o','0000-00-00 00:00:00'),('s',7,NULL,'null','0000-00-00 00:00:00'),('m',8,NULL,'q','0000-00-00 00:00:00'),('null',3,0,'y','0000-00-00 00:00:00'),('i',5,0,'null','0000-00-00 00:00:00'),('z',7,1,'m','0000-00-00 00:00:00'),('f',9,NULL,'null','0000-00-00 00:00:00'),('w',2,0,'i','0000-00-00 00:00:00'),('y',8,NULL,'s','0000-00-00 00:00:00'),('l',6,NULL,'h','0000-00-00 00:00:00'),('o',5,1,'h','0000-00-00 00:00:00'),('null',0,NULL,'x','0000-00-00 00:00:00'),('r',0,0,'w','0000-00-00 00:00:00'),('null',4,1,'f','2020-05-29 23:34:56'),('o',4,NULL,'u','0000-00-00 00:00:00'),('y',2,NULL,'null','0000-00-00 00:00:00'),('p',4,NULL,'x','0000-00-00 00:00:00'),('p',3,NULL,'j','0000-00-00 00:00:00'),('null',4,0,'u','0000-00-00 00:00:00'),('d',3,NULL,'w','0000-00-00 00:00:00'),('i',5,NULL,'k','0000-00-00 00:00:00'),('n',7,1,'u','0000-00-00 00:00:00'),('t',1,1,'k','0000-00-00 00:00:00'),('e',5,NULL,'n','0000-00-00 00:00:00'),('q',9,NULL,'u','0000-00-00 00:00:00'),('t',0,1,'p','0000-00-00 00:00:00'),('w',7,NULL,'null','0000-00-00 00:00:00'),('r',0,0,'h','0000-00-00 00:00:00'),('e',6,1,'c','0000-00-00 00:00:00'),('v',7,1,'v','0000-00-00 00:00:00'),('t',5,NULL,'g','0000-00-00 00:00:00'),('null',4,NULL,'h','0000-00-00 00:00:00'),('t',9,NULL,'g','0000-00-00 00:00:00'),('a',5,NULL,'c','0000-00-00 00:00:00'),('b',1,NULL,'p','0000-00-00 00:00:00'),('n',7,1,'null','0000-00-00 00:00:00'),('q',0,1,'q','0000-00-00 00:00:00'),('c',4,NULL,'h','0000-00-00 00:00:00'),('r',7,0,'g','0000-00-00 00:00:00'),('p',3,0,'x','0000-00-00 00:00:00'),('n',6,NULL,'null','0000-00-00 00:00:00'),('f',4,NULL,'r','0000-00-00 00:00:00'),('s',9,NULL,'r','0000-00-00 00:00:00'),('i',4,NULL,'k','0000-00-00 00:00:00'),('k',1,NULL,'q','0000-00-00 00:00:00'),('j',9,0,'m','0000-00-00 00:00:00'),('x',2,NULL,'i','0000-00-00 00:00:00'),('z',5,NULL,'null','0000-00-00 00:00:00'),('null',4,NULL,'j','0000-00-00 00:00:00'),('s',3,1,'g','0000-00-00 00:00:00'),('h',6,0,'x','0000-00-00 00:00:00'),('c',0,1,'null','0000-00-00 00:00:00'),('z',8,NULL,'k','0000-00-00 00:00:00'),('z',0,1,'f','0000-00-00 00:00:00'),('z',3,NULL,'t','0000-00-00 00:00:00'),('t',9,NULL,'j','0000-00-00 00:00:00'),('w',5,1,'null','0000-00-00 00:00:00'),('null',0,NULL,'h','0000-00-00 00:00:00'),('n',0,1,'null','1979-08-31 19:22:56'),('t',6,0,'null','1987-04-15 23:47:44'),('f',8,NULL,'r','0000-00-00 00:00:00'),('l',9,NULL,'null','0000-00-00 00:00:00'),('null',8,0,'h','0000-00-00 00:00:00'),('u',5,0,'v','1982-07-04 12:03:44'),('v',4,1,'p','0000-00-00 00:00:00'),('p',9,0,'c','0000-00-00 00:00:00'),('g',9,1,'null','0000-00-00 00:00:00'),('null',6,NULL,'j','0000-00-00 00:00:00'),('k',6,NULL,'null','0000-00-00 00:00:00'),('y',5,0,'w','0000-00-00 00:00:00'),('e',3,0,'null','0000-00-00 00:00:00'),('null',5,1,'s','0000-00-00 00:00:00'),('null',9,NULL,'s','0000-00-00 00:00:00'),('t',8,NULL,'o','0000-00-00 00:00:00'),('c',6,NULL,'w','0000-00-00 00:00:00'),('n',0,0,'k','0000-00-00 00:00:00'),('y',8,0,'c','0000-00-00 00:00:00'),('g',4,NULL,'v','0000-00-00 00:00:00'),('j',9,1,'t','0000-00-00 00:00:00'),('c',9,1,'i','0000-00-00 00:00:00'),('i',2,0,'f','0000-00-00 00:00:00'),('r',7,NULL,'j','0000-00-00 00:00:00'),('y',2,NULL,'x','0000-00-00 00:00:00'),('null',2,NULL,'n','0000-00-00 00:00:00'),('null',1,NULL,'u','0000-00-00 00:00:00'),('t',7,1,'m','0000-00-00 00:00:00'),('null',2,NULL,'s','0000-00-00 00:00:00'),('o',2,NULL,'f','0000-00-00 00:00:00'),('u',7,NULL,'j','0000-00-00 00:00:00'),('a',9,NULL,'null','0000-00-00 00:00:00'),('n',4,NULL,'d','0000-00-00 00:00:00'),('g',9,NULL,'e','0000-00-00 00:00:00'),('k',6,0,'w','0000-00-00 00:00:00'),('null',0,NULL,'q','0000-00-00 00:00:00'),('l',7,NULL,'d','0000-00-00 00:00:00'),('g',0,0,'g','0000-00-00 00:00:00'),('m',6,1,'k','0000-00-00 00:00:00'),('t',7,NULL,'v','0000-00-00 00:00:00'),('o',3,NULL,'u','0000-00-00 00:00:00'),('p',2,1,'x','0000-00-00 00:00:00'),('w',2,0,'d','0000-00-00 00:00:00'),('v',0,NULL,'null','0000-00-00 00:00:00'),('l',3,NULL,'g','0000-00-00 00:00:00'),('t',6,NULL,'t','0000-00-00 00:00:00'),('e',4,0,'a','0000-00-00 00:00:00'),('y',7,1,'e','0000-00-00 00:00:00'),('g',6,NULL,'i','0000-00-00 00:00:00'),('h',1,NULL,'h','0000-00-00 00:00:00'),('n',1,NULL,'x','0000-00-00 00:00:00'),('d',8,0,'c','0000-00-00 00:00:00'),('s',8,NULL,'r','0000-00-00 00:00:00'),('w',0,1,'null','0000-00-00 00:00:00'),('w',0,0,'c','0000-00-00 00:00:00'),('f',6,1,'c','0000-00-00 00:00:00'),('d',8,NULL,'d','0000-00-00 00:00:00'),('q',1,NULL,'null','0000-00-00 00:00:00'),('s',0,NULL,'null','1997-06-05 10:59:44'),('m',3,NULL,'i','0000-00-00 00:00:00'),('a',0,NULL,'q','0000-00-00 00:00:00'),('e',7,0,'b','0000-00-00 00:00:00'),('d',1,NULL,'null','0000-00-00 00:00:00'),('null',1,NULL,'null','0000-00-00 00:00:00'),('k',2,NULL,'x','0000-00-00 00:00:00'),('null',2,NULL,'null','0000-00-00 00:00:00'),('s',1,0,'g','0000-00-00 00:00:00'),('w',5,1,'x','0000-00-00 00:00:00'),('i',2,NULL,'w','0000-00-00 00:00:00'),('null',0,NULL,'d','0000-00-00 00:00:00'),('a',7,0,'z','0000-00-00 00:00:00'),('l',5,NULL,'f','0000-00-00 00:00:00'),('m',1,NULL,'null','0000-00-00 00:00:00'),('j',6,0,'a','0000-00-00 00:00:00'),('null',2,NULL,'r','0000-00-00 00:00:00'),('a',7,NULL,'null','0000-00-00 00:00:00'),('s',6,1,'v','0000-00-00 00:00:00'),('null',0,1,'b','0000-00-00 00:00:00'),('x',6,1,'f','0000-00-00 00:00:00'),('w',5,0,'z','0000-00-00 00:00:00'),('null',8,1,'null','0000-00-00 00:00:00'),('g',3,NULL,'null','0000-00-00 00:00:00'),('c',1,1,'null','0000-00-00 00:00:00'),('o',3,NULL,'s','0000-00-00 00:00:00'),('null',9,NULL,'q','0000-00-00 00:00:00'),('u',4,0,'k','0000-00-00 00:00:00'),('e',7,1,'b','0000-00-00 00:00:00'),('w',9,NULL,'c','0000-00-00 00:00:00'),('x',5,1,'j','0000-00-00 00:00:00'),('v',0,NULL,'y','0000-00-00 00:00:00'),('r',4,1,'y','0000-00-00 00:00:00'),('f',4,NULL,'null','0000-00-00 00:00:00'),('l',0,0,'g','0000-00-00 00:00:00'),('u',6,1,'null','0000-00-00 00:00:00'),('m',2,1,'g','0000-00-00 00:00:00'),('k',2,NULL,'null','0000-00-00 00:00:00'),('b',3,1,'null','0000-00-00 00:00:00'),('null',1,0,'i','0000-00-00 00:00:00'),('p',7,0,'r','2021-01-31 20:07:44'),('j',9,1,'g','0000-00-00 00:00:00'),('c',8,NULL,'null','0000-00-00 00:00:00'),('x',5,1,'x','0000-00-00 00:00:00'),('y',5,NULL,'null','0000-00-00 00:00:00'),('g',0,NULL,'w','0000-00-00 00:00:00'),('null',0,0,'r','0000-00-00 00:00:00'),('a',9,0,'e','0000-00-00 00:00:00'),('s',7,NULL,'null','0000-00-00 00:00:00'),('r',7,NULL,'r','0000-00-00 00:00:00'),('k',9,NULL,'a','2002-12-31 21:37:20'),('r',9,NULL,'f','0000-00-00 00:00:00'),('y',4,1,'e','0000-00-00 00:00:00'),('n',1,NULL,'g','0000-00-00 00:00:00'),('p',1,NULL,'u','0000-00-00 00:00:00'),('null',6,NULL,'w','0000-00-00 00:00:00'),('null',2,0,'h','0000-00-00 00:00:00'),('a',4,1,'n','0000-00-00 00:00:00'),('null',7,1,'e','0000-00-00 00:00:00'),('f',1,2,'a','0000-00-00 00:00:00'),('null',2,NULL,'null','0000-00-00 00:00:00'),('l',1,1,'null','0000-00-00 00:00:00'),('null',8,NULL,'i','2010-01-31 04:58:56'),('b',7,1,'b','0000-00-00 00:00:00'),('e',2,0,'null','0000-00-00 00:00:00'),('c',8,NULL,'t','2007-03-30 14:18:08'),('null',7,NULL,'w','0000-00-00 00:00:00'),('b',8,NULL,'o','0000-00-00 00:00:00'),('k',3,0,'x','0000-00-00 00:00:00'),('f',0,NULL,'a','0000-00-00 00:00:00'),('r',3,NULL,'e','0000-00-00 00:00:00'),('t',5,1,'u','0000-00-00 00:00:00'),('null',2,NULL,'z','0000-00-00 00:00:00'),('v',6,NULL,'h','0000-00-00 00:00:00'),('b',9,0,'null','0000-00-00 00:00:00'),('l',6,1,'z','0000-00-00 00:00:00'),('p',5,1,'h','0000-00-00 00:00:00'),('a',1,0,'l','0000-00-00 00:00:00'),('s',6,NULL,'null','0000-00-00 00:00:00'),('g',1,0,'c','1994-07-15 14:24:32'),('c',3,0,'r','0000-00-00 00:00:00'),('n',6,NULL,'null','0000-00-00 00:00:00'),('c',0,NULL,'f','0000-00-00 00:00:00'),('f',6,0,'p','0000-00-00 00:00:00'),('null',7,NULL,'k','0000-00-00 00:00:00'),('h',1,1,'w','0000-00-00 00:00:00'),('null',9,NULL,'c','0000-00-00 00:00:00'),('c',4,NULL,'t','0000-00-00 00:00:00'),('null',7,0,'null','0000-00-00 00:00:00'),('o',3,NULL,'u','0000-00-00 00:00:00'),('a',7,1,'null','0000-00-00 00:00:00'),('k',0,0,'null','0000-00-00 00:00:00'),('j',8,1,'d','0000-00-00 00:00:00'),('b',9,NULL,'f','0000-00-00 00:00:00'),('v',7,NULL,'e','0000-00-00 00:00:00'),('k',8,NULL,'null','0000-00-00 00:00:00'),('r',7,1,'s','0000-00-00 00:00:00'),('y',3,NULL,'h','0000-00-00 00:00:00'),('u',5,1,'null','0000-00-00 00:00:00'),('null',5,0,'r','0000-00-00 00:00:00'),('z',3,NULL,'w','0000-00-00 00:00:00'),('null',9,NULL,'e','0000-00-00 00:00:00'),('f',0,1,'null','0000-00-00 00:00:00'),('e',2,NULL,'null','0000-00-00 00:00:00'),('r',5,NULL,'null','0000-00-00 00:00:00'),('l',4,NULL,'i','0000-00-00 00:00:00'),('p',7,0,'f','0000-00-00 00:00:00'),('b',5,NULL,'e','0000-00-00 00:00:00'),('u',2,NULL,'x','0000-00-00 00:00:00'),('null',5,NULL,'q','0000-00-00 00:00:00'),('null',5,0,'v','0000-00-00 00:00:00'),('r',4,NULL,'o','0000-00-00 00:00:00'),('p',8,0,'j','0000-00-00 00:00:00'),('z',2,0,'p','0000-00-00 00:00:00'),('v',4,NULL,'x','0000-00-00 00:00:00'),('f',0,NULL,'c','0000-00-00 00:00:00'),('w',4,0,'r','0000-00-00 00:00:00'),('v',8,NULL,'a','0000-00-00 00:00:00'),('f',8,1,'l','0000-00-00 00:00:00'),('null',0,NULL,'h','2000-04-22 21:39:44'),('z',2,0,'null','0000-00-00 00:00:00'),('null',0,0,'a','2019-05-15 23:09:20'),('v',2,NULL,'u','0000-00-00 00:00:00'),('p',4,NULL,'q','0000-00-00 00:00:00'),('v',6,NULL,'o','0000-00-00 00:00:00'),('null',7,1,'e','0000-00-00 00:00:00'),('n',9,NULL,'null','0000-00-00 00:00:00'),('q',8,1,'k','0000-00-00 00:00:00'),('h',3,NULL,'d','0000-00-00 00:00:00'),('b',6,NULL,'f','0000-00-00 00:00:00'),('null',2,1,'u','0000-00-00 00:00:00'),('b',6,NULL,'g','0000-00-00 00:00:00'),('k',5,1,'x','0000-00-00 00:00:00'),('null',9,NULL,'m','0000-00-00 00:00:00'),('b',1,1,'x','0000-00-00 00:00:00'),('v',9,1,'k','0000-00-00 00:00:00'),('r',1,0,'x','0000-00-00 00:00:00'),('b',2,NULL,'null','0000-00-00 00:00:00'),('null',5,NULL,'i','0000-00-00 00:00:00'),('z',6,1,'null','0000-00-00 00:00:00'),('m',3,0,'z','0000-00-00 00:00:00'),('j',4,NULL,'o','0000-00-00 00:00:00'),('q',2,NULL,'z','0000-00-00 00:00:00'),('f',5,NULL,'n','0000-00-00 00:00:00'),('null',8,NULL,'null','0000-00-00 00:00:00'),('g',9,NULL,'t','0000-00-00 00:00:00'),('v',9,NULL,'null','0000-00-00 00:00:00'),('e',1,1,'a','0000-00-00 00:00:00'),('w',2,0,'n','0000-00-00 00:00:00'),('u',7,0,'r','0000-00-00 00:00:00'),('x',6,NULL,'y','0000-00-00 00:00:00'),('q',7,NULL,'f','0000-00-00 00:00:00'),('f',1,NULL,'z','2007-10-17 23:34:56'),('o',5,NULL,'null','0000-00-00 00:00:00'),('r',4,NULL,'p','1984-06-18 00:38:56'),('l',0,NULL,'d','0000-00-00 00:00:00'),('h',9,1,'f','0000-00-00 00:00:00'),('b',6,NULL,'null','0000-00-00 00:00:00'),('t',4,NULL,'z','1991-10-18 07:32:32'),('k',7,NULL,'null','2035-02-22 15:06:56'),('g',5,NULL,'g','0000-00-00 00:00:00'),('o',0,NULL,'z','2015-11-02 16:23:44'),('null',0,NULL,'h','0000-00-00 00:00:00'),('c',5,0,'l','0000-00-00 00:00:00'),('f',9,1,'f','0000-00-00 00:00:00'),('w',7,NULL,'p','0000-00-00 00:00:00'),('f',8,NULL,'y','0000-00-00 00:00:00'),('p',5,NULL,'x','0000-00-00 00:00:00'),('null',1,NULL,'null','0000-00-00 00:00:00'),('b',6,0,'c','0000-00-00 00:00:00'),('b',5,NULL,'q','0000-00-00 00:00:00'),('r',7,1,'null','0000-00-00 00:00:00'),('p',4,NULL,'null','0000-00-00 00:00:00'),('g',7,NULL,'null','0000-00-00 00:00:00'),('w',4,1,'r','0000-00-00 00:00:00'),('c',9,1,'c','0000-00-00 00:00:00'),('null',6,1,'m','0000-00-00 00:00:00'),('null',7,NULL,'j','0000-00-00 00:00:00'),('l',2,NULL,'o','0000-00-00 00:00:00'),('t',7,NULL,'u','0000-00-00 00:00:00'),('r',3,NULL,'x','0000-00-00 00:00:00'),('null',0,0,'j','0000-00-00 00:00:00'),('i',5,NULL,'null','0000-00-00 00:00:00'),('m',0,0,'s','0000-00-00 00:00:00'),('v',0,NULL,'i','0000-00-00 00:00:00'),('b',9,1,'t','0000-00-00 00:00:00'),('c',5,0,'l','0000-00-00 00:00:00'),('null',4,NULL,'null','0000-00-00 00:00:00'),('c',5,NULL,'p','0000-00-00 00:00:00'),('o',2,NULL,'c','0000-00-00 00:00:00'),('h',3,1,'o','0000-00-00 00:00:00'),('null',9,NULL,'m','0000-00-00 00:00:00'),('c',8,NULL,'r','0000-00-00 00:00:00'),('g',8,1,'v','0000-00-00 00:00:00'),('k',4,0,'m','0000-00-00 00:00:00'),('t',5,NULL,'h','0000-00-00 00:00:00'),('n',7,1,'null','0000-00-00 00:00:00'),('k',5,NULL,'l','0000-00-00 00:00:00'),('d',6,NULL,'b','0000-00-00 00:00:00'),('null',7,NULL,'null','0000-00-00 00:00:00'),('v',7,0,'c','0000-00-00 00:00:00'),('p',9,2,'a','0000-00-00 00:00:00'),('null',2,NULL,'null','0000-00-00 00:00:00'),('r',0,NULL,'q','0000-00-00 00:00:00'),('null',0,NULL,'i','0000-00-00 00:00:00'),('null',1,NULL,'c','0000-00-00 00:00:00'),('q',0,0,'a','0000-00-00 00:00:00'),('l',4,NULL,'null','0000-00-00 00:00:00'),('v',1,NULL,'c','0000-00-00 00:00:00'),('g',1,0,'h','0000-00-00 00:00:00'),('f',7,NULL,'b','0000-00-00 00:00:00'),('q',7,0,'m','0000-00-00 00:00:00'),('g',0,1,'q','0000-00-00 00:00:00'),('null',7,2,'a','0000-00-00 00:00:00'),('n',4,NULL,'i','0000-00-00 00:00:00'),('x',2,0,'i','0000-00-00 00:00:00'),('z',6,NULL,'v','0000-00-00 00:00:00'),('null',0,NULL,'g','0000-00-00 00:00:00'),('p',0,NULL,'m','0000-00-00 00:00:00'),('c',0,0,'h','0000-00-00 00:00:00'),('null',2,1,'x','0000-00-00 00:00:00'),('null',1,0,'l','0000-00-00 00:00:00'),('e',6,NULL,'n','0000-00-00 00:00:00'),('l',3,NULL,'h','0000-00-00 00:00:00'),('z',9,NULL,'null','0000-00-00 00:00:00'),('z',7,1,'null','2011-04-22 06:11:44'),('i',8,NULL,'m','0000-00-00 00:00:00'),('k',6,NULL,'x','0000-00-00 00:00:00'),('null',9,1,'r','0000-00-00 00:00:00'),('i',8,NULL,'o','0000-00-00 00:00:00'),('f',0,0,'a','0000-00-00 00:00:00'),('x',7,1,'u','0000-00-00 00:00:00'),('null',4,0,'p','0000-00-00 00:00:00'),('null',1,1,'b','0000-00-00 00:00:00'),('a',8,NULL,'o','0000-00-00 00:00:00'),('p',5,0,'m','0000-00-00 00:00:00'),('w',9,NULL,'null','0000-00-00 00:00:00'),('o',5,1,'y','0000-00-00 00:00:00'),('l',9,1,'f','0000-00-00 00:00:00'),('h',2,NULL,'w','0000-00-00 00:00:00'),('u',3,NULL,'h','0000-00-00 00:00:00'),('null',3,0,'q','0000-00-00 00:00:00'),('c',9,1,'null','0000-00-00 00:00:00'),('a',6,1,'o','0000-00-00 00:00:00'),('e',6,NULL,'p','0000-00-00 00:00:00'),('m',5,NULL,'null','0000-00-00 00:00:00'),('y',1,1,'g','2007-03-12 08:23:44'),('z',9,0,'i','0000-00-00 00:00:00'),('o',2,NULL,'b','0000-00-00 00:00:00'),('h',6,0,'h','0000-00-00 00:00:00'),('x',7,NULL,'null','0000-00-00 00:00:00'),('s',6,NULL,'g','0000-00-00 00:00:00'),('null',3,0,'a','0000-00-00 00:00:00'),('u',9,0,'null','0000-00-00 00:00:00'),('e',0,NULL,'k','0000-00-00 00:00:00'),('e',5,1,'null','0000-00-00 00:00:00'),('q',4,0,'y','0000-00-00 00:00:00'),('c',1,0,'null','0000-00-00 00:00:00'),('b',6,0,'k','0000-00-00 00:00:00'),('null',2,1,'z','2011-06-03 08:32:32'),('null',5,1,'r','0000-00-00 00:00:00'),('null',7,0,'i','0000-00-00 00:00:00'),('s',4,NULL,'null','0000-00-00 00:00:00'),('null',6,0,'s','0000-00-00 00:00:00'),('null',2,1,'c','0000-00-00 00:00:00'),('null',7,0,'h','0000-00-00 00:00:00'),('i',8,NULL,'i','0000-00-00 00:00:00'),('p',8,NULL,'y','0000-00-00 00:00:00'),('a',8,NULL,'d','2032-08-05 23:15:44'),('null',5,NULL,'h','0000-00-00 00:00:00'),('u',2,1,'a','0000-00-00 00:00:00'),('s',5,NULL,'x','0000-00-00 00:00:00'),('null',7,NULL,'null','0000-00-00 00:00:00'),('null',3,1,'null','0000-00-00 00:00:00'),('j',1,1,'e','0000-00-00 00:00:00'),('d',1,NULL,'v','0000-00-00 00:00:00'),('i',0,NULL,'u','0000-00-00 00:00:00'),('v',3,0,'n','1970-01-09 09:14:56'),('a',8,NULL,'r','0000-00-00 00:00:00'),('null',5,0,'i','0000-00-00 00:00:00'),('r',2,NULL,'h','0000-00-00 00:00:00'),('x',6,NULL,'m','0000-00-00 00:00:00'),('f',0,NULL,'d','0000-00-00 00:00:00'),('t',7,0,'o','0000-00-00 00:00:00'),('null',6,NULL,'i','0000-00-00 00:00:00'),('f',6,0,'g','0000-00-00 00:00:00'),('m',3,1,'w','0000-00-00 00:00:00'),('q',9,1,'r','0000-00-00 00:00:00'),('n',5,1,'s','0000-00-00 00:00:00'),('null',7,1,'z','0000-00-00 00:00:00'),('x',0,NULL,'y','0000-00-00 00:00:00'),('w',5,0,'u','0000-00-00 00:00:00'),('k',6,NULL,'o','0000-00-00 00:00:00'),('w',8,NULL,'c','2023-05-20 10:08:32'),('l',6,NULL,'c','0000-00-00 00:00:00'),('z',5,NULL,'q','0000-00-00 00:00:00'),('d',7,NULL,'e','0000-00-00 00:00:00'),('x',7,NULL,'d','0000-00-00 00:00:00'),('null',6,1,'b','0000-00-00 00:00:00'),('a',1,1,'d','2015-09-30 17:30:08'),('i',1,NULL,'m','0000-00-00 00:00:00'),('e',4,NULL,'o','0000-00-00 00:00:00'),('u',9,0,'o','0000-00-00 00:00:00'),('a',1,NULL,'x','0000-00-00 00:00:00'),('p',8,NULL,'m','0000-00-00 00:00:00'),('a',1,NULL,'a','0000-00-00 00:00:00'),('null',6,0,'c','0000-00-00 00:00:00'),('null',8,1,'y','0000-00-00 00:00:00'),('i',8,NULL,'null','0000-00-00 00:00:00'),('w',2,0,'null','0000-00-00 00:00:00'),('null',0,0,'a','0000-00-00 00:00:00'),('u',6,1,'k','0000-00-00 00:00:00'),('o',2,NULL,'null','0000-00-00 00:00:00'),('h',7,NULL,'x','0000-00-00 00:00:00'),('null',7,NULL,'n','0000-00-00 00:00:00'),('null',0,2,'a','0000-00-00 00:00:00'),('null',2,0,'null','0000-00-00 00:00:00'),('n',5,0,'o','0000-00-00 00:00:00'),('null',1,1,'c','0000-00-00 00:00:00'),('x',4,NULL,'j','0000-00-00 00:00:00'),('p',4,0,'a','0000-00-00 00:00:00'),('v',0,0,'v','0000-00-00 00:00:00'),('h',0,1,'x','0000-00-00 00:00:00'),('z',6,NULL,'o','0000-00-00 00:00:00'),('k',1,1,'r','0000-00-00 00:00:00'),('n',8,0,'q','0000-00-00 00:00:00'),('null',6,NULL,'h','0000-00-00 00:00:00'),('w',8,NULL,'null','0000-00-00 00:00:00');
       
      select 1 from t1 join t2  on t1.id = t2.id where t1.c1 in ('v') and t2.b1 > 's' and t2.b1 <= 'z';
      

      Version: '11.0.1-MariaDB-debug-log' 
      mariadbd: /sql/ha_partition.cc:10794: virtual int ha_partition::cmp_ref(const uchar*, const uchar*): Assertion `!m_innodb' failed.
      230217 12:39:34 [ERROR] mysqld got signal 6 ;
       
      Server version: 11.0.1-MariaDB-debug-log source revision: 80b4fa54e1d38c8f90f6b94240c583aa9d4627b7
       
      ??:0(__assert_fail)[0x7fe550bd0fd6]
      sql/ha_partition.cc:10795(ha_partition::cmp_ref(unsigned char const*, unsigned char const*))[0x55d5faabda6f]
      sql/sql_delete.cc:1114(refpos_order_cmp)[0x55d5f990a705]
      mysys/mf_qsort.c:165(my_qsort2)[0x55d5fb6b0171]
      sql/rowid_filter.h:344(Refpos_container_sorted_array::sort(int (*)(void*, void const*, void const*), void*))[0x55d5fa12fffd]
      sql/rowid_filter.h:379(Rowid_filter_sorted_array::sort(int (*)(void*, void const*, void const*), void*))[0x55d5fa130173]
      sql/rowid_filter.cc:628(Range_rowid_filter::fill())[0x55d5fa12f3a4]
      sql/rowid_filter.h:268(Range_rowid_filter::build())[0x55d5fa12fb3c]
      sql/sql_select.cc:15163(st_join_table::build_range_rowid_filter())[0x55d5f9b65499]
      sql/sql_select.cc:22746(sub_select(JOIN*, st_join_table*, bool))[0x55d5f9b9c451]
      sql/sql_select.cc:23019(evaluate_join_record(JOIN*, st_join_table*, int))[0x55d5f9b9e3ca]
      sql/sql_select.cc:22823(sub_select(JOIN*, st_join_table*, bool))[0x55d5f9b9d2b9]
      sql/sql_select.cc:22318(do_select(JOIN*, Procedure*))[0x55d5f9b9a9c0]
      sql/sql_select.cc:4877(JOIN::exec_inner())[0x55d5f9b1bb60]
      sql/sql_select.cc:4656(JOIN::exec())[0x55d5f9b19060]
      sql/sql_select.cc:5137(mysql_select(THD*, TABLE_LIST*, List<Item>&, Item*, unsigned int, st_order*, st_order*, Item*, st_order*, unsigned long long, select_result*, st_select_lex_unit*, st_select_lex*))[0x55d5f9b1d5cf]
      sql/sql_select.cc:608(handle_select(THD*, LEX*, select_result*, unsigned long long))[0x55d5f9aed505]
      sql/sql_parse.cc:6265(execute_sqlcom_select(THD*, TABLE_LIST*))[0x55d5f9a109b7]
      sql/sql_parse.cc:3949(mysql_execute_command(THD*, bool))[0x55d5f99ff2b0]
      sql/sql_parse.cc:8000(mysql_parse(THD*, char*, unsigned int, Parser_state*))[0x55d5f9a1b73a]
      sql/sql_parse.cc:1896(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool))[0x55d5f99f19e6]
      sql/sql_parse.cc:1407(do_command(THD*, bool))[0x55d5f99ee722]
      sql/sql_connect.cc:1416(do_handle_one_connection(CONNECT*, bool))[0x55d5f9eb8e75]
      sql/sql_connect.cc:1320(handle_one_connection)[0x55d5f9eb87d2]
      perfschema/pfs.cc:2203(pfs_spawn_thread)[0x55d5faad56f2]
      nptl/pthread_create.c:478(start_thread)[0x7fe5510eb609]
      

      on 11.0:

      select 1 from t1 join t2  on t1.id = t2.id where t1.c1 in ('v') and t2.b1 > 's' and t2.b1 <= 'z';
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	100.00	Using where
      1	SIMPLE	t2	ref|filter	id,b1	id|b1	5|8	test.t1.id	1 (22%)	22.01	Using where; Using rowid filter
      

      test does not fail with optimizer_switch='rowid_filter=off'

      on 10.11:

      explain extended select 1 from t1 join t2  on t1.id = t2.id where t1.c1 in ('v') and t2.b1 > 's' and t2.b1 <= 'z';
      id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
      1	SIMPLE	t1	ALL	NULL	NULL	NULL	NULL	2	100.00	Using where
      1	SIMPLE	t2	ref	id,b1	id	5	test.t1.id	1	21.98	Using where
      

      Attachments

        Issue Links

          Activity

            The assert it is failing:

              /*
                In Innodb we compare with either primary key value or global DB_ROW_ID so
                it is not possible that the two references are equal and are in different
                partitions, but in myisam it is possible since we are comparing offsets.
                Remove this assert if DB_ROW_ID is changed to be per partition.
              */
              DBUG_ASSERT(!m_innodb);
              DBUG_RETURN(diff2 > diff1 ? -1 : 1);
            

            That is, it has found two rows with identical rowids in two different partitions, and thinks that's an error...

            psergei Sergei Petrunia added a comment - The assert it is failing: /* In Innodb we compare with either primary key value or global DB_ROW_ID so it is not possible that the two references are equal and are in different partitions, but in myisam it is possible since we are comparing offsets. Remove this assert if DB_ROW_ID is changed to be per partition. */ DBUG_ASSERT(!m_innodb); DBUG_RETURN(diff2 > diff1 ? -1 : 1); That is, it has found two rows with identical rowids in two different partitions, and thinks that's an error...

            This looks like a consequence of the fix for MDEV-19506 which was done in 11.0:

            commit 944beb9e7acd53488dbfc7edc09bf29e10ce68ab
            Author:	Marko Mäkelä <marko.makela@mariadb.com>  Wed Dec 14 15:44:28 2022
            Committer:	Marko Mäkelä <marko.makela@mariadb.com>  Wed Jan 11 18:59:55 2023
             
            MDEV-19506 Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID
             
            InnoDB tables that lack a primary key (and any UNIQUE INDEX whose
            all columns are NOT NULL) will use an internally generated index,
            called GEN_CLUST_INDEX(DB_ROW_ID) in the InnoDB data dictionary,
            and hidden from the SQL layer.
             
            The 48-bit (6-byte) DB_ROW_ID is being assigned from a
            global sequence that is persisted in the DICT_HDR page.
             
            There is absolutely no reason for the DB_ROW_ID to be globally
            unique across all InnoDB tables.
            

            psergei Sergei Petrunia added a comment - This looks like a consequence of the fix for MDEV-19506 which was done in 11.0: commit 944beb9e7acd53488dbfc7edc09bf29e10ce68ab Author: Marko Mäkelä <marko.makela@mariadb.com> Wed Dec 14 15:44:28 2022 Committer: Marko Mäkelä <marko.makela@mariadb.com> Wed Jan 11 18:59:55 2023   MDEV-19506 Remove the global sequence DICT_HDR_ROW_ID for DB_ROW_ID   InnoDB tables that lack a primary key (and any UNIQUE INDEX whose all columns are NOT NULL) will use an internally generated index, called GEN_CLUST_INDEX(DB_ROW_ID) in the InnoDB data dictionary, and hidden from the SQL layer.   The 48-bit (6-byte) DB_ROW_ID is being assigned from a global sequence that is persisted in the DICT_HDR page.   There is absolutely no reason for the DB_ROW_ID to be globally unique across all InnoDB tables.

            Issue confirmed. Note that the stack for this issue:

            !m_innodb|SIGABRT|ha_partition::cmp_ref|refpos_order_cmp|my_qsort2|Refpos_container_sorted_array::sort
            

            Is slightly different than the one from MDEV-30442:

            !m_innodb|SIGABRT|ha_partition::cmp_ref|refpos_order_cmp|tree_insert|Unique::unique_add
            

            Though both issues look related.

            Roel Roel Van de Paar added a comment - Issue confirmed. Note that the stack for this issue: !m_innodb|SIGABRT|ha_partition::cmp_ref|refpos_order_cmp|my_qsort2|Refpos_container_sorted_array::sort Is slightly different than the one from MDEV-30442 : !m_innodb|SIGABRT|ha_partition::cmp_ref|refpos_order_cmp|tree_insert|Unique::unique_add Though both issues look related.

            Closing as duplicate of MDEV-30442

            psergei Sergei Petrunia added a comment - Closing as duplicate of MDEV-30442

            People

              psergei Sergei Petrunia
              alice Alice Sherepa
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.