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]