Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-19

Update with cross engine join returned an error

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            dshjoshi Dipti Joshi (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.