diff options
| author | unknown <bell@sanja.is.com.ua> | 2004-01-17 11:53:04 +0200 |
|---|---|---|
| committer | unknown <bell@sanja.is.com.ua> | 2004-01-17 11:53:04 +0200 |
| commit | adca234881975e5b686275357980e34b2139b6de (patch) | |
| tree | dbb897b5d82c8b6b0db2fc4ab82f1544145159f7 /mysql-test/r/subselect_innodb.result | |
| parent | e0bd7faf5bc2845f49f60d067579a20092bf62b6 (diff) | |
| parent | fc75518a78af9dfb68baac2cbf279983fe54b492 (diff) | |
| download | mariadb-git-adca234881975e5b686275357980e34b2139b6de.tar.gz | |
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1
into sanja.is.com.ua:/home/bell/mysql/bk/work-sub-4.1
mysql-test/r/subselect_innodb.result:
Auto merged
mysql-test/t/subselect_innodb.test:
Auto merged
sql/item_subselect.cc:
Auto merged
sql/sql_lex.h:
Auto merged
sql/sql_union.cc:
Auto merged
Diffstat (limited to 'mysql-test/r/subselect_innodb.result')
| -rw-r--r-- | mysql-test/r/subselect_innodb.result | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_innodb.result b/mysql-test/r/subselect_innodb.result index 6729916f1c8..3a2a36475c5 100644 --- a/mysql-test/r/subselect_innodb.result +++ b/mysql-test/r/subselect_innodb.result @@ -63,3 +63,23 @@ processor_id (SELECT y.yod_id FROM t1 p2, t2 y WHERE p2.processor_id = p1.proces 2 1 3 1 drop table t1,t2,t3; +CREATE TABLE t1 ( +id int(11) NOT NULL default '0', +b int(11) default NULL, +c char(3) default NULL, +PRIMARY KEY (id), +KEY t2i1 (b) +) TYPE=innodb DEFAULT CHARSET=latin1; +INSERT INTO t1 VALUES (0,0,'GPL'),(1,0,'GPL'),(2,1,'GPL'),(3,2,'GPL'); +CREATE TABLE t2 ( +id int(11) NOT NULL default '0', +b int(11) default NULL, +c char(3) default NULL, +PRIMARY KEY (id), +KEY t2i (b) +) TYPE=innodb DEFAULT CHARSET=latin1; +INSERT INTO t2 VALUES (0,0,'GPL'),(1,0,'GPL'),(2,1,'GPL'),(3,2,'GPL'); +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; |