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

Dead loop in Mariadb version of mysql

    XMLWordPrintable

    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

            People

            Assignee:
            Unassigned
            Reporter:
            YonghengChen Yongheng Chen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: