File: mdev12972.test

package info (click to toggle)
mariadb-10.3 1%3A10.3.34-0%2Bdeb10u1
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 531,600 kB
  • sloc: cpp: 1,415,326; ansic: 917,243; perl: 58,570; sh: 43,538; pascal: 39,206; java: 33,919; yacc: 32,096; javascript: 15,655; python: 10,576; ruby: 8,684; xml: 5,957; makefile: 4,893; sql: 3,750; asm: 841; lex: 670; php: 22; awk: 20; sed: 16
file content (26 lines) | stat: -rw-r--r-- 944 bytes parent folder | download | duplicates (4) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
 
#
# MDEV-12972 Random and Frequent Segfault (SIG 11) During Runtime
#
# This was actually a memory overrun in MRR that TokuDB triggered
#

CREATE TABLE t1 (pk INT PRIMARY KEY, i1 INT, c1 VARCHAR(1), KEY(c1)) ENGINE=TokuDB;
INSERT INTO t1 VALUES
(1,2,NULL),(2,5,'x'),(3,3,'i'),(4,1,'e'),(5,4,'p');

CREATE TABLE t2 (i2 INT) ENGINE=TokuDB;
INSERT INTO t2 VALUES (1),(2);

CREATE TABLE t3 (i3 INT, c3 VARCHAR(1), KEY(i3)) ENGINE=TokuDB;
INSERT INTO t3 VALUES
(1,'e'),(1,'z'),(1,'i'),(1,'q'),(1,'i'),(1,'f'),(1,'m'),(2,'c'),(1,'d'),
(2,'n'),(1,'t'),(2,'e'),(1,'w'),(2,'y'),(1,'j'),(2,'i'),(1,'f'),(2,'f'),
(1,'s'),(2,'y');

SET join_cache_level = 8;
SET optimizer_switch ='mrr=on,mrr_sort_keys=on,optimize_join_buffer_size=on';

--sorted_result
SELECT * FROM t1 AS t1_outer WHERE EXISTS ( SELECT * FROM t2 WHERE i2 IN ( SELECT i3 FROM t3 INNER JOIN t1 AS t1_inner ON (t1_inner.c1 = c3 ) WHERE t1_inner.i1 < t1_outer.i1 ) );

DROP TABLE t1, t2, t3;