diff options
| author | bell@sanja.is.com.ua <> | 2004-10-21 13:39:17 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-10-21 13:39:17 +0300 |
| commit | 05af0c26c12832e184061ad07c55457f5ab1e9e0 (patch) | |
| tree | 12043f459d1c0b6f456a3ef697c53755b38706ff | |
| parent | 370edf063d4ffa8a8a0b79a3c309e2fb0ca0eb8d (diff) | |
| download | mariadb-git-05af0c26c12832e184061ad07c55457f5ab1e9e0.tar.gz | |
fixed default behaviour of WITH CHECK OPTIONS according to standard (BUG#5989)
| -rw-r--r-- | mysql-test/r/view.result | 2 | ||||
| -rw-r--r-- | sql/sql_yacc.yy | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 9dcf0833c18..2e5d7073c5a 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -1467,7 +1467,7 @@ v1 CREATE ALGORITHM=UNDEFINED VIEW `test`.`v1` AS select `test`.`t1`.`a` AS `a` alter algorithm=undefined view v1 as select * from t1 with check option; show create view v1; View Create View -v1 CREATE ALGORITHM=UNDEFINED VIEW `test`.`v1` AS select `test`.`t1`.`a` AS `a` from `test`.`t1` WITH LOCAL CHECK OPTION +v1 CREATE ALGORITHM=UNDEFINED VIEW `test`.`v1` AS select `test`.`t1`.`a` AS `a` from `test`.`t1` WITH CASCADED CHECK OPTION alter algorithm=merge view v1 as select * from t1 with cascaded check option; show create view v1; View Create View diff --git a/sql/sql_yacc.yy b/sql/sql_yacc.yy index d2964df008b..6fb13684098 100644 --- a/sql/sql_yacc.yy +++ b/sql/sql_yacc.yy @@ -7921,7 +7921,7 @@ check_option: /* empty */ { Lex->create_view_check= VIEW_CHECK_NONE; } | WITH CHECK_SYM OPTION - { Lex->create_view_check= VIEW_CHECK_LOCAL; } + { Lex->create_view_check= VIEW_CHECK_CASCADED; } | WITH CASCADED CHECK_SYM OPTION { Lex->create_view_check= VIEW_CHECK_CASCADED; } | WITH LOCAL_SYM CHECK_SYM OPTION |