]
Steven Hawkins updated TEIID-1862:
----------------------------------
Issue Type: Task (was: Bug)
Priority: Optional (was: Major)
add regression test for nested selects using UNION ALL and multiple
aliases of the same column.
-----------------------------------------------------------------------------------------------
Key: TEIID-1862
URL:
https://issues.jboss.org/browse/TEIID-1862
Project: Teiid
Issue Type: Task
Components: Query Engine
Affects Versions: 7.6.1
Environment: Teiid 7.6.x
Reporter: Johnathon Lee
Assignee: Johnathon Lee
Priority: Optional
Attachments: teiid-1862_7.6.x.patch
Pre 7.x code would throw a NPE with a query similar to [1]. Adding JUnit to prevent
regression
[1]
SELECT enterprise_id FROM (
SELECT * FROM (
SELECT id, id AS display_id, 103 AS enterprise_id FROM (
SELECT 'x' as id) AS nexted103) as table103Source
UNION ALL
SELECT 'x', 'x' AS display_id, 101 AS enterprise_id FROM
(
SELECT 'x') AS nested101
UNION ALL
SELECT 'x', 'x' AS display_id, 100 AS enterprise_id FROM
(
SELECT 'x') AS nested100) as tableFrom1stSelect
WHERE enterprise_id = 100
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: