Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 descendants and 100 ancestors of [497367cb]
|
2016-02-15
| ||
| 17:39 | Merge 3.11.0 changes. check-in: 631023dd user: drh tags: sessions | |
|
2016-02-13
| ||
| 15:08 | Fix another test problem in sessionfault.test. check-in: f6d1cf79 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: 6c2d34df 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: 582b2ae7 user: dan tags: sessions | |
| 14:07 | Merge the changes for the 3.11.0 release candidate from trunk. check-in: 4d7a802e user: drh tags: sessions | |
|
2016-02-09
| ||
| 15:44 | Merge enhancements and fixes from trunk. check-in: f040a5bb user: drh tags: sessions | |
|
2016-02-05
| ||
| 14:15 | Merge enhancements from trunk. check-in: a533608c user: drh tags: sessions | |
|
2016-02-02
| ||
| 02:22 | Merge all recent enhancements from trunk. check-in: f3f92001 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: 82470d1c user: dan tags: disable-restrict | |
|
2016-01-20
| ||
| 16:02 | Merge the LIKE-operator bug fix from trunk. check-in: 36cb3d6e user: drh tags: sessions | |
| 11:33 | Merge recent enhancements from trunk. check-in: 327af5f6 user: drh tags: sessions | |
|
2016-01-14
| ||
| 14:48 | Merge the latest fixes and enhancements from trunk. check-in: 007e5c6d user: drh tags: sessions | |
|
2016-01-11
| ||
| 13:10 | Merge recent enhancements, and especially the WAL overwrite change, from trunk. check-in: c4a858b2 user: drh tags: sessions | |
|
2016-01-06
| ||
| 15:14 | Merge changes for version 3.10.0. check-in: fa4705c9 user: drh tags: sessions | |
|
2016-01-04
| ||
| 19:02 | Merge in last-minute patches for the 3.10.0 beta. check-in: c785cd78 user: drh tags: sessions | |
|
2016-01-01
| ||
| 13:25 | Merge the latest enhancements from trunk. check-in: c0be246a user: drh tags: sessions | |
|
2015-12-16
| ||
| 19:47 | Merge recent enhancements from trunk. check-in: f6c9273c user: drh tags: sessions | |
|
2015-12-02
| ||
| 20:40 | Merge recent enhancements from trunk. check-in: d1a1278d user: drh tags: sessions | |
|
2015-11-19
| ||
| 19:40 | Merge the latest enhancements from trunk. check-in: 7d6cfc79 user: drh tags: sessions | |
|
2015-11-07
| ||
| 01:33 | Merge recent enhancements and bug fixes from trunk. check-in: 78bc42e6 user: drh tags: sessions | |
|
2015-11-02
| ||
| 18:57 | Merge all recent enhancements and fixes from trunk. check-in: 0546d1cd user: drh tags: sessions | |
|
2015-10-30
| ||
| 16:50 | Merge all the latest enhancements from trunk. check-in: 395a153f user: drh tags: sessions | |
|
2015-10-16
| ||
| 20:20 | Merge the version 3.9.1 updates. check-in: 2bbb9595 user: drh tags: sessions | |
|
2015-10-13
| ||
| 20:42 | Merge in the final few changes before the 3.9.0 release. check-in: e1afdbb5 user: drh tags: sessions | |
|
2015-10-10
| ||
| 20:35 | Pull in the latest 3.9.0 tweaks from trunk. check-in: ed174ccf 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: c1d96fb6 user: drh tags: sessions | |
|
2015-10-08
| ||
| 14:55 | Merge the 3.8.12 beta changes from trunk. check-in: 35b1b8d4 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: 76958902 user: dan tags: sessions | |
|
2015-09-30
| ||
| 14:50 | Merge recent enhancements from trunk, and especially the fix for ticket [1b266395d6bc10]. check-in: b2face9a user: drh tags: sessions | |
|
2015-09-24
| ||
| 14:26 | Merge all the latest trunk enhancements into the sessions branch. check-in: c91065f8 user: drh tags: sessions | |
|
2015-09-15
| ||
| 15:55 | Merge the latest trunk enhancements with this branch. check-in: b7469c44 user: dan tags: sessions | |
|
2015-09-14
| ||
| 10:47 | Merge the latest trunk enhancements. check-in: 22ce9218 user: drh tags: sessions | |
|
2015-09-03
| ||
| 14:48 | Merge recent trunk enhancements. check-in: 6a513c05 user: drh tags: sessions | |
|
2015-09-01
| ||
| 18:52 | Merge recent enhancements from trunk. check-in: cb772366 user: drh tags: sessions | |
|
2015-08-20
| ||
| 23:54 | Merge recent trunk enhancements, include table-valued functions. check-in: e9196d56 user: drh tags: sessions | |
|
2015-07-24
| ||
| 22:21 | Merge test improvements and minor fixes from trunk. check-in: 0298a9a7 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: 7f0ee770 user: drh tags: sessions | |
|
2015-07-14
| ||
| 15:39 | Merge trunk changes, including the addition of FTS5 and pcache1 performance enhancements. check-in: db4cbefb 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: 85ca4409 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: 39936b33 user: drh tags: sessions | |
|
2015-06-25
| ||
| 15:44 | Merge all the latest enhancements from trunk. check-in: 924f4712 user: drh tags: sessions | |
|
2015-06-17
| ||
| 18:18 | Merge all recent enhancements and fixes from trunk. check-in: 199bfb67 user: drh tags: sessions | |
|
2015-06-11
| ||
| 18:01 | Merge recent trunk enhancements and fixes. check-in: c39cb0e2 user: drh tags: sessions | |
| 17:26 | Add the sqlite3changegroup_xxx() APIs to the sessions module. For combining multiple changesets or patchsets. check-in: 0c1a901c 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: fb391407 user: dan tags: sessions | |
| 09:19 | Modify the sessions module to ignore all operations on tables with no primary keys as documented. check-in: bdaf9575 user: dan tags: sessions | |
|
2015-05-29
| ||
| 19:04 | Import recent enhancements from trunk. check-in: 54bec164 user: drh tags: sessions | |
|
2015-05-22
| ||
| 23:51 | Merge bug fixes from trunk. check-in: 519054bb 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: cdc0ca6f 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: b9e45596 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: 2007391c 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: 7530e1bf 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: 0a0de8b7 user: drh tags: sessions | |
|
2015-05-14
| ||
| 15:17 | Merge in the IS-operator enhancements and other recent changes from trunk. check-in: 4f922944 user: drh tags: sessions | |
|
2015-05-07
| ||
| 12:29 | Merge in the 3.8.10 release changes. check-in: 0404ef88 user: drh tags: sessions | |
|
2015-05-05
| ||
| 17:12 | Merge all trunk enhancements and fixes into the sessions branch. check-in: de7083cf 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: aada0ad0 user: dan tags: sessions | |
| 15:03 | Fix the error message returned by sqlite3session_diff() for tables with no PRIMARY KEY. check-in: 4d34a3d4 user: dan tags: sessions | |
| 14:40 | Fix a performance problem in sqlite3session_diff(). check-in: ea400eca user: dan tags: sessions | |
| 13:49 | Merge the latest trunk enhancements and fixes into the sessions branch. check-in: 4e5f17d1 user: drh tags: sessions | |
|
2015-04-20
| ||
| 01:32 | Merge all recent trunk enhancements and fixes into the sessions branch. check-in: b8ef1cde user: drh tags: sessions | |
|
2015-04-17
| ||
| 11:31 | Hold the database mutex for the duration of sqlite3session_diff(). check-in: 6f330501 user: dan tags: sessions | |
|
2015-04-16
| ||
| 13:52 | Fix a stray backslash character in a printf format string in sessionDiffFindModified() check-in: abb192a1 user: drh tags: sessions | |
|
2015-04-15
| ||
| 14:14 | Merge all recent trunk fixes and enhancements into the sessions branch. check-in: e65e65f9 user: drh tags: sessions | |
|
2015-04-12
| ||
| 01:33 | Merge all recent trunk enhancements into the sessions branch. check-in: 5f14f34f user: drh tags: sessions | |
|
2015-04-11
| ||
| 17:09 | Merge the sessions-diff branch with this one. check-in: 805baa57 user: dan tags: sessions | |
|
2015-04-09
| ||
| 19:19 | Updates to comments describing the changeset and patchset formats. check-in: 5342f721 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: b9459d59 user: dan tags: sessions | |
| 16:01 | Add experimental API sqlite3session_diff(). Closed-Leaf check-in: c4340b2e user: dan tags: sessions-diff | |
|
2015-04-07
| ||
| 23:10 | Merge printf() width and precision overflow fixes from trunk. check-in: aeca95ac user: drh tags: sessions | |
|
2015-04-06
| ||
| 12:08 | Merge obscure problem fixes from trunk. check-in: 271c110b user: drh tags: sessions | |
|
2015-04-01
| ||
| 16:39 | Merge recent enhancements from trunk. check-in: aea439bd user: drh tags: sessions | |
|
2015-03-31
| ||
| 00:10 | Merge all recent trunk enhancements and fixes into the sessions branch. check-in: df94e61f user: drh tags: sessions | |
|
2015-03-24
| ||
| 19:02 | Merge all recent trunk enhancements into the sessions branch. check-in: 54aaa6f2 user: drh tags: sessions | |
|
2015-03-17
| ||
| 18:54 | Merge all recent trunk enhancements into the sessions branch. check-in: 1d1c57c3 user: drh tags: sessions | |
|
2015-03-09
| ||
| 13:07 | Merge recent trunk enhancements into the sessions branch. check-in: 68c8937e user: drh tags: sessions | |
|
2015-02-25
| ||
| 14:02 | Merge the latest trunk fixes into the sessions branch. check-in: 131a2d31 user: drh tags: sessions | |
|
2015-02-21
| ||
| 15:13 | Merge all recent trunk changes into the sessions branch. check-in: f36bb5fa user: drh tags: sessions | |
|
2015-02-06
| ||
| 15:40 | Merge all the latest enhancements from trunk. check-in: ae7eef11 user: drh tags: sessions | |
|
2015-01-16
| ||
| 12:44 | Merge all 3.8.8 changes into the sessions branch. check-in: bebd131a user: drh tags: sessions | |
|
2015-01-14
| ||
| 17:16 | Merge trunk 3.8.8 beta changes into the sessions branch check-in: 0ba12454 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: 5a2dec55 user: drh tags: sessions | |
|
2014-12-31
| ||
| 14:27 | Merge the fix to PRAGMA data_version and testing improvements from trunk. check-in: 86e39123 user: drh tags: sessions | |
|
2014-12-22
| ||
| 18:48 | Merge the PRAGMA data_version redefinition and other fixes from trunk. check-in: 315243e4 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: d4f82af0 user: drh tags: sessions | |
|
2014-12-16
| ||
| 01:05 | Merge threading fixes from trunk into the sessions branch. check-in: 9817a286 user: drh tags: sessions | |
|
2014-12-09
| ||
| 14:54 | Merge the KeyInfo cache mutex fix from trunk. check-in: f0940c73 user: drh tags: sessions | |
|
2014-12-05
| ||
| 20:05 | Merge the fix for the shared-cache KeyInfo cache bug from trunk. check-in: 5a73da6a 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: c9f20eb2 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: 34ffa3b3 user: drh tags: sessions | |
|
2014-12-02
| ||
| 16:31 | Merge all recent fixes and enhancements from trunk into sessions. check-in: 2617d937 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: f09055f3 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: 28b044a5 user: drh tags: sessions | |
|
2014-10-17
| ||
| 11:53 | Merge all version 3.8.7 updates from trunk. check-in: f4de9e07 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: 236704a9 user: dan tags: sessions | |
| 19:37 | Merge latest trunk changes with this branch. check-in: 1b2824f1 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: 83d4114f user: drh tags: sessions | |
|
2014-10-10
| ||
| 12:56 | Merge all recent trunk changes. check-in: abfef254 user: drh tags: sessions | |
|
2014-10-01
| ||
| 01:52 | Merge the latest enhancements from trunk. check-in: 2695772c 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: 1f44bfdc user: drh tags: sessions | |
| 19:51 | Merge recent trunk changes (performance enhancements) into the sessions branch. check-in: 497367cb user: drh tags: sessions | |
| 18:18 | Fix a segfault in the sessions module that could follow an OOM. check-in: 09985fa6 user: dan tags: sessions | |
| 16:33 | Fix a segfault in the streaming API functions triggered by a very long table name. check-in: d2642543 user: dan tags: sessions | |
| 12:26 | Improve sessions module documentation and comments. Fix some other code issues. check-in: bfc8bd80 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: d026f0c9 user: mistachkin tags: trunk | |
| 10:52 | Fix a problem with concatenating patchsets containing DELETE and INSERT operations on the same row. check-in: 4d8537ea 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: 83913515 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: e93aecc0 user: drh tags: trunk | |
|
2014-09-25
| ||
| 20:43 | Add streaming version of sqlite3changeset_concat(). check-in: 88eb6656 user: dan tags: sessions | |
| 17:42 | Minor code reformatting and comment change, to improve clarity. No logic changes. check-in: baeb72a3 user: drh tags: trunk | |
| 14:54 | Add streaming version of sqlite3changeset_invert() to sessions module. check-in: 8ded6a46 user: dan tags: sessions | |
| 13:17 | Simplifications to the SQL function and aggregate calling procedures. check-in: 3467049a 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: 1330c72e user: drh tags: trunk | |
| 11:08 | Still more performance enhancements to the LIKE and GLOB operators. check-in: 6c8924ca user: drh tags: trunk | |
| 03:51 | More performance optimization for the LIKE and GLOB operators. check-in: 5ab1023d user: drh tags: trunk | |
| 02:44 | Change that might allow SQLite to build and work using the EBCDIC character set. check-in: ef30e035 user: drh tags: trunk | |
| 00:56 | Size reduction and performance improvement in the LIKE and GLOB operators. check-in: b2c89ef4 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: 99323552 user: drh tags: trunk | |
| 18:31 | Small performance and size optimization for btreeUnlockIfUnused(). check-in: 13c746f8 user: drh tags: trunk | |
| 17:13 | Add streaming version of sqlite3changeset_apply(). Tests and fixes for the same and sqlite3changeset_start_str(). check-in: b917fc14 user: dan tags: sessions | |
| 13:20 | Do not allow parameters in a DEFAULT clause of a CREATE TABLE statement. Ticket [78c0c8c3c9f7c1]. check-in: 1ad2bc1e 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: f21d2175 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: 5dd41cdb user: drh tags: trunk | |
| 00:59 | Add the MemPage.noPayload boolean and use it to help cellSizePtr() and btreeParseCellPtr() run faster. check-in: 8e337531 user: drh tags: trunk | |
|
2014-09-23
| ||
| 23:12 | Remove an unused C-preprocessor macro. No functional changes to the code. check-in: f480582c 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: 4147f667 user: drh tags: trunk | |
| 21:25 | Simplify the CellInfo structure for a size reduction and performance improvement. check-in: bf59df66 user: drh tags: trunk | |
| 20:39 | Begin adding 'streaming' APIs to sessions module. This is a work in progress. check-in: 3c7d3d95 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: d2962a5f 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: ae9a42b2 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: 76097440 user: drh tags: trunk | |
| 19:51 | Size reduction and substantial performance increase for cellSizePtr(). check-in: bc8bbf32 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: 41de1643 user: drh tags: trunk | |
| 03:22 | Disable shared memory operations using the unix-nolock VFS. check-in: 10a6e510 user: drh tags: trunk | |
|
2014-09-21
| ||
| 22:49 | Merge all recent trunk changes into the sessions branch. check-in: 6406b77f 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: d5880abd user: drh tags: trunk | |
| 20:31 | Add test cases for ticket [d11a6e908f]. Closed-Leaf check-in: 9683e001 user: drh tags: select-trace | |
| 17:51 | Add the "showauth" extension in ext/misc. check-in: 28d52c1c user: drh tags: select-trace | |
| 00:27 | Improved ".selecttrace" output. check-in: c0b61f70 user: drh tags: select-trace | |
|
2014-09-20
| ||
| 20:38 | Candidate fix for [d11a6e908f]. check-in: 89398880 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: f1ba68f1 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: cbe0cf9d 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: 59e2c9df 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: 0fac2c04 user: drh tags: sqliteIntMacros | |
| 00:02 | Revise macro usage in 'sqliteInt.h'. check-in: 35db3e2f 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: 544664ca 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: 3b21cf2b 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: e996ca32 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: 3f3ca76a 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: 3ab20ba1 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: 3db78d61 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: 6199760d user: drh tags: trunk | |
| 16:13 | Small size reduction and performance increase for releaseMemArray(). check-in: 24cd32d6 user: drh tags: trunk | |
| 16:02 | Updates to comments. No code changes. check-in: 9b42c3da 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: 36b613cc user: drh tags: trunk | |
| 04:42 | Add the sqlite3VdbeMemClearAndResize() function. Fix a sorting-index prefilter problem. check-in: 987a7a21 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: 72727b68 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: 5b9b8987 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: 9c09ac35 user: drh tags: trunk | |
| 18:55 | Correct typos in comments. No changes to code. check-in: 55879932 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: 4c8c89d7 user: drh tags: trunk | |
| 16:28 | Performance improvement for affinity transformations on comparison operators. check-in: d7afdcba 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: 4ef4c9a7 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: 3bd7c1b2 user: dan tags: trunk | |
| 02:20 | Fix harmless warnings on 32-bit MSVC builds. check-in: 5192f964 user: drh tags: trunk | |
| 01:50 | Make sure of the strchrnul() library function on platforms where it is available. check-in: ef1aa10b 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: 1de558bc 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: 163bfae8 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: 14052a7d 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: fdddb477 user: drh tags: micro-optimizations | |
| 14:52 | Improved interface to the Mem object handling. Small size reduction and performance increase. check-in: 4e437844 user: drh tags: micro-optimizations | |
|
2014-09-16
| ||
| 21:54 | Continuing cleanup of memory register memory allocation handling. check-in: 2598aedc 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: 78fb8838 user: drh tags: micro-optimizations | |
| 18:22 | Simplification of the OP_Column logic for the case of rows with overflow. check-in: f7367803 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: a10a6bba 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: 8239c35a 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: 0be3019e user: drh tags: micro-optimizations | |
| 13:30 | Changes to sqlite3VdbeRecordUnpack() to make it slightly smaller and faster. check-in: 8fb90da7 user: drh tags: trunk | |
| 03:24 | Performance improvement to the sqlite3MemCompare() routine by factoring out sqlite3BlobCompare(). check-in: 20ed2321 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: 4060efb6 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: dedaa6fb 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: 69a64560 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: 0bdf1a08 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: 4ff0eb96 user: drh tags: trunk | |
|
2014-09-12
| ||
| 20:30 | Small performance improvement to the dirty list handling in the pager. check-in: b332a84d user: drh tags: trunk | |
| 17:41 | Simplify the way the column cache is managed around OP_Move instructions. check-in: 32055623 user: drh tags: trunk | |
| 04:28 | Fix a problem with parser memory allocation on 32-bit systems. check-in: 2f69a1fa 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: 34292b08 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: 7e4978c0 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: 65884d4f user: drh tags: trunk | |
| 17:14 | Clean up some #includes in the extension API implementation. Closed-Leaf check-in: b149ef5c 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: cda33c1e 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: 842c6da8 user: drh tags: user-auth | |
| 15:25 | All interfaces working and tested. check-in: 96ea5c0b user: drh tags: user-auth | |
| 14:56 | Get the sqlite3_user_delete() interface working. check-in: 974a9c65 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: 52d440c7 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: 70121e7c 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: 596e728b user: drh tags: user-auth | |
| 00:27 | Reorder parameters on the sqlite3_user_*() interfaces for consistency. Add the first TCL test cases. check-in: 2f6d8f32 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: 4eaaa7fa 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: a0455f9d user: drh tags: user-auth | |