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