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)