[
https://issues.jboss.org/browse/TEIID-3858?page=com.atlassian.jira.plugin...
]
Steven Hawkins updated TEIID-3858:
----------------------------------
Description:
There is an array index out of bounds in rule merge virtual correct order by when there is
an unrelated sort over a query with a grouping:
select a from (SELECT intkey as a, stringkey as b FROM BQT1.SmallA group by intkey,
stringkey union all SELECT intkey as a, stringkey as b FROM BQT1.Smallb group by intkey,
stringkey) as v order by b
was:
There is an array index out of bounds in rule merge virtual correct order by when there is
an unrelated sort over a union:
select a from (SELECT intkey as a, stringkey as b FROM BQT1.SmallA group by intkey,
stringkey union all SELECT intkey as a, stringkey as b FROM BQT1.Smallb group by intkey,
stringkey) as v order by b
Summary: Planning error with unrelated sort columns and view removal (was:
Planning error with union and unrelated sort columns)
Planning error with unrelated sort columns and view removal
-----------------------------------------------------------
Key: TEIID-3858
URL:
https://issues.jboss.org/browse/TEIID-3858
Project: Teiid
Issue Type: Bug
Components: Query Engine
Affects Versions: 8.12
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Fix For: 8.13, 8.12.3
There is an array index out of bounds in rule merge virtual correct order by when there
is an unrelated sort over a query with a grouping:
select a from (SELECT intkey as a, stringkey as b FROM BQT1.SmallA group by intkey,
stringkey union all SELECT intkey as a, stringkey as b FROM BQT1.Smallb group by intkey,
stringkey) as v order by b
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)