← Back to team overview

drizzle-discuss team mailing list archive

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

 

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 <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
> 
> _______________________________________________
> 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