postgres
diff --git a/‎src/backend/parser/analyze.c
Copy file name to clipboardExpand all lines: src/backend/parser/analyze.c
+1-1Lines changed: 1 addition & 1 deletion b/‎src/backend/parser/analyze.c
Copy file name to clipboardExpand all lines: src/backend/parser/analyze.c
+1-1Lines changed: 1 addition & 1 deletion
diff --git a/‎src/backend/utils/adt/selfuncs.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/selfuncs.c
+2-1Lines changed: 2 additions & 1 deletion b/‎src/backend/utils/adt/selfuncs.c
Copy file name to clipboardExpand all lines: src/backend/utils/adt/selfuncs.c
+2-1Lines changed: 2 additions & 1 deletion
diff --git a/‎src/test/regress/expected/errors.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/errors.out
+5Lines changed: 5 additions & 0 deletions b/‎src/test/regress/expected/errors.out
Copy file name to clipboardExpand all lines: src/test/regress/expected/errors.out
+5Lines changed: 5 additions & 0 deletions
diff --git a/‎src/test/regress/sql/errors.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/errors.sql
+4Lines changed: 4 additions & 0 deletions b/‎src/test/regress/sql/errors.sql
Copy file name to clipboardExpand all lines: src/test/regress/sql/errors.sql
+4Lines changed: 4 additions & 0 deletions
@@ -2688,7 +2688,7 @@ CheckSelectLocking(Query *qry, LockClauseStrength strength)
 		  translator: %s is a SQL row locking clause such as FOR UPDATE */
 				 errmsg("%s is not allowed with DISTINCT clause",
 						LCS_asString(strength))));
-	if (qry->groupClause != NIL)
+	if (qry->groupClause != NIL || qry->groupingSets != NIL)
 		ereport(ERROR,
 				(errcode(ERRCODE_FEATURE_NOT_SUPPORTED),
 		/*------
 
@@ -5150,7 +5150,8 @@ examine_simple_variable(PlannerInfo *root, Var *var,
 		 * of learning something even with it.
 		 */
 		if (subquery->setOperations ||
-			subquery->groupClause)
+			subquery->groupClause ||
+			subquery->groupingSets)
 			return;
 
 		/*
 
@@ -50,6 +50,11 @@ select distinct on (foobar) * from pg_database;
 ERROR:  column "foobar" does not exist
 LINE 1: select distinct on (foobar) * from pg_database;
                             ^
+-- grouping with FOR UPDATE
+select null from pg_database group by datname for update;
+ERROR:  FOR UPDATE is not allowed with GROUP BY clause
+select null from pg_database group by grouping sets (()) for update;
+ERROR:  FOR UPDATE is not allowed with GROUP BY clause
 --
 -- DELETE
 -- missing relation name (this had better not wildcard!)
 
@@ -37,6 +37,10 @@ select * from pg_database where pg_database.datname = nonesuch;
 -- bad attribute name in select distinct on
 select distinct on (foobar) * from pg_database;
 
+-- grouping with FOR UPDATE
+select null from pg_database group by datname for update;
+select null from pg_database group by grouping sets (()) for update;
+
 
 --
 -- DELETE