Hi!
On Wed, Oct 26, 2005 at 07:00:32PM +0300, Vangelis Katsikaros wrote:
> Hello
>
> I would like to ask about struct ST_SCHEMA_TABLE found in sql\tables.h
> (version mysql-5.0.13-rc. If I am correct this struct didn't exist in
> early 5.0 versions).
>
> What does this struct represent? I can't make it out :( I found it in
> make_join_statistcs in the first for:
> if (tables->schema_table)
> table->file->records= 2;
> if we have this schema_table then the records of the table are two.
> The ST_SCHEMA_TABLE * TABLE_LIST::schema_table has the comment
> "information_schema table"
it represent "virtual" information schema tables, like
information_schema.charecter_sets, information_schema.tables and so on.
(see http://dev.mysql.com/doc/refman/5.0/en/information-schema.html)
You acn find information tables description array in sql/sql_show.cc:
ST_SCHEMA_TABLE schema_tables[]=
{
{"CHARACTER_SETS", charsets_fields_info, create_schema_table,
fill_schema_charsets, make_character_sets_old_format, 0, -1, -1, 0},
{"COLLATIONS", collation_fields_info, create_schema_table,
fill_schema_collation, make_old_format, 0, -1, -1, 0},
...
{"USER_PRIVILEGES", user_privileges_fields_info, create_schema_table,
fill_schema_user_privileges, 0, 0, -1, -1, 0},
{0, 0, 0, 0, 0, 0, 0, 0, 0}
};
[skip]
--
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin <sanja@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com
