diff options
| author | unknown <sergefp@mysql.com> | 2006-08-15 21:16:02 +0400 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2006-08-15 21:16:02 +0400 |
| commit | 4ed157ee8603d09b0105183b6306ec2cdaaa119f (patch) | |
| tree | 4675daecc14df05356b3e2aaf9f6a5803b15e86e /mysql-test/r/innodb_mysql.result | |
| parent | 2f5ae7c536ae37a408f1e391ef21c743bd9b1b0e (diff) | |
| parent | 9907e970aea28ce186e110084c3a4f2d6ac0c602 (diff) | |
| download | mariadb-git-4ed157ee8603d09b0105183b6306ec2cdaaa119f.tar.gz | |
BUG#21077: 4.1->5.0 merge
Diffstat (limited to 'mysql-test/r/innodb_mysql.result')
| -rw-r--r-- | mysql-test/r/innodb_mysql.result | 21 |
1 files changed, 21 insertions, 0 deletions
diff --git a/mysql-test/r/innodb_mysql.result b/mysql-test/r/innodb_mysql.result index bf0c4ff1f42..74883b8ccb3 100644 --- a/mysql-test/r/innodb_mysql.result +++ b/mysql-test/r/innodb_mysql.result @@ -83,6 +83,27 @@ b a 3 3 3 3 DROP TABLE t1, t2, t3; +CREATE TABLE `t1` (`id1` INT) ; +INSERT INTO `t1` (`id1`) VALUES (1),(5),(2); +CREATE TABLE `t2` ( +`id1` INT, +`id2` INT NOT NULL, +`id3` INT, +`id4` INT NOT NULL, +UNIQUE (`id2`,`id4`), +KEY (`id1`) +) ENGINE=InnoDB; +INSERT INTO `t2`(`id1`,`id2`,`id3`,`id4`) VALUES +(1,1,1,0), +(1,1,2,1), +(5,1,2,2), +(6,1,2,3), +(1,2,2,2), +(1,2,1,1); +SELECT `id1` FROM `t1` WHERE `id1` NOT IN (SELECT `id1` FROM `t2` WHERE `id2` = 1 AND `id3` = 2); +id1 +2 +DROP TABLE t1, t2; create table t1m (a int) engine=myisam; create table t1i (a int) engine=innodb; create table t2m (a int) engine=myisam; |