]
RH Bugzilla Integration commented on TEIID-4316:
------------------------------------------------
Van Halbert <vhalbert(a)redhat.com> changed the Status of [bug
Accumulo translator: null values not returned for <> criteria
in WHERE clause
-----------------------------------------------------------------------------
Key: TEIID-4316
URL:
https://issues.jboss.org/browse/TEIID-4316
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.12.5
Reporter: Jan Stastny
Assignee: Ramesh Reddy
For columns, which contain some null values, a query like:
{code:sql}
SELECT nullable_column FROM table_name WHERE nullable_column <> some_value
{code}
doesn't return null values.
Simple select works:
{code:sql}
SELECT nullable_column FROM table_name
{code}
returns all rows regardless whether they are null or not.
IS NULL criteria in WHERE clause also work:
{code:sql}
SELECT nullable_column FROM table_name WHERE nullable_column IS NULL
{code}
returns correct number of null values.