Fossil SCM
Changes to a timeline query to ensure the correct join order even if ANALYZE has not been run on the repository database.
Commit
85d960e205288ef8fb0fb9649b580e38bee37f93
Parent
db61a377adf53d1…
1 file changed
+2
-2
+2
-2
| --- src/timeline.c | ||
| +++ src/timeline.c | ||
| @@ -1232,17 +1232,17 @@ | ||
| 1232 | 1232 | ** branch to be included in the report. This related check-ins are |
| 1233 | 1233 | ** useful in helping to visualize what has happened on a quiescent |
| 1234 | 1234 | ** branch that is infrequently merged with a much more activate branch. |
| 1235 | 1235 | */ |
| 1236 | 1236 | blob_appendf(&sql, |
| 1237 | - " OR EXISTS(SELECT 1 FROM plink JOIN tagxref ON rid=cid" | |
| 1237 | + " OR EXISTS(SELECT 1 FROM plink CROSS JOIN tagxref ON rid=cid" | |
| 1238 | 1238 | " WHERE tagid=%d AND tagtype>0 AND pid=blob.rid)", |
| 1239 | 1239 | tagid |
| 1240 | 1240 | ); |
| 1241 | 1241 | if( P("mionly")==0 ){ |
| 1242 | 1242 | blob_appendf(&sql, |
| 1243 | - " OR EXISTS(SELECT 1 FROM plink JOIN tagxref ON rid=pid" | |
| 1243 | + " OR EXISTS(SELECT 1 FROM plink CROSS JOIN tagxref ON rid=pid" | |
| 1244 | 1244 | " WHERE tagid=%d AND tagtype>0 AND cid=blob.rid)", |
| 1245 | 1245 | tagid |
| 1246 | 1246 | ); |
| 1247 | 1247 | }else{ |
| 1248 | 1248 | url_add_parameter(&url, "mionly", "1"); |
| 1249 | 1249 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -1232,17 +1232,17 @@ | |
| 1232 | ** branch to be included in the report. This related check-ins are |
| 1233 | ** useful in helping to visualize what has happened on a quiescent |
| 1234 | ** branch that is infrequently merged with a much more activate branch. |
| 1235 | */ |
| 1236 | blob_appendf(&sql, |
| 1237 | " OR EXISTS(SELECT 1 FROM plink JOIN tagxref ON rid=cid" |
| 1238 | " WHERE tagid=%d AND tagtype>0 AND pid=blob.rid)", |
| 1239 | tagid |
| 1240 | ); |
| 1241 | if( P("mionly")==0 ){ |
| 1242 | blob_appendf(&sql, |
| 1243 | " OR EXISTS(SELECT 1 FROM plink JOIN tagxref ON rid=pid" |
| 1244 | " WHERE tagid=%d AND tagtype>0 AND cid=blob.rid)", |
| 1245 | tagid |
| 1246 | ); |
| 1247 | }else{ |
| 1248 | url_add_parameter(&url, "mionly", "1"); |
| 1249 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -1232,17 +1232,17 @@ | |
| 1232 | ** branch to be included in the report. This related check-ins are |
| 1233 | ** useful in helping to visualize what has happened on a quiescent |
| 1234 | ** branch that is infrequently merged with a much more activate branch. |
| 1235 | */ |
| 1236 | blob_appendf(&sql, |
| 1237 | " OR EXISTS(SELECT 1 FROM plink CROSS JOIN tagxref ON rid=cid" |
| 1238 | " WHERE tagid=%d AND tagtype>0 AND pid=blob.rid)", |
| 1239 | tagid |
| 1240 | ); |
| 1241 | if( P("mionly")==0 ){ |
| 1242 | blob_appendf(&sql, |
| 1243 | " OR EXISTS(SELECT 1 FROM plink CROSS JOIN tagxref ON rid=pid" |
| 1244 | " WHERE tagid=%d AND tagtype>0 AND cid=blob.rid)", |
| 1245 | tagid |
| 1246 | ); |
| 1247 | }else{ |
| 1248 | url_add_parameter(&url, "mionly", "1"); |
| 1249 |