DV RAND() function in a column mask expression fails
Issue
- Using RAND() function in a column mask expression to randomly generate a number for the mask value of an id column
Environment
- Red Hat JBoss Data Virtualization (DV) 6.4
- Dynamic VDB with mask expression:
<permission>
<resource-name>data_pg.emp.id</resource-name>
<condition>id>0</condition>
<mask order="1">convert(RAND()*100000,integer)</mask>
</permission>
- Gives error:
ERROR [org.teiid.PROCESSOR] (Worker20_QueryProcessorQueue88) TEIID30019 Unexpected exception for request IAgYDrdYXFRm.30: org.teiid.core.TeiidComponentException: TEIID30091 org.teiid.api.exception.query.QueryResolverException: TEIID30091 Cannot create group 'sec AS sec__1' with multiple columns named 'expr'
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.