SQLite

Timeline
Login

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

100 descendants of 06338201f3f00151

2016-01-03
18:59
Alternative to [76f5efa6], move definition of utf8_printf up. check-in: 54c5522d user: mistachkin tags: altShellFix
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. check-in: e30062e9 user: drh tags: trunk
11:27
Fix a premature reference to utf8_printf in shell.c. check-in: 76f5efa6 user: drh tags: trunk
11:17
Add the number of cores used and the name of the host computer to the summary at the end of releasetest.tcl. check-in: cd3ae0f1 user: drh tags: trunk
2016-01-02
19:01
Changes to run many fts5 tests with detail=none and detail=col tables as well as the default detail=full. Also fixes for the bugs uncovered by running said tests. check-in: 6322a1d9 user: dan tags: fts5-offsets
05:00
Fix a (harmless) typo in an #ifdef for SQLITE_ENABLE_CURSOR_HINTS check-in: 2047d2de user: drh tags: trunk
2016-01-01
16:42
Remember the size of the Vdbe.aOp[] array in bytes, to avoid unnecessary calls to sqlite3_msize(). check-in: 3e852804 user: drh tags: trunk
16:26
Avoid misaligned memory allocations on Sparc in sqlite3VdbeMakeReady(). This fixes a problem introduced by check-in [a9e819082b]. check-in: a304e346 user: drh tags: trunk
14:14
Merge recent trunk enhancements. check-in: 6bea792c user: drh tags: begin-concurrent
13:31
Merge all recent trunk enhancements. check-in: 5b700f31 user: drh tags: apple-osx
13:25
Merge the latest enhancements from trunk. check-in: c0be246a user: drh tags: sessions
03:37
Fix an assert() that might be false for a corrupt database. check-in: 68360cd2 user: drh tags: trunk
00:15
Remove unreachable branches from the new JSON aggregate functions. check-in: 6e30f8c6 user: drh tags: trunk
2015-12-31
22:29
Fix the ieee754.test module so that it works both on systems that report infinity as "inf" and as "Inf". check-in: d41d4d73 user: drh tags: trunk
19:06
In the shell, use utf8_printf() when any string formatting is present and raw_printf() otherwise. check-in: 8cf01fff user: mistachkin tags: trunk
19:04
Fix harmless compiler warning seen with MSVC. check-in: 98ec778d user: mistachkin tags: trunk
18:39
Fix the fts5 integrity-check code so that it works with detail=none tables. check-in: 3a1df69e user: dan tags: fts5-offsets
17:36
Fix some problems with fts5 detail=none tables. Some still remain. check-in: 6a6f7bc4 user: dan tags: fts5-offsets
15:34
Fix harmless compiler warnings associated with SQLITE_ENABLE_HIDDEN_COLUMNS. check-in: 9c392c10 user: drh tags: trunk
04:34
Small size and performance optimization to the VDBE comparison opcodes. check-in: 7a0b9413 user: drh tags: trunk
2015-12-30
20:50
Use the OvflOffset() macro to try to remove some magic numbers from btree.c. Leaf check-in: 1541607d user: drh tags: ovfloffset-macro
19:58
Updates to fts5 to support detail=none mode. As of this commit, many cases are still broken. check-in: ac8f4cf0 user: dan tags: fts5-offsets
18:18
Reduce the size of the CellInfo object from 32 to 24 bytes on 64-bit machines, for a small performance increase and library size reduction. check-in: 6a4cfc7a user: drh tags: trunk
17:03
Enhance the command-line shell so that it can handle MBCS characters on input and output. check-in: 3d81dfe3 user: drh tags: trunk
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. check-in: 2081d757 user: drh tags: trunk
15:18
Simplification to the xfer-optimization logic. check-in: f35ba018 user: drh tags: trunk
14:06
Remove unnecessary tests from the LIKE pattern matcher. Slightly faster and slightly smaller, and it should also now works with EBCDIC. check-in: 0a99a8c4 user: drh tags: trunk
13:36
Enhance the command-line shell to handle MBCS characters on input and output. Closed-Leaf check-in: a0a08b8c user: drh tags: mbcs-shell
01:07
Add the json_group_array() and json_group_object() aggregate functions to the JSON1 extension. check-in: 7f386a93 user: drh tags: trunk
2015-12-29
19:35
Add the xPhraseFirstColumn() and xPhraseNextColumn() API functions to fts5. For iterating through the set of columns that contain intances of a phrase. check-in: 8c30605b user: dan tags: fts5-offsets
2015-12-28
19:55
Change the name of the offsets=0 option to "detail=column". Have the xInst, xPhraseFirst and other API functions work by parsing the original text for detail=column tables. check-in: 228b4d10 user: dan tags: fts5-offsets
2015-12-24
14:53
Avoid a harmless compiler warning on systems where the byteorder cannot be determined at compile-time. check-in: 7c7b7f26 user: drh tags: trunk
2015-12-23
16:42
Fix some harmless gcc compiler warnings. Mostly in fts5, but also two in the core code. check-in: 5d44d4a6 user: dan tags: trunk
10:54
Enhance the 'utc' modifier on date/time functions so that if the LHS is already known to be in UTC, the modifier becomes a no-op. This is not an incompatibility because the behavior is documented as "undefined" in that scenario. check-in: b910a3d5 user: drh tags: trunk
2015-12-22
18:54
Updates so that fts5 API functions xInst, xPhraseFirst and xPhraseNext work with the offsets=0 option. check-in: 69bffc16 user: dan tags: fts5-offsets
2015-12-21
18:45
Fix an fts5 integrity-check problem that affects offsets=0 tables with prefix indexes. check-in: 609a0bc7 user: dan tags: fts5-offsets
15:22
Ensure that the Expr objects that describe indexed expressions are not modified by code generation. Fix for an assert() problem found by Jon Metzman using AFL. check-in: 34073ce8 user: drh tags: trunk
2015-12-18
19:07
Fix a problem with prefix queries on fts5 offsets=0 tables. check-in: ad0987d8 user: dan tags: fts5-offsets
16:29
Micro-optimizations and comment fixes on the mem5.c memory allocator module. check-in: 8bf5e056 user: drh tags: trunk
03:59
Reduce the size of the CellInfo object from 32 to 24 bytes on 64-bit machines. Closed-Leaf check-in: 78507154 user: drh tags: optimize-cellinfo
2015-12-17
20:36
Add the "offsets=0" option to fts5, to create a smaller index without term offset information. A few things are currently broken on this branch. check-in: 40b5bbf0 user: dan tags: fts5-offsets
19:17
Make the VdbeCursor object even smaller. But the resulting library is bigger and slower than trunk. This branch is a failed experiment. Leaf check-in: 896a06cc user: drh tags: optimize-vdbecursor
17:30
Reduce the size of the VdbeCursor object by a pointer (the pBt pointer used for ephemeral tables). check-in: 98b710c3 user: drh tags: optimize-vdbecursor
14:18
Fix the spellfix1_scriptcode() function to ignore whitespace and punctuation, and to recognize hebrew and arabic scripts. check-in: 7adfa4a5 user: drh tags: trunk
13:28
Fixes for harmless compiler warnings. check-in: 85ebd46c user: drh tags: trunk
2015-12-16
23:30
Fix even more harmless compiler warnings. Closed-Leaf check-in: 1d0e6aa1 user: mistachkin tags: msvcWarn
22:06
Fix some more harmless compiler warnings. check-in: 18f531e1 user: mistachkin tags: msvcWarn
21:09
Fix compiler warning seen with MSVC. check-in: 18a4c054 user: mistachkin tags: msvcWarn
19:55
Merge recent enhancements from trunk. check-in: cb22efaf user: drh tags: begin-concurrent
19:47
Merge recent enhancements from trunk. check-in: f6c9273c user: drh tags: sessions
13:07
Make greater use of the SQLITE_WITHIN macro. check-in: f2fc3aed user: drh tags: trunk
2015-12-15
19:32
Update the mkautoconfamal.sh script to make the building of the sqlite3-autoconf-VERSION.tar.gz package more orthodox. check-in: 1928f894 user: dan tags: trunk
13:50
Add the SQLITE_OMIT_PARSER_TRACE compile-time option. check-in: 2fda43e6 user: drh tags: trunk
2015-12-14
19:42
Add a missing memAboutToChange() macro to vdbe.c, the lack of which was causing an assert() to fail incorrectly. Problem found by libfuzzer. check-in: 1a247911 user: dan tags: trunk
2015-12-12
19:23
Update some stale comments in delete.c. No changes to code. Leaf check-in: f59a3326 user: dan tags: onepass-delete-or
17:31
Add further tests for the changes on this branch. Also fix a memory-leak that could follow a malloc failure. check-in: 21526012 user: dan tags: onepass-delete-or
2015-12-11
14:59
Add a new assert() statement to the snapshot-specific part of sqlite3WalBeginReadTrans(). check-in: d8a12023 user: dan tags: trunk
13:59
Merge recent changes from trunk. Also remove unused variables to permit compiling with -Werror. check-in: 57b700ba user: drh tags: onepass-delete-or
13:51
Simplified alignment constraints in the memory reuse logic of sqlite3VdbeMakeReady(). check-in: e998513e user: drh tags: trunk
12:53
Merge recent trunk enhancements, and in particular the snapshot interface. check-in: 7e7b2406 user: drh tags: apple-osx
12:44
Add the experimental snapshot interface. Because it is experimental, it is subject to change or removal at a later date. check-in: 9b124a5a user: drh tags: trunk
04:11
Fix a memory allocation bug introduced last week by check-in [a9e819082ba]. The bug only appears on systems where the size of a structure is not always a multiple of 8 - which in practice means only on 32-bit windows systems. check-in: 96d3e99f user: drh tags: trunk
03:27
Mention that the snapshot interfaces are only available if SQLite is compiled with SQLITE_ENABLE_SNAPSHOT. Closed-Leaf check-in: 843c15a5 user: drh tags: snapshot-get
03:20
Disable the snapshot test scripts if not compiled with SQLITE_ENABLE_SNAPSHOT. check-in: 5fd008f0 user: drh tags: snapshot-get
03:16
Fix a variable type mismatch problem in the snapshot logic. check-in: 93fb8010 user: drh tags: snapshot-get
01:22
Fix a bad assert related to snapshots. check-in: 767ee30e user: drh tags: snapshot-get
2015-12-10
22:48
Snapshot documentation updates. Comment changes only - no changes to code. check-in: ef51a398 user: drh tags: snapshot-get
20:03
Update the sqlite3_snapshot_get() API so that if the caller does not have an open read transaction on the named database, one is automatically opened. check-in: b9c90f10 user: dan tags: snapshot-get
19:44
Add tests to snapshot.test. check-in: f3b74362 user: dan tags: snapshot-get
19:11
Return SQLITE_BUSY (not SQLITE_BUSY_SNAPSHOT) if sqlite3_snapshot_open() fails to obtain the shared checkpointer lock. check-in: 5343060b user: dan tags: snapshot-get
18:06
Add tests to ensure that an sqlite3_snapshot_open() client cannot be tricked into reading a corrupt snapshot even if another process fails mid-checkpoint. check-in: b908048b user: dan tags: snapshot-get
17:59
Move pointer range comparisons into a macro, where they can be dealt with in a more portable way. check-in: 05bc4f92 user: drh tags: trunk
15:45
Have sqlite3_snapshot_open() avoid a race condition by taking a shared CHECKPOINTER lock while checking pInfo->nBackfillAttempted. check-in: 8084eae0 user: dan tags: snapshot-get
15:09
Move pointer range comparisons into a macro, where they can be dealt with in a more portable way. Closed-Leaf check-in: ad3124c8 user: drh tags: stdint.h
03:16
Fix spacing typo in comment. No changes to code. check-in: 3a18526f user: mistachkin tags: snapshot-get
02:15
Add the nBackfillAttempted field in formerly unused space in WalCkptInfo and use that field to close the race condition on opening a snapshot. check-in: cb68e9d0 user: drh tags: snapshot-get
2015-12-09
20:05
Update sqlite3_snapshot_open() to reduce the chances of reading a corrupt snapshot created by a checkpointer process exiting unexpectedly. check-in: 7315f7cb user: dan tags: snapshot-get
17:45
Add extra test cases to delete4.test. check-in: 571b64b9 user: dan tags: onepass-delete-or
17:23
Further simplifications to the VDBE code generation logic that flow out of the previous check-in. check-in: 6a5dfe85 user: drh tags: trunk
16:26
Simplification of the DROP TRIGGER logic using sqlite3NestedParse() instead of hand-coded VDBE code. This is a manual cherry-pick of the key change from check-in [c80bbf14b365d]. check-in: 8021b4c8 user: drh tags: trunk
16:08
Fix a problem with the DROP TABLE command on this branch. check-in: c80bbf14 user: dan tags: onepass-delete-or
16:04
Merge unrelated fixes from trunk. check-in: 362615b4 user: drh tags: snapshot-get
10:06
Add simple tests and bugfixes for DELETE statements that qualify for the OR-optimization. check-in: 10ca7357 user: dan tags: onepass-delete-or
08:13
Merge latest trunk with this branch. check-in: dc236f11 user: dan tags: onepass-delete-or
2015-12-08
19:50
Experimental optimization for DELETE statements with WHERE clauses that qualify for the OR-optimization. check-in: d52376df user: dan tags: onepass-delete-or
16:58
Changes to avoid undefined behavior in memset() and memcpy() and in the comparisons of pointers from different allocations. All problems are found by analysis tools - none have been seen in the wild. check-in: 901d0b8f user: drh tags: trunk
16:08
Avoid doing comparisons with pointers that might have been previously been passed to realloc() and/or free(). check-in: f20396ad user: drh tags: trunk
14:37
Avoid unnecessary work inside of verifyDbFile() in the unix VFS. Closed-Leaf check-in: f3c0579e user: drh tags: unix-vfs-optimization
04:18
Add a test case of the form "WHERE a<2 OR a<3" using PRAGMA count_changes. This test case was failing before the 3.9.0 release. check-in: 177862c1 user: drh tags: trunk
00:47
Update the TclKit download URL. check-in: 07e5199c user: mistachkin tags: trunk
2015-12-07
23:31
Update MSVC batch build tool to the latest Windows 10 SDK version. check-in: 2ad50171 user: mistachkin tags: trunk
21:46
Add the ".changes ON|OFF" command to the sqlite3.exe command-line shell, for testing and verifying the sqlite3_changes() and sqlite3_total_changes() interfaces. check-in: 9bbe1afc user: drh tags: trunk
18:18
Fix the openDirectory() routine in the unix VFS so that it works for databases located in the root of the filesystem and for database files that have no pathname at all. check-in: e7ae120d user: drh tags: trunk
16:43
Changes to avoid undefined behavior detected by analysis tools - never observed in the wild. Later: This check-in introduces a bug, fixed at [a304e34675404aee]. check-in: a9e81908 user: drh tags: trunk
14:33
Add tests for snapshot_get(), _open() and _free(). check-in: 502cc6f3 user: dan tags: snapshot-get
2015-12-05
20:51
Add untested implementations of experimental APIs sqlite3_snapshot_get(), _open() and _free(). check-in: 0715eb00 user: dan tags: snapshot-get
2015-12-04
13:44
Remove the dependence on "exec ls -U" from the vtabH.test module, as the -U option to "ls" is not universally available. check-in: 4ecbc75b user: drh tags: trunk
03:27
Prevent a segfault on Solaris in the test_fs.c due to differences in the definition of the dirent object. check-in: 042738ad user: drh tags: trunk
2015-12-03
22:33
Fix typos in requirements text and update requirements marks. No changes to code. check-in: 8534a46c user: drh tags: trunk
21:47
Improved OOM recovery in the SELECT code generator logic. check-in: e6521a43 user: drh tags: trunk
20:50
Make the SQLITE_ENABLE_8_3_NAMES compile-time option available to sqlite3_compileoption_used(). check-in: 06338201 user: drh tags: trunk