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.
Hey Elena,
I reproduced it very simply by running this set of sql:
MariaDB [mydb]> CREATE TABLE IF NOT EXISTS MYTABLE ( T_ID)
-> 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(MEASUREMEN
-> 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.