Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-18987

bug in "load data local infile xxx replace into "

Details

    Description

      Fix bug in "load data local infile xxx replace into ",this query distributed "insert into ignore" to remote mysql
      query: load data local infile xxx replace into table t
      before: insert ignore xxx into table t
      now: replace xxx into table t

      Attachments

        Activity

          willhan willhan added a comment - WILL-9f8a92
          Kentoku Kentoku Shiba (Inactive) added a comment - - edited

          willhan
          I added tests for reproducing this issue. But I couldn't reproduce it. Please check test results of the following commit.
          688ae9a

          Kentoku Kentoku Shiba (Inactive) added a comment - - edited willhan I added tests for reproducing this issue. But I couldn't reproduce it. Please check test results of the following commit. 688ae9a
          willhan willhan added a comment -

          test case ( load data replace...)
          when set spider_direct_dup_insert=1;(our defaults value, can be more effective)
          spider will dispatch insert ignore but not "select+update", but we need "replace into"

          willhan willhan added a comment - test case ( load data replace...) when set spider_direct_dup_insert=1;(our defaults value, can be more effective) spider will dispatch insert ignore but not "select+update", but we need "replace into"

          willhan Please see load_data_local_replace_ddi1.result
          This sends "replace into" to the data node.

          Kentoku Kentoku Shiba (Inactive) added a comment - willhan Please see load_data_local_replace_ddi1.result This sends "replace into" to the data node.

          People

            ycp Yuchen Pei
            willhan willhan
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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