List:Internals« Previous MessageNext Message »
From:Sergei Golubchik Date:July 9 2009 9:56pm
Subject:Re: question on handler::start_bulk_insert
View as plain text  
Hi, Zardosht!

On Jul 09, Zardosht Kasheff wrote:
> Hello,
> 
> Is the handler guaranteed to have calls to handler::write_row
> surrounded by handler::start_bulk_insert and handler::end_bulk_insert?
> Or is it possible for a call to write_row to occur without a call to
> start_bulk_insert first.

It is possible.

INSERT t1 VALUES (1,2,3) -- should have no start_bulk_insert/end_bulk_insert

"bulk_insert" is when more than one row is inserted, like

INSERT ... VALUES (...),(...), ...
INSERT ... SELECT 
LOAD DATA INFILE
 
Regards / Mit vielen Grüßen,
Sergei

-- 
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Sergei Golubchik <serg@stripped>
 / /|_/ / // /\ \/ /_/ / /__  Principal Software Engineer/Server Architect
/_/  /_/\_, /___/\___\_\___/  Sun Microsystems GmbH, HRB München 161028
       <___/                  Sonnenallee 1, 85551 Kirchheim-Heimstetten
Geschäftsführer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
Vorsitzender des Aufsichtsrates: Martin Häring
Thread
question on handler::start_bulk_insertZardosht Kasheff9 Jul
  • Re: question on handler::start_bulk_insertSergei Golubchik9 Jul
    • Re: question on handler::start_bulk_insertZardosht Kasheff10 Jul
      • Re: question on handler::start_bulk_insertSergei Golubchik10 Jul