INFORMATION_SCHEMA.TABLE_PRIVILEGES has a misspelled name

[Patrick Crews]

The INFORMATION_SCHEMA table - TABLE_PRIVILEGES is misspelled:

SELECT * FROM data_dictionary.tables WHERE table_name LIKE '%PRIV%';
TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_COLLATION TABLE_CREATION_TIME TABLE_UPDATE_TIME TABLE_COMMENT
INFORMATION_SCHEMA COLUMN_PRIVILEGES FUNCTION FunctionEngine DEFAULT utf8_general_ci Thu Jan 01 03:00:00 1970 Thu Jan 01 03:00:00 1970

************************************* Bug here
INFORMATION_SCHEMA TABLE_PRIVILEDGES FUNCTION FunctionEngine DEFAULT utf8_general_ci Thu Jan 01 03:00:00 1970 Thu Jan 01 03:00:00 1970

[Brian Aker (brianaker)]

Fixed?

Cheers,
   --Brian

On Jul 20, 2010, at 10:20 AM, Lee Bieber <email address hidden> wrote:

> ** Changed in: drizzle/dexter
> Importance: Undecided => Low
>
> --
> INFORMATION_SCHEMA.TABLE_PRIVILEGES has a misspelled name
> https://bugs.launchpad.net/bugs/583081
> You received this bug notification because you are a member of Drizzle-
> developers, which is subscribed to Drizzle.
>
> Status in A Lightweight SQL Database for Cloud and Web: Fix Released
> Status in Drizzle dexter series: Fix Released
>
> Bug description:
> The INFORMATION_SCHEMA table - TABLE_PRIVILEGES is misspelled:
>
> SELECT * FROM data_dictionary.tables WHERE table_name LIKE '%PRIV%';
> TABLE_SCHEMA TABLE_NAME TABLE_TYPE ENGINE ROW_FORMAT TABLE_COLLATION TABLE_CREATION_TIME TABLE_UPDATE_TIME TABLE_COMMENT
> INFORMATION_SCHEMA COLUMN_PRIVILEGES FUNCTION FunctionEngine DEFAULT utf8_general_ci Thu Jan 01 03:00:00 1970 Thu Jan 01 03:00:00 1970
>
> ************************************* Bug here
> INFORMATION_SCHEMA TABLE_PRIVILEDGES FUNCTION FunctionEngine DEFAULT utf8_general_ci Thu Jan 01 03:00:00 1970 Thu Jan 01 03:00:00 1970
>
>