pgvector.git / summary / log / commit / refs

commit    5abf83c415b610cb5282d3ddfb47c5cf73bb4070
Author:   Andrew Kane <andrew@ankane.org>
Date:     Sat Apr 13 22:58:00 2024 +0000

    Improved sparsevec input tests [skip ci]


test/expected/sparsevec_input.out | 42 +++++++++++++++++++++++++++++++++------ test/sql/sparsevec_input.sql | 8 +++++++- 2 files changed, 43 insertions(+), 7 deletions(-) diff --git a/test/expected/sparsevec_input.out b/test/expected/sparsevec_input.out index 6e158ea3..49ddf317 100644 --- a/test/expected/sparsevec_input.out +++ b/test/expected/sparsevec_input.out @@ -4,18 +4,24 @@ SELECT '{1:1.5,3:3.5}/5'::sparsevec; {1:1.5,3:3.5}/5 (1 row) +SELECT '{1:-2,3:-4}/5'::sparsevec; + sparsevec +--------------- + {1:-2,3:-4}/5 +(1 row) + +SELECT '{1:2.,3:4.}/5'::sparsevec; + sparsevec +------------- + {1:2,3:4}/5 +(1 row) + SELECT ' { 1 : 1.5 , 3 : 3.5 } / 5 '::sparsevec; sparsevec ----------------- {1:1.5,3:3.5}/5 (1 row) -SELECT ' { } / 5'::sparsevec; - sparsevec ------------ - {}/5 -(1 row) - SELECT '{1:1.23456}/1'::sparsevec; sparsevec --------------- @@ -85,6 +91,14 @@ SELECT '{ '::sparsevec; ERROR: invalid input syntax for type sparsevec: "{ " LINE 1: SELECT '{ '::sparsevec; ^ +SELECT '{:'::sparsevec; +ERROR: invalid input syntax for type sparsevec: "{:" +LINE 1: SELECT '{:'::sparsevec; + ^ +SELECT '{,'::sparsevec; +ERROR: invalid input syntax for type sparsevec: "{," +LINE 1: SELECT '{,'::sparsevec; + ^ SELECT '{}'::sparsevec; ERROR: invalid input syntax for type sparsevec: "{}" LINE 1: SELECT '{}'::sparsevec; @@ -94,11 +108,27 @@ SELECT '{}/'::sparsevec; ERROR: invalid input syntax for type sparsevec: "{}/" LINE 1: SELECT '{}/'::sparsevec; ^ +SELECT '{}/1'::sparsevec; + sparsevec +----------- + {}/1 +(1 row) + SELECT '{}/1a'::sparsevec; ERROR: invalid input syntax for type sparsevec: "{}/1a" LINE 1: SELECT '{}/1a'::sparsevec; ^ DETAIL: Junk after closing. +SELECT '{ }/1'::sparsevec; + sparsevec +----------- + {}/1 +(1 row) + +SELECT '{:}/1'::sparsevec; +ERROR: invalid input syntax for type sparsevec: "{:}/1" +LINE 1: SELECT '{:}/1'::sparsevec; + ^ SELECT '{,}/1'::sparsevec; ERROR: invalid input syntax for type sparsevec: "{,}/1" LINE 1: SELECT '{,}/1'::sparsevec; diff --git a/test/sql/sparsevec_input.sql b/test/sql/sparsevec_input.sql index 61e2bab5..db900486 100644 --- a/test/sql/sparsevec_input.sql +++ b/test/sql/sparsevec_input.sql @@ -1,6 +1,7 @@ SELECT '{1:1.5,3:3.5}/5'::sparsevec; +SELECT '{1:-2,3:-4}/5'::sparsevec; +SELECT '{1:2.,3:4.}/5'::sparsevec; SELECT ' { 1 : 1.5 , 3 : 3.5 } / 5 '::sparsevec; -SELECT ' { } / 5'::sparsevec; SELECT '{1:1.23456}/1'::sparsevec; SELECT '{1:hello,2:1}/2'::sparsevec; SELECT '{1:NaN,2:1}/2'::sparsevec; @@ -16,9 +17,14 @@ SELECT '{1:-1e-46,2:1}/2'::sparsevec; SELECT ''::sparsevec; SELECT '{'::sparsevec; SELECT '{ '::sparsevec; +SELECT '{:'::sparsevec; +SELECT '{,'::sparsevec; SELECT '{}'::sparsevec; SELECT '{}/'::sparsevec; +SELECT '{}/1'::sparsevec; SELECT '{}/1a'::sparsevec; +SELECT '{ }/1'::sparsevec; +SELECT '{:}/1'::sparsevec; SELECT '{,}/1'::sparsevec; SELECT '{1,}/1'::sparsevec; SELECT '{:1}/1'::sparsevec; [parent: 96b30fd25de9]