SQLite: All files named ”src/pragma.c”

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

History for src/pragma.c

2025-03-28
08:59		[d53aae3c33] part of check-in [648aca5b47] Second round of cygwin fixes: this makes the full "unix" vfs usable with Cygwin as well. Not all tests are working yet. WIP! (check-in: [648aca5b47] user: jan.nijtmans branch: cygwin-fixes, size: 109736)
2025-03-03
16:53		[22c184ba97] part of check-in [b51690e180] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [b51690e180] user: drh branch: reuse-schema, size: 110057)
15:57		[c6dbc66743] part of check-in [6baea938f0] Merge the latest trunk enhancements into the wal2 branch. (check-in: [6baea938f0] user: drh branch: wal2, size: 109787)
2025-02-25
20:55		[30b535d0a6] part of check-in [af928818a0] Approximately 50 typo fixes, spanning the whole tree, contributed via forum post 006c8fa165083ac3 and individually checked for correctness. Affects only code comments, docs, and a single line of debug output in a test app. (check-in: [af928818a0] user: stephan branch: trunk, size: 109740)
2025-02-20
12:34		[e5c01f582f] part of check-in [f24e4d7bc0] Experimental prototype for "PRAGMA loadall(TABLE_OR_INDEX)". (check-in: [f24e4d7bc0] user: drh branch: pragma-loadall, size: 111281)
2025-02-18
14:56		[7e85ce4240] part of check-in [b2bf063011] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [b2bf063011] user: drh branch: reuse-schema, size: 110057)
14:38		[0a26a652ae] part of check-in [bd46516595] Merge all the latest trunk enhancements into the wal2 branch. (check-in: [bd46516595] user: drh branch: wal2, size: 109787)
2025-02-13
14:47		[c7ada27223] part of check-in [c5190b0fd9] Ensure the counts of "deferred FK violations" and "deferred immediate FK violations" are kept separate when "PRAGMA defer_foreign_keys" is used. (check-in: [c5190b0fd9] user: dan branch: trunk, size: 109740)
2025-02-12
20:54		[409e35bf91] part of check-in [85c108eb0f] An attempt to allow the DEFAULT keyword in the VALUES clause of an INSERT. This check-in does not work right. (check-in: [85c108eb0f] user: drh branch: default-in-values, size: 109732)
2024-12-16
14:06		[19cd69233e] part of check-in [58563686eb] Merge all the latest trunk changes and enhancements into the reuse-schema branch. (check-in: [58563686eb] user: drh branch: reuse-schema, size: 110003)
2024-12-13
17:01		[b89eafcd76] part of check-in [be32067a2a] Merge all recent trunk enhancements and fixes into the wal2 branch. Addendum: This was part of an attempt to reduce divergence. I'm still trying to figure out the best way to do that. (check-in: [be32067a2a] user: drh branch: mistake, size: 109733)
2024-12-12
20:39		[464813bf39] part of check-in [3c25c69c93] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [3c25c69c93] user: drh branch: cf8f1552-commit-instr, size: 110389)
15:11		[ce1182217a] part of check-in [e8d7d68ba0] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [e8d7d68ba0] user: drh branch: trunk, size: 109686)
2024-12-07
23:24		[f5383fc9d3] part of check-in [d3ce95f7e0] Update the wal2 branch with the latest trunk enhancements and fixes. (check-in: [d3ce95f7e0] user: drh branch: wal2, size: 109732)
2024-12-06
18:35		[767accbbbe] part of check-in [8704034254] Add the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents errors in the compilation of the SQL from being sent to sqlite3_log(). (check-in: [8704034254] user: drh branch: trunk, size: 109685)
2024-11-18
15:30		[e4213941de] part of check-in [d19aeff609] Merge the latest trunk changes into the wal2 branch. (check-in: [d19aeff609] user: drh branch: wal2, size: 109665)
2024-10-30
14:24		[82fc31a123] part of check-in [67087fe433] Merge the readonly-ignore-wal-jrnl feature into a sub-branch of reuse-schema. (check-in: [67087fe433] user: drh branch: reuse-schema-ro-waljrnl, size: 109935)
2024-10-28
17:27		[a2ec3657a9] part of check-in [3a3f7bf430] Remove the never-used and never-documented and long-ago deprecated user-authentication feature option. [65884d4f81a4705b]. (check-in: [3a3f7bf430] user: drh branch: trunk, size: 109618)
2024-10-16
15:14		[71993e99ce] part of check-in [93f0febab4] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [93f0febab4] user: drh branch: reuse-schema, size: 110140)
15:03		[92daeda7ca] part of check-in [2e96c8bb7a] Merge the latest trunk enhancements into the wal2 branch. (check-in: [2e96c8bb7a] user: drh branch: wal2, size: 109870)
2024-10-10
14:31		[08472536cf] part of check-in [f29ff2f308] Add extra logging points to the code on this branch. (check-in: [f29ff2f308] user: dan branch: cf8f1552-commit-instr, size: 110388)
2024-10-08
15:08		[56663a75d5] part of check-in [cd6f585cad] Add logging to help analyze slow "PRAGMA cache_size = ?" statements. (check-in: [cd6f585cad] user: dan branch: cf8f1552-commit-instr, size: 110102)
2024-10-07
11:47		[cd613126f7] part of check-in [d218993be5] Fix an assert() failure in "PRAGMA integrity_check" that could occur when checking a corrupt database. (check-in: [d218993be5] user: dan branch: trunk, size: 109823)
2024-05-21
15:20		[cce8c7b088] part of check-in [97e0af8882] Merge the lates trunk enhancements into the reuse-schema branch. (check-in: [97e0af8882] user: drh branch: reuse-schema, size: 110090)
15:20		[d206a9a757] part of check-in [d4217d9f70] Merge the latest trunk enhancements into the wal2 branch. (check-in: [d4217d9f70] user: drh branch: wal2, size: 109820)
2024-05-07
17:58		[52bfbf6dfd] part of check-in [6838bf3ac1] Ensure successive scans of pragma virtual tables return consistent rowids. (check-in: [6838bf3ac1] user: dan branch: trunk, size: 109773)
2024-05-02
11:52		[d357a25276] part of check-in [b04e7a2347] Do not accept a string that looks like a number used as an argument to PRAGMA integrity_check as a number. Treat it as a table name that just happens to look like a number. (check-in: [b04e7a2347] user: drh branch: faster-create, size: 109753)
2024-04-15
14:59		[6dfd1f4876] part of check-in [a1ff415341] Merge version 3.45.3 patches into the reuse-schema-3.45 sub-branch. (check-in: [a1ff415341] user: drh branch: reuse-schema-3.45, size: 104632)
14:21		[b1f6266adb] part of check-in [2ccc018546] Merge all 3.45.3 changes into the wal2-3.45 branch. (check-in: [2ccc018546] user: drh branch: wal2-3.45, size: 104362)
2024-03-26
10:48		[6eb7e2f78d] part of check-in [e469b02205] Merge all recent trunk enhancements into the reuse-schema branch. (check-in: [e469b02205] user: drh branch: reuse-schema, size: 110067)
10:42		[3e9d4f35ab] part of check-in [c2139d8263] Merge all recent trunk enhancements into the wal2 branch. (check-in: [c2139d8263] user: drh branch: wal2, size: 109797)
2024-03-25
11:34		[f8f1845b42] part of check-in [b1259d4448] Use the SQLITE_CONSTRAINT return value from xBestIndex to prohibit bad query plans in the pragma virtual table. (check-in: [b1259d4448] user: drh branch: trunk, size: 109750)
2024-03-24
21:18		[a13593a09d] part of check-in [ec791413d5] Fix the xBestIndex method of the pragma virtual table so that it correctly gives a higher cost to plans where the schema hidden parameter is unconstrained. (check-in: [ec791413d5] user: drh branch: branch-3.45, size: 104315)
21:15		[ebcaeb9e56] part of check-in [d68fb8b5db] Fix the xBestIndex method of the pragma virtual table so that it correctly gives a higher cost to plans where the schema hidden parameter is unconstrained. (check-in: [d68fb8b5db] user: drh branch: branch-3.44, size: 104265)
21:10		[4629926f93] part of check-in [bc516ff520] Fix the xBestIndex method of the pragma virtual table so that it correctly gives a higher cost to plans where the schema hidden parameter is unconstrained. Fix for the problem reported by forum post 85b6a8b6705fb77a. (check-in: [bc516ff520] user: drh branch: trunk, size: 109833)
2024-03-13
17:55		[f3ab7e52c3] part of check-in [2b12da7234] Merge the latest trunk enhancements into the wal2 branch. (check-in: [2b12da7234] user: drh branch: wal2, size: 109791)
15:59		[e921676f6c] part of check-in [70ef3784f6] Merge the latest trunk enhancements into the reuse-schema branch. Fix the reuse-schema build of the CLI so that it works again. (check-in: [70ef3784f6] user: drh branch: reuse-schema, size: 110061)
2024-03-11
23:28		[5f4e01d592] part of check-in [e22e0e1e4e] Merge the latest branch-3.45 patches into the reuse-schema-3.45 subbranch. (check-in: [e22e0e1e4e] user: drh branch: reuse-schema-3.45, size: 104543)
23:23		[2719655cdd] part of check-in [f8cee91f5d] Merge the branch-3.45 patches into the wal2 branch. (check-in: [f8cee91f5d] user: drh branch: wal2-3.45, size: 104273)
2024-02-27
16:25		[e8221d6310] part of check-in [8c788fc4b2] Adjust a VdbeCoverage() macro in PRAGMA integrity_check to account for the fact that arguments to the OP_Eq opcode used are never NULL. (check-in: [8c788fc4b2] user: drh branch: wrong-branch, size: 109744)
15:33		[35d3d604e5] part of check-in [6d02fb233f] Remove unreachable branches from the PRAGMA integrity_check enhancement of [b736519d3d2e93c7]. (check-in: [6d02fb233f] user: drh branch: trunk, size: 109735)
11:03		[3b6ffa36e3] part of check-in [b736519d3d] Have "PRAGMA quick_check" compare the number of entries in tables and indexes. (check-in: [b736519d3d] user: dan branch: trunk, size: 109727)
2024-02-21
20:21		[65ec09bbe7] part of check-in [7e3c46eed1] Fix typo in comment. Fossil forum post cc20266bf2. (check-in: [7e3c46eed1] user: drh branch: trunk, size: 109384)
2024-02-20
15:38		[f5cb82c15b] part of check-in [27a2113d78] Fixes to comments associated with the recent PRAGMA optimize enhancements. No changes to code. (check-in: [27a2113d78] user: drh branch: trunk, size: 109383)
13:10		[f35ba8fb0b] part of check-in [5c26bf379e] Remove an unused variable from the merge in the previous check-in. (check-in: [5c26bf379e] user: drh branch: trunk, size: 109530)
12:14		[cc9ccfde12] part of check-in [6c5a0c8545] Another simplification of the PRAGMA optimize logic for improved coverage. (check-in: [6c5a0c8545] user: drh branch: better-pragma-optimize, size: 109706)
2024-02-19
23:58		[613d27816d] part of check-in [ed5afebc41] Minor fixes. (check-in: [ed5afebc41] user: drh branch: better-pragma-optimize, size: 109793)
20:47		[d0e7832bd9] part of check-in [91302d9b27] Fix a minor hiccup in the computation of the number of btrees to be scanned. (check-in: [91302d9b27] user: drh branch: better-pragma-optimize, size: 109781)
20:12		[280945eb4a] part of check-in [0cc93b19de] If there is no mention of a table in sqlite_stat1, use OP_Rewind to see if the table is empty prior to invoking ANALYZE. (check-in: [0cc93b19de] user: drh branch: better-pragma-optimize, size: 109800)
19:56		[c72ba9c8b3] part of check-in [636615358a] In PRAGMA optimize, scale back the analysis_limit when many different tables and indexes must be scanned. (check-in: [636615358a] user: drh branch: better-pragma-optimize, size: 109452)
16:22		[0bd3737acf] part of check-in [e147b18991] If a table has one or more rows and it has a partial index has zero rows, still make an entry in the sqlite_stat1 table for the partial index, so that we know that "PRAGMA optimize" does not need to redo the whole table. (check-in: [e147b18991] user: drh branch: better-pragma-optimize, size: 108721)
13:50		[9197331dd2] part of check-in [44ed7f4cd0] Simplifications to PRAGMA optimize to make it easier to use. It always tries to ANALYZE unanalyzed indexes. The 0x10000 flag just makes it check for size changes in all tables. (check-in: [44ed7f4cd0] user: drh branch: better-pragma-optimize, size: 108885)
13:06		[b877efa88e] part of check-in [4abd47b591] Change the 0x20000 bit (use analysis limit) to 0x10, meaning that this feature is on by default. The default analysis limit is changed to 2000 which is almost always sufficient for accurate analysis results. (check-in: [4abd47b591] user: drh branch: better-pragma-optimize, size: 107552)
2024-02-18
01:12		[c7ef49d333] part of check-in [d13b79eae6] Hold a transaction during PRAGMA optimize, for performance. (check-in: [d13b79eae6] user: drh branch: better-pragma-optimize, size: 106088)
2024-02-17
16:39		[c5b767e753] part of check-in [dd44970625] Add new MASK bits to PRAGMA optimize: 0x70000. (check-in: [dd44970625] user: drh branch: better-pragma-optimize, size: 105861)
01:12		[2a49dd92e9] part of check-in [40532ffba9] The PRAGMA optimize command invokes ANALYZE if a table shrinks by 25 times in addition to if it grows by 25 times. (check-in: [40532ffba9] user: drh branch: better-pragma-optimize, size: 104347)
2024-02-16
12:57		[24584cc928] part of check-in [b4790da5e0] Rename the TF_StatsUsed flag to TF_MaybeReanalyze, to more accurately reflect its usage. No logic changes. (check-in: [b4790da5e0] user: drh branch: trunk, size: 104231)
2024-02-13
18:44		[f86c9d7ab1] part of check-in [60dccb23b1] Fix a bug in PRAGMA integrity_check introduced by enhancement (8a) in release 3.42.0. (check-in: [60dccb23b1] user: drh branch: branch-3.45, size: 104227)
18:41		[b61a1a1801] part of check-in [460353dfff] Fix a bug in PRAGMA integrity_check introduced by enhancement (8a) in release 3.42.0 and first reported by forum post ee4f6fa5ab. (check-in: [460353dfff] user: drh branch: trunk, size: 104226)
2024-02-07
20:45		[017c04c842] part of check-in [7070924eeb] Fix an #endif (added in the wrong place by [8f4b1ceafe4a271b]) so that the build works with SQLITE_OMIT_VIRTUAL_TABLE. (check-in: [7070924eeb] user: drh branch: trunk, size: 104175)
2024-02-02
16:51		[cf46ab7d7d] part of check-in [cc294c041b] Have "PRAGMA quick_check" compare the number of entries in tables and indexes. (check-in: [cc294c041b] user: dan branch: quick-check-counts, size: 104519)
2024-02-01
14:57		[f9b6bb9a04] part of check-in [8f4b1ceafe] In PRAGMA integrity_check, defer running xIntegrity on virtual tables until after all ordinary tables have been checked. (check-in: [8f4b1ceafe] user: drh branch: trunk, size: 104176)
2024-01-01
14:13		[4b33fdfd01] part of check-in [4a8fc17365] Omit the uneven=N argument in sqlite_stat1 and replace it with var=N1,N2,... so that the variation in each column is reported separately. Omit the "slow" argument from sqlite_stat1, computing that flag internally. PRAGMA stats is enhanced with a new column "est" that shows the aiRowLogEst array for each index after it has been modified by "var=..." and also the "slow" flag. (check-in: [4a8fc17365] user: drh branch: enhanced-stat1, size: 104941)
2023-12-06
22:22		[1ed003095b] part of check-in [5c36819c42] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [5c36819c42] user: drh branch: reuse-schema, size: 104235)
21:11		[54dd8e18ef] part of check-in [457724e738] Merge the latest trunk enhancements into the wal2 branch. (check-in: [457724e738] user: drh branch: wal2, size: 103965)
2023-11-29
02:45		[b5b4cff830] part of check-in [cad269d5e2] The assertion change at check-in [7946c79567b0ccd3] is insufficient to fix the problem of a Table object being deleted out from under the OP_VCheck opcode. We need to reference count the Table, which is accomplished here. (check-in: [cad269d5e2] user: drh branch: trunk, size: 103918)
2023-10-30
23:05		[5cd56d02e3] part of check-in [28f9a55928] Merge the latest 3.44.0 release candidate changes into the reuse-schema branch. (check-in: [28f9a55928] user: drh branch: reuse-schema, size: 104205)
21:46		[087234c661] part of check-in [4f65ae2df0] Merge the latest 3.44.0 changes into wal2 branch. (check-in: [4f65ae2df0] user: drh branch: wal2, size: 103935)
2023-10-25
10:37		[b3b4ad9c02] part of check-in [bc8afa3f15] Enhance the new xIntegrity method of the sqlite3_module object with new parameters that provide the name of the table being checked and a flag to indicate a "quick_check". Based on feedback in forum post 965c0d02ea. (check-in: [bc8afa3f15] user: drh branch: trunk, size: 103888)
2023-10-23
19:27		[184e70831c] part of check-in [52262ac920] Merge the latest trunk enhancments into the reuse-schema branch. (check-in: [52262ac920] user: drh branch: reuse-schema, size: 104196)
16:00		[caa5cd189c] part of check-in [3a6479d3f9] Merge latest trunk changes into this branch. (check-in: [3a6479d3f9] user: dan branch: wal2, size: 103926)
11:34		[2c44dca04a] part of check-in [ab99eb2b6c] Add an SQLITE_OMIT_VIRTUALTABLE block around the new vtab code in "PRAGMA integrity_check". (check-in: [ab99eb2b6c] user: dan branch: trunk, size: 103879)
2023-10-21
19:51		[10dae0459c] part of check-in [cbea52e9ef] Check-in contains stray edit. (check-in: [cbea52e9ef] user: drh branch: mistake, size: 103839)
2023-10-20
19:06		[63b3af7288] part of check-in [5cb61c6788] Fix PRAGMA integrity_check so that it does not raise an error if the schema contains a CREATE VIRTUAL TABLE that does not have its module loaded. (check-in: [5cb61c6788] user: drh branch: trunk, size: 103791)
2023-10-13
12:57		[9f9b882862] part of check-in [2b574d9e7e] Actually prevent PRAGMA writable_schema=ON from being set in defensive mode, rather than just preventing it from functioning. (check-in: [2b574d9e7e] user: drh branch: trunk, size: 103675)
2023-10-12
20:51		[db6ce4f9d6] part of check-in [4a4eccb681] Make sure virtual tables have been connected before trying to invoke the xIntegrity method during PRAGMA integrity_check. (check-in: [4a4eccb681] user: drh branch: trunk, size: 103563)
2023-10-06
12:51		[48becc9b68] part of check-in [f3b3d712d6] Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: [f3b3d712d6] user: drh branch: trunk, size: 103512)
2023-09-06
16:22		[ea85fb64b9] part of check-in [f00fc16394] Fix unreachable branches. (check-in: [f00fc16394] user: drh branch: vtab-integrity-check, size: 103464)
12:52		[2e3540e0a7] part of check-in [17bede8cde] Add the xIntegrity method to the sqlite3_module object. Implement this method in RTREE, FTS3/4, and FTS5 so that "PRAGMA integrity_check" also verifies the correctness of shadow tables associated with those virtual tables. (check-in: [17bede8cde] user: drh branch: vtab-integrity-check, size: 103440)
2023-07-18
15:06		[76621ce5e9] part of check-in [c2fba6a632] Experimental (untested, non-working) changes that try reduce the number of reprepares generated by sqlite3_stmt_explain(). I think I see an easier way to do this now, so I'm parking this experiment on a branch to pursue the new idea. (check-in: [c2fba6a632] user: drh branch: sqlite3-stmt-explain-opt1, size: 102824)
2023-06-22
14:50		[5a36e02edd] part of check-in [905c6c9ddb] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [905c6c9ddb] user: drh branch: reuse-schema, size: 103138)
14:20		[3a7c0f8e06] part of check-in [80ac494f73] Merge the latest trunk enhancements into the wal2 branch. (check-in: [80ac494f73] user: drh branch: wal2, size: 102868)
2023-06-07
17:03		[37b8fb02d0] part of check-in [8c291d9994] Fix straggler misspellings and tidy the custom dictionary. Also include pickups from forum post c61fb09afd. (check-in: [8c291d9994] user: larrybr branch: spell-check, size: 102821)
08:40		[02c8e7b47e] part of check-in [26c1bb4bd9] Add a C-source spell-checking facility. make misspell (on Nix) (check-in: [26c1bb4bd9] user: larrybr branch: spell-check, size: 102822)
2023-05-02
21:26		[edf94a4517] part of check-in [d08fa7d4d2] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [d08fa7d4d2] user: drh branch: reuse-schema, size: 103190)
19:58		[450aab7bd0] part of check-in [0215dcc76d] Merge the latest trunk enhancements into the wal2 branch. (check-in: [0215dcc76d] user: drh branch: wal2, size: 102920)
2023-03-29
11:40		[6b4a5bf8f7] part of check-in [fbc27e18aa] Enhance PRAGMA integrity_check so that it can detect that a NOT NULL column contains a NaN value and report that as an error. (check-in: [fbc27e18aa] user: drh branch: branch-3.41, size: 102864)
11:36		[26ed2cfdc5] part of check-in [7638d9755d] Enhance PRAGMA integrity_check so that it can detect that a NOT NULL column contains a NaN value and report that as an error. dbsqlfuzz f144b642fe6f1a1c196f258ac6e60118a0cb59b2. (check-in: [7638d9755d] user: drh branch: trunk, size: 102873)
00:05		[2e3413d450] part of check-in [242cb36c3b] Modify the OP_IsType opcode so that it does not need to distinguish between NaN and other floating point values. Later: This branch causes an unnecessary slowdown of PRAGMA integrity_check. Check-in [7638d9755dc90fd3] does a better job of detecting when a NaN value occurs in a NOT NULL column. (check-in: [242cb36c3b] user: drh branch: istype-opcode-refactor, size: 102838)
2023-03-27
13:27		[acec1c96ea] part of check-in [a4b5f499d9] Do not allow constant factoring during PRAGMA integrity_check, since the constants might be stored in registers that are later reused for other purposes. (check-in: [a4b5f499d9] user: drh branch: branch-3.41, size: 102154)
13:24		[367652f537] part of check-in [0bba27b781] Do not allow constant factoring during PRAGMA integrity_check, since the constants might be stored in registers that are later reused for other purposes. dbsqlfuzz dc9ab26037cf5ef797d28cd1ae0855ade584216d. Problem discovered by a new assert() statement added in [6f8b97f31a4c8552]. (check-in: [0bba27b781] user: drh branch: trunk, size: 102163)
13:10		[a6f721ae2b] part of check-in [636f6fad8d] Improvements to register allocation, especially in the ANALYZE command. New assert() statements added to help verify that memory allocation is correct, and to help fuzzer find lingering errors. (check-in: [636f6fad8d] user: drh branch: branch-3.41, size: 102099)
2023-03-26
16:36		[20103b19d9] part of check-in [6f8b97f31a] Improvements to register allocation, especially in the ANALYZE command. New assert() statements added to help verify that memory allocation is correct, and to help fuzzer find lingering errors. (check-in: [6f8b97f31a] user: drh branch: trunk, size: 102108)
2023-03-10
00:59		[5db436bd36] part of check-in [af08bd3e6e] Merge the branch-3.41 patches into the reuse-schema branch. (check-in: [af08bd3e6e] user: drh branch: reuse-schema-3.41, size: 102465)
00:21		[b9dc405490] part of check-in [e67bfc76fa] Merge the latest 3.41 patches into a new branch called wal2-3.41. (check-in: [e67bfc76fa] user: drh branch: wal2-3.41, size: 102195)
2023-03-03
19:56		[c0c6e07354] part of check-in [77f559d264] Fix a vdbe-coverage macro added by [f418bdd627e84e7d]. (check-in: [77f559d264] user: drh branch: trunk, size: 102157)
18:35		[e698baae96] part of check-in [f418bdd627] Enhance PRAGMA integrity_check so that it can detect when there are extra bytes at the end of an index record, which might cause OP_IdxRowid to malfunction. dbsqlfuzz c1aa3986534d5feab8d21f28b3c1712df2ef358ba. Test case in TH3. (check-in: [f418bdd627] user: drh branch: trunk, size: 102148)
2023-02-07
15:29		[4cf2b8d691] part of check-in [4d21640c58] Merge latest trunk changes into this branch. (check-in: [4d21640c58] user: dan branch: reuse-schema, size: 101627)
2023-02-02
14:21		[bcd8519da8] part of check-in [c9b0180203] Merge trunk enhancements into this branch. (check-in: [c9b0180203] user: dan branch: wal2, size: 101357)
2023-01-28
17:37		[82d5090a35] part of check-in [a7530f8971] Fix a problem causing "PRAGMA quick_check" to return spurious corruption errors for a WITHOUT ROWID for which all columns are either virtual or part of the primary key, and for which the order of the columns in the primary key definition is different from the order in the table. (check-in: [a7530f8971] user: dan branch: trunk, size: 101310)
2023-01-12
19:43		[b55821d295] part of check-in [deb26d034b] Merge latest trunk changes, including fixes for RBU pass-through mode, with this branch. (check-in: [deb26d034b] user: dan branch: reuse-schema, size: 101284)
2023-01-04
15:18		[23e74aaa44] part of check-in [9302e4bfdc] Enhance PRAGMA integrity_check so that it verifies that the string values stored in indexes are byte-for-byte identical to the values in the table, and not just equivalent according to the collating sequence. dbsqlfuzz 686e2e205e0c0594d3fb524bea0c25e621d1a870. (check-in: [9302e4bfdc] user: drh branch: trunk, size: 100967)
2022-12-19
18:42		[717d6213e9] part of check-in [44dd01e315] Hack for special gettimeofday() instrumentation of "PRAGMA schema_version". (check-in: [44dd01e315] user: dan branch: schema-version-instr, size: 95701)
2022-11-14
13:41		[6e211923bc] part of check-in [886788b61e] Merge the 3.40.0 rc1 changes into the reuse-schema branch. (check-in: [886788b61e] user: drh branch: reuse-schema, size: 100352)
13:10		[f96c2f99bb] part of check-in [a5a610a650] Merge the 3.40.0 rc1 changes into the wal2 branch. (check-in: [a5a610a650] user: drh branch: wal2, size: 100082)
2022-11-12
17:17		[894c2621d3] part of check-in [1d81381e8f] Disable the ability to change the schema_version cookie when SQLITE_DBCONFIG_DEFENSIVE mode is enabled. This is a security enhancement inspired by the question in forum post 2b9cc3dae1f1e5f6. (check-in: [1d81381e8f] user: drh branch: trunk, size: 100035)
2022-11-05
15:31		[d39068c344] part of check-in [224eaf2622] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [224eaf2622] user: drh branch: reuse-schema, size: 100088)
2022-11-04
18:58		[49a34aba78] part of check-in [ca63a1bee1] Merge the latest trunk enhancements into the wal2 branch. (check-in: [ca63a1bee1] user: drh branch: wal2, size: 99818)
2022-10-13
12:47		[41430ca047] part of check-in [45f1715654] Proposed optimization to the IS NULL and NOT NULL operators that avoids loading the entire content of larges strings and BLOBs. Response to forum post 3c08d4715dc05b00. (check-in: [45f1715654] user: drh branch: isnull-opt, size: 99771)
2022-10-10
21:21		[444f596c9e] part of check-in [a140173102] Code clean-up for the integrity_check enhancement. (check-in: [a140173102] user: drh branch: integrity_check_datatypes, size: 99856)
19:38		[a0078de988] part of check-in [dbab9d52a8] Fix corner-case bugs in the new integrity_check logic. All tests pass now. (check-in: [dbab9d52a8] user: drh branch: integrity_check_datatypes, size: 99866)
18:25		[f9df5f90b2] part of check-in [8b1e7f0524] An attempt to enhance PRAGMA integrity check so that it does data type checking on non-STRICT tables. Specifically: (1) Columns with TEXT affinity should not contain numeric values, and (2) columns with numeric affinity should not contain text values that can be converted to numeric. (check-in: [8b1e7f0524] user: drh branch: integrity_check_datatypes, size: 99378)
2022-09-30
14:14		[3993e34659] part of check-in [b119a5e896] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [b119a5e896] user: drh branch: reuse-schema, size: 95900)
13:54		[c471a8752c] part of check-in [c22c7c8798] Merge recent trunk enhancements into the wal2 branch. (check-in: [c22c7c8798] user: drh branch: wal2, size: 95630)
2022-09-28
17:10		[7a66d429ac] part of check-in [cf0999d4f8] Prototype implementation of "PRAGMA reset_database". This pragma differs from SQLITE_DBCONFIG_RESET_DATABASE in that the pragma only works if the database is reasonably well-formed, whereas the dbconfig works regardless. (check-in: [cf0999d4f8] user: drh branch: reset-database, size: 95925)
2022-09-05
13:36		[395a1d0912] part of check-in [efd54164b0] Merge patches for version 3.39.3 into the reuse-schema-3.39 branch. (check-in: [efd54164b0] user: drh branch: reuse-schema-3.39, size: 94757)
2022-09-02
12:12		[404c0fe37b] part of check-in [34c6ec3989] Mutex protect access to the sqlite3_test_directory and sqlite3_data_directory global variables. See forum thread 719a11e1314d1c70. (check-in: [34c6ec3989] user: drh branch: branch-3.39, size: 94440)
00:36		[9bf7d8a2a9] part of check-in [5ee3515fbb] Experimental changes to put sqlite3_temp_directory behind a mutex. (check-in: [5ee3515fbb] user: drh branch: tempdir-mutex, size: 95583)
2022-08-22
16:30		[55b96a3dc6] part of check-in [9c05a48ee0] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [9c05a48ee0] user: drh branch: reuse-schema, size: 95450)
15:57		[06c5b9641c] part of check-in [0b7578bf3d] Merge all recent trunk enhancements into the wal2 branch. (check-in: [0b7578bf3d] user: drh branch: wal2, size: 95180)
2022-08-17
18:07		[b57a859a36] part of check-in [62f934bff4] Enhance the "PRAGMA integrity_check" statement so that it verifies the rows of a WITHOUT ROWID table are in the correct order. (check-in: [62f934bff4] user: drh branch: trunk, size: 95133)
17:14		[f857ee5dfd] part of check-in [a3b9c7a6c9] Minor code simplification in the code generator for PRAGMA integrity check. (check-in: [a3b9c7a6c9] user: drh branch: trunk, size: 93946)
2022-07-25
19:05		[6637d624c3] part of check-in [92ac01d41d] Small performance increase and size reduction by splitting out the sqlite3VdbeGetLastOp() from sqlite3VdbeGetOp(). (check-in: [92ac01d41d] user: drh branch: trunk, size: 93991)
2022-07-22
20:24		[d2612488c1] part of check-in [57beb700c0] Add experimental 'xShadowName2' method for virtual table modules. (check-in: [57beb700c0] user: mistachkin branch: xShadowName2, size: 94040)
2022-05-10
13:06		[d6ed27df2b] part of check-in [9f6d6e6135] Merge all recent trunk changes into the reuse-schema branch. (check-in: [9f6d6e6135] user: drh branch: reuse-schema, size: 94307)
12:39		[3aae3282d8] part of check-in [33d77fea40] Merge recent trunk enhancements into the wal2 branch. (check-in: [33d77fea40] user: drh branch: wal2, size: 94037)
2022-04-04
18:17		[d1aead03e8] part of check-in [328dc76657] Use unpacked keys for OP_Found in foreign key processing. (check-in: [328dc76657] user: drh branch: trunk, size: 93990)
2022-04-01
16:22		[a29c54aa52] part of check-in [6d976f90df] Avoid a harmless uninitialized variable warning in PRAGMA incremental_vacuum. (check-in: [6d976f90df] user: drh branch: trunk, size: 94092)
2022-03-12
15:21		[a94161232b] part of check-in [f3fa81963e] Merge the latest trunk changes into the reuse-schema branch. (check-in: [f3fa81963e] user: drh branch: reuse-schema, size: 94405)
15:04		[fbb5c65d33] part of check-in [bafaefc6ab] Merge the lates trunk enhancements into the wal2 branch. (check-in: [bafaefc6ab] user: drh branch: wal2, size: 94135)
2022-03-02
01:02		[9047ffb003] part of check-in [6497997aa8] Fix a harmless compiler warning. (check-in: [6497997aa8] user: drh branch: trunk, size: 94088)
2022-02-25
01:23		[a7323cd175] part of check-in [ad1be34828] Invoking SQLITE_TESTCTRL_INTERNAL_FUNCTIONS causes the flags field of the PRAGMA function_list to show all bits, including internal-use-only bits, rather than just the bits that are part of the API. (check-in: [ad1be34828] user: drh branch: trunk, size: 94080)
2022-01-25
16:28		[770a2ce231] part of check-in [6e4154d414] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [6e4154d414] user: drh branch: reuse-schema, size: 94389)
15:57		[cb52183ed4] part of check-in [84f737abd1] Merge the latest trunk changes into the wal2 branch. (check-in: [84f737abd1] user: drh branch: wal2, size: 94119)
2022-01-24
16:47		[7c024d690a] part of check-in [1f7fa46126] Remove many redundant checks for sqlite3.mallocFailed now that any OOM should cause Parse.nErr to be non-zero. (check-in: [1f7fa46126] user: drh branch: trunk, size: 94072)
2021-11-06
16:46		[cb0cc54e1a] part of check-in [700876b79c] Merge further changes from trunk into this branch. (check-in: [700876b79c] user: dan branch: wal2, size: 93959)
16:10		[f11aa5bb83] part of check-in [52667bce48] Merge changes from trunk into this branch. (check-in: [52667bce48] user: dan branch: wal2, size: 93876)
2021-11-05
23:32		[401df25173] part of check-in [ca09148e13] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [ca09148e13] user: drh branch: reuse-schema, size: 94229)
2021-11-04
14:04		[c536665ce8] part of check-in [9147390d98] Show the preferred schema table names in the output of "PRAGMA table_list". (check-in: [9147390d98] user: drh branch: trunk, size: 93912)
2021-11-03
11:43		[c5fc9c849b] part of check-in [5dff1f6673] Fix an issue in PRAGMA integrity_check associated reporting NULL values in a NOT NULL column of type ANY in a STRICT table. (check-in: [5dff1f6673] user: drh branch: trunk, size: 93858)
2021-10-29
14:04		[32eccbbc90] part of check-in [7623132efe] Merge the latest trunk enhancements into the reuse-schema branch. (check-in: [7623132efe] user: drh branch: reuse-schema, size: 94146)
2021-10-21
19:48		[fc4c772d25] part of check-in [f73b499e53] Fix the previous check-in so that it works with virtual tables that add new shadow tables the first time they are referenced. (check-in: [f73b499e53] user: drh branch: trunk, size: 93829)
17:01		[e98bdbaf4b] part of check-in [fb0ed8c55f] Fix the new "table_list" pragma so that it shows the correct number of columns for views and virtual tables even when the object has not been previously used. (check-in: [fb0ed8c55f] user: drh branch: trunk, size: 93360)
14:10		[3cd2e0f215] part of check-in [cd15fc3c08] Merge recent trunk enhancements into the reuse-schema branch (check-in: [cd15fc3c08] user: drh branch: reuse-schema, size: 93187)
14:01		[fdcc0d3350] part of check-in [7e2bc836f6] Merge recent trunk enhancements into the wal2 branch. (check-in: [7e2bc836f6] user: drh branch: wal2, size: 92917)
2021-10-14
17:30		[12760c6ae9] part of check-in [3a6887a543] Update requirement marks. No changes to code. (check-in: [3a6887a543] user: drh branch: trunk, size: 92870)
2021-10-11
15:21		[5a37120a6c] part of check-in [6189b7809d] Use the IsOrdinaryTable() macro, not a test of tnum, to distinguish tables from views and virtual tables. (check-in: [6189b7809d] user: drh branch: trunk, size: 92691)
2021-10-08
16:39		[8d029903aa] part of check-in [a51b305bd0] Add support for "PRAGMA writable_schema=RESET". (check-in: [a51b305bd0] user: drh branch: trunk, size: 92717)
2021-10-07
14:19		[a2458437f9] part of check-in [f85cb287c5] Fix an incorrect assert() on PRAGMA table_xinfo added by the previous check-in. (check-in: [f85cb287c5] user: drh branch: trunk, size: 92374)
13:40		[99feddb5e3] part of check-in [9af863f065] Protect all accesses to the FuncDef.u and Expr.u unions using nearby assert()s or branches. (check-in: [9af863f065] user: drh branch: trunk, size: 92341)
12:11		[e92c252997] part of check-in [50e08338ae] Protect every access to the Table.u union using a nearby assert() or branch. (check-in: [50e08338ae] user: drh branch: trunk, size: 92207)
2021-10-04
11:49		[a582bc58a7] part of check-in [64234c5c9a] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [64234c5c9a] user: drh branch: reuse-schema, size: 92502)
11:44		[70d3d477a3] part of check-in [127173e0ba] Merge recent trunk enhancements into the wal2 branch. (check-in: [127173e0ba] user: drh branch: wal2, size: 92232)
2021-09-21
17:26		[4a473feae3] part of check-in [2c0e7ae541] Add the "PRAGMA table_list" command with its corresponding eponymous table-valued function: "pragma_table_list". (check-in: [2c0e7ae541] user: drh branch: trunk, size: 92185)
2021-09-08
19:25		[2b31671ff0] part of check-in [57384fda8d] Fix PRAGMA integrity_check so that it does not try to enforce types on ANY columns in a STRICT table. (check-in: [57384fda8d] user: drh branch: trunk, size: 90742)
2021-08-19
16:29		[c482a8d529] part of check-in [4ee57fb588] Improved comments. Fewer opcodes for integrity_check on strict tables. (check-in: [4ee57fb588] user: drh branch: strict-tables, size: 90687)
02:58		[b6ba4aa11a] part of check-in [97c9248b3b] Enhance PRAGMA integrity_check so that it verifies the datatype of all columns in STRICT tables. (check-in: [97c9248b3b] user: drh branch: strict-tables, size: 90685)
2021-08-03
16:11		[0d91c5dd6c] part of check-in [d71adc3fd8] Merge recent trunk enhancements into the reuse-schema branch. (check-in: [d71adc3fd8] user: drh branch: reuse-schema, size: 89907)
2021-08-02
20:29		[f1d34e15bd] part of check-in [f615d7baa8] Merge recent trunk enhancements into the wal2 branch. (check-in: [f615d7baa8] user: drh branch: wal2, size: 89637)
18:03		[af0f437895] part of check-in [8b781dcaf6] Refactor field names in the Column object, zCnName and zCnColl, to make them unique and thus easier to find amid all the other code. (check-in: [8b781dcaf6] user: drh branch: trunk, size: 89590)
16:41		[4a510b24e5] part of check-in [bbb6759bcf] Refactor the Table object to reduce its memory footprint. (check-in: [bbb6759bcf] user: drh branch: trunk, size: 89582)
2021-07-31
20:30		[e8efa185aa] part of check-in [8646547e54] Refactor the way that DEFAULT expressions are stored on columns, in order to save memory in the common case where the column has no DEFAULT clause. (check-in: [8646547e54] user: drh branch: trunk, size: 89451)
2021-07-09
13:29		[0db242cc1f] part of check-in [0e968f9de3] Merge latest trunk changes into this branch. (check-in: [0e968f9de3] user: dan branch: reuse-schema, size: 89644)
2021-07-07
16:48		[9fe75aa29e] part of check-in [7072404ad0] Follow-up to [68db1ff9c44fa9c3]: The number of registers needed by PRAGMA foreign_key_check was increased too late for an assert() deep down inside of sqlite3ExprCode(). So move the size increase a little earlier. Forum post 79c9e4797d. (check-in: [7072404ad0] user: drh branch: trunk, size: 89327)
2021-07-03
02:55		[e74fbc64dc] part of check-in [68db1ff9c4] In the PRAGMA foreign_key_check, ensure that sufficient registers are allocated for the virtual machine, even if one or more foreign keys reuses the same column multiple times and has more columns than the table it is part of. Forum post a6b0c05277. (check-in: [68db1ff9c4] user: drh branch: trunk, size: 89311)
2021-05-10
13:28		[e9b9ea5ff0] part of check-in [905085a75d] Add new output columns to the "PRAGMA database_list" statement. (check-in: [905085a75d] user: drh branch: database-list-enhancement, size: 89809)
2021-03-11
19:42		[4577091a83] part of check-in [30f912d0b3] Merge latest trunk changes into this branch. (check-in: [30f912d0b3] user: dan branch: wal2, size: 89297)
10:55		[300dcb000f] part of check-in [ef8c6e06cb] Merge latest trunk changes into this branch. (check-in: [ef8c6e06cb] user: dan branch: reuse-schema, size: 89567)
2021-03-10
16:35		[eb42cb9bec] part of check-in [7b65fb9f7b] Do not confuse the constant SQLITE_MAX_ATTACHED with the maximum number of schemas. Add the new SQLITE_MAX_DB constant for the maximum number of schemas. Forum post a006d86f72. (check-in: [7b65fb9f7b] user: drh branch: trunk, size: 89250)
2020-11-26
18:08		[3c948d3ed7] part of check-in [cb1f6f18e7] Merge latest trunk changes into this branch. (check-in: [cb1f6f18e7] user: dan branch: wal2, size: 89303)
2020-11-18
21:15		[f134be99f5] part of check-in [6004de525d] Merge trunk changes into this branch. (check-in: [6004de525d] user: dan branch: reuse-schema, size: 89573)
2020-09-16
19:48		[6daaaecc26] part of check-in [9ea3039b53] Fix a pair of assert()s in "PRAGMA foreign_key_check" that might have given a false-positive following an OOM. (check-in: [9ea3039b53] user: drh branch: trunk, size: 89256)
2020-09-04
17:40		[f0a42518e6] part of check-in [ca8deb44c7] Update this branch with latest changes from trunk. (check-in: [ca8deb44c7] user: dan branch: reuse-schema, size: 89533)
2020-08-25
19:09		[5435b9fe17] part of check-in [ad195e3dd8] Add support for the sqlite3_txn_state() interface. (check-in: [ad195e3dd8] user: drh branch: trunk, size: 89216)
2020-08-11
14:55		[b4e8df9a29] part of check-in [b1a77b7ead] Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: [b1a77b7ead] user: drh branch: reuse-schema, size: 89512)
2020-07-31
16:01		[eedd779f8d] part of check-in [0c0d0a77bc] Merge latest trunk changes into this branch. (check-in: [0c0d0a77bc] user: dan branch: wal2, size: 89242)
2020-07-29
16:18		[bdeb6e311c] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 89066)
2020-07-23
09:14		[bdb600be93] part of check-in [b5443b47af] Merge support for partial integrity checks. (check-in: [b5443b47af] user: drh branch: larger-databases, size: 89195)
00:45		[d96ce48697] part of check-in [65dd321432] Add the ability to do a PRAGMA integrity_check (or quick_check) on a single table by specifying the table name as the argument. (check-in: [65dd321432] user: drh branch: trunk, size: 89068)
2020-07-20
12:47		[13c627fb14] part of check-in [9cb7da9bdb] Initial changes to allow database up to 281TB in size. (check-in: [9cb7da9bdb] user: drh branch: larger-databases, size: 88237)
2020-07-04
20:29		[ae499b5ab8] part of check-in [6da77973ab] Fix the table_info pragma so that it always checks the schema version and reprepares, even if it is a no-op. (check-in: [6da77973ab] user: drh branch: trunk, size: 88110)
2020-07-03
12:15		[1c6a435c92] part of check-in [81bc4b65ae] Fix a problem with "PRAGMA foreign_key_check" where if a table in one schema appears to have foreign key constraints against another table in a different schema, the pragma will try to check the constraints even though they do not apply because they are in different schemas. (check-in: [81bc4b65ae] user: drh branch: trunk, size: 88170)
2020-07-01
16:19		[9085fc43b5] part of check-in [27d4a9a7b5] Ensure that the "PRAGMA schema_version" command causes the schema to be reparsed and reloaded. (check-in: [27d4a9a7b5] user: drh branch: trunk, size: 88174)
2020-05-18
17:18		[6ac2af3f44] part of check-in [16b1eca922] Merge latest trunk changes into this branch. (check-in: [16b1eca922] user: dan branch: wal2, size: 88200)
2020-05-16
19:00		[4937f87d57] part of check-in [5af4abe98c] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe98c] user: drh branch: reuse-schema, size: 88470)
2020-05-07
01:56		[1b0db48177] part of check-in [99749d4fd4] Fix the handling of reserve-bytes so that the maximum value of 255 can be used. (check-in: [99749d4fd4] user: drh branch: trunk, size: 88153)
2020-04-09
18:51		[c391258898] part of check-in [d6fda470fe] Merge recent trunk changes into the apple-osx branch. (check-in: [d6fda470fe] user: drh branch: apple-osx, size: 87728)
18:46		[ad117cc1a8] part of check-in [6fb870625c] Merge recent trunk enhancements into the wal2 branch. (check-in: [6fb870625c] user: drh branch: wal2, size: 87808)
2020-03-31
20:57		[85f763714b] part of check-in [a279b151c1] Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by ANALYZE when N is positive. Positive N also disables collecting stat4. (check-in: [a279b151c1] user: drh branch: approximate-analyze, size: 88154)
2020-03-17
13:41		[aff7b91cb3] part of check-in [a9bfa47aee] Remove the SQLITE_OMIT_BTREECOUNT option. Btree count is required. (check-in: [a9bfa47aee] user: drh branch: approximate-analyze, size: 87694)
2020-03-05
19:00		[0591391008] part of check-in [507f972e91] Merge trunk change [895bd20b29] into this branch. (Actually check-in date was 2020-05-18) (check-in: [507f972e91] user: dan branch: reuse-schema, size: 88078)
18:04		[5fd004b89c] part of check-in [895bd20b29] Report an error if the main, or any other, database encoding is modified by an external process (perhaps using the backup API) after the db has been opened. (check-in: [895bd20b29] user: dan branch: trunk, size: 87761)
16:30		[0bda432ffd] part of check-in [9d068e1ef0] Merge trunk enhancements into the reuse-schema branch. (Actual check-in date is 2020-05-18) (check-in: [9d068e1ef0] user: drh branch: reuse-schema, size: 88408)
16:13		[26a2d92028] part of check-in [4a5851893c] Change the sqlite3.pDfltColl (the default collating sequence for the database connection) so that it is the collating sequence appropriate for the database encoding, not the UTF8 collating sequence. This helps to ensure that the database encoding collation is always used, even for expressions that do not have an defined collating sequence. Ticket [1b8d7264567eb6fc]. (check-in: [4a5851893c] user: drh branch: trunk, size: 88091)
2020-02-27
15:20		[ca2c23dc79] part of check-in [3f5650aae6] Merge latest trunk changes into this branch. (check-in: [3f5650aae6] user: dan branch: reuse-schema, size: 88363)
2020-02-07
01:12		[4c8f3665cb] part of check-in [5a877221ce] Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option (check-in: [5a877221ce] user: drh branch: trunk, size: 88046)
2020-01-22
21:12		[ba150ef546] part of check-in [3bb267deb1] Merge version 3.31.0 (check-in: [3bb267deb1] user: drh branch: wal2, size: 89362)
20:36		[bd149305f0] part of check-in [0eae87ad11] Merge version 3.31.0 (check-in: [0eae87ad11] user: drh branch: apple-osx, size: 89282)
2020-01-20
15:32		[76563bedae] part of check-in [9c920bbad3] Merge recent fixes from trunk. (check-in: [9c920bbad3] user: drh branch: reuse-schema, size: 89632)
2020-01-15
16:20		[0d49d43b22] part of check-in [03b003c988] Do not allow the "PRAGMA encoding" statement to change the database encoding if TEMP content exists, or content in any other attached database. Formerly, encoding changes were allowed if just the main database file was empty. Ticket [a08879a4a476eea9]. (check-in: [03b003c988] user: drh branch: trunk, size: 89315)
14:26		[21e7a21370] part of check-in [f783917800] Merge all recent enhancements and fixes from trunk. (check-in: [f783917800] user: drh branch: reuse-schema, size: 89361)
14:11		[8b6013dbf6] part of check-in [35eae71a4d] Merge recent enhancements and fixes from trunk. (check-in: [35eae71a4d] user: drh branch: wal2, size: 89091)
12:49		[a2bc2d320c] part of check-in [dadedf41c7] Merge all recent enhancements and fixes from trunk into the apple-osx branch. (check-in: [dadedf41c7] user: drh branch: apple-osx, size: 89011)
2020-01-09
16:28		[9145cc0d73] part of check-in [318ff7720b] Fix a problem in the encoding display in the updated PRAGMA function_list. (check-in: [318ff7720b] user: drh branch: new-security-options, size: 89044)
2020-01-07
19:45		[f648521a5b] part of check-in [4c21373c21] Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: [4c21373c21] user: drh branch: new-security-options, size: 88951)
2020-01-04
19:58		[6e13c9a885] part of check-in [7a8d7ca726] Enhance PRAGMA function_list to show internal functions if the direct use of internal functions is enabled via the SQLITE_TESTCTRL_INTERNAL_FUNCTIONS test control. (check-in: [7a8d7ca726] user: drh branch: new-security-options, size: 88923)
01:43		[4f5df0df55] part of check-in [9ca906d24a] Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build. (check-in: [9ca906d24a] user: drh branch: new-security-options, size: 88520)
2019-12-09
15:52		[26e9ee5141] part of check-in [f3b39c71b8] Fix the NOT NULL verification logic in PRAGMA integrity_check so that it works for generated columns whose value is the result of a comparison operator. Ticket [bd8c280671ba44a7] CVE-2019-19646. (check-in: [f3b39c71b8] user: drh branch: trunk, size: 87666)
2019-11-14
23:08		[6bad15da51] part of check-in [ba27012d43] Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. (check-in: [ba27012d43] user: drh branch: branch-3.30, size: 87181)
17:46		[36c367a62a] part of check-in [33fd0c3abc] Fix a bug in the hard_heap_limit pragma so that it returns the new value of the hard_heap_limit, not the soft_heap_limit. Change SQLITE_MAX_MEMORY so that it works by setting the default hard_heap_limit value. (check-in: [33fd0c3abc] user: drh branch: hard-heap-limit, size: 87593)
15:21		[115fd36362] part of check-in [b8a631fd30] Merge recent enhancements from trunk. (check-in: [b8a631fd30] user: drh branch: hard-heap-limit, size: 87593)
2019-10-18
12:52		[986fdd27f1] part of check-in [e8426acb94] Claw back some performance from the sqlite3ExprGetColumnOfTable() routine. (check-in: [e8426acb94] user: drh branch: generated-columns, size: 86778)
2019-10-17
18:35		[a2cee4630b] part of check-in [4ad66af04a] In the Table object, change the nVCol field to nNVCol - the number of non-virtual columns, as that is the quantity that we need most. (check-in: [4ad66af04a] user: drh branch: generated-columns, size: 86788)
17:54		[c04340e810] part of check-in [fe7517bf4d] Some (but not all) INSERT and UPDATE statements now work for STORED columns. (check-in: [fe7517bf4d] user: drh branch: generated-columns, size: 86798)
14:21		[61abcb6d9f] part of check-in [7bfe0f679d] Bug fixes so that "make test" once against runs with no errors. (check-in: [7bfe0f679d] user: drh branch: generated-columns, size: 86756)
13:15		[7b4c404012] part of check-in [069351b85f] Fix the table_info and table_xinfo pragmas so that they work with virtual columns. Table_info omits virtual columns. Table_xinfo gives them a "hidden" flag of 2, and 3 for STORED columns. (check-in: [069351b85f] user: drh branch: generated-columns, size: 86729)
2019-10-16
19:31		[a9511633bc] part of check-in [7f9f90b1b8] Simple INSERT and SELECT operations working with VIRTUAL columns. (check-in: [7f9f90b1b8] user: drh branch: generated-columns, size: 86387)
12:18		[941aad9029] part of check-in [11d472c1df] Initial experimental code for generated column support. Non-functional. (check-in: [11d472c1df] user: drh branch: generated-columns, size: 86376)
2019-09-16
12:35		[f76a8ddaf4] part of check-in [27eb223690] Merge all recent trunk enhancements into the reuse-schema branch. (check-in: [27eb223690] user: drh branch: reuse-schema, size: 86683)
12:23		[3ab9816bab] part of check-in [da8bc97412] Merge recent trunk enhancements into the wal2 branch. (check-in: [da8bc97412] user: drh branch: wal2, size: 86413)
12:02		[2b67263250] part of check-in [a95191deab] Merge the latest changes from trunk into the apple-osx branch. (check-in: [a95191deab] user: drh branch: apple-osx, size: 86333)
2019-08-20
17:14		[e423ea296f] part of check-in [9b14eb7754] Bring the hard-heap-limit branch up-to-date with trunk. (check-in: [9b14eb7754] user: drh branch: hard-heap-limit, size: 87181)
2019-08-17
15:27		[b47bc7db02] part of check-in [9c4bca64fb] Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. (check-in: [9c4bca64fb] user: drh branch: trunk, size: 86366)
2019-07-26
20:54		[7f5272822e] part of check-in [7f1e4e4b99] Merge latest changes from trunk into this branch. (check-in: [7f1e4e4b99] user: dan branch: reuse-schema, size: 86677)
2019-07-17
11:01		[a42d4c6040] part of check-in [62274ff683] Enhance the "PRAGMA index_info()" and "PRAGMA index_xinfo()" statements so that they allow a WITHOUT ROWID table as their argument, and in that case show the structure of the underlying index used to implement the WITHOUT ROWID table. (check-in: [62274ff683] user: drh branch: wor-pk-dups, size: 86360)
2019-07-08
21:19		[6c1383a589] part of check-in [dcbcbc2a69] Merge all enhancements from trunk into the wal2 branch. (check-in: [dcbcbc2a69] user: drh branch: wal2, size: 86021)
20:59		[e0b0103810] part of check-in [de88ed862e] Merge recent enhancements from trunk into apple-osx. (check-in: [de88ed862e] user: drh branch: apple-osx, size: 85941)
2019-05-24
13:04		[fb7d6499e1] part of check-in [ff9f3e0951] Merge recent enhancements from trunk. (check-in: [ff9f3e0951] user: drh branch: reuse-schema, size: 86291)
2019-05-21
17:04		[925bcac0af] part of check-in [b3692c406f] Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. (check-in: [b3692c406f] user: drh branch: trunk, size: 85974)
2019-05-17
20:37		[0004625556] part of check-in [a0f5eb5c79] Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c]. (check-in: [a0f5eb5c79] user: drh branch: trunk, size: 85827)
2019-05-14
22:25		[5e8c63fd74] part of check-in [018f3199b9] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [018f3199b9] user: drh branch: reuse-schema, size: 85863)
22:02		[4b176da9a5] part of check-in [23ec34e4f6] Merge the latest trunk enhancements into the wal2 branch. (check-in: [23ec34e4f6] user: drh branch: wal2, size: 85593)
19:39		[02b341226f] part of check-in [40362d5181] Merge recent enhancements from trunk into apple-osx. (check-in: [40362d5181] user: drh branch: apple-osx, size: 85513)
2019-05-08
17:27		[2e9fbfcb23] part of check-in [eabe7f2d4f] Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to omit the case_sensitive_like pragma. This change, in combination with documentation changes, is the current solution to ticket [a340eef47b0cad5]. (check-in: [eabe7f2d4f] user: drh branch: trunk, size: 85546)
2019-04-25
18:15		[f3efbe2f56] part of check-in [b0ccef61a7] Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. (check-in: [b0ccef61a7] user: drh branch: hard-heap-limit, size: 86262)
2019-04-04
20:21		[130a325228] part of check-in [b40a4edceb] Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. (check-in: [b40a4edceb] user: drh branch: disable-vtab, size: 85485)
2019-03-20
20:02		[13e40651f9] part of check-in [c1be211c02] Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). (check-in: [c1be211c02] user: dan branch: reuse-schema, size: 85764)
2019-03-08
15:57		[4113abface] part of check-in [bf20d4ffcb] Merge the latest enhancements and fixes from trunk. (check-in: [bf20d4ffcb] user: drh branch: wal2, size: 85494)
2019-02-25
17:54		[bbe1ba3946] part of check-in [64f97530ad] Where possible, avoid loading all schemas into memory for PRAGMA statements. (check-in: [64f97530ad] user: dan branch: reuse-schema, size: 85763)
2019-02-18
18:16		[06a6b3f0f9] part of check-in [88cbf54eee] Ensure that creating temp schema items does not cause an OPEN_SHARABLE_SCHEMA connection to load all schemas into memory. (check-in: [88cbf54eee] user: dan branch: reuse-schema, size: 85459)
2019-02-07
18:49		[a6ad736f96] part of check-in [628291641f] Merge the offical 3.27.0 release. (check-in: [628291641f] user: drh branch: apple-osx, size: 85414)
2019-01-31
01:39		[af67dedaad] part of check-in [507c43537f] Improvements to "PRAGMA parser_trace=ON": Make it a flag pragma, and then use the flag to show the complete SQL text at the beginning of the parse. (check-in: [507c43537f] user: drh branch: trunk, size: 85447)
2019-01-17
15:47		[165ae00dad] part of check-in [475a179a27] Sync up with the latest enhancements on trunk. (check-in: [475a179a27] user: drh branch: apple-osx, size: 85650)
2019-01-02
16:15		[c1bfbee754] part of check-in [87ef68f917] Merge latest trunk changes into this branch. (check-in: [87ef68f917] user: dan branch: wal2, size: 85730)
2018-12-29
02:26		[20811b404b] part of check-in [4a0929ac76] A new implementation of sqlite3VdbeMakeLabel() is faster and makes fewer memory allocations by deferring memory allocation until sqlite3VdbeResolveLabel() is called, at which point the code generator has a better idea of how big the relocation table needs to be. The sqlite3VdbeMakeLabel() routine now takes a Parse* parameter instead of Vdbe*. (check-in: [4a0929ac76] user: drh branch: trunk, size: 85683)
2018-12-11
13:44		[3b23e9eb39] part of check-in [d8dd98a39e] Merge latest trunk changes into this branch. (check-in: [d8dd98a39e] user: dan branch: wal2, size: 85705)
2018-12-10
02:00		[221cb3384d] part of check-in [b1bbc718c7] Merge enhancements from trunk. (check-in: [b1bbc718c7] user: drh branch: apple-osx, size: 85625)
2018-12-06
17:06		[96ce7dce4d] part of check-in [53d3b169d8] When masking bits off of sqlite3.flags, make sure the mask is 64 bits in size so as not to accidentally mask of high-order bits. (check-in: [53d3b169d8] user: drh branch: trunk, size: 85658)
2018-12-01
20:14		[dbc7a8fa3e] part of check-in [7a44fa5a35] Sync this branch with the latest trunk. (check-in: [7a44fa5a35] user: dan branch: wal2, size: 85700)
2018-11-26
23:35		[cf832d9d6f] part of check-in [e8c20a88c1] Merge recent enhancements from trunk. (check-in: [e8c20a88c1] user: drh branch: apple-osx, size: 85620)
18:09		[4e056f0426] part of check-in [6e1330545e] Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. (check-in: [6e1330545e] user: drh branch: trunk, size: 85653)
2018-11-20
18:09		[a2eab23fbf] part of check-in [6982f52f57] Fix problems in pragma.c causing some PRAGMA statements to test the wrong schema-cookie before proceeding, or to try to open cursors on the wrong database ("PRAGMA foreign_key_check" only). (check-in: [6982f52f57] user: dan branch: trunk, size: 85593)
16:02		[f9b6a7f813] part of check-in [dfab7170ed] Consolidate the two sqlite3SchemaToIndex() routines. (check-in: [dfab7170ed] user: dan branch: reuse-schema1, size: 85324)
2018-11-19
20:41		[1c96a1f324] part of check-in [84be9220db] Fix a problem with virtual tables in shared schemas. (check-in: [84be9220db] user: dan branch: reuse-schema1, size: 85325)
2018-11-17
18:45		[705cffb85e] part of check-in [9fdd186897] Merge latest trunk changes into this branch. (check-in: [9fdd186897] user: dan branch: reuse-schema1, size: 85248)
2018-11-15
21:20		[c0fd52b168] part of check-in [31b6aee755] Fix some problems with the feature on this branch. Many problems remain. (check-in: [31b6aee755] user: dan branch: reuse-schema1, size: 85199)
2018-11-10
20:07		[7c3cb5bc8a] part of check-in [977fc44e65] Merge the read-only shadow table and defensive mode enhancments from trunk. (check-in: [977fc44e65] user: drh branch: apple-osx, size: 85212)
2018-11-05
23:01		[3a5f39517c] part of check-in [31942b3dd3] Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. (check-in: [31942b3dd3] user: drh branch: read-only-shadow, size: 85245)
2018-10-31
01:26		[ce45a21582] part of check-in [4b370c74ae] Merge fixes from trunk, especially rebustness against corrupt database files. (check-in: [4b370c74ae] user: drh branch: apple-osx, size: 85163)
2018-10-30
16:25		[0bb05b1788] part of check-in [4f9878107a] Split the SQLITE_WriteSchema flag in two flags, WriteSchema and SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems when trying to vacuum a corrupt database. With this change, the size of the flags field on sqlite3 must grow from 32 to 64 bytes. (check-in: [4f9878107a] user: drh branch: trunk, size: 85196)
2018-10-11
18:45		[f3a391cee6] part of check-in [d1008b0728] Fix issues with the new textkey pragma from the previous check-in. (check-in: [d1008b0728] user: drh branch: apple-osx, size: 85163)
18:41		[35efa85894] part of check-in [f03164d454] Add the textkey and textrekey pragmas. (check-in: [f03164d454] user: drh branch: trunk, size: 85196)
18:28		[ad16c987cb] part of check-in [f829099d25] Add the textkey and textrekey pragmas. (check-in: [f829099d25] user: drh branch: apple-osx, size: 85157)
2018-10-09
22:58		[d96a4668f3] part of check-in [1b60e7a981] Merge enhancements from trunk. (check-in: [1b60e7a981] user: drh branch: apple-osx, size: 84934)
22:50		[9e31ee952c] part of check-in [ddf6a54ef3] Merge changes for the 3.25.0 release. (check-in: [ddf6a54ef3] user: drh branch: apple-osx, size: 84828)
2018-10-01
18:28		[a656ff043a] part of check-in [cf1b76135f] Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. (check-in: [cf1b76135f] user: drh branch: pragma-table-vinfo, size: 84967)
17:15		[e49a1f19fb] part of check-in [6f606f9923] Bring the PRAGMA table_vinfo statement up to date with trunk. (check-in: [6f606f9923] user: drh branch: pragma-table-vinfo, size: 84881)
2018-09-29
19:38		[afd09f81b9] part of check-in [8bcd1a5956] Add the PRAGMA table_vinfo command (with an extra "v" before "info") that works like PRAGMA table_info (without the "v") except that it also shows hidden columns on virtual tables. (check-in: [8bcd1a5956] user: drh branch: pragma-table-vinfo, size: 85019)
2018-08-21
12:16		[79abc65c08] part of check-in [a04a0ea9e3] Fix various harmless warnings generated by static analysis tools. (check-in: [a04a0ea9e3] user: drh branch: trunk, size: 84861)
2018-08-03
23:04		[873b767f23] part of check-in [3f5f60cd75] Completely remove the column cache logic, which has been a persistent source of bugs for many years. Due to recent enhancements to the performance of the OP_Column opcode, removing the column cache actually makes speed-check.sh run faster. Removing the column cache also saves about 1,800 bytes of code space. (check-in: [3f5f60cd75] user: drh branch: omit-column-cache, size: 84877)
2018-06-06
19:48		[71c585f1d2] part of check-in [4b853f0205] Rearrange the order of some checks in the integrity_check pragma for a very slight performance gain. (check-in: [4b853f0205] user: drh branch: trunk, size: 84999)
2018-06-04
14:10		[fc2af8cd6c] part of check-in [95fbac39ba] Merge changes from trunk. (check-in: [95fbac39ba] user: drh branch: apple-osx, size: 84932)
2018-05-09
13:46		[c0d13c0e82] part of check-in [87f261f0cb] Make the internal dynamic string interface available to extensions using the new sqlite3_str object and its associated methods. This is mostly just a renaming of internal objects and methods to use external names, through there are a few small wrapper functions. (check-in: [87f261f0cb] user: drh branch: trunk, size: 84965)
2018-03-28
15:41		[5a4145c6ce] part of check-in [df52e89fff] Update this branch with latest trunk changes. (check-in: [df52e89fff] user: dan branch: server-process-edition, size: 85757)
2018-01-15
21:59		[a2a221f06f] part of check-in [c9d2ec51c8] Merge the enhancements associated with the first 3.22.0 beta. (check-in: [c9d2ec51c8] user: drh branch: apple-osx, size: 84930)
2017-11-28
02:47		[021613c97a] part of check-in [2494132a2b] Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. (check-in: [2494132a2b] user: drh branch: pragma-table-ipk, size: 85583)
2017-10-24
19:12		[b27a816273] part of check-in [13be3a441d] Merge all enhancements and fixes from the 3.21.0 release. (check-in: [13be3a441d] user: drh branch: apple-osx, size: 84889)
2017-10-11
20:26		[bea56df3ae] part of check-in [2719cf5c5b] Merge latest trunk changes with this branch. (check-in: [2719cf5c5b] user: dan branch: schemalint, size: 84963)
2017-10-04
20:57		[49a04b2ec3] part of check-in [e2fc5c814c] Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". (check-in: [e2fc5c814c] user: dan branch: wal2, size: 84969)
2017-09-22
20:18		[9f8839691c] part of check-in [8d2a1cca61] Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (check-in: [8d2a1cca61] user: drh branch: est_count_pragma, size: 88658)
2017-09-21
00:49		[d04725ac25] part of check-in [adc12c83dd] Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. (check-in: [adc12c83dd] user: drh branch: trunk, size: 84922)
2017-09-13
00:13		[88d99aa475] part of check-in [81f62e99f2] PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. (check-in: [81f62e99f2] user: drh branch: improved-integrity-check, size: 84922)
2017-09-10
01:06		[3799864604] part of check-in [99b9140c79] Simplifications to the PRAGMA integrity_check code generator. (check-in: [99b9140c79] user: drh branch: improved-integrity-check, size: 84603)
2017-09-09
20:38		[036a79afc7] part of check-in [8fa923caa1] Improved detection of malformed records by PRAGMA integrity_check. (check-in: [8fa923caa1] user: drh branch: improved-integrity-check, size: 84184)
06:10		[de5462b81e] part of check-in [6a0b9d9d4e] Merge trunk enhancements (check-in: [6a0b9d9d4e] user: drh branch: apple-osx, size: 84091)
2017-09-05
20:16		[faf5f9ec55] part of check-in [9e393a0edf] Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. (check-in: [9e393a0edf] user: dan branch: trunk, size: 84124)
2017-08-25
09:17		[a4e5028dfc] part of check-in [b79cc8dc88] Avoid returning duplicate rows in experimental pragmas "pragma_list", "module_list" and "function_list". (check-in: [b79cc8dc88] user: dan branch: trunk, size: 84056)
2017-07-24
19:43		[7c61991e6b] part of check-in [d0719ad757] Update this branch with latest changes from trunk. (check-in: [d0719ad757] user: dan branch: server-process-edition, size: 85044)
2017-07-20
13:17		[cd6aeda358] part of check-in [22eda0985e] Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. This fixes a problem with date/time functions in check-constraints. Add some test cases for date/time functions in index expressions and check constraints. (check-in: [22eda0985e] user: drh branch: index-on-date-func, size: 84250)
2017-07-19
19:48		[95672b7dc5] part of check-in [0a5e1c04d9] Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. (check-in: [0a5e1c04d9] user: drh branch: index-on-date-func, size: 84248)
18:54		[38032c10fe] part of check-in [be0df0a65f] Merge latest trunk changes with this branch. (check-in: [be0df0a65f] user: dan branch: server-process-edition, size: 85006)
2017-07-17
20:21		[d467106516] part of check-in [e181225dc7] Merge all the latest fixes and enhancements from trunk. (check-in: [e181225dc7] user: drh branch: apple-osx, size: 84071)
2017-07-15
20:48		[d42b6b5af3] part of check-in [62a86aa6c0] Add the "unionvtab" virtual table extension in ext/misc/unionvtab.c. (check-in: [62a86aa6c0] user: dan branch: union-vtab, size: 84212)
20:33		[2ae4088e9c] part of check-in [253945d480] Fix a register allocation problem in PRAGMA integrity_check that caused the same register to be used for two different purposes on the first ATTACHed database if the schema for the ATTACHed database was noticable more complex than the schema for the first database. Fix for ticket [a4e06e75a9ab61a1]. (check-in: [253945d480] user: drh branch: trunk, size: 84104)
20:25		[91f30204f9] part of check-in [687bd47871] Fix a missing \n at the end of a comment causing a line to be too long. No code changes. (check-in: [687bd47871] user: drh branch: trunk, size: 84064)
2017-07-13
21:06		[09fe2d45a9] part of check-in [dcc407972a] Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". (check-in: [dcc407972a] user: dan branch: server-process-edition, size: 83554)
2017-07-07
22:58		[8984481dfc] part of check-in [7f48f6ab2a] Merge in all the latest trunk enhancements. (check-in: [7f48f6ab2a] user: drh branch: apple-osx, size: 84032)
20:06		[54e64a9d65] part of check-in [38978ce65b] Add the "PRAGMA secure_delete=FAST" option, which overwrites most deleted content without increasing the amount of I/O. Deleted content might persist on the free page list, however. And extra CPU cycles are used for zeroing, of course. (check-in: [38978ce65b] user: drh branch: trunk, size: 84065)
17:43		[79ec7625d5] part of check-in [e0b6ae92ad] Add new PRAGMAs: "function_list", "module_list", and "pragma_list". All are enclosed within #ifdef SQLITE_INTROSPECTION_PRAGMAS. The compile-time option is not on ctime.c yet, since these are still experimental and one can always test "PRAGMA pragma_list" and see whether or not it returns an empty set. (check-in: [e0b6ae92ad] user: drh branch: trunk, size: 83973)
17:33		[072f2907f6] part of check-in [2f3c3781ef] Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. (check-in: [2f3c3781ef] user: drh branch: list-pragmas, size: 84315)
16:00		[3f9456edac] part of check-in [c46f0f076c] Enhance the sqlite3VdbeMultiLoad() interface to automatically generate the OP_ResultRow opcode on PRAGMA implementations, for a small reduction in the library footprint. (check-in: [c46f0f076c] user: drh branch: trunk, size: 82760)
15:43		[415a98ec60] part of check-in [e5f01d7fde] Add new pragmas: "function_list" and "module_list" (check-in: [e5f01d7fde] user: drh branch: list-pragmas, size: 84023)
2017-06-19
11:44		[b5483eba18] part of check-in [f1682f0faf] Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. (check-in: [f1682f0faf] user: drh branch: fast-secure-delete, size: 83194)
2017-04-24
16:14		[994ebf405c] part of check-in [031feebc94] Bring in all the latest enhancements from trunk. (check-in: [031feebc94] user: drh branch: apple-osx, size: 83069)
2017-04-20
17:35		[7fef375eda] part of check-in [b1533bc455] Merge latest trunk changes into this branch. (check-in: [b1533bc455] user: dan branch: schemalint, size: 83143)
2017-04-17
18:42		[2362670a9d] part of check-in [69f51f838a] Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (check-in: [69f51f838a] user: dan branch: trunk, size: 83102)
18:02		[943f71f762] part of check-in [690870bd7b] Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (check-in: [690870bd7b] user: dan branch: trunk, size: 83092)
2017-04-08
19:00		[150821702f] part of check-in [e051e8f21b] Merge latest trunk with this branch. (check-in: [e051e8f21b] user: dan branch: schemalint, size: 83036)
00:25		[28f232da1c] part of check-in [dd16439ea1] Merge the latest trunk changes. (check-in: [dd16439ea1] user: drh branch: apple-osx, size: 82962)
2017-04-04
19:58		[220474f113] part of check-in [e5bb7db51c] Fix a problem causing "PRAGMA integrity_check" to disable the xfer optimization for subsequent VACUUM operations on tables with one or more CHECK constraints. This could result in VACUUM producing slightly larger database files. (check-in: [e5bb7db51c] user: dan branch: trunk, size: 82995)
2017-03-31
11:20		[157c323aef] part of check-in [cb721d0b36] Merge latest trunk into this branch. (check-in: [cb721d0b36] user: dan branch: schemalint, size: 82911)
2017-03-30
20:26		[ae2407b542] part of check-in [ed28f15e05] Merge all changes from the 3.18.0 release. (check-in: [ed28f15e05] user: drh branch: apple-osx, size: 82837)
2017-03-17
03:21		[2b244434e7] part of check-in [019dd3d5ba] Fix a problem in the enhanced PRAGMA integrity_check where it verifies CHECK constraints: Do not be confused by the reuse of the Table.pCheck field by VIEWs with named columns. Problem discovered by OSS-Fuzz. (check-in: [019dd3d5ba] user: drh branch: trunk, size: 82870)
2017-03-15
14:04		[bfaa7e5cbf] part of check-in [bcf6bb08d8] Make "PRAGMA temp.synchronous=N" a no-op to ensure that the TEMP schema always has synchronous=OFF. This fixes an issue discovered by OSS-Fuzz. (check-in: [bcf6bb08d8] user: drh branch: trunk, size: 82797)
2017-03-09
16:32		[6d0dd6879a] part of check-in [5dc82a155d] Add the --recovery-mode option to the CLI ".dump" command. This involves enhancing the "PRAGMA reverse_unordered_selects" command to accept a "TOGGLE" option. Recovery mode used to be always on. Now it is opt-in. Not sure this is the correct approach. Also not sure if TOGGLE is a good feature to have on boolean PRAGMA statements. (check-in: [5dc82a155d] user: drh branch: dump-recovery, size: 82905)
2017-03-08
18:37		[69997bfa26] part of check-in [9b43917380] Merge recent enhancements from trunk, including the --preserve-rowids option to .dump and the .sha3sum commands of the CLI. (check-in: [9b43917380] user: drh branch: apple-osx, size: 82751)
2017-03-06
23:51		[b7bf4f1dd9] part of check-in [73019a8bba] Make the default MASK argument for "PRAGMA optimize" be 0xfffe, to allow for future expansion of up to 14 new default-on optimizations. (check-in: [73019a8bba] user: drh branch: trunk, size: 82784)
20:44		[d4aef42083] part of check-in [ec529bf11b] Fix a typo in a comment. No changes to code. (check-in: [ec529bf11b] user: drh branch: trunk, size: 82688)
20:00		[5e1dfb5a07] part of check-in [1650c3f468] Merge all pending 3.18 enhancements from trunk. (check-in: [1650c3f468] user: drh branch: apple-osx, size: 82660)
2017-03-02
14:17		[75fdb05838] part of check-in [a35388eef4] Add an optional bitmask of allowed optimizations on the "PRAGMA optimize" command. The 0x01 bit is Debug Mode. (check-in: [a35388eef4] user: drh branch: auto-analyze, size: 82693)
2017-02-23
00:58		[4b32b014bb] part of check-in [188300a337] Do a single OP_Expire at the very end of "PRAGMA optimize", and omit the OP_Expire on ANALYZE commands invoked by the pragma. (check-in: [188300a337] user: drh branch: auto-analyze, size: 81591)
2017-02-22
20:24		[46202f2f5e] part of check-in [9fced545a6] Change the name of the analyze_as_needed pragma to "optimize". Enhance the comment (which will become documentation, assuming these changes land on trunk) to explain that the optimize pragma is likely to be enhanced in various ways in future releases and that applications should not depend upon the current behavior. (check-in: [9fced545a6] user: drh branch: auto-analyze, size: 81554)
19:49		[97742aae32] part of check-in [fe07390508] Merge integrity_check and other improvements from trunk. (check-in: [fe07390508] user: drh branch: auto-analyze, size: 80787)
18:04		[b127edeb54] part of check-in [5af7d72ed9] Cleanup and simplification of the output row count limit control of PRAGMA integrity_check. (check-in: [5af7d72ed9] user: drh branch: integrity-check-improvements, size: 77834)
15:11		[ec83a3cb49] part of check-in [5264844b06] Fix integrity_check so that it verifies NOT NULL constraints even for tables that have no indexes. Enhance quick_check so that it verifies NOT NULL and CHECK constraints. (check-in: [5264844b06] user: drh branch: integrity-check-improvements, size: 78583)
14:15		[aa4af3d8c4] part of check-in [549bae0856] Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. (check-in: [549bae0856] user: drh branch: integrity-check-improvements, size: 78137)
2017-02-21
13:29		[9180cce9a1] part of check-in [9626b41e6e] Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. (check-in: [9626b41e6e] user: drh branch: vdbe_cycle_limit, size: 77532)
2017-02-18
22:52		[8a35509e8f] part of check-in [e842ad391e] Updated comments. No code changes. (check-in: [e842ad391e] user: drh branch: auto-analyze, size: 79876)
15:58		[1ed159f6fe] part of check-in [d386015f5e] Add the OP_SqlExec opcode and use it to implement "PRAGMA analyze_as_needed", invoking ANALYZE subcommands as necessary. This simplifies the implementation. (check-in: [d386015f5e] user: drh branch: auto-analyze, size: 78337)
02:19		[cf0f101d29] part of check-in [882599a4a7] In the analyze_as_needed pragma, avoid running unnecessary OP_LoadAnalysis and OP_Expire opcodes. Make the analyze_as_needed pragma responsive to the schema name. (check-in: [882599a4a7] user: drh branch: auto-analyze, size: 77154)
2017-02-17
16:26		[e8b2ea66df] part of check-in [e93db23731] Add the "PRAGMA analyze_as_needed" command. (check-in: [e93db23731] user: drh branch: auto-analyze, size: 77136)
13:38		[d4918a737f] part of check-in [85026c8ee1] Enhance the Index and Table objects so that they remember if their stats come from the sqlite_stat1 table. Make the "PRAGMA stats" an SQLITE_DEBUG only pragma. Add the flags column to "PRAGMA stats". These are all preliminary steps toward a "PRAGMA analyze_ifneeded;" feature. (check-in: [85026c8ee1] user: drh branch: auto-analyze, size: 77006)
2017-02-16
14:02		[0457012c3c] part of check-in [325ccfa95e] Merge recent enhancements from trunk. (check-in: [325ccfa95e] user: drh branch: est_count_pragma, size: 80659)
2017-02-04
15:29		[26e6c5f11e] part of check-in [6c3f09028f] Merge recent trunk enhancements. (check-in: [6c3f09028f] user: drh branch: apple-osx, size: 76890)
2017-02-01
22:43		[7831956012] part of check-in [997f765bc6] Fix harmless compiler warnings seen with MSVC. (check-in: [997f765bc6] user: mistachkin branch: msvcWarn, size: 76923)
2017-01-27
16:24		[1ba3574e9a] part of check-in [fe86ff5429] Merge all recent enhancements from trunk. (check-in: [fe86ff5429] user: drh branch: est_count_pragma, size: 80655)
2017-01-06
17:01		[74f24422fc] part of check-in [c59c888023] Merge the changes for version 3.16.2. (check-in: [c59c888023] user: drh branch: apple-osx, size: 76886)
2017-01-05
19:32		[0e7a7c6f1c] part of check-in [5c05d8ec5e] Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). (check-in: [5c05d8ec5e] user: dan branch: pragma-columncount-fix, size: 76919)
2017-01-03
20:20		[5924c96852] part of check-in [dcbec226ca] Merge changes from the 3.16.1 release (check-in: [dcbec226ca] user: drh branch: apple-osx, size: 76393)
2016-12-22
14:53		[5a23557e49] part of check-in [fa86db2f91] Fix harmless compiler warnings. (check-in: [fa86db2f91] user: drh branch: trunk, size: 76426)
2016-12-16
21:29		[f84626dbd0] part of check-in [4b1e780433] Merge recent enhancements from trunk, and especially the pragma-as-vtab change. (check-in: [4b1e780433] user: drh branch: apple-osx, size: 76285)
21:15		[10f1418fb9] part of check-in [89250777b2] Merge the pragma-as-vtab enhancement from trunk. (check-in: [89250777b2] user: drh branch: est_count_pragma, size: 80054)
21:02		[59cfc788ba] part of check-in [396ab8f87e] Fix a potential memory leak following an OOM error in the pragma processing. (check-in: [396ab8f87e] user: drh branch: est_count_pragma, size: 72269)
16:49		[850bee0057] part of check-in [4b73ee33f3] Experimental merge of the est_count_pragma and the pragma-as-vtab branches. (check-in: [4b73ee33f3] user: drh branch: est-count-pragma-vtab, size: 80045)
04:20		[d5adfe89ad] part of check-in [546821e29e] Fix an error in the way the "schema" argument to some pragma virtual tables is handled. (check-in: [546821e29e] user: drh branch: pragma-as-vtab, size: 76318)
02:14		[767a411284] part of check-in [3f8f461504] Minor bug fixes and enhancements to the pragma eponymous virtual tables. (check-in: [3f8f461504] user: drh branch: pragma-as-vtab, size: 76250)
2016-12-15
21:33		[41f18267db] part of check-in [7126807a18] Fix the cost estimation in the BestIndex method of the eponymous pragma virtual table implementation. (check-in: [7126807a18] user: drh branch: pragma-as-vtab, size: 76170)
21:11		[db1d2ae01a] part of check-in [2c274a1a7b] The pragma as eponymous virtual table mechanism now appears to work. (check-in: [2c274a1a7b] user: drh branch: pragma-as-vtab, size: 76131)
20:59		[b2421f23af] part of check-in [988a61e8b0] Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. (check-in: [988a61e8b0] user: drh branch: pragma-as-vtab, size: 76147)
16:01		[78f85cf6c6] part of check-in [a88ca3524b] Do more pragma processing from tables rather than in-line code. (check-in: [a88ca3524b] user: drh branch: table-driven-pragma, size: 66342)
2016-10-25
17:28		[6ca8fb0a4d] part of check-in [c3570e462a] Merge recent trunk changes, and especially the PRAGMA index_info enhancement which is needed on this branch. (check-in: [c3570e462a] user: drh branch: est_count_pragma, size: 72260)
15:39		[18a2b0aa05] part of check-in [fe49fb0313] Enhance the "PRAGMA index_info" and "PRAGMA index_xinfo" statements so that they work on WITHOUT ROWID tables and provide information about the underlying index btree that implements the WITHOUT ROWID table. (check-in: [fe49fb0313] user: drh branch: index-info-on-table, size: 68599)
2016-10-21
18:01		[7e3bbf3c8d] part of check-in [04fe12b590] When reading from an index, the shared-cache lock must be on the corresponding table. (check-in: [04fe12b590] user: drh branch: est_count_pragma, size: 72114)
17:25		[3ef6e3168e] part of check-in [affc2ef5ee] Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. (check-in: [affc2ef5ee] user: drh branch: est_count_pragma, size: 72044)
15:36		[e33c2c772e] part of check-in [c39fd9b8f1] Fix problems in the est_count pragma for indexes and WITHOUT ROWID tables. (check-in: [c39fd9b8f1] user: drh branch: est_count_pragma, size: 69619)
2016-10-20
22:02		[baf7074639] part of check-in [340822afbe] Experimental est_count pragma. (check-in: [340822afbe] user: drh branch: est_count_pragma, size: 69437)
18:20		[3ad504c61b] part of check-in [fd81d8a430] Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. (check-in: [fd81d8a430] user: drh branch: multi-arg-pragma, size: 68174)
2016-09-07
18:20		[7a32fcc81f] part of check-in [00759af053] Merge recent enhancements from trunk. (check-in: [00759af053] user: drh branch: apple-osx, size: 68420)
2016-08-18
14:33		[d932ba2786] part of check-in [92a22f0134] Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (check-in: [92a22f0134] user: drh branch: zDbSName, size: 68453)
2016-06-15
10:21		[1564ee0bc9] part of check-in [0f707d1532] Merge changes from trunk. (check-in: [0f707d1532] user: drh branch: apple-osx, size: 68399)
2016-06-10
22:49		[c8b4997566] part of check-in [53a1e5d513] Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. (check-in: [53a1e5d513] user: drh branch: trunk, size: 68432)
2016-05-26
20:56		[d98039af2d] part of check-in [ffe80a1bfa] Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. (check-in: [ffe80a1bfa] user: drh branch: trunk, size: 68412)
2016-05-23
02:57		[11046a2eb7] part of check-in [815cc2bb48] Merge changes from trunk. (check-in: [815cc2bb48] user: drh branch: apple-osx, size: 68497)
2016-05-20
15:15		[9fdce031dd] part of check-in [3d55d24dcb] Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. (check-in: [3d55d24dcb] user: drh branch: trunk, size: 68530)
2016-03-29
10:30		[985f16e7f1] part of check-in [eef557449c] Merge 3.12.0 changes. (check-in: [eef557449c] user: drh branch: apple-osx, size: 68503)
2016-03-22
20:05		[faf42922bb] part of check-in [605eba4a75] The sqlite3_column_decltype() routine should return NULL, not an empty string, if the column has no declared type. (check-in: [605eba4a75] user: drh branch: trunk, size: 68536)
2016-03-19
00:40		[620a6f8c85] part of check-in [c73b5b9ccf] Fix a VDBE register allocation bug exposed by recent enhancements to PRAGMA integrity_check. (check-in: [c73b5b9ccf] user: drh branch: apple-osx, size: 68548)
00:35		[e7e8f380ef] part of check-in [88439a866b] Fix a register allocation bug in the VDBE code generator for PRAGMA integrity_check; (check-in: [88439a866b] user: drh branch: trunk, size: 68581)
2016-03-18
00:58		[e1e161797d] part of check-in [ec052b4f14] Merge recent enhancements from trunk. (check-in: [ec052b4f14] user: drh branch: apple-osx, size: 68406)
2016-03-16
20:44		[f0670909e9] part of check-in [db1ce7e13e] Some pragmas can be reused without an automatic reprepare. (check-in: [db1ce7e13e] user: drh branch: reusable-pragma, size: 68439)
20:05		[fb8e3e7343] part of check-in [10a3e2a01d] Fix a comment on the freelist_count and data_version pragmas. (check-in: [10a3e2a01d] user: drh branch: trunk, size: 68381)
01:09		[a1a9753ba1] part of check-in [161d91e485] Merge the SQLITE_OMIT_CODEC_FROM_TCL compile-time option from trunk. (check-in: [161d91e485] user: drh branch: apple-osx, size: 68319)
2016-03-15
22:00		[04baa93437] part of check-in [15e4a272df] Change the OP_IntegrityCk opcode to accept the list of root pages as an intarray argument in P4. Slightly smaller and faster. (check-in: [15e4a272df] user: drh branch: trunk, size: 68352)
2016-03-09
08:08		[3ca4a32189] part of check-in [59caca4387] Merge latest trunk changes with this branch. (check-in: [59caca4387] user: dan branch: schemalint, size: 68221)
2016-03-08
16:35		[88bd7bba13] part of check-in [2974194123] Merge changes from trunk, especially the SQLITE_DEFAULT_SYNCHRONOUS enhancements. (check-in: [2974194123] user: drh branch: apple-osx, size: 68147)
14:40		[c7061870c2] part of check-in [1fefa967aa] Add compile-time options SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS used to specify the default synchronous settings for all database connections. (check-in: [1fefa967aa] user: drh branch: default-synchronous, size: 68180)
2016-03-04
14:57		[2c1fa795a1] part of check-in [2f0c195ccc] Merge recent enhancements from trunk, and especially the changes that reduce the heap-memory footprint of schemas, and defer opening and writing to statement journals. (check-in: [2f0c195ccc] user: drh branch: apple-osx, size: 68821)
2016-02-29
15:53		[42b3f1475b] part of check-in [842b211627] Reduce the amount of heap required to store many schemas by storing each column datatype appended to the column name, rather than as a separate allocation. (check-in: [842b211627] user: drh branch: schema-storage, size: 68153)
2016-02-27
21:16		[35619c4e9f] part of check-in [d8c94a46df] Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. (check-in: [d8c94a46df] user: drh branch: trunk, size: 68112)
19:03		[b9d960d385] part of check-in [3e5d38f5b3] More compact implementation of PRAGMA onconflict, and some test cases. (check-in: [3e5d38f5b3] user: drh branch: pragma-onconflict, size: 68662)
17:16		[f8f9bf11e2] part of check-in [3a0c347cca] Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. (check-in: [3a0c347cca] user: drh branch: pragma-onconflict, size: 68724)
2016-02-26
16:14		[fc4b8918ea] part of check-in [4fb4aee83d] Merge all recent enhancements from trunk, and in particular the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER change. (check-in: [4fb4aee83d] user: drh branch: apple-osx, size: 68690)
2016-02-25
21:19		[d6028d23a9] part of check-in [832c237fcb] Change the "PRAGMA stats" command to report size values in LogEst units. The eliminates the need for sqlite3LogEstToInt() unless non-standard compile-time options are used, so leave it out except in those cases. (check-in: [832c237fcb] user: drh branch: trunk, size: 68022)
2016-02-11
21:01		[cfd521558f] part of check-in [ed49f297bc] Experimental integration of schemalint functionality with the shell tool. Does not work yet. (check-in: [ed49f297bc] user: dan branch: schemalint, size: 68163)
2016-02-05
14:29		[eb149efaf7] part of check-in [201fcbeef3] Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. (check-in: [201fcbeef3] user: drh branch: apple-osx, size: 68790)
01:55		[80ee77226d] part of check-in [c3ef03478a] Improvements to the way that OOM errors are processed. (check-in: [c3ef03478a] user: drh branch: oom-handling, size: 68122)
2016-02-04
02:34		[eb3a712e0b] part of check-in [1c8d300189] Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. (check-in: [1c8d300189] user: drh branch: zero-register, size: 68105)
2016-02-03
19:20		[3c4f3fadf0] part of check-in [af92401826] Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the rollback journal when the rollback journal is deleted in order to commit a transaction in DELETE mode. (check-in: [af92401826] user: drh branch: trunk, size: 68123)
01:55		[a973357ef2] part of check-in [ae8b9d2edf] Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. (check-in: [ae8b9d2edf] user: drh branch: trunk, size: 67944)
2016-02-02
02:30		[dc702fbc48] part of check-in [e6a4a16312] Merge recent enhancements from trunk. (check-in: [e6a4a16312] user: drh branch: apple-osx, size: 68648)
2016-02-01
21:48		[2ac26ac45e] part of check-in [6d7d4703eb] Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. (check-in: [6d7d4703eb] user: drh branch: trunk, size: 67980)
2016-01-20
11:40		[0200623c36] part of check-in [3ed49691a1] Merge all recent enhancements from trunk. (check-in: [3ed49691a1] user: drh branch: apple-osx, size: 68822)
2016-01-18
00:20		[ea29019336] part of check-in [0aaf3febb0] Fix a problem with SQLITE_TEST_REALLOC_STRESS. (check-in: [0aaf3febb0] user: drh branch: trunk, size: 68154)
2016-01-16
20:50		[53c95f5454] part of check-in [88ceb588bc] Improvements to the way sqlite3VdbeAddOpList() works, resulting in a slightly smaller and faster binary. (check-in: [88ceb588bc] user: drh branch: trunk, size: 68042)
2015-11-13
02:13		[c1ab37e157] part of check-in [f9060b2a98] Merge fixes from trunk. (check-in: [f9060b2a98] user: drh branch: apple-osx, size: 68663)
2015-11-12
22:15		[f3e7147299] part of check-in [12e7d9ec02] Always parse the schema before running "PRAGMA cache_size", not after. (check-in: [12e7d9ec02] user: drh branch: trunk, size: 67995)
16:51		[44e32568b4] part of check-in [e72331c719] Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. (check-in: [e72331c719] user: drh branch: apple-osx, size: 68773)
16:44		[56161e4aa4] part of check-in [f79d264db2] Enhance the "PRAGMA cache_spill" statement to accept an integer argument which is the threshold at which spilling will begin. (check-in: [f79d264db2] user: drh branch: trunk, size: 68105)
15:47		[0e91830e5c] part of check-in [9a431362dc] Test cases. Minor problems fixed. All appears to work now. (check-in: [9a431362dc] user: drh branch: cache_spill=N, size: 68160)
14:57		[26a612db31] part of check-in [549d42be0d] First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. (check-in: [549d42be0d] user: drh branch: cache_spill=N, size: 68120)
2015-11-10
14:27		[9dbb9ba245] part of check-in [1e4849911e] Make the output of "PRAGMA parser_trace" go to stdout instead of stderr. (check-in: [1e4849911e] user: drh branch: trunk, size: 66707)
2015-10-26
20:50		[5d97c87f05] part of check-in [bc195e1cd9] Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. (check-in: [bc195e1cd9] user: dan branch: apple-osx, size: 67375)
2015-10-22
20:54		[8fd4c8a12e] part of check-in [cdc92919e6] Modifications to pass a flag to internal routine sqlite3BtreeCursor() when a cursor that is used solely for deleting b-tree entries, or for obtaining the components of keys to delete from other b-trees, is opened. (check-in: [cdc92919e6] user: dan branch: btree-fordelete-flag, size: 66707)
2015-10-09
17:28		[f66e2d2d21] part of check-in [1ccae39b8a] Merge all changes through the first 3.9.0 beta from trunk. (check-in: [1ccae39b8a] user: drh branch: apple-osx, size: 67372)
2015-10-06
21:07		[dcfe3a35d2] part of check-in [041df7c2f1] Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. (check-in: [041df7c2f1] user: drh branch: trunk, size: 66704)
2015-09-29
17:20		[234814978b] part of check-in [7d272aa62c] Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. (check-in: [7d272aa62c] user: drh branch: trunk, size: 66650)
2015-09-25
20:49		[577f70c389] part of check-in [113181cec4] Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. (check-in: [113181cec4] user: drh branch: trunk, size: 66646)
2015-09-03
14:31		[a6b01c318f] part of check-in [d01658adf8] Merge enhancements from trunk. (check-in: [d01658adf8] user: drh branch: apple-osx, size: 67300)
13:46		[d71b813e67] part of check-in [847387ec8e] Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). (check-in: [847387ec8e] user: drh branch: trunk, size: 66632)
04:28		[0465869b5a] part of check-in [d7f4bdf594] Factor out and simplify code in pragma.c for pragmas that return a single row with a single column that is an integer or text value. (check-in: [d7f4bdf594] user: drh branch: trunk, size: 68272)
03:29		[a5a100adba] part of check-in [0ea6e5c9fc] For PRAGMAs, factor out the code that sets the result set column names into a subroutine. (check-in: [0ea6e5c9fc] user: drh branch: trunk, size: 68937)
2015-09-02
18:19		[5d84bdb379] part of check-in [be78f413df] Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand for sqlite3VdbeAddOp2(v,OP_Goto,0,i). (check-in: [be78f413df] user: drh branch: trunk, size: 71582)
2015-08-28
02:12		[9eaa576bbe] part of check-in [da8646582a] Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. (check-in: [da8646582a] user: drh branch: apple-osx, size: 72283)
2015-08-25
19:20		[a239d2c8c6] part of check-in [1ee089a72d] Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. (check-in: [1ee089a72d] user: drh branch: trunk, size: 71615)
2015-07-29
14:10		[669bc0fdb3] part of check-in [4489722a6b] The "PRAGMA cache_size" reads the database schema, as it has done in all prior versions of SQLite. This side-effect of cache_size is undocumented, but apparently it does get used and its absence from 3.8.11 was causing problems. (check-in: [4489722a6b] user: drh branch: branch-3.8.11, size: 71614)
2015-07-16
18:18		[e52084b37a] part of check-in [b79a4affe4] Defer the bulk pcache1 memory allocation until the first page allocation request. Limit the size of the pcache1 bulk allocation to the cache_size setting. Deallocate the bulk allocation on a sqlite3_db_release_memory() request, if the bulk allocation is completely unused. (check-in: [b79a4affe4] user: drh branch: trunk, size: 71559)
2015-04-20
01:25		[17e0049780] part of check-in [74b7bf1744] Merge all recent trunk enhancements and fixes into the apple-osx branch. (check-in: [74b7bf1744] user: drh branch: apple-osx, size: 72166)
2015-04-19
21:43		[c1f4d012ea] part of check-in [d05becd873] Fix harmless compiler warnings seen with MSVC 2015. (check-in: [d05becd873] user: mistachkin branch: vsix2015, size: 71504)
2015-04-17
15:58		[2a81f312cd] part of check-in [7aeade9a07] Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. (check-in: [7aeade9a07] user: drh branch: trunk, size: 71498)
2015-04-16
16:04		[633cb355ab] part of check-in [e0a88176fc] Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. (check-in: [e0a88176fc] user: drh branch: trunk, size: 71543)
2015-04-15
13:51		[db44f204be] part of check-in [bfc7142ad2] Merge recent trunk fixes and enhancements into the apple-osx branch. (check-in: [bfc7142ad2] user: drh branch: apple-osx, size: 72059)
07:19		[3965ae4e82] part of check-in [0e087c0183] Remove an incorrect ALWAYS() from the table_info pragma. (check-in: [0e087c0183] user: drh branch: trunk, size: 71406)
2015-03-09
13:18		[21af63d913] part of check-in [5e04eec88e] Merge recent trunk enhancements into the apple-osx branch. (check-in: [5e04eec88e] user: drh branch: apple-osx, size: 72067)
2015-03-06
04:37		[ac4f3f856b] part of check-in [8c1e85aab9] Clearification of some documentation text. Added requirements marks. (check-in: [8c1e85aab9] user: drh branch: trunk, size: 71414)
2015-03-05
14:29		[7f51aba7fa] part of check-in [fc543c2c5c] Revert "PRAGMA index_info" to output only three columns, for complete compatibility with prior versions. The new "PRAGMA index_xinfo" can be used to get the extra information in 4th, 5th, and 6th columns. (check-in: [fc543c2c5c] user: drh branch: trunk, size: 70850)
2015-02-28
01:04		[d1abcc0706] part of check-in [fc51037cd9] More test cases and requirements marks for pragmas. (check-in: [fc51037cd9] user: drh branch: trunk, size: 70533)
2015-02-06
16:03		[f5c1ba0652] part of check-in [44711921fe] Merge all recent trunk enhancements into the apple-osx branch. (check-in: [44711921fe] user: drh branch: apple-osx, size: 70822)
00:31		[8042d2b202] part of check-in [7f10a0eaf1] Revise the way that the index structure for a WITHOUT ROWID table is discovered. (check-in: [7f10a0eaf1] user: drh branch: ota-update, size: 71909)
2015-02-04
23:51		[6e376554d9] part of check-in [21e95d28a5] Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. (check-in: [21e95d28a5] user: drh branch: ota-update, size: 72055)
23:13		[ea0be138a9] part of check-in [3af19f8444] Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (check-in: [3af19f8444] user: drh branch: index_xinfo, size: 70169)
2015-02-03
18:43		[e39954ff47] part of check-in [a21fefb79a] Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . (check-in: [a21fefb79a] user: dan branch: ota-update, size: 87789)
15:56		[26fc556191] part of check-in [1c111447a0] Remove "PRAGMA ota_mode". (check-in: [1c111447a0] user: dan branch: ota-update, size: 87643)
2015-02-02
22:19		[a5b397bd62] part of check-in [6dca23e64e] Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (check-in: [6dca23e64e] user: drh branch: preload-pragma, size: 69958)
21:34		[58044728a2] part of check-in [32c0325bcb] Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. (check-in: [32c0325bcb] user: drh branch: trunk, size: 69316)
2015-01-31
02:34		[e49831e54c] part of check-in [f9b6dc7702] Merge in support for the index_xinfo pragma. (check-in: [f9b6dc7702] user: drh branch: ota-update, size: 87959)
02:00		[f4d0326361] part of check-in [30f51d7b3b] Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. (check-in: [30f51d7b3b] user: drh branch: index_xinfo, size: 85682)
2015-01-28
12:00		[92eba8211c] part of check-in [17c69be805] Merge in all changes from trunk. (check-in: [17c69be805] user: drh branch: ota-update, size: 86961)
2015-01-16
12:24		[d9bd64b0ca] part of check-in [518621f8dc] Merge the 3.8.8 release changes from trunk. (check-in: [518621f8dc] user: drh branch: apple-osx, size: 85337)
2015-01-12
18:38		[ba149bbbc9] part of check-in [2b8eecbfe7] Fix some harmless compiler warnings. (check-in: [2b8eecbfe7] user: mistachkin branch: msvcW4, size: 84684)
2015-01-02
19:17		[1f13dbb552] part of check-in [df3cdf9f06] Merge the latest changes from trunk into the apple-osx branch. (check-in: [df3cdf9f06] user: drh branch: apple-osx, size: 85337)
2014-12-19
19:28		[bd33aa2445] part of check-in [43db1f44bc] Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. (check-in: [43db1f44bc] user: drh branch: data_version_pragma, size: 84684)
18:49		[7337e5d9f1] part of check-in [da27a09d1d] Simplify the implementation of the "header-value" pragmas (schema_version, user_version, freelist_count, and application_id) by making them more table-driven. (check-in: [da27a09d1d] user: drh branch: trunk, size: 84465)
2014-12-16
00:29		[8ed7592557] part of check-in [2c1d8ddab2] Merge latest fixes and enhancements from trunk into apple-osx. (check-in: [2c1d8ddab2] user: drh branch: apple-osx, size: 85305)
2014-12-12
23:17		[c93be50564] part of check-in [d7bb7ea4ab] Add extra tests to threadtest4.c. Fix a benign data race accessing the text encoding using ENC(db). (check-in: [d7bb7ea4ab] user: drh branch: trunk, size: 84652)
2014-12-08
07:50		[294c31d79d] part of check-in [69a312ad3f] Update this branch with latest trunk changes. (check-in: [69a312ad3f] user: dan branch: ota-update, size: 86904)
2014-12-04
23:42		[0de5c12a99] part of check-in [463ad971d2] Import from trunk support for SQLITE_CHECKPOINT_TRUNCATE and fixes for a couple of obscure bugs. (check-in: [463ad971d2] user: drh branch: apple-osx, size: 85280)
2014-12-02
19:04		[d54cdd40b6] part of check-in [8e20a43419] Add the SQLITE_CHECKPOINT_TRUNCATE option. (check-in: [8e20a43419] user: dan branch: checkpoint-truncate, size: 84627)
2014-11-22
09:09		[8e0087a5ae] part of check-in [600cefdd4d] Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: [600cefdd4d] user: dan branch: ota-update, size: 86794)
2014-11-20
17:37		[272b122a87] part of check-in [55066a1171] Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. (check-in: [55066a1171] user: dan branch: ota-update, size: 86662)
15:11		[92343541fc] part of check-in [556c3de53a] Updates to support zipvfs in pass-through mode. (check-in: [556c3de53a] user: dan branch: ota-update, size: 86676)
2014-10-20
16:24		[310939bc2f] part of check-in [0bf1301aac] Have the ota extension perform an incremental checkpoint after generating the wal file. (check-in: [0bf1301aac] user: dan branch: ota-update, size: 86472)
2014-09-21
23:08		[c63b5aa7b6] part of check-in [3967ebe83e] Merge in all recent changes from trunk. (check-in: [3967ebe83e] user: drh branch: apple-osx, size: 85170)
2014-09-16
20:02		[5b255c09d6] part of check-in [decaccc37c] Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. (check-in: [decaccc37c] user: dan branch: ota-update, size: 86474)
2014-09-15
19:34		[c401b5ddbb] part of check-in [48d201cd8b] Remove the experimental sqlite3_transaction_save() and restore() APIs. (check-in: [48d201cd8b] user: dan branch: ota-update, size: 85273)
15:34		[5dba6b386c] part of check-in [55b8011d5b] Merge latest trunk changes with this branch. (check-in: [55b8011d5b] user: dan branch: ota-update, size: 85326)
2014-09-11
14:01		[3f3e959390] part of check-in [70121e7cf8] Move user authentication blocking from sqlite3_prepare() over to the table lock generator, thus allowing SQL statements (like "PRAGMA locking_mode") that do not touch database content to run prior to authentication. (check-in: [70121e7cf8] user: drh branch: user-auth, size: 84517)
2014-09-10
17:34		[3b7b1a5e90] part of check-in [c8171ecd0d] Further ideas on user authentication. Not yet working code. (check-in: [c8171ecd0d] user: drh branch: user-auth, size: 84517)
2014-09-09
14:47		[e4f6421d7a] part of check-in [8440f093ba] Non-working preliminary implementation attempts on user authentication. (check-in: [8440f093ba] user: drh branch: user-auth, size: 84501)
2014-09-03
19:30		[e1b8049c05] part of check-in [209f672e58] Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. (check-in: [209f672e58] user: dan branch: ota-update, size: 85121)
2014-09-02
19:59		[d252459fb3] part of check-in [2954ab5010] Add an experimental extension for applying bulk updates to databases. (check-in: [2954ab5010] user: dan branch: ota-update, size: 84604)
15:57		[4865f1a42c] part of check-in [696dc935f7] Merge the latest trunk changes into the apple-osx branch. (check-in: [696dc935f7] user: drh branch: apple-osx, size: 84965)
2014-08-29
16:20		[14bcdb5041] part of check-in [1b598c68f3] Add SQLITE_LIMIT_WORKER_THREADS for controlling the maximum number of worker threads. (check-in: [1b598c68f3] user: drh branch: threads, size: 84312)
2014-08-25
23:44		[33971fcaa7] part of check-in [e3305d4b4e] Remove the SQLITE_CONFIG_WORKER_THREADS configuration parameter. The number of worker threads in the sorter is now determined only by the PRAGMA threads=N setting. (check-in: [e3305d4b4e] user: drh branch: threads, size: 84327)
15:13		[4ed8bc86d1] part of check-in [29c5e8a7c9] Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. (check-in: [29c5e8a7c9] user: drh branch: threads, size: 84331)
2014-08-15
22:37		[97a45c2eaa] part of check-in [c8ade949d4] Aborted merge. (check-in: [c8ade949d4] user: numist branch: obsolete, size: 82118)
2014-08-06
01:51		[0fc087e3b2] part of check-in [b2e01080cc] Merge 3.8.6 beta changes in from trunk. (check-in: [b2e01080cc] user: drh branch: apple-osx, size: 84271)
2014-08-05
00:53		[d10ef67c4d] part of check-in [01f60027ad] Improved VdbeCoverage() macros. A few minor simplifications to generated VDBE code. (check-in: [01f60027ad] user: drh branch: IN-operator-improvements, size: 83618)
2014-08-04
15:12		[58374d1bb5] part of check-in [2f724cbac9] Changed my mind: This opcode name changes mere creates unnecessary diff marks between older and newer versions without significantly improving readability. Was: Rename the IsNull opcode to IfNull and rename the NotNull opcode to IfNotNull. (check-in: [2f724cbac9] user: drh branch: deadend, size: 83674)
2014-08-01
01:40		[d4a33151f0] part of check-in [9abcf2698c] Enhance the PRAGMA integrity_check command to detect UNIQUE and NOT NULL constraint violations. (check-in: [9abcf2698c] user: drh branch: trunk, size: 83672)
2014-07-31
22:59		[f9268bd5fa] part of check-in [e75b26ee35] Refactoring: Change "pIndex->onError!=OE_None" to use a macro: "IsUniqueIndex(pIndex)". Easier to understand that way. (check-in: [e75b26ee35] user: drh branch: trunk, size: 81208)
2014-07-30
11:49		[b7758ec0ba] part of check-in [654c6c658b] Merge all recent trunk changes, and especially the R-Tree IN operator fix of ticket [d2889096e7bdeac]. (check-in: [654c6c658b] user: drh branch: apple-osx, size: 81864)
2014-07-25
21:35		[30f3b2ac09] part of check-in [e0fa6fdc14] Try to fix harmless compiler warnings reported by Fortify. (check-in: [e0fa6fdc14] user: drh branch: trunk, size: 81211)
2014-07-24
16:43		[4cb718db62] part of check-in [3810dc62d2] Merge recent trunk changes into the apple-osx branch. (check-in: [3810dc62d2] user: drh branch: apple-osx, size: 81866)
2014-07-23
13:40		[e17c5ea1cb] part of check-in [6c6f0de59b] Change the hex literal processing so that only the SQL parser understands hex literals. Casting and coercing string literals into numeric values does not understand hexadecimal integers. This preserves backwards compatibility. Also: Throw an error on any hex literal that is too big to fit into 64 bits. (check-in: [6c6f0de59b] user: drh branch: hex-literal, size: 81213)
2014-05-09
11:45		[039578fb7d] part of check-in [d66fe706da] Bring the PRAGMA logic into closer alignment with trunk, and in the process fix a couple of crashes. (check-in: [d66fe706da] user: drh branch: apple-osx, size: 81943)
2014-05-08
23:01		[67d3b4a85c] part of check-in [9411d7dc6f] Initial attempt to merge in all trunk changes over the previous 1.5 years. This check-in compiles but there are compiler warnings and "make test" segfaults after only running a few test modules. (check-in: [9411d7dc6f] user: drh branch: apple-osx, size: 82158)
2014-05-05
22:49		[1f392e4e9b] part of check-in [f1a4bf01a2] Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. (check-in: [f1a4bf01a2] user: drh branch: reduce-schema-size, size: 81570)
19:57		[f89b68223a] part of check-in [35a9f3f178] Try to reduce the amount of memory used to hold the schema when PRAGMA ignore_check_constraints is active. (check-in: [35a9f3f178] user: drh branch: reduce-schema-size, size: 81368)
2014-04-25
15:01		[810ef31ccf] part of check-in [1bd74c49dd] Store values loaded from the stat1 table as logarithmic values in memory. (check-in: [1bd74c49dd] user: dan branch: experimental-costs, size: 81290)
2014-04-13
19:15		[21ece94d4f] part of check-in [3122b83640] Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. (check-in: [3122b83640] user: drh branch: trunk, size: 81220)
2014-03-19
14:10		[10f169b965] part of check-in [59742dd4c5] First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. (check-in: [59742dd4c5] user: drh branch: orderby-planning, size: 81212)
2014-03-10
18:03		[e78b4bf2a2] part of check-in [0a5318bc27] Attempt to work around MSVC's treatment of __LINE__ as a non-constant value in "Edit and Continue" mode by avoiding the use of __LINE__ when SQLITE_VDBE_COVERAGE is not defined. (check-in: [0a5318bc27] user: drh branch: trunk, size: 81209)
2014-02-19
19:14		[a46ee83671] part of check-in [c1e94169dd] Add the VdbeCoverageNeverTaken() macro, and comments that better describe how the VDBE branch coverage measurement works. Add some tags to provide 100% VDBE branch coverage. (check-in: [c1e94169dd] user: drh branch: trunk, size: 81176)
2014-02-17
22:40		[2635d6bf8b] part of check-in [ce184c7bb1] Add logic to do test coverage measurements on the VDBE code. (check-in: [ce184c7bb1] user: drh branch: insert-optimization, size: 81126)
14:59		[769d08f10b] part of check-in [35b4d6e938] Avoid unnecessary calls to applyAffinity() during INSERT and UPDATE operations, especially for table that have indices and tables for which all columns have affinity "NONE". (check-in: [35b4d6e938] user: drh branch: insert-optimization, size: 80652)
2014-01-04
19:27		[ed409ce410] part of check-in [8f6e6149a1] Avoid redundant register loads during index key generation when doing a DELETE or INTEGRITY_CHECK on a table with multiple indices. (check-in: [8f6e6149a1] user: drh branch: trunk, size: 80686)
2013-11-16
20:13		[5ab7279d13] part of check-in [8f479a7275] Enhance the DELETE logic so that it can make use of WHERE_ONEPASS_DESIRED for rowid tables. (check-in: [8f479a7275] user: drh branch: optimize-delete, size: 80580)
2013-11-13
17:58		[c8d70c47ec] part of check-in [8ce33f4c81] Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. (check-in: [8ce33f4c81] user: drh branch: trunk, size: 80577)
2013-11-06
19:59		[3b7b766382] part of check-in [defd5205a7] Reference count the KeyInfo object. Cache a copy of an appropriate KeyInfo for each index in the Index object, and reuse that one copy as much as possible. (check-in: [defd5205a7] user: drh branch: omit-rowid, size: 80446)
2013-11-04
21:44		[ac43f31b04] part of check-in [1ea43c0f23] Bug fixes in the INSERT constraint checker. Refactor the Rowid handling logic for ANALYZE with STAT3/4. (check-in: [1ea43c0f23] user: drh branch: omit-rowid, size: 80531)
17:00		[8d67f2e7a7] part of check-in [89098e6d18] Fix a problem with processing INTEGER PRIMARY KEY on a WITHOUT ROWID table. (check-in: [89098e6d18] user: drh branch: omit-rowid, size: 80533)
2013-10-31
15:37		[ff1a98998d] part of check-in [ad90e762e5] Improved comments and variable names in infrastructure routines of UPDATE, DELETE, and INSERT. (check-in: [ad90e762e5] user: drh branch: omit-rowid, size: 80439)
11:15		[74dec25a3f] part of check-in [1adfca6019] Refactor the INSERT, DELETE, and UPDATE code generators to distinguish between the "data cursor" and the "first index cursor", which are no longer consecutive in the case of a WITHOUT ROWID table. (check-in: [1adfca6019] user: drh branch: omit-rowid, size: 80432)
2013-10-30
20:22		[c6612470d2] part of check-in [0d4fea7462] Continue working to get UPDATE operational for WITHOUT ROWID tables. Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables. (check-in: [0d4fea7462] user: drh branch: omit-rowid, size: 80331)
2013-10-28
22:39		[21f9e61ca8] part of check-in [9f8191d1d8] Merge recent fixes from trunk. (check-in: [9f8191d1d8] user: drh branch: omit-rowid, size: 80200)
2013-10-25
14:46		[5986f119f6] part of check-in [9eafafa31c] Basic DELETE operations now working on WITHOUT ROWID tables. (check-in: [9eafafa31c] user: drh branch: omit-rowid, size: 79418)
2013-10-24
14:16		[d6eee7e1b6] part of check-in [0e56ba69f0] Delete PRIMARY KEY index entries last. Only construct the unique prefix of an index key when deleting entries from an index. (check-in: [0e56ba69f0] user: drh branch: omit-rowid, size: 79414)
2013-10-23
22:23		[575a446236] part of check-in [2c028ddc85] Construct secondary indices on WITHOUT ROWID tables. (check-in: [2c028ddc85] user: drh branch: omit-rowid, size: 79414)
2013-10-22
18:01		[ab815d2769] part of check-in [a106ce86cd] The Index object now has nKeyCol and nColumn. nColumn is the total number of columns and nKeyCol is the number of key columns. Currently these always differ by one. Refactor aiColumn[] to be of type i16 instead of int. (check-in: [a106ce86cd] user: drh branch: omit-rowid, size: 79455)
2013-10-21
23:17		[6fb3125fff] part of check-in [f1d8c3b07e] Improve support for the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (check-in: [f1d8c3b07e] user: mistachkin branch: trunk, size: 80237)
2013-10-14
14:30		[64d3d1f8b4] part of check-in [208b259ad7] Update the foreign_key_check pragma so that when a parent table is undefined it is treated as an empty table. (check-in: [208b259ad7] user: drh branch: trunk, size: 79455)
2013-10-12
20:22		[1c00ed0dea] part of check-in [f0cf8c85dc] Restore the index_list pragma back to its former operation. Create a new PRAGMA stats used to access the table and index widths and heights. (check-in: [f0cf8c85dc] user: drh branch: trunk, size: 79365)
19:06		[24fb88e294] part of check-in [8c13a7fd73] In "PRAGMA foreign_key_check", treat missing parent tables as empty (instead of as errors). (check-in: [8c13a7fd73] user: dan branch: fkc-missing-parent-tables, size: 78411)
09:32		[393efaa787] part of check-in [0c4dd9fff0] Changes to the new initial row of PRAGMA index_list results. (check-in: [0c4dd9fff0] user: mistachkin branch: indexList, size: 78415)
2013-10-07
10:48		[f4ff6e29c3] part of check-in [1d7b2dc0ea] Merge bug fixes from trunk. (check-in: [1d7b2dc0ea] user: drh branch: row-size-est, size: 78321)
00:36		[b65c827316] part of check-in [0aca31e151] Restore the hexrekey pragma which was accidently deleted during the pragma refactoring. Make sure the hexkey and hexrekey pragmas do not overflow buffers with a over-length key. (check-in: [0aca31e151] user: drh branch: trunk, size: 77920)
2013-10-05
19:18		[c9a867f6f9] part of check-in [8b4aa0c7a2] Completely remove the iScanRatio field. The PRAGMA index_list(TABLE) command shows the estimated row size in the forth column. It also generates a row for the table with an index name of NULL. The query planner still does not take row size estimates into account - that is the next step. (check-in: [8b4aa0c7a2] user: drh branch: row-size-est, size: 78193)
02:56		[07814efdbf] part of check-in [de78250ad2] In the index_list pragma, make sure the "r" column is the same on output as it was on input in the sqlite_stat1 table. (check-in: [de78250ad2] user: drh branch: index-scan-rate, size: 77942)
2013-10-04
15:30		[3bcdc7a98a] part of check-in [07462bb605] Improved estimates of the relative speed of index scans based on declared datatypes of columns in the table. Add "r" column to PRAGMA index_info, showing the estimated relative scan rate. (check-in: [07462bb605] user: drh branch: index-scan-rate, size: 77936)
2013-10-03
14:08		[5a4d8d9c3c] part of check-in [8338232a11] Rework the PRAGMA implementation to only call sqlite3ReadSchema() from a single place, based on a flag in the pragma table, rather than separately from each case which needs the schema. (check-in: [8338232a11] user: drh branch: trunk, size: 77792)
2013-09-13
21:03		[0c7a67a75c] part of check-in [b74e6be818] Fix the "const" qualifiers on the pragma name table. (check-in: [b74e6be818] user: drh branch: trunk, size: 75126)
21:01		[d3d93be2c8] part of check-in [c326356f9a] Add the soft_heap_limit pragma. (check-in: [c326356f9a] user: drh branch: trunk, size: 75126)
19:00		[249742bd76] part of check-in [c82e05c4b8] Tweak the new PRAGMA name parser to achieve full branch test coverage. (check-in: [c82e05c4b8] user: drh branch: trunk, size: 74566)
16:36		[49612a5c35] part of check-in [870c030b4e] Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. (check-in: [870c030b4e] user: drh branch: trunk, size: 74437)
2013-08-24
00:59		[3aa3d8c862] part of check-in [032c31593d] Unify the result of PRAGMA mmap_size when mmap support is disabled. (check-in: [032c31593d] user: mistachkin branch: mmapDisabled, size: 67283)
2013-08-23
17:33		[dc9ceab9b3] part of check-in [ed31020162] Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS to build. (check-in: [ed31020162] user: drh branch: trunk, size: 67223)
2013-08-17
15:42		[1d96ba7492] part of check-in [d07c4331a2] The fullfsync, checkpoint_fullfsync, and cache_spill pragmas apply to all files of a database connection, including those opened by future ATTACH statements. (check-in: [d07c4331a2] user: drh branch: cache_spill, size: 67175)
2013-08-16
20:42		[3fd0f90f71] part of check-in [cdb181c04f] Add the cache_spill pragma. (check-in: [cdb181c04f] user: drh branch: cache_spill, size: 67059)
2013-08-01
15:09		[590c75750d] part of check-in [0c8cfdfae2] More test cases and corresponding bug fixes. (check-in: [0c8cfdfae2] user: drh branch: partial-indices, size: 66701)
03:36		[aca37128da] part of check-in [6b73ae7c12] Test cases and bug fixes for the partial index logic. (check-in: [6b73ae7c12] user: drh branch: partial-indices, size: 66662)
01:14		[f8936b23ce] part of check-in [fb9044d15a] Add the logic to keep partial indices up to date through DML statements and when new partial indices are created. This new logic is untested except to verify that it does not interfere with full indices. (check-in: [fb9044d15a] user: drh branch: partial-indices, size: 67055)
2013-07-11
15:22		[2790c5175b] part of check-in [6557c40798] Add the experimental "query_only" pragma. (check-in: [6557c40798] user: drh branch: trunk, size: 66998)
12:19		[c87581d93a] part of check-in [3a2ab74c85] Rename the SQLITE_DeferForeignKeys macro to shorter SQLITE_DeferFKs. Move the "defer_foreign_keys" pragma into the flagPragma() routine. (check-in: [3a2ab74c85] user: drh branch: sessions, size: 66940)
2013-07-10
13:33		[f91b64b84c] part of check-in [ece960c496] Experimental "PRAGMA query_only=BOOLEAN" statement that is able to turn write capabilities on and off. (check-in: [ece960c496] user: drh branch: query_only, size: 66870)
2013-07-03
19:53		[057f5b1343] part of check-in [1d44e5d3c2] Experimental change to the handling of foreign key constraint violations when applying a changeset: all foreign keys, immediate and deferred, are deferred until the end of the transaction (or sub-transaction) opened by the sqlite3changeset_apply(). A single call to the conflict-handler (if any) is made if any FK constraint violations are still present in the database at this point. The conflict-handler may choose to rollback the changeset or to apply it, constraint violations and all. (check-in: [1d44e5d3c2] user: dan branch: sessions, size: 67260)
2013-05-29
17:48		[67a611bd4b] part of check-in [d5b084e9d8] Updates to the Codec interface to support codecs on attached databases and to allow rekeying in the middle of a transaction. These changes are only applicable if SQLite is compiled with SQLITE_HAS_CODEC. (check-in: [d5b084e9d8] user: drh branch: trunk, size: 66812)
2013-05-28
12:11		[7528202452] part of check-in [a0d5cc9315] Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. (check-in: [a0d5cc9315] user: drh branch: trunk, size: 66780)
2013-05-23
10:13		[8bf4bfaef7] part of check-in [40cfde8b4a] Avoid unnecessary calls to FCNTL_SIZE_HINT. Return an error to the user if the file-control invoked by "PRAGMA mmap_size" returns a value other than SQLITE_OK or SQLITE_NOTFOUND. (check-in: [40cfde8b4a] user: dan branch: trunk, size: 66796)
2013-05-01
19:49		[8779308bc1] part of check-in [28c9e7fdee] Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. (check-in: [28c9e7fdee] user: drh branch: application-id, size: 66700)
2013-04-15
17:03		[3eacf001cb] part of check-in [ea1404a10a] Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. (check-in: [ea1404a10a] user: drh branch: trunk, size: 66415)
2013-04-11
13:26		[216d6c2452] part of check-in [663f04bd48] Fix pragma code generation so that it always outputs an OP_Trace opcode so that pragmas are shown in sqlite3_trace() output. (check-in: [663f04bd48] user: drh branch: trunk, size: 66425)
2013-04-08
20:47		[8bbc8c8697] part of check-in [8a4314a398] Disable the use of memory-mapped I/O if the SQLITE_DISABLE_MMAP macro is defined. Automatically define this macro for OpenBSD and QNX. Other systems are likely to be added to the disabled list over time. (check-in: [8a4314a398] user: drh branch: trunk, size: 66399)
2013-04-03
13:09		[682e97f3e3] part of check-in [2d9f1327fe] Change the mmap_limit pragma to report the new limit, or to report the existing limit if called with no arguments. Report the default mmap_limit as part of PRAGMA compile_options. Set the default mmmap_limit to 0 for all systems other than linux, mac, windows, and solaris. (check-in: [2d9f1327fe] user: drh branch: experimental-mmap, size: 66345)
2013-04-01
22:38		[d0231f412d] part of check-in [78141d0a16] Add the SQLITE_CONFIG_MMAP_LIMIT configuration option for overriding the SQLITE_DEFAULT_MMAP_LIMIT compile-time setting. Enhance "PRAGMA mmap_limit" so that without a specific database name, it sets the limit on all database files and changes the default for any future databases that might be added using ATTACH. (check-in: [78141d0a16] user: drh branch: experimental-mmap, size: 66212)
2013-03-25
23:09		[8875d32d54] part of check-in [1b37c4effd] Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be used to issue a hint to the VFS to limit mmap space to N bytes. The VFS is free to ignore that hint if desired. However, if "PRAGMA mmap_limit(0)" is used, xFetch is never called. (check-in: [1b37c4effd] user: drh branch: experimental-mmap, size: 65851)
2013-03-19
19:28		[86c8088ac6] part of check-in [6183f1bd86] Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". (check-in: [6183f1bd86] user: dan branch: experimental-mmap, size: 65981)
2013-03-11
11:49		[9f0ee3d74a] part of check-in [938b91e855] Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. (check-in: [938b91e855] user: dan branch: omit-fixes, size: 65045)
2013-02-14
16:16		[bdb484d028] part of check-in [82952d08f3] Verify that the schema has not changed before running PRAGMA table_info, index_list, index_info, and foreign_key_list. (check-in: [82952d08f3] user: drh branch: trunk, size: 64974)
2013-01-29
19:14		[eb9d39e30f] part of check-in [ae565ff3e0] New debugging pragmas: PRAGMA vdbe_debug=ON is short-hand for the sql_trace, vdbe_listing, and vdbe_trace pragmas. PRAGMA vdbe_debug enables tracing of sqlite3VdbeAddOp() calls. None of this is active unless compiled with SQLITE_DEBUG. (check-in: [ae565ff3e0] user: drh branch: trunk, size: 64794)
2013-01-16
20:33		[b7ef175454] part of check-in [6195ebd833] Fix the activate_extensions pragma so that it is a no-op when the required argument is omitted. (check-in: [6195ebd833] user: drh branch: trunk, size: 64618)
2013-01-01
13:55		[8907c559d3] part of check-in [3076a89015] Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. (check-in: [3076a89015] user: drh branch: trunk, size: 64608)
2012-12-20
00:32		[1ff115f620] part of check-in [b5a8f3160b] Remove an unreachable branch operation from the foreign_key_check pragma. (check-in: [b5a8f3160b] user: drh branch: foreign-key-check, size: 64363)
2012-12-17
22:32		[312d9ea0d9] part of check-in [25411f83f9] Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. (check-in: [25411f83f9] user: drh branch: foreign-key-check, size: 64326)
20:57		[c6e9ed9de9] part of check-in [97f7f73772] Add to the foreign_key_check pragma an extra output column "parent" that contains the name of the parent table for the constraint that failed. (check-in: [97f7f73772] user: drh branch: foreign-key-check, size: 64196)
20:40		[5cc87af77d] part of check-in [0f9963526c] Enhance the error message for "foreign key mismatch" to include the names of the child and parent tables. Begin adding test cases for PRAGMA foreign_key_check. Make sure PRAGMA foreign_key_check gets all necessary table locks. (check-in: [0f9963526c] user: drh branch: foreign-key-check, size: 64012)
18:43		[b98dfe89b9] part of check-in [57d47423a6] "PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. (check-in: [57d47423a6] user: drh branch: foreign-key-check, size: 63863)
18:05		[599af02bcc] part of check-in [603b695bf0] Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. (check-in: [603b695bf0] user: drh branch: foreign-key-check, size: 62984)
16:46		[52adf60a59] part of check-in [01c980e9bb] Prototype for PRAGMA that checks all foreign key constraints on a table. (check-in: [01c980e9bb] user: drh branch: foreign-key-check, size: 62760)
2012-10-09
18:51		[015723c480] part of check-in [7b1a6e6cb5] Attempt to suppress warnings generated by Coverity. (check-in: [7b1a6e6cb5] user: drh branch: trunk, size: 59262)
2012-10-01
18:44		[4f31fe4ae4] part of check-in [1262d2f471] Add SQLITE_FCNTL_BUSYHANDLER. Invoked to provide access to the busy-handler callback to custom VFS implementations. (check-in: [1262d2f471] user: dan branch: trunk, size: 59294)
2012-09-28
10:57		[2b556a8a7a] part of check-in [6a5c59dd7e] Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. (check-in: [6a5c59dd7e] user: drh branch: apple-osx, size: 60200)
2012-09-27
12:11		[7f5a0fa6de] part of check-in [1a679a1ef3] Merge the "PRAGMA busy_timeout" change into trunk. (check-in: [1a679a1ef3] user: drh branch: trunk, size: 59265)
2012-09-21
00:04		[44304a69ae] part of check-in [79e922f7ae] Consolidate more of the DISTINCT processing logic into a single spot in the code. Reduce the number of OP_Column operations needed to perform a WHERE_DISTINCT_ORDERED. (check-in: [79e922f7ae] user: drh branch: trunk, size: 58755)
2012-09-13
14:22		[de7f3bc617] part of check-in [4163f5f194] Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. (check-in: [4163f5f194] user: drh branch: trunk, size: 58758)
2012-09-07
18:49		[360ac85ad9] part of check-in [7be5bc3679] Have PRAGMA busy_timeout return 0 if the busy handler has been changed or cancelled. (check-in: [7be5bc3679] user: drh branch: busy-timeout-pragma, size: 59220)
16:46		[e09950b9d0] part of check-in [22ebc66851] Add an experimental busy_timeout pragma to facilitate access to the sqlite3_busy_timeout() interfaces for programmers that are working from behind a language wrapper that does not expose that interface. (check-in: [22ebc66851] user: drh branch: busy-timeout-pragma, size: 59243)
2012-08-25
01:38		[bf2a8023aa] part of check-in [6723add4f4] Merge all the latest trunk changes into the apple-osx branch. (check-in: [6723add4f4] user: drh branch: apple-osx, size: 59644)
2012-07-16
10:06		[97f9357f0e] part of check-in [4353e40b74] If a specific database is nominated as part of a "PRAGMA integrity_check" or "PRAGMA quick_check" command, search for problems in the nominated database only. i.e. "PRAGMA main.quick_check" now only scans the main database, not all attached databases as before. (check-in: [4353e40b74] user: dan branch: trunk, size: 58710)
2012-06-08
01:13		[6d617d3e19] part of check-in [9d1b851562] Merge trunk changes into the apple-osx branch. (check-in: [9d1b851562] user: drh branch: apple-osx, size: 59005)
2012-06-06
23:23		[eee3e3161f] part of check-in [61360ca6ca] Merge the changes need to compile on WinRT into trunk. (check-in: [61360ca6ca] user: drh branch: trunk, size: 58071)
2012-05-15
18:28		[28d7955a9e] part of check-in [aa0c3493d3] The former sqlite3ResetInternalSchema() routine was really two different routines, selected by parameter, each with a confused mission. So split this routine up into three separate smaller routines, calling each separately as needed. Hopefully this will make further refactoring and schema reset collateral damage containment easier. (check-in: [aa0c3493d3] user: drh branch: shared-schema, size: 56495)
2012-03-14
00:44		[149d8400ff] part of check-in [7354ae8fd3] Add experimental support for resolving relative database file paths using a fixed user-defined directory. (check-in: [7354ae8fd3] user: mistachkin branch: winrt, size: 58042)
2012-03-05
16:39		[29db41fc84] part of check-in [504bf49086] Pull in all the latest trunk changes. (check-in: [504bf49086] user: drh branch: apple-osx, size: 57425)
2012-02-24
14:33		[e708b3bb57] part of check-in [3130275c64] Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. (check-in: [3130275c64] user: drh branch: trunk, size: 56491)
00:03		[11f5fff828] part of check-in [9e6d340f55] If the SQLITE_FCNTL_PRAGMA file control returns something other than SQLITE_NOTFOUND, then skip the rest of Pragma code generation. (check-in: [9e6d340f55] user: drh branch: trunk, size: 56511)
2012-02-22
19:56		[a6b1b209a1] part of check-in [5643618108] If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. (check-in: [5643618108] user: drh branch: file-control-pragma, size: 56507)
18:21		[c452bbbd2a] part of check-in [a1f29fa653] Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. (check-in: [a1f29fa653] user: drh branch: file-control-pragma, size: 56387)
16:58		[6838f56b04] part of check-in [fd8d744027] Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. (check-in: [fd8d744027] user: drh branch: file-control-pragma, size: 56329)
14:45		[4dfd5b263d] part of check-in [5be07904ba] Begin adding support for SQLITE_FCNTL_PRAGMA. (check-in: [5be07904ba] user: drh branch: file-control-pragma, size: 56016)
2012-02-10
18:18		[99f401037d] part of check-in [e248598649] Pull the latest trunk changes into the apple-osx branch. (check-in: [e248598649] user: drh branch: apple-osx, size: 56270)
2012-01-31
14:24		[350f59843f] part of check-in [77b3430de6] Futher pedantic fixes to the sqlite3_uri_boolean() interface. (check-in: [77b3430de6] user: drh branch: trunk, size: 55336)
2012-01-30
18:40		[8bf0fa7469] part of check-in [7b053d699f] Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] (check-in: [7b053d699f] user: drh branch: trunk, size: 55311)
2012-01-17
15:29		[dbad8484b9] part of check-in [96900c47e4] Remove the undocumented PRAGMA omit_readlock hack. (check-in: [96900c47e4] user: drh branch: trunk, size: 55200)
2012-01-14
14:13		[5868838281] part of check-in [2cc414cd14] Merge the latest trunk changes into the apple-osx branch. (check-in: [2cc414cd14] user: drh branch: apple-osx, size: 56192)
2012-01-10
17:59		[fb979b7b51] part of check-in [722735a4f3] Refactor sqlite3OsFileControlNoFail() into sqlite3FileControlHint(). (check-in: [722735a4f3] user: drh branch: trunk, size: 55258)
16:56		[492fabe0b3] part of check-in [af59b182d7] Add function sqlite3OsFileControlNoFail(), which is the same as sqlite3OsFileControl() except that it does not simulate OOM errors. This saves adding calls to the BenignMalloc() functions around each of the invocations of sqliteOsFileControl() that ignore the return code. (check-in: [af59b182d7] user: dan branch: trunk, size: 55260)
2011-12-08
21:08		[dae8d30795] part of check-in [59e0d4f3d9] Merge the latest trunk changes into the apple-osx branch. (check-in: [59e0d4f3d9] user: drh branch: apple-osx, size: 56188)
2011-11-16
19:29		[dd66f21faf] part of check-in [3f58e7c889] Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. (check-in: [3f58e7c889] user: drh branch: trunk, size: 55254)
2011-11-09
16:12		[65d1d63d64] part of check-in [bc10a75357] Minor changes needed to restore full branch test coverage. (check-in: [bc10a75357] user: drh branch: experimental-pcache, size: 55013)
14:23		[c5ba7627fb] part of check-in [b3faa680ae] A negative value N for the cache_size pragma adjusts the number of cache pages to use approximately N kibibytes of memory. (check-in: [b3faa680ae] user: drh branch: experimental-pcache, size: 54647)
2011-10-21
17:18		[a09bfb67bc] part of check-in [be62ef058b] Merge the latest trunk changes into the apple-osx branch. (check-in: [be62ef058b] user: drh branch: apple-osx, size: 55823)
2011-10-13
17:09		[da8ef96b3e] part of check-in [c3cb7f4fad] An improved fix for the page_count and quick_check problem previously patched at [150592b4b4d8637] (check-in: [c3cb7f4fad] user: drh branch: trunk, size: 54889)
14:41		[0a11a7b543] part of check-in [150592b4b4] Make sure the page_count and quick_check pragmas work properly even when their names are capitalized. Fixes a problem reported on the mailing list. (check-in: [150592b4b4] user: drh branch: trunk, size: 54865)
2011-10-11
14:19		[273515f029] part of check-in [7e2c489822] Merge the latest trunk changes into the apple-osx branch. (check-in: [7e2c489822] user: drh branch: apple-osx, size: 55791)
2011-10-10
12:04		[68d7db4fc9] part of check-in [c8ff2a4840] Fix a typo in a comment for PRAGMA journal_mode. Also amplify that same comment. (check-in: [c8ff2a4840] user: drh branch: trunk, size: 54857)
2011-06-25
21:43		[66661dbe84] part of check-in [c6158b254f] Changes to make pragma synchronous sticky when SQLITE_DEFAULT_WAL_SAFETYLEVEL is used (check-in: [c6158b254f] user: adam branch: apple-osx, size: 55683)
2011-06-24
20:47		[a1010255cd] part of check-in [34f0efa2b1] Merging local changes to apple-osx (check-in: [34f0efa2b1] user: adam branch: apple-osx, size: 55304)
2011-06-20
11:57		[2824f4c8f3] part of check-in [4c69e827f4] Merge the latest trunk changes into the apple-osx branch. (check-in: [4c69e827f4] user: drh branch: apple-osx, size: 54949)
2011-06-03
13:02		[ebcd20f1e6] part of check-in [051f4635bf] Fix the build when using SQLITE_OMIT_PRAGMA. (check-in: [051f4635bf] user: drh branch: trunk, size: 54749)
2011-05-19
01:51		[8756649386] part of check-in [8d1a6bb002] Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. (check-in: [8d1a6bb002] user: drh branch: apple-osx, size: 54798)
2011-04-22
19:37		[9e778decc3] part of check-in [b8a8132e71] Add the start of the "uri-filenames" feature. (check-in: [b8a8132e71] user: dan branch: uri, size: 54598)
2011-04-05
13:38		[1785e42ea5] part of check-in [8e885ddea0] Pull the latest changes from trunk (and hence from schema-parse-refactor) into the apple-osx branch. (check-in: [8e885ddea0] user: drh branch: apple-osx, size: 54770)
13:12		[49c90ab27a] part of check-in [5db4511d8a] Merge the scheme-parse-refactor changes into trunk: (1) added sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean "all" in sqlite3ResetInternalSchema(), and other cosmetic changes. (check-in: [5db4511d8a] user: drh branch: trunk, size: 54570)
12:25		[65698dc369] part of check-in [bf664b206b] Fix the P4_TRANSIENT constant so that it works correct - so that it really makes a copy of the string for the P4 argument. Use P4_TRANSIENT wherever appropriate. Change P4_STATICs of schema names to P4_TRANSIENT. (check-in: [bf664b206b] user: drh branch: trunk, size: 54415)
2011-04-04
18:22		[36eec9129b] part of check-in [ae8374af05] Add a description of access rules for the Schema object and lots of asserts to verify that the access rules are followed. (check-in: [ae8374af05] user: drh branch: schema-parse-refactor, size: 54564)
13:11		[7e1eb402cf] part of check-in [6d78a25ddc] Merge in the latest changes from trunk. (check-in: [6d78a25ddc] user: drh branch: apple-osx, size: 54609)
2011-04-02
16:28		[672c5e453d] part of check-in [6a8ad6e31e] Begin a series of changes designed to reduce the scope and frequency of invalidating schemas. Design goals are that the internal schema should never be deleted out from under a prepared statement that is running and that all prepared statements should be expired if the schema is invalidated. At the same time, minimize the number of schema invalidations. This change merely revises the sqlite3ResetInternalSchema() function to use -1 as the wildcard for "all" rather than 0, so that we can reset the main schema independently of all the others. (check-in: [6a8ad6e31e] user: drh branch: schema-parse-refactor, size: 54410)
2011-03-08
02:38		[4221eb822d] part of check-in [2d5800bd8c] Fix additional cases of possible signed integer overflow, especially with regard to negation. (check-in: [2d5800bd8c] user: drh branch: trunk, size: 54409)
2011-02-07
23:56		[a83f320497] part of check-in [f611a5a879] Cleanup to the OP_Checkpoint opcode. (check-in: [f611a5a879] user: drh branch: trunk, size: 54441)
2011-02-02
16:34		[3d48a7f0a9] part of check-in [bac7342c36] Merge in the blocking-checkpoint enhancement, including the new sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. (check-in: [bac7342c36] user: drh branch: trunk, size: 54438)
2010-12-07
15:49		[3ff495d7f9] part of check-in [d2ccf7fc06] Merge in all changes to the trunk through version 3.7.4rc3. (check-in: [d2ccf7fc06] user: drh branch: apple-osx, size: 54013)
2010-11-23
18:59		[8a6cd3c787] part of check-in [2031974b60] Fix the max_page_count pragma so that it will not set to a value smaller than the current database size, as the documentation requires. Also, remove all occurances of atoi() from the core. (check-in: [2031974b60] user: drh branch: trunk, size: 53813)
2010-11-19
23:50		[a56ea45dea] part of check-in [c8bc057c7d] Merge all the latest changes from the trunk into the apple-osx branch. (check-in: [c8bc057c7d] user: drh branch: apple-osx, size: 54146)
18:51		[900f480cc2] part of check-in [ebf74015f0] Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. (check-in: [ebf74015f0] user: drh branch: blocking-checkpoint, size: 54565)
18:23		[8e87e9e3e8] part of check-in [a069867301] Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. (check-in: [a069867301] user: drh branch: trunk, size: 53940)
2010-11-18
12:11		[f843c87784] part of check-in [72787c010c] Modify the interface to the blocking wal-checkpoint functionality. (check-in: [72787c010c] user: dan branch: blocking-checkpoint, size: 54455)
2010-11-16
18:56		[66a8b53d1e] part of check-in [7e3fc2c833] Add experimental command "PRAGMA wal_blocking_checkpoint", which uses the busy-handler to block until all readers have finished in order to ensure the next writer will be able to wrap around to the start of the log file. (check-in: [7e3fc2c833] user: dan branch: blocking-checkpoint, size: 54065)
2010-11-09
20:08		[6a641dec2c] part of check-in [756589ad6e] Add "PRAGMA checkpoint_fullfsync". Similar to "PRAGMA fullfsync", but enables full fsyncs only during checkpoint operations. Update: This change was added to the trunk by check-in [a069867301de3ca2e17] (check-in: [756589ad6e] user: dan branch: apple-osx-exp, size: 54090)
00:47		[bbc722cbf7] part of check-in [77b343cfc3] Experimental changes to test defaulting to fullfsync for WAL mode (check-in: [77b343cfc3] user: adam branch: apple-osx-exp, size: 54144)
2010-09-30
00:50		[216d12e454] part of check-in [14eed3a0e0] Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. (check-in: [14eed3a0e0] user: drh branch: experimental, size: 53830)
2010-08-18
00:24		[3dbb254a99] part of check-in [866e9286ae] Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. (check-in: [866e9286ae] user: drh branch: apple-osx, size: 54014)
00:09		[055115ce2b] part of check-in [5e2ee7db0f] Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments (check-in: [5e2ee7db0f] user: adam branch: apple-osx, size: 54011)
2010-08-07
11:46		[6ee4275389] part of check-in [f88c6367d2] Merge in all changes up to the 3.7.0.1 release. (check-in: [f88c6367d2] user: drh branch: apple-osx, size: 54034)
2010-07-24
16:34		[8b24ce00a9] part of check-in [ac1f37a647] Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). (check-in: [ac1f37a647] user: drh branch: malloc-enhancement, size: 53808)
2010-07-08
17:40		[4a79269ea6] part of check-in [e396184cd3] Change the journal_mode pragma to remove the "default journal mode" concept. The journal_mode pragma only effects currently attached databases and does not change the behavior of future attachments. (check-in: [e396184cd3] user: drh branch: trunk, size: 53805)
2010-07-07
14:33		[ca1a563480] part of check-in [d94269e60d] Fix a compiler warning in PRAGMA journal_mode. (check-in: [d94269e60d] user: drh branch: trunk, size: 54192)
13:54		[7d76fe052e] part of check-in [ef126e775a] Make sure the schema is loaded before preparing a "PRAGMA journal_mode" command. This helps it return meaningful results when it is the first command executed by a new database connection. (check-in: [ef126e775a] user: dan branch: trunk, size: 54189)
2010-06-16
19:48		[cd1f514091] part of check-in [21ca87f691] Merge in changes up to and including the 3.6.23.1 release. (check-in: [21ca87f691] user: drh branch: apple-osx, size: 53093)
2010-05-06
21:37		[423865323a] part of check-in [c3520460a4] The PRAGMA journal_mode=WAL; command now makes WAL the default journal mode for new databases added with ATTACH, so the behavior is consistent with the other journal modes. (check-in: [c3520460a4] user: drh branch: trunk, size: 54122)
2010-05-03
15:58		[b9a0a173d5] part of check-in [7fecd21f45] Have sqlite3_wal_checkpoint() handle a zero-length string in the same way as a NULL pointer. Fix "PRAGMA wal_checkpoint" so that it checkpoints all attached databases. (check-in: [7fecd21f45] user: dan branch: trunk, size: 54195)
13:37		[5fa66bc24b] part of check-in [11a85b821a] Make sure the mutex is held while calling sqlite3ApiExit() in sqlite3_wal_checkpoint(). Other cleanup of WAL logic. (check-in: [11a85b821a] user: drh branch: wal, size: 54167)
11:05		[4540555271] part of check-in [714e594726] Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint". (check-in: [714e594726] user: dan branch: wal, size: 54090)
08:04		[97c6054d78] part of check-in [9803196dec] Add the sqlite3_wal_checkpoint() and sqlite3_wal_autocheckpoint() APIs. (check-in: [9803196dec] user: dan branch: wal, size: 53543)
2010-05-01
16:40		[3d4ba9c354] part of check-in [9b230c43df] Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. (check-in: [9b230c43df] user: dan branch: wal, size: 53577)
2010-04-27
01:56		[5ba364af02] part of check-in [7a0ac682c3] Merge in recent changes from the trunk (check-in: [7a0ac682c3] user: drh branch: wal, size: 53428)
2010-04-26
17:36		[71ba42f5a6] part of check-in [36fb2cae75] Change the default_cache_size pragma to always store a positive value. (check-in: [36fb2cae75] user: drh branch: trunk, size: 52808)
2010-04-20
18:53		[bae3ce82ca] part of check-in [96bef18c14] Use the read and write version fields of the database header to mark a database as operating in wal-mode. (check-in: [96bef18c14] user: dan branch: wal, size: 53643)
2010-04-14
11:23		[f12cb58a8a] part of check-in [a9617eff39] Fixes for locking issues in WAL mode. (check-in: [a9617eff39] user: dan branch: wal, size: 53219)
2010-04-13
11:56		[9f1d53d40b] part of check-in [27dc5977c1] Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". (check-in: [27dc5977c1] user: dan branch: wal, size: 53269)
2010-04-12
19:32		[5a68ee9ad2] part of check-in [c15fda145b] Remove duplicate secure_delete pragma implemention. (check-in: [c15fda145b] user: drh branch: wal, size: 53651)
19:00		[55f3405051] part of check-in [409d61baeb] Import experimental write-ahead-logging code. (check-in: [409d61baeb] user: dan branch: wal, size: 54333)
2010-04-07
16:54		[e166ea4154] part of check-in [a811a47fbe] Wrap all automatic index changes inside SQLITE_OMIT_AUTOMATIC_INDEX. Add the automatic_index PRAGMA to turn it on and off. (check-in: [a811a47fbe] user: drh branch: experimental, size: 53023)
2010-02-26
22:05		[4cf0b84933] part of check-in [5c0afe70a5] fix merge error and compiler warning (check-in: [5c0afe70a5] user: adam branch: apple-osx, size: 52662)
15:39		[56d95f7615] part of check-in [733778df99] Remove the compile_option pragma (retaining compile_options - with an "s"). Updates to documentation. (check-in: [733778df99] user: drh branch: trunk, size: 52922)
2010-02-25
15:28		[d610d4f4fc] part of check-in [633d874783] Minor simplifications to the compile-time option reporting functions and pragmas to facilitate coverage testing. (check-in: [633d874783] user: drh branch: trunk, size: 53241)
14:56		[f37f33665b] part of check-in [b8fbf4275b] Expire pragma statements when reset, even if they were not run to completion. (check-in: [b8fbf4275b] user: drh branch: branch-3.6.22, size: 51705)
14:47		[edaded19e5] part of check-in [78351d289b] Expire pragma statements when reset, even if they were not run to completion. (check-in: [78351d289b] user: drh branch: trunk, size: 53252)
2010-02-23
20:08		[1ee3a5bea3] part of check-in [76a0294ab4] Refactored compile time option diagnostic support to use strings identifiers instead of bitmask. (check-in: [76a0294ab4] user: shaneh branch: compile_opts, size: 53449)
2010-02-17
19:34		[43e02b0258] part of check-in [4b72e39bd0] Merge latest changes from the trunk into the apple-osx branch. (check-in: [4b72e39bd0] user: drh branch: apple-osx, size: 52657)
17:48		[5febf8b5d8] part of check-in [34a3413a53] Consistent use of #ifdef for SQLITE_HAS_CODEC to avoid confusion. (check-in: [34a3413a53] user: shaneh branch: trunk, size: 52491)
2010-02-12
19:46		[55cfa9daa1] part of check-in [2bb38bb96f] Enhancements to the secure_delete pragma to make it easier to use. (check-in: [2bb38bb96f] user: drh branch: trunk, size: 52476)
18:18		[c0591d6f77] part of check-in [f72f8a870a] Allow the secure-delete setting to be changed at run-time using a pragma. The SQLITE_SECURE_DELETE compile-time option determines the default setting. (check-in: [f72f8a870a] user: drh branch: trunk, size: 52329)
2010-01-28
19:56		[5644b2cc76] part of check-in [299f74567b] Tweaks for consistency to the SEE and CEROD API declarations in sqlite3.h. (check-in: [299f74567b] user: shaneh branch: trunk, size: 51794)
2009-12-22
00:29		[c194fc1357] part of check-in [1d8550e5c8] Add a pragma to disable the query flattener - for use during testing. (check-in: [1d8550e5c8] user: drh branch: trunk, size: 51997)
2009-12-07
23:53		[eda3d6d165] part of check-in [ad08794d72] Merge all changes associated with the version 3.6.21 release into the OS-X branch. (check-in: [ad08794d72] user: drh branch: apple-osx, size: 52057)
2009-11-12
20:39		[6936d7df5e] part of check-in [6705ab1ad1] Shift more OP_Found opcodes over to using the unpacked format, for improved performance. (check-in: [6705ab1ad1] user: drh branch: trunk, size: 51902)
19:59		[0057a8838e] part of check-in [b9eab885cd] Enhance the OP_Found and OP_NotFound opcodes so that they can accept an array of registers as an unpacked record in addition to a record built using OP_MakeRecord. Use this to avoid OP_MakeRecord calls during IN expression processing. (check-in: [b9eab885cd] user: drh branch: trunk, size: 51864)
2009-11-10
01:30		[97031c9f38] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 51858)
2009-11-03
22:34		[840143b9e0] part of check-in [941a01eb86] Customizations for OSX contributed by Apple. (check-in: [941a01eb86] user: adam branch: apple-osx, size: 52079)
2009-09-23
08:43		[c25d0d15dd] part of check-in [540c2d18e1] Add missing comments to fkey.c. Also, change the terminology used for comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow. (check-in: [540c2d18e1] user: dan branch: trunk, size: 51924)
2009-09-22
07:13		[031ab58ada] part of check-in [c447cb37d6] Fix compilation errors when OMIT_FOREIGN_KEY is defined. (check-in: [c447cb37d6] user: dan branch: trunk, size: 51924)
2009-09-21
16:06		[c75db24792] part of check-in [fb6ceed388] Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: [fb6ceed388] user: dan branch: trunk, size: 51885)
2009-09-19
17:00		[254c21536e] part of check-in [d5d3998118] Check in implementation of foreign key constraints. (check-in: [d5d3998118] user: dan branch: trunk, size: 51498)
2009-09-01
17:11		[0a3b314193] part of check-in [e016cca363] Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. (check-in: [e016cca363] user: dan branch: trunk, size: 51323)
2009-08-30
11:42		[6b1fa9f180] part of check-in [9eb91efda5] Fixes for new triggers scheme. (check-in: [9eb91efda5] user: dan branch: trunk, size: 51327)
2009-07-02
07:47		[9eb44ac1d3] part of check-in [e3c055f167] Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) (check-in: [e3c055f167] user: danielk1977 branch: trunk, size: 51267)
2009-06-19
14:06		[1774ff8e2f] part of check-in [37ae5f5e8f] Reorganize and cleanup the prepared statement object. Remove code that has been commented out for ages and is no longer relevant to anything. (CVS 6786) (check-in: [37ae5f5e8f] user: drh branch: trunk, size: 51022)
2009-06-03
11:25		[06b3a4b93a] part of check-in [6dbf4eca00] Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) (check-in: [6dbf4eca00] user: danielk1977 branch: trunk, size: 51379)
2009-05-28
01:00		[d4a6fd74fd] part of check-in [4ac2bdfbb4] Additional refinements to Expr handling. Restore compression of trigger expressions. Change Expr.zToken to Expr.u.zToken and added Expr.u.iValue. Remove an unnecessary ExprDup from CHECK constraint processing. And so forth. (CVS 6682) (check-in: [4ac2bdfbb4] user: drh branch: trunk, size: 51253)
2009-05-27
10:31		[cf9adc601f] part of check-in [7cb1c3ba07] Simplifications to the Expr object: Remove Expr.span completely and convert Expr.token into a char* Expr.zToken. Also simplify the Token object by removing the Token.dyn and Token.quoted fields. (CVS 6681) (check-in: [7cb1c3ba07] user: drh branch: trunk, size: 51253)
2009-04-07
22:05		[c26c16c49a] part of check-in [22999d3141] Remove two unused tests from the integrity_check pragma logic. (CVS 6466) (check-in: [22999d3141] user: drh branch: trunk, size: 51322)
00:49		[e48136fdf4] part of check-in [909683b342] Remove an unused test for EXPLAIN-mode in the PRAGMA processing. (CVS 6459) (check-in: [909683b342] user: drh branch: trunk, size: 51391)
00:43		[a89252bf02] part of check-in [567cf90b03] Always enable WHERE-tracing on a test build. Oops - accidentally included a debugging change to pragma.c in this check-in. The real fix for the pragma problem is in the following checking. (CVS 6458) (check-in: [567cf90b03] user: drh branch: trunk, size: 51433)
2009-04-04
16:02		[c7a237e4dc] part of check-in [8193125961] Allow the journal_size_limit to be larger than 2147483647 bytes. (CVS 6449) (check-in: [8193125961] user: drh branch: trunk, size: 51427)
2009-04-02
20:16		[32a967b5fc] part of check-in [85e6a4740d] Make sure the VACUUM statement locks down the page_size and auto_vacuum modes after it runs. Otherwise, pragmas might change these settings on a populated database, resulting in problems. (CVS 6442) (check-in: [85e6a4740d] user: drh branch: trunk, size: 51335)
2009-02-23
16:52		[22ed04836a] part of check-in [bc078e0007] Add the reverse_unordered_selects pragma. (CVS 6314) (check-in: [bc078e0007] user: drh branch: trunk, size: 51332)
2009-02-19
14:39		[9ed2acb94e] part of check-in [d9f6ffbc5e] Changes to reduce the heap space consumed by triggers, views and tables in the in-memory representation of the schema. Also to reduce the space used by prepared statements slightly. (CVS 6305) (check-in: [d9f6ffbc5e] user: danielk1977 branch: trunk, size: 51281)
2009-01-20
16:53		[04c13c79fd] part of check-in [1041abd678] When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) (check-in: [1041abd678] user: danielk1977 branch: trunk, size: 51312)
2009-01-13
20:14		[5b7ac60366] part of check-in [b5927213b6] Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172) (check-in: [b5927213b6] user: drh branch: trunk, size: 51316)
2009-01-09
21:41		[ec9470bc3e] part of check-in [64c56226b9] Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) (check-in: [64c56226b9] user: drh branch: trunk, size: 51290)
2008-12-10
23:04		[d6dfc47979] part of check-in [0a1888a7e6] More code obfuscation designed to thwart compiler warning messages. (CVS 6015) (check-in: [0a1888a7e6] user: drh branch: trunk, size: 49797)
22:15		[c77ac9952d] part of check-in [258722b617] Fix an issue with the new sqlite3Strlen30() introduced by check-in (6007). Additional casts for compiler warnings. (CVS 6011) (check-in: [258722b617] user: drh branch: trunk, size: 49793)
19:26		[ad7c6eef96] part of check-in [c872d55493] Never use strlen(). Use our own internal sqlite3Strlen30() which is guaranteed to never overflow an integer. Additional explicit casts to avoid nuisance warning messages. (CVS 6007) (check-in: [c872d55493] user: drh branch: trunk, size: 49771)
17:20		[88050d5afa] part of check-in [e7e9fa4fa1] Remove or rename local variables that shadow other variables or parameters. (CVS 6005) (check-in: [e7e9fa4fa1] user: drh branch: trunk, size: 49744)
2008-11-21
00:10		[539e28c90e] part of check-in [b9bc36d3d5] Added support for proxy file locking style Added pragma support for controlling proxy file locking Added file control access to last errno and proxy locking Added support for TMPDIR environment variable Extended unit tests to cover new proxy locking pragmas and file control features (CVS 5934) (check-in: [b9bc36d3d5] user: aswift branch: trunk, size: 49830)
2008-11-17
19:18		[0a5051029c] part of check-in [8009220c36] Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) (check-in: [8009220c36] user: danielk1977 branch: trunk, size: 48364)
2008-11-10
19:24		[5d4333a27e] part of check-in [83caa22087] Updated comment in source. Ticket #3453. (CVS 5874) (check-in: [83caa22087] user: shane branch: trunk, size: 48371)
2008-10-31
10:53		[e8b5a6a92f] part of check-in [bfce91429b] Change the way sqlite3VdbeSetColName() is called so as to remove a few lines of code. This also fixes #3470. (CVS 5853) (check-in: [bfce91429b] user: danielk1977 branch: trunk, size: 48368)
2008-10-23
05:45		[1eb8dad728] part of check-in [0e448bc609] Fix a bug in pragma table_info. Column default values specified as negative numbers (col DEFAULT -1) were being reported as NULL by the pragma. (CVS 5839) (check-in: [0e448bc609] user: danielk1977 branch: trunk, size: 48224)
2008-10-17
18:51		[10d61f211d] part of check-in [39ebf01add] Add "pragma journal_mode=memory". Change the way rollback works for in-memory databases so that it reuses the journal_mode=memory code. (CVS 5830) (check-in: [39ebf01add] user: danielk1977 branch: trunk, size: 48214)
2008-10-10
17:47		[f0f48d0d50] part of check-in [3bb33cf59d] Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) (check-in: [3bb33cf59d] user: danielk1977 branch: trunk, size: 48136)
2008-09-26
21:08		[0b1c2d2a24] part of check-in [7c561f2e92] Add the "truncate" journal mode which commits transactions by truncating the rollback journal file to zero length and not calling fsync(). (CVS 5745) (check-in: [7c561f2e92] user: drh branch: trunk, size: 47321)
2008-09-16
14:38		[e633b6b7da] part of check-in [e8418588f2] If the xAccess() call used by "PRAGMA temp_store_directory = /new/path/" to determine if the supplied directory is writable returns an error, assume the directory is not writable. (CVS 5707) (check-in: [e8418588f2] user: danielk1977 branch: trunk, size: 47223)
2008-09-02
15:44		[9d00ed41b2] part of check-in [43f757c9f0] Add an extra 'const' qualifier to two arrays (in func.c and pragma.c) to ensure that they do not consume space in the data segment of the compiled object files. (CVS 5663) (check-in: [43f757c9f0] user: danielk1977 branch: trunk, size: 47185)
00:52		[9d8127ac15] part of check-in [ef26ea5c46] Continuing work on adding full support for the SQLITE_OMIT_WSD compile-time option. (CVS 5658) (check-in: [ef26ea5c46] user: drh branch: trunk, size: 47176)
2008-08-20
16:34		[f5b271b090] part of check-in [d0cfbbbaee] When a "pragma main.table_info(...)" is issued, consider only tables from the main database, not the temp db. Ticket #3320. (CVS 5568) (check-in: [d0cfbbbaee] user: danielk1977 branch: trunk, size: 47131)
2008-07-28
19:34		[6e207b4f69] part of check-in [e48f9697e9] Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) (check-in: [e48f9697e9] user: drh branch: trunk, size: 47111)
2008-07-08
07:35		[6fad83fbcc] part of check-in [92e0cf9a08] Prohibit the user from changing the temporary storage medium (pragma temp_store) while there is a read transaction open on the temporary database. Add tests to shared.test to cover a few more lines in btree.c. (CVS 5362) (check-in: [92e0cf9a08] user: danielk1977 branch: trunk, size: 47109)
2008-06-26
10:54		[9a95f5b370] part of check-in [1e3b830802] Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) (check-in: [1e3b830802] user: danielk1977 branch: trunk, size: 47064)
2008-06-22
12:37		[e6c55362d1] part of check-in [663a590e30] Fix a bug in the KEYINFO handling within select.c. Change the OP_Move opcode to take a count and to move multiple registers. Initial code for the compound-select merge optimization is added but is incomplete and is commented out. (CVS 5272) (check-in: [663a590e30] user: drh branch: trunk, size: 47028)
2008-06-05
11:39		[70e7c865dc] part of check-in [4226ac54be] Modify the signatures of the sqlite3_vfs.xAccess and sqlite3_vfs.xCheckReservedLock functions. (CVS 5188) (check-in: [4226ac54be] user: danielk1977 branch: trunk, size: 47033)
2008-06-04
06:45		[c6dfbd16ff] part of check-in [5c59f469d0] Add "pragma journal_size_limit", used to limit the space consumed by persistent journal files left in the file-system after a transaction has concluded in exclusive (or journal_mode=persist) mode. (CVS 5185) (check-in: [5c59f469d0] user: danielk1977 branch: trunk, size: 46986)
2008-05-15
17:48		[a4919a29a0] part of check-in [eb6985e69c] Add the "page_count" pragma. Returns a single integer - the number of pages in the specified database file. (CVS 5135) (check-in: [eb6985e69c] user: danielk1977 branch: trunk, size: 46414)
2008-04-17
20:59		[2e4bb2e76e] part of check-in [4a72a7bb9c] Continuing progress on the journal_mode pragma. It still does not work. (CVS 5027) (check-in: [4a72a7bb9c] user: drh branch: trunk, size: 45849)
17:02		[113f14da85] part of check-in [8eaa0c7102] Add the journal_mode pragma. This is currently just syntax - it is not operational. (CVS 5024) (check-in: [8eaa0c7102] user: drh branch: trunk, size: 45800)
2008-03-27
22:42		[e659c9e443] part of check-in [3cb704c4c4] Allow the xAccess method in the VFS to return -1 to signal an I/O error, and in particular an SQLITE_IOERR_NOMEM. (CVS 4925) (check-in: [3cb704c4c4] user: drh branch: trunk, size: 43840)
2008-03-25
17:23		[99cec6d99d] part of check-in [ee381b4356] Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather than a record formed using {quote: MakeRecord.} This avoids a needless packing and unpacking of the record to be deleted. (CVS 4916) (check-in: [ee381b4356] user: drh branch: trunk, size: 43838)
2008-03-20
11:04		[f64eed9145] part of check-in [871df0e7c3] Allow a VACUUM operation to change the page-size in the same way as it can be used to change a database between auto-vacuum and normal mode. (CVS 4896) (check-in: [871df0e7c3] user: danielk1977 branch: trunk, size: 43843)
2008-03-19
00:21		[09128fe3e2] part of check-in [24e769972e] Remove the dependency on the direct btree interface from as many test scripts as is practical. Fix a bug in the output limiter of the integrity_check pragma that came up while making this change. (CVS 4880) (check-in: [24e769972e] user: drh branch: trunk, size: 43792)
2008-02-13
18:25		[e3f39f8576] part of check-in [990237e27e] Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) (check-in: [990237e27e] user: danielk1977 branch: trunk, size: 43663)
2008-01-22
01:48		[2bb8d6882b] part of check-in [2a0bc1e186] Changes to lemon to generate additional comments in the output file and to remove unreachable code. Additional test cases for improved test coverage. (CVS 4736) (check-in: [2a0bc1e186] user: drh branch: trunk, size: 43612)
2008-01-17
16:22		[155315ee3e] part of check-in [706b41b70b] Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) (check-in: [706b41b70b] user: drh branch: trunk, size: 43604)
02:36		[0768de04ea] part of check-in [b3a141b2b0] Registerification of the WHERE clause logic. (CVS 4716) (check-in: [b3a141b2b0] user: drh branch: trunk, size: 43595)
2008-01-12
21:35		[b4e77e0579] part of check-in [110c000d86] The sqlite3_trace() callback now prints a message as each trigger fires within a statement. (CVS 4709) (check-in: [110c000d86] user: drh branch: trunk, size: 43595)
2008-01-10
23:50		[1d3d9deefc] part of check-in [8cbd46517f] More work toward converting the VM into a register-based machine. (CVS 4704) (check-in: [8cbd46517f] user: drh branch: trunk, size: 43580)
2008-01-09
23:04		[bc6063d91d] part of check-in [e3cf1c1c11] All essential opcodes can now operate out of registers and completely avoid the stack. Many still optionally use the stack to support legacy code generation, but the stack is not required. The next step is to update all code generation to avoid using the stack. (CVS 4700) (check-in: [e3cf1c1c11] user: drh branch: trunk, size: 43082)
02:15		[355d53bc64] part of check-in [92deff07bb] Continued work toward converting to a register-based VM. (CVS 4698) (check-in: [92deff07bb] user: drh branch: trunk, size: 42984)
2008-01-07
19:20		[ebf841efcc] part of check-in [aa48867cfa] Registerify the AUTOINCREMENT processing and the OP_IsNull and OP_NotNull operators. (CVS 4692) (check-in: [aa48867cfa] user: drh branch: trunk, size: 43004)
2008-01-05
16:29		[dfb200ec38] part of check-in [66396d2f02] Registerify binary operators. Add register tracing to debugging output. (CVS 4686) (check-in: [66396d2f02] user: drh branch: trunk, size: 42999)
05:20		[1627b350b4] part of check-in [3e8a07dd3c] Register-ify the OP_AddImm and all casting opcodes. Omit the OP_MemIncr opcode. (CVS 4683) (check-in: [3e8a07dd3c] user: drh branch: trunk, size: 42921)
04:06		[6f5918141e] part of check-in [cc149eb9ca] Get rid of OP_Dup, OP_MemStore, OP_MemLoad, and OP_MemMove. Replace with OP_Copy, OP_SCopy, and OP_Move. Add the infrastructure for operation properties in1, in2, in3, out2, and out3 but do not yet use any of these. (CVS 4682) (check-in: [cc149eb9ca] user: drh branch: trunk, size: 42923)
2008-01-04
22:01		[ff8841222b] part of check-in [fe057a88d0] Implement the out2-prerelease opcode design pattern. (CVS 4681) (check-in: [fe057a88d0] user: drh branch: trunk, size: 42923)
2008-01-03
18:03		[ac8d91bb15] part of check-in [0b849805c3] Registers (aka memory cells) in the VM are now numbered starting with 1 instead of 0. A register number of 0 means "no such register". (CVS 4669) (check-in: [0b849805c3] user: drh branch: trunk, size: 42916)
01:28		[61b9d171a6] part of check-in [4dc507d87b] Revamp sqlite3VdbeAddOpList() so that the structure holds integer values for P1, P2, and P3. (CVS 4661) (check-in: [4dc507d87b] user: drh branch: trunk, size: 42916)
00:01		[036e49b88c] part of check-in [027875e4d4] Refactoring the VM. The P3 parameter is changed to P4. A P5 parameter is added (though not currently used.) Add routines sqlite3VdbeAddOpX() where X is one of 0, 1, 2, 3, or 4. (CVS 4660) (check-in: [027875e4d4] user: drh branch: trunk, size: 42634)
2008-01-02
00:34		[4a7f377a50] part of check-in [051ec01f27] Begin setting a foundation on which to convert the VM from a stack-based to a register-based machine. Everything is still mostly stack based with this check-in. This change merely begins adding infrastructure to support a register-based architecture. (CVS 4652) (check-in: [051ec01f27] user: drh branch: trunk, size: 42480)
2007-12-29
13:39		[dd5b198316] part of check-in [2ddc8d7272] Add experimental pragma "quick_check", a reduced version of integrity_check that runs without most of the overhead of the full integrity_check. (CVS 4645) (check-in: [2ddc8d7272] user: danielk1977 branch: trunk, size: 42456)
2007-12-13
21:54		[2a5f643999] part of check-in [4e91a267fe] Change all instances of "it's" in comments to either "its" or "it is", as appropriate, in case the comments are ever again read by a pedantic grammarian. Ticket #2840. (CVS 4629) (check-in: [4e91a267fe] user: drh branch: trunk, size: 42155)
2007-12-05
01:38		[0246032dbe] part of check-in [bdfc19e838] Add the ability to change the autovacuum status of an existing database by setting the auto_vacuum pragma then running the VACUUM command. (CVS 4592) (check-in: [bdfc19e838] user: drh branch: trunk, size: 42156)
2007-11-13
10:30		[cb1486e76d] part of check-in [7bb00c7df6] Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542) (check-in: [7bb00c7df6] user: danielk1977 branch: trunk, size: 42133)
2007-08-31
18:34		[363e548daf] part of check-in [306586c412] Remove the xLockState method for sqlite3_io_methods. Replace it with a defined call to xFileControl(). This simplifies the interface and also gives us coverage testing of sqlite3_file_control(). (CVS 4355) (check-in: [306586c412] user: drh branch: trunk, size: 41843)
2007-08-30
10:07		[59a5e12ad0] part of check-in [41550d87c9] Better handle a malloc() failure in sqlite3PagerSetPagesize(). (CVS 4332) (check-in: [41550d87c9] user: danielk1977 branch: trunk, size: 41778)
01:19		[65109b3d6a] part of check-in [e40d40a5d4] Fix for the sqlite3AbortOtherActiveVdbes() problem. (CVS 4328) (check-in: [e40d40a5d4] user: drh branch: trunk, size: 41555)
2007-08-21
10:44		[9b989506a1] part of check-in [fbbd5bda54] Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) (check-in: [fbbd5bda54] user: drh branch: trunk, size: 41447)
2007-08-17
15:53		[8f5e37c3cf] part of check-in [af3e3c7acd] Begin migration to using sqlite3_vfs interface. (CVS 4240) (check-in: [af3e3c7acd] user: danielk1977 branch: trunk, size: 41569)
2007-08-16
10:09		[873b0b2ab5] part of check-in [77b1671351] More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) (check-in: [77b1671351] user: danielk1977 branch: trunk, size: 41526)
04:30		[9ecc2bcd79] part of check-in [deb7ecd65f] Half-way through a major refactoring of the memory allocation. I have not even attempted to compile so I am certain there are countless errors. (CVS 4231) (check-in: [deb7ecd65f] user: drh branch: trunk, size: 41514)
2007-06-26
10:38		[7914a6b9ea] part of check-in [7f887a6a00] Allow virtual tables to mark columns as 'hidden'. Hidden columns do not show up in "*" expansion, the implicit column list of an INSERT statement, or the results of a "PRAGMA table_info" statement. (CVS 4127) (check-in: [7f887a6a00] user: danielk1977 branch: trunk, size: 41504)
2007-06-25
08:16		[838f7460e6] part of check-in [5b0408ddd0] Make the auto_vacuum mode peristent in all cases. (CVS 4115) (check-in: [5b0408ddd0] user: danielk1977 branch: trunk, size: 41386)
2007-06-24
08:00		[d2e6f5da99] part of check-in [1fb4251a70] Add the "(database.)freelist_count" PRAGMA. For querying the size of the database free-list. (CVS 4112) (check-in: [1fb4251a70] user: danielk1977 branch: trunk, size: 39832)
2007-05-23
13:50		[0d25dad58b] part of check-in [efd7bcb34c] Make sure the database schema has been read before compiling an incrmental_vacuum pragma. (CVS 4032) (check-in: [efd7bcb34c] user: danielk1977 branch: trunk, size: 39611)
2007-05-11
12:30		[6d5eb19fee] part of check-in [2f70159b1d] Avoid multiple storage class specifiers ("static extern") in the amalagmation. (CVS 3984) (check-in: [2f70159b1d] user: drh branch: trunk, size: 39537)
2007-05-08
20:59		[0703152b9e] part of check-in [5a0fe98548] Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) (check-in: [5a0fe98548] user: drh branch: trunk, size: 39588)
14:51		[b881b45717] part of check-in [b1b74f0668] Add the max_page_count pragma used to limit the maximum size of a database file. Untested. (CVS 3948) (check-in: [b1b74f0668] user: drh branch: trunk, size: 39561)
01:08		[f426fef6b0] part of check-in [93b623b232] Begin implementing a new system of upper bounds on the capabilities of SQLite. By clearly defining the upper bounds, we make those upper bounds explicitly testable. This check-in is just infrastructure. The upper bounds are not yet enforced. (CVS 3941) (check-in: [93b623b232] user: drh branch: trunk, size: 38968)
2007-05-04
18:30		[3f16c1274b] part of check-in [b13e497a32] Change incremental vacuum to be triggered by a pragma rather than a command. We have a lot to learn about this yet and we do not want to paint ourselves into a corner by commiting to specific syntax too early. (CVS 3921) (check-in: [b13e497a32] user: drh branch: trunk, size: 38952)
2007-04-26
14:42		[4fdefc03c3] part of check-in [f6a6d2b887] Add largely untested code for the incremental vacuum function. (CVS 3876) (check-in: [f6a6d2b887] user: danielk1977 branch: trunk, size: 38296)
2007-03-30
17:11		[3b992b5b26] part of check-in [eec7ab63be] Coverage tests for some pragmas. (CVS 3767) (check-in: [eec7ab63be] user: danielk1977 branch: trunk, size: 37650)
11:12		[8fd4f98822] part of check-in [9a7d7e3190] Comment changes in btree.c and added a missing "else" in pragma.c. (CVS 3757) (check-in: [9a7d7e3190] user: drh branch: trunk, size: 37653)
2007-03-24
16:45		[9cb8b94e7d] part of check-in [b6c700370b] Changes for exclusive access mode. There are still some bugs. (CVS 3712) (check-in: [b6c700370b] user: danielk1977 branch: trunk, size: 37657)
2007-03-19
17:44		[a3fe1dacdb] part of check-in [7dc7658887] Modify the interface to the pager sub-system in preparation for performing IO in blocks based on sector-size, not database page-size. (CVS 3705) (check-in: [7dc7658887] user: danielk1977 branch: trunk, size: 35665)
2007-03-14
15:37		[b52dcf2fbb] part of check-in [a8d6d935fb] Modify the behaviour of writable_schema to ignore schema parsing errors. (CVS 3686) (check-in: [a8d6d935fb] user: danielk1977 branch: trunk, size: 35666)
2007-01-27
02:24		[5091300911] part of check-in [d564a039f2] Limit the number of errors returned by PRAGMA integrity_check to 100 by default. Specify an alternative limit using an argument to the pragma. Ticket #2176. (CVS 3609) (check-in: [d564a039f2] user: drh branch: trunk, size: 35640)
2007-01-04
22:13		[fd4df6cf08] part of check-in [f81c4227c2] Fix the user_version and schema_version pragmas so that they set a result column name. Ticket #2143. (CVS 3560) (check-in: [f81c4227c2] user: drh branch: trunk, size: 35046)
2006-11-30
13:06		[d0891d3504] part of check-in [5f21c3a5f0] Change the table_info pragma so that it returns NULL for the default value if there is no default value. Ticket #2078. (CVS 3527) (check-in: [5f21c3a5f0] user: drh branch: trunk, size: 34976)
2006-09-25
18:01		[2ef4353448] part of check-in [c63d34ce0c] Add a pragma for activating proprietary extensions. (CVS 3441) (check-in: [c63d34ce0c] user: drh branch: trunk, size: 35065)
13:48		[eac5926df7] part of check-in [c037403bae] Bug fix in pragma table_info(). (CVS 3440) (check-in: [c037403bae] user: drh branch: trunk, size: 34580)
2006-08-14
14:23		[dcb79b8170] part of check-in [b4d53974c3] Change the table_info pragma to show the text of the default value expression, not the result of evaluating the default value expression. Ticket #1919. (CVS 3353) (check-in: [b4d53974c3] user: drh branch: trunk, size: 34483)
2006-08-08
13:51		[cc12939bb7] part of check-in [76e4d41877] Remove most static and global variables from a pure build. There are still a number of static and global variables used for testing. (CVS 3342) (check-in: [76e4d41877] user: drh branch: trunk, size: 34302)
2006-03-03
21:20		[27d5e395c5] part of check-in [5cae8d63d9] The table_info pragma shows column affinity as "" if there is no column affinity. Ticket #1570. (CVS 3122) (check-in: [5cae8d63d9] user: drh branch: trunk, size: 34289)
2006-02-17
12:25		[607b0f3b19] part of check-in [1e4644b236] Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104) (check-in: [1e4644b236] user: danielk1977 branch: trunk, size: 34304)
2006-02-11
01:25		[31d3e1b74c] part of check-in [f2069d0bf3] Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) (check-in: [f2069d0bf3] user: drh branch: trunk, size: 34078)
2006-02-10
02:27		[8e13597970] part of check-in [82f502cdc1] Add the column_origin_name() etc. APIs. (CVS 3069) (check-in: [82f502cdc1] user: danielk1977 branch: trunk, size: 33999)
2006-02-09
16:52		[c26c810e9c] part of check-in [731f1e3245] Back out check-in (3058) - it breaks too much application code. (CVS 3063) (check-in: [731f1e3245] user: drh branch: trunk, size: 33572)
2006-02-06
21:34		[0986217308] part of check-in [7940a590ab] Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) (check-in: [7940a590ab] user: drh branch: trunk, size: 33861)
2006-01-12
01:56		[4496cc77dc] part of check-in [b2dbd1a5b7] Add the legacy_file_format pragma. (CVS 2922) (check-in: [b2dbd1a5b7] user: drh branch: trunk, size: 33575)
2006-01-11
14:09		[d439d257c1] part of check-in [3970eb875d] Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) (check-in: [3970eb875d] user: danielk1977 branch: trunk, size: 33525)
2006-01-10
17:58		[711992e440] part of check-in [0f0213be4d] Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) (check-in: [0f0213be4d] user: danielk1977 branch: trunk, size: 33465)
2006-01-09
16:12		[05abacaa5a] part of check-in [3e75d3d5ef] Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) (check-in: [3e75d3d5ef] user: danielk1977 branch: trunk, size: 33537)
2006-01-08
18:10		[7358baf8e2] part of check-in [b2ac0be07e] Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) (check-in: [b2ac0be07e] user: drh branch: trunk, size: 33484)
2006-01-06
14:32		[ae8b135531] part of check-in [2529c2e11f] Change the OS interface layer to use traditional direct function call implementations instead of the more complicated virtual function table. Omit the asynchronous I/O demo. (CVS 2870) (check-in: [2529c2e11f] user: drh branch: trunk, size: 33484)
2006-01-05
11:34		[4af4041a88] part of check-in [deeda0dc06] Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) (check-in: [deeda0dc06] user: danielk1977 branch: trunk, size: 33494)
2005-12-09
20:02		[8883b4d347] part of check-in [83a5915155] Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) (check-in: [83a5915155] user: drh branch: trunk, size: 33265)
2005-12-08
18:12		[a6d3a7c76b] part of check-in [a7c9e8989c] Provide a pragma to set the codec key. (CVS 2806) (check-in: [a7c9e8989c] user: drh branch: trunk, size: 33261)
2005-11-30
03:20		[2793699ab0] part of check-in [bd8740d1ae] Restructure the OS interface yet again. This time make the OsFile object a virtual base class which is subclassed for unix, windows, and the crash test simulator. Add the new file "os.c" for common os layer code. Move all OS-specific routines into the sqlite3Os structure. (CVS 2795) (check-in: [bd8740d1ae] user: drh branch: trunk, size: 33138)
2005-11-26
00:25		[e278b3f722] part of check-in [1f69aec285] Modify the OS layer so that I/O routines are called through a virtual function table. The os_test.c module has been replaced by test6.c. The crash tests are busted now and need to be fixed. (CVS 2785) (check-in: [1f69aec285] user: drh branch: trunk, size: 33138)
2005-11-03
02:15		[b401899671] part of check-in [be83bfee02] Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) (check-in: [be83bfee02] user: drh branch: trunk, size: 33136)
2005-10-06
13:59		[9ec219dc4e] part of check-in [4862eaafd8] Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) (check-in: [4862eaafd8] user: drh branch: trunk, size: 33045)
2005-10-05
11:41		[278c8fe2e2] part of check-in [efec04dedf] Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) (check-in: [efec04dedf] user: drh branch: trunk, size: 33045)
2005-09-20
17:42		[126149668a] part of check-in [2471957fee] Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) (check-in: [2471957fee] user: drh branch: trunk, size: 33000)
2005-09-17
16:36		[6d773e25e8] part of check-in [1a737b457c] Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) (check-in: [1a737b457c] user: drh branch: trunk, size: 33408)
2005-08-14
01:20		[69413fbdc0] part of check-in [72ee21c05e] The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) (check-in: [72ee21c05e] user: drh branch: trunk, size: 33405)
2005-08-13
00:56		[59ab707346] part of check-in [25cfe9390d] Fix a memory leak that occurs when a CREATE TABLE that contains a DEFAULT VALUE fails due to a name conflict. Tickets #1356 and #1357. (CVS 2584) (check-in: [25cfe9390d] user: drh branch: trunk, size: 33089)
2005-06-23
03:15		[dea86dad2f] part of check-in [bcf62dc7a1] Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) (check-in: [bcf62dc7a1] user: drh branch: trunk, size: 33089)
2005-06-12
21:35		[5ea2ba0e43] part of check-in [36f2da1f8d] Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) (check-in: [36f2da1f8d] user: drh branch: trunk, size: 33041)
2005-06-07
22:22		[344e501664] part of check-in [62a7353d4a] Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) (check-in: [62a7353d4a] user: drh branch: trunk, size: 33041)
2005-05-22
06:49		[0ed94a1aa9] part of check-in [afc8ce42b6] Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) (check-in: [afc8ce42b6] user: danielk1977 branch: trunk, size: 32989)
2005-04-28
19:03		[93d447670b] part of check-in [90f4cf2ad5] Add hooks for the SSE extension. (CVS 2449) (check-in: [90f4cf2ad5] user: drh branch: trunk, size: 32979)
2005-03-29
03:10		[845c8ab0ab] part of check-in [c41d55443c] Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) (check-in: [c41d55443c] user: danielk1977 branch: trunk, size: 32694)
2005-02-26
18:10		[4b20dbc0f4] part of check-in [c167e90542] Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362) (check-in: [c167e90542] user: drh branch: trunk, size: 32643)
2005-02-09
03:20		[7e65c5545d] part of check-in [f73a8aa34a] Add experimental collation_list pragma. (CVS 2321) (check-in: [f73a8aa34a] user: danielk1977 branch: trunk, size: 32346)
2005-02-06
02:45		[809b95acd9] part of check-in [2155448d21] Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) (check-in: [2155448d21] user: drh branch: trunk, size: 31830)
2005-02-04
04:07		[572d7dd4f9] part of check-in [2eb9087055] Remove code for SQL cursors. (CVS 2312) (check-in: [2eb9087055] user: danielk1977 branch: trunk, size: 31780)
2005-01-24
10:25		[c893f03104] part of check-in [d5233e0747] Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: [d5233e0747] user: danielk1977 branch: trunk, size: 32384)
2005-01-22
03:03		[141a3f4985] part of check-in [df648d50c0] Add the experimental sqlite3_expired() API. (CVS 2263) (check-in: [df648d50c0] user: drh branch: trunk, size: 31998)
2005-01-20
11:32		[8ab3139866] part of check-in [5b1a9bf6aa] Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) (check-in: [5b1a9bf6aa] user: danielk1977 branch: trunk, size: 31936)
2005-01-11
10:25		[ac594f74c9] part of check-in [8ced491588] Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) (check-in: [8ced491588] user: danielk1977 branch: trunk, size: 31895)
2005-01-08
15:44		[1b6f9f4caa] part of check-in [0a90eaf398] Fixes to the temp_store_directory pragma. (CVS 2185) (check-in: [0a90eaf398] user: drh branch: trunk, size: 31912)
2004-12-25
01:03		[0394f9361a] part of check-in [5fd1f47118] Fix ticket #1046 by removing code and simplifying the query optimizer. Remarkably, this simplification also makes the optimizer do a better job. Ticket #1051 was fixed as a side-effect. (CVS 2172) (check-in: [5fd1f47118] user: drh branch: trunk, size: 32968)
2004-12-20
19:01		[639a7e7ef0] part of check-in [772e22cbd6] Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: [772e22cbd6] user: tpoindex branch: trunk, size: 32975)
2004-11-22
19:12		[d6406e12c9] part of check-in [fc8c1393c8] Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) (check-in: [fc8c1393c8] user: drh branch: trunk, size: 30268)
2004-11-13
15:59		[0b43b8cac4] part of check-in [dcbc0c22cf] More compile-time options for removing components. (CVS 2098) (check-in: [dcbc0c22cf] user: drh branch: trunk, size: 29664)
2004-11-12
16:12		[32ce8fad1a] part of check-in [5e05831844] Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) (check-in: [5e05831844] user: danielk1977 branch: trunk, size: 29461)
2004-11-11
05:10		[bb1c76dae9] part of check-in [d28d1d68e5] Add the schema_cookie and user_cookie pragmas. (CVS 2089) (check-in: [d28d1d68e5] user: danielk1977 branch: trunk, size: 29445)
2004-11-09
12:44		[44074b9321] part of check-in [0d27c8ff48] Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: [0d27c8ff48] user: danielk1977 branch: trunk, size: 27010)
2004-11-05
15:45		[6a0ae7721e] part of check-in [b9d5f007fc] Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) (check-in: [b9d5f007fc] user: danielk1977 branch: trunk, size: 27044)
2004-10-31
02:22		[44e192eb59] part of check-in [be661acfa8] Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: [be661acfa8] user: drh branch: trunk, size: 26494)
2004-10-25
20:33		[263e20f764] part of check-in [63efd50a16] Minor optimizations in the pragma module. (CVS 2029) (check-in: [63efd50a16] user: drh branch: trunk, size: 26337)
2004-10-22
20:29		[2b65e0150c] part of check-in [39f7870a54] Add the experimental and scary pragma "writable_schema". (CVS 2027) (check-in: [39f7870a54] user: drh branch: trunk, size: 26522)
2004-10-06
15:41		[3134201e4d] part of check-in [d790c84c5a] Convert many constants to have type "const". (CVS 2006) (check-in: [d790c84c5a] user: drh branch: trunk, size: 26481)
2004-10-05
15:42		[4a071a1908] part of check-in [0415af3257] Use the database name supplied to table_info() and related pragmas. (CVS 2001) (check-in: [0415af3257] user: drh branch: trunk, size: 26432)
02:41		[ba7fdd19c1] part of check-in [81ff8107ad] Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: [81ff8107ad] user: drh branch: trunk, size: 26424)
2004-09-25
14:39		[45978cc82f] part of check-in [9ef4c24a9a] Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) (check-in: [9ef4c24a9a] user: drh branch: trunk, size: 26464)
2004-09-17
20:25		[5fb6647fda] part of check-in [c34f3209e5] The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) (check-in: [c34f3209e5] user: drh branch: trunk, size: 26508)
2004-09-08
15:09		[1f7781c4bb] part of check-in [a1f532520c] Always cast 0 to (char*)0 when it is an argument in a varargs function. (CVS 1948) (check-in: [a1f532520c] user: drh branch: trunk, size: 26482)
2004-09-06
17:24		[6385059dfd] part of check-in [3ddf5a9d1c] Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 connection now must be called "sqlite3". You cannot call it "sqlite". This might break existing code. (CVS 1941) (check-in: [3ddf5a9d1c] user: drh branch: trunk, size: 26475)
2004-09-05
23:23		[0fbfb50491] part of check-in [dfa9ea89c4] Comment changes and minor code cleanup. (CVS 1940) (check-in: [dfa9ea89c4] user: drh branch: trunk, size: 26472)
2004-09-02
15:14		[7156618038] part of check-in [8ce3d730b0] Fix a problem with EXPLAIN on pragmas that return single integer values. Ticket #886 (CVS 1929) (check-in: [8ce3d730b0] user: drh branch: trunk, size: 26494)
2004-08-31
13:45		[b39177b96b] part of check-in [8fd65e7048] Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) (check-in: [8fd65e7048] user: drh branch: trunk, size: 26376)
2004-08-21
17:54		[a7cea75286] part of check-in [bd6649c5aa] Optimizations to the code generator. (CVS 1899) (check-in: [bd6649c5aa] user: drh branch: trunk, size: 26377)
2004-08-08
20:22		[5cf335adfd] part of check-in [b065973898] Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) (check-in: [b065973898] user: drh branch: trunk, size: 26778)
2004-07-22
01:19		[c8be18093f] part of check-in [4cf6e9db75] Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) (check-in: [4cf6e9db75] user: drh branch: trunk, size: 26780)
2004-06-30
09:49		[8326df8c40] part of check-in [152e9940b9] Coverage tests for vacuum.c (CVS 1776) (check-in: [152e9940b9] user: danielk1977 branch: trunk, size: 24631)
2004-06-29
08:59		[0ecbe7ccf7] part of check-in [157db33e09] Fix error reporting path for errors that occur while reading the database schema. (CVS 1757) (check-in: [157db33e09] user: danielk1977 branch: trunk, size: 24608)
07:45		[b6df973670] part of check-in [ffd3312b66] Bug-fixes to get the two threadtest C programs working again. (CVS 1756) (check-in: [ffd3312b66] user: danielk1977 branch: trunk, size: 24818)
2004-06-26
19:35		[2ca5ef7e27] part of check-in [0f9c0f0aa9] Coverage testing of pragma.c. (CVS 1744) (check-in: [0f9c0f0aa9] user: drh branch: trunk, size: 24751)
06:37		[16713c1bc4] part of check-in [212de3ce66] Remove default_synchronous and temp_store pragmas. Allow the safety-level and cache-size to be set for attached databases. (CVS 1735) (check-in: [212de3ce66] user: danielk1977 branch: trunk, size: 25284)
2004-06-21
09:06		[0750e1c360] part of check-in [bbd3e93348] Add the OP_Concat8 opcode, similar in concept to OP_String8. (CVS 1648) (check-in: [bbd3e93348] user: danielk1977 branch: trunk, size: 30309)
08:18		[7d75803f3e] part of check-in [7a33daef5b] Ensure sqlite3ErrorMsg() is used to report errors during compilation, sqlite3Error() during execution. Also remove unused param from sqlite3VdbeReset() and Finalize(). (CVS 1647) (check-in: [7a33daef5b] user: danielk1977 branch: trunk, size: 30306)
2004-06-19
15:22		[318a60581e] part of check-in [fbfc3c95a8] Fix problems with the WatCom C compiler: Arrays must contain at least one element. sqlite3FreeX declared properly. Don't allow run-time expression (the SQLITE_UTF16NATIVE macro) in an array initializer. (CVS 1640) (check-in: [fbfc3c95a8] user: drh branch: trunk, size: 30328)
14:49		[424d812d74] part of check-in [99d0436e0e] Omit the sqlite3VdbeCode() routine. Use sqlite3NameFromToken() more to reduce the amount of code. (CVS 1639) (check-in: [99d0436e0e] user: drh branch: trunk, size: 30202)
2004-06-18
23:21		[42de2b327d] part of check-in [5f383c1ee1] MinGW/MSYS build fixes; ticket #765 (CVS 1625) (check-in: [5f383c1ee1] user: dougcurrie branch: trunk, size: 30274)
17:10		[c11121c2c0] part of check-in [2590fffcaa] Changes to allow libsqlite3.a and libsqlite.a to be both linked into the same program at the same time. (CVS 1621) (check-in: [2590fffcaa] user: drh branch: trunk, size: 30207)
2004-06-17
19:04		[83b86b2942] part of check-in [9fb29f7331] Documentation updates in preparation for the release of version 3.0.0. (CVS 1613) (check-in: [9fb29f7331] user: drh branch: trunk, size: 30191)
2004-06-16
12:02		[b51bd2034a] part of check-in [7974c9a6f5] Trivial modifications to prevent compiler warnings. (CVS 1607) (check-in: [7974c9a6f5] user: danielk1977 branch: trunk, size: 30141)
2004-06-15
16:51		[be8ed53611] part of check-in [07b90f3690] Assorted memory leak fixes. (CVS 1600) (check-in: [07b90f3690] user: danielk1977 branch: trunk, size: 30081)
2004-06-12
00:42		[e288bd122d] part of check-in [9b84f2f488] Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) (check-in: [9b84f2f488] user: danielk1977 branch: trunk, size: 29972)
2004-06-10
10:50		[0bc3adea28] part of check-in [edf069b9f4] Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1562) (check-in: [edf069b9f4] user: danielk1977 branch: trunk, size: 29944)
01:30		[6ab13748a4] part of check-in [28c3cc0880] Add the vdbe_listing and sql_trace pragmas used for debugging. (CVS 1558) (check-in: [28c3cc0880] user: drh branch: trunk, size: 29873)
2004-06-09
14:17		[3251628662] part of check-in [0ecbba78fc] Add the "lock_status" pragma - only available when SQLITE_DEBUG is defined. Used for testing only. (CVS 1547) (check-in: [0ecbba78fc] user: drh branch: trunk, size: 29757)
12:30		[d63b011bf8] part of check-in [beab038c71] Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) (check-in: [beab038c71] user: danielk1977 branch: trunk, size: 28677)
00:48		[9328a31c22] part of check-in [1086196460] Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) (check-in: [1086196460] user: drh branch: trunk, size: 27921)
2004-06-07
07:52		[54b4d67fa8] part of check-in [983221b038] Add pragma to set/get text encoding. Also fix an obscure problem where a temp trigger could be accidently dropped. (CVS 1537) (check-in: [983221b038] user: danielk1977 branch: trunk, size: 27886)
2004-06-03
16:08		[1b58d852b8] part of check-in [d57e5252c8] Untested updates to support atomic multi-file transactions (CVS 1526) (check-in: [d57e5252c8] user: danielk1977 branch: trunk, size: 24315)
2004-05-31
08:26		[7f432dee3c] part of check-in [b8ed812c92] Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) (check-in: [b8ed812c92] user: danielk1977 branch: trunk, size: 24318)
2004-05-29
11:24		[84e778a73e] part of check-in [3225de8902] Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492) (check-in: [3225de8902] user: danielk1977 branch: trunk, size: 24329)
2004-05-28
16:00		[0c17b613d7] part of check-in [6661bb5f9c] Factor common code for generating index keys into a procedure. Other speed improvements and bug fixes. (CVS 1487) (check-in: [6661bb5f9c] user: drh branch: trunk, size: 24303)
2004-05-26
10:11		[f2b05b087a] part of check-in [d5659f2ee6] Add some tests for the new API. Many more to come. (CVS 1462) (check-in: [d5659f2ee6] user: danielk1977 branch: trunk, size: 24688)
06:58		[aa6a887017] part of check-in [93bb958d93] Remove the show_datatypes pragma. (CVS 1461) (check-in: [93bb958d93] user: danielk1977 branch: trunk, size: 25270)
00:01		[02b57adda4] part of check-in [143c502a59] Minor code fixes in btree.c and pragma.c to help with watcom C. (CVS 1457) (check-in: [143c502a59] user: drh branch: trunk, size: 25320)
2004-05-25
23:35		[399feca7ce] part of check-in [9385ad5ca8] Move the sqlite3_exec() function to legacy.c. (CVS 1455) (check-in: [9385ad5ca8] user: danielk1977 branch: trunk, size: 25334)
2004-05-22
21:30		[e14dd3b06c] part of check-in [18e690e405] Remove the OP_SetInsert opcode. (CVS 1443) (check-in: [18e690e405] user: drh branch: trunk, size: 24873)
2004-05-20
22:16		[aeeba7dc5b] part of check-in [a6cb09d7af] Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) (check-in: [a6cb09d7af] user: drh branch: trunk, size: 25447)
2004-05-18
22:17		[2332e7fa9d] part of check-in [238442bbd2] Remove the OP_StrEq opcodes. (CVS 1397) (check-in: [238442bbd2] user: drh branch: trunk, size: 25416)
09:58		[fcbd8bc7f2] part of check-in [a62872aacd] Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1392) (check-in: [a62872aacd] user: danielk1977 branch: trunk, size: 25427)
01:23		[2c65f46a52] part of check-in [202a470f2c] Omit the '\0' at the end of UTF-8 strings on disk (it is implied). Also don't store the number of rows at the beginning of each table record. (CVS 1390) (check-in: [202a470f2c] user: danielk1977 branch: trunk, size: 25427)
2004-05-16
11:15		[351836bce1] part of check-in [a4af838f8d] More changes to support the manifest type model. A few things are currently broken. (CVS 1385) (check-in: [a4af838f8d] user: danielk1977 branch: trunk, size: 25289)
2004-05-11
08:48		[2ab2a12b62] part of check-in [6dc6004684] More small changes to get test cases to execute. (CVS 1355) (check-in: [6dc6004684] user: danielk1977 branch: trunk, size: 25286)
07:11		[cef4b66bd2] part of check-in [dfde112116] Remove code dealing with old file formats. (CVS 1354) (check-in: [dfde112116] user: danielk1977 branch: trunk, size: 25283)
2004-05-08
08:23		[d9f8332a1a] part of check-in [8af6474c49] Change lots of internal symbols from sqliteXXX to sqlite3XXX so that the library links again. It doesn't work yet, due to changes in the btree layer calling convention. (CVS 1324) (check-in: [8af6474c49] user: danielk1977 branch: trunk, size: 25308)
2004-04-23
17:04		[f9c157b059] part of check-in [7ace576215] Get the temp_store and default_temp_store pragmas working. Update the documentation. Also fix a malloc problem that popped up during the regression testing. (CVS 1302) (check-in: [7ace576215] user: drh branch: trunk, size: 25143)
2004-02-22
20:05		[621d319580] part of check-in [51f1e8f753] Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266) (check-in: [51f1e8f753] user: drh branch: trunk, size: 24741)
2004-02-21
14:00		[a8d4366119] part of check-in [6a5fb5b89a] Flag pragmas like vdbe_trace now return their current setting if they are called with no arguments. (CVS 1257) (check-in: [6a5fb5b89a] user: drh branch: trunk, size: 25317)
13:31		[dab17a6093] part of check-in [8e3eda2a90] More code cleanup and size reduction. (CVS 1256) (check-in: [8e3eda2a90] user: drh branch: trunk, size: 24784)
2004-02-20
14:50		[fe677be978] part of check-in [574dd444e7] The name of a result column is now the name of column it originated from, by default. This can be turned off with PRAGMA short_column_names=OFF. This is to be more like PostgreSQL. More testing needed. (CVS 1250) (check-in: [574dd444e7] user: drh branch: trunk, size: 24658)
2004-02-16
03:44		[23dac1d20c] part of check-in [f72134852b] Remove the NullCallback opcode. Handle the empty_result_set pragma inside the sqlite_exec() function. (CVS 1244) (check-in: [f72134852b] user: drh branch: trunk, size: 24464)
2004-01-19
04:52		[89d62c31c6] part of check-in [fa55c9861e] comment (CVS 1188) (check-in: [fa55c9861e] user: jplyon branch: trunk, size: 24467)
2003-12-16
03:44		[deec734274] part of check-in [b92c31d6c1] Improvements to the way PRAGMA integrity_check works. More likely to output userful information when given a corrupt database. (CVS 1132) (check-in: [b92c31d6c1] user: drh branch: trunk, size: 24404)
2003-08-23
22:40		[cee60f1767] part of check-in [5232b0665b] Add a "pk" column to the table_info pragma which is true for each column that is part of the primary key. Add a "foreign_key_list" pragma that gives information about all foreign keys for a table. Both changes are experimental. (CVS 1081) (check-in: [5232b0665b] user: drh branch: trunk, size: 24731)
2003-06-15
23:42		[3b4f5a800e] part of check-in [c9734c2707] Enhance the "PRAGMA integrity_check" command to verify that all indices are correctly constructed. New calls to integrity_check are made in the test suite. These changes are intended to prevent any future problems such as seen in ticket #334. (CVS 1024) (check-in: [c9734c2707] user: drh branch: trunk, size: 23335)
2003-06-04
15:48		[f439a6157f] part of check-in [f39100f575] Change the "database_list" pragma to return a third column containing the filename of the underlying database file. Always use an in-memory TEMP database with an in-memory main database. (CVS 1003) (check-in: [f39100f575] user: drh branch: trunk, size: 18055)
2003-05-13
08:01		[ec64704e61] part of check-in [4183cf9767] Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974) (check-in: [4183cf9767] user: jplyon branch: trunk, size: 17875)
2003-05-11
20:09		[8928b747a4] part of check-in [3da10d2d02] Changed PRAGMA database_list to show the filename. (CVS 968) (check-in: [3da10d2d02] user: jplyon branch: trunk, size: 18059)
2003-05-10
03:03		[c2e932cb89] part of check-in [bf558e7952] Removed never-used pragma "result_set_details". (CVS 964) (check-in: [bf558e7952] user: jplyon branch: trunk, size: 17875)
2003-04-25
02:43		[118fe400d7] part of check-in [5afb88008f] Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) (check-in: [5afb88008f] user: drh branch: trunk, size: 18066)
2003-04-22
20:30		[3b1e8da843] part of check-in [c675a55041] Update the authorizer API so that it reports the database that table and indices belong to and so that it reports when actions are taken in response to a trigger. (CVS 928) (check-in: [c675a55041] user: drh branch: trunk, size: 18008)
2003-04-15
01:19		[aef327bd59] part of check-in [e76787f877] Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) (check-in: [e76787f877] user: drh branch: trunk, size: 18005)
2003-04-13
18:26		[476b138965] part of check-in [96336bffde] Support in-memory databases for temp tables (CVS 903) (check-in: [96336bffde] user: paul branch: trunk, size: 17993)
2003-04-06
21:08		Added: [927fc03658] part of check-in [73359037ea] Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) (check-in: [73359037ea] user: drh branch: trunk, size: 15577)