[JBoss JIRA] (TEIID-5443) Using RAND() function in a column mask errors on temp table creation
- First Post
- Replies
- Stats
-
Go to
- ----- 2026 -----
- April
- March
- February
- January
- ----- 2025 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2024 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2023 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2022 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2021 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2020 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2019 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2018 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2017 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2016 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2015 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2014 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2013 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2012 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2011 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2010 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
- January
- ----- 2009 -----
- December
- November
- October
- September
- August
- July
- June
- May
- April
- March
- February
[
https://issues.jboss.org/browse/TEIID-5443?page=com.atlassian.jira.plugin...
]
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)
2783
days inactive
2783
days old
0 comments
1 participants
tags (0)
participants (1)
-
Steven Hawkins (JIRA)