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 Fix For: 11.1, 10.3.4, 11.0.2, 8.12.15.6_4 Attachments: count_plan.txt, count_plan_debug_log.txt, count_plan_text.txt, select_plan.txt, select_plan_debug_log.txt, select_plan_text.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