Details
Description
Attempting to optimize a table (existing or new) fails immediately.
|
MariaDB [my_db]> CREATE TABLE toku_bug (
|
toku_bug_key int(10) unsigned not null auto_increment,
|
primary key (toku_bug_key)
|
) ENGINE=TokuDB AUTO_INCREMENT=0 DEFAULT CHARSET=latin1 PAGE_CHECKSUM=1 TRANSACTIONAL=0 `compression`=TOKUDB_LZMA;
|
Query OK, 0 rows affected, 1 warning (0.03 sec)
|
|
MariaDB [my_db]> optimize table toku_bug;
|
+------------------+----------+----------+------------------------------------------------------------------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+------------------+----------+----------+------------------------------------------------------------------------------------+
|
| zija_db.toku_bug | optimize | note | Table does not support optimize, doing recreate + analyze instead |
|
| zija_db.toku_bug | optimize | error | Table storage engine 'TokuDB' does not support the create option 'TRANSACTIONAL=1' |
|
| zija_db.toku_bug | optimize | status | Operation failed |
|
+------------------+----------+----------+------------------------------------------------------------------------------------+
|
|
Attachments
Issue Links
- duplicates
-
MDEV-18428 Memory: If transactional=0 is specified in CREATE TABLE, it is not possible to ALTER TABLE
- Closed