/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of src/build.c

2019-10-09
17:06
An alternative, experimental lookaside memory allocator that uses two different slot sizes. file: [804fd944] check-in: [5ba8cee8] user: sperry branch: 2-size-lookaside, size: 161747
15:00
Change sqlite3SelectDup() to always return NULL if an OOM has occurred. file: [41d42160] check-in: [01ba4641] user: drh branch: trunk, size: 161662
2019-10-05
14:39
Performance optimization to the lookaside-memory disabling mechanism. file: [13de2fda] check-in: [17ce1c49] user: drh branch: trunk, size: 161700
2019-09-30
16:57
Merge in the 3.30.0 beta 1 changes. file: [d7bb76a0] check-in: [06796124] user: drh branch: reuse-schema, size: 164142
16:14
Merge the 3.30.0 beta 1 changes from trunk. file: [4ab4e86d] check-in: [a003818f] user: drh branch: begin-concurrent, size: 161806
2019-09-26
20:05
Allow DROP TABLE to work on tables name "sqlite_parameters" just as it does with tables named "sqlite_stat%". Fix for the ".parameter clear" command in the shell. file: [4814d55a] check-in: [e768179b] user: drh branch: trunk, size: 161717
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [ab0e3560] check-in: [27eb2236] user: drh branch: reuse-schema, size: 164089
12:08
Merge recent trunk enhancements into the begin-concurrent branch. file: [acaa1995] check-in: [93b9ef3f] user: drh branch: begin-concurrent, size: 161753
2019-08-23
21:11
Attempt to parse the NULLS LAST clause more efficiently. A few cycles were saved, but at the expense of more code. And there is a bug was introduced somewhere. Not worth continuing down this line. file: [86827bdb] check-in: [12d2cf88] user: drh branch: dead-end, size: 161714
2019-08-19
17:26
Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. file: [da5d5d82] check-in: [bb9767a2] user: dan branch: nulls-last, size: 161664
2019-08-17
15:47
Merge trunk changes into this branch. file: [39f44877] check-in: [db1e6080] user: dan branch: nulls-last, size: 161013
2019-08-13
15:22
Merge latest trunk changes with this branch. file: [7d974292] check-in: [5b4689d8] user: dan branch: reuse-schema, size: 163351
2019-08-12
16:36
Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index. file: [3584e598] check-in: [07babb0f] user: dan branch: nulls-last, size: 160995
14:17
Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. file: [7fb6ad35] check-in: [48d9b48a] user: drh branch: trunk, size: 160926
00:08
Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. file: [d38b82d2] check-in: [724f4df9] user: drh branch: trunk, size: 160868
2019-08-08
15:24
Remove support for STAT3. The sqlite_stat3 tables are ignored, if they exist. STAT4 continues to work as it always has, and as it is a superset of STAT3 is the recommended replacement. file: [9217f26f] check-in: [1e17ea2f] user: drh branch: omit-stat3, size: 160021
2019-08-06
14:37
Use 0x40 (ASCII '@') instead of 0x00 to mean "no affinity" so that columns with no affinity can appear in a zero-terminated string. Use the new SQLITE_AFF_NONE macro for this new magic number. file: [14906ec3] check-in: [e8234f69] user: drh branch: pending, size: 160030
2019-08-05
19:32
One of two options on how to address ticket [61c853857f40da49]. In this mode, we back out the documentation change of [07b7749da88d54e5] and change the core to work as it has been documented to work since 2017, rather than how it has actually worked since 2009. file: [b48552e6] check-in: [09cd0c0c] user: drh branch: tkt-61c853-A, size: 159941
2019-07-26
20:54
Merge latest changes from trunk into this branch. file: [02ec8b22] check-in: [7f1e4e4b] user: dan branch: reuse-schema, size: 162340
2019-07-17
18:11
Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. file: [89af0fb6] check-in: [bda25883] user: drh branch: branch-3.29, size: 159876
09:18
Fix problems with duplicate fields in the PRIMARY KEYs of WITHOUT ROWID tables. file: [48f22e7c] check-in: [bd9a47a3] user: dan branch: wor-pk-dups, size: 159915
2019-07-16
19:44
Add new assert() statements in an attempt to help static analyzers avoid false-positives. file: [cd19eb05] check-in: [9e664585] user: drh branch: trunk, size: 159752
2019-07-08
21:32
Merge recent trunk enhancements into the reuse-schema branch. file: [c3ea3b48] check-in: [fae92fee] user: drh branch: reuse-schema, size: 162138
21:06
Merge recent trunk enhancements into the begin-concurrent branch. file: [e39e67cd] check-in: [7fff0803] user: drh branch: begin-concurrent, size: 159802
13:45
Fix an assert() that [28196d89] caused to fail. file: [23a0253a] check-in: [8fb0c6d5] user: dan branch: trunk, size: 159713
2019-05-24
13:04
Merge recent enhancements from trunk. file: [20965f9b] check-in: [ff9f3e09] user: drh branch: reuse-schema, size: 161901
2019-05-21
16:32
Fix a problem in [b5ca442a] causing an assert() to fail in REINDEX commands. file: [c5b97d35] check-in: [a3e77c77] user: dan branch: trunk, size: 159476
14:42
Use a statement journal for all CREATE INDEX statements in case an indexed exprsesion throws an exception when it is evaluated. Fix for [b5ca442a]. file: [846b6106] check-in: [b8071d10] user: dan branch: trunk, size: 159463
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [ae462f77] check-in: [018f3199] user: drh branch: reuse-schema, size: 161360
21:51
Merge the latest trunk enhancements into begin-concurrent. file: [2e9b0fc0] check-in: [5d3a6e18] user: drh branch: begin-concurrent, size: 159024
00:43
Disable index seek optimizations on REINDEX when the order of primary keys in the index differs from the main table. Fix for ticket [bba7b69f9849b5bf11b4]. file: [aead3d74] check-in: [f7aadfab] user: drh branch: trunk, size: 158935
2019-05-06
16:15
Fix a problem with renaming an INTEGER PRIMARY KEY column of a WITHOUT ROWID table using ALTER TABLE. file: [23e9332b] check-in: [91f701d3] user: dan branch: trunk, size: 158344
2019-04-29
13:30
Improved header comment and precondition checking for the new isDupColumn() function. file: [2d9ddfea] check-in: [740d5ff6] user: drh branch: tkt-3182d38790, size: 158238
2019-04-28
19:27
Take collating sequence into account when removing redundant columns from indexes on WITHOUT ROWID tables. This is the first proof-of-concept fix for ticket [3182d3879020ef3]. More testing needed. file: [3fedab95] check-in: [b34fa5bf] user: drh branch: tkt-3182d38790, size: 157958
2019-04-27
20:16
Fix a minor typo in a comment. No changes to code. file: [e9d560fd] check-in: [95209072] user: drh branch: trunk, size: 156675
2019-04-15
15:35
Merge recent changes from trunk into reuse-schema file: [ed008d99] check-in: [5c6c9e7f] user: drh branch: reuse-schema, size: 159100
14:59
Merge the latest enhancements from trunk. file: [2455b010] check-in: [7c328e88] user: drh branch: begin-concurrent, size: 156764
2019-04-13
14:07
Fixes for harmless compiler warnings. file: [61655dad] check-in: [c28c973a] user: drh branch: trunk, size: 156675
04:01
Enforce the SQLITE_LIMIT_COLUMN limit on virtual tables. file: [55a1fce8] check-in: [0b6ae032] user: drh branch: trunk, size: 156680
2019-04-10
00:58
Do not place arbitrary restrictions on the length of the failure message for a uniqueness constraint. file: [b3bda944] check-in: [037da798] user: drh branch: trunk, size: 156625
2019-04-09
20:50
Fix a problem caused by a small SQLITE_LIMIT_LENGTH value and a CREATE TABLE with a very large name. file: [82954fd1] check-in: [9b5d4088] user: dan branch: toobig-fix, size: 156648
2019-04-04
20:21
Provide a DBCONFIG to enable or disable virtual tables that match a LIKE pattern. file: [1ca296f4] check-in: [b40a4edc] user: drh branch: disable-vtab, size: 156606
2019-03-31
21:09
Early detection of too many columns in an index avoid a possible 16-bit signed integer overflow. file: [cb2cddfb] check-in: [8af0caeb] user: drh branch: trunk, size: 156566
2019-03-28
04:03
If the string formatter in sqlite3NestedParse() fails due to an over-length string, make sure this error is recorded by the parser so that it knows to fail. file: [241006a9] check-in: [85e53ff1] user: drh branch: trunk, size: 156454
2019-03-26
12:07
Merge recent enhancements from trunk. file: [1d5dc39c] check-in: [774d0d52] user: drh branch: begin-concurrent, size: 156523
11:57
Merge recent trunk enhancements. file: [c973531d] check-in: [db4e2cc3] user: drh branch: reuse-schema, size: 158859
2019-03-25
21:55
Remove a test from the index build logic which is no longer needed and is in fact unreachable. file: [7c885189] check-in: [9b20ee10] user: drh branch: trunk, size: 156434
21:35
Change the name of the parameter table in the CLI to "sqlite_parameters". Doing so involves adding SQLITE_DBCONFIG_WRITABLE_SCHEMA and allowing the creation of tables whose names begin with "sqlite_" and that are indexed while writable_schema is on. file: [2c7cde0f] check-in: [24ef3844] user: drh branch: trunk, size: 156494
2019-03-21
17:22
Merge latest trunk changes with this branch. file: [34ff5042] check-in: [3196f5f4] user: dan branch: reuse-schema, size: 158897
17:13
Disable the feature on this branch in non-SQLITE_ENABLE_SHARED_SCHEMA builds. file: [83ab7370] check-in: [b8e53608] user: dan branch: reuse-schema, size: 158844
2019-03-20
20:02
Use the IsReuseSchema() macro more consistently. Also, rename it to IsSharedSchema(). file: [f570cb78] check-in: [c1be211c] user: dan branch: reuse-schema, size: 158802
19:17
Fix an error message. file: [ace0fcc6] check-in: [a70fdaa3] user: dan branch: reuse-schema, size: 158793
16:58
Fix a potential dangling pointer deference in an ALTER TABLE run on a schema that contains constructs of the form "PRIMARY KEY(column COLLATE collation)". file: [0f88a2f5] check-in: [b9e2393c] user: dan branch: trunk, size: 156472
2019-03-08
15:30
Merge all the latest enhancements from trunk. file: [b85d9265] check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 156508
2019-02-25
19:23
Fix a comment in build.c. file: [f556ca5f] check-in: [d6a9bff6] user: dan branch: reuse-schema, size: 158769
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. file: [5db33002] check-in: [64f97530] user: dan branch: reuse-schema, size: 158494
2019-02-22
17:44
Merge latest trunk changes into this branch. file: [7971c75f] check-in: [001771af] user: dan branch: reuse-schema, size: 158479
16:18
In sqlite3NestedParse() be sure to detect all SQLITE_NOMEM and SQLITE_TOOBIG errors and to distinguish between them. file: [3acec29b] check-in: [73056b31] user: drh branch: trunk, size: 156419
2019-02-21
18:11
Fix OOM handling in sqlite3NestedParse(). file: [a8789fbc] check-in: [e6e9dd5c] user: dan branch: nested-parse-oom, size: 156257
2019-02-20
18:44
Further test cases and fixes for SQLITE_OPEN_SHARED_SCHEMA. file: [f0bc756b] check-in: [ba0ab042] user: dan branch: reuse-schema, size: 158084
2019-02-19
18:00
Improve error messages caused by corrupt database schemas in OPEN_SHARED_SCHEMA mode. file: [80f9e220] check-in: [8ac75b8a] user: dan branch: reuse-schema, size: 158065
13:51
New assert() to verify the TF_HasprimaryKey flag. file: [ac41c86b] check-in: [0abace8a] user: drh branch: trunk, size: 156232
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: [87a0bc49] check-in: [88cbf54e] user: dan branch: reuse-schema, size: 158034
2019-02-15
19:00
Fix a problem with eponymous virtual tables and SHARED_SCHEMA databases. Also, after preparing statements that require all database schemas (REINDEX, ANALYZE, CREATE, DROP and some PRAGMA statements), do not allow the database connection to return more than one schema to each schema-pool. file: [9ee9a6d4] check-in: [ecf6251e] user: dan branch: reuse-schema, size: 157569
2019-02-14
21:04
Fix SQLITE_DBSTATUS_SCHEMA_USED so that it works with SQLITE_OPEN_SHARED_SCHEMA connections. file: [364c8fa5] check-in: [d43b3c05] user: dan branch: reuse-schema, size: 157375
18:38
Change the name of the SQLITE_OPEN_REUSE_SCHEMA flag to SQLITE_OPEN_SHARED_SCHEMA. file: [66830361] check-in: [7257fcc8] user: dan branch: reuse-schema, size: 157385
2019-02-13
18:29
Avoid crashing after parsing a corrupt schema with a REUSE_SCHEMA connection. file: [c6b40555] check-in: [b102148e] user: dan branch: reuse-schema, size: 156822
08:40
Fix a problem with OPEN_REUSE_SCHEMA connections reloading the temp schema. file: [98beafec] check-in: [7c2ec2d4] user: dan branch: reuse-schema, size: 156852
2019-02-12
19:20
Share schemas between databases attached to the same database handle. file: [70fa06d9] check-in: [ea611d7c] user: dan branch: reuse-schema, size: 156684
2019-02-11
20:13
Merge latest trunk changes into this branch. file: [4406cadb] check-in: [dbedd81b] user: dan branch: reuse-schema, size: 156145
01:58
Add an assert() in an attempt to repro an ASAN warning from OSSFuzz. file: [b0a9ee5b] check-in: [7b412224] user: drh branch: trunk, size: 156024
2019-02-06
01:18
When extending the size of SrcList objects, do not attempt to use extra space on the end of the allocation, as that provides scarcely any performance benefit but does greatly complicate cross-platform testing. file: [906ca666] check-in: [3087a0c3] user: drh branch: trunk, size: 156002
2019-02-05
19:51
Merge latest trunk into this branch. file: [5c99b587] check-in: [c089cc4f] user: dan branch: reuse-schema, size: 156216
2019-02-04
21:02
Fix a problem with reloading the schema on this branch. file: [6466a704] check-in: [5dfbef83] user: dan branch: reuse-schema, size: 153677
2019-02-02
21:02
Try new approach ensuring that each Schema object is only used by one connection/database at any one time. file: [8b9dfd5e] check-in: [9e8e5f52] user: dan branch: reuse-schema, size: 153691
2019-01-30
19:50
Change the error message slightly for when two or more indexes have the same rootpage. file: [fe6e3753] check-in: [916c52da] user: drh branch: trunk, size: 156095
19:12
When parsing the schema, check for duplicate index root page numbers before adding the index to the schema hash table. file: [f2805f5d] check-in: [6b360bc0] user: dan branch: trunk, size: 156096
18:33
Detect if two indexes of the same table share a common rootpage while parsing the schema, and throw an error immediately. file: [ddcce07e] check-in: [f21c6f13] user: drh branch: trunk, size: 156096
2019-01-17
15:40
Revamp the SrcList allocator routines to be methods of Parse instead of being methods of the "sqlite3" object, so that they can leave better error messages when the SrcList object grows too large. file: [f07c0b15] check-in: [df08d472] user: drh branch: trunk, size: 155896
14:34
Limit the size of SrcList objects to 200 entries (compile-time configurable using -DSQLITE_MAX_SRCLIST=n). The maximum number of tables in a join has always been 64, so this is not a real constraint on capability. Limiting the size of a SrcList prevents DOS attacks (discovered by OSSFuzz) using crazy nexted CTE joins. file: [eb0ab28d] check-in: [7cac614d] user: drh branch: trunk, size: 155914
2019-01-11
17:41
Fix a problem handling a negative value in the "number-of-pages" database header field. Also a problem with running "REINDEX tbl" against a virtual table for which the SQL passed to sqlite3_declare_vtab() contains PRIMARY KEY or UNIQUE constraints. file: [b1e24f1d] check-in: [556dd892] user: dan branch: trunk, size: 154978
2019-01-09
02:02
Enhance the ALTER TABLE RENAME COLUMN feature so that it works on tables that have redundant UNIQUE and/or PRIMARY KEY constraints. Fix for ticket [bc8d94f0fbd633fd9a051e3] file: [2a1b80db] check-in: [f09aa324] user: drh branch: trunk, size: 154932
2019-01-02
16:08
Merge latest trunk changes into this branch. file: [1c36fd26] check-in: [5bf212f1] user: dan branch: begin-concurrent, size: 154874
2018-12-28
21:40
Merge performance enhancements and other patches. file: [f5968d80] check-in: [44e1b55a] user: drh branch: factor-out-scalar-subselect, size: 155150
17:45
Fix a problem causing the sqlite_master entry corresponding to a virtual table to be removed by a DROP TABLE even if the call to the vtabs xDestroy() method failed. file: [5ca38181] check-in: [0140f6db] user: dan branch: trunk, size: 154785
2018-12-27
17:11
Merge latest wal2 changes with this branch. file: [a1bfe29e] check-in: [ea96001e] user: dan branch: begin-concurrent-wal2, size: 154845
2018-12-26
15:04
Here is the beginnings of an effort to factor out the implementation of scalar subqueries to be implemented as subroutines at the end of the main body of bytecode, after the jump back to the OP_Init opcode. This is an incremental check-in that contains only preliminary changes. file: [b6200913] check-in: [50e5f390] user: drh branch: factor-out-scalar-subselect, size: 155121
2018-12-21
19:29
Add new sqlite3_prepare_v3() flag SQLITE_PREPARE_NO_VTAB, for preparing statements that are not allowed to use any virtual tables. Use this to prevent circular references in triggers on virtual table shadow tables from causing resource leaks. file: [cb86906f] check-in: [25666e3d] user: dan branch: prepare-no-vtab, size: 154756
2018-12-06
02:08
Merge bug fixes from trunk. file: [a5402bf3] check-in: [1e13aaa2] user: drh branch: begin-concurrent, size: 154724
02:01
Remove the unused pColHash field from the Table object. file: [ef9d7dc7] check-in: [3a2c0479] user: drh branch: trunk, size: 154635
2018-12-05
13:44
Merge enhancements from trunk, especially the enhanced sqlite3_normalized_sql() interface. file: [7d86c455] check-in: [47b73f6b] user: drh branch: begin-concurrent, size: 154868
2018-12-04
01:18
Attempt to make the parser a little faster by storing the ON and USING clause in a single OnUsing object. file: [0bd866f9] check-in: [6770ed08] user: drh branch: on-using-opt, size: 154814
2018-12-03
18:15
Bring up to date with version 3.26.0. file: [5e04fb85] check-in: [f0ddb358] user: drh branch: begin-concurrent, size: 154882
2018-12-01
21:13
Very slightly smaller and faster. file: [fce47a97] check-in: [27798f17] user: drh branch: trunk, size: 154779
2018-11-28
08:02
Fixes for SQLITE_OMIT_VIRTUAL_TABLE builds. file: [127d33ad] check-in: [9bcdec85] user: dan branch: trunk, size: 154793
2018-11-27
19:47
Fix a failing assert() in sqlite3ResetAllSchemasOfConnection(). file: [06b417bd] check-in: [0ea049f3] user: dan branch: trunk, size: 154675
2018-11-26
07:21
Merge latest trunk changes into this branch. file: [ce4de1bc] check-in: [28a615a2] user: dan branch: begin-concurrent, size: 154661
2018-11-20
16:02
Consolidate the two sqlite3SchemaToIndex() routines. file: [d31ac32f] check-in: [dfab7170] user: dan branch: reuse-schema1, size: 154734
2018-11-19
20:41
Fix a problem with virtual tables in shared schemas. file: [6ef4b77f] check-in: [84be9220] user: dan branch: reuse-schema1, size: 154741
2018-11-17
18:45
Merge latest trunk changes into this branch. file: [20c584fc] check-in: [9fdd1868] user: dan branch: reuse-schema1, size: 154740
18:11
Fix further problems with the feature on this branch. file: [f7487a05] check-in: [6d7a7e5f] user: dan branch: reuse-schema1, size: 153724
2018-11-16
17:04
Fix further REUSE_SCHEMA issues. file: [82e91981] check-in: [9780829a] user: dan branch: reuse-schema1, size: 153748
2018-11-15
21:20
Fix some problems with the feature on this branch. Many problems remain. file: [ce75a583] check-in: [31b6aee7] user: dan branch: reuse-schema1, size: 153715
2018-11-09
18:44
Merge latest trunk changes with this branch. file: [b48fa5d9] check-in: [ae88f8e1] user: dan branch: reuse-schema, size: 153709
2018-11-08
17:32
Improved documentation for SQLITE_DBCONFIG_DEFENSIVE. Add a NEVER() macro on an unreachable branch. file: [d70d8bad] check-in: [9292d335] user: drh branch: read-only-shadow, size: 154579
2018-11-06
13:37
Add enforcement of read-only on shadow tables. This does not currently work since some virtual tables are attempting to update shadow tables using sqlite3_exec(). file: [5bc91901] check-in: [f79b47c9] user: drh branch: read-only-shadow, size: 154572
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: [3b611e7d] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 154667
19:37
Add the SQLITE_DBCONFIG_DEFENSIVE flag. file: [a614b226] check-in: [11d98414] user: drh branch: trunk, size: 153556
16:38
Eponymous virtual tables appear to exist in all schemas. This is an alternative and improved fix to the eponymous virtual table in trigger problem that was previously addressed by checkin [1fa74930ab56171e]. file: [dad9c5ef] check-in: [b8d35c4a] user: drh branch: trunk, size: 153006
2018-11-03
17:31
Correct the internal logic for SQLITE_DBCONFIG_DEFENSIVE. file: [55f10596] check-in: [76094345] user: drh branch: dbconfig-defensive, size: 153625
16:09
Add the SQLITE_DBCONFIG_DEFENSIVE flag. file: [f5d49f97] check-in: [af3f29d4] user: drh branch: dbconfig-defensive, size: 153094
2018-10-31
19:01
Add support for the SQLITE_PREPARE_NORMALIZED flag and the sqlite3_normalized_sql() when compiling with SQLITE_ENABLE_NORMALIZE. Also remove unnecessary whitespace from Makefiles. file: [792a3246] check-in: [790ea39a] user: drh branch: trunk, size: 153075
2018-10-29
21:01
Fix a potential assertion fault that can occur while trying to DROP a table from a corrupted database file. file: [bd475304] check-in: [147a9429] user: drh branch: trunk, size: 152931
17:53
Add the sqlite3_normalized_sql() API. file: [675799ca] check-in: [592b66e8] user: mistachkin branch: normalized_sql, size: 153037
2018-10-08
18:58
Merge latest trunk changes into this branch. file: [9cc3ee9b] check-in: [2ac72114] user: dan branch: reuse-schema, size: 153046
2018-09-28
20:58
Merge latest trunk into this branch. file: [a15d10c6] check-in: [86750c92] user: dan branch: begin-concurrent, size: 152982
2018-09-24
14:10
Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. file: [0b3d4227] check-in: [5a38d928] user: drh branch: trunk, size: 152893
2018-09-17
08:27
Add extra test for the fix on this branch. Also fix a pointer-compare-after-free problem that occurs in similar cases. file: [3bdd61d7] check-in: [1856ea63] user: dan branch: tkt-b41031ea, size: 153020
2018-09-12
08:51
Fix an invalid pointer comparison triggered by renaming a table column when there are views with explicit column names in the schema. file: [90571aa2] check-in: [572de7e4] user: dan branch: trunk, size: 152823
2018-09-07
18:52
Add assert() and ALWAYS() to identify two unreachable branches. file: [08edbe37] check-in: [8fa254aa] user: drh branch: trunk, size: 152744
2018-09-05
14:36
Avoid comparing pointer values after the object that they point to has been deleted. file: [3565efa5] check-in: [2ec7e50c] user: dan branch: alter-table-rename-column, size: 152650
2018-08-29
21:00
Extend RENAME TABLE to edit triggers and views. Still buggy. file: [79c5f752] check-in: [01308bae] user: dan branch: alter-table-rename-table, size: 152577
2018-08-21
16:32
Rename internal function sqlite3RenameToken() to sqlite3RenameTokenMap() and sqlite3MoveRenameToken() to sqlite3RenameTokenRemap(). file: [b49367a9] check-in: [b9ae9a0a] user: dan branch: alter-table-rename-column, size: 152212
2018-08-14
20:18
Have ALTER TABLE RENAME edit column references in CREATE VIEW statements. file: [a2e61e71] check-in: [db829dc1] user: dan branch: edit-trigger-wrapper, size: 152203
16:18
Fix ALTER TABLE RENAME COLUMN in cases where the column being renamed is an IPK declared with a separate PRIMARY KEY clause - "CREATE TABLE x(y INTEGER, PRIMARY KEY(y))". file: [a38f9e25] check-in: [32ca8418] user: dan branch: alter-table-rename-column, size: 151972
2018-08-13
17:14
Edit the WHEN and UPDATE OF clauses of trigger programs as part of ALTER TABLE RENAME COLUMN. file: [49cad074] check-in: [5fdb6b0a] user: dan branch: edit-trigger-wrapper, size: 152005
2018-08-10
19:19
When a column is renamed, update any references to it in REFERENCES clauses that belong to other tables. file: [a8e71a3c] check-in: [191079bd] user: dan branch: alter-table-rename-column, size: 151858
14:23
Fix a problem with renaming columns on tables with REFERENCES clauses that specify a large number of columns. file: [e7c03505] check-in: [d48f7bbd] user: dan branch: alter-table-rename-column, size: 151757
2018-08-09
20:47
Experimental implementation of ALTER TABLE ... RENAME COLUMN. Still buggy. file: [1cdcd12f] check-in: [fa0fc01e] user: dan branch: alter-table-rename-column, size: 151752
2018-08-04
14:30
Remove additional traces of the column cache. file: [fe407be1] check-in: [db6052e9] user: drh branch: omit-column-cache, size: 151216
2018-07-27
22:55
When doing a DROP VIEW do not try to delete entries from the sqlite_stat1 table as there are none. file: [7e827260] check-in: [7efdba2b] user: drh branch: trunk, size: 151291
2018-07-24
22:02
Do not abort running queries due to a CREATE INDEX statement. Allow them to run to completion before being reprepared. Fix for ticket [c694113e50321afdf9]. file: [ae6edcd6] check-in: [2bd59333] user: drh branch: trunk, size: 151262
2018-07-20
20:56
When dropping a view, skip trying to delete from 'sqlite_stat*'. file: [80cd1c21] check-in: [2f5be3a2] user: mistachkin branch: dropViewNoStat, size: 151285
2018-07-10
15:45
Merge latest trunk changes into this branch. file: [da448a48] check-in: [e9a3e864] user: dan branch: begin-concurrent, size: 151345
2018-07-09
18:55
Avoid leaving view-definitions with an incomplete set of column names/types in the in-memory schema if an OOM strikes while allocating the same. file: [d8f6ac1e] check-in: [1ddbb537] user: dan branch: trunk, size: 151256
02:02
During WITHOUT ROWID table creation, if the sqlite3CreateTable() call fails due to an authorizer denying the INSERT into the sqlite_master table, then detect this fact and abort the CREATE TABLE early, to avoid an assertion fault. file: [1f0d0697] check-in: [164b1641] user: drh branch: trunk, size: 151140
2018-06-09
01:12
Compute the bitmask of indexed columns for each index once when the Index objecct is constructed, instead of recomputing it every time it is needed. file: [3b3bfa88] check-in: [d735872e] user: drh branch: trunk, size: 151124
2018-06-06
17:03
Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. file: [3c182a68] check-in: [d7299bfe] user: drh branch: begin-concurrent, size: 150398
2018-05-28
17:31
When compiling with SQLITE_DEBUG, add run-time checks to ensure that no statement aborts unless either there have been no writes or else there is a statement journal. file: [5fc41458] check-in: [5a4542db] user: drh branch: stmt-journal-testing, size: 150309
2018-05-15
11:45
Merge latest trunk changes with this branch. file: [8add8a52] check-in: [ae86cf60] user: dan branch: begin-concurrent, size: 150328
2018-05-14
17:12
Experimental syntax enhancement for an "INDEXED" keyword following a FROM-clause subquery that indicates that an automatic index on that subquery is suggested. file: [d71b7da8] check-in: [32b3d110] user: drh branch: exp-indexed-clause, size: 150254
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: [50ff3e0f] check-in: [87f261f0] user: drh branch: trunk, size: 150239
2018-05-01
18:39
The SQLITE_ALLOW_SQLITE_MASTER_INDEX compile-time option allows a CREATE INDEX statement against the sqlite_master table. Once created, the index works, and is usable by legacy instances of SQLite. file: [0c2be583] check-in: [853f3163] user: drh branch: trunk, size: 150246
2018-04-26
17:54
Merge latest changes from trunk. Including the "ORDER BY ... LIMIT" optimization. file: [1ef89457] check-in: [d8ae7ba0] user: dan branch: begin-concurrent, size: 150233
2018-04-25
12:01
Avoid many unnecessary calls to sqlite3ReadSchema() and sqlite3Init() when the schema is known to be valid already. file: [c4227d05] check-in: [58cf812f] user: drh branch: trunk, size: 150144
2018-04-24
19:21
Merge latest trunk changes into this branch. file: [1a27e1f4] check-in: [b27bd799] user: dan branch: begin-concurrent, size: 150121
2018-04-18
14:48
Omit some code not used without SQLITE_ENABLE_SORTER_REFERENCES. Improvements to comments used for documentation. file: [91d54802] check-in: [f3596ab9] user: drh branch: sorter-reference, size: 150032
2018-04-16
21:12
Add SQLITE_CONFIG_SORTERREF_SIZE configuration option. file: [850d831d] check-in: [b25a7bb7] user: dan branch: sorter-reference, size: 149939
2018-04-12
17:28
Extend the upsert syntax to allow a WHERE clause on the UPDATE. file: [16cbe486] check-in: [e4396c54] user: drh branch: upsert, size: 151466
15:43
Update the upsert parsing so that it accepts conflict-target labels using the PostgreSQL syntax, and also accepts the MySQL "ON DUPLICATE KEY" syntax. file: [6da67b1f] check-in: [c48f64d8] user: drh branch: upsert, size: 151326
13:15
Add the Upsert object for holding upsert clause information. file: [1932d053] check-in: [d83eaed5] user: drh branch: upsert, size: 150577
2018-04-09
00:46
Fix a (harmless) signed integer overflow warning. file: [61320fb8] check-in: [43c2c60c] user: drh branch: trunk, size: 149767
2018-03-28
15:56
Remove tab characters. No logical changes to code. file: [5ac9eb8a] check-in: [eb29b336] user: drh branch: trunk, size: 149751
15:41
Update this branch with latest trunk changes. file: [4b085737] check-in: [df52e89f] user: dan branch: server-process-edition, size: 149786
2018-03-20
13:52
Merge all recent enhancements from trunk. file: [adf56922] check-in: [b0c2f760] user: drh branch: begin-concurrent, size: 149842
2018-03-16
20:15
Better error message text when the schema is corrupted by a CREATE TABLE AS entry. file: [8b53aacc] check-in: [e13993cf] user: drh branch: corrupt-schema, size: 149753
2018-03-02
17:40
Merge latest trunk changes into this branch. file: [4584d3b8] check-in: [36801eff] user: dan branch: begin-concurrent, size: 149809
2018-01-29
16:22
Ensure the "unique-not-null" flag is set for automatic indexes on columns declared with "col UNIQUE NOT NULL" (where the NOT NULL comes after the UNIQUE). file: [672022c0] check-in: [8767f7b8] user: dan branch: trunk, size: 149720
2018-01-10
00:40
Compute the correct column name even if the column identifier is the very last token in the SQL statement. This fixes a problem introduced by check-in [0fdf97efe5df745510c6b] and reported by the community during beta-testing. file: [9f964745] check-in: [36b89d72] user: drh branch: trunk, size: 149264
2017-12-27
19:43
Add and use the internal sqlite3DbSpanDup() interface. file: [a03eb5a1] check-in: [a8e1545c] user: drh branch: span-refactor, size: 149251
19:27
Merge recent enhancements from trunk. file: [972224ed] check-in: [76373091] user: drh branch: span-refactor, size: 149399
2017-12-25
13:43
Fix an assertion fault on a syntax error input caused by check-in [6b2ff26c25bb9da3]. Problem discovered by OSSFuzz. file: [6ab114a9] check-in: [90d6e4f1] user: drh branch: trunk, size: 149183
2017-12-24
18:56
Fix a NULL pointer dereference after a syntax error that can occur as a result of check-in [6b2ff26c25bb9da3] yesterday. This problem was discovered by the OSSFuzz. file: [ab5bdf95] check-in: [d49afb8f] user: drh branch: trunk, size: 149150
00:18
Remove the ExprSpan object. Instead, keep track of the test of subphrases in the parse using the "scanpt" non-terminal. file: [d3d2feee] check-in: [3eab7bdc] user: drh branch: span-refactor, size: 149333
2017-12-23
12:33
Move the generation of output column names earlier in the case of a CREATE TABLE AS. This is a fix for ticket [3b4450072511e62] and a continuation of check-in [ade7ddf1998190b2b63] that fixes cases of ticket [de3403bf5ae5f72ed6] that were missed previously. file: [ed567f08] check-in: [6b2ff26c] user: drh branch: trunk, size: 149117
2017-12-08
19:37
The query planner tries to avoids using indexes that use unknown collating functions. file: [87b68e3b] check-in: [02013fc1] user: drh branch: trunk, size: 149150
2017-11-06
20:02
Merge latest trunk changes into this branch. file: [f890a66f] check-in: [7f217eda] user: dan branch: begin-concurrent, size: 148619
2017-10-31
03:40
Remove unnecessary NEVER() and ALWAYS() conditionals. file: [514db9d4] check-in: [1c80c75d] user: drh branch: trunk, size: 148530
2017-10-21
13:29
Remove unnecessary "#if SQLITE_MAX_COLUMN". SQLITE_MAX_COLUMN is always defined. file: [e24b6114] check-in: [6ec82acd] user: drh branch: trunk, size: 148528
2017-10-10
13:37
DROP TABLE now works for WITHOUT ROWID tables and the SQLITE_OMIT_AUTOVACUUM compile-time option. Fix for ticket [e651b1341861d6] file: [6ffe7697] check-in: [b8c1b5a5] user: drh branch: trunk, size: 148557
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: [ff2ea970] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 149193
10:49
Merge latest trunk changes into this branch. file: [f4d7f09e] check-in: [307b802e] user: dan branch: begin-concurrent, size: 148909
2017-08-29
20:21
Faster memory allocation from lookaside by not trying to keep track of the number of outstanding allocations, and rather computing that value only when requested. file: [e71e96a6] check-in: [a06263f1] user: drh branch: trunk, size: 148820
2017-08-28
17:19
Merge recent enhancements from trunk. file: [a720180d] check-in: [d53108e7] user: drh branch: begin-concurrent, size: 148954
2017-08-18
14:34
Combine the OP_CreateTable and OP_CreateIndex opcodes of the bytecode engine into a single OP_CreateBtree opcode. This simplifies the implementation and makes the bytecode programs clearer. file: [b47a0320] check-in: [eb1202b5] user: drh branch: trunk, size: 148865
2017-08-17
18:23
In sqlite3ViewGetColumnNames(), return the number of errors, not an error code. file: [5b81049a] check-in: [f13682ea] user: drh branch: trunk, size: 149012
02:26
Defer schema resets when the query planner is running. Proposed fix for ticket [be436a7f4587ce517]. file: [559bce11] check-in: [a7bc7752] user: drh branch: trunk, size: 149023
2017-08-14
06:55
Update this branch with latest trunk changes. file: [045e3f46] check-in: [bc2498d6] user: dan branch: server-process-edition, size: 148966
2017-08-12
01:09
Size and performance micro-optimization on sqlite3SrcListIndexedBy(). file: [f8a85d2a] check-in: [28a5aec1] user: drh branch: trunk, size: 148933
2017-08-11
19:16
Merge the latest enhancements from trunk. file: [7c5d92a0] check-in: [47e71695] user: drh branch: begin-concurrent, size: 149012
2017-08-09
20:35
Add experimental sqlite3_open_v2() flag SQLITE_OPEN_REUSE_SCHEMA. For sharing identical in-memory schema objects between connections. file: [5b857c43] check-in: [a6256980] user: dan branch: reuse-schema, size: 148905
2017-08-07
14:15
Update this branch with latest trunk changes. file: [037f793b] check-in: [17bc7ded] user: dan branch: server-process-edition, size: 148956
2017-08-02
22:43
In the KeyInfo object, refactor the nField and nXField elements into nKeyField and nAllField, which are more useful and run a little faster. file: [33b0f605] check-in: [aea5990e] user: drh branch: trunk, size: 148923
2017-08-01
19:53
Split the OP_Last opcode into OP_Last and OP_SeekEnd. Use OP_SeekEnd to position a cursor prior to appending. Ticket [cb91bf4290c211d]. file: [1285d6b7] check-in: [3e02474c] user: drh branch: trunk, size: 148921
13:54
Merge recent enhancements from trunk. file: [f193b9b9] check-in: [aafe1fec] user: drh branch: begin-concurrent, size: 149014
2017-07-31
12:19
Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], cherry-picked from check-in [5216bfb73f1a49bdd8] file: [ce2ee94a] check-in: [322a2ede] user: drh branch: branch-3.19, size: 148744
2017-07-30
20:30
Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136] cherry-picked from [5216bfb73f1a49bdd]. file: [c3837ad5] check-in: [5c8cb1ff] user: drh branch: branch-3.20, size: 148897
18:40
Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID table. This is a fix for ticket [bc115541132dad136], a problem discovered by OSSFuzz. file: [f65f8652] check-in: [5216bfb7] user: drh branch: trunk, size: 148925
2017-07-29
17:10
Merge latest trunk changes with this branch. file: [4da6fe79] check-in: [b42c8779] user: dan branch: server-process-edition, size: 148959
2017-07-26
19:59
Add the new sqlite3.mDbFlags field. Factor out bits of sqlite3.flags that do not interact with PRAGMA statements into sqlite3.mDbFlags. file: [66f3ae9e] check-in: [3808a00f] user: drh branch: trunk, size: 148926
2017-07-20
17:47
Merge all the latest trunk enhancements. file: [62faff08] check-in: [213c61cb] user: drh branch: begin-concurrent, size: 148987
2017-07-08
20:46
Support read-only MVCC transactions in server-mode. Started using "BEGIN READONLY". file: [32107046] check-in: [5a043aa8] user: dan branch: server-process-edition, size: 148931
2017-07-06
01:28
Slightly more compact implementation of the byte-code generator for the COMMIT and ROLLBACK commands. file: [74108007] check-in: [4da663d9] user: drh branch: trunk, size: 148898
01:02
Small performance increase in sqlite3SrcListAppend(). file: [74a7e10f] check-in: [7b2623f1] user: drh branch: trunk, size: 148954
2017-06-28
00:55
Avoid an unnecessary call to sqlite3XPrintf() in the code generator, for a performance improvement. file: [b24e0889] check-in: [29d6ceb3] user: drh branch: trunk, size: 148936
2017-06-06
18:22
Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. file: [3d1abf90] check-in: [802b82f3] user: drh branch: branch-3.8.9, size: 142165
18:20
Add the SQLITE_DEFAULT_ROWEST compile-time option for changing the estimated number of rows in tables that lack sqlite_stat1 entries. file: [88a8cdc1] check-in: [234ede26] user: drh branch: trunk, size: 148848
2017-05-15
17:34
Merge the latest changes from trunk. file: [ba3f3896] check-in: [14ea8400] user: drh branch: begin-concurrent, size: 148834
2017-04-17
17:03
Add support for analyzing trigger programs to the sqlite3_expert code. file: [3fd46781] check-in: [159e8022] user: dan branch: schemalint, size: 148677
2017-04-05
12:39
Split off sqlite3DbFreeNN() from sqlite3DbFree() and use it in cases where we know that the argument to be freed is never NULL. file: [4026a9c5] check-in: [ad90e8bb] user: drh branch: trunk, size: 148745
2017-03-24
15:09
Merge all recent enhancements from trunk. file: [3761b2cc] check-in: [fd5676fe] user: drh branch: begin-concurrent, size: 148830
2017-02-22
19:49
Merge integrity_check and other improvements from trunk. file: [43f903c9] check-in: [fe073905] user: drh branch: auto-analyze, size: 148741
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: [51b473ee] check-in: [5264844b] user: drh branch: integrity-check-improvements, size: 148641
2017-02-17
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: [2e05d036] check-in: [85026c8e] user: drh branch: auto-analyze, size: 148709
2017-01-27
16:24
Merge all recent enhancements from trunk. file: [26f9e24b] check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 148982
2017-01-09
06:53
Disable the optimization from [8cb8516d] (omit TableLock instructions for non-sharable databases) on this branch. This branch uses the TableLock instructions to ensure that the db schema is not written from within a BEGIN CONCURRENT transaction. file: [58bd67d6] check-in: [c8ca3e0a] user: dan branch: begin-concurrent, size: 148698
06:33
Upgrade this branch to 3.16 plus the various fixes that appeared after its release. file: [efef69bb] check-in: [d0e212d0] user: dan branch: begin-concurrent, size: 148661
2016-12-24
19:37
The schema name "main" is always an acceptable alias for the primary database even if the primary database is renamed using SQLITE_DBCONFIG_MAINDBNAME. file: [9e799f1e] check-in: [2f481b85] user: drh branch: trunk, size: 148609
2016-12-16
16:49
Experimental merge of the est_count_pragma and the pragma-as-vtab branches. file: [d814cb15] check-in: [4b73ee33] user: drh branch: est-count-pragma-vtab, size: 148775
15:57
Merge recent trunk enhancements. file: [182877f2] check-in: [74a0ca1f] user: drh branch: est_count_pragma, size: 148670
02:31
Simplifications to facilitate full test coverage. file: [52970b6c] check-in: [01afc515] user: drh branch: pragma-as-vtab, size: 148402
01:09
Merge enhancements from trunk, and especially the ability to use temp.sqlite_master as an alias for sqlite_temp_master. file: [ec9e3595] check-in: [994a4401] user: drh branch: pragma-as-vtab, size: 148431
01:00
All temp.sqlite_master to be used as an alias for sqlite_temp_master. file: [854ec3a2] check-in: [8d646905] user: drh branch: trunk, size: 148297
2016-12-15
20:59
Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. file: [43c9c2bd] check-in: [988a61e8] user: drh branch: pragma-as-vtab, size: 148090
18:59
Do exponential rather than linear expansion of the SrcList.a array when appending new elements, to reduce the number of malloc() calls. file: [4c7952b6] check-in: [4e374912] user: drh branch: trunk, size: 147958
2016-12-14
14:07
Refactor the Table.nRef field as Table.nTabRef for easier grepping. file: [e2b32766] check-in: [9cae4c2e] user: drh branch: trunk, size: 147956
11:14
Three times faster sqlite3SrcListAppend() in the common case by avoiding the call to sqlite3SrcListEnlarge() for the first allocation. file: [66bab5ee] check-in: [0ea2762f] user: drh branch: trunk, size: 147950
2016-11-30
16:39
Merge all the latest changes from trunk. file: [432a2e26] check-in: [7ca58a07] user: drh branch: est_count_pragma, size: 148232
2016-11-09
00:10
Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. file: [178f1669] check-in: [89d958ab] user: drh branch: unpacked-IdxInsert, size: 147859
2016-11-08
17:19
Avoid generating OP_TableLock unnecessary instructions on btrees that are not sharable. file: [fcd220cc] check-in: [8cb8516d] user: drh branch: trunk, size: 147862
2016-10-20
18:20
Add the ability for the PRAGMA statement to accept multiple arguments. Currently all arguments other than the first are ignored. file: [e22e66fb] check-in: [fd81d8a4] user: drh branch: multi-arg-pragma, size: 148148
2016-10-17
23:44
Fix SQLITE_DBCONFIG_REQUIRE_TXN so that it allows BEGIN IMMEDAITE and BEGIN EXCLUSIVE to run outside of a transaction. file: [2f9da95e] check-in: [29997f79] user: drh branch: require-write-txn, size: 146652
2016-09-30
22:24
Avoid initializing the column-cache section of the Parse object, since entries in the cache will be initialized as they are used, and avoiding the initial memset() saves many CPU cycles. file: [59dcfdc1] check-in: [63cf7eaf] user: drh branch: trunk, size: 147775
18:35
Remove unnecessary fields from the Parse object. file: [4d01b74e] check-in: [814e41da] user: drh branch: trunk, size: 147793
2016-09-29
19:50
Remove the peep-hole optimization of removing OP_Close opcodes that come before OP_Halt, as the extra work of removing those opcodes uses more cycles than just running them. file: [ab957122] check-in: [984a96d7] user: drh branch: trunk, size: 148042
2016-09-27
00:09
Update requirements marks due to improvements in the wording of documentation. No changes to code. file: [9a1f228c] check-in: [bf903b2e] user: drh branch: trunk, size: 148099
2016-09-16
11:53
Fix SQLITE_OMIT_AUTHORIZATION so that it compiles cleanly. file: [7438b6da] check-in: [a3e3b3e1] user: drh branch: trunk, size: 147977
2016-08-23
14:42
Fix the SQLITE_USER_AUTHENTICATION login check so that the SQLITE_AUTH_USER error code correctly propagates and is not overwritten by SQLITE_ERROR. file: [c2ccfcdd] check-in: [c640489d] user: drh branch: trunk, size: 147936
2016-08-19
14:20
Add the capability to VACUUM an attached database by specifying the schema name as an argument to the VACUUM command. Since version 2.0, VACUUM has accepted an argument which was silently ignored. Now it has meaning. file: [d32cacbb] check-in: [29d63059] user: drh branch: vacuum-attached-db, size: 147936
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: [c38fd92a] check-in: [92a22f01] user: drh branch: zDbSName, size: 147898
2016-08-11
19:12
Merge version 3.14 plus some subsequent patches (including the page-cache performance patch) from trunk. file: [e3b41d59] check-in: [d9f8918c] user: drh branch: begin-concurrent, size: 147875
2016-08-05
14:35
Fix a very obscure problem following OOM in sqlite3_declare_vtab(). file: [7c3c780b] check-in: [68eac748] user: drh branch: trunk, size: 147823
2016-06-10
22:49
Enhance "PRAGMA table_info" to that it provides information about eponymous virtual tables. file: [d1fdfd7a] check-in: [53a1e5d5] user: drh branch: trunk, size: 147423
2016-06-08
18:07
Prefer to use partial indexes for full table scans when that is possible. file: [53587973] check-in: [fe187432] user: drh branch: trunk, size: 147331
2016-06-04
13:57
Remove an unreachable branch in the UNIQUE constraint parsing. file: [e827e57e] check-in: [313e990c] user: drh branch: trunk, size: 147212
2016-06-02
16:22
Fix corner cases in the WITHOUT ROWID virtual table logic. file: [555b459d] check-in: [a393bbb9] user: drh branch: without-rowid-vtab, size: 147200
2016-05-31
21:18
An experimental branch with code that allows virtual tables to be declared as WITHOUT ROWID tables. This might be useful for virtual tables that model external data sources that do not have a convenient way of computing a unique rowid. The current check-in almost works, but there are still serious issues. file: [7acc29d0] check-in: [49638f18] user: drh branch: without-rowid-vtab, size: 147098
2016-05-20
15:15
Use sqlite3VdbeAddOp0() to code OP_Expire, to save a few bytes. file: [785fa789] check-in: [3d55d24d] user: drh branch: trunk, size: 147258
2016-05-07
12:15
Make the sqlite3DeleteTable() routine smaller and faster. file: [d65be622] check-in: [d75140b8] user: drh branch: trunk, size: 147261
2016-04-20
12:16
Merge all recent enhancements from trunk. file: [034b1b7c] check-in: [1f709fbf] user: drh branch: begin-concurrent, size: 147269
2016-04-18
15:51
Faulty check-in. Extraneous edits that were not logically part of the check-in. file: [16bbcb16] check-in: [abf9d602] user: drh branch: mistake, size: 147228
15:46
Remove quotes from identifiers used as datatype names in a CREATE TABLE statement. Fix for ticket [7d7525cb01b68] file: [42e8ee74] check-in: [eba27d4d] user: drh branch: trunk, size: 147217
2016-04-07
21:29
Carry table column types through into VIEW definitions, where possible. file: [84fb5a66] check-in: [3360ab09] user: drh branch: branch-3.12.0, size: 147201
2016-04-05
20:59
Carry table column types through into VIEW definitions, where possible. file: [1944d95f] check-in: [fb555c3c] user: drh branch: trunk, size: 147190
15:59
Incorrect version of build.c checked in at [87e5f5a6c60e3] (because I neglected to press the "Save" button on the text editor). There is no change to the logic, just improved presentation. file: [c5cf2061] check-in: [cf569f9f] user: drh branch: trunk, size: 146649
14:01
Remove an unnecessary conditional from the index builder. file: [ab763de4] check-in: [87e5f5a6] user: drh branch: trunk, size: 146664
2016-03-29
10:36
Merge 3.12.0 changes. file: [745020bd] check-in: [d7381eff] user: drh branch: begin-concurrent, size: 146712
2016-03-25
12:10
Fix two instances of undefined behavior in the C code - both harmless for all current compilers. file: [39faaaee] check-in: [99fd194c] user: drh branch: trunk, size: 146660
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: [7d1a5e64] check-in: [605eba4a] user: drh branch: trunk, size: 146654
2016-03-16
19:34
Merge the latest enhancements from trunk. file: [12ad19cf] check-in: [a7978ab6] user: drh branch: begin-concurrent, size: 146702
2016-03-09
02:12
Change a branch made obsolete by recent parser enhancements into an assert(). file: [213cbf84] check-in: [ee486ef7] user: drh branch: trunk, size: 146650
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: [43b93fe7] check-in: [842b2116] user: drh branch: schema-storage, size: 146657
13:37
Further simplifications to the grammar. file: [5a3e2c88] check-in: [519fd03b] user: drh branch: schema-storage, size: 146533
2016-02-27
23:25
Update the parser so that it pulls out the column name and type all in one go, rather than using separate reductions. file: [8bde0b1c] check-in: [ad3ffe2e] user: drh branch: schema-storage, size: 146498
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: [6854e717] check-in: [d8c94a46] user: drh branch: trunk, size: 147239
2016-02-24
20:16
Extend [3e9ed1ae] so that covering indexes on WITHOUT ROWID tables are also identified. file: [6661513c] check-in: [e721975f] user: dan branch: trunk, size: 147167
15:43
Identify indexes that completely cover their table. file: [2c85d62e] check-in: [71d488b5] user: drh branch: covering-index, size: 147088
2016-02-15
18:15
Add the SQLITE_NOMEM_BKPT macro to enhance the ability to debug OOM errors. Only effective with compiling with SQLITE_DEBUG. file: [88f185a3] check-in: [9b345476] user: drh branch: trunk, size: 146711
17:44
Merge version 3.11.0 file: [88ec1b5d] check-in: [c393ddc7] user: drh branch: begin-concurrent, size: 146888
2016-02-13
23:43
Enhance ability to debug out-of-memory errors. file: [f1c30432] check-in: [6a9c4a3e] user: mistachkin branch: noMemBkpt, size: 146846
2016-02-11
13:30
Minor simplifications deferred to the next release. file: [7bc84362] check-in: [a863729c] user: drh branch: simplify, size: 146701
2016-02-09
02:12
Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. file: [54866fba] check-in: [ca72be86] user: drh branch: trunk, size: 146836
2016-02-05
14:34
Merge PRAGMA synchronous=EXTRA and OOM performance enhancements from trunk. file: [a9955bb3] check-in: [332c8036] user: drh branch: begin-concurrent, size: 146899
13:38
Add the slightly faster sqlite3DbMallocRawNN(db,n) routine for the majority cases where db is guaranteed to be not NULL. file: [198eaa84] check-in: [0a802e96] user: drh branch: oom-handling, size: 146847
02:42
Further performance improvements that fall out of the mallocFailed changes. file: [784c6136] check-in: [d94416dd] user: drh branch: oom-handling, size: 146826
01:55
Improvements to the way that OOM errors are processed. file: [dcb55142] check-in: [c3ef0347] user: drh branch: oom-handling, size: 146839
2016-02-04
11:48
Remove unnecessary sets of db->mallocFailed. file: [88ee3701] check-in: [b787165b] user: drh branch: trunk, size: 146935
02:34
Add and use the sqlite3VdbeZeroRegister() interface for coding the common operation of writing zero into a register. file: [2d809463] check-in: [1c8d3001] user: drh branch: zero-register, size: 146920
2016-02-02
02:53
Merge recent enhancements from trunk. file: [a1837564] check-in: [347f6a80] user: drh branch: begin-concurrent, size: 146981
00:59
Add the SQLITE_DBCONFIG_REQUIRE_WRITE_TXN connection setting, which if enabled requires all write operations to be enclosed within BEGIN ... COMMIT. file: [bb3c003f] check-in: [7453790c] user: drh branch: require-write-txn, size: 146987
2016-02-01
21:48
Change the OP_SetCookie instruction to write the literal P3 value, not the value in register P3. file: [33dea2ce] check-in: [6d7d4703] user: drh branch: trunk, size: 146929
13:21
Minor simplification to the OP_AutoCommit opcode. Fix some code comments related to transaction control. file: [c177ca70] check-in: [a9b6a067] user: drh branch: trunk, size: 147127
2016-01-30
12:50
Simplification and size reduction to the printf logic. Remove the bFlags parameter from sqlite3VXPrintf() and sqlite3XPrintf(). Use sqlite3XPrintf() instead of sqlite3_snprintf() for rendering P4 values in EXPLAIN output. file: [0510844c] check-in: [0bdb41c4] user: drh branch: trunk, size: 147109
2016-01-26
15:23
Change the automatic index mechanism so that it avoids creating transient indexes on columns that are known to have low cardinality. file: [9135b9b8] check-in: [12ef3a8f] user: drh branch: autoindex-planning, size: 147405
2016-01-22
17:48
Add the sqlite3TokenInit() utility function. file: [b4eba1e8] check-in: [73231753] user: drh branch: trunk, size: 147115
2016-01-20
12:18
Merge recent enhancements from trunk. file: [408543fb] check-in: [5520f600] user: drh branch: begin-concurrent, size: 147219
2016-01-18
13:18
Avoid unnecessary calls to memset() for a small performance improvement. file: [31af80bb] check-in: [9e8c23ac] user: drh branch: trunk, size: 147173
2016-01-16
15:12
Use sqlite3VdbeAddOp4() rather than a separate sqlite3VdbeChangeP4() call, for a slightly smaller and faster binary. file: [59783188] check-in: [a4258cd4] user: drh branch: trunk, size: 147153
2016-01-15
21:55
Remove an unnecessary memset(). file: [a23d2012] check-in: [689421a9] user: drh branch: trunk, size: 147168
16:11
Remove unnecessary de-initialization of the Parse object. file: [ae94a762] check-in: [75ab30c5] user: drh branch: trunk, size: 147226
15:06
Work toward making the schema parsing logic simplier and more compact. file: [2778ccdb] check-in: [c52ca2c0] user: drh branch: trunk, size: 147133
2016-01-14
15:46
Merge the latest enhancements and fixes from trunk. file: [fd8be668] check-in: [fccc5f20] user: dan branch: begin-concurrent, size: 147416
2016-01-07
17:09
Small performance and size optimization spotted while working on the shared-cache problem. file: [9d497ff4] check-in: [828958ff] user: drh branch: trunk, size: 147370
2016-01-06
15:49
Merge changes for version 3.10.0. file: [7fcb454e] check-in: [e1d2ffc0] user: drh branch: begin-concurrent, size: 147663
2016-01-03
18:07
Bug fix: the conflict resolution behavior for the implied NOT NULL constraint on the PRIMARY KEY of a WITHOUT ROWID table should be ABORT. file: [d8006e90] check-in: [e30062e9] user: drh branch: trunk, size: 147617
2016-01-01
14:14
Merge recent trunk enhancements. file: [a79c1b5c] check-in: [6bea792c] user: drh branch: begin-concurrent, size: 147656
2015-12-31
19:04
Fix harmless compiler warning seen with MSVC. file: [1c9fb552] check-in: [98ec778d] user: mistachkin branch: trunk, size: 147610
15:34
Fix harmless compiler warnings associated with SQLITE_ENABLE_HIDDEN_COLUMNS. file: [249e9605] check-in: [9c392c10] user: drh branch: trunk, size: 147602
2015-12-30
16:51
Changes to the way that the default BINARY collating sequence is recorded result in a slightly smaller and slightly faster executable. More work could be done to make this cleaner. file: [5a8611a0] check-in: [2081d757] user: drh branch: trunk, size: 147602
2015-12-02
20:53
Merge recent enhancements from trunk. file: [a3fa162b] check-in: [9130661a] user: drh branch: begin-concurrent, size: 147640
2015-11-26
15:51
Fix a problem with the userauth extension and no-authentication databases. Run the tests for this extension as part of the Debug-One module in releasetest.tcl. file: [e83da4d0] check-in: [8b156219] user: dan branch: trunk, size: 147594
2015-11-21
13:24
Do not allow table-valued function syntax on ordinary tables and views as those objects are not table-valued functions. Fix for ticket [73eba7ba5c7c0fc]. Problem found by libFuzzer. file: [19f7585c] check-in: [ff5716b8] user: drh branch: trunk, size: 147753
2015-11-20
13:49
Merge all the latest enhancements and fixes from trunk. file: [a5976759] check-in: [41c8b8e3] user: drh branch: begin-concurrent, size: 147808
2015-11-19
16:46
Fix problems with INSERT INTO ... SELECT ... statements that write to tables with __hidden__ columns. file: [5a3b7178] check-in: [59bd0ec7] user: dan branch: trunk, size: 147762
14:11
If compiled with SQLITE_ENABLE_HIDDEN_COLUMNS, then columns in ordinary tables and views that have names beginning with "__hidden__" are omitted from the "*" expansion in SELECT statements and from the automatic list of columns following the table name in an INSERT INTO statement. file: [c909d178] check-in: [011904ca] user: drh branch: trunk, size: 147630
13:53
Only support the magic "__hidden__" column name prefix interpretation when compiled with SQLITE_ENABLE_HIDDEN_COLUMNS. file: [c67e12bd] check-in: [5490646b] user: drh branch: hidden-columns-in-tables, size: 148090
13:21
Fix a 10-year-old misguided attempt at parser performance improvement that actually made parsing slightly slower. file: [baee9713] check-in: [3833cbac] user: drh branch: trunk, size: 147306
2015-11-18
18:43
If a table column name begins with "__hidden__" then do not include that column in "*" expansions in SELECT statements, nor fill in that column in an INSERT INTO that omits the column list. This branch is a proof-of-concept only and is not intended to ever be merged into trunk. file: [a62cef33] check-in: [2dbffb3a] user: drh branch: hidden-columns-in-tables, size: 147858
2015-11-01
21:19
If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. file: [ca574d33] check-in: [db319a03] user: drh branch: trunk, size: 147766
2015-10-15
07:44
Merge in the 3.9.0 changes from trunk. file: [569313d3] check-in: [5c3a2a6e] user: drh branch: begin-concurrent, size: 147779
2015-10-10
14:41
Compiler warning fixes: Rename some local variables from "j1" to avoid a name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. file: [d6162335] check-in: [9ddef84d] user: drh branch: trunk, size: 147733
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: [0549b567] check-in: [7d272aa6] user: drh branch: trunk, size: 147724
2015-09-28
15:20
Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. file: [361f58b7] check-in: [e73f919f] user: dan branch: vtab-onepass, size: 147698
2015-09-26
11:15
Fix a memory leak that can occur following a syntax error in CREATE VIEW. file: [edc5a29c] check-in: [f4704035] user: drh branch: trunk, size: 147594
2015-09-15
19:16
Merge enhancements from trunk. file: [a5b54106] check-in: [fc4d1de8] user: drh branch: begin-concurrent, size: 147663
2015-09-14
14:49
Fix a typo in an SQLITE_USER_AUTHENTICATION macro. file: [8a86f420] check-in: [379455af] user: drh branch: trunk, size: 147617
2015-09-09
13:28
When running a CREATE TABLE AS, make the initial temporary sqlite_master entry for the new table a real record rather than a NULL, in case the query after the AS actually tries to read the sqlite_master table. Fix for ticket [acd12990885d9276]. file: [f81380bc] check-in: [4a18d8bd] user: drh branch: trunk, size: 147616
2015-09-08
20:26
Eponymous virtual tables exist in the "main" schema only. Enforce this rule. file: [ba9e1529] check-in: [06f90bb2] user: drh branch: trunk, size: 147464
2015-09-07
20:22
Merge parser enhancements and other improvements and bug fixes from trunk. file: [0620be86] check-in: [9cf3e51b] user: drh branch: begin-concurrent, size: 147439
2015-09-04
17:22
Merge the latest trunk changes, and especially the fix for allowing strings as identifiers in CREATE INDEX statements. file: [1f4fc824] check-in: [a9b84885] user: drh branch: begin-concurrent, size: 146722
13:02
Merge trunk enhancements, and espeically the fix for allowing strings as column identifers in CREATE INDEX statements. file: [5566b341] check-in: [5ff85529] user: drh branch: index-expr, size: 147393
12:54
Continue to support the (broken) legacy syntax of allowing strings for column names in CREATE INDEX statements and in UNIQUE and PRIMARY KEY constraints. file: [3f6176b3] check-in: [3d3df79b] user: drh branch: trunk, size: 146676
2015-09-03
14:18
Merge enhancements from trunk. file: [77da5393] check-in: [1ab10cbf] user: drh branch: index-expr, size: 146453
14:04
Merge trunk optimizations. file: [565d84cf] check-in: [71e7299e] user: drh branch: begin-concurrent, size: 145782
13:46
Add the sqlite3VdbeLoadString() and sqlite3VdbeMultiLoad() routines to help with code generation, especially on PRAGMAs. Rename sqlite3VdbeAddGoto() to just sqlite3VdbeGoto(). file: [6c3a8a9b] check-in: [847387ec] user: drh branch: trunk, size: 145736
2015-09-02
18:40
Add and use the sqlite3VdbeChangeOpcode() routine. Simplify the implementation of the other sqlite3VdbeChange*() routines. file: [4e8b8bde] check-in: [0a5b00e4] user: drh branch: trunk, size: 145745
18:19
Add the sqlite3VdbeAddGoto(v,i) routine as a shorthand for sqlite3VdbeAddOp2(v,OP_Goto,0,i). file: [794cb053] check-in: [be78f413] user: drh branch: trunk, size: 145749
2015-09-01
18:01
Merge the latest trunk enhancements. file: [cbf7c81a] check-in: [3dea0474] user: drh branch: begin-concurrent, size: 145828
00:42
Remove unreachable branches. file: [c6926497] check-in: [fd4da231] user: drh branch: index-expr, size: 146499
2015-08-31
23:09
Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. file: [f85ede9d] check-in: [5a2c0e90] user: drh branch: index-expr, size: 146459
19:38
Always assume that indexed expressions can generate a NULL. Get indexed expressions working for the case of two or more expressions in the same index. file: [9e7216ac] check-in: [cc60321a] user: drh branch: index-expr, size: 146430
14:27
Merge the latest enhancements from trunk. file: [e0902658] check-in: [7bde6d4d] user: drh branch: index-expr, size: 146351
2015-08-29
17:22
Fix the build with -DSQLITE_OMIT_VIRTUALTABLE. file: [511b0213] check-in: [752918de] user: drh branch: trunk, size: 145782
2015-08-28
09:27
Merge latest trunk changes with this branch. file: [bb9335e0] check-in: [57bc0194] user: dan branch: begin-concurrent, size: 145829
2015-08-26
18:04
Merge enhancements from trunk. file: [6b7f6cca] check-in: [ec6ddb3d] user: drh branch: index-expr, size: 146352
11:40
Refactor With.a.zErr into With.a.zCteErr. No logic changes. file: [97f68222] check-in: [58ba7363] user: drh branch: trunk, size: 145783
2015-08-25
16:57
Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. file: [c249a192] check-in: [efaabdb7] user: drh branch: index-expr, size: 146349
11:16
Merge latest trunk changes with this branch. file: [1b5814e0] check-in: [3e7d6dd6] user: dan branch: begin-concurrent, size: 145826
00:34
Fix a memory leak that might occur when compiling with SQLITE_OMIT_CHECK. file: [6debb624] check-in: [8f1d9f1f] user: drh branch: trunk, size: 145780
00:27
Changes toward being able to process indexes on expressions. Not there yet - this check-in is just movement in that direction. Some tests are failing. file: [d9d53c73] check-in: [0ad0f8d7] user: drh branch: index-expr, size: 145547
2015-08-24
20:21
Enhances the parser so that it accepts arbitrary expressions for the arguments of an index, though the code generator still rejects everything other than simple column names. The sqlite3RestrictColumnListSyntax() routine is removed since that feature is now handled by the parser. file: [789e75f3] check-in: [bed42116] user: drh branch: trunk, size: 145813
19:56
Change "BEGIN UNLOCKED" to "BEGIN CONCURRENT". file: [2890c89e] check-in: [ba1ab858] user: dan branch: begin-concurrent, size: 144918
17:42
Enhance the CREATE VIEW syntax so that the names of columns of the view can be specified after the view name. file: [a4e2669b] check-in: [d794b34d] user: drh branch: trunk, size: 146476
15:39
Disallow the use of COLLATE clauses and the ASC and DESC keywords within foreign key constraints and in the argument list to common table expressions. file: [f49c55c1] check-in: [83cbc4d8] user: drh branch: trunk, size: 146004
2015-08-21
16:22
Merge trunk changes with this branch. file: [e47b6fff] check-in: [deaf3b18] user: dan branch: begin-concurrent, size: 144916
2015-08-20
23:28
Fix a couple C99-isms that cause compile errors on MSVC. file: [5eb5d055] check-in: [bc577fe6] user: drh branch: trunk, size: 144872
23:21
Fix corner-case memory management issues in table-valued functions. Change virtual table handling so that if xDestroy is missing the table is eponymous only even if xCreate is present. file: [0ebd9d21] check-in: [774e6a14] user: drh branch: trunk, size: 144872
20:21
Fix stray variable declaration for C89. file: [733a7b19] check-in: [17eb7f18] user: mistachkin branch: trunk, size: 144848
20:13
Correctly handle empty function argument lists on table-valued functions. file: [2a2fd954] check-in: [a7acc787] user: drh branch: trunk, size: 144838
2015-08-19
17:11
A list of arguments following a table name translates into equality constraints against hidden columns in that table. file: [16051071] check-in: [40e12cfe] user: drh branch: table-valued-functions, size: 144829
15:20
Minor refactor of the SrcList object so that it is able to hold the argument list to a table-valued-function in the FROM clause. file: [90941695] check-in: [b9193761] user: drh branch: table-valued-functions, size: 144391
02:32
Initial implementation of eponymous virtual table instances. file: [77a9683d] check-in: [c1f43a77] user: drh branch: table-valued-functions, size: 144154
2015-08-08
23:23
Fix an assert() that was in the wrong spot. file: [4acc35c4] check-in: [962b6cd6] user: drh branch: warnings, size: 143750
22:47
Fix compiler warnings and remove unreachable code. file: [31782da5] check-in: [be190fe7] user: drh branch: warnings, size: 143750
2015-08-03
13:44
Allow a VIEW to reference undefined tables and functions when initially created. The error report is deferred until the VIEW is used. This allows views to be created before subviews and tables that the view references. file: [70a18e12] check-in: [70b57daf] user: drh branch: trunk, size: 143741
2015-07-27
19:31
Add an experimental "BEGIN UNLOCKED" command. file: [28c15c43] check-in: [80794216] user: dan branch: begin-concurrent, size: 143855
2015-06-16
16:39
Ensure that the CREATE TABLE AS statement correctly undoes partial changes to the sqlite_master table if the SELECT on the right-hand side aborts with an error. Fix for ticket [873cae2b6e25b] file: [b3f15255] check-in: [400e025e] user: drh branch: trunk, size: 143811
2015-06-04
12:08
Change the name of SrcList.a[].zIndex to the more descriptive SrcList.a[0].zIndexedBy. file: [6770b74c] check-in: [6a9cf063] user: drh branch: trunk, size: 143780
2015-06-02
15:32
Rename SQLITE_AFF_NONE to SQLITE_AFF_BLOB. file: [73da2b9e] check-in: [bce3f041] user: drh branch: blob-affinity-rename, size: 143768
2015-05-27
13:06
CTEs have never had working rowids. So disallow the use of the "rowid" column within CTEs. file: [85a169a0] check-in: [0055df04] user: drh branch: no-rowid-in-cte, size: 143768
2015-05-26
11:53
Fix a problem with ignoring UNIQUE constraints on WITHOUT ROWID tables rendered redundant by the PRIMARY KEY. file: [9552e749] check-in: [3b936913] user: dan branch: trunk, size: 143748
2015-05-20
17:18
Simplification of the initialization code for CREATE TABLE AS. file: [d5d90907] check-in: [937f659e] user: drh branch: create-table-as-type-fix, size: 143277
15:51
A proposed fix for the problem of CREATE TABLE AS generating a table that has INTEGER values in a TEXT column. Ticket [f2ad7de056ab1dc92]. file: [857606ea] check-in: [d5e2c1fc] user: drh branch: create-table-as-type-fix, size: 143049
2015-05-02
11:45
Cleanup of the sqlite3StrAccumInit() function. No functionality changes. file: [61b47073] check-in: [7952c322] user: drh branch: trunk, size: 142136
2015-04-19
22:31
Silently ignore parser stack overflow when parsing a malformed schema in PRAGMA writable_schema mode. file: [e246c2ce] check-in: [2cb37b95] user: drh branch: trunk, size: 142150
21:59
Fix another assert() that is not true if the database schema is corrupt. file: [2e46e275] check-in: [bc97cec6] user: drh branch: trunk, size: 142094
20:39
Fix a faulty assert in the schema parsing logic. file: [bc3a513a] check-in: [b1ed9495] user: drh branch: trunk, size: 142038
2015-04-18
17:43
Fix an incorrect assert() statement in the CREATE INDEX code generator. file: [2d43ee76] check-in: [2eed41fd] user: drh branch: trunk, size: 142024
2015-04-17
18:22
Remove unnecessary parser error count increments. Let the sqlite3ErrorMsg() take care of doing that. file: [8c4cbff2] check-in: [3f3b0f68] user: drh branch: trunk, size: 142077
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: [f82d394b] check-in: [7aeade9a] user: drh branch: trunk, size: 142121
2015-04-15
04:10
An oversize hex literal can cause a parsing error while generating code for constants that are factored out of the main body of the VDBE program. So allow for that case. file: [01b969b2] check-in: [a084690b] user: drh branch: trunk, size: 142066
2015-04-10
08:20
Update this branch with latest trunk changes. file: [fa4795bc] check-in: [60be9c1c] user: dan branch: sorter-opt, size: 142074
2015-04-09
16:30
Remove two pointless assert() statements. This should silence harmless compiler warnings reported at https://bugzilla.mozilla.org/show_bug.cgi?id=1152845 file: [4a6d573c] check-in: [83b342a4] user: drh branch: trunk, size: 142028
2015-04-01
16:18
Reduce the CPU used by CREATE INDEX statements by taking better advantage of the fact that keys are inserted in sorted order. file: [9103f5cd] check-in: [592cdc5d] user: dan branch: sorter-opt, size: 142108
2015-03-30
19:56
Optimize CREATE INDEX, REINDEX and VACUUM statements by taking better advantage of the fact that index keys are being inserted into b-trees in sorted order. file: [a455f638] check-in: [763d2bc7] user: dan branch: mistake, size: 142014
2015-03-21
02:58
If a column is both UNIQUE and a PRIMARY KEY, make sure the PRIMARY KEY designation takes precedence. file: [0419bba5] check-in: [d871a792] user: drh branch: trunk, size: 142062
2015-02-13
16:36
Improvements to SQLITE_ENABLE_API_ARMOR. file: [ba45ebd0] check-in: [823ad40c] user: drh branch: trunk, size: 142041
2015-01-30
20:59
Change SQLITE_TESTCTRL_INITMODE to SQLITE_TESTCTRL_IMPOSTER. Revise the order of parameters. Give it the ability to reset the schema parse table so that imposter tables can be erased. file: [eefaa4f1] check-in: [42d56017] user: drh branch: trunk, size: 142136
2014-12-28
22:10
Fix WITHOUT ROWID tables so that they correctly deal with PRIMARY KEYs that contain redundant columns. file: [f5cfd7b3] check-in: [0dfef675] user: drh branch: trunk, size: 142033
2014-12-12
00:20
Fix a bug in the threadtest4.c program. Remove the keyinfo cache as it provides minimal performance improvements, and then only at SQL preparation time, not at runtime, and it has problems with data races in shared-cache mode. We might later add the keyinfo cache back but only enable it when shared-cache mode is off. file: [162d84e4] check-in: [b7489f94] user: drh branch: threadtest4, size: 141579
2014-10-24
00:35
Add the SQLITE_ENABLE_API_ARMOR compile-time option. This is a work in progress and is not yet completely functional. file: [67bb05b1] check-in: [c297a84b] user: drh branch: api-armor, size: 141949
2014-10-13
13:00
Remove the OPFLAG_CLEARCACHE flag from OP_Column. In its place, change the P3 parameter of OP_SorterData to be the index of the pseudo-table cursor whose record header cache is to be cleared. This gives a small size reduction and performance increase. file: [9dc2bd94] check-in: [20062f49] user: drh branch: trunk, size: 141875
2014-10-04
00:07
Avoid leaking Index.aiRowEst memory if an OOM causes a rollback which deletes the index before the aiRowEst deletion code in sqlite3AnalysisLoad() routine has a chance to run. Since the aiRowEst now might be deleted from freeIndex() which does not always have a db pointer, make sure the aiRowEst memory is not held in lookaside. file: [9e5205db] check-in: [efd87ba1] user: drh branch: stat4-avgeq, size: 141869
2014-09-24
13:20
Do not allow parameters in a DEFAULT clause of a CREATE TABLE statement. Ticket [78c0c8c3c9f7c1]. file: [bde83dd5] check-in: [1ad2bc1e] user: drh branch: trunk, size: 141797
2014-09-18
14:36
Since numeric affinity is the most common case, check it first. Interchange the NONE and TEXT affinity codes for easier checking of no affinity. file: [8dbca259] check-in: [4ef4c9a7] user: drh branch: trunk, size: 141782
2014-09-11
16:36
Suppress the potential schema error that occurs when a non-user-auth SQLite library tries to parse the sqlite_user table definition in a user-auth database. file: [047d7e1d] check-in: [cda33c1e] user: drh branch: user-auth, size: 141780
16:19
Enhance the sqlite3_user_add() interface to initialize the user authentication logic. Add test cases for the extra argument on the end of the authorizer callback. file: [555826ae] check-in: [842c6da8] user: drh branch: user-auth, size: 141753
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: [8b02494e] check-in: [70121e7c] user: drh branch: user-auth, size: 142054
13:44
Add support for the extra parameter on the sqlite3_set_authorizer() callback and support for failing an ATTACH with an authentication-required database using bad credentials. The extension is now feature complete, but much testing and bug-fixing remains. file: [4c7aac1d] check-in: [596e728b] user: drh branch: user-auth, size: 141460
2014-09-10
17:34
Further ideas on user authentication. Not yet working code. file: [3a61555d] check-in: [c8171ecd] user: drh branch: user-auth, size: 141480
2014-09-09
14:47
Non-working preliminary implementation attempts on user authentication. file: [8b4c67c9] check-in: [8440f093] user: drh branch: user-auth, size: 141298
2014-09-06
16:39
Fix typos in comments. No code changes. file: [8cb23771] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 140755
2014-08-25
13:27
Merge the recent performance enhancements implemented on trunk into the threads branch. file: [c26b233d] check-in: [dfdc900f] user: drh branch: threads, size: 140757
2014-08-21
20:26
Simplify the interface to the symbol table, saving 600 bytes of code space. file: [058e3aad] check-in: [14b0f561] user: drh branch: trunk, size: 140765
2014-08-06
02:03
Merge all recent changes from trunk. file: [6aa8134d] check-in: [a353a851] user: drh branch: threads, size: 141123
2014-08-05
11:04
Rename the internal Schema.flags field to Schema.schemaFlags. file: [5abf794f] check-in: [5ae80b3c] user: drh branch: trunk, size: 141131
2014-07-31
22:59
Refactoring: Change "pIndex->onError!=OE_None" to use a macro: "IsUniqueIndex(pIndex)". Easier to understand that way. file: [c67a915c] check-in: [e75b26ee] user: drh branch: trunk, size: 141125
2014-07-30
14:44
Merge recent trunk changes, and especially the fix for the CREATE UNIQUE INDEX problem of ticket [9a6daf340df99ba9]. file: [f6e49e1b] check-in: [5b50a838] user: drh branch: threads, size: 141129
13:56
Ensure that the correct number of columns in a UNIQUE index are checked for uniqueness, regardless of whether or not the original table has a ROWID or if the columns are NOT NULL, etc. Ticket [9a6daf340df99ba93c]. file: [7ba21d8f] check-in: [6b785e92] user: drh branch: trunk, size: 141137
2014-07-24
16:54
Merge all recent trunk changes into the threads branch. file: [af833cdc] check-in: [77068589] user: drh branch: threads, size: 141144
2014-07-21
15:44
Allow the SQLITE_MAX_ATTACHED compile-time option to be larger than 62. The default limit on the number of attached databases remains 10. file: [48f400fa] check-in: [1a817ae2] user: drh branch: trunk, size: 141152
2014-05-29
20:24
Merge changes from the trunk into the threads branch. file: [ac8dc0b8] check-in: [416cb091] user: drh branch: threads, size: 140814
2014-05-27
18:18
Change the name of the Index.autoIndex field to Index.idxType and provide symbolic names for the various values of that field rather than using magic numbers. file: [927e39b6] check-in: [d16e575d] user: drh branch: trunk, size: 140822
2014-05-26
20:15
Merge recent trunk changes into the threads branch. file: [c68e0391] check-in: [82152027] user: drh branch: threads, size: 140623
2014-05-21
08:48
Do not burn memory remembering CHECK constraints in a read-only database. file: [92539f47] check-in: [34ddf02d] user: drh branch: trunk, size: 140631
2014-05-19
15:16
Changes to help ensure that a multiplication does not overflow when computing the number of bytes needed for a memory allocation, and cause a malfunction. No problems existing problems were discovered. However, these changes should help to ensure that no problems arise in the future. file: [30012cb6] check-in: [17349a49] user: drh branch: safer-malloc, size: 140604
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: [be2063ff] check-in: [f1a4bf01] user: drh branch: reduce-schema-size, size: 140598
19:57
Try to reduce the amount of memory used to hold the schema when PRAGMA ignore_check_constraints is active. file: [7fec8e35] check-in: [35a9f3f1] user: drh branch: reduce-schema-size, size: 140600
2014-05-02
18:05
Merge orderby-planning with this branch. file: [9c522b6e] check-in: [d9549de3] user: dan branch: threads, size: 140536
2014-04-29
19:01
Test that the default values used when sqlite_stat1 data is not available are calculated correctly. Fixes for the same. file: [02665ca1] check-in: [e2d42f90] user: dan branch: experimental-costs, size: 140544
2014-04-25
15:01
Store values loaded from the stat1 table as logarithmic values in memory. file: [9f7b2ed2] check-in: [1bd74c49] user: dan branch: experimental-costs, size: 140343
2014-04-18
12:38
Merge recent trunk changes into the threads branch. file: [9ea11e29] check-in: [8729aa3e] user: drh branch: threads, size: 139929
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: [5bfeea8f] check-in: [3122b836] user: drh branch: trunk, size: 139937
2014-04-04
22:44
Fix harmless compiler warnings. file: [e120a369] check-in: [e54dded2] user: drh branch: threads, size: 139921
2014-04-01
18:41
When sorting data for a CREATE INDEX statement in single-threaded mode, assume that keys are delivered to the sorter in primary key order. Also fix various comments that had fallen out of date. file: [b507fb9b] check-in: [821d1ac4] user: dan branch: threads, size: 139943
2014-03-05
19:04
Fix a harmless compiler warning on MSVC. file: [0d50ef95] check-in: [0723effc] user: drh branch: trunk, size: 139929
15:52
Count the number of elements in a SrcList object using an "int" rather than a "u8", to avoid overflows and to work around an issue in the C compiler on AIX. file: [04acd702] check-in: [eee2a13f] user: drh branch: trunk, size: 139924
2014-02-17
22:40
Add logic to do test coverage measurements on the VDBE code. file: [00ce613b] check-in: [ce184c7b] user: drh branch: insert-optimization, size: 139932
2014-02-08
04:24
Enable constant expression factoring even if no tables are read and no transaction is started. file: [13b9d821] check-in: [a45b8771] user: drh branch: trunk, size: 139830
01:40
Change the OP_Trace opcode to OP_Init and give it the ability to jump to the initialization code at the bottom of the program, thus avoiding the need for an extra OP_Goto. file: [1bc25847] check-in: [192dea97] user: drh branch: trunk, size: 139923
2014-02-06
23:56
Delete the OP_VerifySchema opcode. Enhance OP_Transaction to do the schema version checks that OP_VerifySchema used to do. file: [40c38ec8] check-in: [2f3376eb] user: drh branch: trunk, size: 141295
2014-01-16
21:59
Tweaks to error message text. file: [7e6c275a] check-in: [090a77d9] user: drh branch: common-table-expr, size: 141270
21:02
Improve the error messages used to report illegal recursive cte references. file: [a6b9ba91] check-in: [54eee9fe] user: dan branch: common-table-expr, size: 141263
2014-01-13
16:36
Fix some memory leaks and crashes that could follow an OOM condition during WITH clause parsing. file: [5a2daa66] check-in: [8839850c] user: dan branch: common-table-expr, size: 141229
15:12
Add code to handle non-recursive CTEs in the same way as SQL views. file: [1efdc650] check-in: [a26f399b] user: dan branch: common-table-expr, size: 141201
2014-01-11
19:19
Update the parser so that sub-queries and CTEs may have WITH clauses. file: [1da29e4e] check-in: [704d3931] user: dan branch: common-table-expr, size: 140045
13:22
Parse common table expressions. But do not do anything with them (yet). file: [198670a7] check-in: [da98b720] user: drh branch: common-table-expr, size: 139995
2014-01-10
20:38
Fix CREATE TABLE ... AS so that it works with column names that are empty strings. file: [8c56d914] check-in: [632045f2] user: drh branch: trunk, size: 139311
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: [3609c8aa] check-in: [8f6e6149] user: drh branch: trunk, size: 139302
16:49
Omit OP_Close operations that occur immediately prior to OP_Halt and which cannot be jumped over. file: [5597ffa6] check-in: [874b7e99] user: drh branch: trunk, size: 139303
2013-12-09
19:03
Performance optimizations for sqlite3VXPrintf(). file: [47ef8209] check-in: [9227ad48] user: drh branch: trunk, size: 139246
2013-12-06
22:45
Use memcmp() instead of the BINARY collating function where possible, for a performance boost. file: [9b40580b] check-in: [c5a3a1af] user: drh branch: trunk, size: 139248
2013-12-03
00:11
Fix a harmless compiler warning on MacOS. file: [1965c7b5] check-in: [74328de1] user: drh branch: trunk, size: 139210
2013-11-15
18:15
Changes to make the new constant expression factoring logic more general and more testable. file: [07054d45] check-in: [d10fb49a] user: drh branch: expr-codegen-enhancement, size: 139210
01:10
Rework the logic that factors constant expressions out of inner loops, making it both simpler and faster. file: [5b744617] check-in: [8dc5c76c] user: drh branch: expr-codegen-enhancement, size: 139201
2013-11-13
17:58
Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. file: [2baeed38] check-in: [8ce33f4c] user: drh branch: trunk, size: 138903
2013-11-11
16:55
Remove unreachable code, replacing it in most cases with assert() or NEVER() macros. file: [4d740243] check-in: [924d63b2] user: drh branch: trunk, size: 139028
2013-11-09
18:15
Throw an error if AUTOINCREMENT appears in a WITHOUT ROWID table. Updates to API documentation to discuss WITHOUT ROWID. file: [837587db] check-in: [b1abb2b0] user: drh branch: trunk, size: 139021
2013-11-07
14:09
Make sure cached KeyInfo objects are only valid for a single database connection. Clear all cached KeyInfo objects on any collating sequence change. file: [d4d5ceed] check-in: [55eea178] user: drh branch: omit-rowid, size: 138859
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: [a7488923] check-in: [defd5205] user: drh branch: omit-rowid, size: 138685
16:28
Have the OP_NoConflict opcode set the VdbeCursor.seekResult variable. This speeds up subsequent OP_Insert and OP_IdxInsert opcodes. file: [5e4d105d] check-in: [47455500] user: dan branch: omit-rowid, size: 138444
2013-11-05
22:39
Make sure the query planner knows that the PRIMARY KEY index of a WITHOUT ROWID table is always a covering index. file: [3182fb17] check-in: [03e7019e] user: drh branch: omit-rowid, size: 138469
17:30
Fix a bug in secondary index initialization when the secondary index is a superset of the PRIMARY KEY for a WITHOUT ROWID table. file: [507bacb8] check-in: [52a3d885] user: drh branch: omit-rowid, size: 138446
13:33
Standardize the error messages generated by constraint failures to a format of "$TYPE constraint failed: $DETAIL". This involves many changes to the expected output of test cases. file: [6790e7b7] check-in: [54b22192] user: drh branch: omit-rowid, size: 138408
01:59
Add the conflict2.test script. Fix issues discovered by this script. file: [309f387d] check-in: [294ed337] user: drh branch: omit-rowid, size: 136795
2013-11-04
18:34
Add another test case file for WITHOUT ROWID and fix the bugs that the new test file uncovered. file: [10b7e687] check-in: [bc2a06eb] user: drh branch: omit-rowid, size: 136783
17:00
Fix a problem with processing INTEGER PRIMARY KEY on a WITHOUT ROWID table. file: [0610712b] check-in: [89098e6d] user: drh branch: omit-rowid, size: 136743
2013-11-03
02:27
Improved comments on foreign key logic. file: [21727e78] check-in: [1315d910] user: drh branch: omit-rowid, size: 136720
2013-11-02
22:09
Many new test cases added, that mostly work. Currently 18 errors in without_rowid3.test. Also there is a hack marked by a /*FIXME*/ comment on at fkey.c:547 that needs fixing. file: [113a23bc] check-in: [39e32187] user: drh branch: omit-rowid, size: 136723
14:37
Store the root page of the PRIMARY KEY index for a WITHOUT ROWID table in the sqlite_master entry for the main table and omit the sqlite_master entry for the PRIMARY KEY. file: [38d6d739] check-in: [b7544bb2] user: drh branch: omit-rowid, size: 136699
2013-11-01
22:02
Size KeyInfo objects so that IdxInserts always compare the correct number of fields. file: [bc63356a] check-in: [302a8139] user: drh branch: omit-rowid, size: 135370
20:30
Fix sqlite3_analyzer so that it works with WITHOUT ROWID tables. Fix index generation for secondary indices that include fields from the PRIMARY KEY. file: [7a940e5e] check-in: [f9769d70] user: drh branch: omit-rowid, size: 135147
17:59
Fix an invalid cast operation in the WITHOUT ROWID parsing logic. file: [7c3d6578] check-in: [845153be] user: drh branch: omit-rowid, size: 134994
01:45
A couple of bug fixes. file: [4f3f549d] check-in: [cdf00248] user: drh branch: omit-rowid, size: 134999
2013-10-30
15:52
Make sure KeyInfo objects on multi-column indices of WITHOUT ROWID tables have the correct nField and nXField values. Also, add the SQLITE_ENABLE_MODULE_COMMENT compile-time option and the VdbeModuleComment() macro and use it to label entry and exit points of some key routines. file: [9d33b869] check-in: [6d9af606] user: drh branch: omit-rowid, size: 135048
2013-10-25
14:46
Basic DELETE operations now working on WITHOUT ROWID tables. file: [4d62e99f] check-in: [9eafafa3] user: drh branch: omit-rowid, size: 135014
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: [f99c6980] check-in: [0e56ba69] user: drh branch: omit-rowid, size: 135081
2013-10-23
23:37
Change the sqlite3OpenTable() utility to open the PRIMARY KEY index when reading a WITHOUT ROWID table. file: [2dccf54c] check-in: [247f3899] user: drh branch: omit-rowid, size: 135058
22:23
Construct secondary indices on WITHOUT ROWID tables. file: [6970691b] check-in: [2c028ddc] user: drh branch: omit-rowid, size: 135366
13:30
Some inserts and queries working for multi-column primary keys and WITHOUT ROWID. file: [029e1709] check-in: [b21d831b] user: drh branch: omit-rowid, size: 134149
01:57
Some simple inserts and queries working on WITHOUT ROWID tables. file: [2b8af105] check-in: [3f8016de] user: drh branch: omit-rowid, size: 134094
00:32
Build internal data structures appropriately for WITHOUT ROWID tables. file: [fbc70ed4] check-in: [35a36060] user: drh branch: omit-rowid, size: 133957
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: [c29b38fb] check-in: [a106ce86] user: drh branch: omit-rowid, size: 129827
14:28
Add a procedure to handle the messy details of allocating an Index object from the heap. file: [1c522019] check-in: [45efc94f] user: drh branch: omit-rowid, size: 129660
01:18
Previous refactor is not going to be helpful because implied indices must be created in the same order that they appear in the CREATE TABLE statement for backwards compatibility. This is a much smaller change to clean up a few loose ends. file: [06b5fbc1] check-in: [824b549f] user: drh branch: omit-rowid, size: 129044
2013-10-21
23:55
Minor refactoring of the PRIMARY KEY parsing logic to facilitate enhancements. file: [f95446a9] check-in: [4e69dd5f] user: drh branch: omit-rowid, size: 128388
02:14
Simplification of the syntax: Merely append "WITHOUT rowid" to the end of the table definition. file: [34096ede] check-in: [131cc6e1] user: drh branch: omit-rowid, size: 129031
2013-10-19
23:31
Experimental changes toward "index only" tables. Add the ability to specify options on CREATE TABLE statements using the WITH clause modeled after PostgreSQL and SQL Server. Only the "omit_rowid" option is currently recognized and that option is currently a no-op. file: [2adfe99b] check-in: [0248ec5e] user: drh branch: omit-rowid, size: 129412
15:07
Fix a bug causing an "malformed database schema error" error if a temp table with the same name as an existing table that has at least one temp trigger attached to it is created. file: [6d9a545d] check-in: [56dca4a6] user: dan branch: trunk, size: 128683
2013-10-11
15:05
Fix various harmless compiler warnings. Change the "warnings.sh" script to work with STAT4 instead of STAT3. file: [8ae900bf] check-in: [7df06684] user: drh branch: trunk, size: 128667
2013-10-08
18:40
Further refinement of the idea of multiplying run-time cost estimates by the estimated row size. file: [3da02c07] check-in: [18bd6ba9] user: drh branch: row-size-est, size: 128663
2013-10-07
16:53
Try to remember statistics from ANALYZE using LogEst instead of u64. file: [46bb89df] check-in: [8e78557a] user: drh branch: log-stats, size: 128697
2013-10-05
20:18
Fix an issue in the test8.c test module that arises because of the change to PRAGMA index_list(). Remove an unused local variable. file: [ea07ec35] check-in: [029430c5] user: drh branch: row-size-est, size: 128663
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: [32783455] check-in: [8b4aa0c7] user: drh branch: row-size-est, size: 128743
2013-10-04
18:29
Further refinements of the index scanning speed logic. file: [f92f1cd2] check-in: [e5d9371d] user: drh branch: index-scan-rate, size: 129064
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: [7a91b0db] check-in: [07462bb6] user: drh branch: index-scan-rate, size: 128734
2013-10-03
19:21
Experimental branch allowing different postulated scan rates for each index. file: [7926e17a] check-in: [d59d97b0] user: drh branch: index-scan-rate, size: 127336
15:39
The sqlite3FixInit() routine cannot fail. So change the return type from "int" to "void". file: [834fa4bb] check-in: [500c5932] user: drh branch: trunk, size: 126495
2013-09-02
23:40
Add the experimental SQLITE_DEFAULT_INDEX_SHAPE=1 compile-time option that makes a much more pessimistic guess at the effectiveness of unanalyzed indices. file: [ec867822] check-in: [d8daaba7] user: drh branch: index-shape-1, size: 126975
2013-08-26
23:18
Merge the STAT4 capability into trunk. file: [f63e8929] check-in: [a32af0ab] user: drh branch: trunk, size: 126511
2013-08-19
11:15
Fixes for harmless compiler warnings. file: [f99a715f] check-in: [a0d9ca4f] user: drh branch: trunk, size: 126511
2013-08-07
18:42
Merge latest trunk changes with this branch. file: [c2e4d057] check-in: [08f74c45] user: dan branch: sqlite_stat4, size: 126506
2013-08-05
19:11
Factor all KeyInfo object allocations into a single function: sqlite3KeyInfoAlloc(). Always allocate enough space so that sqlite3VdbeRecordCompare() can avoid checking boundaries and hence run faster. file: [cee47246] check-in: [7301bedd] user: drh branch: trunk, size: 126506
2013-08-03
20:24
Begin adding experimental sqlite_stat4 table. This commit is buggy. file: [b2771cc5] check-in: [2beea303] user: dan branch: sqlite_stat4, size: 126762
2013-08-02
16:41
Add support for partial indices. file: [fc76e1cd] check-in: [478113f1] user: drh branch: trunk, size: 126762
2013-08-01
22:27
Fix the CREATE INDEX statement so that trying to create a TEMP index on a non-TEMP table throws an error rather than segfaulting. file: [1a6db7f4] check-in: [e3c8935f] user: drh branch: trunk, size: 127100
16:02
Fix bug in the logic that determines the end of a CREATE INDEX statement. Added a VACUUM test case that exposed the bug. file: [7fe3c81e] check-in: [2e3df0bc] user: drh branch: partial-indices, size: 126598
03:36
Test cases and bug fixes for the partial index logic. file: [4be89759] check-in: [6b73ae7c] user: drh branch: partial-indices, size: 126579
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: [9422ab5f] check-in: [fb9044d1] user: drh branch: partial-indices, size: 126711
2013-07-31
19:05
Resolve names in CREATE INDEX WHERE clauses and detect errors. Disallow expressions that contain variables, subqueries, or functions. The expression is still not used for anything, however. still unused. file: [f1ef982f] check-in: [f2aa7842] user: drh branch: partial-indices, size: 126585
18:12
Here begins an experimental branch for exploring the idea of a partial index. This check-in is able to parse a WHERE clause on a CREATE INDEX statement, but does not actually do anythingn with that WHERE clause yet. file: [c2903be4] check-in: [6794b2dc] user: drh branch: partial-indices, size: 127103
2013-06-19
13:59
Additional compiler warning fixes. file: [42239cfd] check-in: [8d2ae8e2] user: drh branch: nextgen-query-plan-exp, size: 126936
2013-06-12
17:17
Merge all changes from trunk. file: [eadda12e] check-in: [f2e15b19] user: drh branch: nextgen-query-plan-exp, size: 126938
2013-06-08
19:58
Candidate fix for a memory leak that occurs if a CREATE TABLE statement contains two or more COLLATE clauses on the same column definition. file: [1ecf6852] check-in: [60fc77bc] user: drh branch: memleak, size: 126835
2013-06-04
12:42
Refactor the ORDER BY optimizer in the NGQP so that it is easier to maintain and so that it can support optimizing out GROUP BY and DISTINCT clauses. file: [838cbdcb] check-in: [e605c468] user: drh branch: nextgen-query-plan-exp, size: 126897
2013-05-15
15:16
When loading a database schema that contains an index definition that includes a COLLATE clause for which the collation sequence is unavailable, do not assume that that index uses BINARY instead. Fix for [0fc59f908b]. file: [92ef9483] check-in: [6dae62c4] user: dan branch: trunk, size: 126794
2013-03-24
22:56
Remove the SQLITE_OMIT_MERGE_SORT compile-time option and its related code. The merge sorter is now a required component. file: [083da846] check-in: [8b44d6fb] user: drh branch: trunk, size: 126922
2013-03-21
21:20
Many spelling fixes in comments. No changes to code. file: [b85db6cb] check-in: [6f6e2d50] user: mistachkin branch: trunk, size: 128308
2013-03-01
01:07
Always use strncmp() rather than memcmp() when comparing strings where one or other string might be less than the length parameter, since optimized versions of memcmp() might read past the first difference and in so doing generate an access violation. file: [375e5df7] check-in: [d7343558] user: drh branch: trunk, size: 128309
2013-02-09
13:58
Add extended error codes for constraint errors. file: [73ca65f3] check-in: [54611046] user: drh branch: constraint-error-codes, size: 128300
2012-12-08
21:51
Refactor collating-sequence handling as a fix for ticket [71e333e7d2e642]. The Expr.pColl field is removed from the Expr object. The COLLATE operator now becomes a separate instance of Expr in the expression tree. The code generator looks up the correct collating function as needed, rather than referring to Expr.pColl. file: [f4f86c07] check-in: [8542e618] user: drh branch: trunk, size: 128048
2012-12-06
21:16
Remove the Expr.pColl field and compute the collating sequence as it is needed. This fixes the test script "shared9.test", though there is still a memory leak. And there are other problems. Consider this a work-in-progress. file: [9721f654] check-in: [fd011cb2] user: drh branch: ticket-71e333e7, size: 127678
20:27
Cherrypick [79ef8e3c77] (Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements). file: [f3545121] check-in: [34aafb74] user: dan branch: branch-3.7.9, size: 127511
19:37
Apply the same restrictions on constant refactoring to statements within a trigger program as top-level statements. Candidate fix for [ae3c5670b6]. file: [fd68fb1b] check-in: [0c31a468] user: dan branch: constant-refactoring-in-triggers, size: 128444
2012-10-26
13:34
Backport the shared-cache-fix branch. file: [0aef4fa8] check-in: [325364a9] user: drh branch: branch-3.7.14, size: 128063
2012-10-25
17:21
Use a constant string "BINARY" for the unspecified collating sequence. This is part of check-in [635e3a762dd] that is being back-ported. file: [1c01c649] check-in: [9078ea75] user: drh branch: branch-3.7.9, size: 127141
2012-10-09
18:51
Attempt to suppress warnings generated by Coverity. file: [f35dac52] check-in: [7b1a6e6c] user: drh branch: trunk, size: 128074
2012-10-08
23:25
Changes to facilitate full test coverage. file: [b21c1300] check-in: [28d1eb40] user: drh branch: trunk, size: 128027
2012-10-05
18:38
Fix an accidental fork on branch-3.7.9. file: [d1acf9b8] check-in: [cd9efeb3] user: drh branch: branch-3.7.9, size: 127153
18:35
Backport fixes to shared-cache mode, from the shared-cache-fix branch, to version 3.7.9 file: [55c4e4a1] check-in: [ac81ae49] user: drh branch: branch-3.7.9, size: 126958
17:44
Merge the shared-cache related fixes from the shared-cache-fix branch to the trunk. file: [aaff8dbe] check-in: [698ec776] user: dan branch: trunk, size: 127999
14:43
Consolidate all occurrences of the "no such collation sequence" error message into a single spot. file: [b87aff4a] check-in: [8ea67522] user: drh branch: trunk, size: 127338
2012-10-04
19:33
Shared-cache mode fixes for views and virtual tables. file: [74baa2d6] check-in: [2b370dea] user: dan branch: shared-cache-fix, size: 128091
2012-09-13
14:22
Change boolean fields in the Column object from unsigned characters into bits in a single bit mask variable. file: [c4555e16] check-in: [4163f5f1] user: drh branch: trunk, size: 127430
2012-08-25
10:01
Fix all known instances of 'repeated the' style typos in comments. No changes to code. file: [a3b700af] check-in: [9b19b847] user: mistachkin branch: trunk, size: 127402
2012-08-20
15:53
Remove tab characters from source code files. Replace them with spaces. file: [19673437] check-in: [7edd10a9] user: drh branch: trunk, size: 127406
2012-08-06
18:50
When reusing pages as part of creating a new index, allocate the leaves from each free-list trunk page in ascending order, instead of trying to maximize localization for each individual allocation. This increases the chance that pages will be written to disk in ascending order by a large CREATE INDEX statement, improving overall performance. file: [0f6b40ad] check-in: [d045f8b2] user: dan branch: sorter-coalesce-writes, size: 127400
2012-07-18
16:07
Remove another branch from the DbMalloc() paths. file: [4357149e] check-in: [defd828e] user: dan branch: calloc, size: 127343
2012-06-06
10:56
Make sure the Index.azColl pointers do not point to connection-specific memory. Also, remove an unnecessary reinitialization to sqlite3.pDfltColl. file: [47c4506a] check-in: [c469850b] user: drh branch: shared-schema, size: 127368
2012-06-05
19:20
Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism in that branch. file: [178b24b3] check-in: [42338e9e] user: drh branch: shared-schema, size: 127380
2012-05-21
19:11
Convert the NameContext object from using u8 booleans to using individual bits in a single u8 as its booleans. This change might become a basis for a fix for [c2ad16f997ee9c]. file: [2bb2163b] check-in: [72226096] user: drh branch: nested-agg, size: 127626
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: [6da3a261] check-in: [aa0c3493] user: drh branch: shared-schema, size: 127364
12:49
Add assert()s to verify that Table objects in the schema never use lookaside memory. file: [95fd8aa1] check-in: [736d6ea6] user: drh branch: trunk, size: 127617
2012-03-30
15:48
When a named CHECK constraint fails, include the name of the constraint in the error message. file: [987c6933] check-in: [1b75f301] user: drh branch: trunk, size: 126772
2012-03-29
07:51
Fix an out of date comment on sqlite3ArrayAllocate(). file: [139dc386] check-in: [4afdd5ae] user: dan branch: trunk, size: 126450
2012-03-07
19:13
If a CHECK constraint is named, report that name on the error message when the constraint fails. file: [d58d314c] check-in: [9a0f90d9] user: drh branch: named-check-constraints, size: 126554
2012-02-02
15:50
Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. file: [c4d36e52] check-in: [0bc594e8] user: drh branch: trunk, size: 126232
03:38
Simplified array allocation in the IdList and AggInfo objects. file: [7a03d177] check-in: [25df2a74] user: drh branch: trunk, size: 126250
2012-01-05
12:38
Ensure 8-byte alignment of Index.aiRowEst elements even if the size of an Index object is not a multiple of 8 bytes. file: [8e2a4ded] check-in: [1378f905] user: drh branch: trunk, size: 126536
2011-11-14
02:53
Fix a 8-byte alignment problem that causes a SIGBUS on Sparc. file: [8915bb6d] check-in: [54cc1198] user: drh branch: branch-3.7.9, size: 126492
2011-10-21
19:06
Purge lingering references to SQLITE_STAT2 from the code and test scripts. file: [8af67a08] check-in: [aed2bf7a] user: drh branch: trunk, size: 126297
2011-10-14
21:49
Add assert() statements and eliminate needless variable assignments in order to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. file: [ae152efb] check-in: [60fee957] user: drh branch: trunk, size: 126354
2011-10-07
23:52
Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. file: [119937b0] check-in: [589f3f56] user: drh branch: trunk, size: 126275
2011-09-23
13:59
Testability enhancements. file: [2dc09385] check-in: [be44928c] user: drh branch: stat3-trunk, size: 126216
2011-09-13
19:09
Merge the latest trunk changes into the stat3-trunk branch. file: [57e3b27c] check-in: [11ca4ed8] user: drh branch: stat3-trunk, size: 126235
2011-09-03
00:17
The build works again with -DSQLITE_OMIT_MERGE_SORT. The merge-sorter now avoids spilling to disk (letting the in-memory linked list grow without bound) if PRAGMA temp_store=3. file: [851e81f2] check-in: [68e26c44] user: drh branch: merge-sort, size: 125978
2011-09-02
10:31
Instead of a temporary b-tree, use a linked-list and merge-sort to sort records in main memory in vdbesort.c. file: [dc367138] check-in: [7769fb98] user: dan branch: merge-sort, size: 126268
2011-08-26
18:28
Veryquick and min.rc tests now passing. file: [90685b71] check-in: [a7e18468] user: drh branch: stat3-3.7.2, size: 122405
13:52
Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. file: [556c5918] check-in: [0df04f92] user: drh branch: stat3-3.7.2, size: 122552
13:16
Merge the stat3-enhancement branch with trunk, but keep the resulting merge in a separate branch for now. file: [ea854c9d] check-in: [63f2c785] user: drh branch: stat3-trunk, size: 126023
00:34
Create a new pager type, PAGER_SORTER, for use in the external merge sort. Such pagers are always held in memory but do report when they are under memory pressure by calling pagerStress. file: [2d5de52d] check-in: [c71d7320] user: drh branch: trunk, size: 125766
2011-08-24
15:12
Fix some harmless compiler warnings. file: [20784c6b] check-in: [46f5a68b] user: drh branch: trunk, size: 125724
2011-08-23
00:01
Remove a branch that is always true. file: [6c60478a] check-in: [a6568192] user: drh branch: trunk, size: 125720
2011-08-18
02:51
Fix a bug in the cleanup of stat tables on a DROP TABLE in autovacuum mode. file: [4534f8c4] check-in: [3fe5d54f] user: drh branch: stat3-enhancement, size: 124874
2011-08-17
00:40
Use OP_Sort rather than OP_Rewind in order to sort the content of a new index on the CREATE INDEX statement. Add an ALWAYS() to the merge sort logic to document an unreachable branch. file: [77be7c21] check-in: [f01766f4] user: drh branch: trunk, size: 125694
2011-08-13
19:35
Further testing and bug fixing for sqlite_stat3. Added the Index.avgEq field to index statistics. Fixed several problems in the query planner associated with stat3. file: [cd77ae97] check-in: [89b2f708] user: drh branch: stat3-enhancement, size: 124875
2011-08-12
16:30
Merge latest trunk changes into experimental branch. file: [77b40abf] check-in: [7e515055] user: dan branch: experimental, size: 125696
15:02
Add the SQLITE_OMIT_MERGE_SORT pre-processor directive. To omit the code in vdbesort.c. file: [ac39a62c] check-in: [4ced2394] user: dan branch: experimental, size: 125323
01:51
Begin a branch that experimentally replaces sqlite_stat2 with a new table called sqlite_stat3 that will hopefully facilitate better query planning decisions. file: [4165efa3] check-in: [52e1d7e8] user: drh branch: stat3-enhancement, size: 124873
2011-08-07
01:31
Remove relevant elements from the sqlite_stat2 table when doing a DROP INDEX or DROP TABLE. file: [19a8957a] check-in: [3c8f97ae] user: drh branch: trunk, size: 124617
2011-07-12
14:28
Experimental support for speeding up CREATE INDEX commands using an offline merge sort. file: [8aca0539] check-in: [30dbf0fe] user: dan branch: experimental, size: 124904
2011-06-24
18:43
Explicitly cast an argument to printf() to (int), in case the result of the pointer arithmetic expression is a 64-bit integer on some platforms. file: [5e614e58] check-in: [90cfeaf7] user: dan branch: trunk, size: 124244
2011-06-03
20:11
Create and use a function especially for adding the ParseSchema opcode. This gives a small reduction in code and a small performance increase. file: [5a428625] check-in: [957b2ab6] user: drh branch: trunk, size: 124237
2011-06-01
18:15
Refactor the SQL parameter processing so that parameter names for values that are optimized out of the prepare statement are not forgotten. file: [c10ab9e2] check-in: [b3aaf715] user: drh branch: trunk, size: 124287
2011-05-01
22:57
Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. file: [a8aca43d] check-in: [7155e6f3] user: drh branch: branch-3.7.2, size: 121768
2011-04-23
15:54
Have the ATTACH command do URI interpretation in the same way as sqlite3_open() and sqlite3_open_v2() do. file: [0132bc66] check-in: [68240e75] user: dan branch: uri, size: 124447
2011-04-09
17:32
Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared. file: [f09c46c6] check-in: [a46f3290] user: dan branch: trunk, size: 124437
15:39
Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object). file: [84d4a803] check-in: [b9dbd993] user: dan branch: trunk, size: 123844
2011-04-05
22:08
Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. file: [b7c99327] check-in: [3eeb0ff7] user: drh branch: trunk, size: 123658
19:26
Simplifications to the sqlite3ResetInternalSchema() logic to eliminate unreachable branches. file: [8fc7133b] check-in: [a4c3ac98] user: drh branch: trunk, size: 123673
2011-04-04
21:25
Additional schema mutex checks for sqlite3RootPageMoved(). Reduce the scope of sqlite3ResetInternalSchema() in a few places. file: [d809f572] check-in: [39c00907] user: drh branch: schema-parse-refactor, size: 123673
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: [63465c86] check-in: [ae8374af] user: drh branch: schema-parse-refactor, size: 123578
13:40
Rename sqlite3SchemaFree() to sqlite3SchemaClear() to more accurately reflect its function. file: [3377719d] check-in: [71d74400] user: drh branch: schema-parse-refactor, size: 122450
2011-04-02
20:08
Merge in the latest changes from trunk. file: [0dd1fd5a] check-in: [0d99229a] user: drh branch: schema-parse-refactor, size: 122447
20:01
Change the name of the "tAttachMask" datatype to "yDbMask". file: [3a8c6c4b] check-in: [3d6f2e82] user: drh branch: trunk, size: 121876
16:50
When resetting any non-TEMP schema, also reset the TEMP schema since it might be holding references to the non-TEMP schema that just got reset. file: [fcdd8f47] check-in: [211d5dde] user: drh branch: schema-parse-refactor, size: 122463
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: [9dca3dc0] check-in: [6a8ad6e3] user: drh branch: schema-parse-refactor, size: 122185
2011-03-24
01:34
The changes to fix [f7b4edece25c9948] mean that the schema is always loaded whenever a prepared statement is running. This means that a couple of branches can be eliminated and one operand of OP_ParseSchema can be removed. file: [6c490fe1] check-in: [b6e268fc] user: drh branch: trunk, size: 121892
2011-03-23
18:22
Increase the upper bound on SQLITE_MAX_ATTACHED from 30 to 62. file: [821d4b3c] check-in: [7aaf8772] user: drh branch: trunk, size: 121884
2011-03-18
21:55
Add a generation counter to the Schema object and enhance OP_VerifySchema to also check the Schema generation. Fix for ticket [f7b4edece25c99]. file: [3b86c8ef] check-in: [36c04dd1] user: drh branch: trunk, size: 121838
2011-02-12
05:34
Fix problems in the backport, reducing the number of errors in the TCL tests to just a few dozen. Most of the remaining errors seem to be real and desirable changes of behavior. file: [a3c83d34] check-in: [9d2b0af2] user: drh branch: branch-3.7.2, size: 121798
2010-09-28
20:26
Simplify the test that determines if the name of a new table collides with a prior index name. file: [00a32712] check-in: [3f30f00a] user: drh branch: trunk, size: 121746
19:16
Fix some problems that can occur if a trigger has the same name as another database object. file: [e70451e1] check-in: [655991ec] user: dan branch: trunk, size: 121776
17:34
Add tests to e_createtable.test. Allow a table to be created if there is an index of the same name in a different attached database. file: [0451673a] check-in: [6251e587] user: dan branch: trunk, size: 121732
15:55
Disallow statements of the form "CREATE TEMP TABLE main.t1 ...". file: [90738563] check-in: [dd1b34ba] user: dan branch: trunk, size: 121709
2010-09-25
22:32
Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. file: [99894b89] check-in: [a7645d29] user: drh branch: trunk, size: 121640
2010-08-30
15:02
Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. file: [5acc8a7d] check-in: [0900e353] user: drh branch: trunk, size: 121576
2010-08-27
12:21
Remove unnecessary code from malloc.c. Enhance pcache1.c so that is tries to reuse existing pages, rather than create new pages, when SQLite is under memory pressure. "Memory pressure" means that SQLITE_CONFIG_PAGECACHE memory is nearly exhausted or sqlite3_soft_heap_limit() has been reached. file: [aa5ebbf9] check-in: [51049479] user: drh branch: trunk, size: 121606
2010-07-28
19:17
Get SQLITE_OMIT_VIRTUALTABLE working again after being broken by recent changes. file: [0018d496] check-in: [33b1e862] user: drh branch: trunk, size: 121734
2010-07-26
11:07
Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). file: [d4593392] check-in: [629e38a8] user: drh branch: experimental, size: 121694
2010-07-25
02:12
Further examples of using automatic deallocation to replace "delete" methods. file: [b4f3c9ba] check-in: [da2f62c5] user: drh branch: malloc-enhancement, size: 121692
2010-07-24
19:08
Additional malloc sanity changes. Use sqlite3MemLink() on Index.zColAff and Table.zColAff as a proof of concept. file: [216e3635] check-in: [e5ecb159] user: drh branch: malloc-enhancement, size: 121792
16:34
Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). file: [6d3bd012] check-in: [ac1f37a6] user: drh branch: malloc-enhancement, size: 121925
11:28
Experimental code to measure memory consumed by database schemas and prepared statements. file: [fdf428a3] check-in: [9aa30342] user: dan branch: experimental, size: 121683
2010-07-23
15:41
Remove the Table.dbMem variable, as it is no longer being used for its original purpose. file: [8ccdb8ff] check-in: [6eddc6e6] user: dan branch: trunk, size: 121914
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: [559d38b4] check-in: [e396184c] user: drh branch: trunk, size: 121983
2010-06-28
10:15
Currently, if SQLite cannot find a table or index referred to by a query, it reloads the database schema from disk to see if the table or index has been added since the schema was cached in memory. Extend this behaviour to columns (which may have been added using ALTER TABLE) and fix some obscure cases related to tables and indexes (INDEXED BY, DROP TABLE etc.). file: [31830208] check-in: [4932f228] user: dan branch: trunk, size: 122060
2010-06-11
17:01
Refactor and simplify the logic used to change journalmode. file: [9d48f402] check-in: [95cc3f6f] user: drh branch: trunk, size: 122029
2010-06-02
05:53
Add some 'const' markers to static data that is really constant. file: [fa9bf633] check-in: [e7073e23] user: dan branch: trunk, size: 122026
2010-02-25
23:44
Fix to the database connection validity checker. Other test coverage enhancements. file: [11100b66] check-in: [0f6291bb] user: drh branch: trunk, size: 122019
02:32
Merge in all of the logging enhancements. This is a cherrypick merge of the following check-ins: [103321e37a], [a8076aede3], [6d910245ad], [7c4cca6d1a], [edea3bb740], [1a6d4bb130], [a8c984c1d6], [69a493182f], and [1168763d2c]. file: [ffad5283] check-in: [46f406b2] user: drh branch: branch-3.6.22, size: 121959
2010-02-22
19:32
Log all error messages if logging is enabled. file: [254a273a] check-in: [a8076aed] user: drh branch: trunk, size: 122047
2010-01-31
14:18
If an OOM occurs while setting the page size for the TEMP database, be sure that error gets reported back out to the interface layer. file: [81412e0f] check-in: [6487e70a] user: drh branch: trunk, size: 122037
2010-01-26
01:25
Make the TEMP file tables use the page size set for the main database. Ticket [b80eeab588c4]. Also copy over the changes from apple-osx check-in [7c3bede3f2]. file: [f9002fe1] check-in: [5dcfb0c9] user: drh branch: trunk, size: 122021
2010-01-05
18:06
Apply fix [097737e368] to the 3.6.1 branch. file: [d8fe03f7] check-in: [9f819ea6] user: dan branch: branch-3.6.1, size: 113587
2009-12-22
23:52
Move the query flattener turn-off from a pragma to an sqlite3_test_control() call. Make provisions (not yet implemented) to turn off other optimizers using the same call. file: [6ab7f8d8] check-in: [4a97c623] user: drh branch: trunk, size: 121949
2009-12-08
14:34
Allow zero-length names for tables, columns, and indices. Fix for ticket [78e04e52eaf]. file: [5a18b684] check-in: [7b1cfd65] user: drh branch: trunk, size: 122014
2009-11-10
01:30
Remove the obsolete "$Id:$" RCS identifier strings from the source code. file: [a48e74d2] check-in: [f6c045f6] user: drh branch: trunk, size: 121956
2009-10-12
22:30
Add asserts as evidence that all FK constraints are either immediate or deferred. file: [3c576268] check-in: [634ef4fc] user: drh branch: trunk, size: 122021
2009-09-28
14:49
Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). file: [1988dad2] check-in: [8353808c] user: dan branch: trunk, size: 121997
2009-09-24
00:09
Make sure a transaction is available for rollback whenever a REDUCE conflict resolution occurs and there is the possibility to ABORT. Ticket [4a03edc4c8c] file: [c6c8d4ce] check-in: [f0c56fa9] user: drh branch: trunk, size: 121952
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: [a6bd2dd7] check-in: [540c2d18] user: dan branch: trunk, size: 120704
2009-09-22
16:55
Fix another OOM related problem in fkey.c. file: [b0aee84f] check-in: [e2bc51bc] user: dan branch: trunk, size: 120695
2009-09-19
17:00
Check in implementation of foreign key constraints. file: [6520093d] check-in: [d5d39981] user: dan branch: trunk, size: 120660
2009-09-14
23:47
Make sure sufficient space is allocated for at least one VDBE cursor when autoincrement is used. Ticket [a696379c1f088]. file: [713f2780] check-in: [2b2a1ef7] user: drh branch: trunk, size: 120191
2009-09-11
14:05
Version 3.6.18 file: [f7da9f9a] check-in: [b084828a] user: drh branch: trunk, size: 120020
2009-09-10
16:14
Fix a problem with the sqlite3VdbeMayAbort() assert failing following an OOM. file: [7569d7e2] check-in: [b3027863] user: dan branch: trunk, size: 120012
2009-09-09
11:37
Add a complicated assert() to check that statement transactions are opened when required. file: [52697332] check-in: [28aa1f4e] user: dan branch: trunk, size: 120001
2009-09-08
19:15
Combine the OP_Statement and OP_Transaction opcodes. file: [1a21d6dc] check-in: [aec9dbd8] user: dan branch: trunk, size: 119920
2009-09-01
12:16
More fixes and comment updates. file: [df8dfff6] check-in: [38a9327b] user: dan branch: trunk, size: 119425
2009-08-28
18:53
Changes to support recursive triggers. file: [212476dc] check-in: [9b9c1921] user: dan branch: trunk, size: 119461
2009-08-20
02:34
All the sqlite3GetCollSeq() function to specify an arbitrary text encoding. file: [a43c959c] check-in: [4ee44322] user: drh branch: trunk, size: 119177
2009-08-19
14:34
Clean up sqlite_stat2 related code. Add test cases. file: [ace6b5d9] check-in: [aa728e06] user: dan branch: trunk, size: 119172
2009-08-18
16:24
Change the sqlite_stat2 schema to be more flexible. file: [979b2aa9] check-in: [ded9dec6] user: dan branch: trunk, size: 119392
2009-08-17
17:06
First version of sqlite_stat2 (schema forces exactly 10 samples). file: [09389ab5] check-in: [dd96bda2] user: dan branch: trunk, size: 119173
2009-07-24
17:58
Allow virtual tables to be used in shared-cache mode. (CVS 6928) file: [a15de7c5] check-in: [5d9e767a] user: danielk1977 branch: trunk, size: 119140
2009-07-01
16:12
Report an error if a USING or ON clause is specified following a from-list element that is not to the right of a join operator. Fix for #3846. (CVS 6832) file: [867028ee] check-in: [29b48972] user: danielk1977 branch: trunk, size: 119074
14:56
Do not ignore alias "a" in a query of the form "SELECT ... FROM (...) AS a" Fix for #3935. Also expand upon (6751) to fix some similar obscure memory leaks. (CVS 6831) file: [1906bb28] check-in: [42f9d1e5] user: danielk1977 branch: trunk, size: 118953
2009-06-25
11:50
Get the notify2.test running again by removing an ALWAYS() that was mistakenly inserted and by taking care not to report corruption following an SQLITE_LOCKED failure during schema parsing. (CVS 6815) file: [813f6bda] check-in: [6e9140a7] user: drh branch: trunk, size: 118840
2009-06-23
20:28
Enhance autoincrement so that it works with triggers that also do autoincrement inserts, even multiple inserts into the same table. Ticket #3928 (CVS 6807) file: [d930b389] check-in: [1330993d] user: drh branch: trunk, size: 119054
2009-06-18
17:22
Move codec management from database connections into the pager so that it will work together with shared cache. (CVS 6782) file: [e98868af] check-in: [ed08b53c] user: drh branch: trunk, size: 118866
2009-06-16
04:35
Leave out a redundant line in build.c. Ticket #3916. (CVS 6766) file: [75b57e3f] check-in: [d9f997ae] user: danielk1977 branch: trunk, size: 119086
2009-06-11
00:47
Changes to reenable codec operation and to handle memory allocation failures within a codec. (CVS 6746) file: [6c7b9610] check-in: [43a6ca98] user: drh branch: trunk, size: 119095
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: [20e02fd7] check-in: [6dbf4eca] user: danielk1977 branch: trunk, size: 118891
2009-06-01
16:53
Fix compiler warnings with MSVC build. (CVS 6699) file: [6d527634] check-in: [07915885] user: shane branch: trunk, size: 118836
2009-05-28
21:04
Remove references to deleted function sqlite3ExprRegister(). Changes to the expr.c source module to promote better testing. (CVS 6686) file: [dedb5bcb] check-in: [6ae4ad6e] user: drh branch: trunk, size: 118827
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: [567574f5] check-in: [4ac2bdfb] user: drh branch: trunk, size: 118765
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: [028255aa] check-in: [7cb1c3ba] user: drh branch: trunk, size: 118971
2009-05-13
22:58
Additional simplifications to build.c in support full coverage testing. (CVS 6636) file: [2b4cef0d] check-in: [913d1114] user: drh branch: trunk, size: 118858
17:35
Remove incorrect NEVER() macro in the previous check-in (6634). (CVS 6635) file: [6cf99a4e] check-in: [c6849579] user: drh branch: trunk, size: 118637
17:21
Changes to build.c to help facilitate full coverage testing. (CVS 6634) file: [d9890c52] check-in: [264ace50] user: drh branch: trunk, size: 118644
2009-05-12
18:00
Remove debugging comments left in the prior check-in by mistake. (CVS 6631) file: [e8e2f7d6] check-in: [82070560] user: drh branch: trunk, size: 118438
17:46
Move the sqlite3MinimumFileFormat() routine from build.c over to alter.c since alter.c is the only code that uses it. Additional changes and cleanup to build.c to facility coverage testing. (CVS 6630) file: [f796caf3] check-in: [6fe3750a] user: drh branch: trunk, size: 118591
00:40
Tweaks to build.c to facilitate coverage testing. (CVS 6628) file: [65caba75] check-in: [6572b438] user: drh branch: trunk, size: 118010
2009-05-11
20:53
Rework the logic that generates a schema for tables created using "CREATE TABLE ... AS SELECT ...". Instead of trying to copy the raw datatype string from the right-hand side, just make the type one of TEXT, INT, REAL, NUM, or nothing. This is much simpler than trying to parse and quote datatype strings. Other minor implifications to build.c are bundled with this change. (CVS 6626) file: [caece816] check-in: [33cf8359] user: drh branch: trunk, size: 117868
2009-05-06
18:42
Fix three variable initialization problems found by valgrind. (CVS 6612) file: [a8320b5f] check-in: [37428435] user: drh branch: trunk, size: 119230
2009-05-04
11:42
Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) file: [8e83444d] check-in: [cac4f3d8] user: danielk1977 branch: trunk, size: 119215
2009-05-03
20:23
Changes to facility full coverage testing of util.c. (CVS 6597) file: [894dc1b8] check-in: [a6122990] user: drh branch: trunk, size: 118690
2009-05-02
13:29
Remove the aFKey hash table, which was not being used. Simplify the FKey object. Simplify the hash.c module since the copyKey parameter formerly used only by aFKey is now no longer required. (CVS 6594) file: [9f00cc9c] check-in: [80c43a35] user: drh branch: trunk, size: 118698
2009-05-01
21:13
Record within the Token structure itself whether or not the token has been dequoted. This steals one bit from the length of a token and thus limits the size of tokens to 1GiB. (CVS 6589) file: [a079f965] check-in: [12bcb03d] user: drh branch: trunk, size: 120068
2009-04-28
13:01
Do not store the zero string terminator as part of the name when holding symbols in the symbol table. (CVS 6557) file: [dca0ad77] check-in: [23d67af3] user: drh branch: trunk, size: 119957
2009-04-24
18:06
Dequote the "from" table in a FOREIGN KEY definition (affects the output of "pragma foreign_key_list). Fix for #3800. (CVS 6547) file: [2a50f5e6] check-in: [600482d1] user: danielk1977 branch: trunk, size: 119991
2009-04-23
13:22
Rework the column-cache mechanism to be more robust (and more correct). The column-alias cache is currently disabled, (CVS 6538) file: [d4c6d226] check-in: [dd4d67a6] user: drh branch: trunk, size: 119962
2009-04-20
17:43
Change the journal_mode pragma so that it always returns the current journal mode, even on a failed attempt to change the journal mode. Allow the journal mode to be changed as long as there is not a pending transaction. Ticket #3811. (CVS 6526) file: [18c5e51c] check-in: [419e320a] user: drh branch: trunk, size: 119966
2009-04-08
13:51
Minor refactoring of the expression-compaction logic for clarity of presentation. New comments added. The EXPRDUP_DISTINCTSPAN flag is removed as obsolete. (CVS 6470) file: [2882f220] check-in: [44ded2ea] user: drh branch: trunk, size: 119922
2009-03-31
03:41
Fix compiler warnings from gcc and MSVC; Correct typo in select.c; (CVS 6417) file: [72357fd7] check-in: [76851417] user: shane branch: trunk, size: 119950
2009-03-24
15:08
Changes to insure that lookaside memory allocations are never used to hold schema content. Ticket #3743. (CVS 6377) file: [be2bdaf2] check-in: [ea74d8dc] user: drh branch: trunk, size: 119949
2009-03-21
16:19
Update comments in build.c to conform to the latest implementation. (CVS 6369) file: [f217f9ce] check-in: [a915e8e0] user: drh branch: trunk, size: 119780
2009-03-18
18:43
Fix a crash that could occur when creating an index in shared-cache mode with lookaside enabled. (CVS 6358) file: [c816377c] check-in: [097737e3] user: danielk1977 branch: trunk, size: 120071
2009-03-17
17:49
Fix a problem that could cause a crash when a shared-cache schema contains column default values. (CVS 6353) file: [5f050f06] check-in: [afadddc3] user: danielk1977 branch: trunk, size: 120028
2009-03-14
08:37
Fix for #3719. When synthesizing a CREATE TABLE statement as as result of a "CREATE TABLE AS", quote the column type names unless they are simple identifiers or simple identifiers followed by one or two dimensions (e.g. "VARCHAR(10)"). (CVS 6345) file: [7e5e9301] check-in: [7c6437ef] user: danielk1977 branch: trunk, size: 120002
2009-02-28
10:47
Instead of linking temporary triggers on non-temporary tables into the Table.pTrigger list, search the temp schema for them on demand. Fix for #3688. (CVS 6329) file: [741240c8] check-in: [3befe1ef] user: danielk1977 branch: trunk, size: 117367
2009-02-20
10:58
Instead of using SetNumColumns, specify the number of columns in a table or index using the P4 argument. (CVS 6310) file: [a1db48ae] check-in: [e43ed649] user: danielk1977 branch: trunk, size: 117349
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: [0860029c] check-in: [d9f6ffbc] user: danielk1977 branch: trunk, size: 117357
2009-02-13
03:43
Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) file: [a394b251] check-in: [dd179ff2] user: drh branch: trunk, size: 117626
2009-02-10
10:44
Do not always open a transaction on the temp database when writing to the main or another attached database. (CVS 6273) file: [909c43d7] check-in: [f76b0b81] user: danielk1977 branch: trunk, size: 117580
2009-02-03
22:17
A backup must clear the internal schema of the destination database so that the schema will be reloaded for the next sqlite3_prepare() (CVS 6247) file: [6f3d5f74] check-in: [76f23a43] user: drh branch: trunk, size: 117992
16:51
Commit first version of the 'backup' feature. (CVS 6241) file: [ed7a59fa] check-in: [663479b4] user: danielk1977 branch: trunk, size: 118000
15:50
Remove several compiler warnings. (CVS 6239) file: [1d755e49] check-in: [85e9196d] user: drh branch: trunk, size: 117652
2009-02-02
18:03
Omit the TEMP keyword from the schema of TEMP tables created using CREATE TEMP TABLE AS SELECT ..... Ticket #3630. (CVS 6232) file: [69135424] check-in: [3b0a2554] user: drh branch: trunk, size: 117696
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: [c8bf5dce] check-in: [1041abd6] user: danielk1977 branch: trunk, size: 117766
2008-12-30
06:24
Invoke the authorization callback when compiling SAVEPOINT, ROLLBACK TO and RELEASE commands. (CVS 6074) file: [6eb9d20e] check-in: [e49807b1] user: danielk1977 branch: trunk, size: 117764
2008-12-23
11:11
In sqlite3AddColumn(), use local variable 'db' instead of 'pParse->db'. (CVS 6056) file: [92335a6c] check-in: [0c53a4c2] user: danielk1977 branch: trunk, size: 117533
2008-12-17
17:30
Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) file: [f3e8377c] check-in: [34b56600] user: danielk1977 branch: trunk, size: 117549
2008-12-10
22:30
Work to remove harmless MSVC compiler warnings. (CVS 6013) file: [ae435947] check-in: [715dcd52] user: shane branch: trunk, size: 117077
21:19
Additional work at eliminating silly compiler warnings. (CVS 6010) file: [205538f3] check-in: [ea01d437] user: drh branch: trunk, size: 117075
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: [64e9eb40] check-in: [c872d554] user: drh branch: trunk, size: 116906
17:20
Remove or rename local variables that shadow other variables or parameters. (CVS 6005) file: [01919ad8] check-in: [e7e9fa4f] user: drh branch: trunk, size: 116619
2008-12-05
15:24
Make use of sqlite3DbMallocSize to maximize the size of growable buffers after each reallocation. Added new comments and testcase() macros to where.c. (CVS 5981) file: [ce642b06] check-in: [46f2d089] user: drh branch: trunk, size: 116659
2008-11-17
19:18
Modifications to avoid unsigned/signed comparisons in various files. (CVS 5914) file: [a89e901e] check-in: [8009220c] user: danielk1977 branch: trunk, size: 116544
2008-11-13
18:29
Fixed several more crashes due to corrupt db files. Added corruptC.test to soak.test. (CVS 5905) file: [7723123a] check-in: [9b7a52e9] user: shane branch: trunk, size: 116531
2008-11-11
18:28
Cleanup in flattenSubquery. Add OOM tests for flattenSubquery. Fix issues with OOM errors causes problems for flattenSubquery. Ticket #3485. (CVS 5882) file: [98a6884d] check-in: [ea5f4baa] user: drh branch: trunk, size: 116437
2008-11-03
20:55
Change the name of the Cursor object to VdbeCursor. (CVS 5857) file: [41464eb8] check-in: [fdb98fd8] user: drh branch: trunk, size: 114422
2008-10-22
10:45
Fix an assert() failure that can occur following a malloc() failure. Ticket #3455. (CVS 5834) file: [d6d55f97] check-in: [e0d3aa75] user: danielk1977 branch: trunk, size: 114413
2008-10-06
16:18
Allow INDEXED BY and NOT INDEXED to be used in UPDATE and DELETE statements. (CVS 5772) file: [8714bd80] check-in: [83a7e446] user: danielk1977 branch: trunk, size: 114393
05:32
Allow INDEXED BY and NOT INDEXED clauses in SELECT statements. (CVS 5766) file: [5097bb79] check-in: [98ca5580] user: danielk1977 branch: trunk, size: 114088
2008-08-20
16:35
Refactor the name resolution procedures in the code generator. (CVS 5569) file: [160c71ac] check-in: [daf730d1] user: drh branch: trunk, size: 113739
2008-08-11
18:44
Do not allow indexing of any table whose name begins with "sqlite_". Ticket #3284. Improve handling of databases with malformed schemas - just in case somebody has actually indexed a system table. (CVS 5553) file: [931ed94f] check-in: [0e1d8d14] user: drh branch: trunk, size: 113553
2008-08-06
13:47
Fix compilation with SQLITE_OMIT_FOREIGN_KEY defined. Ticket #3273. (CVS 5544) file: [00aa62a8] check-in: [ce8cbeea] user: danielk1977 branch: trunk, size: 113538
2008-08-04
04:39
Add an assert() statement that will alert us if the potential problem identified by #3243 ever becomes a reality. (CVS 5532) file: [f774f01e] check-in: [34208f0b] user: danielk1977 branch: trunk, size: 113544
2008-08-02
03:50
Additional coverage testing. Fix a segfault following OOM in sqltie3_load_extension(). (CVS 5523) file: [05be60b1] check-in: [f1e44eb3] user: drh branch: trunk, size: 113505
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: [77d5518a] check-in: [e48f9697] user: drh branch: trunk, size: 113635
2008-07-08
23:40
Remove obsolete code from select.c, including the "affinity" parameter to the sqlite3Select() module. (CVS 5380) file: [bac7233d] check-in: [cbd3c158] user: drh branch: trunk, size: 113121
22:28
Added macros to convert between 32-bit ints and 64-bit ptrs to avoid compiler warnings. (CVS 5378) file: [c5985afa] check-in: [6cdb6841] user: shane branch: trunk, size: 113126
19:34
Completely rework the sqlite3SetString() primitive so that it honors the SQLITE_LIMIT_LENGTH and avoids the use of strlen(). (CVS 5374) file: [f6a74df6] check-in: [8ed04b1e] user: drh branch: trunk, size: 113112
14:52
Improved enforcement of the SQLITE_LIMIT_LENGTH limit. (CVS 5368) file: [142ceacd] check-in: [ee931508] user: drh branch: trunk, size: 113229
00:06
Testing coverage enhancements. (CVS 5358) file: [8779e927] check-in: [fe80aa58] user: drh branch: trunk, size: 113133
2008-06-15
02:51
Continuing work on the new memory allocation subsystem. Added routines for temporary memory allocation. Right the btree balance mechanism to only do one temporary allocation at a time. (CVS 5220) file: [88cc5501] check-in: [65fe7b62] user: drh branch: trunk, size: 113080
2008-05-01
17:16
Fix more compiler warnings. (CVS 5074) file: [a52d9d51] check-in: [59568844] user: drh branch: trunk, size: 113081
2008-04-28
18:46
Make sure that transactions are started on all virtual tables that changes in a single statement, not just the first. Ticket #3083. Need to add test cases. (CVS 5063) file: [2cde01ca] check-in: [133b7ee5] user: drh branch: trunk, size: 113043
2008-04-27
18:40
Remove all references to sqlite3_intptr_t. (CVS 5051) file: [8fd7faba] check-in: [6a94d197] user: drh branch: trunk, size: 113002
2008-04-17
20:59
Continuing progress on the journal_mode pragma. It still does not work. (CVS 5027) file: [f56940d7] check-in: [4a72a7bb] user: drh branch: trunk, size: 113020
2008-04-11
17:11
Remove entries from the sqlite_stat1 table whenever an index is dropped. Related to #3033. (CVS 4989) file: [e6f17bbb] check-in: [349aab42] user: danielk1977 branch: trunk, size: 112915
2008-04-02
16:29
Simplifications to the LockTable opcode. (CVS 4954) file: [5d36a604] check-in: [66c5d715] user: drh branch: trunk, size: 112431
2008-04-01
03:27
More test cases and bug fixes with CSE. (CVS 4948) file: [fb042279] check-in: [7e815612] user: drh branch: trunk, size: 112450
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: [4e6321d1] check-in: [ee381b43] user: drh branch: trunk, size: 112371
09:47
Use a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912) file: [d0715b34] check-in: [04715364] user: danielk1977 branch: trunk, size: 112376
2008-03-20
14:03
Initial implementation of per-connection limits and the sqlite3_limit() API. The sqllimits1.test script crashes. SQLITE_LIMIT_PAGE_COUNT and SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897) file: [31ed5af4] check-in: [60c77882] user: drh branch: trunk, size: 112369
2008-03-06
09:58
Handle non-autoconf build correctly with new changes (CVS 4832) file: [fa70bc0f] check-in: [e2a9f5f1] user: mlcreech branch: trunk, size: 112303
07:35
Use intptr_t definition to silence warnings about ptr-int casts (CVS 4824) file: [19990e2c] check-in: [54839a84] user: mlcreech branch: trunk, size: 112295
2008-01-31
13:35
Version number to 3.5.5. Include FTS3 in the amalgamation by default (but disabled unless compiled with -DSQLITE_ENABLE_FTS3). Fix a memory allocation problem. (CVS 4757) file: [7d93ee56] check-in: [72411043] user: drh branch: trunk, size: 112280
2008-01-25
15:04
Error messages says "no such view" instead of "no such table" when trying to DROP a VIEW that does not exist. (CVS 4750) file: [3302f9a8] check-in: [50815a82] user: drh branch: trunk, size: 112228
2008-01-22
14:50
Remove dead code from the lemon-generated parser. Better testing of the sqlite3_file_control() interface, and in particular make sure the interface works on :memory: databases. (CVS 4738) file: [a073dde2] check-in: [83ca4fc7] user: drh branch: trunk, size: 111904
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: [b228a333] check-in: [2a0bc1e1] user: drh branch: trunk, size: 111904
2008-01-21
16:22
Miscellaneous test coverage improvements. (CVS 4734) file: [deb031f7] check-in: [720bc20a] user: drh branch: trunk, size: 111875
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: [27a3be10] check-in: [706b41b7] user: drh branch: trunk, size: 112094
02:36
Registerification of the WHERE clause logic. (CVS 4716) file: [ea291f09] check-in: [b3a141b2] user: drh branch: trunk, size: 111962
2008-01-12
21:35
The sqlite3_trace() callback now prints a message as each trigger fires within a statement. (CVS 4709) file: [c0f9dba7] check-in: [110c000d] user: drh branch: trunk, size: 111858
12:48
Continuing work toward converting the VM into a register machine. (CVS 4707) file: [353cce0f] check-in: [a6dddebc] user: drh branch: trunk, size: 111840
2008-01-10
23:50
More work toward converting the VM into a register-based machine. (CVS 4704) file: [e5bb1ddf] check-in: [8cbd4651] user: drh branch: trunk, size: 111657
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: [785139de] check-in: [e3cf1c1c] user: drh branch: trunk, size: 111387
2008-01-06
00:25
Registerify the SRT_Subroutine destination for SELECT results. (CVS 4690) file: [22b50a46] check-in: [8201f717] user: drh branch: trunk, size: 111276
2008-01-05
18:48
Modify OP_RegMakeRec to take a base register and count and optionally store results in the register specified by P3. (CVS 4689) file: [26690c51] check-in: [6bb1b1bc] user: drh branch: trunk, size: 111245
05:20
Register-ify the OP_AddImm and all casting opcodes. Omit the OP_MemIncr opcode. (CVS 4683) file: [60a3ec74] check-in: [3e8a07dd] user: drh branch: trunk, size: 111245
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: [739eeee8] check-in: [cc149eb9] user: drh branch: trunk, size: 111242
2008-01-04
22:01
Implement the out2-prerelease opcode design pattern. (CVS 4681) file: [eac0f7e6] check-in: [fe057a88] user: drh branch: trunk, size: 111249
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: [b7874b45] check-in: [0b849805] user: drh branch: trunk, size: 111243
09:51
Change the OP_Insert opcode to read the key and data to insert from memory cells, not the stack. (CVS 4666) file: [11cd1e6a] check-in: [46501f49] user: danielk1977 branch: trunk, size: 111251
07:54
Change OP_OpenRead and OP_OpenWrite so that the database number is read from the P3 operand, not the stack. (CVS 4663) file: [a34fc6b2] check-in: [35da261d] user: danielk1977 branch: trunk, size: 111257
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: [043c36a3] check-in: [027875e4] user: drh branch: trunk, size: 111364
2008-01-02
16:27
Combine the eDest and iParm arguments to sqlite3Select() into a single type - "SelectDest". (CVS 4657) file: [640c2a2a] check-in: [86dcdfe6] user: danielk1977 branch: trunk, size: 111325
2007-12-27
15:12
Fix a race condition that can occur when reloading the database schema in shared-cache mode. (CVS 4643) file: [cbfd98ce] check-in: [b37babef] user: danielk1977 branch: trunk, size: 111289
2007-12-04
16:54
Make sure statement journals are initiated when doing DROP operations (since the DROP might fail after sqlite_master changes). Also make sure statement journals are initiated if there are pending SELECT statements. Ticket #2820. (CVS 4591) file: [580561a0] check-in: [bf34284f] user: drh branch: trunk, size: 111133
2007-12-02
11:46
When parsing CREATE INDEX statements from the sqlite_master table, do not search the temp database schema for the corresponding table. Only consider the database for which the schema is being parsed. Ticket #2817. (CVS 4587) file: [04e0783a] check-in: [e6f02aa5] user: danielk1977 branch: trunk, size: 111093
2007-11-12
09:50
Allow collation sequence names to be quoted. Ticket #2744. (CVS 4537) file: [b58dd7c7] check-in: [06749ac7] user: danielk1977 branch: trunk, size: 110996
2007-10-15
07:08
Fix for OMIT_AUTHORIZATION builds. (CVS 4489) file: [d4ace66c] check-in: [260711a1] user: danielk1977 branch: trunk, size: 110846
2007-10-12
20:42
Do not invoke the authorizer when reparsing the schema after a schema change or when trying to figure out the result set of a view. (CVS 4488) file: [a400945d] check-in: [e756bc9b] user: drh branch: trunk, size: 110734
2007-10-04
18:11
Fixes for OMIT_AUTHORIZATION builds. #2691. (CVS 4466) file: [fec79257] check-in: [755fcaf7] user: danielk1977 branch: trunk, size: 110602
2007-09-03
15:19
Honor the SQLITE_OPEN_ flags passed into sqlite3_open_v2(). Some test cases added but more are needed. Ticket #2616. (CVS 4376) file: [94d0d6df] check-in: [020a2b10] user: drh branch: trunk, size: 110488
2007-08-30
01:19
Fix for the sqlite3AbortOtherActiveVdbes() problem. (CVS 4328) file: [f8eeec5c] check-in: [e40d40a5] user: drh branch: trunk, size: 110274
2007-08-29
14:06
Use the DbMalloc() and DbRealloc() functions more consistently. (CVS 4323) file: [830d1a6b] check-in: [c790c234] user: danielk1977 branch: trunk, size: 110198
12:31
Modifications to the malloc failure tests to test transient and persistent failures. (CVS 4321) file: [915c4591] check-in: [e38ef81b] user: danielk1977 branch: trunk, size: 110266
2007-08-28
22:24
Clean up the locking in the btree logic. (CVS 4316) file: [99b0b0c4] check-in: [967ab229] user: drh branch: trunk, size: 110087
02:27
Work toward correct btree locking in a multithreaded environment. (CVS 4307) file: [08001e8a] check-in: [b8cc493b] user: drh branch: trunk, size: 110086
2007-08-22
20:18
The malloc.test script now passes all tests with no errors. (CVS 4271) file: [bc7406e2] check-in: [db818430] user: drh branch: trunk, size: 110031
2007-08-21
19:33
The sqlite3_value object now carries an sqlite3* pointer to use for recording malloc failures. This eliminates the need to pass sqlite3* pointers into many internal interfaces. Also added more mutexing. (CVS 4263) file: [21595511] check-in: [92872761] user: drh branch: trunk, size: 109960
2007-08-17
01:14
Begin adding mutexes. Compiles without SQLITE_OMIT_SHARED_CACHE but we get an assertion fault on the shared cache testing. (CVS 4239) file: [add67be9] check-in: [4c1e9ffe] user: drh branch: trunk, size: 109933
2007-08-16
10:09
More work on refactoring of malloc() interfaces. There are still many errors. (CVS 4233) file: [923d6643] check-in: [77b16713] user: danielk1977 branch: trunk, size: 110071
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: [a25bf9d2] check-in: [deb7ecd6] user: drh branch: trunk, size: 110050
2007-07-02
19:31
Fix a comment typo reported on the mailing list. (CVS 4152) file: [59fd5782] check-in: [25e6df9c] user: drh branch: trunk, size: 108998
2007-05-15
14:34
Relax the restriction on using bytes 0x80 through 0xbf as the first character of an identifier. Enhancements to ALTER TABLE tests for tables with strange names or stange column names. (CVS 4008) file: [50992d92] check-in: [262a3e63] user: drh branch: trunk, size: 109008
03:56
Fix problems in ALTER TABLE that occur when column or table names are invalid UTF encodings. (CVS 4000) file: [a27a21a2] check-in: [9ff382f4] user: drh branch: trunk, size: 109092
2007-05-12
15:00
Make REINDEX robust in the face of malloc() errors. (CVS 3990) file: [8e744caf] check-in: [dbe41774] user: drh branch: trunk, size: 109008
2007-05-08
20:59
Disable tracing pragmas when not in debug mode. This eliminates an external dependency on stdout. (CVS 3959) file: [57893032] check-in: [5a0fe985] user: drh branch: trunk, size: 108987
20:37
Fix the amalgamation generator so that all non-API functions have file scope. (CVS 3958) file: [83ae5b1f] check-in: [e9f56ead] user: drh branch: trunk, size: 108960
13:58
Add more code to enforce the limits specified in limits.h. (CVS 3946) file: [5a60e2e4] check-in: [c59d4360] user: drh branch: trunk, size: 108960
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: [94022eb0] check-in: [93b623b2] user: drh branch: trunk, size: 108842
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: [0dd6f0d0] check-in: [b13e497a] user: drh branch: trunk, size: 108786
16:14
Optional parameter in the INCREMENTAL VACUUM statement specifies how many pages to vacuum from the database. (CVS 3919) file: [470c3d39] check-in: [ed713f9c] user: drh branch: trunk, size: 109488
13:15
Eliminate all uses of sprintf() and strcpy(). These were not being misused. But getting rid of them removes a library dependency. And it avoids warnings from the OpenBSD compiler. Ticket #2336. (CVS 3916) file: [05ef6d80] check-in: [ba4845b3] user: drh branch: trunk, size: 109271
2007-04-26
14:42
Add largely untested code for the incremental vacuum function. (CVS 3876) file: [02e01ec7] check-in: [f6a6d2b8] user: danielk1977 branch: trunk, size: 109102
2007-04-18
14:47
Fix an assertion failure caused by (3851). (CVS 3852) file: [1880da16] check-in: [24683f1d] user: danielk1977 branch: trunk, size: 108617
2007-04-16
15:06
Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845) file: [8ad4f894] check-in: [8d6c3bfc] user: danielk1977 branch: trunk, size: 108592
2007-04-05
11:25
Improvements to coverage testing. (CVS 3810) file: [7c2efa46] check-in: [38af156d] user: drh branch: trunk, size: 108832
2007-03-29
05:51
Change BtreeMoveto so that it can be biased to the right or to the center. Use a right bias when appending and a center bias when searching. This gives about a 15% reduction in calls to sqlite3VdbeRecordCompare. (CVS 3741) file: [ad3374b5] check-in: [ad4a6b1a] user: drh branch: trunk, size: 109164
2007-03-27
13:36
More strict aliasing fixes. The single source file library now runs successfully with -fstrict-alias. (CVS 3725) file: [d178bd7c] check-in: [c8a8a189] user: drh branch: trunk, size: 109152
2007-03-26
22:05
Modify sources to that they can be combined into a single sqlite3.c source file. Eliminate all type-pruned pointer warnings. (CVS 3722) file: [fe2fcebc] check-in: [0b832e21] user: drh branch: trunk, size: 108871
2007-03-17
10:26
Modifications to crash-test infrastructure. (CVS 3695) file: [f2edc786] check-in: [c4be8d99] user: danielk1977 branch: trunk, size: 108886
2007-03-13
16:32
Do not crash when a corrupt database contains two indices with the same name. (CVS 3684) file: [f6b2616b] check-in: [48b2a400] user: danielk1977 branch: trunk, size: 108898
2007-02-02
12:44
Minor tweaks to collating sequences. We'll hold of making major changes until 3.4.0, since we'll likely end up with some minor technical imcompatibilities. (CVS 3626) file: [6bd68dc7] check-in: [9740aa95] user: drh branch: trunk, size: 108890
2006-12-16
16:25
Query optimizer enhancement: In "FROM a,b,c left join d" allow the C table to be reordered with A and B. This used to be the case but the capability was removed by (3203) and (3052) in response to ticket #1652. This change restores the capability. (CVS 3529) file: [02aedde7] check-in: [7393c81b] user: drh branch: trunk, size: 108338
2006-09-11
23:45
Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) file: [7199949a] check-in: [e4fe736c] user: drh branch: trunk, size: 106014
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: [4359b34a] check-in: [b4d53974] user: drh branch: trunk, size: 105936
2006-07-26
16:22
Disallow writing to, creating or dropping virtual tables from within xSync() callbacks. (CVS 3339) file: [2ea8ad0e] check-in: [e705d232] user: danielk1977 branch: trunk, size: 105836
2006-07-11
14:17
By default, new databases are now created in the legacy file format - the format that ignores DESC on indices. If you want descending indices, you must either recompile with -DSQLITE_DEFAULT_FILE_FORMAT=4 or issue "PRAGMA legacy_file_format=OFF" prior to creating the first table in the database. (CVS 3330) file: [b5eb033a] check-in: [65b60f05] user: drh branch: trunk, size: 105533
2006-06-21
12:36
Add tests to make sure altering or adding an index to a virtual table is prohibited. (CVS 3280) file: [ef710ff6] check-in: [6c3e8852] user: danielk1977 branch: trunk, size: 105545
07:34
Test cases for accessing virtual tables when the corresponding module is undefined. (CVS 3279) file: [467944d9] check-in: [bcef48c5] user: danielk1977 branch: trunk, size: 105382
2006-06-20
11:01
Modifications so that compilation and testing with the various OMIT macros defined works. (CVS 3276) file: [ef7debea] check-in: [c6ea353b] user: danielk1977 branch: trunk, size: 105291
2006-06-19
05:33
Respect default collation sequences assigned to virtual table columns. (CVS 3272) file: [0152e858] check-in: [d9b205ac] user: danielk1977 branch: trunk, size: 105231
2006-06-16
16:08
Add code to invoke the virtual table transaction interface. Untested at this point. (CVS 3261) file: [3eb63f61] check-in: [61251402] user: danielk1977 branch: trunk, size: 105250
08:01
Add some tests (and fixes) for virtual tables and the authorization callback. Still more to come. (CVS 3260) file: [28208a90] check-in: [9497c66e] user: danielk1977 branch: trunk, size: 105051
2006-06-15
07:29
Simple tests and fixes for writing to virtual tables. (CVS 3252) file: [a295396a] check-in: [88fa510e] user: danielk1977 branch: trunk, size: 104771
2006-06-14
19:00
Added code to INSERT, DELETE and UPDATE virtual tables. The new code is mostly untested. (CVS 3248) file: [076619b2] check-in: [32c97b88] user: drh branch: trunk, size: 104686
2006-06-12
16:01
Add code to invoke the xDestroy method of a virtual table when it is dropped. (CVS 3218) file: [133a046c] check-in: [f0c7c8d1] user: danielk1977 branch: trunk, size: 104734
12:08
Add a simple test case (and corresponding bugfix) for the virtual table xConnect and xDisconnect methods. (CVS 3214) file: [0781f854] check-in: [b63dbc79] user: danielk1977 branch: trunk, size: 104750
11:24
Add first cut of sqlite3_declare_vtab(). Not at all well tested yet. (CVS 3213) file: [a72a7095] check-in: [bbeb93b5] user: danielk1977 branch: trunk, size: 104525
2006-06-11
23:41
Progress toward CREATE VIRTUAL TABLE. Still not even close to working... (CVS 3211) file: [f541d3e9] check-in: [898ec36b] user: drh branch: trunk, size: 104161
2006-06-10
13:29
Basic parsing of CREATE VIRTUAL TABLE statements. (CVS 3210) file: [a64e4765] check-in: [66370cb9] user: drh branch: trunk, size: 104229
2006-05-11
23:14
Adjust the default weights on indices so that an index that matches more terms of the where clause wins (by default) over one that matches fewer. Ticket #1808. (CVS 3186) file: [eefefdc8] check-in: [249b579f] user: drh branch: trunk, size: 104052
2006-03-24
03:36
Make sure the rootpage values in the symbol table are correctly updated when dropping tables and indices in autocommit mode. Ticket #1728. (CVS 3150) file: [be062911] check-in: [1c582dd1] user: drh branch: trunk, size: 104004
2006-03-23
23:33
Improvements to comments in build.c. (CVS 3149) file: [b8437e81] check-in: [986208a3] user: drh branch: trunk, size: 103390
2006-03-13
12:54
Additional changes due to Coverity scans. (CVS 3130) file: [4bd8471e] check-in: [a69f697d] user: drh branch: trunk, size: 102929
2006-03-06
20:55
Code changes resulting from Coverity analysis. http://scan.coverity.com/ Found 1 potential segfault in sqlite3_mprintf(). Also 2 failures to fclose() following a malloc() failure. And lots of cases where unnecessary conditionals could be removed from the code. (CVS 3126) file: [98b458e3] check-in: [e510e6dd] user: drh branch: trunk, size: 102917
2006-02-24
02:53
Remove unused parameters on internal APIs. Suppress warnings from CodeWarrior. (CVS 3110) file: [eaf2d4d8] check-in: [4b22e4b8] user: drh branch: trunk, size: 102922
2006-02-18
16:36
Always generate code, even if it is a no-op, for CREATE and DROP statements that use the IF EXISTS or IF NOT EXISTS clause. (CVS 3106) file: [f96e57e6] check-in: [f8173e6a] user: drh branch: trunk, size: 103059
2006-02-17
12:25
Ensure temp db is open before executing a pragma like "temp.cachesize = xxx". Fix for #1682. (CVS 3104) file: [e0cecb85] check-in: [1e4644b2] user: danielk1977 branch: trunk, size: 103039
2006-02-10
18:08
Make sure pointers are always aligned to 8-bytes when creating internal Index structures. (CVS 3079) file: [b46cd7d0] check-in: [d20a33ac] user: drh branch: trunk, size: 103038
07:07
Fix the origin APIs so that they correctly handle views and subqueries that cannot be flattened. (CVS 3072) file: [11798f16] check-in: [5e8611e1] user: danielk1977 branch: trunk, size: 103047
2006-02-05
18:55
Detect circularly defined views and issue an error message. Ticket #1658. (CVS 3055) file: [d959aa9c] check-in: [f5341529] user: drh branch: trunk, size: 103013
2006-01-24
12:09
Rename some variables to avoid hiding others. Also add "static" to two function signatures that were missing it. (CVS 3024) file: [feaa61e7] check-in: [d86f18a4] user: danielk1977 branch: trunk, size: 103034
2006-01-18
16:51
Use a global variable protected by a mutex instead of thread-specific-data to record malloc() failures. (CVS 2972) file: [15224e2f] check-in: [ac090f2a] user: danielk1977 branch: trunk, size: 103018
2006-01-16
15:14
Fix some of the issues raised in #1615. (CVS 2959) file: [539b5c6e] check-in: [0d5d83bc] user: danielk1977 branch: trunk, size: 103244
2006-01-13
18:06
Account for multi-byte characters in ALTER TABLE code. Fix for #1609. (CVS 2942) file: [206c8910] check-in: [d634f8b2] user: danielk1977 branch: trunk, size: 103151
06:33
Minor modification to restoreOrClearCursorPosition() to improve efficiency. Do not allocate the extra 8-bytes if memory-management is not enabled. (CVS 2936) file: [6db3dcb7] check-in: [dd705955] user: danielk1977 branch: trunk, size: 103084
2006-01-12
01:56
Add the legacy_file_format pragma. (CVS 2922) file: [a0559746] check-in: [b2dbd1a5] user: drh branch: trunk, size: 103078
2006-01-11
21:41
Automatically deallocate thread-specific data when it is no longer being used. Ticket #1601. Also implemented the suggestion of ticket #1603. Memory management is now off by default at compile-time. The sqlite3_enable_memory_management() API has been removed. (CVS 2919) file: [652a3932] check-in: [5d9c6aa9] user: drh branch: trunk, size: 102967
14:09
Fix bugs caused by assuming that shared-schemas are initialized. (CVS 2917) file: [c7847f29] check-in: [3970eb87] user: danielk1977 branch: trunk, size: 102890
2006-01-10
17:58
Store collation sequence names instead of pointers in sharable schema data structures. (CVS 2904) file: [59c4a6fc] check-in: [0f0213be] user: danielk1977 branch: trunk, size: 103052
07:14
If compiled with memory-debugging, write garbage to memory when it is freed. Fix for #1594. (CVS 2900) file: [97997d43] check-in: [bd02a6fa] user: danielk1977 branch: trunk, size: 101471
2006-01-09
23:40
Added database server example code (untested). Fixed serveral bugs including the autovacuum compile problem described by ticket #1593. (CVS 2897) file: [db1d1bd8] check-in: [ec332d88] user: drh branch: trunk, size: 101463
16:12
Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) file: [ff75e783] check-in: [3e75d3d5] user: danielk1977 branch: trunk, size: 101422
06:29
Rename DbSchema to "Schema" and SqliteTsd to "ThreadData". (CVS 2893) file: [e40a4caa] check-in: [82b81f69] user: danielk1977 branch: trunk, size: 101508
05:36
Minor changes so that OMIT_SHARED_CACHE works. (CVS 2892) file: [8f0b1da7] check-in: [cc963f8c] user: danielk1977 branch: trunk, size: 101404
2006-01-07
13:21
In shared-cache mode, lock all required tables before beginning to execute the body of the statement program. (CVS 2881) file: [0cf9f744] check-in: [23b587b0] user: danielk1977 branch: trunk, size: 101465
2006-01-06
06:33
Fix a bug that was emptying shared-schema tables during an ATTACH. (CVS 2867) file: [715ac7d4] check-in: [752a2754] user: danielk1977 branch: trunk, size: 98764
2006-01-05
11:34
Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) file: [6b14101f] check-in: [deeda0dc] user: danielk1977 branch: trunk, size: 99629
2006-01-04
21:40
Bug fix in the IF NOT EXISTS logic. (CVS 2858) file: [7bf6f9ba] check-in: [cb9095ac] user: drh branch: trunk, size: 98539
15:54
Add support for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS. (CVS 2855) file: [6bf007d0] check-in: [551cdd6c] user: drh branch: trunk, size: 98499
2005-12-29
23:33
Add support for CREATE TABLE IF NOT EXISTS. (CVS 2847) file: [bb4c9df2] check-in: [0bd9e35f] user: drh branch: trunk, size: 98352
19:23
Add serial-types 8 and 9 for integer constants of 0 and 1 that use zero bytes of storage. Make the default file format 4. Add the SQLITE_DEFAULT_FILE_FORMAT compile-time option to lower the default file format number so that newly created databases can be read and written by older versions of SQLite. (CVS 2845) file: [0982b00a] check-in: [ae301db8] user: drh branch: trunk, size: 98263
01:11
Add support for DROP TABLE IF EXISTS. (CVS 2843) file: [88a44141] check-in: [a4c547de] user: drh branch: trunk, size: 98627
2005-12-21
18:36
Bug fixes and additional testing of descending indices. (CVS 2841) file: [51f3f468] check-in: [5638a11e] user: drh branch: trunk, size: 98551
14:43
Basic functionality for descending indices is in place. Lots more testing needed. (CVS 2840) file: [fd441764] check-in: [7064433e] user: drh branch: trunk, size: 98551
03:16
Progress toward decending indices. (CVS 2839) file: [502479f9] check-in: [112a34b8] user: drh branch: trunk, size: 98045
2005-12-16
01:06
Initial infrastructure for recognizing DESC indices and being able to read and write older databases that specify DESC indices but do not really use them. Nothing is close to working yet. (CVS 2822) file: [178a5c36] check-in: [cd110aa2] user: drh branch: trunk, size: 98072
2005-12-09
20:02
Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) file: [306dde31] check-in: [83a59151] user: drh branch: trunk, size: 96481
2005-12-06
12:52
Some elements of the new malloc() failure handling. Not all cases work properly yet. Also, library is not threadsafe if malloc() fails right now. (CVS 2800) file: [41350367] check-in: [e1606658] user: danielk1977 branch: trunk, size: 96463
2005-11-14
22:29
Create separate affinities for INTEGER and REAL. (CVS 2766) file: [8c93ae10] check-in: [ce06c123] user: drh branch: trunk, size: 96191
2005-11-03
02:03
Disallow subqueries in CHECK constraints. (CVS 2756) file: [03ccfb2d] check-in: [db27afc4] user: drh branch: trunk, size: 95822
00:41
First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) file: [5441ae70] check-in: [2313d912] user: drh branch: trunk, size: 95801
2005-11-01
15:48
Omit the SQLITE_AFF_INTEGER type affinity. All numeric values are now of type real, though an integer representation is still sometimes used internally for efficiency. (CVS 2753) file: [a9dc62b9] check-in: [e0d6f61c] user: drh branch: trunk, size: 94564
2005-09-20
17:42
Code cleanup and simplification. Three new Mem opcodes added. The sqlite3VdbeJumpHere function added. (CVS 2730) file: [aa959183] check-in: [2471957f] user: drh branch: trunk, size: 94344
2005-09-16
02:48
Undo check-in (2694). (CVS 2697) file: [74653e04] check-in: [6017b196] user: drh branch: trunk, size: 94398
2005-09-15
21:24
The table_info pragma now gives the order of columns in the primary key. (CVS 2694) file: [62a286c8] check-in: [9b60f48d] user: drh branch: trunk, size: 94414
2005-09-10
15:35
Avoid a memory leak and/or assertion failure when parsing a table declaration that contains a duplicate column name. Ticket #1418. (CVS 2684) file: [db063dc3] check-in: [f4342774] user: drh branch: trunk, size: 94381
2005-09-08
14:17
Remove a few unused variables detected by Borland C. Ticket #1412. (CVS 2675) file: [86181cbd] check-in: [cdfe372a] user: drh branch: trunk, size: 94382
00:13
All regression tests now pass. But I am sure there must still be problems. New tests need to be added. (CVS 2666) file: [fcedb4ba] check-in: [bcc7d722] user: drh branch: trunk, size: 94596
2005-09-07
21:22
Rewrite the aggregate handling logic so that it runs in O(1) space. This is the first cut at the code. Many regression tests fail. (CVS 2662) file: [d9f3c0e6] check-in: [17039ec3] user: drh branch: trunk, size: 94554
2005-08-31
13:13
Explicit typecasts to silence nuisance compiler warnings. Ticket #1398. (CVS 2650) file: [d61682e8] check-in: [90712ea7] user: drh branch: trunk, size: 93620
2005-08-29
23:00
Increase resolution of time-of-day on unix. Add an experimental sqlite3_profile() API. (CVS 2639) file: [15090203] check-in: [ed2ca087] user: drh branch: trunk, size: 93604
2005-08-20
03:03
Increased test coverage. Some malloc tests now fail though this is believed to be an instrumentation problem not a real error. (CVS 2604) file: [55e7e915] check-in: [f786f37a] user: drh branch: trunk, size: 93547
2005-08-18
18:15
Comment fixes. No changes to the underlying code. (CVS 2598) file: [bc7b4791] check-in: [b865e243] user: drh branch: trunk, size: 93666
2005-08-14
01:34
Declare local-use functions as static. Ticket #1363. (CVS 2593) file: [6481b728] check-in: [94efd790] user: drh branch: trunk, size: 93957
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: [bd16c686] check-in: [25cfe939] user: drh branch: trunk, size: 93943
2005-07-28
16:51
The new optimizer now passes all regression tests. (CVS 2566) file: [e50f2f4c] check-in: [a2121284] user: drh branch: trunk, size: 93930
2005-07-27
20:41
More work on the new optimizer. Fewer tests fail now. (CVS 2565) file: [4b6f9e61] check-in: [ee3a08e3] user: drh branch: trunk, size: 94166
2005-07-23
22:59
A new optimizer that breaks a lot of tests. But none of them critically, I think. Nevertheless, there is a lot of work ahead to stabilize the code. (CVS 2564) file: [b78e95dc] check-in: [86ce56cc] user: drh branch: trunk, size: 93228
14:52
Store the total number of rows as part of the ANALYZE statistics. (CVS 2563) file: [59a3ffe9] check-in: [868279c7] user: drh branch: trunk, size: 92864
03:18
The results of ANALYZE are now loaded into internal data structures where they can be used. But they are not actually used yet. (CVS 2562) file: [6aec7f0c] check-in: [1996bacf] user: drh branch: trunk, size: 92848
00:41
First code for the ANALYZE command. Mostly untested. The analysis is not loaded into the symbol tables and is not used by the optimizer. (CVS 2560) file: [50e1197f] check-in: [a4886b11] user: drh branch: trunk, size: 92761
2005-07-21
18:23
Split the OP_Integer opcode into OP_Integer and OP_Int64. This allows comments to be added to OP_Integer. Cleanup in the optimizer. Allow terms of the FROM clause to be reordered automatically. (CVS 2556) file: [c2b9379e] check-in: [e2f822ac] user: drh branch: trunk, size: 92756
03:15
In where.c, split out the code that selects an index into a separate subroutine. (CVS 2554) file: [a908365b] check-in: [c30cbba9] user: drh branch: trunk, size: 92918
2005-06-30
17:04
Allow the DEFAULT value of a column to be obtained by calling a function that has constant arguments, such as julianday('now'). (CVS 2534) file: [1f40c07a] check-in: [d273766e] user: drh branch: trunk, size: 92873
2005-06-25
18:42
Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) file: [f2f12fcb] check-in: [17631785] user: drh branch: trunk, size: 92863
2005-06-24
03:53
NULL values in a row of a unique index cause the row to be distinct. Ticket #1301. More testing and optimization needs to be done on this before closing the ticket. (CVS 2526) file: [3b642059] check-in: [06a71b16] user: drh branch: trunk, size: 92930
2005-06-14
02:12
Do not record existance the sqlite_sequence table until it is actually created. Ticket #1283. (CVS 2513) file: [b6db069e] check-in: [95256d95] user: drh branch: trunk, size: 92671
2005-06-12
21:35
Update older opcode names to be more meaningful in light of the latest code design. (CVS 2506) file: [593d8fda] check-in: [36f2da1f] user: drh branch: trunk, size: 92652
2005-06-06
21:19
Reference count Table structures so that they are not deallocated too soon. Ticket #1210. (CVS 2498) file: [407343b7] check-in: [e73d25c7] user: drh branch: trunk, size: 92655
15:32
Do not allow parameters in VIEW definitions. Ticket #1270. (CVS 2492) file: [bea3107e] check-in: [0d46289f] user: drh branch: trunk, size: 92534
2005-05-25
10:45
Rearrange code so that SSE can invoke the collation factory. (CVS 2482) file: [8c6201bc] check-in: [ea061d2e] user: danielk1977 branch: trunk, size: 92400
2005-05-24
20:19
Remove the config.h file from the build. Ticket #1224. (CVS 2480) file: [b7a5d097] check-in: [3e64f1ab] user: drh branch: trunk, size: 95754
12:01
Move a few things around to make building without the parser easier. (CVS 2479) file: [5d3cee15] check-in: [5fadb464] user: danielk1977 branch: trunk, size: 95786
2005-05-22
06:49
Allow schema objects beginning with sqlite_ to be created if the SQLITE_WriteSchema flag is set. (CVS 2470) file: [6770abc6] check-in: [afc8ce42] user: danielk1977 branch: trunk, size: 98356
2005-05-03
12:30
Make sure all data structures have 8-byte alignment - necessary for the sparc architecture and helpful on other 64-bit platforms. Ticket #1232. Also update some comments in build.c. (CVS 2452) file: [61a0beac] check-in: [d9418851] user: drh branch: trunk, size: 98291
2005-03-29
03:10
Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) file: [8afb06c7] check-in: [c41d5544] user: danielk1977 branch: trunk, size: 98211
2005-03-28
03:39
Fix some memory leaks that occur after a malloc failure. (CVS 2421) file: [2589c2ff] check-in: [bcb5d72e] user: drh branch: trunk, size: 98024
2005-03-21
03:53
Assorted fixes to the handling of various malloc() failures. (CVS 2413) file: [2dc89aa3] check-in: [e7844a01] user: danielk1977 branch: trunk, size: 98001
2005-03-19
01:41
Updates to comments and documentation. No changes to code. (CVS 2398) file: [3c0f4394] check-in: [e53c7726] user: drh branch: trunk, size: 97981
2005-03-17
05:03
Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) file: [a5688630] check-in: [94185dd4] user: danielk1977 branch: trunk, size: 97989
2005-03-16
12:15
Fix some memory leaks that can occur if a memory allocation fails. (CVS 2388) file: [66bf13d2] check-in: [9a358fc3] user: danielk1977 branch: trunk, size: 97554
2005-02-19
08:18
Support for a future file format that includes 'short' records. (CVS 2351) file: [a8792b2f] check-in: [173aeb25] user: danielk1977 branch: trunk, size: 97169
2005-02-15
20:47
Split the logic for the ALTER TABLE command off into a separate source code file. (CVS 2342) file: [7db7f593] check-in: [90d6573c] user: drh branch: trunk, size: 97034
2005-02-14
20:48
Make sure that when a CREATE INDEX fails, it does not leave a residue behind that can corrupt the database. Ticket #1115. (CVS 2330) file: [09333b60] check-in: [cbed92f3] user: drh branch: trunk, size: 102447
2005-02-09
07:05
Return SQLITE_BUSY if the database is locked reading the schema within sqlite_prepare(). Ticket #1106. (CVS 2322) file: [9783b4bd] check-in: [c33c02d6] user: danielk1977 branch: trunk, size: 102455
2005-02-01
03:46
Fix an error introduced with (2299). (CVS 2301) file: [fcb437bc] check-in: [22041d5f] user: danielk1977 branch: trunk, size: 102427
03:09
Avoid allocating a vdbe in sqlite3FinishCoding() if one has not been allocated already. (CVS 2299) file: [7b9427a2] check-in: [eaf1866e] user: danielk1977 branch: trunk, size: 102389
02:13
Change to sqlite3AffinityType() to remove hex constants. (CVS 2298) file: [321c80de] check-in: [d8b4b0ef] user: danielk1977 branch: trunk, size: 102357
01:21
Replace sqlite3AffinityType() with a slightly faster version. (CVS 2296) file: [7e50cb57] check-in: [abe9f5e8] user: danielk1977 branch: trunk, size: 102236
2005-01-31
23:45
Performance tweaks for sqlite3AffinityType. (CVS 2295) file: [c09954eb] check-in: [32b92615] user: drh branch: trunk, size: 101720
12:56
Move sqlite3HashNoCase to hash.c. (CVS 2294) file: [34e6ed5c] check-in: [5c10ccd8] user: danielk1977 branch: trunk, size: 101761
12:42
Assorted minor changes to speed up loading the database schema. (CVS 2293) file: [3eae8b0e] check-in: [dfbd684a] user: danielk1977 branch: trunk, size: 101762
2005-01-29
08:32
Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) file: [e35b7f93] check-in: [b1b50f31] user: danielk1977 branch: trunk, size: 101294
2005-01-27
00:33
Fix a warning introduced by (2280). (CVS 2283) file: [c894a912] check-in: [dc1b8106] user: danielk1977 branch: trunk, size: 101349
00:22
Have REINDEX handle missing collation sequences correctly. (CVS 2280) file: [7fceb519] check-in: [1c1904f4] user: danielk1977 branch: trunk, size: 101351
2005-01-24
10:25
Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) file: [91e05a3a] check-in: [d5233e07] user: danielk1977 branch: trunk, size: 100920
2005-01-21
11:55
Improve test coverage for minimum feature builds. (CVS 2254) file: [b60b1f1f] check-in: [9c4d0e13] user: danielk1977 branch: trunk, size: 100529
00:44
Change the implementation of ALTER TABLE so that it does not use the IN() operattor. (CVS 2249) file: [9c9e9dbb] check-in: [06887afb] user: danielk1977 branch: trunk, size: 100177
2005-01-19
23:24
Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) file: [da5ecd98] check-in: [d8b2a7e0] user: drh branch: trunk, size: 100140
2005-01-18
14:45
Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) file: [608ea54a] check-in: [88d4834f] user: drh branch: trunk, size: 100135
04:00
Refinements to the name resolution logic. Change the name of the keywordhash.c file to keywordhash.h. (CVS 2229) file: [4b7a2c30] check-in: [0142ae6f] user: drh branch: trunk, size: 99871
2005-01-17
22:08
Infrastructure changes to handle name resolution differently. This is needed to fix various long-standing problems with column names in joins. It will also make the implementation of correlated subqueries easier. (CVS 2228) file: [4638b87f] check-in: [4a753439] user: drh branch: trunk, size: 99873
07:53
Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) file: [07d50fe1] check-in: [62442529] user: danielk1977 branch: trunk, size: 99871
2004-12-14
03:34
Minor code and comment cleanup. (CVS 2165) file: [af1296e8] check-in: [d012628a] user: drh branch: trunk, size: 99838
2004-12-07
12:29
Remove the unused sqlite3_context.isStep element. (CVS 2156) file: [306e49e1] check-in: [7b20f2b7] user: drh branch: trunk, size: 99955
2004-11-23
16:31
Fix a memory leak in ALTER TABLE. (CVS 2149) file: [aa7975d7] check-in: [ba71716c] user: danielk1977 branch: trunk, size: 99962
15:41
Add authorization callbacks for REINDEX. (CVS 2148) file: [cbfb8180] check-in: [9f0d744e] user: danielk1977 branch: trunk, size: 99924
2004-11-22
11:51
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) file: [b62389de] check-in: [53894988] user: danielk1977 branch: trunk, size: 99755
2004-11-20
18:13
Fix segfaults that might occur after a malloc failure. (CVS 2119) file: [c7dd57fd] check-in: [36877448] user: drh branch: trunk, size: 99712
2004-11-19
08:41
Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) file: [a43f3b8f] check-in: [f635b6aa] user: danielk1977 branch: trunk, size: 99434
08:02
Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) file: [81422cd1] check-in: [6e971868] user: danielk1977 branch: trunk, size: 99024
07:07
When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) file: [27897ee3] check-in: [0514107b] user: danielk1977 branch: trunk, size: 98697
05:14
Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) file: [467e9407] check-in: [1fd8e835] user: danielk1977 branch: trunk, size: 98511
2004-11-18
15:44
Handle triggers correctly in ALTER TABLE. (CVS 2111) file: [f295d832] check-in: [c61b7de1] user: danielk1977 branch: trunk, size: 97186
2004-11-13
03:48
Autoincrement is now working and has regression tests. (CVS 2095) file: [a95eb118] check-in: [10c712a2] user: drh branch: trunk, size: 96786
2004-11-12
15:53
Add authorization callbacks to ALTER TABLE. (CVS 2093) file: [45ba4052] check-in: [c4115aa3] user: danielk1977 branch: trunk, size: 96964
13:42
Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) file: [cbd985e9] check-in: [a1b2cc63] user: danielk1977 branch: trunk, size: 96686
03:56
Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) file: [6d1687c6] check-in: [8fde833c] user: drh branch: trunk, size: 94098
2004-11-10
11:55
Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) file: [27e3cc9e] check-in: [8e5c2e5d] user: danielk1977 branch: trunk, size: 93081
2004-11-09
12:44
Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) file: [d623d84f] check-in: [0d27c8ff] user: danielk1977 branch: trunk, size: 93040
2004-11-07
13:01
Reindex tests added and bugs fixed. (CVS 2075) file: [f01c2f9b] check-in: [ad433ec2] user: drh branch: trunk, size: 92859
2004-11-06
00:02
Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) file: [fba59507] check-in: [89b9026a] user: drh branch: trunk, size: 92806
2004-11-05
23:46
First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) file: [154e7a66] check-in: [11dba47e] user: drh branch: trunk, size: 92532
22:18
Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071) file: [e498f958] check-in: [0f81aa5b] user: drh branch: trunk, size: 89180
20:58
Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070) file: [d1234774] check-in: [47d8ebda] user: drh branch: trunk, size: 89642
17:17
Create table now works with sqlite3NestedParse. This changed uncovered a latent bug in xprintf which is also fixed. (CVS 2069) file: [f204aebf] check-in: [b0506bdd] user: drh branch: trunk, size: 89522
09:19
Don't code an OP_Statement within sqlite3NestedParse(). Also a correction to the UPDATE statement used within destroyRootPage(). (CVS 2064) file: [dc8b9ab8] check-in: [fdcc31f0] user: danielk1977 branch: trunk, size: 87430
05:23
Another bug fix from two check-ins ago. (CVS 2062) file: [06a4eb8f] check-in: [c46eef2f] user: drh branch: trunk, size: 87407
05:20
Fix a bug in the previous check-in. (CVS 2061) file: [c0a293ea] check-in: [9d259d48] user: drh branch: trunk, size: 87402
05:10
More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) file: [936fb262] check-in: [ac2d5a60] user: drh branch: trunk, size: 87397
03:56
Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059) file: [b18a5c7c] check-in: [2d302931] user: drh branch: trunk, size: 88577
01:24
Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057) file: [6e00bcc3] check-in: [b0c10334] user: danielk1977 branch: trunk, size: 89250
00:43
Incremental check-in of changes that will ultimately lead to a working autoincrement. (CVS 2056) file: [e72d6f76] check-in: [10c3d883] user: drh branch: trunk, size: 89205
2004-11-04
14:47
All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) file: [1bf89a57] check-in: [158a2d16] user: drh branch: trunk, size: 87797
14:30
Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) file: [89d1ace1] check-in: [1da361fa] user: danielk1977 branch: trunk, size: 87831
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: [bb896c5f] check-in: [be661acf] user: drh branch: trunk, size: 83061
2004-10-06
15:41
Convert many constants to have type "const". (CVS 2006) file: [cb0232e0] check-in: [d790c84c] user: drh branch: trunk, size: 82739
2004-10-05
02:41
Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) file: [73bd4219] check-in: [81ff8107] user: drh branch: trunk, size: 82714
2004-09-30
14:22
Correctly parser column typenames that contain more than one identifier. Ticket #934. (CVS 1990) file: [2ed6d9c2] check-in: [85ad1871] user: drh branch: trunk, size: 83275
2004-09-25
14:39
Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) file: [86318bdc] check-in: [9ef4c24a] user: drh branch: trunk, size: 83285
2004-09-15
13:38
The callback on sqlite3_trace() is invoked the first time sqlite3_step() is called after sqlite3_prepare() or sqlite3_reset(). Ticket #900. (CVS 1960) file: [c5ecf114] check-in: [0cc2f40e] user: drh branch: trunk, size: 83373
2004-09-08
15:09
Always cast 0 to (char*)0 when it is an argument in a varargs function. (CVS 1948) file: [662f4e56] check-in: [a1f53252] user: drh branch: trunk, size: 83361
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: [c6940e4a] check-in: [3ddf5a9d] user: drh branch: trunk, size: 83326
2004-08-31
13:45
Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) file: [35275654] check-in: [8fd65e70] user: drh branch: trunk, size: 83300
2004-08-28
14:53
Correct handling of quoted names in CREATE INDEX. Ticket #869. (CVS 1907) file: [ee790553] check-in: [b01d5665] user: drh branch: version_2, size: 67168
2004-08-21
17:54
Optimizations to the code generator. (CVS 1899) file: [7d93b19d] check-in: [bd6649c5] user: drh branch: trunk, size: 83302
2004-08-18
15:58
Be more agressive about not creating or opening the TEMP database if there are no TEMP tables. (CVS 1891) file: [bad6652b] check-in: [6b2b6b2d] user: drh branch: trunk, size: 83245
02:10
Avoid creating a TEMP database unless it is absolutely necessary. (CVS 1890) file: [2c608a48] check-in: [5914a11c] user: drh branch: trunk, size: 83216
2004-08-08
23:39
Fix problems in the handling of malloc failures. (CVS 1882) file: [951a36b2] check-in: [81d91d14] user: drh branch: trunk, size: 83098
20:22
Make sure the argument to ctype.h macros is always an unsigned character. Ticket #839. (CVS 1881) file: [b6689d0c] check-in: [b0659738] user: drh branch: trunk, size: 82881
2004-07-26
00:31
Various size optimizations. (CVS 1867) file: [d1a2d7a9] check-in: [1186e3ce] user: drh branch: trunk, size: 82788
2004-07-24
17:38
Prepared statements now work with CREATE and DROP. All tests pass. No memory leaks. (CVS 1866) file: [7d298166] check-in: [ebdb661e] user: drh branch: trunk, size: 82807
14:35
Fix more problems with deferred execution of CREATE. Still need to do DROP. There is now a memory leak. (CVS 1865) file: [3075ca2e] check-in: [6db3f122] user: drh branch: trunk, size: 83280
03:30
Progress towards getting prepared statements and CREATE and DROP to play nicely together. Work is incomplete. Some tests are known to fail. (CVS 1864) file: [d1870caf] check-in: [49b99149] user: drh branch: trunk, size: 83402
2004-07-22
01:19
Initial implementation of variable page sizes and the temp_store pragma. (CVS 1843) file: [3a135628] check-in: [4cf6e9db] user: drh branch: trunk, size: 84036
2004-07-20
12:45
Add the '%ifdef' capability to lemon. Other minor changes. (CVS 1836) file: [a4b1e80b] check-in: [522ff721] user: drh branch: trunk, size: 84008
00:50
Fix the handling of indices with quoted names. Ticket #695. (CVS 1830) file: [46760493] check-in: [46730997] user: drh branch: version_2, size: 67170
2004-07-19
17:25
Store schema cookies on the TEMP database. Ticket #807. (CVS 1817) file: [1d9a72ad] check-in: [c6c13dc4] user: drh branch: trunk, size: 84095
2004-06-29
08:59
Fix error reporting path for errors that occur while reading the database schema. (CVS 1757) file: [ecc10d4e] check-in: [157db33e] user: danielk1977 branch: trunk, size: 83963
07:45
Bug-fixes to get the two threadtest C programs working again. (CVS 1756) file: [ea8a3220] check-in: [ffd3312b] user: danielk1977 branch: trunk, size: 83742
2004-06-28
01:11
Fix a bunch of harmless warnings. (CVS 1749) file: [574cdd30] check-in: [fae7c6e0] user: danielk1977 branch: trunk, size: 83469
2004-06-26
14:46
Fold in a 64-bit change that came from the PHP people. (CVS 1743) file: [98466ddf] check-in: [b69b4fe8] user: drh branch: trunk, size: 83420
14:40
Fold in changes submitted by the PHP developers. (CVS 1742) file: [cb1ab5ce] check-in: [a4a25708] user: drh branch: version_2, size: 67172
08:38
Remove the 'nMaster' argument from various pager and btree functions. (CVS 1737) file: [ef9fb5bb] check-in: [4e207209] user: danielk1977 branch: trunk, size: 83440
2004-06-22
13:22
Fix some segfaults that could have occurred after a malloc() failure. (CVS 1661) file: [fc0b5174] check-in: [80151e72] user: drh branch: trunk, size: 83435
12:18
Improve the os_test.c module. (CVS 1657) file: [baed8f54] check-in: [ecdb93d3] user: danielk1977 branch: trunk, size: 83421
2004-06-21
18:14
Fix an uninitialized variable. The variable was harmless, but pedantic error checking in MSVC raised an exception on it. (CVS 1651) file: [ee7548a4] check-in: [afc398c2] user: drh branch: trunk, size: 83409
10:45
Avoid opening a temp table for aggregate queries with no GROUP BY clause. (CVS 1649) file: [ffcd0cd8] check-in: [4d02df63] user: danielk1977 branch: trunk, size: 84027
09:06
Add the OP_Concat8 opcode, similar in concept to OP_String8. (CVS 1648) file: [b1180cfc] check-in: [bbd3e933] user: danielk1977 branch: trunk, size: 83759
2004-06-19
17:33
Make sure VdbeFunc entries are initialized before trying to destroy them. Also, unrelated comment changes in build.c. (CVS 1643) file: [2ed1f14a] check-in: [fc3b3a8f] user: drh branch: trunk, size: 83749
16:06
Omit the DB_Locked and DB_Cookie flags. Other minor cleanup. (CVS 1642) file: [09d8863a] check-in: [01f74b42] user: drh branch: trunk, size: 82638
14:49
Omit the sqlite3VdbeCode() routine. Use sqlite3NameFromToken() more to reduce the amount of code. (CVS 1639) file: [c843ef3d] check-in: [99d0436e] user: drh branch: trunk, size: 83028
09:35
Remove the unused 'next_cookie' mechanism. (CVS 1634) file: [d7827169] check-in: [c94a9759] user: danielk1977 branch: trunk, size: 83398
02:22
Fix for #764. When reloading the schema, load the temp schema last. (CVS 1628) file: [239bd939] check-in: [1f43219a] user: danielk1977 branch: trunk, size: 83444
2004-06-18
06:02
Fix a couple of gcc warnings. (CVS 1615) file: [44057a0a] check-in: [960f55f3] user: danielk1977 branch: trunk, size: 83484
04:24
Optimisation for unicode encoding conversion routines. (CVS 1614) file: [f3f7634d] check-in: [39a415ea] user: danielk1977 branch: trunk, size: 83478
2004-06-17
06:13
Handle conflicting ON CONFLICT clauses in table definitions. (CVS 1611) file: [ed0bff93] check-in: [12e77e75] user: danielk1977 branch: trunk, size: 83233
2004-06-15
16:51
Assorted memory leak fixes. (CVS 1600) file: [19fc5d03] check-in: [07b90f36] user: danielk1977 branch: trunk, size: 82800
2004-06-12
09:25
(1) Modifications to the user-function interface and (2) Internal changes to automatically created indices. (CVS 1575) file: [916a84fa] check-in: [5903f538] user: danielk1977 branch: trunk, size: 82678
00:42
Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572) file: [1943d591] check-in: [9b84f2f4] user: danielk1977 branch: trunk, size: 80472
2004-06-10
14:01
Correctly handle the situation where a collation sequence is available, but not in the preferred encoding. (CVS 1565) file: [b36b62f4] check-in: [49ab4794] user: danielk1977 branch: trunk, size: 80442
10:50
Add the sqlite3_collation_needed() API and fix some error handling cases involving unknown collation sequences. (CVS 1562) file: [4b1a23d9] check-in: [edf069b9] user: danielk1977 branch: trunk, size: 80442
02:16
Change the collation sequence interface to allow collation sequences that use UTF-16 in non-native byte order to be registered. (CVS 1559) file: [5d958f48] check-in: [b8aaa3a2] user: danielk1977 branch: trunk, size: 77954
00:29
Check for schema updates if the parser fails to find a table. More locking test updates. (CVS 1555) file: [9ee41777] check-in: [a2228351] user: drh branch: trunk, size: 74601
2004-06-09
12:30
Fix error reporting when trying to attach a database with a foriegn text encoding. (CVS 1545) file: [4ea78aba] check-in: [beab038c] user: danielk1977 branch: trunk, size: 74522
09:55
Some progress on user-defined collation sequences. (CVS 1544) file: [763cb505] check-in: [c634e71f] user: danielk1977 branch: trunk, size: 74516
00:48
Start all transactions and verify all schema cookies near the beginning of of each vdbe program. (CVS 1543) file: [f720a253] check-in: [10861964] user: drh branch: trunk, size: 74097
2004-06-08
00:02
Remove the third argument from the sqlite3_open() API. (CVS 1540) file: [83303494] check-in: [62e31f39] user: danielk1977 branch: trunk, size: 72686
2004-06-07
10:00
Tables created with the CREATE TABLE <tbl> AS SELECT ... syntax now inherit column declaration types from the SELECT statement. (CVS 1538) file: [e8043747] check-in: [31c1668d] user: danielk1977 branch: trunk, size: 72692
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: [92144f30] check-in: [983221b0] user: danielk1977 branch: trunk, size: 71893
2004-06-03
16:08
Untested updates to support atomic multi-file transactions (CVS 1526) file: [e12e602f] check-in: [d57e5252] user: danielk1977 branch: trunk, size: 71819
2004-05-31
18:51
Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511) file: [13985630] check-in: [adf7e29f] user: drh branch: trunk, size: 71808
11:51
Use read-only transactions. (CVS 1504) file: [2f791d1d] check-in: [6c100887] user: danielk1977 branch: trunk, size: 71766
10:01
Add read-transactions to the btree and vdbe. The compiler doesn't invoke them yet. (CVS 1502) file: [8fd4c1a7] check-in: [6b43633a] user: danielk1977 branch: trunk, size: 71520
08:55
Remove the <ON CONFLICT> clause from BEGIN (CVS 1501) file: [774193e2] check-in: [9029274b] user: danielk1977 branch: trunk, size: 71516
08:26
Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500) file: [df54499b] check-in: [b8ed812c] user: danielk1977 branch: trunk, size: 71572
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: [fd36c4a6] check-in: [3225de89] user: danielk1977 branch: trunk, size: 72325
10:23
Fix vacuum so that it works with blobs. (CVS 1490) file: [f9782676] check-in: [4feb4b9a] user: danielk1977 branch: trunk, size: 72310
02:37
Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488) file: [ed09cd54] check-in: [4060a37d] user: danielk1977 branch: trunk, size: 72496
2004-05-28
16:00
Factor common code for generating index keys into a procedure. Other speed improvements and bug fixes. (CVS 1487) file: [60ec4b38] check-in: [6661bb5f] user: drh branch: trunk, size: 72926
12:33
Allow CREATE and DROP VIEW on attached databases. (CVS 1485) file: [3d6fd4a9] check-in: [ad879a95] user: danielk1977 branch: trunk, size: 73237
12:11
Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484) file: [ebb67462] check-in: [2fb3708e] user: danielk1977 branch: trunk, size: 73093
11:37
Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483) file: [7ae5b3ef] check-in: [4984a130] user: danielk1977 branch: trunk, size: 72919
2004-05-22
08:09
Store the text encoding in the database (as meta value 4). (CVS 1435) file: [35cbeb43] check-in: [7f00ca58] user: danielk1977 branch: trunk, size: 69215
2004-05-21
13:39
Remove the OP_SetFound opcode and its cousins. (CVS 1430) file: [95969f37] check-in: [5524075e] user: drh branch: trunk, size: 69109
01:29
Sorting bug fixes. Now only 17 tests fail. (CVS 1422) file: [1d71deac] check-in: [0736b7e8] user: drh branch: trunk, size: 69114
2004-05-20
22:16
Add internal support for collating sequences. This breaks 244 tests. (CVS 1420) file: [ec02b35d] check-in: [a6cb09d7] user: drh branch: trunk, size: 69143
12:41
Fix problems with types and the recognition of BLOB as having no affinity. (CVS 1418) file: [7310eb68] check-in: [8411718f] user: drh branch: trunk, size: 67875
12:10
Default type affinity is now NUMERIC. The affinity.html file checked into the doc directory. (CVS 1417) file: [c3e7b98a] check-in: [948307f0] user: drh branch: trunk, size: 67869
2004-05-18
09:58
Fix many problems with manifest types and column affinity. Most things are working now. (CVS 1392) file: [84a9b377] check-in: [a62872aa] user: danielk1977 branch: trunk, size: 67749
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: [ddb0384a] check-in: [202a470f] user: danielk1977 branch: trunk, size: 67706
2004-05-16
11:57
Fix two bugs that were causing lots of tests to fail. (CVS 1386) file: [fd37eda7] check-in: [5cba8a51] user: danielk1977 branch: trunk, size: 67565
11:15
More changes to support the manifest type model. A few things are currently broken. (CVS 1385) file: [6c046390] check-in: [a4af838f] user: danielk1977 branch: trunk, size: 67565
2004-05-14
11:00
Implement type affinity for table and index records (CVS 1375) file: [e93f443a] check-in: [dbfe6e93] user: danielk1977 branch: trunk, size: 67504
2004-05-12
11:24
Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362) file: [f25e4ac9] check-in: [2f16c9ef] user: danielk1977 branch: trunk, size: 67442
2004-05-11
07:11
Remove code dealing with old file formats. (CVS 1354) file: [97d8b3fc] check-in: [dfde1121] user: danielk1977 branch: trunk, size: 67362
06:55
More minor changes to accomadate the new btree. All the select* tests pass now. (CVS 1353) file: [165424ad] check-in: [941d0fdc] user: danielk1977 branch: trunk, size: 67429
2004-05-10
10:34
Change the names of external symbols from sqlite_XXX to sqlite3_XXX. (CVS 1337) file: [8d9965b3] check-in: [ba2ba242] user: danielk1977 branch: trunk, size: 67517
01:17
Change some code that assumes the root-page of sqlite_master is 2 (it is now 1) (CVS 1333) file: [44ee22de] check-in: [37ae528f] user: danielk1977 branch: trunk, size: 67508
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: [21b6645c] check-in: [8af6474c] user: danielk1977 branch: trunk, size: 67498
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: [76fbca30] check-in: [7ace5762] user: drh branch: trunk, size: 67180
2004-02-24
01:04
Make sure BEGIN, COMMIT, and ROLLBACK are really no-ops when preceded by EXPLAIN. Ticket #626. (CVS 1267) file: [c8ab8b46] check-in: [2af1f065] user: drh branch: trunk, size: 67204
2004-02-22
20:05
Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266) file: [85dee2c7] check-in: [51f1e8f7] user: drh branch: trunk, size: 67072
18:56
Code cleanup in build.c. (CVS 1265) file: [dbeef48d] check-in: [9211e14c] user: drh branch: trunk, size: 67511
18:40
Use sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264) file: [160e6233] check-in: [69aac043] user: drh branch: trunk, size: 67838
2004-02-21
13:31
More code cleanup and size reduction. (CVS 1256) file: [f6ef61a2] check-in: [8e3eda2a] user: drh branch: trunk, size: 68735
2004-02-14
23:59
Eliminate obsolete code associated with the older callback functionality. (CVS 1243) file: [e6d71a3b] check-in: [2dbc4593] user: drh branch: trunk, size: 68727
23:05
Eliminate the use of callbacks during schema initialization. (CVS 1242) file: [f8cef53c] check-in: [af5c2be4] user: drh branch: trunk, size: 69775
16:31
The sqlite_exec() function is now implemented using sqlite_compile() and sqlite_step(). This opens up lots of opportunity to remove old code. (CVS 1240) file: [94fdf4d8] check-in: [9771ad1e] user: drh branch: trunk, size: 69796
2004-02-13
16:22
Fix a bug in the query flattener when trying to find the datatype of the rowid of a view. Also fix a problem with sqlite_compile() and authorization failures. (CVS 1236) file: [f25e9830] check-in: [aa0490cc] user: drh branch: trunk, size: 69771
2004-02-12
18:46
Add hooks on each attached database connection for storing auxiliary information. Add the USING clause to ATTACH. (CVS 1232) file: [2a02df79] check-in: [800c11f4] user: drh branch: trunk, size: 69650
2004-02-11
09:46
Refactor the interface to the randomness generator. (CVS 1224) file: [05ee0d69] check-in: [f2bdccf4] user: drh branch: trunk, size: 69453
2004-01-19
04:55
comment typos (CVS 1191) file: [0fdb0ce4] check-in: [de35c36e] user: jplyon branch: trunk, size: 69423
2004-01-16
20:01
Access to free()ed memory problem fixed. Found by electric fence. Only an issue when doing an EXPLAIN of a CREATE INDEX. (CVS 1186) file: [4b95b200] check-in: [6604e5f7] user: drh branch: trunk, size: 69419
2003-12-06
21:43
Always use "(char*)0" to terminate the argument list of sqliteSetString(). This is needed for 64-bit systems that use a 32-bit integer by default. (CVS 1126) file: [a7493c43] check-in: [656c9038] user: drh branch: trunk, size: 69407
2003-11-27
00:48
Disallow temporary indices on persistent tables. (CVS 1122) file: [fede6bfb] check-in: [72bf73b2] user: drh branch: trunk, size: 69288
2003-09-06
22:18
Update Makefile.in for the new vdbeaux.c file. Remove the experimental "sqlite_instantiate()" routine and replace it with "sqlite_bind()" which is more like ODBC and JDBC. (CVS 1095) file: [9def3a3b] check-in: [990bb118] user: drh branch: trunk, size: 69392
2003-08-24
16:38
Fix a bug in the new "pk" column of the table_info pragma that was added by check-in (1081). (CVS 1082) file: [7cdc9526] check-in: [ad7b017a] user: drh branch: trunk, size: 69314
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: [5b379f8b] check-in: [5232b066] user: drh branch: trunk, size: 69314
2003-07-30
12:34
The {quote: SrcList} object was not being expanded correctly by a call to sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by a call to sqliteSrcListDup(). Ticket #416. This check-in fixes that problem by keeping a separate nAlloc field on {quote: SrcList}. A similar change is made to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067) file: [335a4db9] check-in: [da627325] user: drh branch: trunk, size: 69156
2003-07-01
18:13
Make sure indices in ATTACH-ed databases are put into the right hash table. Ticket #354. (CVS 1044) file: [13b6ae48] check-in: [eb458283] user: drh branch: trunk, size: 69032
2003-05-31
16:21
Tighter binding of views, triggers, and indices to their respective databases. Ticket #323. Much more testing needs to be done to the sqliteFix...() routines in attach.c. (CVS 990) file: [936d10b3] check-in: [7202d4f1] user: drh branch: trunk, size: 69019
2003-05-17
19:04
Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) file: [3f5d1798] check-in: [c8c823b0] user: drh branch: trunk, size: 68603
17:35
Fix problems with TEMP indices that lead to corrupt databases. These problems were discovered while working on ticket #317. No sure yet if that ticket is fixed. (CVS 981) file: [95dfb188] check-in: [01398fb7] user: drh branch: trunk, size: 68781
2003-05-02
14:32
VDBE cursors numbers for tables in a join do not have to be consecutive. This is one step on the road to fixing ticket #272. (CVS 947) file: [e24461d4] check-in: [be7aed20] user: drh branch: trunk, size: 68027
2003-05-01
16:56
Correctly create an index that uses an INTEGER PRIMARY KEY as one of columns to be indexed. (CVS 946) file: [d35b7a65] check-in: [6d019e0b] user: drh branch: trunk, size: 68042
2003-04-29
16:20
The sqlite_complete() function should ignore carriage-return characters. (Oops - some unrelated edits also made it into this check-in.) (CVS 942) file: [6312904c] check-in: [c6bf62e4] user: drh branch: trunk, size: 67898
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: [d5a26bae] check-in: [c675a550] user: drh branch: trunk, size: 67614
2003-04-21
18:48
Add support for TEMPORARY triggers. Such triggers can write temporary or permanent tables. (CVS 926) file: [90fc1b15] check-in: [58ddd587] user: drh branch: trunk, size: 67233
2003-04-20
00:00
Update comments. Remove unused field from the Index structure. (CVS 921) file: [66f8ca24] check-in: [7084e050] user: drh branch: trunk, size: 67031
2003-04-17
22:57
Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) file: [6694013c] check-in: [1e5e00fb] user: drh branch: trunk, size: 67050
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: [daed1dac] check-in: [e76787f8] user: drh branch: trunk, size: 65460
2003-04-13
18:26
Support in-memory databases for temp tables (CVS 903) file: [77b910f7] check-in: [96336bff] user: paul branch: trunk, size: 65468
2003-04-06
21:08
Split the implementation of COPY, PRAGMA, and ATTACH into separate source code files. (CVS 902) file: [f0c774c4] check-in: [73359037] user: drh branch: trunk, size: 65453
20:52
Move the implementation of VACUUM into a separate source file. (CVS 901) file: [da21ffe7] check-in: [b123c165] user: drh branch: trunk, size: 87388
2003-04-05
16:56
More testing of ATTACH and DETACH. (CVS 899) file: [8f158c26] check-in: [51f515f2] user: drh branch: trunk, size: 87849
03:42
Begin testing the new ATTACH and DETACH commands. (CVS 898) file: [346e9372] check-in: [7a0f8024] user: drh branch: trunk, size: 86953
2003-03-31
13:36
Minor follow-on changes to the recent ATTACH patch. (CVS 892) file: [81d31f2e] check-in: [e80afe75] user: drh branch: trunk, size: 86759
02:12
Add the sqliteErrorMsg() function and use it to generate error message text during parsing and code generation. This simplifies the code somewhat and makes it easier to handle names with a database prefix. (CVS 891) file: [5ea24a62] check-in: [1d3fc977] user: drh branch: trunk, size: 86622
00:30
The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890) file: [e56df7b1] check-in: [c7c5e927] user: drh branch: trunk, size: 87051
2003-03-30
00:19
Fix a memory leak in triggers and update tests to show the latest error message text. (CVS 886) file: [afe256e2] check-in: [b90d9de3] user: drh branch: trunk, size: 83631
2003-03-27
13:50
Regression tests now work - except for some changes in error message text. The library is now safe to use for experimental work. (CVS 885) file: [0c14b181] check-in: [8a593e9c] user: drh branch: trunk, size: 83481
12:51
Changes to the "sqlite" structure that allow simultaneous operations on multiple database files. Many regession tests pass - but not all of them. Do not use this version except for debugging SQLite itself. (CVS 883) file: [abd5da38] check-in: [d2fb2bb5] user: drh branch: trunk, size: 83458
2003-03-20
01:16
Record the database name in addition to the table name for DELETE, INSERT, and UPDATE statements. (CVS 879) file: [a965338b] check-in: [a5d8fc95] user: drh branch: trunk, size: 82394
2003-03-19
03:14
Modifications to the VDBE to support more than one database file. (CVS 878) file: [be6db117] check-in: [875da9ee] user: drh branch: trunk, size: 81196
2003-03-01
19:45
Get the non-callback API working with the EXPLAIN keyword and for PRAGMAs. Tickets #258 and #257. Update the API documentation on the sqlite_changes() routine to explain how it works with the non-callback API. Ticket #250. (CVS 875) file: [25d5f901] check-in: [620e1065] user: drh branch: trunk, size: 80690
2003-02-26
13:52
Fix a memory leak associated with PRIMARY KEY in a CREATE TABLE statement that fails. Ticket #249. (CVS 1730) file: [02a106e4] check-in: [66158843] user: drh branch: trunk, size: 81072
2003-02-12
14:09
Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) file: [757b1a37] check-in: [792a9e15] user: drh branch: trunk, size: 80969
2003-02-01
13:53
When a CREATE TABLE ... AS SELECT statement fails, make sure the table name is removed from the internal hash tables. Ticket #238. (CVS 858) file: [f1372886] check-in: [65264780] user: drh branch: trunk, size: 79710
2003-01-29
18:46
Better error messages on constraint violations. Additional tests and bug fixes for the callback-free API. (CVS 854) file: [6e031008] check-in: [ccc82f1a] user: drh branch: trunk, size: 79691
2003-01-28
23:13
First code for the new callback-free API. All regression tests pass but the new API is mostly untested and is unlikely to work. (CVS 852) file: [1a4c0d71] check-in: [065fa818] user: drh branch: trunk, size: 79571
2003-01-25
14:34
Remove an unused variable. (CVS 848) file: [d6716dae] check-in: [18f4ffaa] user: drh branch: trunk, size: 78998
2003-01-18
20:11
Fix datatype reporting and collating sequence selection so that it works correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839) file: [0454fd02] check-in: [71cc292d] user: drh branch: trunk, size: 79031
2003-01-14
02:54
Fix a memory leak in the PRAGMA authorization code. (CVS 833) file: [3bf5d104] check-in: [ba58979f] user: drh branch: trunk, size: 79216
02:49
More tests of the sqlite_set_authorizer() API together with fixes for bugs that the new tests uncovered. (CVS 832) file: [e107e7b8] check-in: [cc2ae781] user: drh branch: trunk, size: 79160
2003-01-13
23:27
Revise the sqlite_set_authorizer API to provide more detailed information about the SQL statement being authorized. Only partially tested so far. (CVS 830) file: [94cd4ed1] check-in: [45de93f9] user: drh branch: trunk, size: 78888
2003-01-12
18:02
Initial check-in of the code for the new sqlite_set_authorizer() API function. The code is mostly untested at this point. (CVS 827) file: [3136d7fc] check-in: [52d5007f] user: drh branch: trunk, size: 77308
2003-01-11
13:30
Remove the ColumnCount opcode, which had become a no-op. (CVS 821) file: [f355fa02] check-in: [86deb12d] user: drh branch: trunk, size: 76504
2003-01-02
14:43
Code optimizations to help the library run faster. (CVS 808) file: [8569ac01] check-in: [db745e87] user: drh branch: trunk, size: 76883
2002-12-03
02:22
Honor ORDER BY clauses in VIEWs. Ticket #193. (CVS 792) file: [415dce88] check-in: [dbf78932] user: drh branch: trunk, size: 76877
2002-12-02
04:25
Change to the pager to avoid opening journal files unnecessarily. This can sometimes results in a significant speed improvement. (CVS 791) file: [ede69254] check-in: [fa5c0425] user: drh branch: trunk, size: 77023
2002-10-20
16:00
The "table_info" pragma reports unspecified column types as "numeric" instead of "text". Fix for ticket #174. (CVS 767) file: [1559232f] check-in: [395ab5fa] user: drh branch: trunk, size: 77044
2002-09-25
19:04
Bug fix: When multiple SQL statements were passed into a single sqlite_exec() call, execution speed would decrease for each statement executed because VDBE cursors were not being reused. Now the cursors are reused and execution time is linear. (CVS 754) file: [37e19378] check-in: [b0d27a37] user: drh branch: trunk, size: 77020
2002-09-21
15:57
Make sure memory malloced() for structures is aligned on an even byte boundry. Solaris segfaults otherwise. (CVS 753) file: [84f397a6] check-in: [14ebe30b] user: drh branch: trunk, size: 76940
2002-09-14
13:47
Do not put a write lock on the main database file when writing to a temporary table. (CVS 750) file: [d41b8da6] check-in: [3f253afe] user: drh branch: trunk, size: 76935
2002-08-31
18:53
Parse foreign key constraints and populate internal data structures appropriately. Constraints are still not enforced. (CVS 738) file: [0116afe4] check-in: [170711ca] user: drh branch: trunk, size: 76524
2002-08-24
18:24
Change the way token memory is allocated in an effort to fix ticket #136. There is now a memory leak when using views of views. (CVS 725) file: [b367b4a8] check-in: [22d8726e] user: drh branch: trunk, size: 71199
2002-08-18
20:28
Fix for ticket #110: return an error if trying to start a transaction within a transaction or when attempting to commit or rollback outside of a transaction. (CVS 721) file: [d8ce4507] check-in: [df51cb16] user: drh branch: trunk, size: 70893
2002-08-15
01:26
Fixes and test improvements resulting from code coverage testing. (CVS 716) file: [35d7ec1e] check-in: [66a0f6a8] user: drh branch: trunk, size: 70513
2002-08-02
10:36
Remove the restriction that a transaction cannot be started by one linuxthread and continued by another. Leave in the documentation the warning about not carrying a database connection across fork() but do not test for it any more. Ticket #130. (CVS 701) file: [0d661e65] check-in: [bdbdb866] user: drh branch: trunk, size: 70409
2002-07-18
00:34
Fix for ticket #107: Fix a design defect in indices that was causing queries to fail when using an index on a column containing an empty string. This fix is an incompatible file-format change. (CVS 681) file: [2f81c837] check-in: [20d152fc] user: drh branch: trunk, size: 70442
2002-07-13
17:23
Partial fix for ticket #96: Return SQLITE_MISUSE from sqlite_exec() if called from a child process with an active transaction that was started in the parent. (CVS 675) file: [81d0f42a] check-in: [72a609ec] user: drh branch: trunk, size: 70442
03:11
Fix for ticket #95: Do not allow automatically created indices (associated with UNIQUE or PRIMARY KEY constraints) to be dropped. (CVS 671) file: [58ce73da] check-in: [0603eb74] user: drh branch: trunk, size: 70409
2002-07-11
12:18
Turn of the reporting of datatypes in the 4th callback argument unless the SHOW_DATATYPES pragma is ON. Eliminate the NULL pointer that used to separate the beginning of datatypes from the end of column names so that the callback can test to see whether or not datatypes are provided. This is an incompatible changes, but since the prior behavior was never documented, we will let it in. (CVS 670) file: [d8318cd8] check-in: [b9872724] user: drh branch: trunk, size: 70187
2002-07-08
22:03
Add support for TEMPORARY views. The code is here but it is mostly untested. (CVS 668) file: [e5a3e6bc] check-in: [87cd10c1] user: drh branch: trunk, size: 70001
2002-07-05
21:42
All the code is now in place for SQLite to distinguish between NUMERIC and TEXT datatypes. Still need to turn on the new code and test it. (CVS 659) file: [ea4a3bc1] check-in: [b4737a16] user: drh branch: trunk, size: 69943
2002-06-28
12:18
Additional test cases added. The following bug fixed: A segfault was occurring if a VIEW consisted of a join with a USING clause. (CVS 651) file: [0834185c] check-in: [96515b81] user: drh branch: trunk, size: 68577
2002-06-25
13:16
Enhance the INTEGRITY_CHECK pragma to test the auxiliary database file in addition to the main database file. (CVS 642) file: [c288c242] check-in: [52eba4de] user: drh branch: trunk, size: 68425
01:09
Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) file: [846eb3ee] check-in: [9c1432bf] user: drh branch: trunk, size: 68049
2002-06-20
11:36
This patch contains the beginnings of the data-typing infrastructure. The new build-in TypeOf() function is added. New opcodes for doing pure text comparisons are added. Most changes are disabled pending the 2.6.0 release. (CVS 632) file: [95eac6ce] check-in: [cbbc858d] user: drh branch: trunk, size: 73330
2002-06-17
17:07
Add preliminary logic for the eventual move to having separate TEXT and NUMTEXT datatypes. Also change the version number to 2.5.0 in preparation for an interim release. (CVS 625) file: [f4633493] check-in: [05783a9d] user: drh branch: trunk, size: 72684
2002-05-24
20:31
Initial implementation of LEFT OUTER JOIN including the expanded SQL92 join syntax. The basic functionality is there but there is still a lot of testing to do. (CVS 587) file: [36e42718] check-in: [99bd1f5b] user: drh branch: trunk, size: 71708
02:04
Split the IdList structure into IdList and SrcList. SrcList is used to represent a FROM clause and IdList is used for everything else. This change allows SrcList to grow to support outer joins without burdening the other uses of IdList. (CVS 584) file: [48bb3066] check-in: [a167b71d] user: drh branch: trunk, size: 71408
2002-05-22
21:27
Fix for ticket #46: Report an error if a CREATE TABLE contains two or more columns with the same name. (CVS 578) file: [d88ad651] check-in: [ba1953ab] user: drh branch: trunk, size: 70151
2002-05-21
11:38
Additional code cleanup resulting from a review of the new trigger code. (CVS 572) file: [f5aa02e4] check-in: [37dbdd55] user: drh branch: trunk, size: 69905
2002-05-19
23:43
Style fixes to triggers code in various *.c files (partial fix to ticket #39) (CVS 571) file: [f6d2f428] check-in: [8a4195c7] user: danielk1977 branch: trunk, size: 70236
2002-05-15
12:45
Beginning to clean up the trigger code. Still lots of work to do. (CVS 566) file: [705ebd99] check-in: [b1034681] user: drh branch: trunk, size: 70228
11:44
Remove all tabs from the beginning of source code lines. Replace tabs with the appropriate number of spaces. (CVS 565) file: [74f19f90] check-in: [690f9a16] user: drh branch: trunk, size: 70198
08:30
Added FOR EACH ROW triggers functionality (CVS 562) file: [cbf1b552] check-in: [794bf67b] user: danielk1977 branch: trunk, size: 70084
2002-05-08
21:30
Fix for ticket #34: VIEWs ignore their ORDER BY clause. (CVS 556) file: [6a506450] check-in: [5f22d215] user: drh branch: trunk, size: 67715
2002-03-06
22:01
Added the default_cache_size and default_synchronous pragmas. Added additional tests for pragmas. Added a new speedtest script. (CVS 421) file: [d01b81f4] check-in: [161c0c5f] user: drh branch: trunk, size: 67568
2002-03-05
01:11
Add the ability to turn of calls to fsync() using the "synchronous" pragma. Increased the default cache size from 100 to 2000 and made the "cache_size" pragma persistent. (CVS 418) file: [0f3c6b64] check-in: [414da4af] user: drh branch: trunk, size: 62598
2002-03-04
02:26
Updates to the documentation. Changed version number to 2.4.0-beta1 (CVS 417) file: [e11b0daa] check-in: [36a8fe0a] user: drh branch: trunk, size: 60657
2002-03-03
23:06
More bugs fixed for views. (CVS 416) file: [5b91d41c] check-in: [81307762] user: drh branch: trunk, size: 60947
18:59
VIEWs are bound to tables when they are used, not when they are first entered. This works around the problem of what to do if a table is deleted that a view refers to. (CVS 415) file: [7c65eeab] check-in: [6121e5ab] user: drh branch: trunk, size: 60227
2002-03-02
17:04
Subquery flattening is implemented and passes all regression tests. We still need to add addition tests to the suite to further exercise the flattener, however. (CVS 408) file: [2f6d3136] check-in: [d5d3e79c] user: drh branch: trunk, size: 57285
2002-02-27
01:47
Bug fixes in the VIEW implementation. (CVS 396) file: [7ada2426] check-in: [668ef638] user: drh branch: trunk, size: 57292
2002-02-23
02:32
Code to implement CREATE VIEW is in place. A quick smoke test shows that it works, but there are probably still many bugs. (CVS 387) file: [1da05178] check-in: [39fed2df] user: drh branch: trunk, size: 57511
2002-02-21
12:01
Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) file: [4e10d8e6] check-in: [b2a9807f] user: drh branch: trunk, size: 58414
2002-02-19
13:39
Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) file: [088acf87] check-in: [c6e9048e] user: drh branch: trunk, size: 57401
2002-02-18
22:49
Bug fix: CREATE TABLE, followed by DROP TABLE within the same transaction is working now. (CVS 378) file: [955a0094] check-in: [553579f9] user: drh branch: trunk, size: 57420
18:30
Add support for CREATE TABLE AS. (CVS 377) file: [6643e708] check-in: [78a50971] user: drh branch: trunk, size: 57428
2002-02-03
17:37
Put in PRAGMA SANITY_CHECK in place of VACUUM. (CVS 365) file: [29504057] check-in: [7c65029e] user: drh branch: trunk, size: 54792
03:34
The VACUUM command now does a database sanity check. (CVS 364) file: [a8851852] check-in: [95d1f838] user: drh branch: trunk, size: 54692
00:56
Five-algorithm conflict resolution appears to be working. (CVS 363) file: [0c7346d0] check-in: [0115518f] user: drh branch: trunk, size: 55063
2002-02-02
18:49
Get the ABORT conflict resolution algorithm working. (CVS 362) file: [397d78ce] check-in: [9be4d4c6] user: drh branch: trunk, size: 55207
2002-01-31
15:54
Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE. This checkin is code only. Documentation and tests are still needed. Also, ABORT is not fully implemented. (CVS 360) file: [f725dc39] check-in: [d0e7cf4a] user: drh branch: trunk, size: 54438
2002-01-30
16:17
Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) file: [78571589] check-in: [cf1538d7] user: drh branch: trunk, size: 54759
2002-01-29
23:07
The new ON CONFLICT logic is in and passes the legacy tests. But the new capabilities have not been tested and are likely broken. (CVS 356) file: [c55881f2] check-in: [ac8a4189] user: drh branch: trunk, size: 54620
18:41
Beginning to insert the infrastructure for ON CONFLICT clauses. (CVS 355) file: [c5023252] check-in: [e00a9ff8] user: drh branch: trunk, size: 54572
2002-01-28
15:53
Bug fix: The IN operator was not working if either side derived from an INTEGER PRIMARY KEY. (CVS 354) file: [3f40a6e6] check-in: [dbcfe198] user: drh branch: trunk, size: 53835
2002-01-22
03:13
The right-hand side of an AS in a SELECT can be used within expressions of the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350) file: [bf8456b5] check-in: [3684beab] user: drh branch: trunk, size: 53817
2002-01-10
14:31
Fix a problem with the way temporary tables mask permanent tables. (CVS 345) file: [d44fbcfa] check-in: [ba89da60] user: drh branch: trunk, size: 54130
2002-01-09
13:30
Continued work on the DROP/CREATE problem. (CVS 343) file: [1acab23d] check-in: [0a3aa99e] user: drh branch: trunk, size: 54070
03:19
Working on a bug: Dropping and recreating a table within a transaction causes an assertion failure. (CVS 342) file: [66195e45] check-in: [b3656a5c] user: drh branch: trunk, size: 53938
2001-12-22
14:49
Bug fixing in the new integer primary key code. (CVS 334) file: [6c01002e] check-in: [29cab124] user: drh branch: trunk, size: 51625
2001-12-21
14:30
Added support for the INTEGER PRIMARY KEY column type. (CVS 333) file: [36b3bf95] check-in: [236a54d2] user: drh branch: trunk, size: 51249
2001-12-15
02:35
Fix a critical bug in the creation of temporary tables. (CVS 327) file: [5127f737] check-in: [96f70741] user: drh branch: trunk, size: 49401
2001-12-05
00:21
Bug fix: sqlite_exec() would sometimes return SQLITE_PROTOCOL when it should have returned SQLITE_BUSY. There was also a deadlock that the previous bug was masking. (CVS 322) file: [83733f96] check-in: [585ed5eb] user: drh branch: trunk, size: 49393
2001-11-22
00:01
Fix a bug in the locking protocol. (CVS 315) file: [2e21d425] check-in: [a9db1c12] user: drh branch: trunk, size: 49395
2001-11-21
02:21
Attempting to add support for 64-bit platforms. (CVS 314) file: [16102331] check-in: [03673adb] user: drh branch: trunk, size: 49201
2001-11-07
16:48
New Next opcode and indexing style implemented. (CVS 304) file: [40b7d144] check-in: [decbeb91] user: drh branch: trunk, size: 49195
14:22
Incremental update. We are in the middle of modifying the index system to support range queries without doing a complete table scan. (CVS 303) file: [b459cbe3] check-in: [e6ca23fa] user: drh branch: trunk, size: 49297
2001-11-06
14:10
Added support for LIMIT. (CVS 302) file: [65438f92] check-in: [17701224] user: drh branch: trunk, size: 49297
2001-10-22
02:58
More changes for 2.0.7. (CVS 293) file: [8857c167] check-in: [f8328a5f] user: drh branch: trunk, size: 49288
2001-10-19
16:44
Version 2.0.6 (CVS 291) file: [d18081e6] check-in: [8467d84f] user: drh branch: trunk, size: 48793
2001-10-15
00:44
Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) file: [fe71d516] check-in: [747bf1b3] user: drh branch: trunk, size: 48597
2001-10-13
02:59
2.0.3 (CVS 287) file: [9c3e3634] check-in: [75e90cf0] user: drh branch: trunk, size: 48416
01:06
Remove the P3 and label arguments from the internal sqliteVdbeAddOp() function. This makes the code easier to read and perhaps smaller as well. (CVS 286) file: [191f9ec9] check-in: [288ef124] user: drh branch: trunk, size: 48383
2001-10-12
17:30
Fix an assertion failure when the disk fills up. Add tests for a full disk situation. (CVS 285) file: [cb3607c8] check-in: [0a7848b6] user: drh branch: trunk, size: 47919
2001-10-09
04:19
Fix the locking protocol. (CVS 280) file: [707f6ef5] check-in: [484b82d8] user: drh branch: trunk, size: 47042
2001-10-08
13:22
Support for temporary tables added. Still need more testing. (CVS 279) file: [55ca22cd] check-in: [9368c62e] user: drh branch: trunk, size: 47042
2001-10-06
16:33
Adding table column query capability to support ODBC. (CVS 278) file: [7cbac6c3] check-in: [b63b3f36] user: drh branch: trunk, size: 42818
2001-09-27
15:11
Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268) file: [64a7325c] check-in: [116fdad0] user: drh branch: trunk, size: 39570
03:22
Added basic support for enforcement of UNIQUE on indices and primary keys. Support for addition constraints is to follow. (CVS 267) file: [501c96f8] check-in: [34c42967] user: drh branch: trunk, size: 40159
2001-09-24
03:12
Tests for inserting lots of data (~64K) into a single row of a table. (CVS 264) file: [6a27cbfa] check-in: [a462c850] user: drh branch: trunk, size: 40026
2001-09-23
19:46
Additional test cases with locking fixes. Also, make the code thread-safe. (CVS 262) file: [17ba9b85] check-in: [bd7d6a64] user: drh branch: trunk, size: 39938
02:35
Fixes to the locking and rollback behavior. (CVS 261) file: [8dbdcce4] check-in: [337b3d3b] user: drh branch: trunk, size: 39936
2001-09-22
18:12
Put in a generic hash table system in place of the various ad-hoc hash table scattered everywhere. Except, the page hash table in the pager is unchanged. (CVS 260) file: [8af632a8] check-in: [9114420d] user: drh branch: trunk, size: 39656
2001-09-17
20:25
Add a new column in the SQLITE_MASTER table to record the root page number of primary key indices. (CVS 252) file: [072d6cf5] check-in: [602ea4f9] user: drh branch: trunk, size: 39723
2001-09-16
00:13
Disclaimed copyright. Preparing for release 2.0. (CVS 250) file: [c311b8d1] check-in: [4e926efe] user: drh branch: trunk, size: 38869
2001-09-15
00:57
Everything is working on Linux. This is release 2.0-Alpha-1. (CVS 246) file: [8359e553] check-in: [14474fa1] user: drh branch: trunk, size: 39344
2001-09-14
18:54
Added a PRAGMA statement. Took out the special comment parsing. (CVS 245) file: [b5c68296] check-in: [5e372460] user: drh branch: trunk, size: 37274
03:24
All tests now pass. But there are still issues. For example, inserts are way too slow. And additional tests are needed for new features. (CVS 243) file: [d639146a] check-in: [e7b65e37] user: drh branch: trunk, size: 35556
2001-09-13
21:53
Many problems fixed. Many problems yet to go. (CVS 242) file: [ebc3ecd5] check-in: [62c7bd11] user: drh branch: trunk, size: 35484
16:18
It runs. Simple tables can be created. INSERT and SELECT work. Much more testing is needed, however. (CVS 241) file: [5839600c] check-in: [9ac8399c] user: drh branch: trunk, size: 34121
14:46
The BTree changes are now integrated and the whole thing compiles and links. I have not yet tried to run it, though. (CVS 239) file: [58020177] check-in: [a0a1e701] user: drh branch: trunk, size: 33443
13:46
The code is in place to replace GDBM with BTree. But I have not yet attempted to compile it. I am sure the code contains bugs. (CVS 238) file: [5a990a29] check-in: [6ecc8b20] user: drh branch: trunk, size: 33496
2001-04-15
00:37
Pager is working, mostly. (CVS 211) file: [4f6a2d55] check-in: [f82fa707] user: drh branch: trunk, size: 30672
2001-04-11
14:28
better handling of out-of-memory errors (CVS 207) file: [6afbb610] check-in: [86b30cd0] user: drh branch: trunk, size: 29947
2001-04-04
11:48
Added transaction support (CVS 196) file: [4c5eede1] check-in: [35a8feed] user: drh branch: trunk, size: 28862
2001-01-15
22:51
continued progress toward version 2.0 (CVS 177) file: [7aa5879b] check-in: [c6ffb7ec] user: drh branch: trunk, size: 27585
2000-10-16
22:06
Added an interrupt capability (CVS 153) file: [e2ceba85] check-in: [f7ea08b9] user: drh branch: trunk, size: 27571
2000-08-03
15:09
bug fix (CVS 123) file: [4d90e9e9] check-in: [4dabf5e4] user: drh branch: trunk, size: 27503
2000-08-02
13:47
file format change (CVS 122) file: [afdbf213] check-in: [b7b90237] user: drh branch: trunk, size: 27510
2000-07-29
13:06
better column labels in select results (CVS 110) file: [ecb8ec72] check-in: [3bf434d9] user: drh branch: trunk, size: 26883
2000-07-28
14:32
added the sqlite_busy_handler() interface (CVS 109) file: [ac2e2383] check-in: [4fe8e51c] user: drh branch: trunk, size: 26496
2000-06-21
13:59
:-) (CVS 104) file: [55edb404] check-in: [e1bf96a4] user: drh branch: trunk, size: 26426
2000-06-17
13:12
:-) (CVS 101) file: [9ce11eaf] check-in: [6ed35a1d] user: drh branch: trunk, size: 26416
2000-06-08
13:36
remove all memory leaks (CVS 80) file: [925a785d] check-in: [bf98cf82] user: drh branch: trunk, size: 26375
2000-06-07
23:51
:-) (CVS 74) file: [5e3b6bab] check-in: [2ffeb850] user: drh branch: trunk, size: 26365
2000-06-05
18:54
:-) (CVS 52) file: [6c9454b2] check-in: [c02268bd] user: drh branch: trunk, size: 26609
2000-06-03
18:06
added default values (CVS 46) file: [15c4f384] check-in: [27c06786] user: drh branch: trunk, size: 26509
2000-06-02
13:27
:-) (CVS 37) file: [44a99167] check-in: [2b55f9b7] user: drh branch: trunk, size: 25887
01:17
:-) (CVS 34) file: [f56c47f0] check-in: [52338f4a] user: drh branch: trunk, size: 25674
2000-05-31
15:34
added aggregate functions like count(*) (CVS 21) file: [03f83e95] check-in: [dee7a8be] user: drh branch: trunk, size: 25674
02:27
:-) (CVS 20) file: [c6b50007] check-in: [01d85b35] user: drh branch: trunk, size: 47980
2000-05-30
19:22
:-) (CVS 18) file: [335df4b6] check-in: [2d41caec] user: drh branch: trunk, size: 46834
17:30
:-) (CVS 16) file: [82e7dfdf] check-in: [b56d1b9c] user: drh branch: trunk, size: 46582
16:27
:-) (CVS 15) file: [971796c0] check-in: [8d66c735] user: drh branch: trunk, size: 46548
13:44
:-) (CVS 14) file: [bc81ec2f] check-in: [1bb8ee8d] user: drh branch: trunk, size: 43659
03:12
:-) (CVS 12) file: [94d1bda1] check-in: [20f2811f] user: drh branch: trunk, size: 43656
00:51
:-) (CVS 11) file: [6c7b4b79] check-in: [9818723e] user: drh branch: trunk, size: 43796
2000-05-29
23:30
:-) (CVS 7) file: [56fd0763] check-in: [fdf4b31a] user: drh branch: trunk, size: 43807
17:44
:-) (CVS 2) file: [45dc9101] check-in: [53841c66] user: drh branch: trunk, size: 43828
14:26
initial check-in of the new version (CVS 1) file: [64016990] check-in: [6f3655f7] user: drh branch: trunk, size: 43806 Added