Rename parser token REF to REF_P to avoid a symbol conflict.

tglsfdc · tglsfdc · commit 9bfa043a1379 · 2022-10-16T15:27:04.000-04:00
In the latest version of Apple's macOS SDK, <sys/socket.h> fails to compile if "REF" is #define'd as something. Apple may or may not agree that this is a bug, and even if they do accept the bug report I filed, they probably won't fix it very quickly. In the meantime, our back branches will all fail to compile gram.y. v15 and HEAD currently escape the problem thanks to the refactoring done in 98e93a1, but that's purely accidental. Moreover, since that patch removed a widely-visible inclusion of <netdb.h>, back-patching it seems too likely to break third-party code. Instead, change the token's code name to REF_P, following our usual convention for naming parser tokens that are likely to have symbol conflicts. The effects of that should be localized to the grammar and immediately surrounding files, so it seems like a safer answer. Per project policy that we want to keep recently-out-of-support branches buildable on modern systems, back-patch all the way to 9.2. Discussion: https://postgr.es/m/1803927.1665938411@sss.pgh.pa.us
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
@@ -621,7 +621,7 @@ static Node *makeRecursiveViewSelect(char *relname, List *aliases, Node *query);
 
 	QUOTE
 
-	RANGE READ REAL REASSIGN RECHECK RECURSIVE REF REFERENCES REFRESH REINDEX
+	RANGE READ REAL REASSIGN RECHECK RECURSIVE REF_P REFERENCES REFRESH REINDEX
 	RELATIVE_P RELEASE RENAME REPEATABLE REPLACE REPLICA
 	RESET RESTART RESTRICT RETURNING RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP
 	ROW ROWS RULE
@@ -12739,15 +12739,15 @@ xmlexists_argument:
 				{
 					$$ = $2;
 				}
-			| PASSING c_expr BY REF
+			| PASSING c_expr BY REF_P
 				{
 					$$ = $2;
 				}
-			| PASSING BY REF c_expr
+			| PASSING BY REF_P c_expr
 				{
 					$$ = $4;
 				}
-			| PASSING BY REF c_expr BY REF
+			| PASSING BY REF_P c_expr BY REF_P
 				{
 					$$ = $4;
 				}
@@ -13966,7 +13966,7 @@ unreserved_keyword:
 			| REASSIGN
 			| RECHECK
 			| RECURSIVE
-			| REF
+			| REF_P
 			| REFRESH
 			| REINDEX
 			| RELATIVE_P
diff --git a/src/include/parser/kwlist.h b/src/include/parser/kwlist.h
@@ -311,7 +311,7 @@ PG_KEYWORD("real", REAL, COL_NAME_KEYWORD)
 PG_KEYWORD("reassign", REASSIGN, UNRESERVED_KEYWORD)
 PG_KEYWORD("recheck", RECHECK, UNRESERVED_KEYWORD)
 PG_KEYWORD("recursive", RECURSIVE, UNRESERVED_KEYWORD)
-PG_KEYWORD("ref", REF, UNRESERVED_KEYWORD)
+PG_KEYWORD("ref", REF_P, UNRESERVED_KEYWORD)
 PG_KEYWORD("references", REFERENCES, RESERVED_KEYWORD)
 PG_KEYWORD("refresh", REFRESH, UNRESERVED_KEYWORD)
 PG_KEYWORD("reindex", REINDEX, UNRESERVED_KEYWORD)

Original file line number	Diff line number	Diff line change
`@@ -621,7 +621,7 @@ static Node makeRecursiveViewSelect(char relname, List aliases, Node query);`
`621`	`621`
`622`	`622`	`QUOTE`
`623`	`623`
`624`		`- RANGE READ REAL REASSIGN RECHECK RECURSIVE REF REFERENCES REFRESH REINDEX`
	`624`	`+ RANGE READ REAL REASSIGN RECHECK RECURSIVE REF_P REFERENCES REFRESH REINDEX`
`625`	`625`	`RELATIVE_P RELEASE RENAME REPEATABLE REPLACE REPLICA`
`626`	`626`	`RESET RESTART RESTRICT RETURNING RETURNS REVOKE RIGHT ROLE ROLLBACK ROLLUP`
`627`	`627`	`ROW ROWS RULE`
`@@ -12739,15 +12739,15 @@ xmlexists_argument:`
`12739`	`12739`	`{`
`12740`	`12740`	`$$ = $2;`
`12741`	`12741`	`}`
`12742`		`- \| PASSING c_expr BY REF`
	`12742`	`+ \| PASSING c_expr BY REF_P`
`12743`	`12743`	`{`
`12744`	`12744`	`$$ = $2;`
`12745`	`12745`	`}`
`12746`		`- \| PASSING BY REF c_expr`
	`12746`	`+ \| PASSING BY REF_P c_expr`
`12747`	`12747`	`{`
`12748`	`12748`	`$$ = $4;`
`12749`	`12749`	`}`
`12750`		`- \| PASSING BY REF c_expr BY REF`
	`12750`	`+ \| PASSING BY REF_P c_expr BY REF_P`
`12751`	`12751`	`{`
`12752`	`12752`	`$$ = $4;`
`12753`	`12753`	`}`
`@@ -13966,7 +13966,7 @@ unreserved_keyword:`
`13966`	`13966`	`\| REASSIGN`
`13967`	`13967`	`\| RECHECK`
`13968`	`13968`	`\| RECURSIVE`
`13969`		`- \| REF`
	`13969`	`+ \| REF_P`
`13970`	`13970`	`\| REFRESH`
`13971`	`13971`	`\| REINDEX`
`13972`	`13972`	`\| RELATIVE_P`