summaryrefslogtreecommitdiff
path: root/mysql-test/t/func_str.test
diff options
context:
space:
mode:
authorunknown <gkodinov/kgeorge@macbook.gmz>2007-01-22 12:51:21 +0200
committerunknown <gkodinov/kgeorge@macbook.gmz>2007-01-22 12:51:21 +0200
commit2c6e678dd9343a905ea6b7d32cf70fe43c9f9dbe (patch)
treee86a04bb2bb93a9f16e6a4731cc2e20749258fcd /mysql-test/t/func_str.test
parente84b4600b808025d6515c4fd079604b8114425ae (diff)
downloadmariadb-git-2c6e678dd9343a905ea6b7d32cf70fe43c9f9dbe.tar.gz
BUG#16590: Optimized does not do right "const" table pre-read
st_table::const_key_parts member is used in determining if certain key has a prefix that is compared to constant(s) in the query predicates. If there's such prefix the index can be used to get the data from the remaining suffix columns in sorted order. However if a field is compared to another field from a "const" table the const_key_parts is not amended. This makes the optimizer unable to detect that the key can be used for sorting and adds an extra filesort. Fixed by updating const_key_parts after reading in the "const" table. mysql-test/r/order_by.result: BUG#16590: Optimized does not do right "const" table pre-read - test case mysql-test/t/order_by.test: BUG#16590: Optimized does not do right "const" table pre-read - test case sql/sql_select.cc: BUG#16590: Optimized does not do right "const" table pre-read - fill up the const_key_parts structure
Diffstat (limited to 'mysql-test/t/func_str.test')
0 files changed, 0 insertions, 0 deletions