pgvector.git / summary / log / commit / refs

commit    e8bd7cd2f5c8e5c2e54412dd213c376d87b9e2ee
Author:   Andrew Kane <andrew@ankane.org>
Date:     Thu Apr 11 16:22:03 2024 +0000

    Updated test to be independent of order [skip ci]


 test/expected/ivfflat_vector_l2.out | 13 +++++--------
 test/sql/ivfflat_vector_l2.sql      |  2 +-
 2 files changed, 6 insertions(+), 9 deletions(-)

diff --git a/test/expected/ivfflat_vector_l2.out b/test/expected/ivfflat_vector_l2.out
index bef78ae6..7580afc7 100644
--- a/test/expected/ivfflat_vector_l2.out
+++ b/test/expected/ivfflat_vector_l2.out
@@ -12,14 +12,11 @@ SELECT * FROM t ORDER BY val <-> '[3,3,3]';
  [0,0,0]
 (4 rows)
 
-SELECT * FROM t ORDER BY val <-> (SELECT NULL::vector);
-   val   
----------
- [0,0,0]
- [1,1,1]
- [1,2,3]
- [1,2,4]
-(4 rows)
+SELECT COUNT(*) FROM (SELECT * FROM t ORDER BY val <-> (SELECT NULL::vector)) t2;
+ count 
+-------
+     4
+(1 row)
 
 SELECT COUNT(*) FROM t;
  count 
diff --git a/test/sql/ivfflat_vector_l2.sql b/test/sql/ivfflat_vector_l2.sql
index c309519e..9c7b5d56 100644
--- a/test/sql/ivfflat_vector_l2.sql
+++ b/test/sql/ivfflat_vector_l2.sql
@@ -7,7 +7,7 @@ CREATE INDEX ON t USING ivfflat (val vector_l2_ops) WITH (lists = 1);
 INSERT INTO t (val) VALUES ('[1,2,4]');
 
 SELECT * FROM t ORDER BY val <-> '[3,3,3]';
-SELECT * FROM t ORDER BY val <-> (SELECT NULL::vector);
+SELECT COUNT(*) FROM (SELECT * FROM t ORDER BY val <-> (SELECT NULL::vector)) t2;
 SELECT COUNT(*) FROM t;
 
 TRUNCATE t;


[parent: bed40ec0b5f5]