cockroachdb / cockroachdb/cockroach
sem/builtins: `makeaclitem` seemingly orders privileges in PG
Open
A-sql-pgcompat
branch-release-26.2
C-bug
O-pg-regress
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Extracted from `pg_regress`.
```sql
CREATE USER regress_priv_user1;
CREATE USER regress_priv_user2;
-- we return 'rawd' whereas PG returns 'arwd'
SELECT makeaclitem('regress_priv_user1'::regrole, 'regress_priv_user2'::regrole,
'SELECT, INSERT, UPDATE , DELETE ', FALSE); -- multiple privileges
```
cc @rafiss
Jira issue: CRDB-62203
Epic CRDB-60816
Contributor guide
Assessment
This issue has not been assessed yet.