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

    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.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                chaudharygaurav Gaurav Chaudhary
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: