Function mysql_sql_stmt_execute

sql/sql_prepare.cc:3556–3665

*/

static
bool mysql_sql_stmt_execute(THD *thd, const Lex_ident_sys &name,
                            const char *cmd,
                            bool open_dynamic_cursor,
                            select_result *result_arg,
                            Server_side_cursor **cursor_arg)
{
  LEX *lex= thd->lex;
  Prepared_statement *stmt;
  /* Query text for binary, general or slow log, if any of them is open */
  String expanded_query;
  DBUG_ENTER("mysql_sql_stmt_execute");
  DBUG_PRINT("info", ("EXECUTE: %.*s", (int) name.length, name.str));
  CSET_STRING orig_query= thd->query_string;

  if (!(stmt= Prepared_statement::find_by_name_or_error(thd, name, cmd)))
    DBUG_RETURN(true);

  DBUG_PRINT("info",("stmt: %p", stmt));

  if (!open_dynamic_cursor)
  {
    if (stmt->param_count != lex->prepared_stmt.param_count())
    {
      my_error(ER_WRONG_ARGUMENTS, MYF(0), cmd);
      DBUG_RETURN(true);
    }

    if (lex->prepared_stmt.params_fix_fields(thd))
      DBUG_RETURN(true);
  }
  else
  {
    if (stmt->lex->sql_command != SQLCOM_SELECT)
    {
      my_error(ER_SP_BAD_CURSOR_QUERY, MYF(0));
      DBUG_RETURN(true);
    }

    /*
      Check if all placeholder parameters were set by the USING list:
        OPEN c USING expr1, expr2;
    */
    if (stmt->check_all_placeholders_set())
      DBUG_RETURN(true);
  }

  /*
    thd->free_list can already have some Items.

    Example queries:
      - SET STATEMENT var=expr FOR EXECUTE stmt;
      - EXECUTE stmt USING expr;

    E.g. for a query like this:
      PREPARE stmt FROM 'INSERT INTO t1 VALUES (@@max_sort_length)';
      SET STATEMENT max_sort_length=2048 FOR EXECUTE stmt;
    thd->free_list contains a pointer to Item_int corresponding to 2048.