Method create_table_from_items

sql/sql_insert.cc:4896–5128

*/

TABLE *select_create::create_table_from_items(THD *thd, List<Item> *items,
                                              MYSQL_LOCK **lock)
{
  TABLE tmp_table;		// Used during 'Create_field()'
  TABLE_SHARE share;
  TABLE *table= 0;
  alter_info->select_field_count= items->elements;
  /* Add selected items to field list */
  List_iterator_fast<Item> it(*items);
  Item *item;
  bool save_table_creation_was_logged;
  DBUG_ENTER("select_create::create_table_from_items");

  tmp_table.reset();
  tmp_table.s= &share;
  init_tmp_table_share(thd, &share, "", 0, "", "", true);
  tmp_table.in_use= thd;

  if (!(thd->variables.option_bits & OPTION_EXPLICIT_DEF_TIMESTAMP))
    promote_first_timestamp_column(&alter_info->create_list);

  while ((item=it++))
  {
    Field *tmp_field= item->create_field_for_create_select(thd->mem_root,
                                                           &tmp_table);

    if (!tmp_field)
      DBUG_RETURN(NULL);

    Field *table_field;

    switch (item->type())
    {
      /*
        We have to take into account both the real table's fields and
        pseudo-fields used in trigger's body. These fields are used
        to copy defaults values later inside constructor of
        the class Create_field.
      */
    case Item::FIELD_ITEM:
    case Item::TRIGGER_FIELD_ITEM:
      table_field= ((Item_field *) item)->field;
      break;
    default:
      table_field= NULL;
    }

    Create_field *cr_field= new (thd->mem_root)
                                  Create_field(thd, tmp_field, table_field);
    /*
      rather inconsistently we copy constant defaults and compression
      from the original field, but not default expression or check constraint
    */
    if (table_field && table_field->default_value &&
        !table_field->default_value->expr->const_item())
      cr_field->default_value= 0;
    cr_field->check_constraint= 0;