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)
