Fossil SCM

Need to account for adjacent ranges to avoid bad data from db_column_text.

andybradford 2015-03-06 08:28 UTC multi-block-highlight
Commit 17b67a9b82e043dc3185ad7485561e496bfeba45
1 file changed +1 -1
+1 -1
--- src/info.c
+++ src/info.c
@@ -1746,11 +1746,11 @@
17461746
db_finalize(&q);
17471747
@ <pre>
17481748
while( z[0] ){
17491749
n++;
17501750
db_prepare(&q,
1751
- "SELECT min(iStart), iEnd FROM lnos"
1751
+ "SELECT min(iStart), max(iEnd) FROM lnos"
17521752
" WHERE iStart <= %d AND iEnd >= %d", n, n);
17531753
if( db_step(&q)==SQLITE_ROW ){
17541754
iStart = db_column_int(&q, 0);
17551755
iEnd = db_column_int(&q, 1);
17561756
}
17571757
--- src/info.c
+++ src/info.c
@@ -1746,11 +1746,11 @@
1746 db_finalize(&q);
1747 @ <pre>
1748 while( z[0] ){
1749 n++;
1750 db_prepare(&q,
1751 "SELECT min(iStart), iEnd FROM lnos"
1752 " WHERE iStart <= %d AND iEnd >= %d", n, n);
1753 if( db_step(&q)==SQLITE_ROW ){
1754 iStart = db_column_int(&q, 0);
1755 iEnd = db_column_int(&q, 1);
1756 }
1757
--- src/info.c
+++ src/info.c
@@ -1746,11 +1746,11 @@
1746 db_finalize(&q);
1747 @ <pre>
1748 while( z[0] ){
1749 n++;
1750 db_prepare(&q,
1751 "SELECT min(iStart), max(iEnd) FROM lnos"
1752 " WHERE iStart <= %d AND iEnd >= %d", n, n);
1753 if( db_step(&q)==SQLITE_ROW ){
1754 iStart = db_column_int(&q, 0);
1755 iEnd = db_column_int(&q, 1);
1756 }
1757

Keyboard Shortcuts

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