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

Description of vector type says VECTOR([M])

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      The manual description for vector data type https://mariadb.com/kb/en/vector/
      says VECTOR([M]). But M i.e. maximum is not optional so VECTOR(M) might be better.
      (Another user has already noticed this and left a comment on the page bottom.)
      I don't see where the maximum is documented.
      It is 65532 – the same as the maximum for VARCHAR(M) – but if I say VECTOR(65536) the error message is
      Error 1074 (42000) Column length too big for column 'v' (max = 65532); use BLOB or TEXT instead
      That is inappropriate, it is not a length and of course BLOB and TEXT are not good substitutes for VECTOR.
      I assume you want to call it the maximum number of dimensions, eh?
      A slightly smaller worry is the use of the letter M:
      sure, it's the same as VARCHAR(M),
      but it's going to be followed often by a clause "M=n" so you have two Ms in the same description.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              Peter Gulutzan Peter Gulutzan
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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