diff options
| author | unknown <gkodinov/kgeorge@rakia.(none)> | 2006-07-26 19:55:33 +0300 |
|---|---|---|
| committer | unknown <gkodinov/kgeorge@rakia.(none)> | 2006-07-26 19:55:33 +0300 |
| commit | bb81f6ac2da29383c353e109ce41834cbbe71c36 (patch) | |
| tree | 19a38e786b5094feb21559112b2ae68cbe034ec9 /mysql-test/r/subselect2.result | |
| parent | 03fc0a8fb15a785b3c2cd95adab1749d6aa7ea0f (diff) | |
| parent | 6b75e24b73828316dd1715ab32811a614ce74314 (diff) | |
| download | mariadb-git-bb81f6ac2da29383c353e109ce41834cbbe71c36.tar.gz | |
Merge gkodinov@bk-internal.mysql.com:/home/bk/mysql-4.1-opt
into rakia.(none):/home/kgeorge/mysql/autopush/B20792-4.1-opt
sql/sql_select.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/subselect2.result')
| -rw-r--r-- | mysql-test/r/subselect2.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/subselect2.result b/mysql-test/r/subselect2.result index 8fcfa06a8ae..db1848105f8 100644 --- a/mysql-test/r/subselect2.result +++ b/mysql-test/r/subselect2.result @@ -130,3 +130,15 @@ id select_type table type possible_keys key key_len ref rows Extra 5 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX PRIMARY 32 func 1 Using index; Using where 6 DEPENDENT SUBQUERY t3 unique_subquery PRIMARY,FFOLDERID_IDX,CMFLDRPARNT_IDX PRIMARY 32 func 1 Using index; Using where drop table t1, t2, t3, t4; +CREATE TABLE t1 (a int(10) , PRIMARY KEY (a)) Engine=InnoDB; +INSERT INTO t1 VALUES (1),(2); +CREATE TABLE t2 (a int(10), PRIMARY KEY (a)) Engine=InnoDB; +INSERT INTO t2 VALUES (1); +CREATE TABLE t3 (a int(10), b int(10), c int(10), +PRIMARY KEY (a)) Engine=InnoDB; +INSERT INTO t3 VALUES (1,2,1); +SELECT t1.* FROM t1 WHERE (SELECT COUNT(*) FROM t3,t2 WHERE t3.c=t2.a +and t2.a='1' AND t1.a=t3.b) > 0; +a +2 +DROP TABLE t1,t2,t3; |