Bug 1515761 - PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator
Summary: PrestoDB translator - NULL values are not allowed on the probe side of SemiJo...
Keywords:
Status: CLOSED NOTABUG
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid, Documentation
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: GA
: 6.4.0
Assignee: Bara Ancincova
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-11-21 10:43 UTC by Andrej Smigala
Modified: 2023-09-14 04:12 UTC (History)
9 users (show)

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.
Clone Of:
Environment:
Last Closed: 2018-09-27 11:25:11 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-4694 0 Major Resolved PrestoDB translator - NULL values not supported in SemiJoin 2020-05-12 06:56:33 UTC
Red Hat Issue Tracker TEIID-5167 0 Major Closed PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator 2020-05-12 06:56:33 UTC

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
Note You need to log in before you can comment on or make changes to this bug.