db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Closed: (DERBY-4189) CURRENT_ROLE returns role name with double quotes around it
Date Wed, 29 Apr 2009 08:22:30 GMT

     [ 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.


Mime
View raw message