diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-10-21 17:05:45 +0300 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-10-21 17:05:45 +0300 |
| commit | 0ea04229074645b2642456158ac120448dfa6334 (patch) | |
| tree | 42b1e437dccc9771797e363e83790462632bfbd7 /mysql-test/t/view.test | |
| parent | 2aad30394d33eef23545d717f4b92eb280c2b19d (diff) | |
| download | mariadb-git-0ea04229074645b2642456158ac120448dfa6334.tar.gz | |
value should be checked after 'before' trigger work (BUG#5992)
mysql-test/r/view.result:
changing value by trigger and CHECK OPTION
mysql-test/t/view.test:
changing value by trigger and CHECK OPTION
sql/sql_insert.cc:
value should be checked after 'before' trigger work
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 282ea827c6a..fdf431f0107 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -1497,3 +1497,17 @@ select * from t1; drop view v1; drop table t1; +# +# changing value by trigger and CHECK OPTION +# +create table t1 (s1 tinyint); +create trigger t1_bi before insert on t1 for each row set new.s1 = 500; +create view v1 as select * from t1 where s1 <> 127 with check option; +-- error 1369 +insert into v1 values (0); +select * from v1; +select * from t1; +drop view v1; +drop table t1; + + |