fix(function): auto cast int -> decimal -> float.

Dousir9 · Mar 4, 2023 · 6fc38e5 · 6fc38e5
1 parent 84e8ad3
commit 6fc38e5
Showing 1 changed file with 2 additions and 0 deletions.
diff --git a/src/query/expression/src/type_check.rs b/src/query/expression/src/type_check.rs
@@ -518,6 +518,8 @@ pub fn can_auto_cast_to(
         }
         (DataType::Number(n), DataType::Decimal(_)) if !n.is_float() => true,
         (DataType::Decimal(x), DataType::Decimal(y)) => x.precision() <= y.precision(),
+        (DataType::Decimal(_), DataType::Number(NumberDataType::Float32)) => true,
+        (DataType::Decimal(_), DataType::Number(NumberDataType::Float64)) => true,
         _ => false,
     }
 }