Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
This comes from main.view test failure:
CREATE TABLE t1 (a int PRIMARY KEY, b int); |
INSERT INTO t1 VALUES (2,20), (3,10), (1,10), (0,30), (5,10); |
|
|
set optimizer_record_context=1; |
EXPLAIN SELECT MAX(a) FROM t1; |
select context into dumpfile '/tmp/1.sql' from information_schema.optimizer_context; |
|
|
source /tmp/1.sql
|
The first EXPLAIN gives:
MariaDB [test]> EXPLAIN SELECT MAX(a) FROM t1;
|
+------+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Select tables optimized away |
|
+------+-------------+-------+------+---------------+------+---------+------+------+------------------------------+
|
The second:
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------+
|
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------+
|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | No matching min/max row |
|
+------+-------------+-------+------+---------------+------+---------+------+------+-------------------------+
|
Attachments
Issue Links
- relates to
-
MDEV-39368 Add mtr option to test Optimizer Context Replay
-
- Open
-