Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of 497367cb57345dd3
2016-02-15
| ||
17:39 | Merge 3.11.0 changes. (check-in: 631023dd9a user: drh tags: sessions) | |
2016-02-13
| ||
15:08 | Fix another test problem in sessionfault.test. (check-in: f6d1cf7943 user: dan tags: sessions) | |
14:45 | Harden sqlite3session_delete() against trying to delete a session that is not currently on the session list. (check-in: 6c2d34df76 user: drh tags: sessions) | |
14:39 | Fix a problem in sessionfault.test causing it to segfault following a test failure. This commit does not fix the actual test failure - just the subsequent segfault. (check-in: 582b2ae77d user: dan tags: sessions) | |
14:07 | Merge the changes for the 3.11.0 release candidate from trunk. (check-in: 4d7a802e73 user: drh tags: sessions) | |
2016-02-09
| ||
15:44 | Merge enhancements and fixes from trunk. (check-in: f040a5bb62 user: drh tags: sessions) | |
2016-02-05
| ||
14:15 | Merge enhancements from trunk. (check-in: a533608cb0 user: drh tags: sessions) | |
2016-02-02
| ||
02:22 | Merge all recent enhancements from trunk. (check-in: f3f9200115 user: drh tags: sessions) | |
2016-01-21
| ||
17:25 | Disable the RESTRICT foreign key action if "PRAGMA defer_foreign_keys" is set. (Closed-Leaf check-in: 82470d1c3a user: dan tags: disable-restrict) | |
2016-01-20
| ||
16:02 | Merge the LIKE-operator bug fix from trunk. (check-in: 36cb3d6e27 user: drh tags: sessions) | |
11:33 | Merge recent enhancements from trunk. (check-in: 327af5f644 user: drh tags: sessions) | |
2016-01-14
| ||
14:48 | Merge the latest fixes and enhancements from trunk. (check-in: 007e5c6df6 user: drh tags: sessions) | |
2016-01-11
| ||
13:10 | Merge recent enhancements, and especially the WAL overwrite change, from trunk. (check-in: c4a858b228 user: drh tags: sessions) | |
2016-01-06
| ||
15:14 | Merge changes for version 3.10.0. (check-in: fa4705c91f user: drh tags: sessions) | |
2016-01-04
| ||
19:02 | Merge in last-minute patches for the 3.10.0 beta. (check-in: c785cd7813 user: drh tags: sessions) | |
2016-01-01
| ||
13:25 | Merge the latest enhancements from trunk. (check-in: c0be246a74 user: drh tags: sessions) | |
2015-12-16
| ||
19:47 | Merge recent enhancements from trunk. (check-in: f6c9273cab user: drh tags: sessions) | |
2015-12-02
| ||
20:40 | Merge recent enhancements from trunk. (check-in: d1a1278d7f user: drh tags: sessions) | |
2015-11-19
| ||
19:40 | Merge the latest enhancements from trunk. (check-in: 7d6cfc79e7 user: drh tags: sessions) | |
2015-11-07
| ||
01:33 | Merge recent enhancements and bug fixes from trunk. (check-in: 78bc42e664 user: drh tags: sessions) | |
2015-11-02
| ||
18:57 | Merge all recent enhancements and fixes from trunk. (check-in: 0546d1cd1a user: drh tags: sessions) | |
2015-10-30
| ||
16:50 | Merge all the latest enhancements from trunk. (check-in: 395a153ff7 user: drh tags: sessions) | |
2015-10-16
| ||
20:20 | Merge the version 3.9.1 updates. (check-in: 2bbb9595cc user: drh tags: sessions) | |
2015-10-13
| ||
20:42 | Merge in the final few changes before the 3.9.0 release. (check-in: e1afdbb501 user: drh tags: sessions) | |
2015-10-10
| ||
20:35 | Pull in the latest 3.9.0 tweaks from trunk. (check-in: ed174ccf0a user: drh tags: sessions) | |
2015-10-09
| ||
15:29 | Merge the version 3.9.0 changes and the incorporation of JSON1 and FTS5 into the amalgamation from trunk. (check-in: c1d96fb654 user: drh tags: sessions) | |
2015-10-08
| ||
14:55 | Merge the 3.8.12 beta changes from trunk. (check-in: 35b1b8d4b9 user: drh tags: sessions) | |
2015-10-01
| ||
16:35 | Changes to the sesssions module ensure that tables appear within changesets and patchsets in the same order that they were attached to the sessions object. (check-in: 7695890230 user: dan tags: sessions) | |
2015-09-30
| ||
14:50 | Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. (check-in: b2face9aa9 user: drh tags: sessions) | |
2015-09-24
| ||
14:26 | Merge all the latest trunk enhancements into the sessions branch. (check-in: c91065f8ed user: drh tags: sessions) | |
2015-09-15
| ||
15:55 | Merge the latest trunk enhancements with this branch. (check-in: b7469c44be user: dan tags: sessions) | |
2015-09-14
| ||
10:47 | Merge the latest trunk enhancements. (check-in: 22ce9218fb user: drh tags: sessions) | |
2015-09-03
| ||
14:48 | Merge recent trunk enhancements. (check-in: 6a513c0585 user: drh tags: sessions) | |
2015-09-01
| ||
18:52 | Merge recent enhancements from trunk. (check-in: cb77236673 user: drh tags: sessions) | |
2015-08-20
| ||
23:54 | Merge recent trunk enhancements, include table-valued functions. (check-in: e9196d5666 user: drh tags: sessions) | |
2015-07-24
| ||
22:21 | Merge test improvements and minor fixes from trunk. (check-in: 0298a9a780 user: drh tags: sessions) | |
2015-07-23
| ||
21:59 | Merge all changes in the latest 3.8.11 beta into the sessions branch. Changes include the rename of OTA to RBU, the WITHOUT-ROWID-OR-Skipscan fix, and improvements to pcache1. (check-in: 7f0ee77062 user: drh tags: sessions) | |
2015-07-14
| ||
15:39 | Merge trunk changes, including the addition of FTS5 and pcache1 performance enhancements. (check-in: db4cbefb86 user: drh tags: sessions) | |
2015-07-02
| ||
18:47 | Merge in the latest enhancements from trunks, especially the use of _byteswap_ulong() and similar intrinsics on MSVC. (check-in: 85ca4409bd user: drh tags: sessions) | |
2015-06-30
| ||
16:29 | Merge all the latest enhancements from trunk. This merge include FTS5 and a number of notable performance enhancements. (check-in: 39936b33b0 user: drh tags: sessions) | |
2015-06-25
| ||
15:44 | Merge all the latest enhancements from trunk. (check-in: 924f471291 user: drh tags: sessions) | |
2015-06-17
| ||
18:18 | Merge all recent enhancements and fixes from trunk. (check-in: 199bfb67fd user: drh tags: sessions) | |
2015-06-11
| ||
18:01 | Merge recent trunk enhancements and fixes. (check-in: c39cb0e257 user: drh tags: sessions) | |
17:26 | Add the sqlite3changegroup_xxx() APIs to the sessions module. For combining multiple changesets or patchsets. (check-in: 0c1a901cd6 user: dan tags: sessions) | |
2015-06-02
| ||
09:20 | Add the "finish_test" command to the end of new test script sessionE.test. (check-in: fb39140707 user: dan tags: sessions) | |
09:19 | Modify the sessions module to ignore all operations on tables with no primary keys as documented. (check-in: bdaf9575cd user: dan tags: sessions) | |
2015-05-29
| ||
19:04 | Import recent enhancements from trunk. (check-in: 54bec164eb user: drh tags: sessions) | |
2015-05-22
| ||
23:51 | Merge bug fixes from trunk. (check-in: 519054bb72 user: drh tags: sessions) | |
23:26 | Merge enhancements from trunk, including the new sqlite3_value_dup() API and the addition of the apSqlParam field in the sqlite3_rtree_query_info object of R-Tree. (check-in: cdc0ca6fb3 user: drh tags: sessions) | |
2015-05-21
| ||
20:26 | Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". drh added later: All changes on this branch have been cherrypicked to trunk and will be merged into sessions from trunk. So this branch can close. (Closed-Leaf check-in: b9e45596d8 user: dan tags: sessions-value-dup) | |
2015-05-20
| ||
22:01 | Add the sqlite3_value_dup() and sqlite3_value_free() interfaces and use those to add the sqlite3_rtree_query_info.apSqlParam field to the query callback in R-Tree. (check-in: 2007391cec user: drh tags: sessions-value-dup) | |
2015-05-19
| ||
23:04 | Merge the Makefile.msc fix and the compiler warning fix from trunk. Also fix another compiler warning in sqlite3session_diff(). (check-in: 7530e1bf55 user: drh tags: sessions) | |
22:42 | Merge recent trunk changes, include the R-Tree enhancement that allows 8-byte BLOB arguments to geometry functions, and the fix for the TEXT affinity problem that could cause corrupt indexes. (check-in: 0a0de8b72c user: drh tags: sessions) | |
2015-05-14
| ||
15:17 | Merge in the IS-operator enhancements and other recent changes from trunk. (check-in: 4f9229445c user: drh tags: sessions) | |
2015-05-07
| ||
12:29 | Merge in the 3.8.10 release changes. (check-in: 0404ef885e user: drh tags: sessions) | |
2015-05-05
| ||
17:12 | Merge all trunk enhancements and fixes into the sessions branch. (check-in: de7083cfe2 user: drh tags: sessions) | |
2015-04-23
| ||
17:22 | Modify the sqlite3session_diff() API so that tables with no PRIMARY KEYs are ignored. This matches the other sessions APIs. Also change sqlite3session_diff() so that it returns SQLITE_SCHEMA, instead of SQLITE_ERROR, if the tables being compared do not have compatible schemas. (check-in: aada0ad08e user: dan tags: sessions) | |
15:03 | Fix the error message returned by sqlite3session_diff() for tables with no PRIMARY KEY. (check-in: 4d34a3d40d user: dan tags: sessions) | |
14:40 | Fix a performance problem in sqlite3session_diff(). (check-in: ea400eca31 user: dan tags: sessions) | |
13:49 | Merge the latest trunk enhancements and fixes into the sessions branch. (check-in: 4e5f17d189 user: drh tags: sessions) | |
2015-04-20
| ||
01:32 | Merge all recent trunk enhancements and fixes into the sessions branch. (check-in: b8ef1cdee3 user: drh tags: sessions) | |
2015-04-17
| ||
11:31 | Hold the database mutex for the duration of sqlite3session_diff(). (check-in: 6f33050115 user: dan tags: sessions) | |
2015-04-16
| ||
13:52 | Fix a stray backslash character in a printf format string in sessionDiffFindModified() (check-in: abb192a1d7 user: drh tags: sessions) | |
2015-04-15
| ||
14:14 | Merge all recent trunk fixes and enhancements into the sessions branch. (check-in: e65e65f9bc user: drh tags: sessions) | |
2015-04-12
| ||
01:33 | Merge all recent trunk enhancements into the sessions branch. (check-in: 5f14f34f07 user: drh tags: sessions) | |
2015-04-11
| ||
17:09 | Merge the sessions-diff branch with this one. (check-in: 805baa57e5 user: dan tags: sessions) | |
2015-04-09
| ||
19:19 | Updates to comments describing the changeset and patchset formats. (check-in: 5342f721e8 user: dan tags: sessions) | |
2015-04-08
| ||
16:43 | Fix problems in the sessions module causing it to produce spurious SQLITE_NOMEM errors when handling SQL text or blob values zero bytes in size. (check-in: b9459d5980 user: dan tags: sessions) | |
16:01 | Add experimental API sqlite3session_diff(). (Closed-Leaf check-in: c4340b2ea2 user: dan tags: sessions-diff) | |
2015-04-07
| ||
23:10 | Merge printf() width and precision overflow fixes from trunk. (check-in: aeca95ac77 user: drh tags: sessions) | |
2015-04-06
| ||
12:08 | Merge obscure problem fixes from trunk. (check-in: 271c110bcf user: drh tags: sessions) | |
2015-04-01
| ||
16:39 | Merge recent enhancements from trunk. (check-in: aea439bdc6 user: drh tags: sessions) | |
2015-03-31
| ||
00:10 | Merge all recent trunk enhancements and fixes into the sessions branch. (check-in: df94e61f93 user: drh tags: sessions) | |
2015-03-24
| ||
19:02 | Merge all recent trunk enhancements into the sessions branch. (check-in: 54aaa6f29a user: drh tags: sessions) | |
2015-03-17
| ||
18:54 | Merge all recent trunk enhancements into the sessions branch. (check-in: 1d1c57c356 user: drh tags: sessions) | |
2015-03-09
| ||
13:07 | Merge recent trunk enhancements into the sessions branch. (check-in: 68c8937e83 user: drh tags: sessions) | |
2015-02-25
| ||
14:02 | Merge the latest trunk fixes into the sessions branch. (check-in: 131a2d3116 user: drh tags: sessions) | |
2015-02-21
| ||
15:13 | Merge all recent trunk changes into the sessions branch. (check-in: f36bb5fa5c user: drh tags: sessions) | |
2015-02-06
| ||
15:40 | Merge all the latest enhancements from trunk. (check-in: ae7eef117f user: drh tags: sessions) | |
2015-01-16
| ||
12:44 | Merge all 3.8.8 changes into the sessions branch. (check-in: bebd131a35 user: drh tags: sessions) | |
2015-01-14
| ||
17:16 | Merge trunk 3.8.8 beta changes into the sessions branch (check-in: 0ba124540b user: drh tags: sessions) | |
2015-01-08
| ||
20:06 | Merge recent enhancements from trunk, including test scripts enhancements and the removal of limits on the number of terms in a VALUES clause. (check-in: 5a2dec55bf user: drh tags: sessions) | |
2014-12-31
| ||
14:27 | Merge the fix to PRAGMA data_version and testing improvements from trunk. (check-in: 86e39123c1 user: drh tags: sessions) | |
2014-12-22
| ||
18:48 | Merge the PRAGMA data_version redefinition and other fixes from trunk. (check-in: 315243e49d user: drh tags: sessions) | |
2014-12-20
| ||
14:58 | Merge the PRAGMA data_version command and the enhancements to FK query planning from trunk into the sessions branch. (check-in: d4f82af0a4 user: drh tags: sessions) | |
2014-12-16
| ||
01:05 | Merge threading fixes from trunk into the sessions branch. (check-in: 9817a2864e user: drh tags: sessions) | |
2014-12-09
| ||
14:54 | Merge the KeyInfo cache mutex fix from trunk. (check-in: f0940c73bd user: drh tags: sessions) | |
2014-12-05
| ||
20:05 | Merge the fix for the shared-cache KeyInfo cache bug from trunk. (check-in: 5a73da6a30 user: drh tags: sessions) | |
00:41 | Import from trunk the fix the "test" target on the autoconf and MSVC makefiles and some minor compiler warning fixes. (check-in: c9f20eb2fb user: drh tags: sessions) | |
2014-12-04
| ||
23:35 | Incorporate the SQLITE_CHECKPOINT_TRUNCATE enhancement and a couple of obscure bug fixes from trunk. (check-in: 34ffa3b3c0 user: drh tags: sessions) | |
2014-12-02
| ||
16:31 | Merge all recent fixes and enhancements from trunk into sessions. (check-in: 2617d93713 user: drh tags: sessions) | |
2014-11-18
| ||
21:20 | Merge recent trunk enhancements, including the read-after-ROLLBACK change and the addition of sqlite3_stmt_scanstatus() support, as well as various minor bug fixes. (check-in: f09055f3c4 user: drh tags: sessions) | |
2014-10-31
| ||
14:53 | Merge recent trunk enhancements, and in particular the improvements to the b-tree balancing logic, into the sessions branch. (check-in: 28b044a512 user: drh tags: sessions) | |
2014-10-17
| ||
11:53 | Merge all version 3.8.7 updates from trunk. (check-in: f4de9e07be user: drh tags: sessions) | |
2014-10-15
| ||
20:02 | Fix a problem causing sqlite3changeset_concat() to fail to detect attempts to concatenate patchsets which changesets. (check-in: 236704a9d1 user: dan tags: sessions) | |
19:37 | Merge latest trunk changes with this branch. (check-in: 1b2824f1d1 user: dan tags: sessions) | |
2014-10-14
| ||
13:41 | Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY bug fix into the sessions branch. (check-in: 83d4114f2a user: drh tags: sessions) | |
2014-10-10
| ||
12:56 | Merge all recent trunk changes. (check-in: abfef25472 user: drh tags: sessions) | |
2014-10-01
| ||
01:52 | Merge the latest enhancements from trunk. (check-in: 2695772c98 user: drh tags: sessions) | |
2014-09-27
| ||
20:45 | Change the names of the stream interface APIs to be of the form "_strm" instead of "_str". In other words, added an "m" to the end, to try to make it clear that we are talking about a "stream" and not a "string. (check-in: 1f44bfdc23 user: drh tags: sessions) | |
19:51 | Merge recent trunk changes (performance enhancements) into the sessions branch. (check-in: 497367cb57 user: drh tags: sessions) | |
18:18 | Fix a segfault in the sessions module that could follow an OOM. (check-in: 09985fa6b6 user: dan tags: sessions) | |
16:33 | Fix a segfault in the streaming API functions triggered by a very long table name. (check-in: d2642543ee user: dan tags: sessions) | |
12:26 | Improve sessions module documentation and comments. Fix some other code issues. (check-in: bfc8bd80f8 user: dan tags: sessions) | |
2014-09-26
| ||
18:30 | Add an assert() to verify the last-row-id for the database just prior to calling a SQL function. (check-in: d026f0c944 user: mistachkin tags: trunk) | |
10:52 | Fix a problem with concatenating patchsets containing DELETE and INSERT operations on the same row. (check-in: 4d8537eafb user: dan tags: sessions) | |
02:41 | Fix the "PRAGMA integrity_check" command so that it avoids formatting error message context messages until it actually needs to generate an error message. This avoids much formatting, and hence greatly improves the performance of "PRAGMA integrity_check" in the common case when there are no errors. It also makes the code a little smaller. (check-in: 8391351583 user: drh tags: trunk) | |
01:10 | If an SQL function makes a recursive call to do an INSERT into the same database, make sure that the last_insert_rowid() for that INSERT is recorded. (check-in: e93aecc090 user: drh tags: trunk) | |
2014-09-25
| ||
20:43 | Add streaming version of sqlite3changeset_concat(). (check-in: 88eb6656bd user: dan tags: sessions) | |
17:42 | Minor code reformatting and comment change, to improve clarity. No logic changes. (check-in: baeb72a356 user: drh tags: trunk) | |
14:54 | Add streaming version of sqlite3changeset_invert() to sessions module. (check-in: 8ded6a4679 user: dan tags: sessions) | |
13:17 | Simplifications to the SQL function and aggregate calling procedures. (check-in: 3467049a17 user: drh tags: trunk) | |
12:31 | Simplification to the random rowid picking logic that begins running when the maximum possible rowid has already been used. (check-in: 1330c72e17 user: drh tags: trunk) | |
11:08 | Still more performance enhancements to the LIKE and GLOB operators. (check-in: 6c8924cacc user: drh tags: trunk) | |
03:51 | More performance optimization for the LIKE and GLOB operators. (check-in: 5ab1023d6c user: drh tags: trunk) | |
02:44 | Change that might allow SQLite to build and work using the EBCDIC character set. (check-in: ef30e0352b user: drh tags: trunk) | |
00:56 | Size reduction and performance improvement in the LIKE and GLOB operators. (check-in: b2c89ef49c user: drh tags: trunk) | |
2014-09-24
| ||
19:47 | Have each open database allocate its pTmpSpace when the first write cursor is opened, rather than on each insert or delete, for a small space savings and performance boost. (check-in: 99323552c0 user: drh tags: trunk) | |
18:31 | Small performance and size optimization for btreeUnlockIfUnused(). (check-in: 13c746f85d user: drh tags: trunk) | |
17:13 | Add streaming version of sqlite3changeset_apply(). Tests and fixes for the same and sqlite3changeset_start_str(). (check-in: b917fc1468 user: dan tags: sessions) | |
13:20 | Do not allow parameters in a DEFAULT clause of a CREATE TABLE statement. Ticket [78c0c8c3c9f7c1]. (check-in: 1ad2bc1ed4 user: drh tags: trunk) | |
02:05 | Have the clearCell() routine return the cell size to the caller, rather than have the caller make a separate call to cellSizePtr(). (check-in: f21d217583 user: drh tags: trunk) | |
01:23 | Shorten all lines of source code in btree.c to at most 80 characters. No logical changes. (check-in: 5dd41cdbfe user: drh tags: trunk) | |
00:59 | Add the MemPage.noPayload boolean and use it to help cellSizePtr() and btreeParseCellPtr() run faster. (check-in: 8e3375313e user: drh tags: trunk) | |
2014-09-23
| ||
23:12 | Remove an unused C-preprocessor macro. No functional changes to the code. (check-in: f480582cca user: drh tags: trunk) | |
22:36 | Avoid calling btreeParseCellPtr() from within fillInCell() since most of what btreeParseCellPtr() computes is ignored by fillInCell(). Instead, have fillInCell() compute the values it needs inline. Performance improvement. (check-in: 4147f6671e user: drh tags: trunk) | |
21:25 | Simplify the CellInfo structure for a size reduction and performance improvement. (check-in: bf59df66b3 user: drh tags: trunk) | |
20:39 | Begin adding 'streaming' APIs to sessions module. This is a work in progress. (check-in: 3c7d3d950b user: dan tags: sessions) | |
18:30 | Add the "multiplex_truncate" PRAGMA to the multiplexor extension, for querying and setting the truncate flag on a database connection. (check-in: d2962a5f38 user: drh tags: trunk) | |
01:40 | Adjust skip-scan cost estimates slightly so that a full table scan is preferred over a skip-scan to a column with only two distinct values. (check-in: ae9a42b268 user: drh tags: trunk) | |
2014-09-22
| ||
20:38 | Fix to payload size overflow detection in the cellSizePtr() change of the previous check-in. (check-in: 7609744014 user: drh tags: trunk) | |
19:51 | Size reduction and substantial performance increase for cellSizePtr(). (check-in: bc8bbf3207 user: drh tags: trunk) | |
14:30 | Tune the query planner to be more aggressive about using automatic indexes on views and subqueries for which there is not opportunity to declare a persistent schema index. (check-in: 41de1643bf user: drh tags: trunk) | |
03:22 | Disable shared memory operations using the unix-nolock VFS. (check-in: 10a6e51049 user: drh tags: trunk) | |
2014-09-21
| ||
22:49 | Merge all recent trunk changes into the sessions branch. (check-in: 6406b77f2c user: drh tags: sessions) | |
22:31 | Correctly handle an ORDER BY clause on an outer query when applying the compound-subquery flattening optimization. Ticket [d11a6e908f]. Also add the SQLITE_ENABLE_SELECTTRACE option for additional debugging and analysis information about select statement processing. (check-in: d5880abd63 user: drh tags: trunk) | |
20:31 | Add test cases for ticket [d11a6e908f]. (Closed-Leaf check-in: 9683e001ed user: drh tags: select-trace) | |
17:51 | Add the "showauth" extension in ext/misc. (check-in: 28d52c1c38 user: drh tags: select-trace) | |
00:27 | Improved ".selecttrace" output. (check-in: c0b61f7092 user: drh tags: select-trace) | |
2014-09-20
| ||
20:38 | Candidate fix for [d11a6e908f]. (check-in: 89398880bc user: dan tags: select-trace) | |
20:24 | Fix the SELECTTRACE_ENABLE macro so that it doesn't cause problems for testfixture. Add new SELECTTRACE() calls. (check-in: f1ba68f131 user: drh tags: select-trace) | |
18:18 | Enable SELECT query planning tracing when compiled with SQLITE_ENABLE_SELECTTRACE and either SQLITE_DEBUG or SQLITE_TEST. (check-in: cbe0cf9ddf user: drh tags: select-trace) | |
00:35 | Fix the usage of the _GNU_SOURCE and _BSD_SOURCE macros in the main internal header file, sqliteInt.h. Set HAVE_STRCHRNUL to 1 by default on Linux only. (check-in: 59e2c9df02 user: drh tags: trunk) | |
00:29 | Only enable HAVE_STRCHRNUL by default on linux, as that is the only place it appears to work by default. (Closed-Leaf check-in: 0fac2c045f user: drh tags: sqliteIntMacros) | |
00:02 | Revise macro usage in 'sqliteInt.h'. (check-in: 35db3e2f35 user: mistachkin tags: sqliteIntMacros) | |
2014-09-19
| ||
22:44 | Simplify two conditionals and add testcase() macros to the affinity transform logic in the comparison operators. (check-in: 544664cadf user: drh tags: trunk) | |
22:30 | Recognize the invariant that a Mem object cannot be MEM_Dyn and have a non-zero szMalloc at the same time. Enforce this with assert()s and exploit it in the sqlite3VdbeMemClearAndResize() routine for a performance increase. (check-in: 3b21cf2b28 user: drh tags: trunk) | |
22:01 | Tighten the conditions under which applyNumericAffinity() be called and add assert() statements to prove that it is never called otherwise. (check-in: e996ca32cb user: drh tags: trunk) | |
20:13 | Fix the affinity on inserts into the ANALYZE tables. Change the affinity characters to be upper case, to make the P5 parameter of comparison operators easier to read. (check-in: 3f3ca76aea user: drh tags: trunk) | |
19:43 | Do not attempt to extend the temp file if VFS version 3 is not supported and hence memory mapped I/O is unavailable. (check-in: 3ab20ba14f user: drh tags: trunk) | |
19:00 | Make the "nolock" VFS on unix a version-3 VFS so that the sorter can use memory-mapped I/O. (check-in: 3db78d6100 user: drh tags: trunk) | |
16:56 | Remove a local variable from the OP_Column implementation, resulting in a modest size reduction and a performance increase. (check-in: 6199760d13 user: drh tags: trunk) | |
16:13 | Small size reduction and performance increase for releaseMemArray(). (check-in: 24cd32d681 user: drh tags: trunk) | |
16:02 | Updates to comments. No code changes. (check-in: 9b42c3da6b user: drh tags: trunk) | |
15:28 | The OP_Column opcode runs faster and is smaller by manually in-lining the code that persists string values in the output register. (check-in: 36b613ccf0 user: drh tags: trunk) | |
04:42 | Add the sqlite3VdbeMemClearAndResize() function. Fix a sorting-index prefilter problem. (check-in: 987a7a2119 user: drh tags: trunk) | |
02:01 | Make sure that the sorting-index pre-filter recognizes that a rowid reference might be sortable. This fixes a performance regression. (Closed-Leaf check-in: 72727b68cd user: drh tags: Cplusplus-comment) | |
00:43 | Add the sqlite3VdbeMemClearAndResize() interface to be used in place of sqlite3VdbeMemGrow(). A C++ style comment was left in this check-in by mistake, and so it has been moved into a branch to avoid problems in any future bisects on windows. (check-in: 5b9b898779 user: drh tags: Cplusplus-comment) | |
2014-09-18
| ||
21:25 | Add the Mem.szMalloc element to the Mem object and use it to keep track of the size of the Mem.zMalloc allocation. (check-in: 9c09ac353d user: drh tags: trunk) | |
18:55 | Correct typos in comments. No changes to code. (check-in: 5587993211 user: mistachkin tags: trunk) | |
17:52 | Merge the Mem.r value into the MemValue union as Mem.u.r. Hence, a Mem can now store an integer or a real but not both at the same time. Strings are still stored in a separate element Mem.z, for now. (check-in: 4c8c89d7e6 user: drh tags: trunk) | |
16:28 | Performance improvement for affinity transformations on comparison operators. (check-in: d7afdcbac2 user: drh tags: trunk) | |
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. (check-in: 4ef4c9a7c8 user: drh tags: trunk) | |
09:59 | Modify an assert() within sqlite3PagerWalFramesize(), a function only ever used by zipvfs, to account for recent zipvfs changes. (check-in: 3bd7c1b2fa user: dan tags: trunk) | |
02:20 | Fix harmless warnings on 32-bit MSVC builds. (check-in: 5192f964b2 user: drh tags: trunk) | |
01:50 | Make sure of the strchrnul() library function on platforms where it is available. (check-in: ef1aa10b7f user: drh tags: trunk) | |
01:29 | Merge micro-optimizations into trunk after fixing the build on MSVC. Performance now shows 7.58% faster than the 3.8.6 release on x64 with gcc 4.8.1 and -Os. (check-in: 1de558bcb1 user: drh tags: trunk) | |
01:21 | Fix compiler warnings and change the nullMem structure initializer into a format that MSVC can understand. (Closed-Leaf check-in: 163bfae858 user: drh tags: micro-optimizations) | |
2014-09-17
| ||
23:37 | Performance improvement and slight size reduction to the comparison operators in the VDBE. (check-in: 14052a7d08 user: drh tags: micro-optimizations) | |
16:41 | In the Mem object, stop requiring that Mem.xDel be NULL when the MEM_Dyn bit is clear. Also reduce the amount of initialization of Mem objects. All for a small size reduction and performance increase. (check-in: fdddb477c8 user: drh tags: micro-optimizations) | |
14:52 | Improved interface to the Mem object handling. Small size reduction and performance increase. (check-in: 4e43784432 user: drh tags: micro-optimizations) | |
2014-09-16
| ||
21:54 | Continuing cleanup of memory register memory allocation handling. (check-in: 2598aedc5d user: drh tags: micro-optimizations) | |
20:05 | Make sure registers are cleared properly prior to being used to store the result of an OP_Column operator. (check-in: 78fb8838d8 user: drh tags: micro-optimizations) | |
18:22 | Simplification of the OP_Column logic for the case of rows with overflow. (check-in: f73678038d user: drh tags: micro-optimizations) | |
14:55 | Remove an unused parameter from sqlite3VdbeIdxRowid(). This is cosmetic only as the C-compiler optimizers were already omitting this parameter on amalgamation builds. (check-in: a10a6bba49 user: drh tags: micro-optimizations) | |
14:37 | Reduce the number of arguments to RecordCompare functions from 4 to 3, resulting in a small performance increase. (check-in: 8239c35aed user: drh tags: micro-optimizations) | |
14:16 | Reorder the elements of the Mem object for a small size reduction and performance improvement. Moved into a branch because MSVC is unable to handle named structure initializer on nullMem. (check-in: 0be3019ed7 user: drh tags: micro-optimizations) | |
13:30 | Changes to sqlite3VdbeRecordUnpack() to make it slightly smaller and faster. (check-in: 8fb90da77c user: drh tags: trunk) | |
03:24 | Performance improvement to the sqlite3MemCompare() routine by factoring out sqlite3BlobCompare(). (check-in: 20ed2321b0 user: drh tags: trunk) | |
2014-09-15
| ||
16:53 | Fix tool/showwal.c so that it handles WAL files that contain 64KiB pages. (check-in: 4060efb646 user: dan tags: trunk) | |
16:50 | Avoid attempting to call the xFetch() method of an sqlite3_io_methods object with a version number less than 3. (check-in: dedaa6fb3d user: dan tags: trunk) | |
14:59 | Remove the EXPENSIVE_ASSERTS in pcache.c having to do with the pSynced field of the Pcache object, as they are incorrect, as revealed by recent pcache enhancements. (check-in: 69a6456077 user: drh tags: trunk) | |
14:46 | Do not flatten aggregate subqueries that contain min() or max() functions so that if the min()/max() are discarded by the outer query, they still function and cause non-aggregate expression to be evaluated on the minimal or maximal row. (check-in: 0bdf1a086b user: drh tags: trunk) | |
11:14 | Adjust comments to show that subquery flattening restriction (10) was removed from the code back in 2005. This is a comment change only. (check-in: 4ff0eb96bc user: drh tags: trunk) | |
2014-09-12
| ||
20:30 | Small performance improvement to the dirty list handling in the pager. (check-in: b332a84d51 user: drh tags: trunk) | |
17:41 | Simplify the way the column cache is managed around OP_Move instructions. (check-in: 320556233e user: drh tags: trunk) | |
04:28 | Fix a problem with parser memory allocation on 32-bit systems. (check-in: 2f69a1fa6a user: drh tags: trunk) | |
2014-09-11
| ||
23:34 | Fix an issue with sqlite3_bind_text64() with the SQLITE_UTF16 encoding parameter. Remove some unreachable code from the text64() and blob64() implementation. (check-in: 34292b084e user: drh tags: trunk) | |
18:44 | Add new APIs that take 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_bind_text64(), sqlite3_result_blob64(), and sqlite3_result_text64(). Add the sqlite3_msize() interface. Internal memory allocation routines now use 64-bit unsigned length parameters for safety. Fix the sqlite3_get_table() to use sqlite3_realloc64() to avoid a integer overflow problem. (check-in: 7e4978c003 user: drh tags: trunk) | |
17:27 | Add the SQLITE_USER_AUTHENTICATION extension to the trunk. This extension is disabled by default. Special compilation procedures are need to enable it. (check-in: 65884d4f81 user: drh tags: trunk) | |
17:14 | Clean up some #includes in the extension API implementation. (Closed-Leaf check-in: b149ef5c63 user: drh tags: user-auth) | |
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. (check-in: cda33c1ef3 user: drh tags: user-auth) | |
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. (check-in: 842c6da8f1 user: drh tags: user-auth) | |
15:25 | All interfaces working and tested. (check-in: 96ea5c0b3c user: drh tags: user-auth) | |
14:56 | Get the sqlite3_user_delete() interface working. (check-in: 974a9c6558 user: drh tags: user-auth) | |
14:40 | Fix the sqlite3_user_change() interface so that it does allow a non-admin user to change their own password. (check-in: 52d440c7e1 user: drh tags: user-auth) | |
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. (check-in: 70121e7cf8 user: drh tags: user-auth) | |
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. (check-in: 596e728b0e user: drh tags: user-auth) | |
00:27 | Reorder parameters on the sqlite3_user_*() interfaces for consistency. Add the first TCL test cases. (check-in: 2f6d8f32ee user: drh tags: user-auth) | |
2014-09-10
| ||
22:46 | Complete the implementation of the various APIs. Fix several problems. This is another incremental check-in that does not completely work. (check-in: 4eaaa7fa87 user: drh tags: user-auth) | |
19:01 | Add the ".user" shell command and implement the sqlite3_user_add() routine. Incremental check-in. The code compiles but does not work. (check-in: a0455f9deb user: drh tags: user-auth) | |