[teiid-issues] [JBoss JIRA] Resolved: (TEIID-1704) if where clause contains more than one equal condition on the same column, no rows are returned for the count query

if where clause contains more than one equal condition on the same column, no rows are returned for the count query ------------------------------------------------------------------------------------------------------------------- Key: TEIID-1704 URL: https://issues.jboss.org/browse/TEIID-1704 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 7.3 Reporter: Gaurav Chaudhary Assignee: Steven Hawkins Labels: count, query, where Fix For: 7.4.1, 7.5 SELECT count(*) FROM "table1" as Something WHERE (Something."column1" = 'gaurav' AND Something."column1" = 'chaudhary') does not return any row when this is fired through a prepared statement. #Table table does not have any value given in the where clause Though the query SELECT count(*) FROM "table1" as Something WHERE (Something."column1" = 'gaurav') works and returns a row with 0 as value. Though this is a minor issue but due to this, our search is failing if the user gives matching columns in the criteria.