/ File History
Login

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

History of src/pragma.c

2019-10-18
12:52
Claw back some performance from the sqlite3ExprGetColumnOfTable() routine. file: [986fdd27] check-in: [e8426acb] user: drh branch: generated-columns, size: 86778
2019-10-17
18:35
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. file: [a2cee463] check-in: [4ad66af0] user: drh branch: generated-columns, size: 86788
17:54
Some (but not all) INSERT and UPDATE statements now work for STORED columns. file: [c04340e8] check-in: [fe7517bf] user: drh branch: generated-columns, size: 86798
14:21
Bug fixes so that "make test" once against runs with no errors. file: [61abcb6d] check-in: [7bfe0f67] user: drh branch: generated-columns, size: 86756
13:15
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. file: [7b4c4040] check-in: [069351b8] user: drh branch: generated-columns, size: 86729
2019-10-16
19:31
Simple INSERT and SELECT operations working with VIRTUAL columns. file: [a9511633] check-in: [7f9f90b1] user: drh branch: generated-columns, size: 86387
12:18
Initial experimental code for generated column support. Non-functional. file: [941aad90] check-in: [11d472c1] user: drh branch: generated-columns, size: 86376
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [f76a8dda] check-in: [27eb2236] user: drh branch: reuse-schema, size: 86683
12:23
Merge recent trunk enhancements into the wal2 branch. file: [3ab9816b] check-in: [da8bc974] user: drh branch: wal2, size: 86413
12:02
Merge the latest changes from trunk into the apple-osx branch. file: [2b672632] check-in: [a95191de] user: drh branch: apple-osx, size: 86333
2019-08-20
17:14
Bring the hard-heap-limit branch up-to-date with trunk. file: [e423ea29] check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 87181
2019-08-17
15:27
Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. file: [b47bc7db] check-in: [9c4bca64] user: drh branch: trunk, size: 86366
2019-07-26
20:54
Merge latest changes from trunk into this branch. file: [7f527282] check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 86677
2019-07-17
11:01
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. file: [a42d4c60] check-in: [62274ff6] user: drh branch: wor-pk-dups, size: 86360
2019-07-08
21:19
Merge all enhancements from trunk into the wal2 branch. file: [6c1383a5] check-in: [dcbcbc2a] user: drh branch: wal2, size: 86021
20:59
Merge recent enhancements from trunk into apple-osx. file: [e0b01038] check-in: [de88ed86] user: drh branch: apple-osx, size: 85941
2019-05-24
13:04
Merge recent enhancements from trunk. file: [fb7d6499] check-in: [ff9f3e09] user: drh branch: reuse-schema, size: 86291
2019-05-21
17:04
Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. file: [925bcac0] check-in: [b3692c40] user: drh branch: trunk, size: 85974
2019-05-17
20:37
Disable PRAGMA journal_mode=OFF when SQLITE_DBCONFIG_DEFENSIVE is turned on. Ticket [f4ec250930342e0c]. file: [00046255] check-in: [a0f5eb5c] user: drh branch: trunk, size: 85827
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [5e8c63fd] check-in: [018f3199] user: drh branch: reuse-schema, size: 85863
22:02
Merge the latest trunk enhancements into the wal2 branch. file: [4b176da9] check-in: [23ec34e4] user: drh branch: wal2, size: 85593
19:39
Merge recent enhancements from trunk into apple-osx. file: [02b34122] check-in: [40362d51] user: drh branch: apple-osx, size: 85513
2019-05-08
17:27
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]. file: [2e9fbfcb] check-in: [eabe7f2d] user: drh branch: trunk, size: 85546
2019-04-25
18:15
Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. file: [f3efbe2f] check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 86262
2019-04-04
20:21
Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. file: [130a3252] check-in: [b40a4edc] user: drh branch: disable-vtab, size: 85485
2019-03-20
20:02
Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). file: [13e40651] check-in: [c1be211c] user: dan branch: reuse-schema, size: 85764
2019-03-08
15:57
Merge the latest enhancements and fixes from trunk. file: [4113abfa] check-in: [bf20d4ff] user: drh branch: wal2, size: 85494
2019-02-25
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. file: [bbe1ba39] check-in: [64f97530] user: dan branch: reuse-schema, size: 85763
2019-02-18
18:16
Ensure that creating temp schema items does not cause an OPEN_SHARABLE_SCHEMA connection to load all schemas into memory. file: [06a6b3f0] check-in: [88cbf54e] user: dan branch: reuse-schema, size: 85459
2019-02-07
18:49
Merge the offical 3.27.0 release. file: [a6ad736f] check-in: [62829164] user: drh branch: apple-osx, size: 85414
2019-01-31
01:39
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. file: [af67deda] check-in: [507c4353] user: drh branch: trunk, size: 85447
2019-01-17
15:47
Sync up with the latest enhancements on trunk. file: [165ae00d] check-in: [475a179a] user: drh branch: apple-osx, size: 85650
2019-01-02
16:15
Merge latest trunk changes into this branch. file: [c1bfbee7] check-in: [87ef68f9] user: dan branch: wal2, size: 85730
2018-12-29
02:26
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*. file: [20811b40] check-in: [4a0929ac] user: drh branch: trunk, size: 85683
2018-12-11
13:44
Merge latest trunk changes into this branch. file: [3b23e9eb] check-in: [d8dd98a3] user: dan branch: wal2, size: 85705
2018-12-10
02:00
Merge enhancements from trunk. file: [221cb338] check-in: [b1bbc718] user: drh branch: apple-osx, size: 85625
2018-12-06
17:06
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. file: [96ce7dce] check-in: [53d3b169] user: drh branch: trunk, size: 85658
2018-12-01
20:14
Sync this branch with the latest trunk. file: [dbc7a8fa] check-in: [7a44fa5a] user: dan branch: wal2, size: 85700
2018-11-26
23:35
Merge recent enhancements from trunk. file: [cf832d9d] check-in: [e8c20a88] user: drh branch: apple-osx, size: 85620
18:09
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. file: [4e056f04] check-in: [6e133054] user: drh branch: trunk, size: 85653
2018-11-20
18:09
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). file: [a2eab23f] check-in: [6982f52f] user: dan branch: trunk, size: 85593
16:02
Consolidate the two sqlite3SchemaToIndex() routines. file: [f9b6a7f8] check-in: [dfab7170] user: dan branch: reuse-schema1, size: 85324
2018-11-19
20:41
Fix a problem with virtual tables in shared schemas. file: [1c96a1f3] check-in: [84be9220] user: dan branch: reuse-schema1, size: 85325
2018-11-17
18:45
Merge latest trunk changes into this branch. file: [705cffb8] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 85248
2018-11-15
21:20
Fix some problems with the feature on this branch. Many problems remain. file: [c0fd52b1] check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 85199
2018-11-10
20:07
Merge the read-only shadow table and defensive mode enhancments from trunk. file: [7c3cb5bc] check-in: [977fc44e] user: drh branch: apple-osx, size: 85212
2018-11-05
23:01
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. file: [3a5f3951] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 85245
2018-10-31
01:26
Merge fixes from trunk, especially rebustness against corrupt database files. file: [ce45a215] check-in: [4b370c74] user: drh branch: apple-osx, size: 85163
2018-10-30
16:25
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. file: [0bb05b17] check-in: [4f987810] user: drh branch: trunk, size: 85196
2018-10-11
18:45
Fix issues with the new textkey pragma from the previous check-in. file: [f3a391ce] check-in: [d1008b07] user: drh branch: apple-osx, size: 85163
18:41
Add the textkey and textrekey pragmas. file: [35efa858] check-in: [f03164d4] user: drh branch: trunk, size: 85196
18:28
Add the textkey and textrekey pragmas. file: [ad16c987] check-in: [f829099d] user: drh branch: apple-osx, size: 85157
2018-10-09
22:58
Merge enhancements from trunk. file: [d96a4668] check-in: [1b60e7a9] user: drh branch: apple-osx, size: 84934
22:50
Merge changes for the 3.25.0 release. file: [9e31ee95] check-in: [ddf6a54e] user: drh branch: apple-osx, size: 84828
2018-10-01
18:28
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. file: [a656ff04] check-in: [cf1b7613] user: drh branch: pragma-table-vinfo, size: 84967
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. file: [e49a1f19] check-in: [6f606f99] user: drh branch: pragma-table-vinfo, size: 84881
2018-09-29
19:38
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. file: [afd09f81] check-in: [8bcd1a59] user: drh branch: pragma-table-vinfo, size: 85019
2018-08-21
12:16
Fix various harmless warnings generated by static analysis tools. file: [79abc65c] check-in: [a04a0ea9] user: drh branch: trunk, size: 84861
2018-08-03
23:04
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. file: [873b767f] check-in: [3f5f60cd] user: drh branch: omit-column-cache, size: 84877
2018-06-06
19:48
Rearrange the order of some checks in the integrity_check pragma for a very slight performance gain. file: [71c585f1] check-in: [4b853f02] user: drh branch: trunk, size: 84999
2018-06-04
14:10
Merge changes from trunk. file: [fc2af8cd] check-in: [95fbac39] user: drh branch: apple-osx, size: 84932
2018-05-09
13:46
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. file: [c0d13c0e] check-in: [87f261f0] user: drh branch: trunk, size: 84965
2018-03-28
15:41
Update this branch with latest trunk changes. file: [5a4145c6] check-in: [df52e89f] user: dan branch: server-process-edition, size: 85757
2018-01-15
21:59
Merge the enhancements associated with the first 3.22.0 beta. file: [a2a221f0] check-in: [c9d2ec51] user: drh branch: apple-osx, size: 84930
2017-11-28
02:47
Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. file: [021613c9] check-in: [2494132a] user: drh branch: pragma-table-ipk, size: 85583
2017-10-24
19:12
Merge all enhancements and fixes from the 3.21.0 release. file: [b27a8162] check-in: [13be3a44] user: drh branch: apple-osx, size: 84889
2017-10-11
20:26
Merge latest trunk changes with this branch. file: [bea56df3] check-in: [2719cf5c] user: dan branch: schemalint, size: 84963
2017-10-04
20:57
Add experimental mode that uses two wal files. Activated using "PRAGMA journal_mode = wal2". file: [49a04b2e] check-in: [e2fc5c81] user: dan branch: wal2, size: 84969
2017-09-22
20:18
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. file: [9f883969] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 88658
2017-09-21
00:49
Fix the rendering of the P4_INTARRAY argument to the OP_IntegrityCk opcode in the output of EXPLAIN. file: [d04725ac] check-in: [adc12c83] user: drh branch: trunk, size: 84922
2017-09-13
00:13
PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption while scanning indexes. file: [88d99aa4] check-in: [81f62e99] user: drh branch: improved-integrity-check, size: 84922
2017-09-10
01:06
Simplifications to the PRAGMA integrity_check code generator. file: [37998646] check-in: [99b9140c] user: drh branch: improved-integrity-check, size: 84603
2017-09-09
20:38
Improved detection of malformed records by PRAGMA integrity_check. file: [036a79af] check-in: [8fa923ca] user: drh branch: improved-integrity-check, size: 84184
06:10
Merge trunk enhancements file: [de5462b8] check-in: [6a0b9d9d] user: drh branch: apple-osx, size: 84091
2017-09-05
20:16
Update "PRAGMA integrity_check" to detect inconsistencies between a single record's header and body. file: [faf5f9ec] check-in: [9e393a0e] user: dan branch: trunk, size: 84124
2017-08-25
09:17
Avoid returning duplicate rows in experimental pragmas "pragma_list", "module_list" and "function_list". file: [a4e5028d] check-in: [b79cc8dc] user: dan branch: trunk, size: 84056
2017-07-24
19:43
Update this branch with latest changes from trunk. file: [7c61991e] check-in: [d0719ad7] user: dan branch: server-process-edition, size: 85044
2017-07-20
13:17
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. file: [cd6aeda3] check-in: [22eda098] user: drh branch: index-on-date-func, size: 84250
2017-07-19
19:48
Allow indexes to be created on date/time functions as long as the 'now' date and the 'localtime' and 'utc' modifiers are not used. file: [95672b7d] check-in: [0a5e1c04] user: drh branch: index-on-date-func, size: 84248
18:54
Merge latest trunk changes with this branch. file: [38032c10] check-in: [be0df0a6] user: dan branch: server-process-edition, size: 85006
2017-07-17
20:21
Merge all the latest fixes and enhancements from trunk. file: [d4671065] check-in: [e181225d] user: drh branch: apple-osx, size: 84071
2017-07-15
20:48
Add the "unionvtab" virtual table extension in ext/misc/unionvtab.c. file: [d42b6b5a] check-in: [62a86aa6] user: dan branch: union-vtab, size: 84212
20:33
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]. file: [2ae4088e] check-in: [253945d4] user: drh branch: trunk, size: 84104
20:25
Fix a missing \n at the end of a comment causing a line to be too long. No code changes. file: [91f30204] check-in: [687bd478] user: drh branch: trunk, size: 84064
2017-07-13
21:06
Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". file: [09fe2d45] check-in: [dcc40797] user: dan branch: server-process-edition, size: 83554
2017-07-07
22:58
Merge in all the latest trunk enhancements. file: [8984481d] check-in: [7f48f6ab] user: drh branch: apple-osx, size: 84032
20:06
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. file: [54e64a9d] check-in: [38978ce6] user: drh branch: trunk, size: 84065
17:43
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. file: [79ec7625] check-in: [e0b6ae92] user: drh branch: trunk, size: 83973
17:33
Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. file: [072f2907] check-in: [2f3c3781] user: drh branch: list-pragmas, size: 84315
16:00
Enhance the sqlite3VdbeMultiLoad() interface to automatically generate the OP_ResultRow opcode on PRAGMA implementations, for a small reduction in the library footprint. file: [3f9456ed] check-in: [c46f0f07] user: drh branch: trunk, size: 82760
15:43
Add new pragmas: "function_list" and "module_list" file: [415a98ec] check-in: [e5f01d7f] user: drh branch: list-pragmas, size: 84023
2017-06-19
11:44
Experimental "PRAGMA secure_delete=FAST" pragma. The intent is to overwrite deleted content with zeros without increasing the amount of disk I/O. file: [b5483eba] check-in: [f1682f0f] user: drh branch: fast-secure-delete, size: 83194
2017-04-24
16:14
Bring in all the latest enhancements from trunk. file: [994ebf40] check-in: [031feebc] user: drh branch: apple-osx, size: 83069
2017-04-20
17:35
Merge latest trunk changes into this branch. file: [7fef375e] check-in: [b1533bc4] user: dan branch: schemalint, size: 83143
2017-04-17
18:42
Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. file: [2362670a] check-in: [69f51f83] user: dan branch: trunk, size: 83102
18:02
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. file: [943f71f7] check-in: [690870bd] user: dan branch: trunk, size: 83092
2017-04-08
19:00
Merge latest trunk with this branch. file: [15082170] check-in: [e051e8f2] user: dan branch: schemalint, size: 83036
00:25
Merge the latest trunk changes. file: [28f232da] check-in: [dd16439e] user: drh branch: apple-osx, size: 82962
2017-04-04
19:58
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. file: [220474f1] check-in: [e5bb7db5] user: dan branch: trunk, size: 82995
2017-03-31
11:20
Merge latest trunk into this branch. file: [157c323a] check-in: [cb721d0b] user: dan branch: schemalint, size: 82911
2017-03-30
20:26
Merge all changes from the 3.18.0 release. file: [ae2407b5] check-in: [ed28f15e] user: drh branch: apple-osx, size: 82837
2017-03-17
03:21
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. file: [2b244434] check-in: [019dd3d5] user: drh branch: trunk, size: 82870
2017-03-15
14:04
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. file: [bfaa7e5c] check-in: [bcf6bb08] user: drh branch: trunk, size: 82797
2017-03-09
16:32
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. file: [6d0dd687] check-in: [5dc82a15] user: drh branch: dump-recovery, size: 82905
2017-03-08
18:37
Merge recent enhancements from trunk, including the --preserve-rowids option to .dump and the .sha3sum commands of the CLI. file: [69997bfa] check-in: [9b439173] user: drh branch: apple-osx, size: 82751
2017-03-06
23:51
Make the default MASK argument for "PRAGMA optimize" be 0xfffe, to allow for future expansion of up to 14 new default-on optimizations. file: [b7bf4f1d] check-in: [73019a8b] user: drh branch: trunk, size: 82784
20:44
Fix a typo in a comment. No changes to code. file: [d4aef420] check-in: [ec529bf1] user: drh branch: trunk, size: 82688
20:00
Merge all pending 3.18 enhancements from trunk. file: [5e1dfb5a] check-in: [1650c3f4] user: drh branch: apple-osx, size: 82660
2017-03-02
14:17
Add an optional bitmask of allowed optimizations on the "PRAGMA optimize" command. The 0x01 bit is Debug Mode. file: [75fdb058] check-in: [a35388ee] user: drh branch: auto-analyze, size: 82693
2017-02-23
00:58
Do a single OP_Expire at the very end of "PRAGMA optimize", and omit the OP_Expire on ANALYZE commands invoked by the pragma. file: [4b32b014] check-in: [188300a3] user: drh branch: auto-analyze, size: 81591
2017-02-22
20:24
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. file: [46202f2f] check-in: [9fced545] user: drh branch: auto-analyze, size: 81554
19:49
Merge integrity_check and other improvements from trunk. file: [97742aae] check-in: [fe073905] user: drh branch: auto-analyze, size: 80787
18:04
Cleanup and simplification of the output row count limit control of PRAGMA integrity_check. file: [b127edeb] check-in: [5af7d72e] user: drh branch: integrity-check-improvements, size: 77834
15:11
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. file: [ec83a3cb] check-in: [5264844b] user: drh branch: integrity-check-improvements, size: 78583
14:15
Enhance "PRAGMA integrity_check" so that it verifies CHECK constraints. file: [aa4af3d8] check-in: [549bae08] user: drh branch: integrity-check-improvements, size: 78137
2017-02-21
13:29
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. file: [9180cce9] check-in: [9626b41e] user: drh branch: vdbe_cycle_limit, size: 77532
2017-02-18
22:52
Updated comments. No code changes. file: [8a35509e] check-in: [e842ad39] user: drh branch: auto-analyze, size: 79876
15:58
Add the OP_SqlExec opcode and use it to implement "PRAGMA analyze_as_needed", invoking ANALYZE subcommands as necessary. This simplifies the implementation. file: [1ed159f6] check-in: [d386015f] user: drh branch: auto-analyze, size: 78337
02:19
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. file: [cf0f101d] check-in: [882599a4] user: drh branch: auto-analyze, size: 77154
2017-02-17
16:26
Add the "PRAGMA analyze_as_needed" command. file: [e8b2ea66] check-in: [e93db237] user: drh branch: auto-analyze, size: 77136
13:38
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. file: [d4918a73] check-in: [85026c8e] user: drh branch: auto-analyze, size: 77006
2017-02-16
14:02
Merge recent enhancements from trunk. file: [0457012c] check-in: [325ccfa9] user: drh branch: est_count_pragma, size: 80659
2017-02-04
15:29
Merge recent trunk enhancements. file: [26e6c5f1] check-in: [6c3f0902] user: drh branch: apple-osx, size: 76890
2017-02-01
22:43
Fix harmless compiler warnings seen with MSVC. file: [78319560] check-in: [997f765b] user: mistachkin branch: msvcWarn, size: 76923
2017-01-27
16:24
Merge all recent enhancements from trunk. file: [1ba3574e] check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 80655
2017-01-06
17:01
Merge the changes for version 3.16.2. file: [74f24422] check-in: [c59c8880] user: drh branch: apple-osx, size: 76886
2017-01-05
19:32
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). file: [0e7a7c6f] check-in: [5c05d8ec] user: dan branch: pragma-columncount-fix, size: 76919
2017-01-03
20:20
Merge changes from the 3.16.1 release file: [5924c968] check-in: [dcbec226] user: drh branch: apple-osx, size: 76393
2016-12-22
14:53
Fix harmless compiler warnings. file: [5a23557e] check-in: [fa86db2f] user: drh branch: trunk, size: 76426
2016-12-16
21:29
Merge recent enhancements from trunk, and especially the pragma-as-vtab change. file: [f84626db] check-in: [4b1e7804] user: drh branch: apple-osx, size: 76285
21:15
Merge the pragma-as-vtab enhancement from trunk. file: [10f1418f] check-in: [89250777] user: drh branch: est_count_pragma, size: 80054
21:02
Fix a potential memory leak following an OOM error in the pragma processing. file: [59cfc788] check-in: [396ab8f8] user: drh branch: est_count_pragma, size: 72269
16:49
Experimental merge of the est_count_pragma and the pragma-as-vtab branches. file: [850bee00] check-in: [4b73ee33] user: drh branch: est-count-pragma-vtab, size: 80045
04:20
Fix an error in the way the "schema" argument to some pragma virtual tables is handled. file: [d5adfe89] check-in: [546821e2] user: drh branch: pragma-as-vtab, size: 76318
02:14
Minor bug fixes and enhancements to the pragma eponymous virtual tables. file: [767a4112] check-in: [3f8f4615] user: drh branch: pragma-as-vtab, size: 76250
2016-12-15
21:33
Fix the cost estimation in the BestIndex method of the eponymous pragma virtual table implementation. file: [41f18267] check-in: [7126807a] user: drh branch: pragma-as-vtab, size: 76170
21:11
The pragma as eponymous virtual table mechanism now appears to work. file: [db1d2ae0] check-in: [2c274a1a] user: drh branch: pragma-as-vtab, size: 76131
20:59
Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. file: [b2421f23] check-in: [988a61e8] user: drh branch: pragma-as-vtab, size: 76147
16:01
Do more pragma processing from tables rather than in-line code. file: [78f85cf6] check-in: [a88ca352] user: drh branch: table-driven-pragma, size: 66342
2016-10-25
17:28
Merge recent trunk changes, and especially the PRAGMA index_info enhancement which is needed on this branch. file: [6ca8fb0a] check-in: [c3570e46] user: drh branch: est_count_pragma, size: 72260
15:39
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. file: [18a2b0aa] check-in: [fe49fb03] user: drh branch: index-info-on-table, size: 68599
2016-10-21
18:01
When reading from an index, the shared-cache lock must be on the corresponding table. file: [7e3bbf3c] check-in: [04fe12b5] user: drh branch: est_count_pragma, size: 72114
17:25
Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. file: [3ef6e316] check-in: [affc2ef5] user: drh branch: est_count_pragma, size: 72044
15:36
Fix problems in the est_count pragma for indexes and WITHOUT ROWID tables. file: [e33c2c77] check-in: [c39fd9b8] user: drh branch: est_count_pragma, size: 69619
2016-10-20
22:02
Experimental est_count pragma. file: [baf70746] check-in: [340822af] user: drh branch: est_count_pragma, size: 69437
18:20
Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. file: [3ad504c6] check-in: [fd81d8a4] user: drh branch: multi-arg-pragma, size: 68174
2016-09-07
18:20
Merge recent enhancements from trunk. file: [7a32fcc8] check-in: [00759af0] user: drh branch: apple-osx, size: 68420
2016-08-18
14:33
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. file: [d932ba27] check-in: [92a22f01] user: drh branch: zDbSName, size: 68453
2016-06-15
10:21
Merge changes from trunk. file: [1564ee0b] check-in: [0f707d15] user: drh branch: apple-osx, size: 68399
2016-06-10
22:49
Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. file: [c8b49975] check-in: [53a1e5d5] user: drh branch: trunk, size: 68432
2016-05-26
20:56
Add a new OP_SeekRowid opcode, that combines the functions of OP_MustBeInt and OP_NotExists. This makes the code slightly smaller and faster. file: [d98039af] check-in: [ffe80a1b] user: drh branch: trunk, size: 68412
2016-05-23
02:57
Merge changes from trunk. file: [11046a2e] check-in: [815cc2bb] user: drh branch: apple-osx, size: 68497
2016-05-20
15:15
Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. file: [9fdce031] check-in: [3d55d24d] user: drh branch: trunk, size: 68530
2016-03-29
10:30
Merge 3.12.0 changes. file: [985f16e7] check-in: [eef55744] user: drh branch: apple-osx, size: 68503
2016-03-22
20:05
The sqlite3_column_decltype() routine should return NULL, not an empty string, if the column has no declared type. file: [faf42922] check-in: [605eba4a] user: drh branch: trunk, size: 68536
2016-03-19
00:40
Fix a VDBE register allocation bug exposed by recent enhancements to PRAGMA integrity_check. file: [620a6f8c] check-in: [c73b5b9c] user: drh branch: apple-osx, size: 68548
00:35
Fix a register allocation bug in the VDBE code generator for PRAGMA integrity_check; file: [e7e8f380] check-in: [88439a86] user: drh branch: trunk, size: 68581
2016-03-18
00:58
Merge recent enhancements from trunk. file: [e1e16179] check-in: [ec052b4f] user: drh branch: apple-osx, size: 68406
2016-03-16
20:44
Some pragmas can be reused without an automatic reprepare. file: [f0670909] check-in: [db1ce7e1] user: drh branch: reusable-pragma, size: 68439
20:05
Fix a comment on the freelist_count and data_version pragmas. file: [fb8e3e73] check-in: [10a3e2a0] user: drh branch: trunk, size: 68381
01:09
Merge the SQLITE_OMIT_CODEC_FROM_TCL compile-time option from trunk. file: [a1a9753b] check-in: [161d91e4] user: drh branch: apple-osx, size: 68319
2016-03-15
22:00
Change the OP_IntegrityCk opcode to accept the list of root pages as an intarray argument in P4. Slightly smaller and faster. file: [04baa934] check-in: [15e4a272] user: drh branch: trunk, size: 68352
2016-03-09
08:08
Merge latest trunk changes with this branch. file: [3ca4a321] check-in: [59caca43] user: dan branch: schemalint, size: 68221
2016-03-08
16:35
Merge changes from trunk, especially the SQLITE_DEFAULT_SYNCHRONOUS enhancements. file: [88bd7bba] check-in: [29741941] user: drh branch: apple-osx, size: 68147
14:40
Add compile-time options SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS used to specify the default synchronous settings for all database connections. file: [c7061870] check-in: [1fefa967] user: drh branch: default-synchronous, size: 68180
2016-03-04
14:57
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. file: [2c1fa795] check-in: [2f0c195c] user: drh branch: apple-osx, size: 68821
2016-02-29
15:53
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. file: [42b3f147] check-in: [842b2116] user: drh branch: schema-storage, size: 68153
2016-02-27
21:16
Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce the amount of memory needed to hold the schema. file: [35619c4e] check-in: [d8c94a46] user: drh branch: trunk, size: 68112
19:03
More compact implementation of PRAGMA onconflict, and some test cases. file: [b9d960d3] check-in: [3e5d38f5] user: drh branch: pragma-onconflict, size: 68662
17:16
Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. file: [f8f9bf11] check-in: [3a0c347c] user: drh branch: pragma-onconflict, size: 68724
2016-02-26
16:14
Merge all recent enhancements from trunk, and in particular the SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER change. file: [fc4b8918] check-in: [4fb4aee8] user: drh branch: apple-osx, size: 68690
2016-02-25
21:19
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. file: [d6028d23] check-in: [832c237f] user: drh branch: trunk, size: 68022
2016-02-11
21:01
Experimental integration of schemalint functionality with the shell tool. Does not work yet. file: [cfd52155] check-in: [ed49f297] user: dan branch: schemalint, size: 68163
2016-02-05
14:29
Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as other enhancements from trunk. file: [eb149efa] check-in: [201fcbee] user: drh branch: apple-osx, size: 68790
01:55
Improvements to the way that OOM errors are processed. file: [80ee7722] check-in: [c3ef0347] user: drh branch: oom-handling, size: 68122
2016-02-04
02:34
Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. file: [eb3a712e] check-in: [1c8d3001] user: drh branch: zero-register, size: 68105
2016-02-03
19:20
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. file: [3c4f3fad] check-in: [af924018] user: drh branch: trunk, size: 68123
01:55
Enhance the internal sqlite3VdbeAddOpList() interface to automatically update jump destinations. Use this feature to simplify the AUTOINCREMENT code generator. file: [a973357e] check-in: [ae8b9d2e] user: drh branch: trunk, size: 67944
2016-02-02
02:30
Merge recent enhancements from trunk. file: [dc702fbc] check-in: [e6a4a163] user: drh branch: apple-osx, size: 68648
2016-02-01
21:48
Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. file: [2ac26ac4] check-in: [6d7d4703] user: drh branch: trunk, size: 67980
2016-01-20
11:40
Merge all recent enhancements from trunk. file: [0200623c] check-in: [3ed49691] user: drh branch: apple-osx, size: 68822
2016-01-18
00:20
Fix a problem with SQLITE_TEST_REALLOC_STRESS. file: [ea290193] check-in: [0aaf3feb] user: drh branch: trunk, size: 68154
2016-01-16
20:50
Improvements to the way sqlite3VdbeAddOpList() works, resulting in a slightly smaller and faster binary. file: [53c95f54] check-in: [88ceb588] user: drh branch: trunk, size: 68042
2015-11-13
02:13
Merge fixes from trunk. file: [c1ab37e1] check-in: [f9060b2a] user: drh branch: apple-osx, size: 68663
2015-11-12
22:15
Always parse the schema *before* running "PRAGMA cache_size", not after. file: [f3e71472] check-in: [12e7d9ec] user: drh branch: trunk, size: 67995
16:51
Merge the latest enhancements from trunk, and in particular the "PRAGMA cache_spill=N" change. file: [44e32568] check-in: [e72331c7] user: drh branch: apple-osx, size: 68773
16:44
Enhance the "PRAGMA cache_spill" statement to accept an integer argument which is the threshold at which spilling will begin. file: [56161e4a] check-in: [f79d264d] user: drh branch: trunk, size: 68105
15:47
Test cases. Minor problems fixed. All appears to work now. file: [0e91830e] check-in: [9a431362] user: drh branch: cache_spill=N, size: 68160
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [26a612db] check-in: [549d42be] user: drh branch: cache_spill=N, size: 68120
2015-11-10
14:27
Make the output of "PRAGMA parser_trace" go to stdout instead of stderr. file: [9dbb9ba2] check-in: [1e484991] user: drh branch: trunk, size: 66707
2015-10-26
20:50
Merge latest trunk changes, including the SQLITE_IOERR_AUTH error code, with this branch. file: [5d97c87f] check-in: [bc195e1c] user: dan branch: apple-osx, size: 67375
2015-10-22
20:54
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. file: [8fd4c8a1] check-in: [cdc92919] user: dan branch: btree-fordelete-flag, size: 66707
2015-10-09
17:28
Merge all changes through the first 3.9.0 beta from trunk. file: [f66e2d2d] check-in: [1ccae39b] user: drh branch: apple-osx, size: 67372
2015-10-06
21:07
Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. file: [dcfe3a35] check-in: [041df7c2] user: drh branch: trunk, size: 66704
2015-09-29
17:20
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. file: [23481497] check-in: [7d272aa6] user: drh branch: trunk, size: 66650
2015-09-25
20:49
Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. file: [577f70c3] check-in: [113181ce] user: drh branch: trunk, size: 66646
2015-09-03
14:31
Merge enhancements from trunk. file: [a6b01c31] check-in: [d01658ad] user: drh branch: apple-osx, size: 67300
13:46
Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). file: [d71b813e] check-in: [847387ec] user: drh branch: trunk, size: 66632
04:28
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. file: [0465869b] check-in: [d7f4bdf5] user: drh branch: trunk, size: 68272
03:29
For PRAGMAs, factor out the code that sets the result set column names into a subroutine. file: [a5a100ad] check-in: [0ea6e5c9] user: drh branch: trunk, size: 68937
2015-09-02
18:19
Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand for sqlite3VdbeAddOp2(v,OP_Goto,0,i). file: [5d84bdb3] check-in: [be78f413] user: drh branch: trunk, size: 71582
2015-08-28
02:12
Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. file: [9eaa576b] check-in: [da864658] user: drh branch: apple-osx, size: 72283
2015-08-25
19:20
Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. file: [a239d2c8] check-in: [1ee089a7] user: drh branch: trunk, size: 71615
2015-07-29
14:10
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. file: [669bc0fd] check-in: [4489722a] user: drh branch: branch-3.8.11, size: 71614
2015-07-16
18:18
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. file: [e52084b3] check-in: [b79a4aff] user: drh branch: trunk, size: 71559
2015-04-20
01:25
Merge all recent trunk enhancements and fixes into the apple-osx branch. file: [17e00497] check-in: [74b7bf17] user: drh branch: apple-osx, size: 72166
2015-04-19
21:43
Fix harmless compiler warnings seen with MSVC 2015. file: [c1f4d012] check-in: [d05becd8] user: mistachkin branch: vsix2015, size: 71504
2015-04-17
15:58
Ensure that semantic SQL errors are always reported back up to the syntax parser. Also: Improve the defense against invalid PRAGMA synchronous settings. file: [2a81f312] check-in: [7aeade9a] user: drh branch: trunk, size: 71498
2015-04-16
16:04
Silently ignore requests to change the PRAGMA synchronous setting to an illegal integer value, rather than raising an assertion. file: [633cb355] check-in: [e0a88176] user: drh branch: trunk, size: 71543
2015-04-15
13:51
Merge recent trunk fixes and enhancements into the apple-osx branch. file: [db44f204] check-in: [bfc7142a] user: drh branch: apple-osx, size: 72059
07:19
Remove an incorrect ALWAYS() from the table_info pragma. file: [3965ae4e] check-in: [0e087c01] user: drh branch: trunk, size: 71406
2015-03-09
13:18
Merge recent trunk enhancements into the apple-osx branch. file: [21af63d9] check-in: [5e04eec8] user: drh branch: apple-osx, size: 72067
2015-03-06
04:37
Clearification of some documentation text. Added requirements marks. file: [ac4f3f85] check-in: [8c1e85aa] user: drh branch: trunk, size: 71414
2015-03-05
14:29
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. file: [7f51aba7] check-in: [fc543c2c] user: drh branch: trunk, size: 70850
2015-02-28
01:04
More test cases and requirements marks for pragmas. file: [d1abcc07] check-in: [fc51037c] user: drh branch: trunk, size: 70533
2015-02-06
16:03
Merge all recent trunk enhancements into the apple-osx branch. file: [f5c1ba06] check-in: [44711921] user: drh branch: apple-osx, size: 70822
00:31
Revise the way that the index structure for a WITHOUT ROWID table is discovered. file: [8042d2b2] check-in: [7f10a0ea] user: drh branch: ota-update, size: 71909
2015-02-04
23:51
Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. file: [6e376554] check-in: [21e95d28] user: drh branch: ota-update, size: 72055
23:13
Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. file: [ea0be138] check-in: [3af19f84] user: drh branch: index_xinfo, size: 70169
2015-02-03
18:43
Fix some problems surrounding WITHOUT ROWID tables with DESC primary key indexes . file: [e39954ff] check-in: [a21fefb7] user: dan branch: ota-update, size: 87789
15:56
Remove "PRAGMA ota_mode". file: [26fc5561] check-in: [1c111447] user: dan branch: ota-update, size: 87643
2015-02-02
22:19
Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. file: [a5b397bd] check-in: [6dca23e6] user: drh branch: preload-pragma, size: 69958
21:34
Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. file: [58044728] check-in: [32c0325b] user: drh branch: trunk, size: 69316
2015-01-31
02:34
Merge in support for the index_xinfo pragma. file: [e49831e5] check-in: [f9b6dc77] user: drh branch: ota-update, size: 87959
02:00
Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. file: [f4d03263] check-in: [30f51d7b] user: drh branch: index_xinfo, size: 85682
2015-01-28
12:00
Merge in all changes from trunk. file: [92eba821] check-in: [17c69be8] user: drh branch: ota-update, size: 86961
2015-01-16
12:24
Merge the 3.8.8 release changes from trunk. file: [d9bd64b0] check-in: [518621f8] user: drh branch: apple-osx, size: 85337
2015-01-12
18:38
Fix some harmless compiler warnings. file: [ba149bbb] check-in: [2b8eecbf] user: mistachkin branch: msvcW4, size: 84684
2015-01-02
19:17
Merge the latest changes from trunk into the apple-osx branch. file: [1f13dbb5] check-in: [df3cdf9f] user: drh branch: apple-osx, size: 85337
2014-12-19
19:28
Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. file: [bd33aa24] check-in: [43db1f44] user: drh branch: data_version_pragma, size: 84684
18:49
Simplify the implementation of the "header-value" pragmas (schema_version, user_version, freelist_count, and application_id) by making them more table-driven. file: [7337e5d9] check-in: [da27a09d] user: drh branch: trunk, size: 84465
2014-12-16
00:29
Merge latest fixes and enhancements from trunk into apple-osx. file: [8ed75925] check-in: [2c1d8dda] user: drh branch: apple-osx, size: 85305
2014-12-12
23:17
Add extra tests to threadtest4.c. Fix a benign data race accessing the text encoding using ENC(db). file: [c93be505] check-in: [d7bb7ea4] user: drh branch: trunk, size: 84652
2014-12-08
07:50
Update this branch with latest trunk changes. file: [294c31d7] check-in: [69a312ad] user: dan branch: ota-update, size: 86904
2014-12-04
23:42
Import from trunk support for SQLITE_CHECKPOINT_TRUNCATE and fixes for a couple of obscure bugs. file: [0de5c12a] check-in: [463ad971] user: drh branch: apple-osx, size: 85280
2014-12-02
19:04
Add the SQLITE_CHECKPOINT_TRUNCATE option. file: [d54cdd40] check-in: [8e20a434] user: dan branch: checkpoint-truncate, size: 84627
2014-11-22
09:09
Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. file: [8e0087a5] check-in: [600cefdd] user: dan branch: ota-update, size: 86794
2014-11-20
17:37
Update the ota extension so that it can be used to update tables with external PRIMARY KEY indexes. file: [272b122a] check-in: [55066a11] user: dan branch: ota-update, size: 86662
15:11
Updates to support zipvfs in pass-through mode. file: [92343541] check-in: [556c3de5] user: dan branch: ota-update, size: 86676
2014-10-20
16:24
Have the ota extension perform an incremental checkpoint after generating the wal file. file: [310939bc] check-in: [0bf1301a] user: dan branch: ota-update, size: 86472
2014-09-21
23:08
Merge in all recent changes from trunk. file: [c63b5aa7] check-in: [3967ebe8] user: drh branch: apple-osx, size: 85170
2014-09-16
20:02
Clarify the effects of the pager_ota_mode pragma. Add tests and fixes for the same. file: [5b255c09] check-in: [decaccc3] user: dan branch: ota-update, size: 86474
2014-09-15
19:34
Remove the experimental sqlite3_transaction_save() and restore() APIs. file: [c401b5dd] check-in: [48d201cd] user: dan branch: ota-update, size: 85273
15:34
Merge latest trunk changes with this branch. file: [5dba6b38] check-in: [55b8011d] user: dan branch: ota-update, size: 85326
2014-09-11
14:01
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. file: [3f3e9593] check-in: [70121e7c] user: drh branch: user-auth, size: 84517
2014-09-10
17:34
Further ideas on user authentication. Not yet working code. file: [3b7b1a5e] check-in: [c8171ecd] user: drh branch: user-auth, size: 84517
2014-09-09
14:47
Non-working preliminary implementation attempts on user authentication. file: [e4f6421d] check-in: [8440f093] user: drh branch: user-auth, size: 84501
2014-09-03
19:30
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. file: [e1b8049c] check-in: [209f672e] user: dan branch: ota-update, size: 85121
2014-09-02
19:59
Add an experimental extension for applying bulk updates to databases. file: [d252459f] check-in: [2954ab50] user: dan branch: ota-update, size: 84604
15:57
Merge the latest trunk changes into the apple-osx branch. file: [4865f1a4] check-in: [696dc935] user: drh branch: apple-osx, size: 84965
2014-08-29
16:20
Add SQLITE_LIMIT_WORKER_THREADS for controlling the maximum number of worker threads. file: [14bcdb50] check-in: [1b598c68] user: drh branch: threads, size: 84312
2014-08-25
23:44
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. file: [33971fca] check-in: [e3305d4b] user: drh branch: threads, size: 84327
15:13
Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. file: [4ed8bc86] check-in: [29c5e8a7] user: drh branch: threads, size: 84331
2014-08-15
22:37
Aborted merge. file: [97a45c2e] check-in: [c8ade949] user: numist branch: obsolete, size: 82118
2014-08-06
01:51
Merge 3.8.6 beta changes in from trunk. file: [0fc087e3] check-in: [b2e01080] user: drh branch: apple-osx, size: 84271
2014-08-05
00:53
Improved VdbeCoverage() macros. A few minor simplifications to generated VDBE code. file: [d10ef67c] check-in: [01f60027] user: drh branch: IN-operator-improvements, size: 83618
2014-08-04
15:12
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. file: [58374d1b] check-in: [2f724cba] user: drh branch: deadend, size: 83674
2014-08-01
01:40
Enhance the PRAGMA integrity_check command to detect UNIQUE and NOT NULL constraint violations. file: [d4a33151] check-in: [9abcf269] user: drh branch: trunk, size: 83672
2014-07-31
22:59
Refactoring: Change "pIndex->onError!=OE_None" to use a macro: "IsUniqueIndex(pIndex)". Easier to understand that way. file: [f9268bd5] check-in: [e75b26ee] user: drh branch: trunk, size: 81208
2014-07-30
11:49
Merge all recent trunk changes, and especially the R-Tree IN operator fix of ticket [d2889096e7bdeac]. file: [b7758ec0] check-in: [654c6c65] user: drh branch: apple-osx, size: 81864
2014-07-25
21:35
Try to fix harmless compiler warnings reported by Fortify. file: [30f3b2ac] check-in: [e0fa6fdc] user: drh branch: trunk, size: 81211
2014-07-24
16:43
Merge recent trunk changes into the apple-osx branch. file: [4cb718db] check-in: [3810dc62] user: drh branch: apple-osx, size: 81866
2014-07-23
13:40
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. file: [e17c5ea1] check-in: [6c6f0de5] user: drh branch: hex-literal, size: 81213
2014-05-09
11:45
Bring the PRAGMA logic into closer alignment with trunk, and in the process fix a couple of crashes. file: [039578fb] check-in: [d66fe706] user: drh branch: apple-osx, size: 81943
2014-05-08
23:01
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. file: [67d3b4a8] check-in: [9411d7dc] user: drh branch: apple-osx, size: 82158
2014-05-05
22:49
Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. file: [1f392e4e] check-in: [f1a4bf01] user: drh branch: reduce-schema-size, size: 81570
19:57
Try to reduce the amount of memory used to hold the schema when PRAGMA ignore_check_constraints is active. file: [f89b6822] check-in: [35a9f3f1] user: drh branch: reduce-schema-size, size: 81368
2014-04-25
15:01
Store values loaded from the stat1 table as logarithmic values in memory. file: [810ef31c] check-in: [1bd74c49] user: dan branch: experimental-costs, size: 81290
2014-04-13
19:15
Make sure column cache elements are cleared correctly when jumping over code for key generation in a partial index. Fix for ticket [2ea3e9fe6379fc3f6]. file: [21ece94d] check-in: [3122b836] user: drh branch: trunk, size: 81220
2014-03-19
14:10
First attempt at getting block-sort to work. This is an incremental check-in. There are many problems still to be worked out. file: [10f169b9] check-in: [59742dd4] user: drh branch: orderby-planning, size: 81212
2014-03-10
18:03
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. file: [e78b4bf2] check-in: [0a5318bc] user: drh branch: trunk, size: 81209
2014-02-19
19:14
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. file: [a46ee836] check-in: [c1e94169] user: drh branch: trunk, size: 81176
2014-02-17
22:40
Add logic to do test coverage measurements on the VDBE code. file: [2635d6bf] check-in: [ce184c7b] user: drh branch: insert-optimization, size: 81126
14:59
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". file: [769d08f1] check-in: [35b4d6e9] user: drh branch: insert-optimization, size: 80652
2014-01-04
19:27
Avoid redundant register loads during index key generation when doing a DELETE or INTEGRITY_CHECK on a table with multiple indices. file: [ed409ce4] check-in: [8f6e6149] user: drh branch: trunk, size: 80686
2013-11-16
20:13
Enhance the DELETE logic so that it can make use of WHERE_ONEPASS_DESIRED for rowid tables. file: [5ab7279d] check-in: [8f479a72] user: drh branch: optimize-delete, size: 80580
2013-11-13
17:58
Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. file: [c8d70c47] check-in: [8ce33f4c] user: drh branch: trunk, size: 80577
2013-11-06
19:59
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. file: [3b7b7663] check-in: [defd5205] user: drh branch: omit-rowid, size: 80446
2013-11-04
21:44
Bug fixes in the INSERT constraint checker. Refactor the Rowid handling logic for ANALYZE with STAT3/4. file: [ac43f31b] check-in: [1ea43c0f] user: drh branch: omit-rowid, size: 80531
17:00
Fix a problem with processing INTEGER PRIMARY KEY on a WITHOUT ROWID table. file: [8d67f2e7] check-in: [89098e6d] user: drh branch: omit-rowid, size: 80533
2013-10-31
15:37
Improved comments and variable names in infrastructure routines of UPDATE, DELETE, and INSERT. file: [ff1a9899] check-in: [ad90e762] user: drh branch: omit-rowid, size: 80439
11:15
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. file: [74dec25a] check-in: [1adfca60] user: drh branch: omit-rowid, size: 80432
2013-10-30
20:22
Continue working to get UPDATE operational for WITHOUT ROWID tables. Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables. file: [c6612470] check-in: [0d4fea74] user: drh branch: omit-rowid, size: 80331
2013-10-28
22:39
Merge recent fixes from trunk. file: [21f9e61c] check-in: [9f8191d1] user: drh branch: omit-rowid, size: 80200
2013-10-25
14:46
Basic DELETE operations now working on WITHOUT ROWID tables. file: [5986f119] check-in: [9eafafa3] user: drh branch: omit-rowid, size: 79418
2013-10-24
14:16
Delete PRIMARY KEY index entries last. Only construct the unique prefix of an index key when deleting entries from an index. file: [d6eee7e1] check-in: [0e56ba69] user: drh branch: omit-rowid, size: 79414
2013-10-23
22:23
Construct secondary indices on WITHOUT ROWID tables. file: [575a4462] check-in: [2c028ddc] user: drh branch: omit-rowid, size: 79414
2013-10-22
18:01
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. file: [ab815d27] check-in: [a106ce86] user: drh branch: omit-rowid, size: 79455
2013-10-21
23:17
Improve support for the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. file: [6fb3125f] check-in: [f1d8c3b0] user: mistachkin branch: trunk, size: 80237
2013-10-14
14:30
Update the foreign_key_check pragma so that when a parent table is undefined it is treated as an empty table. file: [64d3d1f8] check-in: [208b259a] user: drh branch: trunk, size: 79455
2013-10-12
20:22
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. file: [1c00ed0d] check-in: [f0cf8c85] user: drh branch: trunk, size: 79365
19:06
In "PRAGMA foreign_key_check", treat missing parent tables as empty (instead of as errors). file: [24fb88e2] check-in: [8c13a7fd] user: dan branch: fkc-missing-parent-tables, size: 78411
09:32
Changes to the new initial row of PRAGMA index_list results. file: [393efaa7] check-in: [0c4dd9ff] user: mistachkin branch: indexList, size: 78415
2013-10-07
10:48
Merge bug fixes from trunk. file: [f4ff6e29] check-in: [1d7b2dc0] user: drh branch: row-size-est, size: 78321
00:36
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. file: [b65c8273] check-in: [0aca31e1] user: drh branch: trunk, size: 77920
2013-10-05
19:18
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. file: [c9a867f6] check-in: [8b4aa0c7] user: drh branch: row-size-est, size: 78193
02:56
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. file: [07814efd] check-in: [de78250a] user: drh branch: index-scan-rate, size: 77942
2013-10-04
15:30
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. file: [3bcdc7a9] check-in: [07462bb6] user: drh branch: index-scan-rate, size: 77936
2013-10-03
14:08
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. file: [5a4d8d9c] check-in: [8338232a] user: drh branch: trunk, size: 77792
2013-09-13
21:03
Fix the "const" qualifiers on the pragma name table. file: [0c7a67a7] check-in: [b74e6be8] user: drh branch: trunk, size: 75126
21:01
Add the soft_heap_limit pragma. file: [d3d93be2] check-in: [c326356f] user: drh branch: trunk, size: 75126
19:00
Tweak the new PRAGMA name parser to achieve full branch test coverage. file: [249742bd] check-in: [c82e05c4] user: drh branch: trunk, size: 74566
16:36
Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. file: [49612a5c] check-in: [870c030b] user: drh branch: trunk, size: 74437
2013-08-24
00:59
Unify the result of PRAGMA mmap_size when mmap support is disabled. file: [3aa3d8c8] check-in: [032c3159] user: mistachkin branch: mmapDisabled, size: 67283
2013-08-23
17:33
Adjust #ifdefs to get SQLITE_OMIT_AUTOMATIC_INDEX and SQLITE_OMIT_PAGER_PRAGMAS to build. file: [dc9ceab9] check-in: [ed310201] user: drh branch: trunk, size: 67223
2013-08-17
15:42
The fullfsync, checkpoint_fullfsync, and cache_spill pragmas apply to all files of a database connection, including those opened by future ATTACH statements. file: [1d96ba74] check-in: [d07c4331] user: drh branch: cache_spill, size: 67175
2013-08-16
20:42
Add the cache_spill pragma. file: [3fd0f90f] check-in: [cdb181c0] user: drh branch: cache_spill, size: 67059
2013-08-01
15:09
More test cases and corresponding bug fixes. file: [590c7575] check-in: [0c8cfdfa] user: drh branch: partial-indices, size: 66701
03:36
Test cases and bug fixes for the partial index logic. file: [aca37128] check-in: [6b73ae7c] user: drh branch: partial-indices, size: 66662
01:14
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. file: [f8936b23] check-in: [fb9044d1] user: drh branch: partial-indices, size: 67055
2013-07-11
15:22
Add the experimental "query_only" pragma. file: [2790c517] check-in: [6557c407] user: drh branch: trunk, size: 66998
12:19
Rename the SQLITE_DeferForeignKeys macro to shorter SQLITE_DeferFKs. Move the "defer_foreign_keys" pragma into the flagPragma() routine. file: [c87581d9] check-in: [3a2ab74c] user: drh branch: sessions, size: 66940
2013-07-10
13:33
Experimental "PRAGMA query_only=BOOLEAN" statement that is able to turn write capabilities on and off. file: [f91b64b8] check-in: [ece960c4] user: drh branch: query_only, size: 66870
2013-07-03
19:53
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. file: [057f5b13] check-in: [1d44e5d3] user: dan branch: sessions, size: 67260
2013-05-29
17:48
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. file: [67a611bd] check-in: [d5b084e9] user: drh branch: trunk, size: 66812
2013-05-28
12:11
Many small harmless comment changes. Removal of obsolete comments and fixing misspelled words. No changes to code. file: [75282024] check-in: [a0d5cc93] user: drh branch: trunk, size: 66780
2013-05-23
10:13
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. file: [8bf4bfae] check-in: [40cfde8b] user: dan branch: trunk, size: 66796
2013-05-01
19:49
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. file: [8779308b] check-in: [28c9e7fd] user: drh branch: application-id, size: 66700
2013-04-15
17:03
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. file: [3eacf001] check-in: [ea1404a1] user: drh branch: trunk, size: 66415
2013-04-11
13:26
Fix pragma code generation so that it always outputs an OP_Trace opcode so that pragmas are shown in sqlite3_trace() output. file: [216d6c24] check-in: [663f04bd] user: drh branch: trunk, size: 66425
2013-04-08
20:47
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. file: [8bbc8c86] check-in: [8a4314a3] user: drh branch: trunk, size: 66399
2013-04-03
13:09
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. file: [682e97f3] check-in: [2d9f1327] user: drh branch: experimental-mmap, size: 66345
2013-04-01
22:38
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. file: [d0231f41] check-in: [78141d0a] user: drh branch: experimental-mmap, size: 66212
2013-03-25
23:09
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. file: [8875d32d] check-in: [1b37c4ef] user: drh branch: experimental-mmap, size: 65851
2013-03-19
19:28
Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". file: [86c8088a] check-in: [6183f1bd] user: dan branch: experimental-mmap, size: 65981
2013-03-11
11:49
Fixes for compiling with SQLITE_OMIT_AUTOVACUUM and/or SQLITE_OMIT_TRIGGER defined. file: [9f0ee3d7] check-in: [938b91e8] user: dan branch: omit-fixes, size: 65045
2013-02-14
16:16
Verify that the schema has not changed before running PRAGMA table_info, index_list, index_info, and foreign_key_list. file: [bdb484d0] check-in: [82952d08] user: drh branch: trunk, size: 64974
2013-01-29
19:14
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. file: [eb9d39e3] check-in: [ae565ff3] user: drh branch: trunk, size: 64794
2013-01-16
20:33
Fix the activate_extensions pragma so that it is a no-op when the required argument is omitted. file: [b7ef1754] check-in: [6195ebd8] user: drh branch: trunk, size: 64618
2013-01-01
13:55
Enhance the table_info pragma so that the pk column shows the order of the columns in a multi-column primary key. file: [8907c559] check-in: [3076a890] user: drh branch: trunk, size: 64608
2012-12-20
00:32
Remove an unreachable branch operation from the foreign_key_check pragma. file: [1ff115f6] check-in: [b5a8f316] user: drh branch: foreign-key-check, size: 64363
2012-12-17
22:32
Added test cases for PRAGMA foreign_key_check. Fixed a bug that appears when the column order of the child and parent differ. file: [312d9ea0] check-in: [25411f83] user: drh branch: foreign-key-check, size: 64326
20:57
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. file: [c6e9ed9d] check-in: [97f7f737] user: drh branch: foreign-key-check, size: 64196
20:40
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. file: [5cc87af7] check-in: [0f996352] user: drh branch: foreign-key-check, size: 64012
18:43
"PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. file: [b98dfe89] check-in: [57d47423] user: drh branch: foreign-key-check, size: 63863
18:05
Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. file: [599af02b] check-in: [603b695b] user: drh branch: foreign-key-check, size: 62984
16:46
Prototype for PRAGMA that checks all foreign key constraints on a table. file: [52adf60a] check-in: [01c980e9] user: drh branch: foreign-key-check, size: 62760
2012-10-09
18:51
Attempt to suppress warnings generated by Coverity. file: [015723c4] check-in: [7b1a6e6c] user: drh branch: trunk, size: 59262
2012-10-01
18:44
Add SQLITE_FCNTL_BUSYHANDLER. Invoked to provide access to the busy-handler callback to custom VFS implementations. file: [4f31fe4a] check-in: [1262d2f4] user: dan branch: trunk, size: 59294
2012-09-28
10:57
Merge the latest trunk changes (PRAGMA busy_timeout and the ORDER BY query planner enhancements) into the apple-osx branch. file: [2b556a8a] check-in: [6a5c59dd] user: drh branch: apple-osx, size: 60200
2012-09-27
12:11
Merge the "PRAGMA busy_timeout" change into trunk. file: [7f5a0fa6] check-in: [1a679a1e] user: drh branch: trunk, size: 59265
2012-09-21
00:04
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. file: [44304a69] check-in: [79e922f7] user: drh branch: trunk, size: 58755
2012-09-13
14:22
Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. file: [de7f3bc6] check-in: [4163f5f1] user: drh branch: trunk, size: 58758
2012-09-07
18:49
Have PRAGMA busy_timeout return 0 if the busy handler has been changed or cancelled. file: [360ac85a] check-in: [7be5bc36] user: drh branch: busy-timeout-pragma, size: 59220
16:46
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. file: [e09950b9] check-in: [22ebc668] user: drh branch: busy-timeout-pragma, size: 59243
2012-08-25
01:38
Merge all the latest trunk changes into the apple-osx branch. file: [bf2a8023] check-in: [6723add4] user: drh branch: apple-osx, size: 59644
2012-07-16
10:06
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. file: [97f9357f] check-in: [4353e40b] user: dan branch: trunk, size: 58710
2012-06-08
01:13
Merge trunk changes into the apple-osx branch. file: [6d617d3e] check-in: [9d1b8515] user: drh branch: apple-osx, size: 59005
2012-06-06
23:23
Merge the changes need to compile on WinRT into trunk. file: [eee3e316] check-in: [61360ca6] user: drh branch: trunk, size: 58071
2012-05-15
18:28
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. file: [28d7955a] check-in: [aa0c3493] user: drh branch: shared-schema, size: 56495
2012-03-14
00:44
Add experimental support for resolving relative database file paths using a fixed user-defined directory. file: [149d8400] check-in: [7354ae8f] user: mistachkin branch: winrt, size: 58042
2012-03-05
16:39
Pull in all the latest trunk changes. file: [29db41fc] check-in: [504bf490] user: drh branch: apple-osx, size: 57425
2012-02-24
14:33
Add #ifdef SQLITE_ENABLE_ZIPVFS around those bits of code that are only used by ZIPVFS. file: [e708b3bb] check-in: [3130275c] user: drh branch: trunk, size: 56491
00:03
If the SQLITE_FCNTL_PRAGMA file control returns something other than SQLITE_NOTFOUND, then skip the rest of Pragma code generation. file: [11f5fff8] check-in: [9e6d340f] user: drh branch: trunk, size: 56511
2012-02-22
19:56
If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. file: [a6b1b209] check-in: [56436181] user: drh branch: file-control-pragma, size: 56507
18:21
Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. file: [c452bbbd] check-in: [a1f29fa6] user: drh branch: file-control-pragma, size: 56387
16:58
Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. file: [6838f56b] check-in: [fd8d7440] user: drh branch: file-control-pragma, size: 56329
14:45
Begin adding support for SQLITE_FCNTL_PRAGMA. file: [4dfd5b26] check-in: [5be07904] user: drh branch: file-control-pragma, size: 56016
2012-02-10
18:18
Pull the latest trunk changes into the apple-osx branch. file: [99f40103] check-in: [e2485986] user: drh branch: apple-osx, size: 56270
2012-01-31
14:24
Futher pedantic fixes to the sqlite3_uri_boolean() interface. file: [350f5984] check-in: [77b3430d] user: drh branch: trunk, size: 55336
2012-01-30
18:40
Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] file: [8bf0fa74] check-in: [7b053d69] user: drh branch: trunk, size: 55311
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. file: [dbad8484] check-in: [96900c47] user: drh branch: trunk, size: 55200
2012-01-14
14:13
Merge the latest trunk changes into the apple-osx branch. file: [58688382] check-in: [2cc414cd] user: drh branch: apple-osx, size: 56192
2012-01-10
17:59
Refactor sqlite3OsFileControlNoFail() into sqlite3FileControlHint(). file: [fb979b7b] check-in: [722735a4] user: drh branch: trunk, size: 55258
16:56
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. file: [492fabe0] check-in: [af59b182] user: dan branch: trunk, size: 55260
2011-12-08
21:08
Merge the latest trunk changes into the apple-osx branch. file: [dae8d307] check-in: [59e0d4f3] user: drh branch: apple-osx, size: 56188
2011-11-16
19:29
Add the sqlite3_db_release_memory() interface and the shrink_memory pragma. file: [dd66f21f] check-in: [3f58e7c8] user: drh branch: trunk, size: 55254
2011-11-09
16:12
Minor changes needed to restore full branch test coverage. file: [65d1d63d] check-in: [bc10a753] user: drh branch: experimental-pcache, size: 55013
14:23
A negative value N for the cache_size pragma adjusts the number of cache pages to use approximately N kibibytes of memory. file: [c5ba7627] check-in: [b3faa680] user: drh branch: experimental-pcache, size: 54647
2011-10-21
17:18
Merge the latest trunk changes into the apple-osx branch. file: [a09bfb67] check-in: [be62ef05] user: drh branch: apple-osx, size: 55823
2011-10-13
17:09
An improved fix for the page_count and quick_check problem previously patched at [150592b4b4d8637] file: [da8ef96b] check-in: [c3cb7f4f] user: drh branch: trunk, size: 54889
14:41
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. file: [0a11a7b5] check-in: [150592b4] user: drh branch: trunk, size: 54865
2011-10-11
14:19
Merge the latest trunk changes into the apple-osx branch. file: [273515f0] check-in: [7e2c4898] user: drh branch: apple-osx, size: 55791
2011-10-10
12:04
Fix a typo in a comment for PRAGMA journal_mode. Also amplify that same comment. file: [68d7db4f] check-in: [c8ff2a48] user: drh branch: trunk, size: 54857
2011-06-25
21:43
Changes to make pragma synchronous sticky when SQLITE_DEFAULT_WAL_SAFETYLEVEL is used file: [66661dbe] check-in: [c6158b25] user: adam branch: apple-osx, size: 55683
2011-06-24
20:47
Merging local changes to apple-osx file: [a1010255] check-in: [34f0efa2] user: adam branch: apple-osx, size: 55304
2011-06-20
11:57
Merge the latest trunk changes into the apple-osx branch. file: [2824f4c8] check-in: [4c69e827] user: drh branch: apple-osx, size: 54949
2011-06-03
13:02
Fix the build when using SQLITE_OMIT_PRAGMA. file: [ebcd20f1] check-in: [051f4635] user: drh branch: trunk, size: 54749
2011-05-19
01:51
Pull all the latest trunk changes, and especially the fix for WAL cache spills causing transactions to disappear, into the apple-osx branch. file: [87566493] check-in: [8d1a6bb0] user: drh branch: apple-osx, size: 54798
2011-04-22
19:37
Add the start of the "uri-filenames" feature. file: [9e778dec] check-in: [b8a8132e] user: dan branch: uri, size: 54598
2011-04-05
13:38
Pull the latest changes from trunk (and hence from schema-parse-refactor) into the apple-osx branch. file: [1785e42e] check-in: [8e885dde] user: drh branch: apple-osx, size: 54770
13:12
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. file: [49c90ab2] check-in: [5db4511d] user: drh branch: trunk, size: 54570
12:25
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. file: [65698dc3] check-in: [bf664b20] user: drh branch: trunk, size: 54415
2011-04-04
18:22
Add a description of access rules for the Schema object and lots of asserts to verify that the access rules are followed. file: [36eec912] check-in: [ae8374af] user: drh branch: schema-parse-refactor, size: 54564
13:11
Merge in the latest changes from trunk. file: [7e1eb402] check-in: [6d78a25d] user: drh branch: apple-osx, size: 54609
2011-04-02
16:28
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. file: [672c5e45] check-in: [6a8ad6e3] user: drh branch: schema-parse-refactor, size: 54410
2011-03-08
02:38
Fix additional cases of possible signed integer overflow, especially with regard to negation. file: [4221eb82] check-in: [2d5800bd] user: drh branch: trunk, size: 54409
2011-02-07
23:56
Cleanup to the OP_Checkpoint opcode. file: [a83f3204] check-in: [f611a5a8] user: drh branch: trunk, size: 54441
2011-02-02
16:34
Merge in the blocking-checkpoint enhancement, including the new sqlite3_wal_checkpoint_v2() interface and the PRAGMA wal_checkpoint(full) statement. file: [3d48a7f0] check-in: [bac7342c] user: drh branch: trunk, size: 54438
2010-12-07
15:49
Merge in all changes to the trunk through version 3.7.4rc3. file: [3ff495d7] check-in: [d2ccf7fc] user: drh branch: apple-osx, size: 54013
2010-11-23
18:59
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. file: [8a6cd3c7] check-in: [2031974b] user: drh branch: trunk, size: 53813
2010-11-19
23:50
Merge all the latest changes from the trunk into the apple-osx branch. file: [a56ea45d] check-in: [c8bc057c] user: drh branch: apple-osx, size: 54146
18:51
Merge the checkpoint_fullfsync pragma and the superlock demonstration into the checkpoint-v2 experimental branch. file: [900f480c] check-in: [ebf74015] user: drh branch: blocking-checkpoint, size: 54565
18:23
Add the checkpoint_fullfsync pragma which enables F_FULLFSYNC on checkpoint operations only, not during ordinary commit fsyncs. file: [8e87e9e3] check-in: [a0698673] user: drh branch: trunk, size: 53940
2010-11-18
12:11
Modify the interface to the blocking wal-checkpoint functionality. file: [f843c877] check-in: [72787c01] user: dan branch: blocking-checkpoint, size: 54455
2010-11-16
18:56
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. file: [66a8b53d] check-in: [7e3fc2c8] user: dan branch: blocking-checkpoint, size: 54065
2010-11-09
20:08
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] file: [6a641dec] check-in: [756589ad] user: dan branch: apple-osx-exp, size: 54090
00:47
Experimental changes to test defaulting to fullfsync for WAL mode file: [bbc722cb] check-in: [77b343cf] user: adam branch: apple-osx-exp, size: 54144
2010-09-30
00:50
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. file: [216d12e4] check-in: [14eed3a0] user: drh branch: experimental, size: 53830
2010-08-18
00:24
Merge the 3.7.1 pre-release snapshot changes as of 2010-08-18 into the apple-osx branch. file: [3dbb254a] check-in: [866e9286] user: drh branch: apple-osx, size: 54014
00:09
Updating apple-osx with minor source fixes, database truncate and replace private calls and a bunch of conditionalization for tests running in different environments file: [055115ce] check-in: [5e2ee7db] user: adam branch: apple-osx, size: 54011
2010-08-07
11:46
Merge in all changes up to the 3.7.0.1 release. file: [6ee42753] check-in: [f88c6367] user: drh branch: apple-osx, size: 54034
2010-07-24
16:34
Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). file: [8b24ce00] check-in: [ac1f37a6] user: drh branch: malloc-enhancement, size: 53808
2010-07-08
17:40
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. file: [4a79269e] check-in: [e396184c] user: drh branch: trunk, size: 53805
2010-07-07
14:33
Fix a compiler warning in PRAGMA journal_mode. file: [ca1a5634] check-in: [d94269e6] user: drh branch: trunk, size: 54192
13:54
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. file: [7d76fe05] check-in: [ef126e77] user: dan branch: trunk, size: 54189
2010-06-16
19:48
Merge in changes up to and including the 3.6.23.1 release. file: [cd1f5140] check-in: [21ca87f6] user: drh branch: apple-osx, size: 53093
2010-05-06
21:37
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. file: [42386532] check-in: [c3520460] user: drh branch: trunk, size: 54122
2010-05-03
15:58
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. file: [b9a0a173] check-in: [7fecd21f] user: dan branch: trunk, size: 54195
13:37
Make sure the mutex is held while calling sqlite3ApiExit() in sqlite3_wal_checkpoint(). Other cleanup of WAL logic. file: [5fa66bc2] check-in: [11a85b82] user: drh branch: wal, size: 54167
11:05
Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint". file: [45405552] check-in: [714e5947] user: dan branch: wal, size: 54090
08:04
Add the sqlite3_wal_checkpoint() and sqlite3_wal_autocheckpoint() APIs. file: [97c6054d] check-in: [9803196d] user: dan branch: wal, size: 53543
2010-05-01
16:40
Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. file: [3d4ba9c3] check-in: [9b230c43] user: dan branch: wal, size: 53577
2010-04-27
01:56
Merge in recent changes from the trunk file: [5ba364af] check-in: [7a0ac682] user: drh branch: wal, size: 53428
2010-04-26
17:36
Change the default_cache_size pragma to always store a positive value. file: [71ba42f5] check-in: [36fb2cae] user: drh branch: trunk, size: 52808
2010-04-20
18:53
Use the read and write version fields of the database header to mark a database as operating in wal-mode. file: [bae3ce82] check-in: [96bef18c] user: dan branch: wal, size: 53643
2010-04-14
11:23
Fixes for locking issues in WAL mode. file: [f12cb58a] check-in: [a9617eff] user: dan branch: wal, size: 53219
2010-04-13
11:56
Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". file: [9f1d53d4] check-in: [27dc5977] user: dan branch: wal, size: 53269
2010-04-12
19:32
Remove duplicate secure_delete pragma implemention. file: [5a68ee9a] check-in: [c15fda14] user: drh branch: wal, size: 53651
19:00
Import experimental write-ahead-logging code. file: [55f34050] check-in: [409d61ba] user: dan branch: wal, size: 54333
2010-04-07
16:54
Wrap all automatic index changes inside SQLITE_OMIT_AUTOMATIC_INDEX. Add the automatic_index PRAGMA to turn it on and off. file: [e166ea41] check-in: [a811a47f] user: drh branch: experimental, size: 53023
2010-02-26
22:05
fix merge error and compiler warning file: [4cf0b849] check-in: [5c0afe70] user: adam branch: apple-osx, size: 52662
15:39
Remove the compile_option pragma (retaining compile_options - with an "s"). Updates to documentation. file: [56d95f76] check-in: [733778df] user: drh branch: trunk, size: 52922
2010-02-25
15:28
Minor simplifications to the compile-time option reporting functions and pragmas to facilitate coverage testing. file: [d610d4f4] check-in: [633d8747] user: drh branch: trunk, size: 53241
14:56
Expire pragma statements when reset, even if they were not run to completion. file: [f37f3366] check-in: [b8fbf427] user: drh branch: branch-3.6.22, size: 51705
14:47
Expire pragma statements when reset, even if they were not run to completion. file: [edaded19] check-in: [78351d28] user: drh branch: trunk, size: 53252
2010-02-23
20:08
Refactored compile time option diagnostic support to use strings identifiers instead of bitmask. file: [1ee3a5be] check-in: [76a0294a] user: shaneh branch: compile_opts, size: 53449
2010-02-17
19:34
Merge latest changes from the trunk into the apple-osx branch. file: [43e02b02] check-in: [4b72e39b] user: drh branch: apple-osx, size: 52657
17:48
Consistent use of #ifdef for SQLITE_HAS_CODEC to avoid confusion. file: [5febf8b5] check-in: [34a3413a] user: shaneh branch: trunk, size: 52491
2010-02-12
19:46
Enhancements to the secure_delete pragma to make it easier to use. file: [55cfa9da] check-in: [2bb38bb9] user: drh branch: trunk, size: 52476
18:18
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. file: [c0591d6f] check-in: [f72f8a87] user: drh branch: trunk, size: 52329
2010-01-28
19:56
Tweaks for consistency to the SEE and CEROD API declarations in sqlite3.h. file: [5644b2cc] check-in: [299f7456] user: shaneh branch: trunk, size: 51794
2009-12-22
00:29
Add a pragma to disable the query flattener - for use during testing. file: [c194fc13] check-in: [1d8550e5] user: drh branch: trunk, size: 51997
2009-12-07
23:53
Merge all changes associated with the version 3.6.21 release into the OS-X branch. file: [eda3d6d1] check-in: [ad08794d] user: drh branch: apple-osx, size: 52057
2009-11-12
20:39
Shift more OP_Found opcodes over to using the unpacked format, for improved performance. file: [6936d7df] check-in: [6705ab1a] user: drh branch: trunk, size: 51902
19:59
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. file: [0057a883] check-in: [b9eab885] user: drh branch: trunk, size: 51864
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [97031c9f] check-in: [f6c045f6] user: drh branch: trunk, size: 51858
2009-11-03
22:34
Customizations for OSX contributed by Apple. file: [840143b9] check-in: [941a01eb] user: adam branch: apple-osx, size: 52079
2009-09-23
08:43
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. file: [c25d0d15] check-in: [540c2d18] user: dan branch: trunk, size: 51924
2009-09-22
07:13
Fix compilation errors when OMIT_FOREIGN_KEY is defined. file: [031ab58a] check-in: [c447cb37] user: dan branch: trunk, size: 51924
2009-09-21
16:06
Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. file: [c75db247] check-in: [fb6ceed3] user: dan branch: trunk, size: 51885
2009-09-19
17:00
Check in implementation of foreign key constraints. file: [254c2153] check-in: [d5d39981] user: dan branch: trunk, size: 51498
2009-09-01
17:11
Change "PRAGMA disable_recursive_triggers" to "PRAGMA recursive_triggers". Also a fix for compiling with OMIT_TRIGGER defined. file: [0a3b3141] check-in: [e016cca3] user: dan branch: trunk, size: 51323
2009-08-30
11:42
Fixes for new triggers scheme. file: [6b1fa9f1] check-in: [9eb91efd] user: dan branch: trunk, size: 51327
2009-07-02
07:47
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) file: [9eb44ac1] check-in: [e3c055f1] user: danielk1977 branch: trunk, size: 51267
2009-06-19
14:06
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) file: [1774ff8e] check-in: [37ae5f5e] user: drh branch: trunk, size: 51022
2009-06-03
11:25
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) file: [06b3a4b9] check-in: [6dbf4eca] user: danielk1977 branch: trunk, size: 51379
2009-05-28
01:00
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) file: [d4a6fd74] check-in: [4ac2bdfb] user: drh branch: trunk, size: 51253
2009-05-27
10:31
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) file: [cf9adc60] check-in: [7cb1c3ba] user: drh branch: trunk, size: 51253
2009-04-07
22:05
Remove two unused tests from the integrity_check pragma logic. (CVS 6466) file: [c26c16c4] check-in: [22999d31] user: drh branch: trunk, size: 51322
00:49
Remove an unused test for EXPLAIN-mode in the PRAGMA processing. (CVS 6459) file: [e48136fd] check-in: [909683b3] user: drh branch: trunk, size: 51391
00:43
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) file: [a89252bf] check-in: [567cf90b] user: drh branch: trunk, size: 51433
2009-04-04
16:02
Allow the journal_size_limit to be larger than 2147483647 bytes. (CVS 6449) file: [c7a237e4] check-in: [81931259] user: drh branch: trunk, size: 51427
2009-04-02
20:16
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) file: [32a967b5] check-in: [85e6a474] user: drh branch: trunk, size: 51335
2009-02-23
16:52
Add the reverse_unordered_selects pragma. (CVS 6314) file: [22ed0483] check-in: [bc078e00] user: drh branch: trunk, size: 51332
2009-02-19
14:39
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) file: [9ed2acb9] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 51281
2009-01-20
16:53
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) file: [04c13c79] check-in: [1041abd6] user: danielk1977 branch: trunk, size: 51312
2009-01-13
20:14
Updates to comments as suggested by tickets #3578 and #3579. (CVS 6172) file: [5b7ac603] check-in: [b5927213] user: drh branch: trunk, size: 51316
2009-01-09
21:41
Coverage improvements in pragma.c. Change the __DARWIN__ macro to __APPLE__, which is available by default on Leopard. (CVS 6153) file: [ec9470bc] check-in: [64c56226] user: drh branch: trunk, size: 51290
2008-12-10
23:04
More code obfuscation designed to thwart compiler warning messages. (CVS 6015) file: [d6dfc479] check-in: [0a1888a7] user: drh branch: trunk, size: 49797
22:15
Fix an issue with the new sqlite3Strlen30() introduced by check-in (6007). Additional casts for compiler warnings. (CVS 6011) file: [c77ac995] check-in: [258722b6] user: drh branch: trunk, size: 49793
19:26
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) file: [ad7c6eef] check-in: [c872d554] user: drh branch: trunk, size: 49771
17:20
Remove or rename local variables that shadow other variables or parameters. (CVS 6005) file: [88050d5a] check-in: [e7e9fa4f] user: drh branch: trunk, size: 49744
2008-11-21
00:10
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) file: [539e28c9] check-in: [b9bc36d3] user: aswift branch: trunk, size: 49830
2008-11-17
19:18
Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) file: [0a505102] check-in: [8009220c] user: danielk1977 branch: trunk, size: 48364
2008-11-10
19:24
Updated comment in source. Ticket #3453. (CVS 5874) file: [5d4333a2] check-in: [83caa220] user: shane branch: trunk, size: 48371
2008-10-31
10:53
Change the way sqlite3VdbeSetColName() is called so as to remove a few lines of code. This also fixes #3470. (CVS 5853) file: [e8b5a6a9] check-in: [bfce9142] user: danielk1977 branch: trunk, size: 48368
2008-10-23
05:45
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) file: [1eb8dad7] check-in: [0e448bc6] user: danielk1977 branch: trunk, size: 48224
2008-10-17
18:51
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) file: [10d61f21] check-in: [39ebf01a] user: danielk1977 branch: trunk, size: 48214
2008-10-10
17:47
Change 'pragma foreign_key_list' to return some extra information. (CVS 5795) file: [f0f48d0d] check-in: [3bb33cf5] user: danielk1977 branch: trunk, size: 48136
2008-09-26
21:08
Add the "truncate" journal mode which commits transactions by truncating the rollback journal file to zero length and not calling fsync(). (CVS 5745) file: [0b1c2d2a] check-in: [7c561f2e] user: drh branch: trunk, size: 47321
2008-09-16
14:38
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) file: [e633b6b7] check-in: [e8418588] user: danielk1977 branch: trunk, size: 47223
2008-09-02
15:44
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) file: [9d00ed41] check-in: [43f757c9] user: danielk1977 branch: trunk, size: 47185
00:52
Continuing work on adding full support for the SQLITE_OMIT_WSD compile-time option. (CVS 5658) file: [9d8127ac] check-in: [ef26ea5c] user: drh branch: trunk, size: 47176
2008-08-20
16:34
When a "pragma main.table_info(...)" is issued, consider only tables from the main database, not the temp db. Ticket #3320. (CVS 5568) file: [f5b271b0] check-in: [d0cfbbba] user: danielk1977 branch: trunk, size: 47131
2008-07-28
19:34
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) file: [6e207b4f] check-in: [e48f9697] user: drh branch: trunk, size: 47111
2008-07-08
07:35
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) file: [6fad83fb] check-in: [92e0cf9a] user: danielk1977 branch: trunk, size: 47109
2008-06-26
10:54
Change the TEMP_STORE preprocessor symbol to SQLITE_TEMP_STORE. (CVS 5312) file: [9a95f5b3] check-in: [1e3b8308] user: danielk1977 branch: trunk, size: 47064
2008-06-22
12:37
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) file: [e6c55362] check-in: [663a590e] user: drh branch: trunk, size: 47028
2008-06-05
11:39
Modify the signatures of the sqlite3_vfs.xAccess and sqlite3_vfs.xCheckReservedLock functions. (CVS 5188) file: [70e7c865] check-in: [4226ac54] user: danielk1977 branch: trunk, size: 47033
2008-06-04
06:45
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) file: [c6dfbd16] check-in: [5c59f469] user: danielk1977 branch: trunk, size: 46986
2008-05-15
17:48
Add the "page_count" pragma. Returns a single integer - the number of pages in the specified database file. (CVS 5135) file: [a4919a29] check-in: [eb6985e6] user: danielk1977 branch: trunk, size: 46414
2008-04-17
20:59
Continuing progress on the journal_mode pragma. It still does not work. (CVS 5027) file: [2e4bb2e7] check-in: [4a72a7bb] user: drh branch: trunk, size: 45849
17:02
Add the journal_mode pragma. This is currently just syntax - it is not operational. (CVS 5024) file: [113f14da] check-in: [8eaa0c71] user: drh branch: trunk, size: 45800
2008-03-27
22:42
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) file: [e659c9e4] check-in: [3cb704c4] user: drh branch: trunk, size: 43840
2008-03-25
17:23
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) file: [99cec6d9] check-in: [ee381b43] user: drh branch: trunk, size: 43838
2008-03-20
11:04
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) file: [f64eed91] check-in: [871df0e7] user: danielk1977 branch: trunk, size: 43843
2008-03-19
00:21
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) file: [09128fe3] check-in: [24e76997] user: drh branch: trunk, size: 43792
2008-02-13
18:25
Where possible, avoid freeing buffers allocated for vdbe memory cells in case they can be reused. (CVS 4783) file: [e3f39f85] check-in: [990237e2] user: danielk1977 branch: trunk, size: 43663
2008-01-22
01:48
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) file: [2bb8d688] check-in: [2a0bc1e1] user: drh branch: trunk, size: 43612
2008-01-17
16:22
Registerification of the VDBE is complete. The operand stack has been removed from the code. All instructions operate out of registers only. (CVS 4718) file: [155315ee] check-in: [706b41b7] user: drh branch: trunk, size: 43604
02:36
Registerification of the WHERE clause logic. (CVS 4716) file: [0768de04] check-in: [b3a141b2] user: drh branch: trunk, size: 43595
2008-01-12
21:35
The sqlite3_trace() callback now prints a message as each trigger fires within a statement. (CVS 4709) file: [b4e77e05] check-in: [110c000d] user: drh branch: trunk, size: 43595
2008-01-10
23:50
More work toward converting the VM into a register-based machine. (CVS 4704) file: [1d3d9dee] check-in: [8cbd4651] user: drh branch: trunk, size: 43580
2008-01-09
23:04
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) file: [bc6063d9] check-in: [e3cf1c1c] user: drh branch: trunk, size: 43082
02:15
Continued work toward converting to a register-based VM. (CVS 4698) file: [355d53bc] check-in: [92deff07] user: drh branch: trunk, size: 42984
2008-01-07
19:20
Registerify the AUTOINCREMENT processing and the OP_IsNull and OP_NotNull operators. (CVS 4692) file: [ebf841ef] check-in: [aa48867c] user: drh branch: trunk, size: 43004
2008-01-05
16:29
Registerify binary operators. Add register tracing to debugging output. (CVS 4686) file: [dfb200ec] check-in: [66396d2f] user: drh branch: trunk, size: 42999
05:20
Register-ify the OP_AddImm and all casting opcodes. Omit the OP_MemIncr opcode. (CVS 4683) file: [1627b350] check-in: [3e8a07dd] user: drh branch: trunk, size: 42921
04:06
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) file: [6f591814] check-in: [cc149eb9] user: drh branch: trunk, size: 42923
2008-01-04
22:01
Implement the out2-prerelease opcode design pattern. (CVS 4681) file: [ff884122] check-in: [fe057a88] user: drh branch: trunk, size: 42923
2008-01-03
18:03
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) file: [ac8d91bb] check-in: [0b849805] user: drh branch: trunk, size: 42916
01:28
Revamp sqlite3VdbeAddOpList() so that the structure holds integer values for P1, P2, and P3. (CVS 4661) file: [61b9d171] check-in: [4dc507d8] user: drh branch: trunk, size: 42916
00:01
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) file: [036e49b8] check-in: [027875e4] user: drh branch: trunk, size: 42634
2008-01-02
00:34
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) file: [4a7f377a] check-in: [051ec01f] user: drh branch: trunk, size: 42480
2007-12-29
13:39
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) file: [dd5b1983] check-in: [2ddc8d72] user: danielk1977 branch: trunk, size: 42456
2007-12-13
21:54
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) file: [2a5f6439] check-in: [4e91a267] user: drh branch: trunk, size: 42155
2007-12-05
01:38
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) file: [0246032d] check-in: [bdfc19e8] user: drh branch: trunk, size: 42156
2007-11-13
10:30
Modify the Tcl interface to use sqlite3_prepare_v2(). (CVS 4542) file: [cb1486e7] check-in: [7bb00c7d] user: danielk1977 branch: trunk, size: 42133
2007-08-31
18:34
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) file: [363e548d] check-in: [306586c4] user: drh branch: trunk, size: 41843
2007-08-30
10:07
Better handle a malloc() failure in sqlite3PagerSetPagesize(). (CVS 4332) file: [59a5e12a] check-in: [41550d87] user: danielk1977 branch: trunk, size: 41778
01:19
Fix for the sqlite3AbortOtherActiveVdbes() problem. (CVS 4328) file: [65109b3d] check-in: [e40d40a5] user: drh branch: trunk, size: 41555
2007-08-21
10:44
Remove unnecessary #includes of "os.h". New mutex implementations. (CVS 4255) file: [9b989506] check-in: [fbbd5bda] user: drh branch: trunk, size: 41447
2007-08-17
15:53
Begin migration to using sqlite3_vfs interface. (CVS 4240) file: [8f5e37c3] check-in: [af3e3c7a] user: danielk1977 branch: trunk, size: 41569
2007-08-16
10:09
More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [873b0b2a] check-in: [77b16713] user: danielk1977 branch: trunk, size: 41526
04:30
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) file: [9ecc2bcd] check-in: [deb7ecd6] user: drh branch: trunk, size: 41514
2007-06-26
10:38
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) file: [7914a6b9] check-in: [7f887a6a] user: danielk1977 branch: trunk, size: 41504
2007-06-25
08:16
Make the auto_vacuum mode peristent in all cases. (CVS 4115) file: [838f7460] check-in: [5b0408dd] user: danielk1977 branch: trunk, size: 41386
2007-06-24
08:00
Add the "(database.)freelist_count" PRAGMA. For querying the size of the database free-list. (CVS 4112) file: [d2e6f5da] check-in: [1fb4251a] user: danielk1977 branch: trunk, size: 39832
2007-05-23
13:50
Make sure the database schema has been read before compiling an incrmental_vacuum pragma. (CVS 4032) file: [0d25dad5] check-in: [efd7bcb3] user: danielk1977 branch: trunk, size: 39611
2007-05-11
12:30
Avoid multiple storage class specifiers ("static extern") in the amalagmation. (CVS 3984) file: [6d5eb19f] check-in: [2f70159b] user: drh branch: trunk, size: 39537
2007-05-08
20:59
Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) file: [0703152b] check-in: [5a0fe985] user: drh branch: trunk, size: 39588
14:51
Add the max_page_count pragma used to limit the maximum size of a database file. Untested. (CVS 3948) file: [b881b457] check-in: [b1b74f06] user: drh branch: trunk, size: 39561
01:08
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) file: [f426fef6] check-in: [93b623b2] user: drh branch: trunk, size: 38968
2007-05-04
18:30
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) file: [3f16c127] check-in: [b13e497a] user: drh branch: trunk, size: 38952
2007-04-26
14:42
Add largely untested code for the incremental vacuum function. (CVS 3876) file: [4fdefc03] check-in: [f6a6d2b8] user: danielk1977 branch: trunk, size: 38296
2007-03-30
17:11
Coverage tests for some pragmas. (CVS 3767) file: [3b992b5b] check-in: [eec7ab63] user: danielk1977 branch: trunk, size: 37650
11:12
Comment changes in btree.c and added a missing "else" in pragma.c. (CVS 3757) file: [8fd4f988] check-in: [9a7d7e31] user: drh branch: trunk, size: 37653
2007-03-24
16:45
Changes for exclusive access mode. There are still some bugs. (CVS 3712) file: [9cb8b94e] check-in: [b6c70037] user: danielk1977 branch: trunk, size: 37657
2007-03-19
17:44
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) file: [a3fe1dac] check-in: [7dc76588] user: danielk1977 branch: trunk, size: 35665
2007-03-14
15:37
Modify the behaviour of writable_schema to ignore schema parsing errors. (CVS 3686) file: [b52dcf2f] check-in: [a8d6d935] user: danielk1977 branch: trunk, size: 35666
2007-01-27
02:24
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) file: [50913009] check-in: [d564a039] user: drh branch: trunk, size: 35640
2007-01-04
22:13
Fix the user_version and schema_version pragmas so that they set a result column name. Ticket #2143. (CVS 3560) file: [fd4df6cf] check-in: [f81c4227] user: drh branch: trunk, size: 35046
2006-11-30
13:06
Change the table_info pragma so that it returns NULL for the default value if there is no default value. Ticket #2078. (CVS 3527) file: [d0891d35] check-in: [5f21c3a5] user: drh branch: trunk, size: 34976
2006-09-25
18:01
Add a pragma for activating proprietary extensions. (CVS 3441) file: [2ef43534] check-in: [c63d34ce] user: drh branch: trunk, size: 35065
13:48
Bug fix in pragma table_info(). (CVS 3440) file: [eac5926d] check-in: [c037403b] user: drh branch: trunk, size: 34580
2006-08-14
14:23
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) file: [dcb79b81] check-in: [b4d53974] user: drh branch: trunk, size: 34483
2006-08-08
13:51
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) file: [cc12939b] check-in: [76e4d418] user: drh branch: trunk, size: 34302
2006-03-03
21:20
The table_info pragma shows column affinity as "" if there is no column affinity. Ticket #1570. (CVS 3122) file: [27d5e395] check-in: [5cae8d63] user: drh branch: trunk, size: 34289
2006-02-17
12:25
Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104) file: [607b0f3b] check-in: [1e4644b2] user: danielk1977 branch: trunk, size: 34304
2006-02-11
01:25
Add support and documentation for the fullfsync pragma. Also include some other unrelated documentation updates. (CVS 3080) file: [31d3e1b7] check-in: [f2069d0b] user: drh branch: trunk, size: 34078
2006-02-10
02:27
Add the column_origin_name() etc. APIs. (CVS 3069) file: [8e135979] check-in: [82f502cd] user: danielk1977 branch: trunk, size: 33999
2006-02-09
16:52
Back out check-in (3058) - it breaks too much application code. (CVS 3063) file: [c26c810e] check-in: [731f1e32] user: drh branch: trunk, size: 33572
2006-02-06
21:34
Add "autoinc" and "collseq" columns to the table_info() pragma. (CVS 3058) file: [09862173] check-in: [7940a590] user: drh branch: trunk, size: 33861
2006-01-12
01:56
Add the legacy_file_format pragma. (CVS 2922) file: [4496cc77] check-in: [b2dbd1a5] user: drh branch: trunk, size: 33575
2006-01-11
14:09
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) file: [d439d257] check-in: [3970eb87] user: danielk1977 branch: trunk, size: 33525
2006-01-10
17:58
Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) file: [711992e4] check-in: [0f0213be] user: danielk1977 branch: trunk, size: 33465
2006-01-09
16:12
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) file: [05abacaa] check-in: [3e75d3d5] user: danielk1977 branch: trunk, size: 33537
2006-01-08
18:10
Get LIMIT and OFFSET working again for negative limits and offsets. Ticket #1586. (CVS 2889) file: [7358baf8] check-in: [b2ac0be0] user: drh branch: trunk, size: 33484
2006-01-06
14:32
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) file: [ae8b1355] check-in: [2529c2e1] user: drh branch: trunk, size: 33484
2006-01-05
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) file: [4af4041a] check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 33494
2005-12-09
20:02
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [8883b4d3] check-in: [83a59151] user: drh branch: trunk, size: 33265
2005-12-08
18:12
Provide a pragma to set the codec key. (CVS 2806) file: [a6d3a7c7] check-in: [a7c9e898] user: drh branch: trunk, size: 33261
2005-11-30
03:20
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) file: [2793699a] check-in: [bd8740d1] user: drh branch: trunk, size: 33138
2005-11-26
00:25
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) file: [e278b3f7] check-in: [1f69aec2] user: drh branch: trunk, size: 33138
2005-11-03
02:15
Add the ignore_check_constraints pragma. VACUUM works even on a database that contains table entries that violate check constraints. (CVS 2757) file: [b4018996] check-in: [be83bfee] user: drh branch: trunk, size: 33136
2005-10-06
13:59
Check-in (2744) as incomplete and broke pragma integrity_check. This completes the change and fixes the problem. (CVS 2746) file: [9ec219dc] check-in: [4862eaaf] user: drh branch: trunk, size: 33045
2005-10-05
11:41
Make sure pragma integrity_check does not report "ok" after first finding a bunch of errors. (CVS 2744) file: [278c8fe2] check-in: [efec04de] user: drh branch: trunk, size: 33045
2005-09-20
17:42
Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) file: [12614966] check-in: [2471957f] user: drh branch: trunk, size: 33000
2005-09-17
16:36
Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) file: [6d773e25] check-in: [1a737b45] user: drh branch: trunk, size: 33408
2005-08-14
01:20
The case_sensitive_like pragma added. Test cases added for the LIKE optimization. (CVS 2592) file: [69413fbd] check-in: [72ee21c0] user: drh branch: trunk, size: 33405
2005-08-13
00:56
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) file: [59ab7073] check-in: [25cfe939] user: drh branch: trunk, size: 33089
2005-06-23
03:15
Make sure the String8 opcode always has a non-null P3 argument in the foreign_key_list pragma. Ticket #1297. (CVS 2525) file: [dea86dad] check-in: [bcf62dc7] user: drh branch: trunk, size: 33089
2005-06-12
21:35
Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) file: [5ea2ba0e] check-in: [36f2da1f] user: drh branch: trunk, size: 33041
2005-06-07
22:22
Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) file: [344e5016] check-in: [62a7353d] user: drh branch: trunk, size: 33041
2005-05-22
06:49
Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) file: [0ed94a1a] check-in: [afc8ce42] user: danielk1977 branch: trunk, size: 32989
2005-04-28
19:03
Add hooks for the SSE extension. (CVS 2449) file: [93d44767] check-in: [90f4cf2a] user: drh branch: trunk, size: 32979
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [845c8ab0] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 32694
2005-02-26
18:10
Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362) file: [4b20dbc0] check-in: [c167e905] user: drh branch: trunk, size: 32643
2005-02-09
03:20
Add experimental collation_list pragma. (CVS 2321) file: [7e65c554] check-in: [f73a8aa3] user: danielk1977 branch: trunk, size: 32346
2005-02-06
02:45
Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) file: [809b95ac] check-in: [2155448d] user: drh branch: trunk, size: 31830
2005-02-04
04:07
Remove code for SQL cursors. (CVS 2312) file: [572d7dd4] check-in: [2eb90870] user: danielk1977 branch: trunk, size: 31780
2005-01-24
10:25
Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) file: [c893f031] check-in: [d5233e07] user: danielk1977 branch: trunk, size: 32384
2005-01-22
03:03
Add the experimental sqlite3_expired() API. (CVS 2263) file: [141a3f49] check-in: [df648d50] user: drh branch: trunk, size: 31998
2005-01-20
11:32
Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) file: [8ab31398] check-in: [5b1a9bf6] user: danielk1977 branch: trunk, size: 31936
2005-01-11
10:25
Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) file: [ac594f74] check-in: [8ced4915] user: danielk1977 branch: trunk, size: 31895
2005-01-08
15:44
Fixes to the temp_store_directory pragma. (CVS 2185) file: [1b6f9f4c] check-in: [0a90eaf3] user: drh branch: trunk, size: 31912
2004-12-25
01:03
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) file: [0394f936] check-in: [5fd1f471] user: drh branch: trunk, size: 32968
2004-12-20
19:01
Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) file: [639a7e7e] check-in: [772e22cb] user: tpoindex branch: trunk, size: 32975
2004-11-22
19:12
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) file: [d6406e12] check-in: [fc8c1393] user: drh branch: trunk, size: 30268
2004-11-13
15:59
More compile-time options for removing components. (CVS 2098) file: [0b43b8ca] check-in: [dcbc0c22] user: drh branch: trunk, size: 29664
2004-11-12
16:12
Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) file: [32ce8fad] check-in: [5e058318] user: danielk1977 branch: trunk, size: 29461
2004-11-11
05:10
Add the schema_cookie and user_cookie pragmas. (CVS 2089) file: [bb1c76da] check-in: [d28d1d68] user: danielk1977 branch: trunk, size: 29445
2004-11-09
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [44074b93] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 27010
2004-11-05
15:45
Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) file: [6a0ae772] check-in: [b9d5f007] user: danielk1977 branch: trunk, size: 27044
2004-10-31
02:22
Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) file: [44e192eb] check-in: [be661acf] user: drh branch: trunk, size: 26494
2004-10-25
20:33
Minor optimizations in the pragma module. (CVS 2029) file: [263e20f7] check-in: [63efd50a] user: drh branch: trunk, size: 26337
2004-10-22
20:29
Add the experimental and scary pragma "writable_schema". (CVS 2027) file: [2b65e015] check-in: [39f7870a] user: drh branch: trunk, size: 26522
2004-10-06
15:41
Convert many constants to have type "const". (CVS 2006) file: [3134201e] check-in: [d790c84c] user: drh branch: trunk, size: 26481
2004-10-05
15:42
Use the database name supplied to table_info() and related pragmas. (CVS 2001) file: [4a071a19] check-in: [0415af32] user: drh branch: trunk, size: 26432
02:41
Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) file: [ba7fdd19] check-in: [81ff8107] user: drh branch: trunk, size: 26424
2004-09-25
14:39
Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) file: [45978cc8] check-in: [9ef4c24a] user: drh branch: trunk, size: 26464
2004-09-17
20:25
The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) file: [5fb6647f] check-in: [c34f3209] user: drh branch: trunk, size: 26508
2004-09-08
15:09
Always cast 0 to (char*)0 when it is an argument in a varargs function. (CVS 1948) file: [1f7781c4] check-in: [a1f53252] user: drh branch: trunk, size: 26482
2004-09-06
17:24
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) file: [6385059d] check-in: [3ddf5a9d] user: drh branch: trunk, size: 26475
2004-09-05
23:23
Comment changes and minor code cleanup. (CVS 1940) file: [0fbfb504] check-in: [dfa9ea89] user: drh branch: trunk, size: 26472
2004-09-02
15:14
Fix a problem with EXPLAIN on pragmas that return single integer values. Ticket #886 (CVS 1929) file: [71566180] check-in: [8ce3d730] user: drh branch: trunk, size: 26494
2004-08-31
13:45
Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) file: [b39177b9] check-in: [8fd65e70] user: drh branch: trunk, size: 26376
2004-08-21
17:54
Optimizations to the code generator. (CVS 1899) file: [a7cea752] check-in: [bd6649c5] user: drh branch: trunk, size: 26377
2004-08-08
20:22
Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) file: [5cf335ad] check-in: [b0659738] user: drh branch: trunk, size: 26778
2004-07-22
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) file: [c8be1809] check-in: [4cf6e9db] user: drh branch: trunk, size: 26780
2004-06-30
09:49
Coverage tests for vacuum.c (CVS 1776) file: [8326df8c] check-in: [152e9940] user: danielk1977 branch: trunk, size: 24631
2004-06-29
08:59
Fix error reporting path for errors that occur while reading the database schema. (CVS 1757) file: [0ecbe7cc] check-in: [157db33e] user: danielk1977 branch: trunk, size: 24608
07:45
Bug-fixes to get the two threadtest C programs working again. (CVS 1756) file: [b6df9736] check-in: [ffd3312b] user: danielk1977 branch: trunk, size: 24818
2004-06-26
19:35
Coverage testing of pragma.c. (CVS 1744) file: [2ca5ef7e] check-in: [0f9c0f0a] user: drh branch: trunk, size: 24751
06:37
Remove default_synchronous and temp_store pragmas. Allow the safety-level and cache-size to be set for attached databases. (CVS 1735) file: [16713c1b] check-in: [212de3ce] user: danielk1977 branch: trunk, size: 25284
2004-06-21
09:06
Add the OP_Concat8 opcode, similar in concept to OP_String8. (CVS 1648) file: [0750e1c3] check-in: [bbd3e933] user: danielk1977 branch: trunk, size: 30309
08:18
Ensure sqlite3ErrorMsg() is used to report errors during compilation, sqlite3Error() during execution. Also remove unused param from sqlite3VdbeReset() and Finalize(). (CVS 1647) file: [7d75803f] check-in: [7a33daef] user: danielk1977 branch: trunk, size: 30306
2004-06-19
15:22
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) file: [318a6058] check-in: [fbfc3c95] user: drh branch: trunk, size: 30328
14:49
Omit the sqlite3VdbeCode() routine. Use sqlite3NameFromToken() more to reduce the amount of code. (CVS 1639) file: [424d812d] check-in: [99d0436e] user: drh branch: trunk, size: 30202
2004-06-18
23:21
MinGW/MSYS build fixes; ticket #765 (CVS 1625) file: [42de2b32] check-in: [5f383c1e] user: dougcurrie branch: trunk, size: 30274
17:10
Changes to allow libsqlite3.a and libsqlite.a to be both linked into the same program at the same time. (CVS 1621) file: [c11121c2] check-in: [2590fffc] user: drh branch: trunk, size: 30207
2004-06-17
19:04
Documentation updates in preparation for the release of version 3.0.0. (CVS 1613) file: [83b86b29] check-in: [9fb29f73] user: drh branch: trunk, size: 30191
2004-06-16
12:02
Trivial modifications to prevent compiler warnings. (CVS 1607) file: [b51bd203] check-in: [7974c9a6] user: danielk1977 branch: trunk, size: 30141
2004-06-15
16:51
Assorted memory leak fixes. (CVS 1600) file: [be8ed536] check-in: [07b90f36] user: danielk1977 branch: trunk, size: 30081
2004-06-12
00:42
Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) file: [e288bd12] check-in: [9b84f2f4] user: danielk1977 branch: trunk, size: 29972
2004-06-10
10:50
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1562) file: [0bc3adea] check-in: [edf069b9] user: danielk1977 branch: trunk, size: 29944
01:30
Add the vdbe_listing and sql_trace pragmas used for debugging. (CVS 1558) file: [6ab13748] check-in: [28c3cc08] user: drh branch: trunk, size: 29873
2004-06-09
14:17
Add the "lock_status" pragma - only available when SQLITE_DEBUG is defined. Used for testing only. (CVS 1547) file: [32516286] check-in: [0ecbba78] user: drh branch: trunk, size: 29757
12:30
Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) file: [d63b011b] check-in: [beab038c] user: danielk1977 branch: trunk, size: 28677
00:48
Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) file: [9328a31c] check-in: [10861964] user: drh branch: trunk, size: 27921
2004-06-07
07:52
Add pragma to set/get text encoding. Also fix an obscure problem where a temp trigger could be accidently dropped. (CVS 1537) file: [54b4d67f] check-in: [983221b0] user: danielk1977 branch: trunk, size: 27886
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [1b58d852] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 24315
2004-05-31
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [7f432dee] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 24318
2004-05-29
11:24
Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492) file: [84e778a7] check-in: [3225de89] user: danielk1977 branch: trunk, size: 24329
2004-05-28
16:00
Factor common code for generating index keys into a procedure. Other speed improvements and bug fixes. (CVS 1487) file: [0c17b613] check-in: [6661bb5f] user: drh branch: trunk, size: 24303
2004-05-26
10:11
Add some tests for the new API. Many more to come. (CVS 1462) file: [f2b05b08] check-in: [d5659f2e] user: danielk1977 branch: trunk, size: 24688
06:58
Remove the show_datatypes pragma. (CVS 1461) file: [aa6a8870] check-in: [93bb958d] user: danielk1977 branch: trunk, size: 25270
00:01
Minor code fixes in btree.c and pragma.c to help with watcom C. (CVS 1457) file: [02b57add] check-in: [143c502a] user: drh branch: trunk, size: 25320
2004-05-25
23:35
Move the sqlite3_exec() function to legacy.c. (CVS 1455) file: [399feca7] check-in: [9385ad5c] user: danielk1977 branch: trunk, size: 25334
2004-05-22
21:30
Remove the OP_SetInsert opcode. (CVS 1443) file: [e14dd3b0] check-in: [18e690e4] user: drh branch: trunk, size: 24873
2004-05-20
22:16
Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) file: [aeeba7dc] check-in: [a6cb09d7] user: drh branch: trunk, size: 25447
2004-05-18
22:17
Remove the OP_StrEq opcodes. (CVS 1397) file: [2332e7fa] check-in: [238442bb] user: drh branch: trunk, size: 25416
09:58
Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1392) file: [fcbd8bc7] check-in: [a62872aa] user: danielk1977 branch: trunk, size: 25427
01:23
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) file: [2c65f46a] check-in: [202a470f] user: danielk1977 branch: trunk, size: 25427
2004-05-16
11:15
More changes to support the manifest type model. A few things are currently broken. (CVS 1385) file: [351836bc] check-in: [a4af838f] user: danielk1977 branch: trunk, size: 25289
2004-05-11
08:48
More small changes to get test cases to execute. (CVS 1355) file: [2ab2a12b] check-in: [6dc60046] user: danielk1977 branch: trunk, size: 25286
07:11
Remove code dealing with old file formats. (CVS 1354) file: [cef4b66b] check-in: [dfde1121] user: danielk1977 branch: trunk, size: 25283
2004-05-08
08:23
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) file: [d9f8332a] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 25308
2004-04-23
17:04
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) file: [f9c157b0] check-in: [7ace5762] user: drh branch: trunk, size: 25143
2004-02-22
20:05
Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266) file: [621d3195] check-in: [51f1e8f7] user: drh branch: trunk, size: 24741
2004-02-21
14:00
Flag pragmas like vdbe_trace now return their current setting if they are called with no arguments. (CVS 1257) file: [a8d43661] check-in: [6a5fb5b8] user: drh branch: trunk, size: 25317
13:31
More code cleanup and size reduction. (CVS 1256) file: [dab17a60] check-in: [8e3eda2a] user: drh branch: trunk, size: 24784
2004-02-20
14:50
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) file: [fe677be9] check-in: [574dd444] user: drh branch: trunk, size: 24658
2004-02-16
03:44
Remove the NullCallback opcode. Handle the empty_result_set pragma inside the sqlite_exec() function. (CVS 1244) file: [23dac1d2] check-in: [f7213485] user: drh branch: trunk, size: 24464
2004-01-19
04:52
comment (CVS 1188) file: [89d62c31] check-in: [fa55c986] user: jplyon branch: trunk, size: 24467
2003-12-16
03:44
Improvements to the way PRAGMA integrity_check works. More likely to output userful information when given a corrupt database. (CVS 1132) file: [deec7342] check-in: [b92c31d6] user: drh branch: trunk, size: 24404
2003-08-23
22:40
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) file: [cee60f17] check-in: [5232b066] user: drh branch: trunk, size: 24731
2003-06-15
23:42
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) file: [3b4f5a80] check-in: [c9734c27] user: drh branch: trunk, size: 23335
2003-06-04
15:48
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) file: [f439a615] check-in: [f39100f5] user: drh branch: trunk, size: 18055
2003-05-13
08:01
Removed 3rd (file) column from PRAGMA database_list until tests are fixed. (CVS 974) file: [ec64704e] check-in: [4183cf97] user: jplyon branch: trunk, size: 17875
2003-05-11
20:09
Changed PRAGMA database_list to show the filename. (CVS 968) file: [8928b747] check-in: [3da10d2d] user: jplyon branch: trunk, size: 18059
2003-05-10
03:03
Removed never-used pragma "result_set_details". (CVS 964) file: [c2e932cb] check-in: [bf558e79] user: jplyon branch: trunk, size: 17875
2003-04-25
02:43
Get VACUUM working again - with test cases. Some other minor cleanups. (CVS 931) file: [118fe400] check-in: [5afb8800] user: drh branch: trunk, size: 18066
2003-04-22
20:30
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) file: [3b1e8da8] check-in: [c675a550] user: drh branch: trunk, size: 18008
2003-04-15
01:19
Change some variable names and comments in the new in-memory database file implementation. Partial (non-working) implementation of the VACUUM command. (CVS 904) file: [aef327bd] check-in: [e76787f8] user: drh branch: trunk, size: 18005
2003-04-13
18:26
Support in-memory databases for temp tables (CVS 903) file: [476b1389] check-in: [96336bff] user: paul branch: trunk, size: 17993
2003-04-06
21:08
Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) file: [927fc036] check-in: [73359037] user: drh branch: trunk, size: 15577 Added