Nick Hryhoriev created PHOENIX-2751: ---------------------------------------
Summary: Wrong filtering for VARCHAR with null Key: PHOENIX-2751 URL: https://issues.apache.org/jira/browse/PHOENIX-2751 Project: Phoenix Issue Type: Bug Affects Versions: 4.5.1 Reporter: Nick Hryhoriev I ve got table CREATE TABLE integration_tests.connector_test( cf1.date_full timestamp, cf1.date_empty timestamp, cf1.date_with_null timestamp, cf1.date_milliseconds bigint, cf1.date_milliseconds_empty bigint, cf1.date_milliseconds_with_null bigint, cf1.date_seconds bigint, cf1.date_seconds_empty bigint, cf1.date_seconds_with_null bigint, cf1.date_year bigint, cf2.date_year_with_null bigint, cf2.double_full DOUBLE, cf2.double_with_null DOUBLE, cf2.double_empty DOUBLE, cf2.integer_full bigint, cf3.integer_with_null bigint, cf3.integer_empty bigint, cf3.string_with_null varchar, cf3.string_empty varchar, cf3.string_full varchar, id bigint, CONSTRAINT pk PRIMARY KEY (id)) SALT_BUCKETS=3, STORE_NULLS=true, DEFAULT_COLUMN_FAMILY='cf4', COMPRESSION='GZ' where in with_null column 30% null values. When i run Select ds.double_full, ds.string_with_null from integration_tests.connector_test ds -> i ve got all my nulls. When i run Select ds.double_full, ds.string_with_null from integration_tests.connector_test ds where ds.string_with_null is NULL-> ive got empty result. is not NULL work well. and also i ve find issue in mail list that a really close to this one https://mail-archives.apache.org/mod_mbox/phoenix-user/201505.mbox/%3cd18383cd.7f6d%25a...@hortonworks.com%3E. -- This message was sent by Atlassian JIRA (v6.3.4#6332)