MySQL Bugs: #82296: ERROR 1296 (HY000): Got error 756 'Index on disk column is not supported'

Bug #82296	ERROR 1296 (HY000): Got error 756 'Index on disk column is not supported'
Submitted:	20 Jul 2016 21:32	Modified:	22 Jul 2016 12:48
Reporter:	Seçkin ALAN	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S1 (Critical)
Version:	mysql-5.6.29 ndb-7.4.11	OS:	Any
Assigned to:	MySQL Verification Team	CPU Architecture:	Any
Tags:	ndb

Description:
Hi,
I want to create unique index on my cluster

create unique index your_index_name on table_h(`x_type`,`y_type`,`z_id`,`c_type_id`);
ERROR 1296 (HY000): Got error 756 'Index on disk column is not supported' from NDBCLUSTER

I restart my cluster and try again but result is same

How to repeat:
all again whenever

Hi,

first, you know that you can't have indexed columns on disk?

https://dev.mysql.com/doc/mysql-cluster-excerpt/5.6/en/mysql-cluster-disk-data.html
*It is possible to store the nonindexed columns of NDB tables on disk, rather than in RAM.*

you have to provide a full create you have issues with as I can't reproduce your problem:

mysql> create table t2 ( x_type char(10), y_type varchar(10), z_id int(11), c_type_id bigint(20))  TABLESPACE ts_1 STORAGE DISK  ENGINE=ndbcluster DEFAULT CHARSET=latin1;
Query OK, 0 rows affected (0.26 sec)

mysql> create unique index xx on t2(`x_type`,`y_type`,`z_id`,`c_type_id`);
Query OK, 0 rows affected (0.70 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql> show create table t2\G
*************************** 1. row ***************************
       Table: t2
Create Table: CREATE TABLE `t2` (
  `x_type` char(10) DEFAULT NULL,
  `y_type` varchar(10) DEFAULT NULL,
  `z_id` int(11) DEFAULT NULL,
  `c_type_id` bigint(20) DEFAULT NULL,
  UNIQUE KEY `xx` (`x_type`,`y_type`,`z_id`,`c_type_id`)
) /*!50100 TABLESPACE ts_1 STORAGE DISK */ ENGINE=ndbcluster DEFAULT CHARSET=latin1
1 row in set (0.00 sec)
mysql> alter table t2 drop key xx;
Query OK, 0 rows affected (0.24 sec)
Records: 0  Duplicates: 0  Warnings: 0

kind regards
Bogdan