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

VEC_DISTANCE() function to autouse the available index type

    XMLWordPrintable

Details

    Description

      With multiple implementations of vector index types we're burdening the application and the database to be in sync over the type of index. A wrong step means there will be a table scan.

      Simplifying it for the user is a generic VEC_DISTANCE function that will operate on the index that's there.

      If two indexes are possible I guess we select the first

      Attachments

        Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35724 VEC_DISTANCE does not work in HAVING clause

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35752 VEC_DISTANCE does not work in triggers

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35756 VEC_DISTANCE does not work in stored functions

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35759 VEC_DISTANCE does not work in INSERT DELAYED .. RETURNING

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35768 Vector key is not used upon selecting from views / subqueries

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35778 Server crashes in Item_func_vec_distance::fix_length_and_dec upon using VEC_DISTANCE with temptable view

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35885 main.vector_funcs fails on x86

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-35919 Server crashes in Item_func_vec_distance::fix_length_and_dec upon reading from I_S table

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

          Activity

            People

              serg Sergei Golubchik
              danblack Daniel Black
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 3.5h
                  3.5h

                  Git Integration

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