[teiid-issues] [JBoss JIRA] (TEIID-5945) queries with SUM(big integer) throw NPE

[Steven Hawkins (Jira)]

     [ https://issues.redhat.com/browse/TEIID-5945?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-5945:
----------------------------------
         Fix Version/s: 14.0
                        13.0.3
                        13.1.1
     Original Estimate: 4 hours
    Remaining Estimate: 4 hours
          Story Points: 0.5
                Sprint: DV Sprint 63
               Summary: queries with SUM(big integer) throw NPE  (was: queries with SUM(big integer) throw NPE (amazon athena))
              Priority: Critical  (was: Major)


> 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
>  Remaining Estimate: 4 hours
>
> 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)