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-common | |
| 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-common')
0 files changed, 0 insertions, 0 deletions