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

[Lars Hofhansl (Jira)]

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

Lars Hofhansl updated PHOENIX-6424:
---
Comment: was deleted

(was: The {{select y.v2 from test3 where x.v1 <> 'blah'}} case turns the y.v2 
reference into a {{ProjectedColumnExpression}} whereas the {{select y.* from 
test3 where x.v1 <> 'blah'}} turns it into a {{KeyValueColumnExpression}}.)

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

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

[Lars Hofhansl (Jira)]

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

Lars Hofhansl updated PHOENIX-6424:
---
Comment: was deleted

(was: The {{select y.* from test3}} also creates a 
{{ProjectedColumnExpression}} that seems to be the difference.)

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

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

[Lars Hofhansl (Jira)]

 [ 
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.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}

  was:
{code}
> create table test3(pk1 integer not null primary key, x.v1 varchar, 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.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)

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

[Lars Hofhansl (Jira)]

 [ 
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.v1 varchar, 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}

  was:
{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.v1 varchar, 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)

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

[Lars Hofhansl (Jira)]

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