diff options
| author | drh <> | 2023-04-22 22:32:19 +0000 |
|---|---|---|
| committer | drh <> | 2023-04-22 22:32:19 +0000 |
| commit | 223c6b48a9d68eb4fa6aa884fa78b60fce892495 (patch) | |
| tree | 6f6843901f2373d6cb603c5af5e9aa185daccd99 /src/analyze.c | |
| parent | 4d24eff8dc47b6e351c775ebc08df5a866534036 (diff) | |
| download | sqlite-223c6b48a9d68eb4fa6aa884fa78b60fce892495.tar.gz sqlite-223c6b48a9d68eb4fa6aa884fa78b60fce892495.zip | |
The sqlite_stat4.idx field is case insensitive. It should work even if
some entries use a different case than others. Fix for
[forum:/info/6c118daad0f1f5ef|forum post 6c118daad0f1f5ef].
FossilOrigin-Name: f097ca70b5b967d1aadebd74ac5020813e00b7c30cc543814dbf5f359d1328f1
Diffstat (limited to 'src/analyze.c')
| -rw-r--r-- | src/analyze.c | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/analyze.c b/src/analyze.c index 6e9d72464..bc1c5259c 100644 --- a/src/analyze.c +++ b/src/analyze.c @@ -1874,7 +1874,7 @@ static int loadStat4(sqlite3 *db, const char *zDb){ && IsOrdinaryTable(pStat4) ){ rc = loadStatTbl(db, - "SELECT idx,count(*) FROM %Q.sqlite_stat4 GROUP BY idx", + "SELECT idx,count(*) FROM %Q.sqlite_stat4 GROUP BY idx COLLATE nocase", "SELECT idx,neq,nlt,ndlt,sample FROM %Q.sqlite_stat4", zDb ); |