Debian Codegraph @

mysql-test/suite/secondary_engine/r/secondary_engine_bugs.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 PRIMARY alias1 NULL ALL NULL NULL NULL NULL 1 100.00 Using where; Using temporary; Using secondary engine MOCK
20 3 DEPENDENT SUBQUERY NULL NULL NULL NULL NULL NULL NULL NULL NULL No tables used
21 4 DEPENDENT UNION NULL NULL NULL NULL NULL NULL NULL NULL NULL No tables used
22 2 SUBQUERY t1 NULL ALL NULL NULL NULL NULL 1 100.00 Using secondary engine MOCK
23 Warnings:
24 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`
25 SELECT (SELECT MAX(col_varchar_255_key ) FROM t1) AS field1
26 FROM t1 AS alias1
27 WHERE (alias1.col_varchar_255_key IN (SELECT 'f' UNION ALL SELECT 'r'))
28 GROUP BY field1;
29 field1
30 DROP TABLE t1;
31 #
32 # Bug#34854369: Customer query hits assert(m_pq.is_valid()) failure
33 #
34 CREATE TABLE t (x INT) SECONDARY_ENGINE MOCK;
35 INSERT INTO t VALUES (), (), (), ();
36 ALTER TABLE t SECONDARY_LOAD;
37 ANALYZE TABLE t;
38 Table Op Msg_type Msg_text
39 test.t analyze status OK
40 EXPLAIN FORMAT=TREE SELECT * FROM t UNION ALL SELECT * FROM t;
41 EXPLAIN
42 -> Append (rows=8)
43 -> Stream results (rows=4)
44 -> Table scan on t in secondary engine MOCK (rows=4)
45 -> Stream results (rows=4)
46 -> Table scan on t in secondary engine MOCK (rows=4)
47
48 Warnings:
49 Note 1003 Query is executed in secondary engine; the actual query plan may diverge from the printed one
50 SET optimizer_max_subgraph_pairs = 1;
51 WITH u AS (SELECT * FROM t UNION ALL SELECT * FROM t)
52 SELECT * FROM t AS t1 NATURAL JOIN t AS t2 NATURAL JOIN
53 u AS u1 NATURAL JOIN u AS u2 NATURAL JOIN
54 u AS u3 NATURAL JOIN u AS u4;
55 x
56 SET optimizer_max_subgraph_pairs = DEFAULT;
57 DROP TABLE t;