Debian Codegraph @

mysql-test/suite/secondary_engine/inc/secondary_engine_bugs.inc

raw
1 --source include/elide_costs.inc
2
3 --disable_query_log
4 eval INSTALL PLUGIN mock SONAME '$MOCK_PLUGIN';
5 --enable_query_log
6
7 --echo #
8 --echo # Bug#33546083 - mysqld crash in Field::field_index
9 --echo #
10
11 CREATE TABLE t1 (
12 pk int NOT NULL,
13 col_varchar_255_key varchar(255),
14 PRIMARY KEY (pk),
15 KEY col_varchar_255_key (col_varchar_255_key)
16 ) ENGINE=InnoDB SECONDARY_ENGINE=mock;
17
18 ALTER TABLE t1 SECONDARY_LOAD;
19 ANALYZE TABLE t1;
20
21 let $query=
22 SELECT (SELECT MAX(col_varchar_255_key ) FROM t1) AS field1
23 FROM t1 AS alias1
24 WHERE (alias1.col_varchar_255_key IN (SELECT 'f' UNION ALL SELECT 'r'))
25 GROUP BY field1;
26
27 eval EXPLAIN $query;
28 eval $query;
29
30 DROP TABLE t1;
31
32 --echo #
33 --echo # Bug#34854369: Customer query hits assert(m_pq.is_valid()) failure
34 --echo #
35
36 CREATE TABLE t (x INT) SECONDARY_ENGINE MOCK;
37 INSERT INTO t VALUES (), (), (), ();
38 ALTER TABLE t SECONDARY_LOAD;
39 ANALYZE TABLE t;
40
41 # The Append path used to lack a row estimate.
42 --replace_regex $elide_costs
43 EXPLAIN FORMAT=TREE SELECT * FROM t UNION ALL SELECT * FROM t;
44
45 # This query used to hit an assert failure during graph simplification
46 # when running with the hypergraph optimizer, caused by the missing
47 # row estimates.
48 SET optimizer_max_subgraph_pairs = 1;
49 WITH u AS (SELECT * FROM t UNION ALL SELECT * FROM t)
50 SELECT * FROM t AS t1 NATURAL JOIN t AS t2 NATURAL JOIN
51 u AS u1 NATURAL JOIN u AS u2 NATURAL JOIN
52 u AS u3 NATURAL JOIN u AS u4;
53 SET optimizer_max_subgraph_pairs = DEFAULT;
54
55 DROP TABLE t;
56
57 --disable_query_log
58 UNINSTALL PLUGIN mock;
59 --enable_query_log