[
https://issues.apache.org/jira/browse/HIVE-15792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15851180#comment-15851180
]
Nandakumar commented on HIVE-15792:
-----------------------------------
Following are the results from different databases for LPAD/PPAD with null
{{SELECT LPAD('x', 5, '')}}
||Database|| Output||
|Oracle | NULL |
| MySQL | NULL |
| Postgres | <value unmodified> |
> 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)
