Bug #37670 The CHECK_OPTION column of the VIEWS I_S table is correct
Submitted: 26 Jun 2008 15:44 Modified: 8 Jul 2008 18:10
Reporter: Anders Karlsson Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0.58 OS:Any
Assigned to: Paul DuBois CPU Architecture:Any

[26 Jun 2008 15:44] Anders Karlsson 
Description:
The docs says about CHECK_OPTION in the VIEWS INFORMATION_SCHEMA table, that this always contains the value NONE. Actually, this is incorrect, the CHECK_OPTION column correctly contains the values NONE, CASCADE or LOCAL respectively, as it should. This was observered in server version 5.0.58.

How to repeat:
Read the docs.

Suggested fix:
Fix the docs accordingly.
[26 Jun 2008 16:32] MySQL Verification Team 
Thank you for the bug report.

mysql 5.0 > select * from views\G
*************************** 1. row ******
  TABLE_CATALOG: NULL
   TABLE_SCHEMA: test
     TABLE_NAME: v
VIEW_DEFINITION: /* ALGORITHM=UNDEFINED *
   CHECK_OPTION: CASCADED
   IS_UPDATABLE: YES
        DEFINER: root@localhost
  SECURITY_TYPE: DEFINER
1 row in set (0.01 sec)

mysql 5.0 >
[8 Jul 2008 18:10] Paul DuBois 
Thank you for your bug report. This issue has been addressed in the documentation. The updated documentation will appear on our website shortly, and will be included in the next release of the relevant products.