[ysql] Port table locks tests from privileges.sql to YB #27402
Assignees
Labels
2025.1 Backport Required
area/ysql
Yugabyte SQL (YSQL)
kind/enhancement
This is an enhancement of an existing feature
priority/medium
Medium priority issue
Comments
67 tasks
yusong-yan
added a commit
that referenced
this issue
May 30, 2025
Summary:
The yb.port.privileges test involves LOCK TABLE statements. Previously, table-level locks were not supported in YugabyteDB, so these statements would fail with:
```
LOCK atest2 IN ACCESS EXCLUSIVE MODE; -- ok
ERROR: ACCESS EXCLUSIVE not supported yet
LINE 1: LOCK atest2 IN ACCESS EXCLUSIVE MODE;
^
HINT: Please report the issue on https://github.com/YugaByte/yugabyte-db/issues
```
Now that table-level locking is supported, this diff enables LOCK TABLE functionality for the test and updates the yb.port.privileges.out file to reflect the expected behavior where LOCK TABLE works as intended.
Jira: DB-16936
Test Plan: ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressPgAuth#schedule'
Reviewers: bkolagani, pjain, rthallam, jason
Reviewed By: bkolagani, rthallam, jason
Subscribers: ybase, rthallam, yql
Differential Revision: https://phorge.dev.yugabyte.com/D44367
yusong-yan
added a commit
that referenced
this issue
Jun 3, 2025
…leges test Summary: Original commit: 3ff5c3b / D44367 The yb.port.privileges test involves LOCK TABLE statements. Previously, table-level locks were not supported in YugabyteDB, so these statements would fail with: ``` LOCK atest2 IN ACCESS EXCLUSIVE MODE; -- ok ERROR: ACCESS EXCLUSIVE not supported yet LINE 1: LOCK atest2 IN ACCESS EXCLUSIVE MODE; ^ HINT: Please report the issue on https://github.com/YugaByte/yugabyte-db/issues ``` Now that table-level locking is supported, this diff enables LOCK TABLE functionality for the test and updates the yb.port.privileges.out file to reflect the expected behavior where LOCK TABLE works as intended. Jira: DB-16936 Test Plan: ./yb_build.sh --java-test 'org.yb.pgsql.TestPgRegressPgAuth#schedule' Reviewers: bkolagani, pjain, rthallam, jason, #db-approvers Reviewed By: rthallam Subscribers: yql, rthallam, ybase Differential Revision: https://phorge.dev.yugabyte.com/D44405
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
Jira Link: DB-16936
Description
Port table locks tests from privileges.sql to YB
Issue Type
kind/enhancement
Warning: Please confirm that this issue does not contain any sensitive information
The text was updated successfully, but these errors were encountered: