Description:
If I make a view with a check option the
information_schema.views check_option column
contains 'WITH CASCADED CHECK OPTION' instead
of 'CASCADED'.
How to repeat:
mysql> create view v as select * from ttt with check option;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from information_schema.views;
+---------------+--------------+------------+--------------------------------------------------+----------------------------+--------------+
| TABLE_CATALOG | TABLE_SCHEMA | TABLE_NAME | VIEW_DEFINITION
| CHECK_OPTION | IS_UPDATABLE |
+---------------+--------------+------------+--------------------------------------------------+----------------------------+--------------+
| NULL | db5 | v | select `db5`.`ttt`.`s1` AS `s1` from `db5`.`ttt` | WITH
CASCADED CHECK OPTION | YES |
+---------------+--------------+------------+--------------------------------------------------+----------------------------+--------------+
1 row in set (0.04 sec)
