3 -- Reformat generated_coverage to be JSON arrays rather than simple comma-
6 -- This upgrade script is technically imperfect, but should do the right thing
7 -- in 99.9% of cases, and any mistakes will be self-healing as more serials
10 SELECT evergreen.upgrade_deps_block_check('0543', :eg_version); -- dbwells
12 UPDATE serial.basic_summary SET generated_coverage = '["' || regexp_replace(regexp_replace(generated_coverage, '"', E'\\"', 'g'), ', ', '","', 'g') || '"]' WHERE generated_coverage <> '';
14 UPDATE serial.supplement_summary SET generated_coverage = '["' || regexp_replace(regexp_replace(generated_coverage, '"', E'\\"', 'g'), ', ', '","', 'g') || '"]' WHERE generated_coverage <> '';
16 UPDATE serial.index_summary SET generated_coverage = '["' || regexp_replace(regexp_replace(generated_coverage, '"', E'\\"', 'g'), ', ', '","', 'g') || '"]' WHERE generated_coverage <> '';