postgrespro
diff --git a/‎expected/rum_validate.out
Copy file name to clipboardExpand all lines: expected/rum_validate.out
+11-1Lines changed: 11 additions & 1 deletion b/‎expected/rum_validate.out
Copy file name to clipboardExpand all lines: expected/rum_validate.out
+11-1Lines changed: 11 additions & 1 deletion
diff --git a/‎sql/rum_validate.sql
Copy file name to clipboardExpand all lines: sql/rum_validate.sql
+7-1Lines changed: 7 additions & 1 deletion b/‎sql/rum_validate.sql
Copy file name to clipboardExpand all lines: sql/rum_validate.sql
+7-1Lines changed: 7 additions & 1 deletion
diff --git a/‎src/rumutil.c
Copy file name to clipboardExpand all lines: src/rumutil.c
+3Lines changed: 3 additions & 0 deletions b/‎src/rumutil.c
Copy file name to clipboardExpand all lines: src/rumutil.c
+3Lines changed: 3 additions & 0 deletions
@@ -114,9 +114,19 @@ SET enable_indexscan=on;
 SELECT a
 	FROM test_rum
 	WHERE a @@ to_tsquery('pg_catalog.english', 'bar')
-	ORDER BY a <=> (to_tsquery('pg_catalog.english', 'bar'),0)
+	ORDER BY a <=> (to_tsquery('pg_catalog.english', 'bar'),0);
               a               
 ------------------------------
  'bar':2,8 'foo':1,3,6 'qq':7
 (1 row)
 
+-- PGPRO-9026: column and attached column cannot be the same
+CREATE TABLE test_array (i int2[]);
+CREATE INDEX idx_array ON test_array USING rum (i rum_anyarray_addon_ops) WITH (attach = 'i', to = 'i');
+ERROR:  column "i" and attached column cannot be the same
+SELECT * FROM test_array WHERE i && '{1}';
+ i 
+---
+(0 rows)
+
+DROP TABLE test_array;
@@ -58,4 +58,10 @@ SET enable_indexscan=on;
 SELECT a
 	FROM test_rum
 	WHERE a @@ to_tsquery('pg_catalog.english', 'bar')
-	ORDER BY a <=> (to_tsquery('pg_catalog.english', 'bar'),0)
+	ORDER BY a <=> (to_tsquery('pg_catalog.english', 'bar'),0);
+
+-- PGPRO-9026: column and attached column cannot be the same
+CREATE TABLE test_array (i int2[]);
+CREATE INDEX idx_array ON test_array USING rum (i rum_anyarray_addon_ops) WITH (attach = 'i', to = 'i');
+SELECT * FROM test_array WHERE i && '{1}';
+DROP TABLE test_array;
@@ -211,6 +211,9 @@ initRumState(RumState * state, Relation index)
 
 			if (!AttributeNumberIsValid(state->attrnAddToColumn))
 				elog(ERROR, "attribute \"%s\" is not found in index", colname);
+
+			if (state->attrnAddToColumn == state->attrnAttachColumn)
+				elog(ERROR, "column \"%s\" and attached column cannot be the same", colname);
 		}
 
 		if (!(AttributeNumberIsValid(state->attrnAttachColumn) &&
Original file line number	Diff line number	Diff line change
`@@ -211,6 +211,9 @@ initRumState(RumState * state, Relation index)`
`211`	`211`
`212`	`212`	`if (!AttributeNumberIsValid(state->attrnAddToColumn))`
`213`	`213`	`elog(ERROR, "attribute \"%s\" is not found in index", colname);`
	`214`	`+`
	`215`	`+ if (state->attrnAddToColumn == state->attrnAttachColumn)`
	`216`	`+ elog(ERROR, "column \"%s\" and attached column cannot be the same", colname);`
`214`	`217`	`}`
`215`	`218`
`216`	`219`	`if (!(AttributeNumberIsValid(state->attrnAttachColumn) &&`