diff options
| author | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-18 18:11:33 +0400 |
|---|---|---|
| committer | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-18 18:11:33 +0400 |
| commit | dbe855d0e37f70ae972f09cbcf83c8964cbcb259 (patch) | |
| tree | 61f3ed0787561c6948cb7a830f4ba59762f9add5 /mysql-test | |
| parent | a50270a9123708a78b5f5d328a73b707d76ef7e5 (diff) | |
| parent | 5032380084a61445cba0c7455c95f2abf9125612 (diff) | |
| download | mariadb-git-dbe855d0e37f70ae972f09cbcf83c8964cbcb259.tar.gz | |
Merged corrected fix for the bug#46051.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/subselect.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
2 files changed, 2 insertions, 4 deletions
diff --git a/mysql-test/r/subselect.result b/mysql-test/r/subselect.result index d3f7f631f70..324a6073426 100644 --- a/mysql-test/r/subselect.result +++ b/mysql-test/r/subselect.result @@ -4472,10 +4472,6 @@ int_nokey int_key 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. diff --git a/mysql-test/t/subselect.test b/mysql-test/t/subselect.test index 63ab2710f89..9d4fc9030f2 100644 --- a/mysql-test/t/subselect.test +++ b/mysql-test/t/subselect.test @@ -3441,8 +3441,10 @@ 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); +--disable_warnings SELECT * FROM C WHERE `int_key` IN (SELECT `int_nokey`); EXPLAIN EXTENDED SELECT * FROM C WHERE `int_key` IN (SELECT `int_nokey`); +--enable_warnings DROP TABLE C; --echo # End of test for bug#45061. |