Details
-
Bug
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
N/A
-
None
Description
set @userstat.save= @@userstat; |
|
set global userstat=1; |
|
create table t (b vector(1) not null, vector(b)); |
insert into t values (0x31313131),(0x32323232); |
explain select * from t order by vec_distance_euclidean(b,0x30303030) limit 1; |
select * from t order by vec_distance_euclidean(b,0x30303030) limit 1; |
show index_statistics;
|
|
# Cleanup
|
drop table t; |
set global userstat= @userstat.save; |
3e03a45aa4c69e5aa76c9396547797a895a98edc |
explain select * from t order by vec_distance_euclidean(b,0x30303030) limit 1; |
id select_type table type possible_keys key key_len ref rows Extra |
1 SIMPLE t index NULL b 6 NULL 1 |
select * from t order by vec_distance_euclidean(b,0x30303030) limit 1; |
b
|
1111
|
show index_statistics;
|
Table_schema Table_name Index_name Rows_read Queries
|
drop table t; |
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed