diff options
| author | unknown <igor@rurik.mysql.com> | 2006-04-05 14:00:54 -0700 |
|---|---|---|
| committer | unknown <igor@rurik.mysql.com> | 2006-04-05 14:00:54 -0700 |
| commit | ef4309284d0124e4b5cb76a379da1571cd8ce464 (patch) | |
| tree | 5478f3804bd93ddefb8eb77c1029c4f84fe48570 /mysql-test/r/view.result | |
| parent | fb559d433f33dc457de061bb666c6f13cc4a4336 (diff) | |
| parent | e77888f53075d283d1e8d2c719ef91896b93e15e (diff) | |
| download | mariadb-git-ef4309284d0124e4b5cb76a379da1571cd8ce464.tar.gz | |
Merge rurik.mysql.com:/home/igor/dev/mysql-5.0-0
into rurik.mysql.com:/home/igor/dev/mysql-5.1-0
mysql-test/r/view.result:
Auto merged
mysql-test/t/view.test:
Auto merged
sql/opt_sum.cc:
Auto merged
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 ab33b54bd2a..fc3e5475ae7 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -2562,3 +2562,20 @@ my_sqrt 1.4142135623731 DROP VIEW v1; DROP TABLE t1; +CREATE TABLE t1 (id int PRIMARY KEY); +CREATE TABLE t2 (id int PRIMARY KEY); +INSERT INTO t1 VALUES (1), (3); +INSERT INTO t2 VALUES (1), (2), (3); +CREATE VIEW v2 AS SELECT * FROM t2; +SELECT COUNT(*) FROM t1 LEFT JOIN t2 ON t1.id=t2.id; +COUNT(*) +2 +SELECT * FROM t1 LEFT JOIN t2 ON t1.id=t2.id; +id id +1 1 +3 3 +SELECT COUNT(*) FROM t1 LEFT JOIN v2 ON t1.id=v2.id; +COUNT(*) +2 +DROP VIEW v2; +DROP TABLE t1, t2; |