[teiid-issues] [JBoss JIRA] (TEIID-3511) usage of BITAND function in exists statement results in duplicate rows
Bram Gadeyne (JIRA)
issues at jboss.org
Wed Jun 3 03:46:01 EDT 2015
Bram Gadeyne created TEIID-3511:
-----------------------------------
Summary: 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
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)
More information about the teiid-issues
mailing list