Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
4205
ER_VECTOR_FORMAT_INVALID
Invalid vector format at offset: %d for '%-.100s'. Must be a valid JSON array of numbers.
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
4200
ER_SEQUENCE_TABLE_ORDER_BY
ORDER BY
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
4202
ER_INCORRECT_COLUMN_NAME_COUNT
Incorrect column name count for derived table
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
4204
ER_VECTOR_BINARY_FORMAT_INVALID
Invalid binary vector format. Must use IEEE standard float representation in little-endian format. Use VEC_FromText() to generate it.
For example, the function expects a binary vector. If not given one, this error will result:
SELECT VEC_ToText(x'aabbcc');
+-----------------------+
| VEC_ToText(x'aabbcc') |
+-----------------------+
| NULL |
+-----------------------+
1 row in set, 1 warning (0.000 sec)
Warning (Code 4204): Invalid binary vector format. Must use IEEE standard float
representation in little-endian format. Use VEC_FromText() to generate it.The solution is to provide a valid binary vector:
SELECT VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d');
+---------------------------------------------------------+
| VEC_ToText(x'e360d63ebe554f3fcdbc523f4522193f5236083d') |
+---------------------------------------------------------+
| [0.418708,0.809902,0.823193,0.598179,0.033255] |
+---------------------------------------------------------+This page is licensed: CC BY-SA / Gnu FDL
4206
ER_VEC_DISTANCE_TYPE
Cannot determine distance type for VEC_DISTANCE, index is not found
CREATE OR REPLACE TABLE v (id INT PRIMARY KEY, v VECTOR(5) NOT NULL);
INSERT INTO v VALUES
(1, x'e360d63ebe554f3fcdbc523f4522193f5236083d'),
(2, x'f511303f72224a3fdd05fe3eb22a133ffae86a3f'),
(3,x'f09baa3ea172763f123def3e0c7fe53e288bf33e'),
(4,x'b97a523f2a193e3eb4f62e3f2d23583e9dd60d3f'),
(5,x'f7c5df3e984b2b3e65e59d3d7376db3eac63773e'),
(6,x'de01453ffa486d3f10aa4d3fdd66813c71cb163f'),
(7,x'76edfc3e4b57243f10f8423fb158713f020bda3e'),
(8,x'56926c3fdf098d3e2c8c5e3d1ad4953daa9d0b3e'),
(9,x'7b713f3e5258323f80d1113d673b2b3f66e3583f'),
(10,x'6ca1d43e9df91b3fe580da3e1c247d3f147cf33e');
SELECT id FROM v ORDER BY VEC_DISTANCE(v, x'6ca1d43e9df91b3fe580da3e1c247d3f147cf33e');
ERROR 4206 (HY000): Cannot determine distance type for VEC_DISTANCE, index is not foundALTER TABLE v ADD VECTOR INDEX(v);
SELECT id FROM v ORDER BY VEC_DISTANCE(v, x'6ca1d43e9df91b3fe580da3e1c247d3f147cf33e');
+----+
| id |
+----+
| 10 |
| 7 |
| 3 |
| 9 |
| 2 |
| 1 |
| 5 |
| 4 |
| 6 |
| 8 |
+----+4203
WARN_SORTING_ON_TRUNCATED_LENGTH
%llu values were longer than max_sort_length. Sorting used only the first %lu bytes
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL
4201
ER_VARIABLE_IGNORED
The variable '%s' is ignored. It only exists for compatibility with old installations and will be removed in a future release
This article doesn't currently contain any content. You can help!
This page is licensed: CC BY-SA / Gnu FDL