# # Bug#33546083 - mysqld crash in Field::field_index # CREATE TABLE t1 ( pk int NOT NULL, col_varchar_255_key varchar(255), PRIMARY KEY (pk), KEY col_varchar_255_key (col_varchar_255_key) ) ENGINE=InnoDB SECONDARY_ENGINE=mock; ALTER TABLE t1 SECONDARY_LOAD; ANALYZE TABLE t1; Table Op Msg_type Msg_text test.t1 analyze status OK EXPLAIN SELECT (SELECT MAX(col_varchar_255_key ) FROM t1) AS field1 FROM t1 AS alias1 WHERE (alias1.col_varchar_255_key IN (SELECT 'f' UNION ALL SELECT 'r')) GROUP BY field1; id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 NONE NULL NULL NULL NULL NULL NULL NULL NULL NULL Using secondary engine MOCK. Use EXPLAIN FORMAT=TREE to show the plan. Warnings: 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 (`test`.`alias1`.`col_varchar_255_key`,(/* select#3 */ select 'f' having ((`test`.`alias1`.`col_varchar_255_key`) = ('f')) union all /* select#4 */ select 'r' having ((`test`.`alias1`.`col_varchar_255_key`) = ('r')))) group by `field1` SELECT (SELECT MAX(col_varchar_255_key ) FROM t1) AS field1 FROM t1 AS alias1 WHERE (alias1.col_varchar_255_key IN (SELECT 'f' UNION ALL SELECT 'r')) GROUP BY field1; field1 DROP TABLE t1; # # Bug#34854369: Customer query hits assert(m_pq.is_valid()) failure # CREATE TABLE t (x INT) SECONDARY_ENGINE MOCK; INSERT INTO t VALUES (), (), (), (); ALTER TABLE t SECONDARY_LOAD; ANALYZE TABLE t; Table Op Msg_type Msg_text test.t analyze status OK EXPLAIN FORMAT=TREE SELECT * FROM t UNION ALL SELECT * FROM t; EXPLAIN -> Append (rows=8) -> Stream results (rows=4) -> Table scan on t in secondary engine MOCK (rows=4) -> Stream results (rows=4) -> Table scan on t in secondary engine MOCK (rows=4) Warnings: Note 1003 Query is executed in secondary engine; the actual query plan may diverge from the printed one SET optimizer_max_subgraph_pairs = 1; WITH u AS (SELECT * FROM t UNION ALL SELECT * FROM t) SELECT * FROM t AS t1 NATURAL JOIN t AS t2 NATURAL JOIN u AS u1 NATURAL JOIN u AS u2 NATURAL JOIN u AS u3 NATURAL JOIN u AS u4; x SET optimizer_max_subgraph_pairs = DEFAULT; DROP TABLE t;