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

Optimizer support for JSON MEMBER OF predicate

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 13.3
    • Optimizer
    • None
    • Q1/2027 Server Development

    Description

      We started work on JSON indexing:
      MDEV-40168:Indexes over JSON data based on Fulltext index, and its part
      MDEV-40777 : JSON indexing: ARRAY index over fulltext
      when MEMBER OF predicate wasn't available.

      Now, MDEV-38591 adds support for MEMBER OF predicate. Do we need anything to enable optimizer support for it?
      If x MEMBER OF js is rewritten into something internally like JSON_OVERLAPS(js, JSON_ARRAY( x)) or JSON_CONTAINS(js, CAST(x as JSON) then probably not except the transformation/translation.
      Otherwise, we might need to code something to add optimizer support.

      This is what this MDEV covers.

      Attachments

        Issue Links

          is part of

          New Feature - A new feature of the product, which has yet to be developed. MDEV-40168 Indexes over JSON data based on Fulltext index

          • Critical - Crashes, loss of data, severe memory leak.
          • In Progress

          Activity

            People

              ycp Yuchen Pei
              psergei Sergei Petrunia
              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.