GIN: check && 'empty'

df7cb · msdemlei · commit 98fc1ba8f0d7 · 2021-04-22T14:01:36.000+02:00
diff --git a/expected/moc100.out b/expected/moc100.out
@@ -45,6 +45,16 @@ SELECT ivoid FROM moc100 WHERE coverage && '4/0' ORDER BY ivoid;
  ivo://vopdc.obspm/luth/hess
 (35 rows)
 
+EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)
+	SELECT * FROM moc100 WHERE coverage && '0/';
+                                                QUERY PLAN                                                
+----------------------------------------------------------------------------------------------------------
+ Bitmap Heap Scan on moc100  (cost=0.00..4.01 rows=1 width=96) (actual rows=0 loops=1)
+   Recheck Cond: (coverage && '0/'::smoc)
+   ->  Bitmap Index Scan on moc100_coverage_idx  (cost=0.00..0.00 rows=1 width=0) (actual rows=0 loops=1)
+         Index Cond: (coverage && '0/'::smoc)
+(4 rows)
+
 EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)
 	SELECT * FROM moc100 WHERE coverage && '4/0';
                                    QUERY PLAN                                   
diff --git a/sql/moc100.sql b/sql/moc100.sql
@@ -111,6 +111,9 @@ CREATE INDEX ON moc100 USING GIN (coverage);
 
 SELECT ivoid FROM moc100 WHERE coverage && '4/0' ORDER BY ivoid;
 
+EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)
+	SELECT * FROM moc100 WHERE coverage && '0/';
+
 EXPLAIN (ANALYZE, BUFFERS, TIMING OFF, SUMMARY OFF)
 	SELECT * FROM moc100 WHERE coverage && '4/0';
 
