← Back to team overview

drizzle-discuss team mailing list archive

Re: PROPOSAL: Rename plugin::InfoSchemaTable -> plugin::InfoSchemaView

 

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 <roland.bouman@xxxxxxxxx> 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 <Jay.Pipes@xxxxxxx> 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     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
> >> 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     : drizzle-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~drizzle-discuss
> More help   : https://help.launchpad.net/ListHelp



Follow ups

References