pgvector.git / summary / log / commit / refs
commit c198fd58ee2d4aeaa75d03c5a3b87c15b161cd9f
Author: Andrew Kane <andrew@ankane.org>
Date: Wed Apr 24 08:31:50 2024 +0000
Added more tests for subvector function [skip ci]
test/expected/halfvec_functions.out | 6 ++++++
test/expected/vector_functions.out | 6 ++++++
test/sql/halfvec_functions.sql | 1 +
test/sql/vector_functions.sql | 1 +
4 files changed, 14 insertions(+)
diff --git a/test/expected/halfvec_functions.out b/test/expected/halfvec_functions.out
index aaf3588f..e7e3d767 100644
--- a/test/expected/halfvec_functions.out
+++ b/test/expected/halfvec_functions.out
@@ -414,6 +414,12 @@ SELECT subvector('[1,2,3,4,5]'::halfvec, 3, 2147483647);
[3,4,5]
(1 row)
+SELECT subvector('[1,2,3,4,5]'::halfvec, -2147483644, 2147483647);
+ subvector
+-----------
+ [1,2]
+(1 row)
+
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::halfvec, '[3,5,7]']) v;
avg
-----------
diff --git a/test/expected/vector_functions.out b/test/expected/vector_functions.out
index 4b229279..dd3654cb 100644
--- a/test/expected/vector_functions.out
+++ b/test/expected/vector_functions.out
@@ -438,6 +438,12 @@ SELECT subvector('[1,2,3,4,5]'::vector, 3, 2147483647);
[3,4,5]
(1 row)
+SELECT subvector('[1,2,3,4,5]'::vector, -2147483644, 2147483647);
+ subvector
+-----------
+ [1,2]
+(1 row)
+
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::vector, '[3,5,7]']) v;
avg
-----------
diff --git a/test/sql/halfvec_functions.sql b/test/sql/halfvec_functions.sql
index 77a1a889..efd005a6 100644
--- a/test/sql/halfvec_functions.sql
+++ b/test/sql/halfvec_functions.sql
@@ -92,6 +92,7 @@ SELECT subvector('[1,2,3,4,5]'::halfvec, 3, -1);
SELECT subvector('[1,2,3,4,5]'::halfvec, -1, 2);
SELECT subvector('[1,2,3,4,5]'::halfvec, 2147483647, 10);
SELECT subvector('[1,2,3,4,5]'::halfvec, 3, 2147483647);
+SELECT subvector('[1,2,3,4,5]'::halfvec, -2147483644, 2147483647);
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::halfvec, '[3,5,7]']) v;
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::halfvec, '[3,5,7]', NULL]) v;
diff --git a/test/sql/vector_functions.sql b/test/sql/vector_functions.sql
index 25eb810f..7b4de45d 100644
--- a/test/sql/vector_functions.sql
+++ b/test/sql/vector_functions.sql
@@ -96,6 +96,7 @@ SELECT subvector('[1,2,3,4,5]'::vector, 3, -1);
SELECT subvector('[1,2,3,4,5]'::vector, -1, 2);
SELECT subvector('[1,2,3,4,5]'::vector, 2147483647, 10);
SELECT subvector('[1,2,3,4,5]'::vector, 3, 2147483647);
+SELECT subvector('[1,2,3,4,5]'::vector, -2147483644, 2147483647);
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::vector, '[3,5,7]']) v;
SELECT avg(v) FROM unnest(ARRAY['[1,2,3]'::vector, '[3,5,7]', NULL]) v;
[parent: 8c408759dcc5]