Method set_parameters

sql/sql_prepare.cc:4556–4628

*/

bool
Prepared_statement::set_parameters(String *expanded_query,
                                   const InstrSlice &instrs_set_placeholder,
                                   uchar *packet, uchar *packet_end)
{
  bool is_sql_ps= packet == NULL;
  bool res= FALSE;

  if (is_sql_ps)
  {
    /* SQL prepared statement */
    const sp_lex_cursor *clex= thd->lex->get_lex_for_cursor();
    if (!clex || (clex->get_ps_name().is_null() &&
                  clex->prepared_stmt.code() == nullptr))
    {
      /*
        Set placehoder values from prepared_stmt.params() only for
        static cursors.
        Dynamic cursors set placeholder values using a different way:
        with help of sp_instr_set_ps_placeholder instructions.
      */
      res= set_params_from_actual_params(this, thd->lex->prepared_stmt.params(),
                                         expanded_query);
    }
    else
    {
      /*
        Set parameters from sp_instr_set_ps_placeholder's.
        Non-zero instr_set_placeholder_count is not possible for
        SQL Standard dynamic cursors:
          DECLARE c CURSOR FOR stmt;
          PREPARE stmt FROM 'SELECT ?';
          OPEN c USING 'value';
        It's only possibly for Oracle style dynamic cursors:
          OPEN c FOR 'SELECT ?'

        as sp_instr_set_ps_placeholder handles USING expressions as follows:
        - whites the value directly to Prepared_statement::param_array[idx]
          for the former
        - caches the value in sp_instr_set_ps_placeholder for the latter.
      */
      DBUG_ASSERT(!instrs_set_placeholder.count() ||
                  clex->prepared_stmt.code() != nullptr);
      if (instrs_set_placeholder.count() &&
          set_placeholders_from_instr(instrs_set_placeholder))
        return true;
    }
  }
  else if (param_count)
  {
#ifndef EMBEDDED_LIBRARY
    uchar *null_array= packet;
    res= (setup_conversion_functions(this, &packet) ||
          set_params(this, null_array, packet, packet_end, expanded_query));
#else
    /*
      In embedded library we re-install conversion routines each time
      we set parameters, and also we don't need to parse packet.