Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27306

SET STATEMENT optimizer_trace=1 Doesn't save the trace

    XMLWordPrintable

    Details

      Description

      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.

        Attachments

          Activity

            People

            Assignee:
            psergei Sergei Petrunia
            Reporter:
            psergei Sergei Petrunia
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration

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