postgres
diff --git a/‎src/test/regress/expected/create_index_spgist.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/create_index_spgist.out
+10Lines changed: 10 additions & 0 deletions b/‎src/test/regress/expected/create_index_spgist.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/create_index_spgist.out
+10Lines changed: 10 additions & 0 deletions
diff --git a/‎src/test/regress/sql/create_index_spgist.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/create_index_spgist.sql
+4Lines changed: 4 additions & 0 deletions b/‎src/test/regress/sql/create_index_spgist.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/create_index_spgist.sql
+4Lines changed: 4 additions & 0 deletions
@@ -555,6 +555,16 @@ WHERE seq.dist IS DISTINCT FROM idx.dist;
 ---+------+---+---+------+---
 (0 rows)
 
+-- check ORDER BY distance to NULL
+SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt, p <-> '0,0' LIMIT 1)
+FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt);
+      p      
+-------------
+ (59,21)
+ (59,21)
+ (1239,5647)
+(3 rows)
+
 EXPLAIN (COSTS OFF)
 SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef';
                          QUERY PLAN                         
 
@@ -225,6 +225,10 @@ SELECT * FROM quad_point_tbl_ord_seq3 seq FULL JOIN kd_point_tbl_ord_idx3 idx
 ON seq.n = idx.n
 WHERE seq.dist IS DISTINCT FROM idx.dist;
 
+-- check ORDER BY distance to NULL
+SELECT (SELECT p FROM kd_point_tbl ORDER BY p <-> pt, p <-> '0,0' LIMIT 1)
+FROM (VALUES (point '1,2'), (NULL), ('1234,5678')) pts(pt);
+
 
 EXPLAIN (COSTS OFF)
 SELECT count(*) FROM radix_text_tbl WHERE t = 'P0123456789abcdef';