5 INSERT INTO config.db_patch_dependencies (db_patch, supersedes, deprecates)
7 ('AAAE', '{AAAD}', '{}'),
8 ('AAAF', '{}', '{AAAC,AAAB}');
10 -- AAAB is deprecated by AAAF
11 SELECT is(evergreen.upgrade_list_applied_deprecated('AAAB'), 'AAAF', 'deprecated');
13 -- AAAC is deprecated by AAAF
14 SELECT is(evergreen.upgrade_list_applied_deprecated('AAAC'), 'AAAF', 'deprecated');
16 -- AAAD is superseded by AAAE
17 SELECT is(evergreen.upgrade_list_applied_superseded('AAAD'), 'AAAE', 'superseded');
19 -- add some applied versions
20 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('AAAB', 'AAAA');
21 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('AAAC', 'AAAB');
22 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('AAAD', 'AAAC');
24 -- AAAE supersedes AAAD
26 (SELECT ARRAY_AGG(patch) FROM evergreen.upgrade_list_applied_supersedes('AAAE')),
30 -- AAAF deprecates AAAB, AAAC
32 ( SELECT ARRAY_AGG(patch)
34 -- sort the patches to match the expected output
36 FROM evergreen.upgrade_list_applied_deprecates('AAAF')