[MDEV-27306] SET STATEMENT optimizer_trace=1 Doesn't save the trace - Jira

XML

Word

Printable

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.

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.