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

JSON indexing: wildcard-like index over fulltext

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Critical
    • Resolution: Unresolved
    • 13.3
    • None
    • Q4/2026 Server Development

    Description

      This is Goal #2 of MDEV-40168

      That is, an index containing every (path, value) pair of a json document. In other words, instead of a usual JSON MVI which is in the form of

      create index idx1 on t1 ((cast(jscol->'$.tags' as DATATYPE array)));
      

      a wildcard index is akin to

      create index idx1 on t1 (jscol->'$.**');
      

      MVI-on-fulltext naturally extends to this. Other JSON index backends could incur different engineering costs.

      TODO: very brief mention of engineering costs of various backend designs as suggested by Claude

      TODO: do we need JSON comparator as mentioned in MDEV-37288?

      Attachments

        Issue Links

          Activity

            People

              ycp Yuchen Pei
              ycp Yuchen Pei
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - 15d
                  15d
                  Remaining:
                  Remaining Estimate - 14d 7.25h
                  14d 7.25h
                  Logged:
                  Remaining Estimate - 14d 7.25h
                  0.75h

                  Git Integration

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