postgres
diff --git a/‎src/backend/utils/adt/like_support.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/like_support.c
+11-2Lines changed: 11 additions & 2 deletions b/‎src/backend/utils/adt/like_support.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/like_support.c
+11-2Lines changed: 11 additions & 2 deletions
@@ -1442,9 +1442,18 @@ regex_selectivity(const char *patt, int pattlen, bool case_insensitive,
 		sel *= FULL_WILDCARD_SEL;
 	}
 
-	/* If there's a fixed prefix, discount its selectivity */
+	/*
+	 * If there's a fixed prefix, discount its selectivity.  We have to be
+	 * careful here since a very long prefix could result in pow's result
+	 * underflowing to zero (in which case "sel" probably has as well).
+	 */
 	if (fixed_prefix_len > 0)
-		sel /= pow(FIXED_CHAR_SEL, fixed_prefix_len);
+	{
+		double		prefixsel = pow(FIXED_CHAR_SEL, fixed_prefix_len);
+
+		if (prefixsel > 0.0)
+			sel /= prefixsel;
+	}
 
 	/* Make sure result stays in range */
 	CLAMP_PROBABILITY(sel);