← Back to team overview

maria-developers team mailing list archive

Updated (by Serg): insert ignore ha_extra hint (114)

 

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

PROGRESS NOTES:

-=-=(Serg - Mon, 10 May 2010, 14:35)=-=-
Category updated.
--- /tmp/wklog.114.old.7124     2010-05-10 14:35:59.000000000 +0000
+++ /tmp/wklog.114.new.7124     2010-05-10 14:35:59.000000000 +0000
@@ -1 +1 @@
-Server-Sprint
+Server-BackLog

-=-=(Serg - Mon, 10 May 2010, 14:35)=-=-
Version updated.
--- /tmp/wklog.114.old.7124     2010-05-10 14:35:59.000000000 +0000
+++ /tmp/wklog.114.new.7124     2010-05-10 14:35:59.000000000 +0000
@@ -1 +1 @@
-Server-9.x
+Server-5.3



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)