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

Engine column (and index?) options are not recognized by partitioned tables

Details

    • Task
    • Status: Stalled (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      The create statement:

      CREATE TABLE t1 (
      		 
      id INT NOT NULL,
      		 
      msg VARCHAR(32) FLAG=12)
      		 
      ENGINE=CONNECT TABLE_TYPE=FIX
      		 
      PARTITION BY HASH(id)
      		 
      PARTITIONS 3;

      returns the error message: (1911) Unknown option 'flag'

      Note that can be temporarily bypassed by doing:

      CREATE TABLE t1 (
      		 
      id INT NOT NULL,
      		 
      msg VARCHAR(32) FLAG=12)
      		 
      ENGINE=CONNECT TABLE_TYPE=FIX;
      		 
       
      		 
      ALTER TABLE t1
      		 
      PARTITION BY HASH(id)
      		 
      PARTITIONS 3;

      Note: Partition support by CONNECT is a work in progress.

      Attachments

        Activity

          bertrandop Olivier Bertrand added a comment -

          There are many more bugs concerning the partition engine, such as the lost of the CONNECTION option and wrong impossible where clauses.

          bertrandop Olivier Bertrand added a comment - There are many more bugs concerning the partition engine, such as the lost of the CONNECTION option and wrong impossible where clauses.

          People

            serg Sergei Golubchik
            bertrandop Olivier Bertrand
            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.