>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 ;-)
Yes, you are right. I make a stupid mistake again^_^.
Although the server won't care that it's implemented by an engine later
rather than by a hack, optimizer can be fully used and it looks elegant if using an
>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
>MySQL Summer of Code Mailing List
>For list archives: http://lists.mysql.com/soc
>To unsubscribe: http://lists.mysql.com/soc?unsub=1