Hi!
I was trying to create a table with partitioning on the ndb cluster engine, according to the manual:
http://dev.mysql.com/doc/refman/5.1/en/partitioning-hash.html
I get the following error:
mysql [t1] >CREATE TABLE employees (
-> id INT NOT NULL,
-> fname VARCHAR(30),
-> lname VARCHAR(30),
-> hired DATE NOT NULL DEFAULT '1970-01-01',
-> separated DATE NOT NULL DEFAULT '9999-12-31',
-> job_code INT,
-> store_id INT
-> )
-> PARTITION BY HASH(store_id)
-> PARTITIONS 4;
ERROR 1005 (HY000): Can't create table 't1.employees' (errno: 138)
Which seems to mean "MySQL error code 138: Unsupported extension used for table"
Anyone got any idea?
The have_partitioning variable is set to YES and I'm using MySQL version 5.1.14.