diff options
| author | unknown <evgen@moonbone.local> | 2006-11-29 15:03:53 +0300 |
|---|---|---|
| committer | unknown <evgen@moonbone.local> | 2006-11-29 15:03:53 +0300 |
| commit | 004aadd6f716e2bdd055a2518b50bd8d13e961e8 (patch) | |
| tree | 8a4b4dbca4f569565f89a30bab47a7700d15da81 /mysql-test/r/ps.result | |
| parent | a116f93dd32cdd0bc29e66f93ad71fc12727e3d3 (diff) | |
| parent | fe499575af62bebdc42f804645da089f8e268bc4 (diff) | |
| download | mariadb-git-004aadd6f716e2bdd055a2518b50bd8d13e961e8.tar.gz | |
Merge epotemkin@bk-internal.mysql.com:/home/bk/mysql-5.0-opt
into moonbone.local:/work/20327-bug-5.0-opt-mysql
sql/sql_base.cc:
Auto merged
mysql-test/r/ps.result:
Manual merge
mysql-test/t/ps.test:
Manual merge
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 003e57edb8e..cd7f5683bd5 100644 --- a/mysql-test/r/ps.result +++ b/mysql-test/r/ps.result @@ -1475,6 +1475,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"'; |