diff options
| author | Oleg Smirnov <olernov@gmail.com> | 2023-02-17 19:21:30 +0700 |
|---|---|---|
| committer | Oleg Smirnov <olernov@gmail.com> | 2023-03-20 10:56:41 +0700 |
| commit | 22ebce8d684cbcbd7ff8c044f387b9cd5ca295f7 (patch) | |
| tree | 39c73cedf0ee173d437da42c84d0090420e9554c /sql/item_cmpfunc.cc | |
| parent | ce4a289f1c367987977f1a02bbb8d8b8e8e6bb53 (diff) | |
| download | mariadb-git-bb-11.0-MDEV-8320.tar.gz | |
MDEV-8320 Allow index usage for DATE(col) <=> const and YEAR <=> constbb-11.0-MDEV-8320
Rewrite datetime comparison conditions into sargeable. For example,
YEAR(col) <= val -> col <= YEAR_END(val)
YEAR(col) < val -> col < YEAR_START(val)
YEAR(col) >= val -> col >= YEAR_START(val)
YEAR(col) > val -> col > YEAR_END(val)
YEAR(col) = val -> col BETWEEN YEAR_START(val) AND YEAR_END(val)
Do the same with DATE(col), for example:
DATE(col) <= val -> col <= DAY_END(val)
After such a rewrite index lookup on column "col" can be employed
Diffstat (limited to 'sql/item_cmpfunc.cc')
| -rw-r--r-- | sql/item_cmpfunc.cc | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/sql/item_cmpfunc.cc b/sql/item_cmpfunc.cc index 8a1e6d9ffc3..e480ae26903 100644 --- a/sql/item_cmpfunc.cc +++ b/sql/item_cmpfunc.cc @@ -7802,3 +7802,4 @@ Item *Item_equal::multiple_equality_transformer(THD *thd, uchar *arg) break; } } + |