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

SPIDER table with no COMMENT clause causes queries to wait forever

    XMLWordPrintable

    Details

      Description

      MariaDB [test]> CREATE OR REPLACE TABLE user (
          ->   username VARCHAR(50) NOT NULL
          -> , password VARCHAR(50) NOT NULL
          -> )
          -> ENGINE = SPIDER;
      Query OK, 0 rows affected (0.12 sec)
       
      MariaDB [test]> SELECT * FROM user;

      I beleive that the table should not be created, since the COMMENT clause misses.

      The query waits forever. Note that even KILL HARD, in some cases, does not kill the query/process.

        Attachments

          Activity

            People

            Assignee:
            Kentoku Kentoku Shiba
            Reporter:
            f_razzoli Federico Razzoli
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: