hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Nandakumar (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-15792) Hive should raise SemanticException when LPAD/RPAD pad character's length is 0
Date Fri, 03 Feb 2017 07:26:51 GMT

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

Mime
View raw message