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

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

    XMLWordPrintable

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

            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.