Lars Hofhansl created PHOENIX-6423: -------------------------------------- Summary: Mixed column families with uncovered local index columns causes an exception Key: PHOENIX-6423 URL: https://issues.apache.org/jira/browse/PHOENIX-6423 Project: Phoenix Issue Type: Bug Reporter: Lars Hofhansl
This one is obscure: {code} > create table test3(pk1 integer not null primary key, v1 float, y.v1 > float[10]); No rows affected (1.179 seconds) > create local index l4 on test3(v1); No rows affected (11.253 seconds) > upsert into test3 values (1,2,ARRAY[5,6]); 1 row affected (0.023 seconds) > select * from test3 where y.v1[2] < 6; Error: ERROR 203 (22005): Type mismatch. expected: FLOAT but was: FLOAT ARRAY at column: V1 (state=22005,code=203) org.apache.phoenix.schema.ArgumentTypeMismatchException: ERROR 203 (22005): Type mismatch. expected: FLOAT but was: FLOAT ARRAY at column: V1 at org.apache.phoenix.compile.ProjectionCompiler.coerceIfNecessary(ProjectionCompiler.java:339) at org.apache.phoenix.compile.ProjectionCompiler.projectAllIndexColumns(ProjectionCompiler.java:258) at org.apache.phoenix.compile.ProjectionCompiler.compile(ProjectionCompiler.java:393) at org.apache.phoenix.compile.QueryCompiler.compileSingleFlatQuery(QueryCompiler.java:757) at org.apache.phoenix.compile.QueryCompiler.compileSingleQuery(QueryCompiler.java:676) at org.apache.phoenix.compile.QueryCompiler.compileSelect(QueryCompiler.java:253) at org.apache.phoenix.compile.QueryCompiler.compile(QueryCompiler.java:178) at org.apache.phoenix.optimize.QueryOptimizer.addPlan(QueryOptimizer.java:347) at org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlansForSingleFlatQuery(QueryOptimizer.java:239) at org.apache.phoenix.optimize.QueryOptimizer.getApplicablePlans(QueryOptimizer.java:138) at org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:116) at org.apache.phoenix.optimize.QueryOptimizer.optimize(QueryOptimizer.java:102) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:313) at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:295) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:294) at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:287) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1930) {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)