alexBai created PHOENIX-4120:
--------------------------------
Summary: Can not get the records by select when the operator is
"!=" and the specified column value is null
Key: PHOENIX-4120
URL: https://issues.apache.org/jira/browse/PHOENIX-4120
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.8.0
Environment: phoenix-4.8.1-HBase-1.0-SNAPSHOT-server.jar
Reporter: alexBai
0: jdbc:phoenix:> create table alex ("id" BIGINT, "name" varchar(10), "age"
BIGINT, constraint pk primary key("id"));
2 rows affected (1.257 seconds)
0: jdbc:phoenix:> upsert into alex values(1, 'alex', 28);
1 row affected (0.071 seconds)
0: jdbc:phoenix:> upsert into alex values(2, null, 28);
1 row affected (0.012 seconds)
0: jdbc:phoenix:> select * from alex;
+-----+-------+------+
| id | name | age |
+-----+-------+------+
| 1 | alex | 28 |
| 2 | | 28 |
+-----+-------+------+
2 rows selected (0.063 seconds)
0: jdbc:phoenix:> select * from alex where "name"!='alex';
+-----+-------+------+
| id | name | age |
+-----+-------+------+
+-----+-------+------+
No rows selected (0.053 seconds)
0: jdbc:phoenix:> select * from alex where "name" is null;
+-----+-------+------+
| id | name | age |
+-----+-------+------+
| 2 | | 28 |
+-----+-------+------+
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
