[jira] [Assigned] (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 reassigned PHOENIX-6424:
--------------------------------------

    Assignee: Lars Hofhansl

> 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
>            Assignee: Lars Hofhansl
>            Priority: Major
>
> {code}
> > create table test3(pk1 integer not null primary key, x.v1 varchar, y.v2 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  | V2 |
> +-----+------+----+
> | 1   | test | 2  |
> +-----+------+----+
> 1 row selected (0.026 seconds)
> -- so far so good
> > select y.* from test3 where x.v1 <> 'blah';
> +------+
> |  V2  |
> +------+
> | null |
> +------+
> 1 row selected (0.037 seconds)
> > select x.* from test3 where y.v2 = 2;
> +----+
> | V1 |
> +----+
> |    |
> +----+
> 1 row selected (0.036 seconds)
> {code}



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