From: Zardosht Kasheff Date: February 12 2010 10:08pm Subject: question on HA_EXTRA_IGNORE_DUP_KEY List-Archive: http://lists.mysql.com/internals/37708 Message-Id: <2f9663ba1002121408q3c1a424cndbc0dd82732c8fb6@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Hello all, I am trying to implement an optimization in our storage engine if HA_EXTRA_IGNORE_DUP_KEY is set. Would it be ok if handler::write_row returns success if this flag is set, the sql statement is NOT SQLCOM_REPLACE or SQLCOM_REPLACE_SELECT, and the row is not inserted if a duplicate is otherwise there. Basically, the question is if this flag is set, is it ok to not return HA_ERR_FOUND_DUPP_KEY in the cases where the statement is not "replace into". Thanks -Zardosht