From: Zardosht Kasheff
Date: July 9 2009 10:01pm
Subject: Re: question on handler::start_bulk_insert
List-Archive: http://lists.mysql.com/internals/37162
Message-Id: <2f9663ba0907091501h2fafe34rc932e2dfa49e62ee@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hello Sergei,

Thank you for your reply. However, I have just seen the following
steps result in a call to handler::start_bulk_insert and
handler::end_bulk_insert. The the value of rows in start_bulk_insert
was 1.

mysql> create table foo (a int, b int) engine =3D tokudb;
Query OK, 0 rows affected (0.00 sec)

mysql> insert into foo values (1,1);

So it seems to be called here as well.

This is on 5.1.30.

-Zardosht


On Thu, Jul 9, 2009 at 5:56 PM, Sergei Golubchik<serg@stripped> wrote:
> 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_ins=
ert
>
> "bulk_insert" is when more than one row is inserted, like
>
> INSERT ... VALUES (...),(...), ...
> INSERT ... SELECT
> LOAD DATA INFILE
>
> Regards / Mit vielen Gr=FC=DFen,
> Sergei
>
> --
> =A0 __ =A0___ =A0 =A0 ___ ____ =A0__
> =A0/ =A0|/ =A0/_ __/ __/ __ \/ / =A0 Sergei Golubchik <serg@stripped>
> =A0/ /|_/ / // /\ \/ /_/ / /__ =A0Principal Software Engineer/Server Arch=
itect
> /_/ =A0/_/\_, /___/\___\_\___/ =A0Sun Microsystems GmbH, HRB M=FCnchen 16=
1028
> =A0 =A0 =A0 <___/ =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0Sonnenallee 1, 85551=
 Kirchheim-Heimstetten
> Gesch=E4ftsf=FChrer: Thomas Schroeder, Wolfgang Engels, Wolf Frenkel
> Vorsitzender des Aufsichtsrates: Martin H=E4ring
>