diff options
| author | bell@sanja.is.com.ua <> | 2004-09-08 21:54:01 +0300 |
|---|---|---|
| committer | bell@sanja.is.com.ua <> | 2004-09-08 21:54:01 +0300 |
| commit | 31c63b07c968332fe262dd4a2cb4c67f424df657 (patch) | |
| tree | c8b6bdeb3236e4bacaa9793fd4a5dfd89645f984 /mysql-test/r/subselect_innodb.result | |
| parent | a022b3c5496b99c73b99f23f3aaf83818679c848 (diff) | |
| download | mariadb-git-31c63b07c968332fe262dd4a2cb4c67f424df657.tar.gz | |
test case of bug#5220
Diffstat (limited to 'mysql-test/r/subselect_innodb.result')
| -rw-r--r-- | mysql-test/r/subselect_innodb.result | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/mysql-test/r/subselect_innodb.result b/mysql-test/r/subselect_innodb.result index bbbc607b6f8..e8f6426f51b 100644 --- a/mysql-test/r/subselect_innodb.result +++ b/mysql-test/r/subselect_innodb.result @@ -106,3 +106,11 @@ a b 2 12 4 105 drop table t1, t2; +CREATE TABLE `t1` ( `unit` varchar(50) NOT NULL default '', `ingredient` varchar(50) NOT NULL default '') ENGINE=InnoDB DEFAULT CHARSET=latin1; +CREATE TABLE `t2` ( `ingredient` varchar(50) NOT NULL default '', `unit` varchar(50) NOT NULL default '', PRIMARY KEY (ingredient, unit)) ENGINE=InnoDB DEFAULT CHARSET=latin1; +INSERT INTO `t1` VALUES ('xx','yy'); +INSERT INTO `t2` VALUES ('yy','xx'); +SELECT R.unit, R.ingredient FROM t1 R WHERE R.ingredient IN (SELECT N.ingredient FROM t2 N WHERE N.unit = R.unit); +unit ingredient +xx yy +drop table t1, t2; |