diff options
| author | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-18 18:09:56 +0400 |
|---|---|---|
| committer | Evgeny Potemkin <epotemkin@mysql.com> | 2009-07-18 18:09:56 +0400 |
| commit | 5032380084a61445cba0c7455c95f2abf9125612 (patch) | |
| tree | 741adb9eb42191a579c1556e8e74300a8eac5e85 /mysql-test/t/subselect.test | |
| parent | 63e6a59d7398673c32a00ed163f76420a85120dd (diff) | |
| download | mariadb-git-5032380084a61445cba0c7455c95f2abf9125612.tar.gz | |
Bug#46051: Incorrectly market field caused wrong result.
When during the optimization an item is moved to the upper select
the item's context left unchanged. This caused wrong result in the
PS/SP mode.
The Item_ident::remove_dependence_processor now sets the context
of the select to which the item is moved to.
mysql-test/r/subselect.result:
The test case for the bug#46051 is adjusted.
mysql-test/t/subselect.test:
The test case for the bug#46051 is adjusted.
sql/item.cc:
Bug#46051: Incorrectly market field caused wrong result.
The Item_ident::remove_dependence_processor now sets the context
of the select to which the item is moved to.
Diffstat (limited to 'mysql-test/t/subselect.test')
| -rw-r--r-- | mysql-test/t/subselect.test | 2 |
1 files changed, 2 insertions, 0 deletions
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. |