[jira] [Updated] (PHOENIX-6424) SELECT cf1.* FAILS with a WHERE clause including cf2.

["Lars Hofhansl (Jira)" <ji...@apache.org>]

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

Lars Hofhansl updated PHOENIX-6424:
-----------------------------------
    Description: 
{code}
> create table test3(pk1 integer not null primary key, x.v1varchar, y.v1 integer);
No rows affected (1.189 seconds)

> upsert into test3 values(1,'test',2);
1 row affected (0.02 seconds)

> select * from test3;
+-----+------+----+
| PK1 |  V1  | V1 |
+-----+------+----+
| 1   | test | 2  |
+-----+------+----+
1 row selected (0.026 seconds)

-- so far so good

> select y.* from test3 where x.v1 <> 'blah';
+------+
|  V1  |
+------+
| null |
+------+
1 row selected (0.037 seconds)

> select x.* from test3 where y.v1 = 2;
+----+
| V1 |
+----+
|    |
+----+
1 row selected (0.036 seconds)
{code}

> SELECT cf1.* FAILS with a WHERE clause including cf2.
> -----------------------------------------------------
>
>                 Key: PHOENIX-6424
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6424
>             Project: Phoenix
>          Issue Type: Bug
>    Affects Versions: 5.1.1
>            Reporter: Lars Hofhansl
>            Priority: Major
>
> {code}
> > create table test3(pk1 integer not null primary key, x.v1varchar, y.v1 integer);
> No rows affected (1.189 seconds)
> > upsert into test3 values(1,'test',2);
> 1 row affected (0.02 seconds)
> > select * from test3;
> +-----+------+----+
> | PK1 |  V1  | V1 |
> +-----+------+----+
> | 1   | test | 2  |
> +-----+------+----+
> 1 row selected (0.026 seconds)
> -- so far so good
> > select y.* from test3 where x.v1 <> 'blah';
> +------+
> |  V1  |
> +------+
> | null |
> +------+
> 1 row selected (0.037 seconds)
> > select x.* from test3 where y.v1 = 2;
> +----+
> | V1 |
> +----+
> |    |
> +----+
> 1 row selected (0.036 seconds)
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)