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

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.

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 >

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.

Page generated in 0.038 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.