Fossil SCM

More test cases (based on the SQLite repository) for the merge-riser coalescing logic.

drh 2020-06-08 19:14 trunk
Commit a2930cc09184e4055985decde2458bb86084756b3a7464c0b7613e955abdad12
1 file changed +30
--- test/graph-test-2.md
+++ test/graph-test-2.md
@@ -38,5 +38,35 @@
3838
GROUP BY cid
3939
HAVING (cp>0 AND n>0) OR cp>3 OR n>2
4040
ORDER BY cnt
4141
);
4242
~~~~~
43
+
44
+Similar 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
+
57
+Generated by a very similar script:
58
+
59
+~~~~~
60
+SELECT 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
+~~~~~
4373
--- test/graph-test-2.md
+++ test/graph-test-2.md
@@ -38,5 +38,35 @@
38 GROUP BY cid
39 HAVING (cp>0 AND n>0) OR cp>3 OR n>2
40 ORDER BY cnt
41 );
42 ~~~~~
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
43
--- test/graph-test-2.md
+++ test/graph-test-2.md
@@ -38,5 +38,35 @@
38 GROUP BY cid
39 HAVING (cp>0 AND n>0) OR cp>3 OR n>2
40 ORDER BY cnt
41 );
42 ~~~~~
43
44 Similar 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
57 Generated by a very similar script:
58
59 ~~~~~
60 SELECT 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

Keyboard Shortcuts

Open search /
Next entry (timeline) j
Previous entry (timeline) k
Open focused entry Enter
Show this help ?
Toggle theme Top nav button