TokuDB - Can not create a clustering index on a partitioned table
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.6 |
Fix Released
|
Critical
|
George Ormond Lorch III | |||
5.7 |
Fix Released
|
Critical
|
George Ormond Lorch III |
Bug Description
https:/
mysql> CREATE TABLE `t1` ( -> `a` int(10) unsigned NOT NULL AUTO_INCREMENT,
-> `b` varchar(255) DEFAULT NULL,
-> PRIMARY KEY (`a`)
-> ) ENGINE=TokuDB DEFAULT CHARSET=latin1
-> /*!50100 PARTITION BY RANGE (a)
-> (PARTITION p0 VALUES LESS THAN (100) ENGINE = TokuDB,
-> PARTITION p2 VALUES LESS THAN MAXVALUE ENGINE = TokuDB) */;
Query OK, 0 rows affected (0.23 sec)
mysql> alter table t1 add clustering index cl_b (`b`);
ERROR 1478 (HY000): Table storage engine 'partition' does not support the create option 'CLUSTERING'
Bugs is here:
(gdb) bt
#0 mysql_prepare_
count=0x7ffda42
#1 0x000000000083b71f in create_table_impl (thd=0x183e1290, db=0x7ffd540052a0 "test", table_name=
_info=0x7ffda42
e.cc:4737
#2 0x00000000008444ea in mysql_alter_table (thd=0x183e1290, new_db=
er=0x0, ignore=false) at /home/rfp/
#3 0x0000000000989799 in Sql_cmd_
#4 0x00000000007d18d1 in mysql_execute_
#5 0x00000000007d4b4d in mysql_parse (thd=0x183e1290, rawbuf=
.6/sql/
#6 0x00000000007c72e8 in dispatch_command (command=COM_QUERY, thd=0x183e1290, packet=0x183e53e1 "alter table t1 add clustering index cl_b (`b`)", packet_length=46) at /home/rfp/
/sql/sql_
Partition storage engine needs to pass up the clustering flag from the underlying engine.
Changed in percona-server: | |
importance: | Undecided → Critical |
tags: | added: i57094 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/ /jira.percona. com/browse/ PS-389