static int test_metadata(MYSQL *mysql)

{

  int rc;

  char *query1= "SELECT 1,2 FROM DUAL";

  char *query2= "SHOW CREATE TABLE test_metadata";

  MYSQL_STMT *stmt= mysql_stmt_init(mysql);

  rc= mysql_query(mysql, "DROP TABLE IF EXISTS test_metadata");

  check_mysql_rc(rc, mysql);

  rc= mysql_query(mysql, "CREATE TABLE test_metadata (a int)"); 

  check_mysql_rc(rc, mysql);

  rc= mysql_stmt_prepare(stmt, query1, strlen(query1));

  check_stmt_rc(rc, stmt);

  diag("Fields in result set after prepare: %u", mysql_stmt_field_count(stmt));

  rc= mysql_stmt_prepare(stmt, query2, strlen(query2));

  check_stmt_rc(rc, stmt);

  diag("Fields in result set after prepare: %u", mysql_stmt_field_count(stmt));

  rc= mysql_stmt_execute(stmt);

  diag("Fields in result set after execute: %u", mysql_stmt_field_count(stmt));

  mysql_stmt_close(stmt);

}

# Fields in result set after prepare: 2

# Fields in result set after prepare: 0

# Fields in result set after execute: 2