]
Steven Hawkins logged work on TEIID-5945:
-----------------------------------------
Author: Steven Hawkins
Created on: 29/Apr/20 4:17 PM
Start Date: 29/Apr/20 4:16 PM
Worklog Time Spent: 4 hours
Work Description: It took a while to create a simple processor test case to
reproduce this.
Issue Time Tracking
-------------------
Remaining Estimate: 0 minutes (was: 4 hours)
Time Spent: 4 hours
Worklog Id: (was: 12450913)
queries with SUM(big integer) throw NPE
---------------------------------------
Key: TEIID-5945
URL:
https://issues.redhat.com/browse/TEIID-5945
Project: Teiid
Issue Type: Bug
Components: Query Engine
Reporter: Steven Hawkins
Assignee: Steven Hawkins
Priority: Critical
Fix For: 14.0, 13.0.3, 13.1.1
Original Estimate: 4 hours
Time Spent: 4 hours
Remaining Estimate: 0 minutes
Both queries:
{code:java}
SELECT A.INTKEY, A.BIGINTEGERVALUE, (SELECT SUM(B.BIGINTEGERVALUE) FROM bqt.SMALLA AS B
WHERE B.INTKEY = A.INTKEY) FROM bqt.SMALLA AS A;
SELECT INTKEY, BIGINTEGERVALUE FROM bqt.SMALLA AS A WHERE BIGINTEGERVALUE >= (SELECT
SUM(BIGINTEGERVALUE) FROM bqt.SMALLA AS B WHERE A.INTKEY = B.INTKEY);
{code}
throw NPE when they are run against amazon athena vdb.
The same queries return the right data when they are run against amazon athena directly.
Attached stacktrace points that the problem is in SUM(big integer).
A similar query with SUM(long) works fine.