diff options
| author | Igor Babaev <igor@askmonty.org> | 2012-01-18 03:31:20 -0800 |
|---|---|---|
| committer | Igor Babaev <igor@askmonty.org> | 2012-01-18 03:31:20 -0800 |
| commit | 746dbbe583f8528b34065b0669136842128e27b2 (patch) | |
| tree | 7f368922928ea854c3c5d6531cc2d757bd63f570 /mysql-test/r/view.result | |
| parent | 296b450d3b58ded0fd4d4972161414c6cc7a80e5 (diff) | |
| download | mariadb-git-746dbbe583f8528b34065b0669136842128e27b2.tar.gz | |
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.
Diffstat (limited to 'mysql-test/r/view.result')
| -rw-r--r-- | mysql-test/r/view.result | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mysql-test/r/view.result b/mysql-test/r/view.result index 644f7f7289e..8a71d00291c 100644 --- a/mysql-test/r/view.result +++ b/mysql-test/r/view.result @@ -304,7 +304,7 @@ a+1 4 explain select * from v1; id select_type table type possible_keys key key_len ref rows Extra -1 PRIMARY <derived2> ALL NULL NULL NULL NULL 4 +1 PRIMARY <derived2> ALL NULL NULL NULL NULL 2 2 DERIVED t1 ALL NULL NULL NULL NULL 4 Using filesort drop view v1; drop table t1; |