[ 
https://issues.apache.org/jira/browse/HIVE-15792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15850232#comment-15850232
 ] 

Thejas M Nair commented on HIVE-15792:
--------------------------------------

There are couple of options here. It would be better to follow the convention 
followed by some of the other databases, like  postgres and mysql with this 
regard. Can you take a look at what they do ?
Its cleaner to have this check in the UDF itself rather than in semantic 
analyzer.


> 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)

Reply via email to