Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of src/build.c
|
2019-12-07
| ||
| 00:22 | Fix a problem with foreign keys and generated columns discovered by Manuel Rigger. file: [ed6cc3e7] check-in: [27c0fdab] user: drh branch: trunk, size: 168122 | |
|
2019-12-04
| ||
| 03:31 | Fix an incorrect NEVER() macro. file: [66b14837] check-in: [96b6a76d] user: drh branch: trunk, size: 167924 | |
|
2019-11-16
| ||
| 18:36 | Do not allow shadow tables to be dropped in defensive mode. file: [3f917507] check-in: [0a988ce3] user: drh branch: apple-osx, size: 162090 | |
| 14:15 | Do not allow CREATE TABLE or CREATE VIEW of an object with a name that looks like a shadow table name. file: [fe0b0b6d] check-in: [6aef58b6] user: drh branch: defensive-improvements, size: 167842 | |
| 13:51 | Break out the test for writable shadow tables into a separate subroutine. file: [0001fed7] check-in: [8ad34d36] user: drh branch: defensive-improvements, size: 167797 | |
| 12:04 | Do not allow shadow tables to be dropped in defensive mode. file: [8d83d05a] check-in: [70390bbc] user: drh branch: trunk, size: 167559 | |
|
2019-11-02
| ||
| 17:59 | Fix a problem in VIEW creation that was introduced by the generated columns feature. file: [572d85d3] check-in: [9c795c4d] user: drh branch: trunk, size: 167186 | |
|
2019-10-29
| ||
| 03:39 | Tighten the generated column requirement such that every table must have at least one non-generated column. Ticket [166347c6fc994155]. file: [7afa8336] check-in: [4fba090e] user: drh branch: trunk, size: 167168 | |
| 01:26 | Disallow tables that have only virtual columns. file: [c0f279e9] check-in: [59197321] user: drh branch: trunk, size: 167189 | |
|
2019-10-27
| ||
| 22:22 | Improved detection of attempts to use a generated column as part of the primary key. Ticket [91e86951016a6802] file: [8563e547] check-in: [6d1bbba9] user: drh branch: trunk, size: 167016 | |
|
2019-10-26
| ||
| 18:47 | Add support for generated columns. file: [3dea3b75] check-in: [b855acf1] user: drh branch: trunk, size: 166896 | |
| 17:08 | Performance optimization on sqlite3GenerateConstraintChecks() - bypass the loop that checks each column for NOT NULL constraints if it is known in advance that the table has no NOT NULL constraints. file: [2e17f27d] check-in: [e3c3f4d7] user: drh branch: trunk, size: 160533 | |
|
2019-10-24
| ||
| 20:29 | Fix handling of covering indexes that use virtual columns. file: [0c9704f9] check-in: [e0f7e321] user: drh branch: generated-columns, size: 166859 | |
|
2019-10-23
| ||
| 15:47 | Minor adjustments for clarity and test coverage. file: [f7070af6] check-in: [30065716] user: drh branch: generated-columns, size: 166208 | |
| 03:53 | Fix incorrect arguments to testcase() macros. file: [7e4c8359] check-in: [812467fb] user: drh branch: generated-columns, size: 166201 | |
|
2019-10-22
| ||
| 15:45 | Do not allow generated columns in the PRIMARY KEY. file: [27c82247] check-in: [1a54743a] user: drh branch: generated-columns, size: 166201 | |
| 13:59 | In UPDATE processing, include generated columns in the set of columns being updated if and only if their generator expressions reference some other column that is being updated. file: [27471914] check-in: [d38176e9] user: drh branch: generated-columns, size: 165723 | |
| 13:01 | New testcase() macros. Fix a problem with INSERT when the IPK is to the right of generated columns. file: [acf54f35] check-in: [412799fc] user: drh branch: generated-columns, size: 165464 | |
| 12:02 | Merge changes on trunk into the generated-columns branch. file: [c8d76afe] check-in: [ba123b8c] user: drh branch: generated-columns, size: 165308 | |
| 01:00 | Move the sqlite3LocateCollSeq(), sqlite3FindCollSeq(), and sqlite3GetCollSeq() routines so that they are all beside one another in the callback.c source file. No logic changes. file: [0e558ef8] check-in: [9ff80a9b] user: drh branch: trunk, size: 160496 | |
|
2019-10-21
| ||
| 01:04 | Changes to the INSERT logic to make it simpler and faster and so that it works with generated columns and BEFORE triggers. file: [b5eefc5b] check-in: [bc368cb0] user: drh branch: generated-columns, size: 166512 | |
|
2019-10-19
| ||
| 18:47 | Work toward getting generated columns to work with triggers. Still more work to do in this area. file: [c6421066] check-in: [932a3727] user: drh branch: generated-columns, size: 166483 | |
| 13:29 | Refactor names of column index transformation functions, for clarity. Get generated columns working with ALTER TABLE RENAME COLUMN. file: [fb6464e8] check-in: [27ab41c9] user: drh branch: generated-columns, size: 165375 | |
|
2019-10-18
| ||
| 18:33 | Fixes for WITHOUT ROWID tables with VIRTUAL columns and an INTEGER PRIMARY KEY. file: [c38f1b89] check-in: [86074da0] user: drh branch: generated-columns, size: 165147 | |
| 17:42 | Get generated columns working for WITHOUT ROWID tables. file: [1872ee2d] check-in: [9f409649] user: drh branch: generated-columns, size: 165316 | |
| 12:14 | Fix sqlite3ColumnOfIndex() to account for virtual columns. file: [5e5fc50b] check-in: [44727112] user: drh branch: generated-columns, size: 164405 | |
|
2019-10-17
| ||
| 18:35 | In the Table object, change the nVCol field to nNVCol - the number of non-virtual columns, as that is the quantity that we need most. file: [a6424bec] check-in: [4ad66af0] user: drh branch: generated-columns, size: 164191 | |
| 17:54 | Some (but not all) INSERT and UPDATE statements now work for STORED columns. file: [efbcb2e7] check-in: [fe7517bf] user: drh branch: generated-columns, size: 164053 | |
|
2019-10-16
| ||
| 20:05 | ALTER TABLE is able to add a VIRTUAL column. file: [6cb40a36] check-in: [120c6b78] user: drh branch: generated-columns, size: 163877 | |
| 12:18 | Initial experimental code for generated column support. Non-functional. file: [0ed5a7bb] check-in: [11d472c1] user: drh branch: generated-columns, size: 163878 | |
|
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 | |