Renat Zhilkibaev created TEIID-3265:
---------------------------------------
Summary: Incorrect result if multiple aggregate functions used
Key: TEIID-3265
URL:
https://issues.jboss.org/browse/TEIID-3265
Project: Teiid
Issue Type: Bug
Components: Embedded
Affects Versions: 8.9
Reporter: Renat Zhilkibaev
Assignee: Steven Hawkins
When using multiple aggregate functions the value returned by the first one is used as a
result of the second one.
With data looking like this:
SYMBOL,PRICE
GE,10.45
GE,15.45
GE,20.45
and this query:
select symbol, max(price), min(price) from mytable group by symbol
result looks like this:
GE, 20.45,20.45
Note the last value is 20.45 which is not a correct value (10.45).
Attached is incorrect-result-if-multiple-aggregate-functions-used.tar.gz which is modified
(changed query and text table data) embedded quick start example.
To reproduce execute examples/embedded-portfolio/run.sh
--
This message was sent by Atlassian JIRA
(v6.3.11#6341)