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

UPDATE/DELETE Queries and FORCE INDEX

    XMLWordPrintable

Details

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

    Description

      I think I may have either stumbled onto a documentation issue, or an situation where MariaDB simply ignores a directive, or even uses it. The other day, I ran a query as follows:

      UPDATE some_table FORCE INDEX (some_index) SET some_column='some value' WHERE another_column > some_value;

      The issue is, the query ran just fine, and did not complain about the FORCE INDEX. So, I went on to search the documentation and low and behold "FORCE INDEX" did not appear to be documented (or glasses are needed).

      If would be nice if DELETE queries could use a FORCE INDEX directive as well. With the recent optimization problems, I think this might not be a bad idea.

      This to me seems like a feature request, but for the life of me, JIRA has my head spinning, so I thought I would log it here.

      Attachments

        Activity

          People

            Unassigned Unassigned
            TheWitness Larry Adams
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.