static int test_conpy135(MYSQL *mysql)

{

  int rc;

  MYSQL_STMT *stmt;

  MYSQL_BIND bind;

  unsigned int vals[]= {1,2,3};

  unsigned int array_size= 3;

  MYSQL_ROW row;

  MYSQL_RES *result;

  rc= mysql_query(mysql, "CREATE OR REPLACE TABLE t1 (a int)");

  check_mysql_rc(rc, mysql);

  rc= mysql_query(mysql, "CREATE OR REPLACE TABLE t2 (a int)");

  check_mysql_rc(rc, mysql);

  rc= mysql_query(mysql, "CREATE TRIGGER t1_before_insert BEFORE INSERT ON t1\n"

                         "FOR EACH ROW BEGIN\n"

                         "   INSERT INTO t2 (a) VALUES (NEW.a);\n"

                         "END");

  check_mysql_rc(rc, mysql);

  stmt= mysql_stmt_init(mysql);

  rc= mysql_stmt_prepare(stmt, SL("INSERT INTO t1 VALUES (?)"));

  check_stmt_rc(rc, stmt);

  memset(&bind, 0, sizeof(MYSQL_BIND));

  bind.buffer_type= MYSQL_TYPE_LONG;

  bind.buffer= vals;

  rc= mysql_stmt_attr_set(stmt, STMT_ATTR_ARRAY_SIZE, &array_size);

  check_stmt_rc(rc, stmt);

  rc= mysql_stmt_bind_param(stmt, &bind);

  check_stmt_rc(rc, stmt);

  rc= mysql_stmt_execute(stmt);

  check_stmt_rc(rc, stmt);

  diag("affected rows: %lld", mysql_stmt_affected_rows(stmt));

  rc= mysql_query(mysql, "SELECT 't1', a FROM t1 UNION SELECT 't2', a FROM t2");

  check_mysql_rc(rc, mysql);

  result= mysql_store_result(mysql);

  while ((row = mysql_fetch_row(result)))

    diag("%s | %s ", row[0], row[1]);

  mysql_free_result(result);

  return OK;

}

# affected rows: 3

# t1 | 1 

# t1 | 2 

# t1 | 3 

# t2 | 1 

# t2 | 2 

# t2 | 3

# affected rows: 1

# t1 | 1 

# t2 | 1