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

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            eldadfux Eldad Fux
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration