Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
Description
update nation a, myisamdb.region b set a.n_nationkey = 100 where a.n_regionkey = b.r_regionkey and b.r_regionkey = 5;
ERROR 1663 (HY000) at line 15: Cannot execute statement: impossible to write to binary log since statement is unsafe, storage engine is limited to statement-based logging, and BINLOG_FORMAT = MIXED. Statement accesses nontransactional table as well as transactional or temporary table, and writes to any of them.