diff options
| author | bell@sanja.is.com.ua <> | 2004-01-17 13:13:48 +0200 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-01-17 13:13:48 +0200 |
| commit | 242e8dbbbb5d377c33ad639ff93c827fa7a73543 (patch) | |
| tree | bd13fb064a3a0fcc08e582e6ffba928760cc73ed /mysql-test/r/subselect_innodb.result | |
| parent | c04fd7b17796a2abdc09288c52288636ac10b45f (diff) | |
| parent | a5800f8f441164fd2fc67ea45831442bcf7dbb04 (diff) | |
| download | mariadb-git-242e8dbbbb5d377c33ad639ff93c827fa7a73543.tar.gz | |
merge
Diffstat (limited to 'mysql-test/r/subselect_innodb.result')
| -rw-r--r-- | mysql-test/r/subselect_innodb.result | 17 |
1 files changed, 15 insertions, 2 deletions
diff --git a/mysql-test/r/subselect_innodb.result b/mysql-test/r/subselect_innodb.result index e3528e06546..b2a055fa72c 100644 --- a/mysql-test/r/subselect_innodb.result +++ b/mysql-test/r/subselect_innodb.result @@ -60,8 +60,8 @@ INSERT INTO t2 VALUES (1,1),(2,2),(3,3); SELECT distinct p1.processor_id, (SELECT y.yod_id FROM t1 p2, t2 y WHERE p2.processor_id = p1.processor_id and p2.processor_id = y.processor_id) FROM t1 p1; processor_id (SELECT y.yod_id FROM t1 p2, t2 y WHERE p2.processor_id = p1.processor_id and p2.processor_id = y.processor_id) 1 1 -2 1 -3 1 +2 2 +3 3 drop table t1,t2,t3; CREATE TABLE t1 ( id int(11) NOT NULL default '0', @@ -83,3 +83,16 @@ select (select max(id) from t2 where b=1 group by b) as x,b from t1 where b=1; x b 2 1 drop table t1,t2; +create table t1 (id int not null, value char(255), primary key(id)) engine=innodb; +create table t2 (id int not null, value char(255)) engine=innodb; +insert into t1 values (1,'a'),(2,'b'); +insert into t2 values (1,'z'),(2,'x'); +select t2.id,t2.value,(select t1.value from t1 where t1.id=t2.id) from t2; +id value (select t1.value from t1 where t1.id=t2.id) +1 z a +2 x b +select t2.id,t2.value,(select t1.value from t1 where t1.id=t2.id) from t2; +id value (select t1.value from t1 where t1.id=t2.id) +1 z a +2 x b +drop table t1,t2; |