[
https://issues.apache.org/jira/browse/HIVE-15792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15851800#comment-15851800
]
Thejas M Nair commented on HIVE-15792:
--------------------------------------
Thanks [~nandakumar131]
I think NULL is the better choice, that way we don't return unpadded data.
NULL makes sense with invalid input.
> Hive should raise SemanticException when LPAD/RPAD pad character's length is 0
> ------------------------------------------------------------------------------
>
> Key: HIVE-15792
> URL: https://issues.apache.org/jira/browse/HIVE-15792
> Project: Hive
> Issue Type: Improvement
> Reporter: Zoltan Chovan
> Assignee: Nandakumar
> Priority: Minor
>
> For example SELECT LPAD('A', 2, ''); will cause an infinite loop and the
> running query will hang without any error.
> It would be great if this could be prevented by checking the pad character's
> length and if it's 0 then throw a SemanticException.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)