gistfile1.txt

diff --git a/geofield.module b/geofield.module
index 45cb326..41f9ddd 100644
--- a/geofield.module
+++ b/geofield.module
@@ -135,7 +135,7 @@ function geofield_radius_options() {
  *   The generated SQL query snippet for haversine formula.
  */
 function geofield_haversine($options = []) {
-  $formula = '( :earth_radius * ACOS( COS( RADIANS(:origin_latitude) ) * COS( RADIANS(:destination_latitude) ) * COS( RADIANS(:destination_longitude) - RADIANS(:origin_longitude) ) + SIN( RADIANS(:origin_latitude) ) * SIN( RADIANS(:destination_latitude) ) ) )';
+  $formula = '( :earth_radius * ACOS( LEAST(1, COS( RADIANS(:origin_latitude) ) * COS( RADIANS(:destination_latitude) ) * COS( RADIANS(:destination_longitude) - RADIANS(:origin_longitude) ) + SIN( RADIANS(:origin_latitude) ) * SIN( RADIANS(:destination_latitude) ) ) ) )';
 
   foreach ($options as $key => $option) {
     if (is_numeric($option)) {

See https://www.drupal.org/project/geofield/issues/2654360#comment-12831745