[
https://issues.apache.org/jira/browse/PHOENIX-989?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14007352#comment-14007352
]
Jody Landreneau commented on PHOENIX-989:
-----------------------------------------
Hey [~ram_krish] I will check it out shortly. I started to write a test for you
based on what you had done testUpsertValuesWithNull in the ArrayIT file. I did
see it work with the 'a_double_array' but when I switched to setting null on
the a_string_array, that is where I could replicate the problem. So it sounds
like what you found for variable length arrays.
> problem setting column type of Array to null
> --------------------------------------------
>
> Key: PHOENIX-989
> URL: https://issues.apache.org/jira/browse/PHOENIX-989
> Project: Phoenix
> Issue Type: Bug
> Affects Versions: 3.0-Release
> Reporter: Jody Landreneau
> Assignee: ramkrishna.s.vasudevan
> Attachments: HBASE-989.patch, HBASE-989_1.patch, Phoenix-989_1.patch
>
>
> Phoenix throws error when setting null for an array column type.
> Example:
> CREATE TABLE regions (
> region_name VARCHAR NOT NULL,
> nullable_field VARCHAR,
> zips VARCHAR[]
> CONSTRAINT pk PRIMARY KEY (region_name));
> I can
> UPSERT INTO regions(region_name, nullable_field)
> VALUES('SF Bay Area', null)
> but not
> UPSERT INTO regions(region_name, nullable_field, zips)
> VALUES('SF Bay Area', 'one', null)
> I have the same issue attempting to use jdbc, when I call the
> PreparedStatement's
> setNull(int parameterIndex, int sqlType) and I set the sqlType to ARRAY.
> Seems that the error I get is
> java.lang.NullPointerException
> at org.apache.phoenix.schema.PDataType$27.isCoercibleTo(PDataType.java:3455)
> at
> org.apache.phoenix.compile.UpsertCompiler$3.execute(UpsertCompiler.java:695)
> at
> org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:226)
> at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:185)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:146)
> at
> org.apache.phoenix.jdbc.PhoenixPreparedStatement.execute(PhoenixPreparedStatement.java:151)
> The expectation is that I should be able to set array column types to null.
--
This message was sent by Atlassian JIRA
(v6.2#6252)
