Slightly improved tests

waaeer · waaeer · commit 7d8e47717e20 · 2023-05-14T09:25:11.000+03:00
diff --git a/expected/index_9.5.out b/expected/index_9.5.out
@@ -3,10 +3,10 @@ SET enable_seqscan = OFF;
 SET enable_bitmapscan = OFF;
 SET enable_indexonlyscan = ON;
 EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p <@ scircle '<(1,1),0.3>';
-                      QUERY PLAN                       
--------------------------------------------------------
+                       QUERY PLAN                       
+--------------------------------------------------------
  Aggregate
-   ->  Index Scan using spoint3_idx on spheretmp1b
+   ->  Index Only Scan using spoint3_idx on spheretmp1b
          Index Cond: (p <@ '<(1 , 1) , 0.3>'::scircle)
 (3 rows)
 
@@ -17,10 +17,10 @@ EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p <@ scircle '<(1,1),
 (1 row)
 
 EXPLAIN (COSTS OFF) SELECT count(*) FROM spheretmp1b WHERE p = spoint '(3.09 , 1.25)';
-                    QUERY PLAN                     
----------------------------------------------------
+                       QUERY PLAN                       
+--------------------------------------------------------
  Aggregate
-   ->  Index Scan using spoint3_idx on spheretmp1b
+   ->  Index Only Scan using spoint3_idx on spheretmp1b
          Index Cond: (p = '(3.09 , 1.25)'::spoint)
 (3 rows)
 
diff --git a/expected/knn.out b/expected/knn.out
@@ -6,12 +6,22 @@ EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT
                    QUERY PLAN                    
 -------------------------------------------------
  Limit
-   ->  Index Scan using i on points
+   ->  Index Only Scan using i on points
          Order By: (p <-> '(0.2 , 0.3)'::spoint)
 (3 rows)
 
 UPDATE points SET pos = n FROM (SELECT id, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n  FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10) sel WHERE points.id = sel.id;
 SET enable_indexscan = false;
+SET enable_indexonlyscan = false;
+EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT 10;
+                    QUERY PLAN                     
+---------------------------------------------------
+ Limit
+   ->  Sort
+         Sort Key: ((p <-> '(0.2 , 0.3)'::spoint))
+         ->  Seq Scan on points
+(4 rows)
+
 SELECT pos, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n  FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10;
  pos | n  
 -----+----
diff --git a/sql/knn.sql b/sql/knn.sql
@@ -5,6 +5,8 @@ SET enable_indexscan = true;
 EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT 10;
 UPDATE points SET pos = n FROM (SELECT id, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n  FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10) sel WHERE points.id = sel.id;
 SET enable_indexscan = false;
+SET enable_indexonlyscan = false;
+EXPLAIN (costs off) SELECT p <-> spoint (0.2, 0.3) FROM points ORDER BY 1 LIMIT 10;
 SELECT pos, row_number() OVER (ORDER BY p <-> spoint (0.2, 0.3)) n  FROM points ORDER BY p <-> spoint (0.2, 0.3) LIMIT 10;
 DROP TABLE points;
 
