pgvector.git / summary / log / commit / refs

commit    fd3c3ce83dd63b5c28cd7e053a2d224badcaffea
Author:   Andrew Kane <andrew@ankane.org>
Date:     Sun Jul 16 06:03:15 2023 +0000

    Added test for avg with large values


 test/expected/functions.out | 6 ++++++
 test/sql/functions.sql      | 1 +
 2 files changed, 7 insertions(+)

diff --git a/test/expected/functions.out b/test/expected/functions.out
index 451762b9..86562b22 100644
--- a/test/expected/functions.out
+++ b/test/expected/functions.out
@@ -130,6 +130,12 @@ SELECT avg(v) FROM unnest(ARRAY[]::vector[]) v;
 
 SELECT avg(v) FROM unnest(ARRAY['[1,2]'::vector, '[3]']) v;
 ERROR:  expected 2 dimensions, not 1
+SELECT avg(v) FROM unnest(ARRAY['[3e38]'::vector, '[3e38]']) v;
+   avg   
+---------
+ [3e+38]
+(1 row)
+
 SELECT vector_avg(array_agg(n)) FROM generate_series(1, 16002) n;
 ERROR:  vector cannot have more than 16000 dimensions
 SELECT sum(v) FROM unnest(ARRAY['[1,2,3]'::vector, '[3,5,7]']) v;
diff --git a/test/sql/functions.sql b/test/sql/functions.sql
index 83ee22eb..e1c5a422 100644
--- a/test/sql/functions.sql
+++ b/test/sql/functions.sql
@@ -33,6 +33,7 @@ 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;
 SELECT avg(v) FROM unnest(ARRAY[]::vector[]) v;
 SELECT avg(v) FROM unnest(ARRAY['[1,2]'::vector, '[3]']) v;
+SELECT avg(v) FROM unnest(ARRAY['[3e38]'::vector, '[3e38]']) v;
 SELECT vector_avg(array_agg(n)) FROM generate_series(1, 16002) n;
 
 SELECT sum(v) FROM unnest(ARRAY['[1,2,3]'::vector, '[3,5,7]']) v;


[parent: 5796f38ad2ea]