Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Duplicate
-
10.3(EOL)
-
None
Description
10.3 6686dfcbbf7 |
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) |
It doesn't make much sense to OPTIMIZE a sequence, but still, the warning is obviously weird and misplaced.
Attachments
Issue Links
- is duplicated by
-
MDEV-24617 OPTIMIZE on a sequence causes unexpected ER_BINLOG_UNSAFE_STATEMENT warning
- Closed