Bob Kline comments

Repositories
Issues
Comments

Results 42 comments of


                                            Bob Kline

Fixed #36030 -- Avoid unnecessary CAST(... AS NUMERIC) for Value(Decimal) on SQLite.

> SQLite already preserves Decimal values without requiring an explicit `CAST(... AS NUMERIC)` I'm not sure that's true. With SQLite, dividing the integer 2 by Decimal("3.0") produces a result of...

Fixed #36030 -- Avoid unnecessary CAST(... AS NUMERIC) for Value(Decimal) on SQLite.

> For these literals, the cast is unnecessary ... It is true that casting to `NUMERIC` doesn't do what is needed for SQLite. However, for Decimal values, a cast _is_...