Details
-
Bug
-
Status: In Progress (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
Description
Issue found in below tests:
main.derived_cond_pushdown
main.subselect
main.subselect4
main.func_in
main.subselect_mat_cost_bugs
Issue:
-------------
Replay crashes the server:
mariadbd: /home/ppandith/test2/sql/opt_range.cc:2743: quick_select_return SQL_SELECT::test_quick_select(THD*, key_map, table_map, ha_rows, bool, bool, bool, bool, Item_func::Bitmap): Assertion `table_records || !head->file->stats.records' failed.
How to repro:
-------------
CREATE TABLE t1 (a INT, PRIMARY KEY(a)); |
INSERT INTO t1 VALUES (1),(2),(3); |
 |
set optimizer_record_context=ON; |
EXPLAIN SELECT * FROM t1 WHERE a IN |
((SELECT MAX(a) FROM t1), (SELECT MAX(a) FROM t1)); |
SELECT context INTO DUMPFILE 'context1.txt' FROM INFORMATION_SCHEMA.OPTIMIZER_CONTEXT; |
source context1.txt;
|
Attachments
Issue Links
- relates to
-
MDEV-39382 Trace replay produces "Impossible WHERE noticed after reading const tables"
-
- Closed
-
-
MDEV-39368 Add mtr option to test Optimizer Context Replay
-
- Open
-