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

Support for Multi-Valued Indexes

    XMLWordPrintable

Details

    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

          blocks

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35316 more than one vector index per table

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-35389 Native Multi-Value Indexes for JSON

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-36568 Enhancing MariaDB Full Text Search

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38306 Optimizer support for Multi-Valued indexes over JSON data

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-38485 Pluggable Full-Text Search Framework with BM25 Ranking

          • Critical - Crashes, loss of data, severe memory leak.
          • Open
          relates to

          Task - A task that needs to be done. MDEV-37288 JSON Comparator: does MariaDB need one?

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-38214 FTS Sharding fails due to unicode collations map all tokens to aux index 0

          • Major - Major loss of function.
          • Open

          Task - A task that needs to be done. MDEV-40113 Optimizer support for Multi-Valued indexes: support new Full Text Search

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

          Activity

            People

              serg Sergei Golubchik
              eldadfux Eldad Fux
              Votes:
              13 Vote for this issue
              Watchers:
              22 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 8d 7h Remaining Estimate - 16d 1h
                  16d 1h
                  Logged:
                  Time Spent - 8d 7h Remaining Estimate - 16d 1h
                  8d 7h

                  Git Integration

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