--source include/have_sequence.inc

create function f() returns int return 1;

--connect(con1,localhost,root,,)

--let $conid= `select connection_id()`

--send

  select f() from seq_1_to_10000000 where seq%1000000 = 0;

--connection default

--let $sent_rows=

while (`select INFO is not null from information_schema.processlist where id = $conid`)

{

  --let $rows= `select sent_rows from information_schema.processlist where id = $conid`

  if ($rows != $sent_rows)

  {

    --echo # Found SENT_ROWS = $rows

    --let $sent_rows= $rows

  }

}

--enable_query_log

--connection con1

--reap

drop function f;

connection default;

# Found SENT_ROWS = 0

# Found SENT_ROWS = 1

# Found SENT_ROWS = 0

# Found SENT_ROWS = 3

# Found SENT_ROWS = 7

# Found SENT_ROWS = 15

# Found SENT_ROWS = 31

# Found SENT_ROWS = 63

# Found SENT_ROWS = 127

# Found SENT_ROWS = 255

# Found SENT_ROWS = 511

# Found SENT_ROWS = 0

connection con1;

f()

1

1

1

1

1

1

1

1

1

1

select f() from seq_1_to_10000000

connect con1,localhost,root,,;

select f() from seq_1_to_10000000;

connection default;

# Found SENT_ROWS = 0

# Found SENT_ROWS = 2147483647

# Found SENT_ROWS = 0

# Found SENT_ROWS = 2147483647

# Found SENT_ROWS = 0

# Found SENT_ROWS = 2147483647

# Found SENT_ROWS = 0

...