← Back to team overview

drizzle-discuss team mailing list archive

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

 

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

Because a Schema != View. :)

-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




References