oxide icon indicating copy to clipboard operation
oxide copied to clipboard

Updates with `$inc` for double values don't work

Open fcoury opened this issue 3 years ago • 0 comments

We get the following query:

UPDATE "db_test"."test_collection_1657995566780048000"
    SET _jsonb = _jsonb ||
        json_build_object('v', COALESCE(_jsonb->'v')::numeric + 10)::jsonb || json_build_object('z', COALESCE(_jsonb->'z')::numeric + -2)::jsonb
     WHERE (CASE WHEN (_jsonb->'one' ? '$f') THEN (_jsonb->'one'->>'$f')::numeric ELSE (_jsonb->'one')::numeric END) = '1'

When we need to append the ->'$f' to properly update float fields.

This probably also applies to regular field updates.

fcoury avatar Jul 16 '22 18:07 fcoury