allow_relabelled_vars_in_dependency_stats.patch

application/octet-stream

Filename: allow_relabelled_vars_in_dependency_stats.patch
Type: application/octet-stream
Part: 0
Message: Extended statistics is not working on Vars hidden under a RelabelType

Patch

Format: unified
File+
src/backend/statistics/dependencies.c 8 0
diff --git a/src/backend/statistics/dependencies.c b/src/backend/statistics/dependencies.c
index 2e7c0ad..9756fb8 100644
--- a/src/backend/statistics/dependencies.c
+++ b/src/backend/statistics/dependencies.c
@@ -792,6 +792,14 @@ dependency_is_compatible_clause(Node *clause, Index relid, AttrNumber *attnum)
 
 		var = (varonleft) ? linitial(expr->args) : lsecond(expr->args);
 
+		/*
+		 * We may ignore any RelabelType node above the operand.  (There won't
+		 * be more than one, since eval_const_expressions() has been applied
+		 * already.)
+		 */
+		if (IsA(var, RelabelType))
+			var = (Var *) ((RelabelType *) var)->arg;
+
 		/* We only support plain Vars for now */
 		if (!IsA(var, Var))
 			return false;