MySQL Bugs: #33412: Didn't limit the storage engine for exception table

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

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;

Thank you for the report.

Verified as described.