summaryrefslogtreecommitdiff
path: root/sql/sql_select.cc
diff options
context:
space:
mode:
authorVicențiu Ciorbaru <vicentiu@mariadb.org>2017-05-17 14:53:28 +0300
committerVicențiu Ciorbaru <vicentiu@mariadb.org>2017-05-17 14:53:28 +0300
commitb87873b221fffccae622d4d52d9d1219e306a98f (patch)
treed809e3744dfdcb07b453173a66b7339303d16c82 /sql/sql_select.cc
parent5064623ce4f721d7b3286296f7cd08e6eb8091b5 (diff)
parent0af9818240a0745aca3fd94891664fe008de24fe (diff)
downloadmariadb-git-b87873b221fffccae622d4d52d9d1219e306a98f.tar.gz
Merge branch 'merge-innodb-5.6' into bb-10.0-vicentiu
This merge reverts commit 6ca4f693c1ce472e2b1bf7392607c2d1124b4293 from current 5.6.36 innodb. Bug #23481444 OPTIMISER CALL ROW_SEARCH_MVCC() AND READ THE INDEX APPLIED BY UNCOMMITTED ROW Problem: ======== row_search_for_mysql() does whole table traversal for range query even though the end range is passed. Whole table traversal happens when the record is not with in transaction read view. Solution: ========= Convert the innodb last record of page to mysql format and compare with end range if the traversal of row_search_mvcc() exceeds 100, no ICP involved. If it is out of range then InnoDB can avoid the whole table traversal. Need to refactor the code little bit to make it compile. Reviewed-by: Jimmy Yang <jimmy.yang@oracle.com> Reviewed-by: Knut Hatlen <knut.hatlen@oracle.com> Reviewed-by: Dmitry Shulga <dmitry.shulga@oracle.com> RB: 14660
Diffstat (limited to 'sql/sql_select.cc')
0 files changed, 0 insertions, 0 deletions