phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "alexBai (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (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:04:00 GMT

     [ https://issues.apache.org/jira/browse/PHOENIX-4120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

alexBai updated PHOENIX-4120:
-----------------------------
    Description: 

{code:java}
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   |
+-----+-------+------+
{code}


  was:
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   |
+-----+-------+------+


> 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
>              Labels: null-values
>
> {code:java}
> 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   |
> +-----+-------+------+
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Mime
View raw message