diff options
| author | unknown <gshchepa/uchum@gleb.loc> | 2007-05-28 00:22:44 +0500 |
|---|---|---|
| committer | unknown <gshchepa/uchum@gleb.loc> | 2007-05-28 00:22:44 +0500 |
| commit | 4f9d984572f08a981f13dbb83293a17304a420d8 (patch) | |
| tree | d507b01c581dcd55bffd91939feeff21f51f64c2 /mysql-test/t/view.test | |
| parent | 2d6544b496574151acad7fa3e1b81ae387d3e5c2 (diff) | |
| parent | 5f99cf963ea4138fd7adb70ec4a9add55388c281 (diff) | |
| download | mariadb-git-4f9d984572f08a981f13dbb83293a17304a420d8.tar.gz | |
Merge gleb.loc:/home/uchum/work/bk/mysql-5.0-opt
into gleb.loc:/home/uchum/work/bk/mysql-5.1-opt
client/mysqldump.c:
Auto merged
mysql-test/r/join_outer.result:
Auto merged
mysql-test/r/kill.result:
Auto merged
mysql-test/r/view.result:
Auto merged
mysql-test/t/join_outer.test:
Auto merged
mysql-test/t/kill.test:
Auto merged
sql/field.h:
Auto merged
sql/item_func.cc:
Auto merged
sql/sp_head.cc:
Auto merged
sql/sql_base.cc:
Auto merged
mysql-test/r/mysqldump.result:
Merge with 5.0-opt
mysql-test/t/mysqldump.test:
Merge with 5.0-opt
mysql-test/t/view.test:
Merge with 5.0-opt
sql/sql_select.cc:
Merge with 5.0-opt
Diffstat (limited to 'mysql-test/t/view.test')
| -rw-r--r-- | mysql-test/t/view.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/view.test b/mysql-test/t/view.test index 51c862f692d..0eebdcf2a22 100644 --- a/mysql-test/t/view.test +++ b/mysql-test/t/view.test @@ -3055,6 +3055,25 @@ DROP VIEW v1; DROP TABLE t1; # +# +# Bug #28561: update on multi-table view with CHECK OPTION and +# a subquery in WHERE condition +# + +CREATE TABLE t1 (id int); +CREATE TABLE t2 (id int, c int DEFAULT 0); +INSERT INTO t1 (id) VALUES (1); +INSERT INTO t2 (id) VALUES (1); + +CREATE VIEW v1 AS + SELECT t2.c FROM t1, t2 + WHERE t1.id=t2.id AND 1 IN (SELECT id FROM t1) WITH CHECK OPTION; + +UPDATE v1 SET c=1; + +DROP VIEW v1; +DROP TABLE t1,t2; + # BUG#25897: Some queries are no longer possible after a CREATE VIEW # fails # |