Lars Hofhansl created PHOENIX-6088:
--------------------------------------

             Summary: Local indexes are not updated in 5.1.x
                 Key: PHOENIX-6088
                 URL: https://issues.apache.org/jira/browse/PHOENIX-6088
             Project: Phoenix
          Issue Type: Bug
            Reporter: Lars Hofhansl


{code:java}
> create table test(pk1 integer not null primary key, v1 float, v2 float);
No rows affected (0.658 seconds)

> create local index l2 on test(v2);
No rows affected (10.881 seconds)

> upsert into test values(rand()*10000, rand(), rand());
1 row affected (0.01 seconds)
0: jdbc:phoenix:localhost> select count(*) from test;
+----------+
| COUNT(1) |
+----------+
| 0        |
+----------+

> select /*+ NO_INDEX */ count(*) from test;
+----------+
| COUNT(1) |
+----------+
| 1        |
+----------+
1 row selected (0.018 seconds)

> select v2 from test;
+----+
| V2 |
+----+
+----+
No rows selected (0.039 seconds)

> select /*+ NO_INDEX */ v2 from test;
+------------+
|     V2     |
+------------+
| 0.57341254 |
+------------+
1 row selected (0.046 seconds)

> drop index l2 on test;
No rows affected (0.295 seconds)

> select v2 from test;
+------------+
|     V2     |
+------------+
| 0.57341254 |
+------------+
1 row selected (0.032 seconds)

{code}
 

This is bad.



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

Reply via email to