1# Graph Test Cases
2
3There are test cases for the merge-riser coalescing logic that
4was added on 2020-06-08.
5
6  *  [e19cfba5373369b](/info/e19cfba5373369b?diff=0)
7  *  [c779b6890464cae](/info/c779b6890464cae?diff=0)
8  *  [eed3946bd92a499](/info/eed3946bd92a499?diff=0)
9  *  [9e1fa626e47f147](/info/9e1fa626e47f147?diff=0)
10  *  [68bd2e7bedb8d05](/info/68bd2e7bedb8d05?diff=0)
11  *  [8ac66ef33b464d2](/info/8ac66ef33b464d2?diff=0)
12  *  [ef6979eac9abded](/info/ef6979eac9abded?diff=0)
13  *  [7766e689926c703](/info/7766e689926c703?diff=0)
14  *  [642f4dcfa24f1f9](/info/642f4dcfa24f1f9?diff=0)
15  *  [3ea66260b5555d2](/info/3ea66260b5555d2?diff=0)
16  *  [66ae70a54b20656](/info/66ae70a54b20656?diff=0)
17  *  [b0f2a0ac53926c9](/info/b0f2a0ac53926c9?diff=0)
18  *  [303e7af7c31866c](/info/303e7af7c31866c?diff=0)
19  *  [b31afcc2cab1dc4](/info/b31afcc2cab1dc4?diff=0)
20  *  [1a164e5fb76a46b](/info/1a164e5fb76a46b?diff=0)
21  *  [f325b2343e6a18f](/info/f325b2343e6a18f?diff=0)
22  *  [2d75e87b760c0a9](/info/2d75e87b760c0a9?diff=0)
23  *  [76442af7e13267b](/info/76442af7e13267b?diff=0)
24
25
26The list above was generated by the following script:
27
28~~~~~
29.mode list
30SELECT printf('  *  [%s](/info/%s?diff=0)', hash, hash) FROM (
31  SELECT count(*) AS cnt, sum(cherrypick=1) AS cp, sum(cherrypick=0) AS n,
32      (SELECT substr(uuid,1,15) FROM blob WHERE rid=cid) AS hash
33    FROM (
34      SELECT cid, 0 AS cherrypick FROM plink WHERE NOT isprim
35      UNION ALL
36      SELECT childid, 1 FROM cherrypick
37    )
38   GROUP BY cid
39   HAVING (cp>0 AND n>0) OR cp>3 OR n>2
40   ORDER BY cnt
41);
42~~~~~
43
44Similar links to the SQLite repository:
45
46  *  [7f72fc4f47445a2](https://sqlite.org/src/info/7f72fc4f47445a2?diff=0)
47  *  [db2935473eab91c](https://sqlite.org/src/info/db2935473eab91c?diff=0)
48  *  [a56506b9387a067](https://sqlite.org/src/info/a56506b9387a067?diff=0)
49  *  [d59567dda231e7f](https://sqlite.org/src/info/d59567dda231e7f?diff=0)
50  *  [2b750b0f74e5a11](https://sqlite.org/src/info/2b750b0f74e5a11?diff=0)
51  *  [c697d2f83c2d8ea](https://sqlite.org/src/info/c697d2f83c2d8ea?diff=0)
52  *  [b330c7ff6fd1230](https://sqlite.org/src/info/b330c7ff6fd1230?diff=0)
53  *  [746fcd2fd412ddc](https://sqlite.org/src/info/746fcd2fd412ddc?diff=0)
54  *  [71866b367f32b5a](https://sqlite.org/src/info/71866b367f32b5a?diff=0)
55  *  [05418b2a4a6e6a9](https://sqlite.org/src/info/05418b2a4a6e6a9?diff=0)
56
57Generated by a very similar script:
58
59~~~~~
60SELECT printf('  *  [%s](https://sqlite.org/src/info/%s?diff=0)', hash, hash) FROM (
61  SELECT count(*) AS cnt, sum(cherrypick=1) AS cp, sum(cherrypick=0) AS n,
62      (SELECT substr(uuid,1,15) FROM blob WHERE rid=cid) AS hash
63    FROM (
64      SELECT cid, 0 AS cherrypick FROM plink WHERE NOT isprim
65      UNION ALL
66      SELECT childid, 1 FROM cherrypick
67    )
68   GROUP BY cid
69   HAVING (cp>0 AND n>0) OR cp>2 OR n>2
70   ORDER BY cnt
71);
72~~~~~
73