[MCOL-19] Update with cross engine join returned an error Created: 2016-05-03  Updated: 2016-06-11  Resolved: 2016-05-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: regression suite
Affects Version/s: None
Fix Version/s: 1.0.0

Type: Bug Priority: Major
Reporter: Dipti Joshi (Inactive) Assignee: Unassigned
Resolution: Fixed Votes: 0
Labels: 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.

 Comments   
Comment by Dipti Joshi (Inactive) [ 2016-05-23 ]

Daniel Lee has verified this by auto-pilot and it works now

Generated at Thu Feb 08 02:17:54 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.