Fossil SCM
Fix off-by-one in the computation of day-of-week names in the byday report.
Commit
d530589c3fd7766a15d4f6bdd1e628eeee31515f9f106f74e9c78e50625b0e75
Parent
c810af8dab8607e…
1 file changed
+1
-1
+1
-1
| --- src/statrep.c | ||
| +++ src/statrep.c | ||
| @@ -846,11 +846,11 @@ | ||
| 846 | 846 | db_multi_exec( |
| 847 | 847 | "CREATE TEMP TABLE daydata(dn,isodate,dow,n);\n" |
| 848 | 848 | "WITH RECURSIVE c(daynum, isodate, dow) AS (\n" |
| 849 | 849 | " VALUES(0,'%q-01-01',0+strftime('%%w','%q-01-01'))\n" |
| 850 | 850 | " UNION ALL\n" |
| 851 | - " SELECT daynum+1, date(isodate,'+1 day'), (dow+1)%%6\n" | |
| 851 | + " SELECT daynum+1, date(isodate,'+1 day'), (dow+1)%%7\n" | |
| 852 | 852 | " FROM c\n" |
| 853 | 853 | " WHERE isodate<%Q\n" |
| 854 | 854 | ")\n" |
| 855 | 855 | "INSERT INTO daydata(dn,isodate,dow,n)\n" |
| 856 | 856 | " SELECT c.daynum, c.isodate, c.dow, coalesce(x.n,0)\n" |
| 857 | 857 |
| --- src/statrep.c | |
| +++ src/statrep.c | |
| @@ -846,11 +846,11 @@ | |
| 846 | db_multi_exec( |
| 847 | "CREATE TEMP TABLE daydata(dn,isodate,dow,n);\n" |
| 848 | "WITH RECURSIVE c(daynum, isodate, dow) AS (\n" |
| 849 | " VALUES(0,'%q-01-01',0+strftime('%%w','%q-01-01'))\n" |
| 850 | " UNION ALL\n" |
| 851 | " SELECT daynum+1, date(isodate,'+1 day'), (dow+1)%%6\n" |
| 852 | " FROM c\n" |
| 853 | " WHERE isodate<%Q\n" |
| 854 | ")\n" |
| 855 | "INSERT INTO daydata(dn,isodate,dow,n)\n" |
| 856 | " SELECT c.daynum, c.isodate, c.dow, coalesce(x.n,0)\n" |
| 857 |
| --- src/statrep.c | |
| +++ src/statrep.c | |
| @@ -846,11 +846,11 @@ | |
| 846 | db_multi_exec( |
| 847 | "CREATE TEMP TABLE daydata(dn,isodate,dow,n);\n" |
| 848 | "WITH RECURSIVE c(daynum, isodate, dow) AS (\n" |
| 849 | " VALUES(0,'%q-01-01',0+strftime('%%w','%q-01-01'))\n" |
| 850 | " UNION ALL\n" |
| 851 | " SELECT daynum+1, date(isodate,'+1 day'), (dow+1)%%7\n" |
| 852 | " FROM c\n" |
| 853 | " WHERE isodate<%Q\n" |
| 854 | ")\n" |
| 855 | "INSERT INTO daydata(dn,isodate,dow,n)\n" |
| 856 | " SELECT c.daynum, c.isodate, c.dow, coalesce(x.n,0)\n" |
| 857 |