[jira] [Created] (PHOENIX-2402) NPE when using UPSERT SELECT with a char array

["Julian Jaffe (JIRA)" <ji...@apache.org>]

Julian Jaffe created PHOENIX-2402:
-------------------------------------

             Summary: NPE when using UPSERT SELECT with a char array
                 Key: PHOENIX-2402
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2402
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.5.2
            Reporter: Julian Jaffe


A NPE is thrown when attempting to UPSERT SELECT with a char array:

{code:sql}
CREATE TABLE IF NOT EXISTS TEST.TEST("testInt" INTEGER, "testCharArray" CHAR(3)[] CONSTRAINT "test_test" PRIMARY KEY ("testInt")) DEFAULT_COLUMN_FAMILY='TT', SALT_BUCKETS=10;
No rows affected (1.631 seconds)
0: jdbc:phoenix:xxxxxx> UPSERT INTO TEST.TEST VALUES(5, ARRAY['aaa','bbb']);
1 row affected (0.164 seconds)
0: jdbc:phoenix:xxxxxx> SELECT * FROM TEST.TEST;
+------------------------------------------+---------------+
|                 testInt                  | testCharArray |
+------------------------------------------+---------------+
| 5                                        | ['aaa', 'bbb'] |
+------------------------------------------+---------------+
1 row selected (0.364 seconds)
0: jdbc:phoenix:xxxxxx> UPSERT INTO TEST.TEST("testInt", "testCharArray") SELECT "testInt", ARRAY['ccc'] FROM TEST.TEST WHERE "testInt" = 5;
Error: java.lang.NullPointerException (state=08000,code=101)
org.apache.phoenix.exception.PhoenixIOException: java.lang.NullPointerException
    at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108)
    at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:553)
    at org.apache.phoenix.iterate.RoundRobinResultIterator.getIterators(RoundRobinResultIterator.java:176)
    at org.apache.phoenix.iterate.RoundRobinResultIterator.next(RoundRobinResultIterator.java:91)
    at org.apache.phoenix.compile.UpsertCompiler$2.execute(UpsertCompiler.java:685)
    at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319)
    at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311)
    at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
    at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309)
    at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1432)
    at sqlline.Commands.execute(Commands.java:822)
    at sqlline.Commands.sql(Commands.java:732)
    at sqlline.SqlLine.dispatch(SqlLine.java:808)
    at sqlline.SqlLine.begin(SqlLine.java:681)
    at sqlline.SqlLine.start(SqlLine.java:398)
    at sqlline.SqlLine.main(SqlLine.java:292)
Caused by: java.util.concurrent.ExecutionException: java.lang.NullPointerException
    at java.util.concurrent.FutureTask.report(FutureTask.java:122)
    at java.util.concurrent.FutureTask.get(FutureTask.java:206)
    at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:549)
    ... 14 more
Caused by: java.lang.NullPointerException
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)