Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-37431

Extended query optimization, e.g. RLIKE '^2023-(08|09|1[0-2])' -> start_time > '2023-08-01' AND start_time < '2024-01-01'

    XMLWordPrintable

Details

    • New Feature
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • None
    • Optimizer
    • None

    Description

      Tested in Ver 15.1 Distrib 10.11.13-MariaDB with MyISAM table engine.

      Time difference 0.015 sec (BETWEEN) vs 0.088 sec (RLIKE)

      Attachments

        Activity

          People

            Unassigned Unassigned
            anttiryt Antti Rytsölä
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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