From: Michael Widenius
Date: March 6 2013 9:35pm
Subject: Re: effects of load data local on RSS
List-Archive: http://lists.mysql.com/internals/38748
Message-Id: <20791.46735.93610.554523@narttu.askmonty.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


hi!

>>>>> "Zardosht" == Zardosht Kasheff <zardosht@stripped> writes:

Zardosht> Here is a stack trace where for LOAD DATA LOCAL, we get a call to
Zardosht> handler::extra with operation set to HA_EXTRA_IGNORE_DUP_KEY

<cut>

I missed the following code (was not totally obvious):

  /* We can't give an error in the middle when using LOCAL files */
  if (read_file_from_client && handle_duplicates == DUP_ERROR)
    ignore= 1;

So yes, LOAD DATA LOCAL has an implicite IGNORE.

Regards,
Monty