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

usage of BITAND function in exists statement results in duplicate rows

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Obsolete
    • Icon: Major Major
    • None
    • 8.9.1
    • None
    • None

      I've added the debug plan for the query without the BITAND function and with the BITAND function as an attachment.

      The version without the BITAND function returns 438 rows and the version with BITAND function returns 833 rows. I can see however that rows are duplicated in this second result. I've checked this by executing the version with BITAND statement with select *.

        1. debugplan_bitand_correct.txt
          141 kB
        2. debugplan_bitand.txt
          118 kB
        3. debugplan_nobitand_correct.txt
          118 kB
        4. debugplan_nobitand.txt
          118 kB

            rhn-engineering-shawkins Steven Hawkins
            gadeynebram Bram Gadeyne (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: