You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2009/04/27 13:25:32 UTC
[jira] Commented: (DERBY-4189) CURRENT_ROLE returns role name with
double quotes around it
[ https://issues.apache.org/jira/browse/DERBY-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12703073#action_12703073 ]
Knut Anders Hatlen commented on DERBY-4189:
-------------------------------------------
>From what I can see in the SQL standard (ISO/IEC 9075-2:2003 (E) - 6.4 <value specification> and <target specification> - general rule 8), CURRENT_ROLE should return the name of the current role, not a quoted identifier.
> CURRENT_ROLE returns role name with double quotes around it
> -----------------------------------------------------------
>
> Key: DERBY-4189
> URL: https://issues.apache.org/jira/browse/DERBY-4189
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.5.1.1
> Reporter: Knut Anders Hatlen
> Priority: Minor
>
> CURRENT_ROLE returns the current role name with quotes around it. This does not follow the existing pattern used by CURRENT_USER.
> Example:
> $ java -Dderby.connection.requireAuthentication=true -Dderby.database.sqlAuthorization=true -Dderby.user.kah=secret -jar lib/derbyrun.jar ij
> ij version 10.5
> ij> connect 'jdbc:derby:db;create=true;user=kah;password=secret';
> ij> create role myrole;
> 0 rows inserted/updated/deleted
> ij> set role myrole;
> 0 rows inserted/updated/deleted
> ij> values current_user;
> 1
> --------------------------------------------------------------------------------------------------------------------------------
> KAH
> 1 row selected
> ij> values current_role;
> 1
> --------------------------------------------------------------------------------------------------------------------------------
> "MYROLE"
> 1 row selected
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.