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

          Ascending order - Click to sort in descending order
          bertrandop Olivier Bertrand created issue -
          bertrandop Olivier Bertrand made changes -
          Field Original Value New Value
          Comment [ Hi Sergei,

          Can you have a look at MDEV-6297. It is currently unassigned.

          Thanks,
          Olivier
          ]
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          Resolution Duplicate [ 3 ]
          Status Open [ 1 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 41713 ] MariaDB v2 [ 43733 ]
          serg Sergei Golubchik made changes -
          Comment [ This is a duplicate of MDEV-5271 ]
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          Assignee Sergei Golubchik [ serg ]
          Resolution Duplicate [ 3 ]
          Status Closed [ 6 ] Stalled [ 10000 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.1 [ 16100 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43733 ] MariaDB v3 [ 64764 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.1 [ 16100 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.2 [ 14601 ]
          serg Sergei Golubchik made changes -
          Fix Version/s 10.3 [ 22126 ]
          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.
          serg Sergei Golubchik made changes -
          Fix Version/s 10.3 [ 22126 ]
          serg Sergei Golubchik made changes -
          Affects Version/s 10.0.12 [ 15201 ]
          Issue Type Bug [ 1 ] Task [ 3 ]
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 64764 ] MariaDB v4 [ 131635 ]

          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.