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