Bug #18488 VARCHAR not supported in Distribution Key
Submitted: 24 Mar 2006 15:16 Modified: 27 Mar 2006 15:17
Reporter: Johan Andersson Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1 OS:Any (*)
Assigned to: CPU Architecture:Any

[24 Mar 2006 15:16] Johan Andersson 
Description:
Using VARCHAR does not work in distribution key..

mysql> create table test2 (A VARCHAR (255), B INTEGER, PRIMARY KEY (A,
B)) engine=ndb PARTITION BY KEY (A);
ERROR 1005 (HY000): Can't create table 'hss01.test2' (errno: 140)

mysql> create table test2 (A VARBINARY (255), B INTEGER, PRIMARY KEY (A,
B)) engine=ndb PARTITION BY KEY (A);
Query OK, 0 rows affected (0.68 sec)

mysql> 

How to repeat:

create table t1 (A VARCHAR (255), B INTEGER, PRIMARY KEY (A,
B)) engine=ndb PARTITION BY KEY (A);

>>ERROR 1005 (HY000): Can't create table 'test.test2' (errno: 140)

create table t1 (A VARBINARY (255), B INTEGER, PRIMARY KEY (A,
B)) engine=ndb PARTITION BY KEY (A);
Query OK, 0 rows affected (0.68 sec)
[24 Mar 2006 17:21] Jonas Oreland 
This only works with varbinary.
This is a know limitation that I don't think there is any current plans to remove...
[13 Mar 2014 13:34] Omer Barnir 
This bug is not scheduled to be fixed at this time.