[teiid-issues] [JBoss JIRA] (TEIID-5945) queries with SUM(big integer) throw NPE
Steven Hawkins (Jira)
issues at jboss.org
Wed Apr 29 16:19:09 EDT 2020
[ https://issues.redhat.com/browse/TEIID-5945?focusedWorklogId=12450913&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-12450913 ]
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.
--
This message was sent by Atlassian Jira
(v7.13.8#713008)
More information about the teiid-issues
mailing list