Fossil SCM
For the correct join order on timeline generation using a CROSS JOIN.
Commit
60b409322ade042535340df54f297c4e8118ff78
Parent
09681e17bb7cb60…
1 file changed
+1
-1
+1
-1
| --- src/timeline.c | ||
| +++ src/timeline.c | ||
| @@ -786,11 +786,11 @@ | ||
| 786 | 786 | @ WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid |
| 787 | 787 | @ AND tagxref.rid=blob.rid AND tagxref.tagtype>0) AS tags, |
| 788 | 788 | @ tagid AS tagid, |
| 789 | 789 | @ brief AS brief, |
| 790 | 790 | @ event.mtime AS mtime |
| 791 | - @ FROM event JOIN blob | |
| 791 | + @ FROM event CROSS JOIN blob | |
| 792 | 792 | @ WHERE blob.rid=event.objid |
| 793 | 793 | ; |
| 794 | 794 | if( zBase==0 ){ |
| 795 | 795 | zBase = mprintf(zBaseSql, TAG_BRANCH, TAG_BRANCH); |
| 796 | 796 | } |
| 797 | 797 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -786,11 +786,11 @@ | |
| 786 | @ WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid |
| 787 | @ AND tagxref.rid=blob.rid AND tagxref.tagtype>0) AS tags, |
| 788 | @ tagid AS tagid, |
| 789 | @ brief AS brief, |
| 790 | @ event.mtime AS mtime |
| 791 | @ FROM event JOIN blob |
| 792 | @ WHERE blob.rid=event.objid |
| 793 | ; |
| 794 | if( zBase==0 ){ |
| 795 | zBase = mprintf(zBaseSql, TAG_BRANCH, TAG_BRANCH); |
| 796 | } |
| 797 |
| --- src/timeline.c | |
| +++ src/timeline.c | |
| @@ -786,11 +786,11 @@ | |
| 786 | @ WHERE tagname GLOB 'sym-*' AND tag.tagid=tagxref.tagid |
| 787 | @ AND tagxref.rid=blob.rid AND tagxref.tagtype>0) AS tags, |
| 788 | @ tagid AS tagid, |
| 789 | @ brief AS brief, |
| 790 | @ event.mtime AS mtime |
| 791 | @ FROM event CROSS JOIN blob |
| 792 | @ WHERE blob.rid=event.objid |
| 793 | ; |
| 794 | if( zBase==0 ){ |
| 795 | zBase = mprintf(zBaseSql, TAG_BRANCH, TAG_BRANCH); |
| 796 | } |
| 797 |