phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alexBai (JIRA)" <j...@apache.org>
Subject [jira] [Created] (PHOENIX-4120) Can not get the records by select when the operator is "!=" and the specified column value is null
Date Thu, 24 Aug 2017 08:03:00 GMT
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)

Mime
View raw message