[MDEV-30930] Make more date conditions sargable - Jira

XML

Word

Printable

Details

Type: New Feature
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Fix Version/s: None
Component/s: Optimizer
Labels:
- optimizer-feature

PM Planning:
- RM_ROADMAP

Description

In further development of ~~MDEV-8320~~ make such conditions sargable:

YEAR(column) = const1 AND MONTH(column) <=> const2
YEAR(column) = const1 AND MONTH(column) BETWEEN const1 AND const2
YEAR(column) BETWEEN const1 AND const2
DATE(column) BETWEEN const1 AND const2

Attachments

Issue Links

relates to

MDEV-8320 Allow index usage for DATE(datetime_column) = const

Closed

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Oleg Smirnov

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2023-03-27 05:14

Updated:: 2025-03-17 00:14

Time Tracking

Estimated:

0d

Remaining:

0d

Logged:

0.5h

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.