Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ysql: Intermittent TestPgRegressAuthorization failure #9982

Open
tedyu opened this issue Sep 13, 2021 · 0 comments
Open

ysql: Intermittent TestPgRegressAuthorization failure #9982

tedyu opened this issue Sep 13, 2021 · 0 comments
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue

Comments

@tedyu
Copy link
Contributor

tedyu commented Sep 13, 2021

Jira Link: DB-4793
https://detective-gcp.dev.yugabyte.com/job/github-yugabyte-db-phabricator%2F117259%2Fartifact%2Fjava%2Fyb-pgsql%2Ftarget%2Fsurefire-reports_org.yb.pgsql.TestPgRegressAuthorization__testPgRegressAuthorization%2Forg.yb.pgsql.TestPgRegressAuthorization-output.txt?class=org.yb.pgsql.TestPgRegressAuthorization&max_lines=3000&name=testPgRegressAuthorization&start_line=108001

Here is the difference in output:

*** /tmp/yb_test.org.yb.pgsql.TestPgRegressAuthorization#testPgRegressAuthorization.20210910221309158275.3872407918/pgregress_output/expected/yb_pg_privileges.out 2021-09-10 22:18:50.351016177 +0000
109076 | --- /tmp/yb_test.org.yb.pgsql.TestPgRegressAuthorization#testPgRegressAuthorization.20210910221309158275.3872407918/pgregress_output/results/yb_pg_privileges.out 2021-09-10 22:18:50.265010412 +0000
109077 | ***************
109078 | *** 290,295 ****
109079 | --- 290,296 ----
109080 | SELECT * FROM atest3; -- fail
109081 | ERROR: permission denied for table atest3
109082 | DELETE FROM atest3; -- ok
109083 | + ERROR: permission denied for table atest3
109084 | -- views
109085 | SET SESSION AUTHORIZATION regress_priv_user3;
109086 | CREATE VIEW atestv1 AS SELECT * FROM atest1; -- ok
109087
@rthallamko3 rthallamko3 added the area/ysql Yugabyte SQL (YSQL) label Jan 3, 2023
@yugabyte-ci yugabyte-ci added kind/bug This issue is a bug priority/medium Medium priority issue labels Jan 3, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
area/ysql Yugabyte SQL (YSQL) kind/bug This issue is a bug priority/medium Medium priority issue
Projects
None yet
Development

No branches or pull requests

3 participants