SQLite

All files named ”tool/schemalint.tcl”
Login

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

History for tool/schemalint.tcl

2017-05-04
14:02
Deleted: Remove the tool/schemalint.tcl script. And related Makefile entries. It is superseded by sqlite3_expert. (check-in: [269bf52e27] user: dan branch: schemalint, size: 0)
2016-01-22
14:44
[4969035670] part of check-in [44edc1aa3b] Fix handling of transitive constraints in schemalint.tcl. (check-in: [44edc1aa3b] user: dan branch: schemalint, size: 14666)
14:32
[7b94e303b0] part of check-in [d4e3776767] Update the schemalint.tcl script so that the argument to a -select option may be either an SQL statement or the name of a file containing an SQL statement (check-in: [d4e3776767] user: dan branch: schemalint, size: 14414)
2015-11-30
19:16
[045481a427] part of check-in [b8251065db] Add a rule to main.mk to build the schemalint.tcl script into an executable. Similar to the way the sqlite3_analyzer executable is built. (check-in: [b8251065db] user: dan branch: schemalint, size: 14168)
18:17
[2f44d08740] part of check-in [451e0fafbe] Fix the schemalint.tcl script to handle identifiers that require quoting. (check-in: [451e0fafbe] user: dan branch: schemalint, size: 13994)
2015-11-23
18:28
[ad61083d39] part of check-in [d3aa067c83] In the CREATE INDEX statements output by schemalint.tcl, avoid declaring an explicit collation sequence that is the same as the column's default. (check-in: [d3aa067c83] user: dan branch: schemalint, size: 11288)
17:10
[e49c9b25c8] part of check-in [b8f277c9b4] Fix ORDER BY handling in the schemalint.tcl script. Add internal self-tests to the same script. (check-in: [b8f277c9b4] user: dan branch: schemalint, size: 10751)
2015-11-20
20:55
[160fe2ed74] part of check-in [93bdf70e85] Add support for ORDER BY clauses to schemalint.tcl. (check-in: [93bdf70e85] user: dan branch: schemalint, size: 6725)
2015-11-11
18:08
Added: [2eb60e950e] part of check-in [c6fa01c28e] Add a hack to debug out a description of the WHERE clause of a SELECT (or other) statement. Use this in script tool/schemalint.tcl to automatically recommend indexes that might speed up specific queries. (check-in: [c6fa01c28e] user: dan branch: schemalint, size: 6475)