[MDEV-18987] bug in "load data local infile xxx replace into " Created: 2019-03-21  Updated: 2023-10-26

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: willhan Assignee: Yuchen Pei
Resolution: Unresolved Votes: 0
Labels: None


 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



 Comments   
Comment by willhan [ 2019-03-29 ]

WILL-9f8a92

Comment by Kentoku Shiba (Inactive) [ 2019-04-06 ]

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

Comment by willhan [ 2019-04-09 ]

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"

Comment by Kentoku Shiba (Inactive) [ 2019-11-12 ]

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

Generated at Thu Feb 08 08:48:14 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.