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]