[teiid-issues] [JBoss JIRA] (TEIID-3511) usage of BITAND function in exists statement results in duplicate rows

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-3511?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13078380#comment-13078380 ] 

Steven Hawkins commented on TEIID-3511:
---------------------------------------

I haven't made too much progress yet on fully recreating this scenario.  Any possiblity of providing post execution query plans showing row counts and/or executing with fewer joins?

It does appear that the bad plan is affected by TEIID-3525 which has been addressed for 8.12.  That may not be the cause of the issue, but it is a minor simplification.  If needed we can also get that into 8.11.1.

> usage of BITAND function in exists statement results in duplicate rows
> ----------------------------------------------------------------------
>
>                 Key: TEIID-3511
>                 URL: https://issues.jboss.org/browse/TEIID-3511
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 8.9.1
>            Reporter: Bram Gadeyne
>            Assignee: Steven Hawkins
>         Attachments: debugplan_bitand.txt, debugplan_bitand_correct.txt, debugplan_nobitand.txt, debugplan_nobitand_correct.txt
>
>
> 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 *.



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)