SQLyog shows the ndb-cluster engine as an option though ndb is not enabled in configuration!
The system response is very clear and unambigious:
CODE
show variables like 'have_ndb%';
/* returns
Variable_name Value
--------------- --------
have_ndbcluster DISABLED
*/
select * from information_schema.engines where engine = 'ndbcluster';
/*returns
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
---------- -------- -------------------------------- ------------ ------ ----------
ndbcluster DISABLED Clustered, fault-tolerant tables NO NO NO
*/
/* returns
Variable_name Value
--------------- --------
have_ndbcluster DISABLED
*/
select * from information_schema.engines where engine = 'ndbcluster';
/*returns
ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
---------- -------- -------------------------------- ------------ ------ ----------
ndbcluster DISABLED Clustered, fault-tolerant tables NO NO NO
*/
.. so I guess we did not use the correct " WHERE SUPPORT = 'ENABLED' " ..