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

          relates to

          Task - A task that needs to be done. MDEV-30542 Update the spider self_reference test to include a case of circular referencing of length > 0

          • Major - Major loss of function.
          • Closed

          Task - A task that needs to be done. MDEV-30994 Earlier detection of spider table self-reference

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. MDEV-29583 Disallow Spider self/dual/multi/cross-referencing tables, consider not executing/skipping/disabling init_connect for Spider user

          • Major - Major loss of function.
          • Closed

          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:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 25.75d
                  25.75d

                  Git Integration

                    Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.