Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1515761

Summary: PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: Teiid, DocumentationAssignee: Bara Ancincova <bancinco>
Status: CLOSED NOTABUG QA Contact: Andrej Smigala <asmigala>
Severity: high Docs Contact:
Priority: high    
Version: 6.4.0CC: asmigala, blafond, drieden, gjospin, jolee, jschatte, jstastny, thauser, vhalbert
Target Milestone: GA   
Target Release: 6.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
If you are using the PrestoDB translator and you attempt to run any query with criteria and subquery with the IN, ANY and ALL operators, you will encounter an exception. This is because they are currently unsupported in PrestoDB.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2018-09-27 11:25:11 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Andrej Smigala 2017-11-21 10:43:47 UTC 
When running queries containg a subquery such as

SELECT INTKEY, DOUBLENUM FROM BQT1.SMALLA WHERE DOUBLENUM <> ALL (SELECT DOUBLENUM FROM BQT1.SMALLA WHERE INTKEY = 40) 

An exception is thrown:

java.sql.SQLException: Query failed (#20171121_103829_00016_8zhqn): NULL values are not allowed on the probe side of SemiJoin operator. See the query plan for details.

See jira for more details.
Comment 3 David Le Sage 2017-11-23 03:51:14 UTC 
Added to release notes errata as a known issue.
Comment 6 Andrej Smigala 2018-02-01 08:26:02 UTC 
David, please dix the typo in the doctext "vbecause"
Comment 10 Debi Rieden 2018-09-27 11:25:11 UTC 
I agree, we can close this as "NOTABUG".

Thank you
Comment 11 Red Hat Bugzilla 2023-09-14 04:12:14 UTC 
The needinfo request[s] on this closed bug have been removed as they have been unresolved for 1000 days