Bug 1515761 – PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator

Bugzilla will be upgraded to version 5.0. The upgrade date is tentatively scheduled for 2 December 2018, pending final testing and feedback.

Bug 1515761 - PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator [NEEDINFO]

Summary:	PrestoDB translator - NULL values are not allowed on the probe side of SemiJo...

Status:	CLOSED NOTABUG

Aliases:	None

Product:	JBoss Data Virtualization 6
Classification:	JBoss
Component:	Teiid, Documentation (Show other bugs)
Sub Component:
Version:	6.4.0
Hardware:	Unspecified Unspecified

Priority	high Severity high
Target Milestone:	GA
Target Release:	6.4.0
Assigned To:	Bara Ancincova
QA Contact:	Andrej Smigala
Docs Contact:

URL:
Whiteboard:
Keywords:

Depends On:
Blocks:
	Show dependency tree / graph

Reported:	2017-11-21 05:43 EST by Andrej Smigala
Modified:	2018-09-27 07:25 EDT (History)
CC List:	9 users (show)

See Also:
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 07:25:11 EDT
Type:	Bug
Regression:	---
Mount Type:	---
Documentation:	---
CRM:
Verified Versions:
Category:	---
oVirt Team:	---
RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---

Flags:	bancinco: needinfo? (asmigala)

Attachments	(Terms of Use)
Add an attachment (proposed patch, testcase, etc.)

External Trackers
Tracker	ID	Priority	Status	Summary	Last Updated
JBoss Issue Tracker	TEIID-4694	Major	Resolved	PrestoDB translator - NULL values not supported in SemiJoin	2018-10-02 02:45 EDT
JBoss Issue Tracker	TEIID-5167	Major	Closed	PrestoDB translator - NULL values are not allowed on the probe side of SemiJoin operator	2018-10-02 02:45 EDT

Groups: None (edit)

Description Andrej Smigala 2017-11-21 05:43:47 EST

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-22 22:51:14 EST

Added to release notes errata as a known issue.

Comment 6 Andrej Smigala 2018-02-01 03:26:02 EST

David, please dix the typo in the doctext "vbecause"

Comment 10 Debi Rieden 2018-09-27 07:25:11 EDT

I agree, we can close this as "NOTABUG".

Thank you

Note You need to log in before you can comment on or make changes to this bug.