maria-developers team mailing list archive

[worklog-noreply@xxxxxxxxxxxx]

-----------------------------------------------------------------------
                              WORKLOG TASK
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
TASK...........: insert ignore ha_extra hint 
CREATION DATE..: Sun, 25 Apr 2010, 16:32
SUPERVISOR.....: Sergei
IMPLEMENTOR....: 
COPIES TO......: 
CATEGORY.......: Server-Sprint
TASK ID........: 114 (http://askmonty.org/worklog/?tid=114)
VERSION........: Server-9.x
STATUS.........: Un-Assigned
PRIORITY.......: 60
WORKED HOURS...: 0
ESTIMATE.......: 0 (hours remain)
ORIG. ESTIMATE.: 0

PROGRESS NOTES:



DESCRIPTION:

There is HA_EXTRA_WRITE_CAN_REPLACE hint that tells the engine that the
following ::write_row() calls are part of the REPLACE statement, not INSERT.
With this knowledge the engine can execute the replace internally, deleting the
conflicting row in the ::write_row() method instead of returning an error.

We need a similar HA_EXTRA_WRITE_CAN_IGNORE hint to allow engines to optimize
INSERT IGNORE in a similar way.


ESTIMATED WORK TIME

ESTIMATED COMPLETION DATE
-----------------------------------------------------------------------
WorkLog (v3.5.9)