[MDEV-6297] Engine column (and index?) options are not recognized by partitioned tables Created: 2014-06-03  Updated: 2019-09-24

Status: Stalled
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Task Priority: Major
Reporter: Olivier Bertrand Assignee: Sergei Golubchik
Resolution: Unresolved Votes: 0
Labels: 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.

 Comments   
Comment by Olivier Bertrand [ 2017-09-25 ]

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

Generated at Thu Feb 08 07:10:49 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.