Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
Q3/2026 Server Maintenance
Description
set statement optimizer_record_context=1 for ... doesn't seem to have any effect.
Test case:
--source include/have_sequence.inc
|
|
|
create table t1 (
|
a int,
|
b int,
|
index (a)
|
);
|
|
|
insert into t1 select seq, seq from seq_1_to_1000;
|
|
|
set statement optimizer_record_context=1 for
|
explain select * from t1 where a < 10;
|
select * from information_schema.optimizer_context;
|
produces nothing.
If I put a breakpoint in Optimizer_context_recorder::record_multi_range_read_info_const, it is not hit, that is, no recording takes place.
For comparison:
set statement optimizer_trace=1 for |
explain select * from t1 where a < 10; |
select * from information_schema.optimizer_trace; |