[teiid-issues] [JBoss JIRA] (TEIID-5434) count(*) returns different nr of rows compared to normal select

[Bram Gadeyne (JIRA)]

Bram Gadeyne created TEIID-5434:
-----------------------------------

             Summary: count(*) returns different nr of rows compared to normal select
                 Key: TEIID-5434
                 URL: https://issues.jboss.org/browse/TEIID-5434
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 10.3.3
            Reporter: Bram Gadeyne
            Assignee: Steven Hawkins
            Priority: Critical
         Attachments: count_plan.txt, select_plan.txt

Normal select return 162175 rows:

{code:sql}
select pa.ICUSessionID,11074, obr.DateTime, obr.varvalue, true, 15001866
from tv_retrieve_observrec obr
join kd_matric.ExtrPatICUAdmissions epa on epa.PatientID = obr.admissionid
join kd_matric.PatICUAdmissions pa on pa.ICUSessionID = epa.ICUSessionID and pa.BatchID < 1152
where obr.VariableID = 15001866;
{code}

count query return a count of 11573

{code:sql}
select count(*)
from tv_retrieve_observrec obr
join kd_matric.ExtrPatICUAdmissions epa on epa.PatientID = obr.admissionid
join kd_matric.PatICUAdmissions pa on pa.ICUSessionID = epa.ICUSessionID and pa.BatchID < 1152
where obr.VariableID = 15001866;
{code}

This was detected on a snapshot release of 10.3.3





--
This message was sent by Atlassian JIRA
(v7.5.0#75005)