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: JDBC Driver Affects Versions: 7.3 Reporter: Gaurav Chaudhary Assignee: Steven Hawkins 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. -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira