Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2
-
None
Description
When flashback is enabled, the local value of binlog_format can still be set to STATEMENT or MIXED, and an informative warning is produced:
MariaDB [test]> show warnings;
|
+---------+------+------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+------------------------------------------------------------------+
|
| Warning | 1105 | MariaDB Galera and flashback do not support binlog format: MIXED |
|
+---------+------+------------------------------------------------------------------+
|
1 row in set (0.01 sec)
|
However, when one attempts to set the global value, it produces a generic error:
MariaDB [test]> set global binlog_format=mixed;
|
ERROR 1231 (42000): Variable 'binlog_format' can't be set to the value of 'mixed'
|
Maybe there is a reason why a local value can be set and global can not, but then the error message should at least say why it is not possible, referring to flashback.