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

Details

    Description

      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.

      Attachments

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: