Bug #16832 ALGORITHM missing from "information_schema.views"
Submitted: 27 Jan 2006 10:56 Modified: 23 Jul 2006 6:10
Reporter: Magnus Blaudd
Status: Closed
Category:Server: I_S Severity:S3 (Non-critical)
Version:5.0 OS:Any (All)
Assigned to: Alexey Botchkov Target Version:

[27 Jan 2006 10:56] Magnus Blaudd 
Description:
The information_schema table "information_schema.views" does not contain information
about which algorithm the view uses.

select * from information_schema.views where table_name="v";
TABLE_CATALOG NULL
TABLE_SCHEMA  test
TABLE_NAME    v
VIEW_DEFINITION       select `test`.`t`.`s2` AS `s2`,`test`.`t`.`s1` AS `s1`
from `test`.`t` where (`test`.`t`.`s1` > 5) order by `test`.`t`.`s1`
CHECK_OPTION  NONE
IS_UPDATABLE  NO
DEFINER       root@localhost
SECURITY_TYPE DEFINER

This information is available in "SHOW CREATE VIEW "

How to repeat:
select * from information_schema.views where table_name="v";

Suggested fix:
Add the field ALGORITHM to "information_schema.views"
[27 Jan 2006 12:42] Miguel Solorzano 
Thank you for the bug report.
[8 Feb 2006 14:40] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2317
[13 Jun 2006 12:07] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7561
[13 Jun 2006 12:18] Sergey Gluhov 
ok to push
[13 Jun 2006 14:05] Bugs System 
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/7564
[23 Jul 2006 6:03] Paul DuBois 
Noted in 5.0.25 changelog.

The VIEW_DEFINITION column of the INFORMATION_SCHEMA VIEWS table now
contains information about the view algorithm.