summaryrefslogtreecommitdiff
path: root/mysql-test/r/events.result
diff options
context:
space:
mode:
authorigor@olga.mysql.com <>2007-08-02 12:45:56 -0700
committerigor@olga.mysql.com <>2007-08-02 12:45:56 -0700
commitcf39429295846cf944e3fd1a327c554ebd08942d (patch)
treecb69ff6598e568046e57c591baf10d4a49f2d5b7 /mysql-test/r/events.result
parent642b0c00ed99334a5540839c0e6598d7a26c8ac7 (diff)
downloadmariadb-git-cf39429295846cf944e3fd1a327c554ebd08942d.tar.gz
Fixed bug#28404.
This patch adds cost estimation for the queries with ORDER BY / GROUP BY and LIMIT. If there was a ref/range access to the table whose rows were required to be ordered in the result set the optimizer always employed this access though a scan by a different index that was compatible with the required order could be cheaper to produce the first L rows of the result set. Now for such queries the optimizer makes a choice between the cheapest ref/range accesses not compatible with the given order and index scans compatible with it.
Diffstat (limited to 'mysql-test/r/events.result')
0 files changed, 0 insertions, 0 deletions