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

Validate Spider table definition

    XMLWordPrintable

Details

    Description

      Spider allows a user to create a table with invalid connection information. For example, CREATE TABLE t (a INT) ENGINE=SPIDER is accepted by Spider but DMLs on the table will definitely result in errors. Note that we do not do a health check of data nodes at the table creation but do validation for obvious mistakes.

      It might be good to have an internal switch for disabling the validation for the convenience of testing/QA.

      Spider should also validate that the table definition of the spider table and the remote table match, and report error otherwise. We could introduce a variable that determines whether the check should be performed at spider table creation.

      Attachments

        Activity

          People

            ycp Yuchen Pei
            nayuta-yanagisawa Nayuta Yanagisawa (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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