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

Dead loop in Mariadb version of mysql

Details

    Description

      With the following SQL queries, mysql gets stuck in MariaDB-server but not in MySQL-server and the CPU is occupied 100 %.

      CREATE TEMPORARY TABLE v0 ( v1 INT UNIQUE ) ;
      		 
      WITH RECURSIVE v0 ( v1 ) AS ( SELECT -128 UNION SELECT v1 + 33 FROM v0 ) SELECT 'x' , -1 , 54703121.000000 FROM v0 AS v3 , v0 AS v2 ,v0 NATURAL JOIN v0 AS v5 NATURAL JOIN v0 AS v4 ;

      Attachments

        Activity

          Transition Time In Source Status Execution Times
          Sergei Golubchik made transition -
          Open Closed
          		36d 9h 27m 1

          People

            Unassigned Unassigned
            YonghengChen Yongheng Chen
            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.