VEC_ToText
MariaDB starting with 11.6
Vectors were introduced in MariaDB 11.6 Vector Preview.
Syntax
VEC_ToText(v)
Description
VEC_ToText converts a binary vector into a json array of numbers (floats). Returns NULL and throws a warning 4201 if given an invalid vector.
Example
SELECT VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d'); +---------------------------------------------------------+ | VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d') | +---------------------------------------------------------+ | [0.418708,0.809902,0.823193,0.598179,0.033255] | +---------------------------------------------------------+
Invalid vector:
SELECT VEC_ToText(x'aabbcc'); +-----------------------+ | VEC_ToText(x'aabbcc') | +-----------------------+ | NULL | +-----------------------+ 1 row in set, 1 warning (0.000 sec) Warning (Code 4201): Invalid binary vector format. Must use IEEE standard float representation in little-endian format. Use VEC_FromText() to generate it.
See Also
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
