statement ok CREATE TABLE t (val vector(3)); statement ok INSERT INTO t (val) SELECT ARRAY[random(), random(), random()]::real[] FROM generate_series(1, 1000); statement error CREATE INDEX ON t USING vchordrq (val vector_l2_ops) WITH (options = $$ unknown_options=true $$); # multiple index on single column statement ok CREATE INDEX ON t USING vchordrq (val vector_l2_ops) WITH (options = $$ residual_quantization = true [build.internal] lists = [32] spherical_centroids = false $$); statement ok CREATE INDEX ON t USING vchordrq (val vector_ip_ops) WITH (options = $$ residual_quantization = false [build.internal] lists = [32] spherical_centroids = true $$); statement ok CREATE INDEX ON t USING vchordrq (val vector_cosine_ops) WITH (options = $$ residual_quantization = false [build.internal] lists = [32] spherical_centroids = true $$); statement ok SET vchordrq.probes = '16'; query I SELECT COUNT(1) FROM (SELECT 1 FROM t ORDER BY val <-> '[0.5,0.5,0.5]' limit 10) t2; ---- 10 query I SELECT COUNT(1) FROM (SELECT 1 FROM t ORDER BY val <=> '[0.5,0.5,0.5]' limit 10) t2; ---- 10 query I SELECT COUNT(1) FROM (SELECT 1 FROM t ORDER BY val <#> '[0.5,0.5,0.5]' limit 10) t2; ---- 10 statement ok DROP TABLE t;