MariaDB [test]> CREATE SEQUENCE t1;
|
Query OK, 0 rows affected (0.20 sec)
|
|
MariaDB [test]> OPTIMIZE TABLE t1;
|
+---------+----------+----------+-----------------------------------------------------------+
|
| Table | Op | Msg_type | Msg_text |
|
+---------+----------+----------+-----------------------------------------------------------+
|
| test.t1 | optimize | note | The storage engine for the table doesn't support optimize |
|
+---------+----------+----------+-----------------------------------------------------------+
|
1 row in set, 1 warning (0.00 sec)
|
|
MariaDB [test]> show warnings;
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Level | Code | Message |
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
| Note | 1592 | Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. Statement is unsafe because it uses a system function that may return a different value on the slave |
|
+-------+------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MariaDB [test]> select @@binlog_format;
|
+-----------------+
|
| @@binlog_format |
|
+-----------------+
|
| MIXED |
|
+-----------------+
|
1 row in set (0.00 sec)
|