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

[Gaurav Chaudhary (JIRA)]

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