makima/migrations/20260205200000_fix_decimal_to_float.sql


1
2
3
4
5
6
7
8
9
10
11

-- Fix type mismatches: DECIMAL -> DOUBLE PRECISION for f64 compatibility
-- DECIMAL/NUMERIC maps to rust_decimal::Decimal, not f64

ALTER TABLE chains
    ALTER COLUMN default_pass_threshold TYPE DOUBLE PRECISION;

ALTER TABLE contract_evaluations
    ALTER COLUMN overall_score TYPE DOUBLE PRECISION;

ALTER TABLE chain_contract_definitions
    ALTER COLUMN pass_threshold TYPE DOUBLE PRECISION;