diff options
author | unknown <evgen@moonbone.local> | 2006-11-29 14:52:11 +0300 |
---|---|---|
committer | unknown <evgen@moonbone.local> | 2006-11-29 14:52:11 +0300 |
commit | fe499575af62bebdc42f804645da089f8e268bc4 (patch) | |
tree | 58303856c94bb03ed386d11976cdfba64c839b12 /mysql-test/r/default.result | |
parent | a5975941a43885579b86e511248d2dde1cebdb3d (diff) | |
download | mariadb-git-fe499575af62bebdc42f804645da089f8e268bc4.tar.gz |
Bug#20327: Marking of a wrong field leads to a wrong result on select with view,
prepared statement and subquery.
When a field of a view from an outer select is resolved the find_field_in_view
function creates an Item_direct_view_ref object that references the
corresponding view underlying field. After that the view_ref is marked
as a dependent one. While resolving view underlying field it also get
marked as a dependent one due to current_select still points to the subselect.
Marking the view underlying field is wrong and lead to attaching conditions
to a wrong table and thus to the wrong result of the whole statement.
Now mark_select_range_as_dependent() function isn't called for fields from a
view underlying table.
sql/sql_base.cc:
Bug#20327: Marking of a wrong field leads to a wrong result on select with view, prepared statement and subquery.
Now mark_select_range_as_dependent() function isn't called for fields from a
view underlying table.
mysql-test/r/ps.result:
Added a test case for bug#20327: Marking of a wrong field leads to a wrong result on select with view, prepared statement and subquery.
mysql-test/t/ps.test:
Added a test case for bug#20327: Marking of a wrong field leads to a wrong result on select with view,prepared statement and subquery.
Diffstat (limited to 'mysql-test/r/default.result')
0 files changed, 0 insertions, 0 deletions