[ 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)