Error 1178: The storage engine for the table doesn't support
Error Code | SQLSTATE | Error | Description |
---|---|---|---|
1178 | 42000 | ER_CHECK_NOT_IMPLEMENTED | The storage engine for the table doesn't support %s |
Contents
Possible Causes and Solutions
MariaDB storage engines differ in many ways, and not all operations are supported by each engine. Perhaps you don't need the intended operation for the engine, or perhaps you need a different storage engine. For example, sequences don't support analyze table, as it's an unnecessary operation on a sequence table, which only contains one row.
CREATE SEQUENCE s START WITH 100 INCREMENT BY 10; ANALYZE TABLE s; +--------+---------+----------+----------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------+---------+----------+----------------------------------------------------------+ | test.s | analyze | note | The storage engine for the table doesn't support analyze | +--------+---------+----------+----------------------------------------------------------+
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.