DV RAND() function in a column mask expression fails

Solution Verified - Updated -

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.

Current Customers and Partners

Log in for full access

Log In