[jira] [Updated] (HIVE-17077) Hive should raise StringIndexOutOfBoundsException when LPAD/RPAD len character's value is negative number
[ https://issues.apache.org/jira/browse/HIVE-17077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] ASF GitHub Bot updated HIVE-17077: -- Labels: pull-request-available (was: ) > Hive should raise StringIndexOutOfBoundsException when LPAD/RPAD len > character's value is negative number > - > > Key: HIVE-17077 > URL: https://issues.apache.org/jira/browse/HIVE-17077 > Project: Hive > Issue Type: Bug >Reporter: Lingang Deng >Assignee: Lingang Deng >Priority: Minor > Labels: pull-request-available > Time Spent: 10m > Remaining Estimate: 0h > > lpad(rpad) throw a exception when the second argument a negative number, as > follows, > {code:java} > hive> select lpad("hello", -1 ,"h"); > FAILED: StringIndexOutOfBoundsException String index out of range: -1 > hive> select rpad("hello", -1 ,"h"); > FAILED: StringIndexOutOfBoundsException String index out of range: -1 > {code} > Maybe we should return friendly result such as mysql. > {code:java} > mysql> select lpad("hello", -1 ,"h"); > +--+ > | lpad("hello", -1 ,"h") | > +--+ > | NULL | > +--+ > 1 row in set (0.00 sec) > mysql> select rpad("hello", -1 ,"h"); > +--+ > | rpad("hello", -1 ,"h") | > +--+ > | NULL | > +--+ > 1 row in set (0.00 sec) > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)
[jira] [Updated] (HIVE-17077) Hive should raise StringIndexOutOfBoundsException when LPAD/RPAD len character's value is negative number
[ https://issues.apache.org/jira/browse/HIVE-17077?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lingang Deng updated HIVE-17077: Summary: Hive should raise StringIndexOutOfBoundsException when LPAD/RPAD len character's value is negative number (was: lpad(rpad) should return a value but not throw a exception) > Hive should raise StringIndexOutOfBoundsException when LPAD/RPAD len > character's value is negative number > - > > Key: HIVE-17077 > URL: https://issues.apache.org/jira/browse/HIVE-17077 > Project: Hive > Issue Type: Bug >Reporter: Lingang Deng >Assignee: Lingang Deng >Priority: Minor > > lpad(rpad) throw a exception when the second argument a negative number, as > follows, > {code:java} > hive> select lpad("hello", -1 ,"h"); > FAILED: StringIndexOutOfBoundsException String index out of range: -1 > hive> select rpad("hello", -1 ,"h"); > FAILED: StringIndexOutOfBoundsException String index out of range: -1 > {code} > Maybe we should return friendly result such as mysql. > {code:java} > mysql> select lpad("hello", -1 ,"h"); > +--+ > | lpad("hello", -1 ,"h") | > +--+ > | NULL | > +--+ > 1 row in set (0.00 sec) > mysql> select rpad("hello", -1 ,"h"); > +--+ > | rpad("hello", -1 ,"h") | > +--+ > | NULL | > +--+ > 1 row in set (0.00 sec) > {code} -- This message was sent by Atlassian JIRA (v6.4.14#64029)