Bug #5988 Views with check option: no CASCADED if no WHERE clause
Submitted: 8 Oct 2004 20:56 Modified: 22 Oct 2004 7:46
Reporter: Peter Gulutzan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.0.2-alpha-debug OS:Linux (SuSE 8.2)
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[8 Oct 2004 20:56] Peter Gulutzan
Description:
If I insert into a view v2 with a CASCADED check option, 
and v2 has an underlying view v1 with a LOCAL check option, 
then the WHERE clause of v1 should be checked. It seems 
that it's only checked if view v2 has a WHERE clause. 

How to repeat:
mysql> create table ti (s1 tinyint); 
Query OK, 0 rows affected (0.26 sec) 
 
mysql> create view vi1 as select * from ti where s1 <> 0 with local check option; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> create view vi2 as select * from vi1 with cascaded check option; 
Query OK, 0 rows affected (0.00 sec) 
 
mysql> insert into vi2 values (0); 
Query OK, 1 row affected (0.00 sec)
[8 Oct 2004 22:06] MySQL Verification Team
Verified on latest Bk source.
[21 Oct 2004 10:32] Oleksandr Byelkin
ChangeSet 
  1.1665 04/10/21 13:30:25 bell@sanja.is.com.ua +3 -0 
  Allow inheriting check options if view have not WHERE clause (BUG#5988)
[22 Oct 2004 7:46] Oleksandr Byelkin
Thank you for bugreport! Bug is fixed patch is pushed.