INSERT ... SELECT ON DUPLICATE

[dbrb2002-sql]

Does anyone know if I can add a hint SQL_BUFFER_RESULT to INSERT .. SELECT ON DUPLICATE

ex..

INSERT INTO foo
SELECT SQL_BUFFER_RESULT* FROM bar
ON DUPLICATE KEY UPDATE foo.X=..

Both my tables foo and bar are InnoDB; but the idea is to release the lock on bar as soon
as possible by moving the results to temp table to accommodate slow inserts..

Any reco or does SQL_BUFFER_RESULT work in this case ?

Thanks