Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
Loading...
For example, the VEC_ToText function expects a binary vector. If not given one, this error will result:
The solution is to provide a valid binary vector:
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.
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.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
4203
WARN_SORTING_ON_TRUNCATED_LENGTH
%llu values were longer than max_sort_length. Sorting used only the first %lu bytes
Prior to the introduction of this error, there were multiple error codes reported for the issue 'Can't execute init_slave query'. Those errors are the underlying reason the init_slave query cannot be executed, but this made it difficult to detect the issue in an automated way.
This error code, ER_INIT_SLAVE_ERROR, unifies all the errors related to the init_slave query. The ER_INIT_SLAVE_ERROR error is raised for any issue related to the init_slave query, and the underlying error code and message are included in the Last_SQL_Error field. See those specific errors for more details.
4226
ER_INIT_SLAVE_ERROR
Slave SQL thread aborted. Can't execute init_slave query due to error code %u: %s
4222
ER_UNRESOLVED_INDEX_HINT_NAME
Unresolved index name %s for %s hint
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
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This page is licensed: CC BY-SA / Gnu FDL
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
This article doesn't currently contain any content.
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 foundThis page is licensed: CC BY-SA / Gnu FDL
ALTER 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 |
+----+This article doesn't currently contain any content.