Debian Codegraph @

mysql-test/suite/secondary_engine/r/secondary_engine_bugs_hypergraph.result

raw
1 #
2 # Bug#33546083 - mysqld crash in Field::field_index
3 #
4 CREATE TABLE t1 (
5 pk int NOT NULL,
6 col_varchar_255_key varchar(255),
7 PRIMARY KEY (pk),
8 KEY col_varchar_255_key (col_varchar_255_key)
9 ) ENGINE=InnoDB SECONDARY_ENGINE=mock;
10 ALTER TABLE t1 SECONDARY_LOAD;
11 ANALYZE TABLE t1;
12 Table Op Msg_type Msg_text
13 test.t1 analyze status OK
14 EXPLAIN SELECT (SELECT MAX(col_varchar_255_key ) FROM t1) AS field1
15 FROM t1 AS alias1
16 WHERE (alias1.col_varchar_255_key IN (SELECT 'f' UNION ALL SELECT 'r'))
17 GROUP BY field1;
18 id select_type table partitions type possible_keys key key_len ref rows filtered Extra
19 1 NONE NULL NULL NULL NULL NULL NULL NULL NULL NULL Using secondary engine MOCK. Use EXPLAIN FORMAT=TREE to show the plan.
20 Warnings:
21 Note 1003 /* select#1 */ select (/* select#2 */ select max(`test`.`t1`.`col_varchar_255_key`) from `test`.`t1`) AS `field1` from `test`.`t1` `alias1` where <in_optimizer>(`test`.`alias1`.`col_varchar_255_key`,<exists>(/* select#3 */ select 'f' having (<cache>(`test`.`alias1`.`col_varchar_255_key`) = <ref_null_helper>('f')) union all /* select#4 */ select 'r' having (<cache>(`test`.`alias1`.`col_varchar_255_key`) = <ref_null_helper>('r')))) group by `field1`
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 field1
27 DROP TABLE t1;
28 #
29 # Bug#34854369: Customer query hits assert(m_pq.is_valid()) failure
30 #
31 CREATE TABLE t (x INT) SECONDARY_ENGINE MOCK;
32 INSERT INTO t VALUES (), (), (), ();
33 ALTER TABLE t SECONDARY_LOAD;
34 ANALYZE TABLE t;
35 Table Op Msg_type Msg_text
36 test.t analyze status OK
37 EXPLAIN FORMAT=TREE SELECT * FROM t UNION ALL SELECT * FROM t;
38 EXPLAIN
39 -> Append (rows=8)
40 -> Stream results (rows=4)
41 -> Table scan on t in secondary engine MOCK (rows=4)
42 -> Stream results (rows=4)
43 -> Table scan on t in secondary engine MOCK (rows=4)
44
45 Warnings:
46 Note 1003 Query is executed in secondary engine; the actual query plan may diverge from the printed one
47 SET optimizer_max_subgraph_pairs = 1;
48 WITH u AS (SELECT * FROM t UNION ALL SELECT * FROM t)
49 SELECT * FROM t AS t1 NATURAL JOIN t AS t2 NATURAL JOIN
50 u AS u1 NATURAL JOIN u AS u2 NATURAL JOIN
51 u AS u3 NATURAL JOIN u AS u4;
52 x
53 SET optimizer_max_subgraph_pairs = DEFAULT;
54 DROP TABLE t;