Add handling of case when we hit the gap between partitions.

Alexander Korotkov · Alexander Korotkov · commit 02402f971af5 · 2016-06-03T09:19:13.000+03:00
diff --git a/src/pg_pathman.c b/src/pg_pathman.c
@@ -997,6 +997,24 @@ handle_binary_opexpr(WalkerContext *context, WrapperNode *result,
 					/* If we still didn't find partition then it doesn't exist */
 					if (startidx >= endidx)
 					{
+						/* Handle case when we hit the gap between partitions */
+						if (strategy != BTEqualStrategyNumber)
+						{
+							if (strategy == BTLessStrategyNumber ||
+								strategy == BTLessEqualStrategyNumber)
+							{
+								if (is_less && i > 0)
+									i--;
+							}
+							if (strategy == BTGreaterStrategyNumber ||
+								strategy == BTGreaterEqualStrategyNumber)
+							{
+								if (is_greater && i < rangerel->ranges.length - 1)
+									i++;
+							}
+							lossy = false;
+							break;
+						}
 						result->rangeset = NIL;
 						return;
 					}
