Debian Codegraph @

mysql-test/suite/opt_trace/t/bugs_no_prot_none.test

raw
1 # Start server with MyISAM
2 --source include/force_myisam_default.inc
3
4 # Skip the test if MyISAM is not available
5 --source include/have_myisam.inc
6
7 # Does not output the same optimizer trace.
8 --source include/not_hypergraph.inc
9
10 --disable_query_log
11 if (`select locate('semijoin', @@optimizer_switch) > 0`)
12 {
13 set optimizer_switch='semijoin=off';
14 }
15 if (`select locate('materialization', @@optimizer_switch) > 0`)
16 {
17 set optimizer_switch='materialization=off';
18 }
19 if (`select locate('index_condition_pushdown', @@optimizer_switch) > 0`)
20 {
21 set optimizer_switch='index_condition_pushdown=off';
22 }
23 if (`select locate('mrr', @@optimizer_switch) > 0`)
24 {
25 set optimizer_switch='mrr=off';
26 }
27 --enable_query_log
28
29 # Test requires: sp-protocol/ps-protocol/view-protocol/cursor-protocol disabled
30 --source include/no_protocol.inc
31
32 --let $support_native_partitioning= 0
33
34 --source suite/opt_trace/include/bugs.inc
35
36 --echo #
37 --echo # BUG#18365641: SERVER EXIT IN TRACE OF QUICK SELECT
38 --echo #
39
40 CREATE TABLE t1 (
41 pk INT(11),
42 i1 INT(11),
43 vc VARCHAR(10),
44 vc2 VARCHAR(10),
45 PRIMARY KEY (pk),
46 KEY i1 (i1),
47 KEY vc (vc)
48 ) ENGINE=InnoDB, CHARSET utf8mb4;
49
50 INSERT INTO t1 VALUES (1, -1281753088,'p','r');
51 INSERT INTO t1 VALUES (4, NULL,'a','i');
52 INSERT INTO t1 VALUES (5, NULL,'lhtrovamzq','t');
53 INSERT INTO t1 VALUES (6, 3,'d','RZDUH');
54 INSERT INTO t1 VALUES (7, 951910400,'z','it\'s');
55 INSERT INTO t1 VALUES (8, 1067319296,'get','WZJHD');
56 INSERT INTO t1 VALUES (9, -1666187264,'zqrdcenchy','me');
57 INSERT INTO t1 VALUES (10, NULL,'what','there');
58
59 CREATE TABLE t2 (
60 vc VARCHAR(10),
61 pk INT(11),
62 PRIMARY KEY (pk),
63 KEY vc2 (vc)
64 );
65
66 INSERT INTO t2 VALUES ('ukkoeiwsgp',1);
67
68 # Opt trace needs to be 'on' to reproduce, but the
69 # trace itself is not interesting
70
71 EXPLAIN
72 SELECT *
73 FROM t1 LEFT JOIN t2
74 ON t1.i1 < t2.vc
75 WHERE t1.vc IN ( 'AVZPQ' )
76 OR t1.i1 IS NULL AND t1.pk >= 9;
77
78 SELECT *
79 FROM t1 LEFT JOIN t2
80 ON t1.i1 < t2.vc
81 WHERE t1.vc IN ( 'AVZPQ' )
82 OR t1.i1 IS NULL AND t1.pk >= 9;
83
84 DROP TABLE t1, t2;