Brian Aker wrote: > Hi! > > On Aug 18, 2008, at 6:44 PM, Baron Schwartz wrote: > >> Yeah, do we really need SHOW anymore at all? I would argue not. > > I go back and forth on this. > > Right now I believe: > 1) Keeping them in the client I think is a win. > 2) Right now we need them because for replication not everything is in I_S. > 3) SHOW CREATE TABLE is required no matter what... or we have to find > some similar syntax (I personally find it really useful).
Again, I return to the idea that SHOW and other commands like DESC can be implemented as a raw string replacement on the client. Basically, convert SHOW TABLES to SELECT TABLE_NAME.TABLE FROM INFORMATION_SCHEMA, etc... As for SHOW CREATE TABLE, besides the comment given in the create statement (which we currently are planning to store using Proto Buffers in Field::comment()) is there anything about the SHOW CREATE TABLE statement that *cannot* be generated from schema information stored in I_S? Less in the server syntax parser, the better IMHO. Cheers, jay _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
