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.
          • Closed

          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
          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41525 SIGSEGV in st_key::options on ALTER TABLE ADD INDEX for a table with a JSON ARRAY index

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41533 SIGSEGV in TABLE::unlock_hlindexes after DELETE ... LIMIT using multi-value JSON index

          • 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 JSON queries: switch to using Multi-Valued Index API

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-41860 Vector datatype returns in protocol as VAR_STRING without vector hints

          • Major - Major loss of function.
          • Open
          has action item

          DOCS-6942 Loading...

          Activity

            People

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

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 25d
                  25d
                  Remaining:
                  Time Spent - 13d 1h Remaining Estimate - 11d 7h
                  11d 7h
                  Logged:
                  Time Spent - 13d 1h Remaining Estimate - 11d 7h
                  13d 1h

                  Git Integration

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