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%[email protected]%3E.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
