[teiid-issues] [JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select

[Van Halbert (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12813475#comment-12813475 ] 

Van Halbert commented on TEIID-2695:
------------------------------------

What it sounds like is Teiid is basing the hasRole() on what roles are defined in the vdb.xml and is also mapped to the user, not what is defined in the roles properties file,
                
> Unable to use CASE statement in Select
> --------------------------------------
>
>                 Key: TEIID-2695
>                 URL: https://issues.jboss.org/browse/TEIID-2695
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.4.1
>            Reporter: Van Halbert
>            Assignee: Steven Hawkins
>         Attachments: portfolio-vdb.xml
>
>
> Trying to add a <mask> of:
> <permission>
>       <resource-name>Stocks.StockPrices.Price</resource-name>
>      <mask>CASE WHEN hasRole('prices') THEN Price END</mask>
>  </permission>
> even tried using "= true" just to see
> but it it always returns null for Prices.
> To test it, I logged in as 'user' using CommandLog vdb and issued:
> Select VDB, CASE WHEN hasRole('prices') THEN 'Y' Else 'N' END as V from TEIID_COMMANDLOG
> and 'N' was always returned for column V.
> teiid roles file:
> # A roles.properties file for use with the UsersRolesLoginModule
> # username=role1,role2
> portfolio=superuser
> viewonly=readonly
> user=user,prices

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira