Comment 6 for bug 997460

Revision history for this message
Scott Feldstein (scottmf76) wrote : Re: truncate table on aria storage engine fails inconsistently

Hey Elena,
I reproduced it very simply by running this set of sql:

MariaDB [mydb]> CREATE TABLE IF NOT EXISTS MYTABLE (
    -> TIMESTAMP bigint(20) NOT NULL,
    -> MEASUREMENT_ID int(11) NOT NULL,
    -> VALUE decimal(24,5) DEFAULT NULL,
    -> MINVALUE decimal(24,5) DEFAULT NULL,
    -> MAXXVALUE decimal(24,5) DEFAULT NULL,
    -> KEY MYTABLE_IDX (MEASUREMENT_ID)
    -> ) ENGINE=Aria
    -> PARTITION BY HASH(MEASUREMENT_ID)
    -> PARTITIONS 8;
Query OK, 0 rows affected (0.03 sec)

MariaDB [mydb]> set autocommit = 0;
Query OK, 0 rows affected (0.00 sec)

MariaDB [mydb]> truncate table MYTABLE;
ERROR 1031 (HY000): Table storage engine for 'MYTABLE' doesn't have this option

MariaDB [hqdb]> select @@version;
+--------------------+
| @@version |
+--------------------+
| 5.5.23-MariaDB-log |
+--------------------+
1 row in set (0.00 sec)

Let me know if you need anymore info.