Suppose, one wants to produce trace for a statement.
One can do that with multiple statements:
set optimizer_trace=1;
|
select * from seq_1_to_10 where seq<10;
|
set optimizer_trace=0;
|
select left(trace, 100) from information_schema.optimizer_trace;
|
This produces a first part of the trace.
However, trying to do the same with SET STATEMENT produces an empty result:
set statement optimizer_trace=1 for select * from seq_1_to_10 where seq<10;
|
select left(trace, 100) from information_schema.optimizer_trace;
|
produces nothing.
Bug
Major
