Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Fixed
-
11.8
-
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
- duplicates
-
MDEV-37025 Incorrect error/docs for Vector column lengths (max = 65532)
-
- Closed
-