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

Support for Multi-Valued Indexes

    XMLWordPrintable

Details

    • Q1/2026 Server Development

    Description

      Hey, our team has the desire to start storing JSON arrays of strings inside our MariaDB instance and we would love to take advantages of them with queries using the JSON_CONTAINS() function. This design can help us avoid multiple tables for managing many-to-many relations and making slow & complex joins over huge datasets. The problem is that without proper indexing of this new JSON fields we can't really take advantage of them properly.

      While checking MySQL feature set, we have seen that version > 8 has support for multi-valued Indexes (https://dev.mysql.com/doc/refman/8.0/en/create-index.html#create-index-multi-valued), is there anything similar in MariaDB for arrays? is this feature expected any time in the near future?

      Appreciate the help, this can be a game changer for our use-case, and our team will be more then happy to help with feedback, testing or other possible ways.

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              eldadfux Eldad Fux
              Votes:
              12 Vote for this issue
              Watchers:
              16 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.