Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
1. ER_TRUNCATED_WRONG_VALUE_FOR_FIELD
|
bb-11.6-MDEV-32887-vector 764592a4da2a1b490471732fbefe2ce745ce1f32 |
MariaDB [test]> create or replace table t (a vector(64) not null default ''); |
ERROR 1366 (22007): Incorrect vector value: '''' for column `(null)`.`(null)`.`a` at row 0 |
MariaDB [test]> show warnings;
|
+-------+------+------------------------------------------------------------------------+ |
| Level | Code | Message | |
+-------+------+------------------------------------------------------------------------+ |
| Error | 1366 | Incorrect vector value: '''' for column `(null)`.`(null)`.`a` at row 0 | |
| Error | 1067 | Invalid default value for 'a' | |
+-------+------+------------------------------------------------------------------------+ |
2 rows in set (0.000 sec) |
We have a similar case with for example INET6, but there are differences: first, the "top" error there is 1067, I don't know if it's correct, but at least it looks better; and secondly, `(null)` for schema/table looks even uglier than `` (although not by much).
MariaDB [test]> create or replace table t (a inet6 not null default ''); |
ERROR 1067 (42000): Invalid default value for 'a' |
MariaDB [test]> show warnings;
|
+---------+------+---------------------------------------------------------+ |
| Level | Code | Message | |
+---------+------+---------------------------------------------------------+ |
| Warning | 1292 | Incorrect inet6 value: '' for column ``.``.`a` at row 0 | |
| Error | 1067 | Invalid default value for 'a' | |
+---------+------+---------------------------------------------------------+ |
2 rows in set (0.000 sec) |
TBC.
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
-
- Closed
-