/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

100 check-ins occurring around a38d57a4e5d79a0b.

2012-02-23
15:35
Add the sqlite3PagerWalFramesize() function to pager.c. This is used by zipvfs. check-in: 786e24dc user: dan tags: trunk
14:28
Expose the sqlite3_stricmp() interface. Add the SQLITE_FCNTL_PRAGMA file control. check-in: c539cf21 user: drh tags: trunk
2012-02-22
20:08
Move test logic for SQLITE_FCNTL_PRAGMA out of os_unix.c and into test_vfs.c. Closed-Leaf check-in: c81fc40b user: drh tags: file-control-pragma
19:56
If the SQLITE_FCNTL_PRAGMA file-control returns anything other than SQLTIE_NOTFOUND and SQLITE_OK, then treat the result as an error. check-in: 56436181 user: drh tags: file-control-pragma
19:03
Disable the "filename" pragma implemented by os_unix.c except when compiled with SQLITE_TEST. check-in: 9a1da918 user: drh tags: file-control-pragma
18:21
Make benign any malloc failures inside the sqlite3_file_control() call within PRAGMA parsing. Add a couple simple tests for SQLITE_FCNTL_PRAGMA. check-in: a1f29fa6 user: drh tags: file-control-pragma
16:58
Change the SQLITE_FCNTL_PRAGMA file-control so that it can return a string value. check-in: fd8d7440 user: drh tags: file-control-pragma
14:45
Begin adding support for SQLITE_FCNTL_PRAGMA. check-in: 5be07904 user: drh tags: file-control-pragma
2012-02-21
18:35
Avoid redefining NDEBUG if the fuzzer is included in an amalagmated source file. check-in: f8ac826f user: drh tags: trunk
18:00
Prevent the fuzzer from ever returning a string longer than 100 bytes. check-in: 969095ca user: dan tags: trunk
14:11
Further fuzzer test cases. Fix a case in the fuzzer where an error code was being dropped. check-in: 8b77d395 user: dan tags: trunk
10:36
Add further test cases and minor fixes for the fuzzer. check-in: 583dde93 user: dan tags: trunk
2012-02-20
22:44
Updates to the instructions in the header comment of the fuzzer implementation. New test cases for the fuzzer. check-in: bf1dc790 user: drh tags: trunk
20:03
Change the way the fuzzer (test_fuzzer.c) works so that it loads its configuration from a database table. check-in: 90b7b957 user: dan tags: trunk
19:36
Fix a case in test_fuzzer.c causing transformations from the wrong ruleset to be applied in some cases. check-in: cb5f5ebc user: dan tags: trunk
2012-02-14
18:56
Increase the maximum ruleset id in the fuzzer from 50 to 2^31-1. check-in: 760e009a user: drh tags: trunk
15:34
Enhance the fuzzer virtual table to support multiple rule sets. check-in: a8293873 user: drh tags: trunk
2012-02-13
21:24
Merge the non-blocking ROLLBACK changes into trunk. check-in: 9c572d42 user: drh tags: trunk
20:28
Fix a harmless compiler warning introduced by the previous check-in. check-in: a8a042a7 user: drh tags: trunk
20:16
On unix, ignore the umask when creating journal files. That way, journal files will have exactly the same permissions as the original database and any process that has permission to write to the database can also recover hot journals. check-in: 84b32460 user: drh tags: trunk
17:01
Add the new SQLITE_ABORT_ROLLBACK extended error code to be returned for statements that are cancelled due to a rollback. Closed-Leaf check-in: 549f4fd0 user: drh tags: nonblocking-rollback
16:43
Change the ROLLBACK command so that pending statements to not block it. The pending statements instead return SQLITE_ABORT upon next access. Note: This causes separate shared-cache connections in read_uncommitted mode to abort as well. check-in: 9b66c79e user: drh tags: nonblocking-rollback
13:44
Generalize the interrupt mechanism so that individual statements can be interrupted and so that codes other than just SQLITE_INTERRUPT can be returned as a consequence of an interrupt. Closed-Leaf check-in: 922bcbb4 user: drh tags: generalize-interrupt
10:00
Changes to various test scripts so that veryquick.test runs with OMIT_COMPOUND_SELECT defined. check-in: 76bb649e user: dan tags: trunk
08:50
Fix a typo in the type of the fchown() function in os_unix.c. check-in: bfbfe05b user: dan tags: trunk
2012-02-11
23:55
Make fchown() an overrideable system call in os_unix.c. check-in: 98efac96 user: drh tags: trunk
22:19
Cleanup some directories and files left by the MinGW build, even when using the MSVC Makefile. check-in: 3ab89e25 user: mistachkin tags: trunk
21:56
Revise the preprocessor directives used to handle malloc.h and _msize, in order to detect and handle the MSVC special-case automatically. check-in: 90e73dc3 user: mistachkin tags: trunk
21:21
Silence GCC compiler warnings about unused return value from fchown(). check-in: b0225473 user: drh tags: trunk
19:53
Another attempt to fix warnings in the randomFunc() function. check-in: 768df4e1 user: drh tags: trunk
19:23
When creating journal files (including -wal and -shm files) try to set the ownership to be the same as the original database. This will prevent root from locking out the original owner of the file. check-in: 1254dffe user: drh tags: trunk
18:51
Remove a redundant test from the shared-memory logic in os_unix.c. check-in: 31142ca7 user: drh tags: trunk
2012-02-10
20:43
Fix a warning coming from the Solaris Studio compiler. check-in: 33294bbd user: drh tags: trunk
18:18
Pull the latest trunk changes into the apple-osx branch. check-in: e2485986 user: drh tags: apple-osx
17:54
Pull all the latest trunk changes into the sessions branch. check-in: 361fb66a user: drh tags: sessions
17:38
Disable the ability to have multiple values in the VALUES clause of an INSERT statement when SQLITE_OMIT_COMPOUND_SELECT is used. check-in: 92131195 user: drh tags: trunk
03:10
Fix an important bug in the handling of EINTR in unixRead(). Never came up on x86 but crashes on sparc. check-in: 1a16db0b user: drh tags: trunk
01:25
Fix a boundary case for the integer affinity routine for non-x86 processors. check-in: bea05ddd user: drh tags: trunk
2012-02-08
12:13
Add an autoconf test for malloc.h and use the results of that test to conditionally #include the malloc.h header file. check-in: 16a47112 user: drh tags: trunk
2012-02-07
14:22
Port the command-line shell enhancements including the new --cmd option to the nx-devkit branch. check-in: 81ce52af user: drh tags: nx-devkit
14:13
Command-line shell enhancements: Reorganize the "usage" comment so that options are in alphabetical order. Add the new "--cmd" option. Allow either "--option" or "-option" for options. check-in: 9497893b user: drh tags: trunk
2012-02-02
21:02
More structure packing for smaller objects and less memory usage. check-in: f14e7f29 user: drh tags: trunk
19:37
Reduce the size of the MemPage object by about 32 bytes. Other structure size optimizations. check-in: 21695c34 user: drh tags: trunk
18:46
When non-aggregate columns occur in an aggregate query with a single min() or max(), then the values of the non-aggregate columns are taken from one of the rows that was the min() or max(). check-in: fa13edd3 user: drh tags: trunk
18:42
Fix a problem with NULL handling in aggregate min/max when returning values from the row containing the min or max. Closed-Leaf check-in: f27c7b4f user: drh tags: output-minmax-row
17:35
For queries of the form "SELECT p, max(q) FROM t1", the value of column p returned is the one on the same row that holds the maximum value of q. check-in: adb29232 user: drh tags: output-minmax-row
15:50
Data structure cleanup. Remove unused fields. Rearrange other files for tighter packing and reduced memory usage. check-in: 0bc594e8 user: drh tags: trunk
03:38
Simplified array allocation in the IdList and AggInfo objects. check-in: 25df2a74 user: drh tags: trunk
03:11
Fix a possible segfault after an OOM fault. This has been in the code for ages but only expressed itself following the previous check-in. check-in: a3553b8a user: drh tags: trunk
01:58
Remove the nAlloc field from the ExprList object. check-in: 5963de30 user: drh tags: trunk
2012-02-01
19:03
Very small performance enhancement and reduction in size of the sqlite3_stmt object. check-in: a38d57a4 user: drh tags: trunk
01:13
Fix ALTER TABLE RENAME so that it correctly handles triggers that attach to the table using the name in a different case. Ticket [ae6794effd404]. check-in: 0d78ebb8 user: drh tags: trunk
2012-01-31
23:34
Fix a compiler warning in FTS4. check-in: b4cad1ce user: drh tags: trunk
14:24
Futher pedantic fixes to the sqlite3_uri_boolean() interface. check-in: 77b3430d user: drh tags: trunk
13:35
Improvements to the documentation for sqlite3_uri_boolean(). check-in: b0a16179 user: drh tags: trunk
05:11
Change a comment in test script backup.test. check-in: 313546b4 user: dan tags: trunk
2012-01-30
18:40
Bring the documentation and implementation of sqlite3_uri_boolean() into closer agreement. Ticket [5f41597f7c9c] check-in: 7b053d69 user: drh tags: trunk
18:00
Fix compiler warnings in the TCL test harness. check-in: c4cd38a0 user: drh tags: trunk
16:13
Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. check-in: 4f0997c7 user: drh tags: nx-devkit
16:02
Do not rely on the _WIN32_WINNT macro as vs2005 does not define it by default. Instead, always assume winNT unless the makefile explicitly sets SQLITE_OS_WINNT=0. check-in: 1ce4d21d user: drh tags: trunk
2012-01-28
21:08
Update the .dump command of the command-line shell so that it (1) avoids putting the semicolon of a DDL statement on the same line as a comment, (2) avoids long expression, even when dumping a table with many columns, and (3) avoids unnecessary quoting of the table name. This fixes tickets [c04a8b8a4f] and [232637c465]. Shell change only; no changes to the SQLite core. check-in: e6eea8d5 user: drh tags: trunk
19:44
Remove a couple of unnecessary nonterminals from the grammar. check-in: 2b2a7d8d user: drh tags: trunk
19:41
Add support for IF NOT EXISTS on CREATE VIRTUAL TABLE. check-in: 230983e8 user: drh tags: trunk
15:26
Update the version number to 3.7.11 and rerun autoconf. check-in: 6f9b265d user: drh tags: trunk
15:22
Add support for multiple rows of VALUES in an INSERT statement. check-in: eb3b6a0c user: drh tags: trunk
2012-01-25
22:08
Cherrypick the FTS fix in [c05c3fd20d9] into the nx-devkit branch. Ticket [edb497982c]. check-in: 2a7170f0 user: drh tags: nx-devkit
20:43
Only invalidate the schema when the OP_ParseSchema opcode fails, not on any general failure of a vdbe program. check-in: 11f68d99 user: drh tags: trunk
16:29
Fix an FTS problem triggered by querying for an N character prefix using an N+1 character prefix index after rows have been deleted from the FTS table. Fix for [edb497982c]. check-in: c05c3fd2 user: dan tags: trunk
2012-01-24
10:08
Changes to the async-io module so that the xFileControl method returns SQLITE_NOTFOUND when a file-control is not recognized and so that it adds the second nul-terminator byte to filenames passed to the xOpen method of the underlying VFS. check-in: 7036886e user: dan tags: trunk
2012-01-20
15:05
Cherrypick the fix from [629108c8e5376f989] into the nx-devkit branch. check-in: d7374568 user: drh tags: nx-devkit
2012-01-19
16:57
Make the use and function of SQLITE_DYNAMIC clearer. Add assert() statement to help ensure that SQLITE_DYNAMIC is not misused. check-in: ab80f2c3 user: drh tags: trunk
2012-01-18
18:22
Avoid overriding the malloc_usable_size symbol using the C preprocessor as this might be confusing the build on some systems. check-in: bbaec351 user: drh tags: trunk
12:46
Add the SQLITE_WITHOUT_MSIZE and SQLITE_WITHOUT_ZONEMALLOC macros in mem1.c to disable the use of _msize() on windows and the zone memory allocator on Apple products, respectively. check-in: 238e35a4 user: drh tags: trunk
01:14
Remove a redundant assignment from the VM. check-in: d0dabe2f user: drh tags: trunk
01:09
Fix typo in comment. check-in: 199edb68 user: mistachkin tags: trunk
2012-01-17
15:29
Remove the undocumented PRAGMA omit_readlock hack. check-in: 96900c47 user: drh tags: trunk
2012-01-16
16:56
Enhance the command-lin shell to interpret CSV files as described by the wikipedia article on CSV. check-in: 93aa17d8 user: drh tags: trunk
16:39
Test the fts4 content and prefix options together. check-in: de11cd5c user: dan tags: trunk
13:28
Version 3.7.10 check-in: ebd01a8d user: drh tags: trunk, release, version-3.7.10
13:00
Rebuild the configure script using autoconf 2.68 since autoconf 2.65 (previously used) appears to build incorrect scripts for Mac. check-in: 9da1cd0a user: drh tags: trunk
12:33
Support building with SQLITE_ENABLE_SESSION under MSVC. check-in: 2845654d user: mistachkin tags: sessions
2012-01-14
14:13
Merge the latest trunk changes into the apple-osx branch. check-in: 2cc414cd user: drh tags: apple-osx
13:50
Update sessions branch with latest changes from trunk. check-in: 01c84fd3 user: dan tags: sessions
03:34
Make sure the EXTERN macro is properly defined when building targets that require it (e.g. on MinGW). check-in: 88ad2f23 user: mistachkin tags: trunk
00:42
In the multiplexor routine that determines the size of an overflow file, return 0 and leave the error code unchanges if there were prior errors. This prevents some I/O errors from going unreported in nx-devkit tests. check-in: 6da0821a user: drh tags: trunk
2012-01-13
16:48
Fix documentation typos. No changes to code. check-in: 0b857613 user: drh tags: trunk
16:16
Add the -uri option to the usage comment that is printed by the "sqlite3" TCL command when an unknown command-line option is supplied. check-in: 7987e285 user: drh tags: trunk
15:50
Update the documentation for the sqlite3_uri_*() routines to make it clear that there argument must be a database filename passed into xOpen(). No changes to code. check-in: 08230a3a user: drh tags: trunk
15:21
Fix backup2.test so that it passes on OpenBSD (which produces a slightly different error message in one case). check-in: 227cfe11 user: dan tags: trunk
14:50
Do not throw an error from within test_journal.c if a database file size is not an integer multiple of the page-size. check-in: 3f4899a9 user: dan tags: trunk
10:51
Omit test file zerodamage.test from the inmemory_journal permutation. check-in: 0c0051b1 user: dan tags: trunk
10:04
Fix test case issues related to errors in file-controls and the PSOW flag. check-in: 5afbcd49 user: dan tags: trunk
2012-01-12
16:41
Fix issues in test cases so that they work with DEFAULT_AUTOVACUUM defined. And with a small default cache-size. check-in: a298465c user: dan tags: trunk
15:05
Fix typos in a testcase() macro introduced by the previous commit. check-in: 0467742f user: dan tags: trunk
14:25
Remove some assert() statements that can fail with corrupt databases. check-in: 7654ae71 user: dan tags: trunk
2012-01-11
16:16
Remove code made unreachable by the enhancement of the previous check-in. check-in: 9e31a275 user: drh tags: trunk
15:47
Make the pager less vulnerable to problems caused by shifting sector sizes when rolling back a hot journal. check-in: 629108c8 user: drh tags: trunk
11:20
Fix the sqlite3_quota_file() function in test_quota.c so that it adds the second nul-terminator to all file names that will be passed to a VFS xOpen method. check-in: 3013f9a6 user: dan tags: trunk
01:01
Prevent winOpenSharedMemory from masking the real return code from its call to winOpen. Also, add asserts to check the double-zero termination of database file names. check-in: 93a65776 user: mistachkin tags: trunk
00:38
Make sure filenames handed to the VFS by the fake_big_file test procedure are double-zero terminated. check-in: d0a86860 user: drh tags: trunk