Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1704

if where clause contains more than one equal condition on the same column, no rows are returned for the count query

XMLWordPrintable

      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.

              rhn-engineering-shawkins Steven Hawkins
              chaudharygaurav Gaurav Chaudhary (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Created:
                Updated:
                Resolved: