~drizzle-trunk/drizzle/development

           {

             Lex->sql_command= SQLCOM_SELECT;

             drizzled::statement::Show *select= new statement::Show(YYSession);

             Lex->statement= select;

 

             if (prepare_new_schema_table(YYSession, Lex, "SCHEMA_SQL_DEFINITION"))

               DRIZZLE_YYABORT;

 

             util::string::const_shared_ptr schema(YYSession->schema());

             if ($4.str)

             {

              select->setShowPredicate($4.str);

             }

             else if (schema)

             {

               select->setShowPredicate(*schema);

             }

             else

             {

               my_error(ER_NO_DB_ERROR, MYF(0));

               DRIZZLE_YYABORT;

             }

 

             std::string key("Database");

             std::string value("Create Database");

 

             Item_field *my_field= new Item_field(&YYSession->lex->current_select->context, NULL, NULL, "SCHEMA_NAME");

             my_field->is_autogenerated_name= false;

             my_field->set_name(key.c_str(), key.length(), system_charset_info);

 

             if (YYSession->add_item_to_list(my_field))

               DRIZZLE_YYABORT;

 

             my_field= new Item_field(&YYSession->lex->current_select->context, NULL, NULL, "SCHEMA_SQL_DEFINITION");

             my_field->is_autogenerated_name= false;

             my_field->set_name(value.c_str(), value.length(), system_charset_info);

 

             if (YYSession->add_item_to_list(my_field))

               DRIZZLE_YYABORT;

           }