## Test of cursor fetch functionality

## Preamble
--source include/xplugin_preamble.inc
--source include/xplugin_create_user.inc
## Test starts here

--write_file $MYSQL_TMP_DIR/cursor_fetch.xpl

Mysqlx.Prepare.Prepare {
  stmt_id: 1
  stmt: {
    type: STMT
    stmt_execute: {
      stmt: 'SELECT * FROM xtest.t1'
    }
  }
}
-->recvok

-->title = Fetch all rows in Cursor.Open

Mysqlx.Cursor.Open {
  cursor_id: 1
  stmt: {
    type: PREPARE_EXECUTE
    prepare_execute: {
      stmt_id: 1
    }
  }
  fetch_rows: 0
}
-->recvresult_store_metadata META_ID

Mysqlx.Cursor.Fetch {
  cursor_id: 1
  fetch_rows: 2
}
-->recv_with_stored_metadata META_ID
-->clear_stored_metadata

EOF

CREATE SCHEMA IF NOT EXISTS xtest;
USE xtest;
create table t1(
k   char(8) default ' ' not null ,
c00 char(50) default ' ' not null ,
c01 char(50) default ' ' not null,
c02 char(50) default ' ' not null,
c03 char(50) default ' ' not null,
c04 char(50) default ' ' not null,
c05 char(50) default ' ' not null,
c06 char(50) default ' ' not null,
c07 char(50) default ' ' not null,
c08 char(50) default ' ' not null,
c09 char(50) default ' ' not null,
c10 char(50) default ' ' not null,
c11 char(50) default ' ' not null,
c12 char(50) default ' ' not null,
c13 char(50) default ' ' not null,
c14 char(50) default ' ' not null,
c15 char(50) default ' ' not null,
c16 char(50) default ' ' not null,
c17 char(50) default ' ' not null,
c18 char(50) default ' ' not null,
c19 char(50) default ' ' not null,
c20 char(50) default ' ' not null,
c21 char(50) default ' ' not null,
c22 char(50) default ' ' not null,
c23 char(50) default ' ' not null,
c24 char(50) default ' ' not null,
c25 char(50) default ' ' not null,
c26 char(50) default ' ' not null,
c27 char(50) default ' ' not null,
c28 char(50) default ' ' not null,
c29 char(50) default ' ' not null,
c30 char(50) default ' ' not null,
c31 char(50) default ' ' not null,
c32 char(50) default ' ' not null,
c33 char(50) default ' ' not null,
c34 char(50) default ' ' not null,
c35 char(50) default ' ' not null,
c36 char(50) default ' ' not null,
c37 char(50) default ' ' not null,
c38 char(50) default ' ' not null,
c39 char(50) default ' ' not null,
c40 char(50) default ' ' not null,
c41 char(50) default ' ' not null,
c42 char(50) default ' ' not null,
c43 char(50) default ' ' not null,
constraint pk_t1 primary key(k)
) CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

insert into t1(k) values('00000001');
insert into t1(k) values('00000002');

set global tmp_table_size=1024;

exec $MYSQLXTEST
  -ux_root --password=''
  --file=$MYSQL_TMP_DIR/cursor_fetch.xpl 2>&1;

## Cleanup
set global tmp_table_size = default;
--source ../include/xplugin_cleanup.inc