embucket-labs
embucket-labs copied to clipboard
engine: Support Snowflake Float types
- 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 |
+---------------------------------------+