Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
When a Federated/FederatedX table is created with an explicit vector key, it returns errors, which is fine, but the errors themselves aren't great:
bb-11.6-MDEV-32887-vector eff6bc39fcb6e1f691fa08b153d9ea44b9f77b54 |
MariaDB [test]> CREATE TABLE t_fed (a VECTOR(1) NOT NULL, VECTOR(a)) ENGINE=FEDERATED CONNECTION = 's/t'; |
ERROR 1 (HY000): server name: '' doesn't exist! |
MariaDB [test]> show warnings;
|
+---------+------+---------------------------------------------------------------------+
|
| Level | Code | Message |
|
+---------+------+---------------------------------------------------------------------+
|
| Error | 1 | server name: '' doesn't exist! | |
| Error | 1 | Can't create/write to file '' (Errcode: 14 "Bad address") | |
| Warning | 1030 | Got error 1 "Operation not permitted" from storage engine FEDERATED | |
+---------+------+---------------------------------------------------------------------+ |
When a FederatedX table is created via table discovery, it succeeds, and similar errors are produced later upon an attempt to use the key:
INSTALL SONAME 'ha_federatedx'; |
|
eval create server s foreign data wrapper mysql options (host "127.0.0.1", database "test", user "root", port $MASTER_MYPORT); |
|
CREATE TABLE t1 (a VECTOR(1) NOT NULL, VECTOR(a)); |
CREATE TABLE t1_fed ENGINE=FEDERATED CONNECTION = 's/t1'; |
SHOW CREATE TABLE t1_fed; |
SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1; |
SHOW WARNINGS;
|
SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1; |
mysqltest: At line 8: query 'SELECT * FROM t1_fed ORDER BY VEC_DISTANCE_EUCLIDEAN(a,0x00000000) LIMIT 1' failed: <Unknown> (1): server name: '' doesn't exist! |
SHOW WARNINGS;
|
Level Code Message
|
Error 1 server name: '' doesn't exist! |
Error 1 Can't create/write to file '' (Errcode: 14 "Bad address") |
Error 1034 Index for table 't1_fed' is corrupt; try to repair it |
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed