[ https://issues.apache.org/jira/browse/SPARK-36021?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17374978#comment-17374978 ]
Max Gekk commented on SPARK-36021: ---------------------------------- cc [~angerszhuuu] > Incorrect parsing of the start field in interval literals > --------------------------------------------------------- > > Key: SPARK-36021 > URL: https://issues.apache.org/jira/browse/SPARK-36021 > Project: Spark > Issue Type: Sub-task > Components: SQL > Affects Versions: 3.2.0 > Reporter: Max Gekk > Priority: Major > > The example below portraits the issue: > {code:sql} > spark-sql> select interval '123456:12' minute to second; > Error in query: > requirement failed: Interval string must match day-time format of > '^(?<sign>[+|-])?(?<minute>\d{1,2}):(?<second>(\d{1,2})(\.(\d{1,9}))?)$': > 123456:12, set spark.sql.legacy.fromDayTimeString.enabled to true to restore > the behavior before Spark 3.0.(line 1, pos 16) > == SQL == > select interval '123456:12' minute to second > ----------------^^^ > {code} > The start field can have more than 2 digits, actually. -- 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