[
https://issues.apache.org/jira/browse/DERBY-3073?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dag H. Wanvik updated DERBY-3073:
---------------------------------
Attachment: DERBY-3073b.stat
DERBY-3073b.diff
This patch, DERBY-3073b, replaces DERBY-3073.
The previous version had some issues which are corrected in this version:
- Parser support for create synonym was accidentally broken in the first
version.
- The look-ahead handling introduced to differentiate between granting of roles
and granting of privileges was broken. The new version is hopefully adequate.
- A test is now included (lang/RolesTest.java).
With this patch, the parser modifications should be completed as per the
specification in DERBY-2207, i.e. support for:
- create role
- drop role
- grant role
- revoke role
- set role
- current_role as value specification
- current_role as column default
All new features presently give "not implemented" (0A000: NOT_IMPLEMENTED) at
run-time if running with sql authorization, otherwise an error message (42Z60:
LANG_GRANT_REVOKE_WITH_LEGACY_ACCESS) is given.
Also, for all new features, if the database is pre-10.4, level (in soft upgrade
mode), an error is given (XCL47: LANG_STATEMENT_UPGRADE_REQUIRED).
All regression tests pass, including the new test.
As for the upgrade check, I have only tested manually so far. It will be added
to upgrade tests
later.
It is ready for review; I will appreciate any comments!
> SQL roles: add parser support
> -----------------------------
>
> Key: DERBY-3073
> URL: https://issues.apache.org/jira/browse/DERBY-3073
> Project: Derby
> Issue Type: New Feature
> Components: SQL
> Reporter: Dag H. Wanvik
> Attachments: DERBY-3073.diff, DERBY-3073.stat, DERBY-3073b.diff,
> DERBY-3073b.stat
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
