Information Schema will be just the ANSI schemas, nothing more. DD will have a much longer list of schemas to it (which is similar to how PG/Oracle/MS does it). There is debate about having non-ANSI columns in the schemas, but the schemas themselves will be limited to just the standard.
That makes sense. A little confusing to end user but what your saying is all details will be in data dictionary. Information schema will reflect the ANSI standard view, i.e. a subset of data dictionary data. > > It also seems that the DESC command has morphed from the older MySQL >> output. What's missing is the *length* of types! >> > > Here is the question do you want LENGTH as in number of bytes, or in number > of characters? Just for VARCHAR? > > That is a good question. if you went with bytes, then technically you could show bytes for all date types. If DESC is short for providing value add information and a different view to a SHOW CREATE TABLE/SELECT ... DD.TABLES is used for table definition, then I could see a reason for bytes. > We are just listing the type right now. I can add another column for > length, but what would go there for NUMBER/etc? > > Thanks! > -Brian
_______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
