virtual int Mrr_ordered_index_reader::refill_buffer(): Assertion `!know_key_tuple_params || key_buffer->is_empty()' failed in maria-5.3-mwl128-dsmrr-cpk
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
Fix Released
|
Undecided
|
Sergey Petrunia |
Bug Description
The following query:
SELECT table2.
FROM t1 AS table1 JOIN t2 AS table2 ON table1.
WHERE table2.
asserted as follows in maria-5.
mysqld: multi_range_
#8 0x00133d98 in __assert_fail () from /lib/libc.so.6
#9 0x084a2edd in Mrr_ordered_
#10 0x084a33f2 in Mrr_ordered_
#11 0x084a3da4 in DsMrr_impl:
buf=0xae743c84) at multi_range_
#12 0x08566aa3 in ha_maria:
at ha_maria.cc:3615
#13 0x082e1541 in JOIN_TAB_
#14 0x082df994 in JOIN_CACHE:
#15 0x082df652 in JOIN_CACHE:
#16 0x08327178 in sub_select_cache (join=0xae748f58, join_tab=
#17 0x08327abb in evaluate_
#18 0x08327447 in sub_select (join=0xae748f58, join_tab=
#19 0x0832686c in do_select (join=0xae748f58, fields=0x9d82678, table=0x0, procedure=0x0) at sql_select.cc:12914
#20 0x0830c405 in JOIN::exec (this=0xae748f58) at sql_select.cc:2382
#21 0x0830cb6b in mysql_select (thd=0x9d80c48, rref_pointer_
order=0x0, group=0x0, having=0x0, proc_param=0x0, select_
at sql_select.cc:2592
#22 0x083051a1 in handle_select (thd=0x9d80c48, lex=0x9d822d4, result=0xae744d88, setup_tables_
#23 0x082a130f in execute_
#24 0x08297e0f in mysql_execute_
#25 0x082a3880 in mysql_parse (thd=0x9d80c48,
rawbuf=
#26 0x0829597c in dispatch_command (command=COM_QUERY, thd=0x9d80c48, packet=0x9d82cb9 "", packet_length=191) at sql_parse.cc:1209
#27 0x08294e2e in do_command (thd=0x9d80c48) at sql_parse.cc:902
#28 0x08291de4 in handle_
#29 0x00bea919 in start_thread () from /lib/libpthread
#30 0x001edcbe in clone () from /lib/libc.so.6
Related branches
Changed in maria: | |
status: | New → Fix Committed |
Changed in maria: | |
status: | Fix Committed → Fix Released |
Test case:
SET SESSION optimizer_use_mrr = 'force';
SET SESSION join_cache_level = 6;
SET SESSION join_buffer_size = 1024;
--disable_warnings
DROP TABLE /*! IF EXISTS */ t1;
DROP TABLE /*! IF EXISTS */ t2;
--enable_warnings
CREATE TABLE t1 ( 10_latin1_ key varchar(10) DEFAULT NULL, 10_latin1 varchar(10) DEFAULT NULL, 1024_latin1_ key varchar(1024) DEFAULT NULL, 10_utf8 varchar(10) CHARACTER SET utf8 DEFAULT NULL, 10_latin1_ key (col_varchar_ 10_latin1_ key), 1024_latin1_ key (col_varchar_ 1024_latin1_ key) ,1,'mean' ,'z','CETCI' ),('r', 2,'abcdefjhjkl' ,'abcdefjhjkl' ,'g'),( 'been', 3,'abcdefjhjkl' ,'in',' hey'),( 'I\'ll' ,4,'abcdefjhjkl ','abcdefjhjkl' ,'CVCZR' ),('GSMTS' ,6,'he\ 's','abcdefjhjk l','u') ,('GSKUD' ,7,'h', 'at','the' ),('going' ,8,'this' ,'RNEVG' ,'JVXGC' ),('say' ,9,'WGBVU' ,'ZNQVR' ,'SOFFU' ),('you\ 're',10, 'z','j' ,'tell' ),('abcdefjhjkl ',14,'abcdefjhj kl','no' ,'p'),( 'NOFJH' ,15,'GLSXZ' ,'k','DWTZJ' ),('b', 16,'could' ,'JFJAU' ,'LIPLE' ),('abcdefjhjkl ',17,'z' ,'f','IGFKY' ),('abcdefjhjkl ',18,'abcdefjhj kl','g' ,'e'),( 'didn\' t',5,'this' ,'this' ,'would' ),('AUWVN' ,12,'abcdefjhjk l','AOOUK' ,'EHGSK' ),('QNHWK' ,20,'q' ,'on',' m'),('x' ,22,'n' ,'it',' abcdefjhjkl' ),('mean' ,23,'KVJEK' ,'have' ,'right' ),('h', 24,'VJVDS' ,'abcdefjhjkl' ,'XJJVP' ),('if' ,26,'u' ,'abcdefjhjkl' ,'CLULE' ),('abcdefjhjkl ',28,'you\ 're','abcdefjhj kl','think' ),('with' ,30,'z' ,'on',' n'),('s' ,31,'s' ,'MUVHW' ,'a'),( 'abcdefjhjkl' ,33,'LCVTC' ,'she', 'abcdefjhjkl' ),('m', 19,'for' ,'GNCJI' ,'abcdefjhjkl' ),('abcdefjhjkl ',11,'up' ,'all', 'it\'s' ),('g', 21,'u', 'abcdefjhjkl' ,'then' ),('t', 25,'abcdefjhjkl ','MQFEC' ,'right' ),('out' ,34,'abcdefjhjk l','g', 'GRPDG' ),('your' ,35,'can\ 't','RXSIK' ,'b'),( 'b',37, 'abcdefjhjkl' ,'FZCZL' ,'d'),( 'to',42, 'm','will' ,'l'),( 'abcdefjhjkl' ,43,'abcdefjhjk l','TNOSX' ,'PWQKO' );
col_varchar_
pk int(11) NOT NULL AUTO_INCREMENT,
col_varchar_
col_varchar_
col_varchar_
PRIMARY KEY (pk),
KEY col_varchar_
KEY col_varchar_
) ENGINE=Aria AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1;
INSERT INTO t1 VALUES ('FSLXI'
CREATE TABLE t2 ( 10_utf8 varchar(10) CHARACTER SET utf8 DEFAULT NULL, 10_latin1 varchar(10) DEFAULT NULL, 10_latin1_ key varchar(10) DEFAULT NULL, 1024_latin1_ key varchar(1024) DEFAULT NULL, 10_latin1_ key (col_varchar_ 10_latin1_ key), 1024_latin1_ key (col_varchar_ 1024_latin1_ key) ,'abcdefjhjkl' ,'c',1, 'i'),(' m','abcdefjhjkl ','ILVHS' ,2,'abcdefjhjkl '),('he\ 's','abcdefjhjk l','were' ,3,'PRNZK' ),('d', 'abcdefjhjkl' ,'here' ,4,'abcdefjhjkl '),('can' ,'BLJCV' ,'go',5, 'that') ,('this' ,'SWGQI' ,'BFBWJ' ,6,'QECYF' ),('time' ,'p','m' ,7,'q') ,('abcdefjhjkl' ,'is',' XEZRN', 9,'abcdefjhjkl' ),('yes' ,'g','abcdefjhj kl',10, 'been') ,('e',' u','p', 11,'v') ,('FFJIH' ,'j','ARQHA' ,8,'abcdefjhjkl '),('BNEQB' ,'FCIPV' ,'e',13, 'XSECZ' ),('JMRST' ,'NDHZT' ,'q',15, 'oh'),( 'abcdefjhjkl' ,'then' ,'oh',16, 'abcdefjhjkl' ),('k', 'don\'t' ,'abcdefjhjkl' ,17,'go' ),('v', 'abcdefjhjkl' ,'PMPKB' ,18,'about' ),('abcdefjhjkl ','AIKFD' ,'abcdefjhjkl' ,19,'she' ),('abcdefjhjkl ','yeah' ,'oh',20, 'b'),(' z','just' ,'TSDNQ' ,21,'abcdefjhjk l'),('. ..
col_varchar_
col_varchar_
col_varchar_
pk int(11) NOT NULL AUTO_INCREMENT,
col_varchar_
PRIMARY KEY (pk),
KEY col_varchar_
KEY col_varchar_
) ENGINE=Aria AUTO_INCREMENT=51 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1;
INSERT INTO t2 VALUES ('GINHU'