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

VEC_FromText does not return vector type but varbinary

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • N/A
    • 11.7
    • Vector search
    • None

    Description

      It would seem logical for Vec_FromText function to produce a vector type result, but it doesn't:

      bb-11.6-MDEV-32887-vector 4dfa605f405df3bee7142be6bcdc364f5a5e0db3

      MariaDB [test]> create or replace table t as select vec_fromtext('[1]') as v;
      Query OK, 1 row affected (0.126 sec)
      Records: 1  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> show create table t;
      +-------+---------------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                              |
      +-------+---------------------------------------------------------------------------------------------------------------------------+
      | t     | CREATE TABLE `t` (
        `v` varbinary(16) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci |
      +-------+---------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.000 sec)
      

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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