[
https://issues.apache.org/jira/browse/DERBY-4189?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Knut Anders Hatlen closed DERBY-4189.
-------------------------------------
Resolution: Won't Fix
Right, it looks like this has been discussed in great length before, and the
behaviour is intended. It's not clear to me that the current behaviour follows
the standard (actually, it doesn't even look like those involved in the
original discussion were quite convinced they had interpreted the standard
correctly), but since I don't have any other concerns than those that have
already been raised and discussed, I'm closing this issue as "Won't Fix".
> 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.
