diff options
| author | drh <drh@noemail.net> | 2011-11-04 00:35:56 +0000 |
|---|---|---|
| committer | drh <drh@noemail.net> | 2011-11-04 00:35:56 +0000 |
| commit | 6ac7a58b144906b70f184c6731668c2b0a1dec3d (patch) | |
| tree | ffbefec31bed1df5bb048ea2d03e2fa792707ed5 /src/shell.c | |
| parent | e7224a011bd2ee28ceab126b6d867ba7963260e7 (diff) | |
| download | sqlite-6ac7a58b144906b70f184c6731668c2b0a1dec3d.tar.gz sqlite-6ac7a58b144906b70f184c6731668c2b0a1dec3d.zip | |
Enhance the shell so that the ".schema" command works with case insensitive
LIKE patterns even with PRAGMA cache_sensitive_like=ON.
FossilOrigin-Name: b06bf3b3605a3c39cdfbb76c9a9f6b5202bb95ec
Diffstat (limited to 'src/shell.c')
| -rw-r--r-- | src/shell.c | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/src/shell.c b/src/shell.c index 07623e52a..11da32aa8 100644 --- a/src/shell.c +++ b/src/shell.c @@ -2085,7 +2085,8 @@ static int do_meta_command(char *zLine, struct callback_data *p){ " (SELECT sql sql, type type, tbl_name tbl_name, name name" " FROM sqlite_master UNION ALL" " SELECT sql, type, tbl_name, name FROM sqlite_temp_master) " - "WHERE tbl_name LIKE shellstatic() AND type!='meta' AND sql NOTNULL " + "WHERE lower(tbl_name) LIKE shellstatic()" + " AND type!='meta' AND sql NOTNULL " "ORDER BY substr(type,2,1), name", callback, &data, &zErrMsg); zShellStatic = 0; |