diff options
| author | gshchepa/uchum@gleb.loc <> | 2007-05-31 13:28:43 +0500 |
|---|---|---|
| committer | gshchepa/uchum@gleb.loc <> | 2007-05-31 13:28:43 +0500 |
| commit | 89a4d89c2682d49fc6613125e419cfa9e3f39e8f (patch) | |
| tree | e81fb70c9295f4c86d6da1b19efc247477861dbd /mysql-test/r/view.result | |
| parent | 1fea1536529d5888e9bea0e45fa089c8d211ef08 (diff) | |
| parent | 7f63aab2e03519a80796b5f7b37c20093955871a (diff) | |
| download | mariadb-git-89a4d89c2682d49fc6613125e419cfa9e3f39e8f.tar.gz | |
Merge gleb.loc:/home/uchum/work/bk/mysql-5.0-opt
into gleb.loc:/home/uchum/work/bk/mysql-5.1-opt
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 238e330710c..29861ba4184 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -3369,6 +3369,23 @@ SHOW CREATE VIEW v1; View Create View v1 CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v1` AS select cast(1.23456789 as decimal(8,0)) AS `col` DROP VIEW v1; +CREATE TABLE t1 (a INT); +CREATE TABLE t2 (b INT, c INT DEFAULT 0); +INSERT INTO t1 (a) VALUES (1), (2); +INSERT INTO t2 (b) VALUES (1), (2); +CREATE VIEW v1 AS SELECT t2.b,t2.c FROM t1, t2 +WHERE t1.a=t2.b AND t2.b < 3 WITH CHECK OPTION; +SELECT * FROM v1; +b c +1 0 +2 0 +UPDATE v1 SET c=1 WHERE b=1; +SELECT * FROM v1; +b c +1 1 +2 0 +DROP VIEW v1; +DROP TABLE t1,t2; End of 5.0 tests. DROP DATABASE IF EXISTS `d-1`; CREATE DATABASE `d-1`; |