[ https://issues.apache.org/jira/browse/SPARK-10617?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14955486#comment-14955486 ]
Davies Liu commented on SPARK-10617: ------------------------------------ [~shao.lo] I still do not get it, if the add_months is right, then first query will become {code} select date_add(cast('2016-02-29' as date), 1) {code} It's different than the second one. Why the order of evaluation is wrong? > Leap year miscalculated in sql query > ------------------------------------ > > Key: SPARK-10617 > URL: https://issues.apache.org/jira/browse/SPARK-10617 > Project: Spark > Issue Type: Bug > Components: SQL > Affects Versions: 1.5.0, 1.5.1, 1.6.0 > Reporter: shao lo > > -- This is wrong...returns 2016-03-01 > select date_add(add_months(cast('2015-02-28' as date), 1 * 12), 1) > -- This is right...returns 2016-02-29 > select date_add(cast('2016-02-28' as date), 1) -- This message was sent by Atlassian JIRA (v6.3.4#6332) --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org For additional commands, e-mail: issues-h...@spark.apache.org