SQLite

Today In History
Login

This Day In History For 2019-09-09

1 Year Ago (more context)

2018-09-09
10:46 New ticket [c94369cae9] Wrong answer due to the LIKE optimization. (artifact: ffd4cb432b user: drh)

2 Years Ago (more context)

2017-09-09
22:46
Simplification and performance improvement to sqlite3_reset(). (check-in: b6425d0170 user: drh tags: improved-integrity-check)
20:38
Improved detection of malformed records by PRAGMA integrity_check. (check-in: 8fa923caa1 user: drh tags: improved-integrity-check)
19:41
Enhance the vtab interface to handle IS, !=, IS NOT, IS NULL and IS NOT NULL constraints. (check-in: 34c8e95261 user: dan tags: vtab-extra-ops)
08:03
Use a mutex-free PRNG for the random() and randomblob() SQL functions and for the randomness used during checkpoint operations. (Leaf check-in: e63d1a7cd3 user: drh tags: mutex-free-randomness)
06:10
Merge trunk enhancements (check-in: 6a0b9d9d4e user: drh tags: apple-osx)
00:51
Fix harmless compiler warnings seen with MSVC. (check-in: faa22e29a5 user: mistachkin tags: trunk)

3 Years Ago (more context)

2016-09-09
20:26
Make the new file test_delete.c portable to MSVC on Windows. (Closed-Leaf check-in: 0e3ace39f2 user: mistachkin tags: test_delete)
20:23
Remove an unnecessary call to sqlite3VdbeMemExpandBlob() when casting to text. (check-in: 19e2e59505 user: drh tags: trunk)
20:00
Add new file test_delete.c, containing test code for deleting an sqlite database. (check-in: fb0b95e940 user: dan tags: test_delete)
19:33
Performance improvements to the comparison operators in the bytecode engine. (check-in: 37803b19d2 user: drh tags: trunk)
15:12
Fix a out-of-order variable declaration for some compile-time configurations. (check-in: 6ac932c92a user: drh tags: trunk)
13:23
In releasetest.tcl, the --srcdir option is automatic, so no need to mention it in the --help output. (check-in: 2bdd838e2c user: drh tags: trunk)
13:17
Fix an obsolete comment in the releasetest.tcl source code. (check-in: afaaa276b2 user: drh tags: trunk)
12:29
In releasetest.tcl: Improved testing for uncommitted changes. If uncommitted changes are seen, exit immediately unless the --force option is used. (check-in: 9a14e6c46c user: drh tags: trunk)

4 Years Ago (more context)

2015-09-09
23:54
Fix harmless compiler warning in FTS5. (check-in: 86146a731d user: mistachkin tags: trunk)
19:44
Fix an assert() enabled by SQLITE_ENABLE_EXPENSIVE_ASSERT in wal.c. (check-in: 8d2ed150a7 user: dan tags: trunk)
19:27
Fix a possible NULL pointer deref when using SQLITE_ENABLE_MEMORY_MANAGEMENT. (check-in: 89bfdbfe94 user: drh tags: trunk)
17:23
Fix harmless compiler warning. (check-in: 280fd3a482 user: mistachkin tags: trunk)
17:17
Fix harmless compiler warnings in FTS5. (check-in: 2cdb18778f user: mistachkin tags: trunk)
13:28 Fixed ticket [acd1299088]: CREATE TABLE AS fails with a false report of database corruption plus 5 other changes (artifact: b2d6502f2b user: drh)
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]. (check-in: 4a18d8bd4c user: drh tags: trunk)
12:34 New ticket [acd1299088] CREATE TABLE AS fails with a false report of database corruption. (artifact: 16828871e7 user: drh)
08:15
Fix a bug in preprocessor macros within fts5_main.c. (check-in: 0eb2b9521f user: dan tags: fts5-incompatible)

5 Years Ago (more context)

2014-09-09
20:30
Change the name of the _texte64() interfaces to just _test64(), without the "e". (Closed-Leaf check-in: 6ab76c5fed user: drh tags: 64-bit-lengths)
18:41
Add new interfaces to the loadable extension mechanism. (check-in: 18d80cbc59 user: drh tags: 64-bit-lengths)
17:27
Add new APIs that take 64-bit length parameters: sqlite3_malloc64(), sqlite3_realloc64(), sqlite3_bind_blob64(), sqlite3_bind_texte64(), sqlite3_result_blob64(), and sqlite3_result_texte64(). Internal memory allocation routines also now use 64-bit unsigned length parameters for safety. Also add the sqlite3_msize() interface. Fix the sqlite3_get_table() to use sqlite3_realloc64() to avoid a integer overflow problem. (check-in: 94954850cf user: drh tags: 64-bit-lengths)
14:47
Non-working preliminary implementation attempts on user authentication. (check-in: 8440f093ba user: drh tags: user-auth)

10 Years Ago (more context)

2009-09-09
18:46
Trying to open a transaction in one thread and close it in another is a misuse with LinuxThreads. Doing so may cause memory and file-descriptors to be leaked. Update an assert() and some test cases to account for this. (check-in: ef99eb57c5 user: dan tags: trunk)
16:10
Suppress some harmless compiler warnings. (check-in: f0c72a53c5 user: drh tags: trunk)
15:29
Bug fix in the SQLITE_OPEN_PRIVATECACHE option added a few minutes ago. (check-in: f3a0f23bc7 user: drh tags: trunk)
15:06
Add some tests that involve BEFORE UPDATE or BEFORE DELETE triggers messing with the row being updated or deleted. SQLite behaviour in this scenario is undefined, so the tests just check that the behaviour is relatively sane and there are no crashes. (check-in: 9a4c59a2dd user: dan tags: trunk)
14:49 Fixed ticket [7d96113ff0]: SQLite fails to build when TCL isn't installed plus 2 other changes (artifact: 5b8f84d886 user: drh)
14:48
Update the README file to state that TCL is required in order to run the makefiles for SQLite. Ticket [7d96113ff]. (check-in: ba20091ae8 user: drh tags: trunk)
14:31 Closed ticket [4b81075908]: In mult-thread that have a problem of updata lost plus 2 other changes (artifact: 0e99c27ada user: drh)
14:26 Fixed ticket [9fd0bc3663]: Add a new open flag to enable shared cache for a single db connection plus 3 other changes (artifact: afa0825e25 user: drh)
14:17
Added SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags as possibilities to sqlite3_open_v2(), to override the global shared cache mode setting. Ticket [9fd0bc36639c15] (check-in: f509eb8b48 user: drh tags: trunk)
13:18 Closed ticket [f76cabebfd]: xBestIndex/xFilter slight interface improvement plus 3 other changes (artifact: 3a27e2e809 user: drh)
12:50 Closed ticket [3350da7d35]: Error: malformed database schema - near "VIRTUAL": syntax error plus 2 other changes (artifact: 51c0799189 user: drh)
12:46 Ticket [3350da7d35]: 1 change (artifact: ae6384584f user: drh)
12:41
Increase the size of bitvec objects to 1024 bytes on 64-bit systems. (check-in: f1272b90f6 user: drh tags: trunk)
11:47 Closed ticket [29ab7be99f]: Hitting NOT NULL constraint does not roll back statement transaction plus 3 other changes (artifact: 2e3bbe70ea user: dan)
11:43
Add a test case to show that 29ab7be99f is fixed. (check-in: 135d656a20 user: dan tags: trunk)
11:37
Add a complicated assert() to check that statement transactions are opened when required. (check-in: 28aa1f4ea8 user: dan tags: trunk)
10:31 New ticket [29ab7be99f] Hitting NOT NULL constraint does not roll back statement transaction. (artifact: b37d2263d5 user: dan)
10:06 Ticket [3350da7d35] Error: malformed database schema - near "VIRTUAL": syntax error status still Open with 3 other changes (artifact: ad57431484 user: anonymous)
10:05 New ticket [3350da7d35]. (artifact: 142606d87b user: anonymous)
08:09 New ticket [f76cabebfd] xBestIndex/xFilter slight interface improvement. (artifact: 5c4161ba8f user: anonymous)
05:39 Ticket [eaa105fe74] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 1 other change (artifact: b2bdc0912e user: dan)

15 Years Ago (more context)

2004-09-09
14:01
Fix lemon so that inserted code always ends in a newline. Ticket #895. (CVS 1955) (check-in: 13fba17e3f user: drh tags: trunk)
13:55
Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1954) (check-in: 97d63b9290 user: drh tags: trunk)
13:54
Fix a segfault in the authorizer when it is given a SELECT statement with no FROM clause. Ticket #896. (CVS 1953) (check-in: 205d85d77e user: drh tags: version_2)
00:35
Trying to get some tests in printf.test to pass on 64-bit systems. (CVS 1952) (check-in: b12fc46dcd user: drh tags: trunk)