SQLite: Check-in [b06bf3b3]

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview

Comment:	Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON.
Downloads:	Tarball \| ZIP archive \| SQL archive
Timelines:	family \| ancestors \| descendants \| both \| trunk
Files:	files \| file ages \| folders
SHA1:	b06bf3b3605a3c39cdfbb76c9a9f6b5202bb95ec
User & Date:	drh 2011-11-04 00:35:56

Context

2011-11-04
02:24		Use mkdir() and rmdir() rather than open() and unlink() to create the lock files with the unix-dotlock VFS. The change is backwards compatible and, we are told, works better on some network filesystems. (check-in: e2f08426 user: drh tags: trunk)
00:35		Enhance the shell so that the ".schema" command works with case insensitive LIKE patterns even with PRAGMA cache_sensitive_like=ON. (check-in: b06bf3b3 user: drh tags: trunk)
00:23		Make sure the INSERT INTO ... SELECT statement works correctly even when the destination table contains an INTEGER PRIMARY KEY ON CONFLICT... column. Ticket [676bc02b87176125]. (check-in: 6f9898db user: drh tags: trunk)

Changes

Hide Diffs Side-by-Side Diffs Ignore Whitespace Patch

Changes to src/shell.c.

  2081   2081         }else{
  2082   2082           zShellStatic = azArg[1];
  2083   2083           rc = sqlite3_exec(p->db,
  2084   2084             "SELECT sql FROM "
  2085   2085             "  (SELECT sql sql, type type, tbl_name tbl_name, name name"
  2086   2086             "     FROM sqlite_master UNION ALL"
  2087   2087             "   SELECT sql, type, tbl_name, name FROM sqlite_temp_master) "
  2088         -          "WHERE tbl_name LIKE shellstatic() AND type!='meta' AND sql NOTNULL "
         2088  +          "WHERE lower(tbl_name) LIKE shellstatic()"
         2089  +          "  AND type!='meta' AND sql NOTNULL "
  2089   2090             "ORDER BY substr(type,2,1), name",
  2090   2091             callback, &data, &zErrMsg);
  2091   2092           zShellStatic = 0;
  2092   2093         }
  2093   2094       }else{
  2094   2095         rc = sqlite3_exec(p->db,
  2095   2096            "SELECT sql FROM "