diff options
| author | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-17 18:45:32 +0400 |
|---|---|---|
| committer | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-17 18:45:32 +0400 |
| commit | dc1c164f3560cba6fd471d7557ed5c1571dd6069 (patch) | |
| tree | a2f237801a803c61bccb7c83a1c4dfa8b430209a /mysql-test/r | |
| parent | d6151846c6be1ef69deb85118a5ddf081da119fd (diff) | |
| parent | c288559c68581552aa669da46268f883ed085e8b (diff) | |
| download | mariadb-git-dc1c164f3560cba6fd471d7557ed5c1571dd6069.tar.gz | |
Merged fix for the bug#46051.
Diffstat (limited to 'mysql-test/r')
| -rw-r--r-- | mysql-test/r/subselect.result | 26 |
1 files changed, 26 insertions, 0 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index 671e5d8f532..d3f7f631f70 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4452,4 +4452,30 @@ WHERE 1 IN (SELECT id FROM t1) WITH CHECK OPTION; DELETE FROM v3; DROP VIEW v1,v2,v3; DROP TABLE t1,t2; +# +# Bug#45061: Incorrectly market field caused wrong result. +# +CREATE TABLE `C` ( +`int_nokey` int(11) NOT NULL, +`int_key` int(11) NOT NULL, +KEY `int_key` (`int_key`) +); +INSERT INTO `C` VALUES (9,9), (0,0), (8,6), (3,6), (7,6), (0,4), +(1,7), (9,4), (0,8), (9,4), (0,7), (5,5), (0,0), (8,5), (8,7), +(5,2), (1,8), (7,0), (0,9), (9,5); +SELECT * FROM C WHERE `int_key` IN (SELECT `int_nokey`); +int_nokey int_key +9 9 +0 0 +5 5 +0 0 +EXPLAIN EXTENDED SELECT * FROM C WHERE `int_key` IN (SELECT `int_nokey`); +id select_type table type possible_keys key key_len ref rows Extra +1 PRIMARY C ALL NULL NULL NULL NULL 20 Using where +Warnings: +Note 1276 Field or reference 'test.C.int_nokey' of SELECT #2 was resolved in SELECT #1 +Note 1249 Select 2 was reduced during optimization +Note 1003 select `test`.`C`.`int_nokey` AS `int_nokey`,`test`.`C`.`int_key` AS `int_key` from `test`.`C` where (`test`.`C`.`int_nokey` = `test`.`C`.`int_key`) +DROP TABLE C; +# End of test for bug#45061. End of 5.0 tests. |