[teiid-issues] [JBoss JIRA] (TEIID-5443) Using RAND() function in a column mask errors on temp table creation

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-5443.
-----------------------------------
    Fix Version/s: 11.1
                   10.3.4
                   11.0.2
       Resolution: Done


Addressed by correcting the view creation - we need to use the existing virtual group symbol names, not the names off of the masked expressions.  In any case the logic for creating the masked expressions was also updated to use expressionsymbols to convey that they are created at the relevant project node and have a name.

The attached test will still fail if the random function is marked as non-deterministic - as that will trigger the view creation.

> Using RAND() function in a column mask errors on temp table creation
> --------------------------------------------------------------------
>
>                 Key: TEIID-5443
>                 URL: https://issues.jboss.org/browse/TEIID-5443
>             Project: Teiid
>          Issue Type: Bug
>          Components: Server
>    Affects Versions: 8.12.14.6_4
>            Reporter: Debbie Steigner
>            Assignee: Steven Hawkins
>             Fix For: 11.1, 10.3.4, 11.0.2
>
>
> Column masking with RAND() tries to create a temp table and errors:
> 09:47:47,601 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'



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)