[SPARK-41219] Regression in IntegralDivide returning null instead of 0 - ASF JIRA

Attach files

Attach Screenshot

Voters

Watch issue

Watchers

Create sub-task

Link

Clone

Update Comment Author

Replace String in Comment

Update Comment Visibility

Delete Comments

XML

Word

Printable

JSON

Details

Type: Bug
Status: Resolved
Priority: Major
Resolution: Fixed
Affects Version/s: 3.4.0
Fix Version/s: 3.4.0
Component/s: SQL
Labels:
None

Description

There seems to be a regression in Spark 3.4 Integral Divide

scala> val df = Seq("0.5944910","0.3314242").toDF("a")
df: org.apache.spark.sql.DataFrame = [a: string]

scala> df.selectExpr("cast(a as decimal(7,7)) div 100").show
+---------------------------------+
|(CAST(a AS DECIMAL(7,7)) div 100)|
+---------------------------------+
|                             null|
|                             null|
+---------------------------------+

While in Spark 3.3.0

scala> val df = Seq("0.5944910","0.3314242").toDF("a")
df: org.apache.spark.sql.DataFrame = [a: string]

scala> df.selectExpr("cast(a as decimal(7,7)) div 100").show
+---------------------------------+
|(CAST(a AS DECIMAL(7,7)) div 100)|
+---------------------------------+
|                                0|
|                                0|
+---------------------------------+