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

[Van Halbert (JIRA)]

Van Halbert created TEIID-2695:
----------------------------------

             Summary: 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


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