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

Hang after setting show_explain_probe_join_exec_end and SET (no hang for same query without SET)

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Not a Bug
    • Affects Version/s: 10.2, 10.3, 10.4, 10.5, 10.6
    • Fix Version/s: N/A
    • Component/s: Optimizer, Tests
    • Labels:

      Description

      Sergei Petrunia hi! Not sure if this is a bug, though it looks to be. If not, please close.

      CREATE TABLE t (c INT);
      INSERT INTO t VALUES (1);  # Optional
      SET @show_explain_probe_select_id=2;
      SET debug_dbug='+d,show_explain_probe_join_exec_end';
      SELECT c FROM t;
      

      Will not fail/simply result in "1" output.

      However,

      CREATE TABLE t (c INT);
      INSERT INTO t VALUES (1);  # Optional
      SET @show_explain_probe_select_id=2;
      SET debug_dbug='+d,show_explain_probe_join_exec_end';
      SET @hang=(SELECT c FROM t);
      

      Will hang on 10.2, 10.3, 10.4, 10.5, 10.6 debug.

      It may be a shortcoming in the debug parameter, or it may be a bug in SET handling.

        Attachments

          Activity

            People

            Assignee:
            Roel Roel Van de Paar
            Reporter:
            Roel Roel Van de Paar
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.