MySQL Forums
Forum List  »  Partitioning

Partitioning with ndb cluster engine
Posted by: Johan Jerräng
Date: April 03, 2007 07:39AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Partitioning with ndb cluster engine
6668
April 03, 2007 07:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.