Viewing all changes in revision 3381.1.1.
- Committer: Igor Babaev
- Date: 2012-01-18 11:31:20 UTC
- mto: (3384.1.1 maria-5.3-trunk)
- mto: This revision was merged to the branch mainline in revision 3387.
- Revision ID: igor@askmonty.org-20120118113120-h49k42kfnfccob7v
Fixed LP bug #917990.
If the expression for a derived table of a query contained a LIMIT
clause the estimate of the number of rows in this derived table
returned by the EXPLAIN command could be badly off since the
optimizer ignored the limit number from the LIMIT clause when
getting the estimate.
The call of the method SELECT_LEX_UNIT->set_limit added in the code
of mysql_derived_optimize() will be needed also in maria-5.5 where
parameters in the LIMIT clause are supported.
If the expression for a derived table of a query contained a LIMIT
clause the estimate of the number of rows in this derived table
returned by the EXPLAIN command could be badly off since the
optimizer ignored the limit number from the LIMIT clause when
getting the estimate.
The call of the method SELECT_LEX_UNIT->set_limit added in the code
of mysql_derived_optimize() will be needed also in maria-5.5 where
parameters in the LIMIT clause are supported.
expand all
collapse all
added
removed
