FROM report_lines
JOIN reports ON reports.id = report_lines.report_id
JOIN market_configs ON reports.market_config_id = market_configs.id
- WHERE report_lines.payload::jsonb->'checkpoint' IS NOT NULL`,
+ WHERE report_lines.payload::jsonb->>'checkpoint' IS NOT NULL`,
`CREATE INDEX checkpoints_idx ON report_lines ((payload->>'checkpoint'))`,
},
Down: []string{"DROP VIEW view_balances", "DROP INDEX checkpoints_idx"},