diff options
| author | unknown <igor@olga.mysql.com> | 2007-02-02 15:22:10 -0800 |
|---|---|---|
| committer | unknown <igor@olga.mysql.com> | 2007-02-02 15:22:10 -0800 |
| commit | e0d8e8fd09f46b9ccda0b39e5483bca4d3d672de (patch) | |
| tree | c43db5c7b276574cabf4a5f8e38755f9d43e60e7 /client/mysql.cc | |
| parent | a30830460794651c0e9fc5ec4779cf77680514ee (diff) | |
| download | mariadb-git-e0d8e8fd09f46b9ccda0b39e5483bca4d3d672de.tar.gz | |
Fix bug #24035.
This performance degradation for UPDATEs could be observed in the update
statements for which the search key cannot be converted to any valid
value of the type of the search column, like for a the condition
int_fld=99999999999999999999999999, though it can be guaranteed here
that there is no row with such a key value.
mysql-test/r/update.result:
Added a test case for bug #24035.
mysql-test/t/update.test:
Added a test case for bug #24035.
sql/opt_range.cc:
Fix bug #24035.
This performance degradation for could be observed in the update
statements for which the search key cannot be converted to any valid
value of the type of the search column, like for a the condition
int_fld=99999999999999999999999999, though it can be guaranteed here
that there is no row with such a key value.
Now the function get_mm_leaf creates trees of the type SEL_ARG::IMPOSSIBLE
for such conditions that tells the range scan not to perform any search
at all.
Diffstat (limited to 'client/mysql.cc')
0 files changed, 0 insertions, 0 deletions