pgvector.git / summary / log / commit / refs
commit bc6b9e4bbad34d5be52d23d5057433b849802427
Author: Andrew Kane <andrew@ankane.org>
Date: Fri Dec 02 04:45:27 2022 +0000
Added more tests for text output
test/expected/input.out | 19 +++++++++++++++++++
test/sql/input.sql | 5 +++++
2 files changed, 24 insertions(+)
diff --git a/test/expected/input.out b/test/expected/input.out
index 3bb11c9a..da60022a 100644
--- a/test/expected/input.out
+++ b/test/expected/input.out
@@ -12,6 +12,18 @@ SELECT '[-1,2,3]'::vector;
[-1,2,3]
(1 row)
+SELECT '[1.23456]'::vector;
+ vector
+-----------
+ [1.23456]
+(1 row)
+
+SELECT '[1.234567]'::vector;
+ vector
+-----------
+ [1.23457]
+(1 row)
+
SELECT '[hello,1]'::vector;
ERROR: invalid input syntax for type vector: "hello"
LINE 1: SELECT '[hello,1]'::vector;
@@ -62,3 +74,10 @@ SELECT unnest('{"[1,2,3]", "[4,5,6]"}'::vector[]);
SELECT '{"[1,2,3]"}'::vector(2)[];
ERROR: expected 2 dimensions, not 3
+set extra_float_digits = 3;
+SELECT '[1.23456789]'::vector;
+ vector
+--------------
+ [1.23456788]
+(1 row)
+
diff --git a/test/sql/input.sql b/test/sql/input.sql
index c51dfa1f..00a6556c 100644
--- a/test/sql/input.sql
+++ b/test/sql/input.sql
@@ -3,6 +3,8 @@ CREATE EXTENSION IF NOT EXISTS vector;
SELECT '[1,2,3]'::vector;
SELECT '[-1,2,3]'::vector;
+SELECT '[1.23456]'::vector;
+SELECT '[1.234567]'::vector;
SELECT '[hello,1]'::vector;
SELECT '[NaN,1]'::vector;
SELECT '[Infinity,1]'::vector;
@@ -16,3 +18,6 @@ SELECT '[1,2,3]'::vector(2);
SELECT unnest('{"[1,2,3]", "[4,5,6]"}'::vector[]);
SELECT '{"[1,2,3]"}'::vector(2)[];
+
+set extra_float_digits = 3;
+SELECT '[1.23456789]'::vector;
[parent: d605948be407]