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

        Issue Links

          Activity

            People

              Kentoku Kentoku Shiba (Inactive)
              f_razzoli Federico Razzoli
              Votes:
              0 Vote for this issue
              Watchers:
              8 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.