[ https://issues.apache.org/jira/browse/SPARK-36639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17408339#comment-17408339 ]
Apache Spark commented on SPARK-36639: -------------------------------------- User 'sarutak' has created a pull request for this issue: https://github.com/apache/spark/pull/33895 > SQL sequence function with interval returns unexpected error in latest > versions > ------------------------------------------------------------------------------- > > Key: SPARK-36639 > URL: https://issues.apache.org/jira/browse/SPARK-36639 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 3.0.3, 3.1.2 > Reporter: Ignatiy Vdovichenko > Priority: Major > > For example this returns > {color:#FF0000}java.lang.ArrayIndexOutOfBoundsException: 1 {color} > {code:java} > select sequence( > date_trunc('month', '2021-08-30'), > date_trunc('month', '2021-08-15'), > - interval 1 month){code} > Another cases like - all ok > {code:java} > select sequence( > date_trunc('month', '2021-07-15'), > date_trunc('month', '2021-08-30'), > interval 1 month) as x > , sequence( > date_trunc('month', '2021-08-30'), > date_trunc('month', '2021-07-15'), > - interval 1 month) as y > , sequence( > date_trunc('month', '2021-08-15'), > date_trunc('month', '2021-08-30'), > interval 1 month) as z{code} > In version 3.0.0 this works -- This message was sent by Atlassian Jira (v8.3.4#803005) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org