Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
12.0
-
None
Description
When the new variable create_temporary_table_binlog_formats is set to 'mixed' the SELECT shows a different value 'MIXED,STATEMENT'.
11.8.1-opt>SET create_temporary_table_binlog_formats = 'mixed';
|
Query OK, 0 rows affected (0.000 sec)
|
|
|
11.8.1-opt>SELECT @@create_temporary_table_binlog_formats;
|
+-----------------------------------------+
|
| @@create_temporary_table_binlog_formats |
|
+-----------------------------------------+
|
| MIXED,STATEMENT |
|
+-----------------------------------------+
|
1 row in set (0.000 sec)
|
Expected behavior:
SQL-standard-wise SELECT should only show that which the variable was SET to.
Attachments
Issue Links
- is caused by
-
MDEV-36099 Ensure that creation and usage of temporary tables in replication is predictable
-
- Closed
-