diff options
| author | unknown <sergefp@mysql.com> | 2007-12-13 13:38:22 +0300 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2007-12-13 13:38:22 +0300 |
| commit | c6675cd1876a90468ca2e2cb10471af93728aa6c (patch) | |
| tree | 8280703de51f1dcb45bd62866b4eca3f9ba5b947 /sql/field.cc | |
| parent | 6a72267d05ba24953345b9fe516d6bff2f77e8eb (diff) | |
| download | mariadb-git-c6675cd1876a90468ca2e2cb10471af93728aa6c.tar.gz | |
BUG#32198: Comparison of DATE with DATETIME still not using indexes correctly
- Make conditions like "date_col $CMP$ 'datetime-const'" range-sargable
mysql-test/r/range.result:
BUG#32198: Comparison of DATE with DATETIME still not using indexes correctly
- Testcase
mysql-test/t/range.test:
BUG#32198: Comparison of DATE with DATETIME still not using indexes correctly
- Testcase
sql/field.cc:
BUG#32198: Comparison of DATE with DATETIME still not using indexes correctly
- Added comments
Diffstat (limited to 'sql/field.cc')
| -rw-r--r-- | sql/field.cc | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/sql/field.cc b/sql/field.cc index 86853389c64..955694933a0 100644 --- a/sql/field.cc +++ b/sql/field.cc @@ -5259,6 +5259,9 @@ void Field_date::sql_type(String &res) const 1 Value was cut during conversion 2 Wrong date string 3 Datetime value that was cut (warning level NOTE) + This is used by opt_range.cc:get_mm_leaf(). Note that there is a + nearly-identical class Field_date doesn't ever return 3 from its + store function. */ int Field_newdate::store(const char *from,uint len,CHARSET_INFO *cs) |