Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
N/A
-
None
Description
I suppose the attribute should be either applied or not allowed.
create table t (a vector(1) not null, vector(a) ignored); |
show index in t; |
insert into t values (0x00000000),(0x00000000); |
explain select vec_totext(a) from t order by vec_distance_euclidean(a,0x00000000) limit 1; |
 |
# Cleanup
|
drop table t; |
bb-11.6-MDEV-32887-vector eff6bc39fcb6e1f691fa08b153d9ea44b9f77b54 |
create table t (a vector(1) not null, vector(a) ignored);
|
show index in t;
|
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment Ignored
|
t 1 a 1 a A NULL NULL NULL VECTOR NO
|
insert into t values (0x00000000),(0x00000000);
|
explain select vec_totext(a) from t order by vec_distance_euclidean(a,0x00000000) limit 1;
|
id select_type table type possible_keys key key_len ref rows Extra
|
1 SIMPLE t index NULL a 6 NULL 1
|
drop table t;
|
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed