Bug #33412 Didn't limit the storage engine for exception table
Submitted: 20 Dec 2007 16:29 Modified: 3 Apr 2008 11:43
Reporter: li zhou Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version:mysql-5.1-telco-6.3 OS:Any
Assigned to: CPU Architecture:Any
Tags: 5.1.22-ndb-6.3.7
Triage: Triaged: D3 (Medium)

[20 Dec 2007 16:29] li zhou 
Description:
We can create an exception table using MYISAM engine. But in manual we have "The exception table must use the NDB storage engine.".
So we need the limited the storage engine and give warning if engine is not NDB.

How to repeat:
CREATE TABLE test.t1$EX  (
    server_id INT UNSIGNED,
    master_server_id INT UNSIGNED,
    master_epoch BIGINT UNSIGNED,
    count INT UNSIGNED,
    a INT UNSIGNED NOT NULL,
    b CHAR(25) NOT NULL,
    PRIMARY KEY(server_id, master_server_id, master_epoch, count)
)   ENGINE=MYISAM;
CREATE TABLE test.t1  (
    a INT UNSIGNED NOT NULL,
    b CHAR(25) NOT NULL,
    mycol INT UNSIGNED NOT NULL,
    PRIMARY KEY (a, b)
)   ENGINE=NDB;
[3 Apr 2008 11:43] Sveta Smirnova 
Thank you for the report.

Verified as described.