[teiid-issues] [JBoss JIRA] (TEIID-2695) Unable to use CASE statement in Select
Steven Hawkins (JIRA)
jira-events at lists.jboss.org
Fri Oct 11 12:23:26 EDT 2013
[ https://issues.jboss.org/browse/TEIID-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12813539#comment-12813539 ]
Steven Hawkins commented on TEIID-2695:
---------------------------------------
As noted in the docs, you need to be case sensitive.
> 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
More information about the teiid-issues
mailing list