embucket-labs icon indicating copy to clipboard operation
embucket-labs copied to clipboard

engine: Support Snowflake Float types

Open DanCodedThis opened this issue 5 months ago • 0 comments

  • In #1362 we introduced a patch (fix) for #1361 (Number (Decimal128) was made a Float64 in DF losing digits).
  • The fix makes any DF Float type as Decimal type
  • Not critical, not desired however:
 > SELECT 1234567890.0123;
+---------------------------------------+
| Decimal128(Some(12345678900123),14,4) |
|---------------------------------------|
| 1234567890.0123                       |
+---------------------------------------+

 > SELECT 1234567890.0123::FLOAT;
+---------------------------------------+
| Decimal128(Some(12345678900123),14,4) |
|---------------------------------------|
| 1234567936.0                          |
+---------------------------------------+

 > SELECT 1234567890.0123::FLOAT64;
+---------------------------------------+
| Decimal128(Some(12345678900123),14,4) |
|---------------------------------------|
| 1234567890.0123                       |
+---------------------------------------+

DanCodedThis avatar Jul 17 '25 19:07 DanCodedThis