Details
-
Bug
-
Resolution: Won't Do
-
Major
-
None
-
8.12.5
-
None
Description
For columns, which contain some null values, a query like:
SELECT nullable_column FROM table_name WHERE nullable_column <> some_value
doesn't return null values.
Simple select works:
SELECT nullable_column FROM table_name
returns all rows regardless whether they are null or not.
IS NULL criteria in WHERE clause also work:
SELECT nullable_column FROM table_name WHERE nullable_column IS NULL
returns correct number of null values.