BTW Info -> Information On Dec 2, 2009, at 1:15 PM, Eric Day wrote:
> I agree with Roland, view may be slightly more accurate, but is not > "correct". Any reason we need the suffix type on there at all? Why > not just: > > plugin::InfoSchemaTable -> plugin::InfoSchema > > -Eric > > On Wed, Dec 02, 2009 at 09:53:51PM +0100, Roland Bouman wrote: >> Oh, I forgot to mention - the term "view" would also be not entirely >> appropriate in this case, because it can potentially be confused with >> VIEW schema objects. >> (which is why the information schema itself reports "SYSTEM VIEW" as >> the TABLE_TYPE for information_schema tables, at least, in standard >> SQL) >> >> On Wed, Dec 2, 2009 at 9:50 PM, Roland Bouman <[email protected]> >> wrote: >>> Hi Jay, >>> >>> I don't think "table" is wrong (although I can imagine its considered >>> confusing). >>> >>> I mean " table " conveys something about the organization of the data. >>> Even the result of a SELECT is a table in this sense, so is a view, >>> and so is a "base table" (often casually referred to as simply >>> "table") >>> >>> >>> >>> On Wed, Dec 2, 2009 at 9:16 PM, Jay Pipes <[email protected]> wrote: >>>> Subject says it all. >>>> >>>> INFORMATION_SCHEMA objects aren't tables, they are views, as they are only >>>> read-only materializations of data stored in other places (hash_map<>s, >>>> other real tables, HASHs, etc) >>>> >>>> Thoughts? >>>> >>>> -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 >>>> >>> >>> >>> >>> -- >>> Roland Bouman >>> http://rpbouman.blogspot.com/ >>> >>> Author of "Pentaho Solutions: Business Intelligence and Data >>> Warehousing with Pentaho and MySQL", >>> http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470484322.html >>> >> >> >> >> -- >> Roland Bouman >> http://rpbouman.blogspot.com/ >> >> Author of "Pentaho Solutions: Business Intelligence and Data >> Warehousing with Pentaho and MySQL", >> http://www.wiley.com/WileyCDA/WileyTitle/productCd-0470484322.html >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~drizzle-discuss >> Post to : [email protected] >> Unsubscribe : https://launchpad.net/~drizzle-discuss >> More help : https://help.launchpad.net/ListHelp > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
