On 01/06/2009, at 2:55 PM, scut_tang wrote:
> 4. You said it is good for a clear API for I_S plugins, separate
> from server internals. But I think there must be some special for
> I_S storage engine. Because before "SELECT * FROM database.table",
> "USE database" must perform. So user must perform "USE
> INFORMATION_SCHEMA" before a query of I_S table, and this is not
> like the current style.
If you do SELECT * FROM dbname.tblname then it's not necessary to do
USE dbname first.
If you just to SELECT * FROM tblname then it is necessary to select a
default database name first.
From that perspective, the current I_S behaves just like any other
And the server won't care that it's implemented by an engine later
rather than by a hack in sql_show.cc ;-)
Arjen Lentz, Director @ Open Query (http://openquery.com)
Affordable Training and ProActive Support for MySQL & related
Follow our blog at http://openquery.com/blog/
OurDelta: free enhanced builds for MySQL @ http://ourdelta.org