[
https://issues.apache.org/jira/browse/PHOENIX-1875?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14532477#comment-14532477
]
Dumindu Buddhika edited comment on PHOENIX-1875 at 5/7/15 11:41 AM:
--------------------------------------------------------------------
As it seems there cannot be a case where only nMultipliesOVer255 changes.
Hm. In postgre, nulls are allowed in any type of array. So the null is just
appended/prepended as it is. In Phoenix if a null is upserted for a
non-primitive fixed width array it produces an exception. (For PDate type,
exception message says "Illegal data. DATE may not be null").
was (Author: dumindux):
Hm. In postgre, nulls are allowed in any type of array. So the null is just
appended/prepended as it is. In Phoenix if a null is upserted for a
non-primitive fixed width array it produces an exception. (For PDate type,
exception message says "Illegal data. DATE may not be null").
> implement ARRAY_PREPEND built in function
> -----------------------------------------
>
> Key: PHOENIX-1875
> URL: https://issues.apache.org/jira/browse/PHOENIX-1875
> Project: Phoenix
> Issue Type: Sub-task
> Reporter: Dumindu Buddhika
> Assignee: Dumindu Buddhika
> Attachments: PHOENIX-1875-v2.patch, PHOENIX-1875-v3.patch,
> PHOENIX-1875-v4.patch
>
>
> ARRAY_PREPEND(1, ARRAY[2, 3]) = ARRAY[1, 2, 3]
> ARRAY_PREPEND("a", ARRAY["b", "c"]) = ARRAY["a", "b", "c"]
> ARRAY_PREPEND(null, ARRAY["b", "c"]) = ARRAY[null, "b", "c"]
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
