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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Close

Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.