Fossil SCM

Make sure Fossil is run with a version of SQLite that include the order-by-subquery optimization, to avoid a performance problem.

drh 2024-08-16 19:28 trunk
Commit 668fefe796fd5e2441c80d98dad5b637bc7a94f705794797c28512f4409421cc
2 files changed +1 -1 +2 -2
+1 -1
--- auto.def
+++ auto.def
@@ -36,11 +36,11 @@
3636
}
3737
3838
# Update the minimum required SQLite version number here, and also
3939
# in src/main.c near the sqlite3_libversion_number() call. Take care
4040
# that both places agree!
41
-define MINIMUM_SQLITE_VERSION "3.43.0"
41
+define MINIMUM_SQLITE_VERSION "3.46.0"
4242
4343
# This is useful for people wanting Fossil to use an external SQLite library
4444
# to compare the one they have against the minimum required
4545
if {[opt-bool print-minimum-sqlite-version]} {
4646
puts [get-define MINIMUM_SQLITE_VERSION]
4747
--- auto.def
+++ auto.def
@@ -36,11 +36,11 @@
36 }
37
38 # Update the minimum required SQLite version number here, and also
39 # in src/main.c near the sqlite3_libversion_number() call. Take care
40 # that both places agree!
41 define MINIMUM_SQLITE_VERSION "3.43.0"
42
43 # This is useful for people wanting Fossil to use an external SQLite library
44 # to compare the one they have against the minimum required
45 if {[opt-bool print-minimum-sqlite-version]} {
46 puts [get-define MINIMUM_SQLITE_VERSION]
47
--- auto.def
+++ auto.def
@@ -36,11 +36,11 @@
36 }
37
38 # Update the minimum required SQLite version number here, and also
39 # in src/main.c near the sqlite3_libversion_number() call. Take care
40 # that both places agree!
41 define MINIMUM_SQLITE_VERSION "3.46.0"
42
43 # This is useful for people wanting Fossil to use an external SQLite library
44 # to compare the one they have against the minimum required
45 if {[opt-bool print-minimum-sqlite-version]} {
46 puts [get-define MINIMUM_SQLITE_VERSION]
47
+2 -2
--- src/main.c
+++ src/main.c
@@ -726,12 +726,12 @@
726726
fossil_limit_memory(1);
727727
728728
/* When updating the minimum SQLite version, change the number here,
729729
** and also MINIMUM_SQLITE_VERSION value set in ../auto.def. Take
730730
** care that both places agree! */
731
- if( sqlite3_libversion_number()<3043000
732
- || strncmp(sqlite3_sourceid(),"2023-06-12",10)<0
731
+ if( sqlite3_libversion_number()<3046000
732
+ || strncmp(sqlite3_sourceid(),"2024-08-16",10)<0
733733
){
734734
fossil_panic("Unsuitable SQLite version %s, must be at least 3.43.0",
735735
sqlite3_libversion());
736736
}
737737
738738
--- src/main.c
+++ src/main.c
@@ -726,12 +726,12 @@
726 fossil_limit_memory(1);
727
728 /* When updating the minimum SQLite version, change the number here,
729 ** and also MINIMUM_SQLITE_VERSION value set in ../auto.def. Take
730 ** care that both places agree! */
731 if( sqlite3_libversion_number()<3043000
732 || strncmp(sqlite3_sourceid(),"2023-06-12",10)<0
733 ){
734 fossil_panic("Unsuitable SQLite version %s, must be at least 3.43.0",
735 sqlite3_libversion());
736 }
737
738
--- src/main.c
+++ src/main.c
@@ -726,12 +726,12 @@
726 fossil_limit_memory(1);
727
728 /* When updating the minimum SQLite version, change the number here,
729 ** and also MINIMUM_SQLITE_VERSION value set in ../auto.def. Take
730 ** care that both places agree! */
731 if( sqlite3_libversion_number()<3046000
732 || strncmp(sqlite3_sourceid(),"2024-08-16",10)<0
733 ){
734 fossil_panic("Unsuitable SQLite version %s, must be at least 3.43.0",
735 sqlite3_libversion());
736 }
737
738

Keyboard Shortcuts

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