diff options
| author | unknown <gkodinov@dl145s.mysql.com> | 2006-11-30 12:27:04 +0100 |
|---|---|---|
| committer | unknown <gkodinov@dl145s.mysql.com> | 2006-11-30 12:27:04 +0100 |
| commit | 6ea42e6779d1873d6e327801f93cb9370a7955e0 (patch) | |
| tree | d78e45d0e0dedf887d221c2b3da4a43ac1d9f778 /mysql-test/r/ps.result | |
| parent | 46fd7deccbf9fcf75640ecdaa52667fc0d8e5832 (diff) | |
| parent | 5ec18e1d4335c565c0732f142f87265f6041e110 (diff) | |
| download | mariadb-git-6ea42e6779d1873d6e327801f93cb9370a7955e0.tar.gz | |
Merge dl145s.mysql.com:/data0/bk/team_tree_merge/mysql-5.1
into dl145s.mysql.com:/data0/bk/team_tree_merge/MERGE/mysql-5.1-opt
mysql-test/r/func_in.result:
Auto merged
mysql-test/r/ps.result:
Auto merged
mysql-test/t/ps.test:
Auto merged
sql/field.cc:
Auto merged
sql/item_func.h:
Auto merged
sql/item_sum.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/ps.result')
| -rw-r--r-- | mysql-test/r/ps.result | 18 |
1 files changed, 18 insertions, 0 deletions
diff --git a/mysql-test/r/ps.result b/mysql-test/r/ps.result index e968d3de6e9..a44125d4bed 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -1486,6 +1486,24 @@ i 1 DEALLOCATE PREPARE stmt; DROP TABLE t1, t2; +CREATE TABLE t1 (i INT); +CREATE VIEW v1 AS SELECT * FROM t1; +INSERT INTO t1 VALUES (1), (2); +SELECT t1.i FROM t1 JOIN v1 ON t1.i = v1.i +WHERE EXISTS (SELECT * FROM t1 WHERE v1.i = 1); +i +1 +PREPARE stmt FROM "SELECT t1.i FROM t1 JOIN v1 ON t1.i = v1.i +WHERE EXISTS (SELECT * FROM t1 WHERE v1.i = 1)"; +EXECUTE stmt; +i +1 +EXECUTE stmt; +i +1 +DEALLOCATE PREPARE stmt; +DROP VIEW v1; +DROP TABLE t1; DROP PROCEDURE IF EXISTS p1; flush status; prepare sq from 'show status like "slow_queries"'; |