/ 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.

138 check-ins using file src/pragma.c version 49c90ab2

2011-12-23
11:07
Fix a problem with [f9c4a7c8f4] as applied to this branch. Leaf check-in: e6a04bf9 user: dan tags: branch-3.7.6
2011-12-22
18:44
Backport the fixes for Coverity-discovered problems in [1c27d84216], [676acce274], and [f9c4a7c8f4] from trunk to the 3.7.6 branch. check-in: a61786e7 user: drh tags: branch-3.7.6
2011-06-21
15:58
Give the osLocaltime() function file scope in date.c. check-in: 1abce55a user: dan tags: branch-3.7.6
15:15
Backport the localtime() failure fix of ticket [bd484a090c8077] to the 3.7.6 branch. check-in: 5d4b0c5b user: drh tags: branch-3.7.6
2011-05-19
13:26
Version 3.7.6.3. check-in: ed1da510 user: drh tags: release, branch-3.7.6, version-3.7.6.3
01:46
Backport the [67bf1c9a88] fix for vanishing WAL transactions due to small cache spillage. Ticket [2d1a5c67dfc236]. Also bump the version number to 3.7.6.3 in preparation for patch release. check-in: e4d0f7ac user: drh tags: branch-3.7.6
2011-05-17
19:43
Fix an off-by-one error in the new sqlite3_uri_parameter() function. check-in: 9593a640 user: drh tags: trunk
18:53
Add the sqlite3_uri_parameter() interface function for use in building new VFSes. check-in: 6b5de95f user: drh tags: trunk
15:56
Add extended return code SQLITE_CORRUPT_VTAB. Returned when the tcontents of the sqlite tables used internally by a virtual table module are invalid or inconsistent. check-in: 8844e8bf user: dan tags: trunk
15:21
Avoid exceeding array bounds when reading a corrupt database file in autovacuum mode. Fixes a problem discovered by John Regehr and Peng Li using a customized clang compiler. check-in: f7c525f5 user: drh tags: trunk
14:41
Avoid including fts3_term.c in the amalgamation, as it contains test code only. check-in: f392b7ae user: dan tags: trunk
2011-05-16
21:00
Enhance WAL mode so that the WAL file honors the journal size limit set by PRAGMA journal_size_limit. check-in: db7e500f user: drh tags: trunk
2011-05-13
18:51
Make arrangements so that virtual table inserts into shadow tables do not modify the sqlite3_last_insert_rowid() return. Document that this is how sqlite3_last_insert_rowid() works. check-in: e569f18b user: drh tags: trunk
17:11
Rather than document goofy behavior, it seems better to make the behavior less goofy. (Was: Updates to the sqlite3_last_insert_rowid() documentation - to make it clear that the function does not work for virtual tables.) Closed-Leaf check-in: f88dfac3 user: drh tags: mistake
17:11
Also add fts3_term.c to main.mk. check-in: 966f2d2c user: drh tags: trunk
2011-05-12
21:01
Add fts3_term.c to amalg gen script and configure input files. check-in: 6ee07732 user: shaneh tags: trunk
2011-05-11
20:54
Improvements to documentation hyperlinks. Change the value of SQLITE_OPEN_URI to an unreserved value. check-in: 851ab75d user: drh tags: trunk
19:00
URI filename documentation updates. check-in: 8885c867 user: drh tags: trunk
17:36
Add missing comments associated with readonly shm changes. check-in: 6a2ea52e user: dan tags: wal-readonly
15:53
Merge latest trunk changes. Add a couple of readonly shm tests. check-in: cde45a03 user: dan tags: wal-readonly
14:57
Only open a read-only connection to shared-memory if the "readonly_shm=1" option is specified as part of the database file URI (and if a read-write connection fails). check-in: 671ba5fc user: dan tags: wal-readonly
2011-05-10
18:39
Have flags passed to sqlite3_open_v2() apply to the main and any attached databases. And change things so that any "mode=xxx" or "cache=xxx" options specified as part of a URI for the main database do not also apply to attached databases. check-in: 3e490915 user: dan tags: trunk
17:43
Update URI test cases to account for the new error message format. check-in: 5bde5680 user: dan tags: trunk
17:31
Add experimental support for read-only connections to WAL databases. check-in: bb59f986 user: dan tags: wal-readonly
14:52
Provide the ability to specify an alternative mutex subsystem at compile-time. - This check-in should have gone on the trunk, not on the 3.7.6 branch. Closed-Leaf check-in: 489c453d user: drh tags: mistake
10:17
Add new documentation keywords to the sqlite3_vfs description. check-in: ad3389a9 user: drh tags: trunk
2011-05-09
19:20
Return a suitable error message if the mode= argument to a URI specifies a higher mode than what is allowed by context. Other minor cleanups for the URI parsing logic. check-in: d9bc1c7f user: drh tags: trunk
2011-05-07
18:40
Set the sqlite3.mallocFailed flag if sqlite3ParseUri fails with SQLITE_NOMEM. check-in: ca3797d4 user: drh tags: trunk
18:18
Return SQLITE_MISUSE from the sqlite3_open_v2() function if the 3rd parameter is not a valid set of bit-values. check-in: 3c926ce0 user: drh tags: trunk
14:40
Fix minor compiler warnings. check-in: 139eecbe user: drh tags: trunk
2011-05-06
18:55
Merge the uri branch with the trunk. check-in: 88df33c4 user: dan tags: trunk
18:53
Remove some unnecessary modifications from the uri branch. Add a test to show that ATTACH only interprets its argument as a URI if the connection was opened with SQLITE_OPEN_URI (or URI interpretation is globally enabled). Closed-Leaf check-in: aa90b943 user: dan tags: uri
13:58
Merge windows test case fixes. No changes to code. check-in: 2e5c0ed7 user: dan tags: trunk
00:19
Increase the iVersion for sqlite3_module needed for the xSavepoint, xRelease, and xRollbackTo methods from 1 to 2. This is so that it will conform to published documentation. check-in: 0f4954e9 user: drh tags: trunk
2011-05-05
23:07
Fix an incorrect assert() in sqlite3_value_config(). Updates to the sqlite3_value_config() documentation. check-in: 22cbc01a user: drh tags: trunk
19:44
Changes to various test scripts so that they pass on windows. Closed-Leaf check-in: 1586244b user: dan tags: win32-test-fixes
17:41
Fix sqlite3_vtab_on_conflict() to return the correct values for ABORT, FAIL, and IGNORE. check-in: f0617d61 user: drh tags: trunk
17:00
Fix a bug in memory usage tracking that was introduced by check-in [4e33a0eaf83922]. check-in: 8ba456ae user: drh tags: trunk
15:46
Merge the latest trunk changes into the sessions branch. check-in: 6883580e user: drh tags: sessions
15:39
Bump the version number to 3.7.7 on account of the new sqlite3_vtab_config() and sqlite3_vtab_on_conflict() interfaces. Updates to the documentation on those interfaces. check-in: 930be6a1 user: drh tags: trunk
13:54
Change sqlite3_create_module() so that it avoids resetting the schema as long as preexisting modules are unchanged. check-in: 8485855a user: drh tags: trunk
13:53
Add a #include to test_demovfs.c in an effort to get it to compile on Solaris. check-in: 8f06ea33 user: drh tags: trunk
2011-05-04
17:23
Merge vtab-conflict branch with trunk. check-in: 8f9666af user: dan tags: trunk
16:30
Fix a couple of compiler warnings in the FTS code. Closed-Leaf check-in: 1a113359 user: dan tags: vtab-conflict
15:41
Fix a performance problem in queries that use "ORDER BY rowid DESC" and one or more FTS auxiliary functions. check-in: 95e09b20 user: dan tags: vtab-conflict
12:52
Optimize "ORDER BY rowid/docid DESC/ASC" clauses on FTS tables. check-in: 13395121 user: dan tags: vtab-conflict
2011-04-28
18:46
Have r-tree virtual tables support on-conflict clauses. check-in: 822ab52f user: dan tags: vtab-conflict
2011-04-27
19:54
In windows, ignore ERROR_NOT_LOCKED when calling the read-lock removal routine. check-in: f55156c5 user: drh tags: trunk
18:08
Change the name of an internal function to avoid conflicts with the math library. check-in: 1bd1484c user: drh tags: trunk
16:05
Expose the UTF8 to MBCS conversion routine in os_win.c to external applications. check-in: 7b479b9b user: drh tags: trunk
16:02
Add documentation for the newly introduced sqlite3_vtab_config() and on_conflict() API functions. Test that encountering an SQLITE_MISMATCH in fts3 does not corrupt the full text index. check-in: abdd70ae user: dan tags: vtab-conflict
12:08
Fix problems related to savepoint rollback and fts3. check-in: ff69f823 user: dan tags: vtab-conflict
01:00
Fix a comment typo. check-in: 19c6625a user: drh tags: trunk
2011-04-26
19:21
Extra tests for fts3. And fixes for conflict-handling related problems in fts3. check-in: fb4a3558 user: dan tags: vtab-conflict
2011-04-25
18:49
Add support for on conflict clauses to fts3/fts4. check-in: 6d2633a6 user: dan tags: vtab-conflict
18:20
Test case for the ".log" command to the command-line shell. check-in: 7d0ff26a user: drh tags: trunk
18:03
Add the (deliberately undocumented) sqlite_log() SQL function as a built-in. check-in: f7806e03 user: drh tags: trunk
18:01
Invoke the unix open() system call through a wrapper to avoid problems resulting from differing declarations to that function in various systems. check-in: 4c7ff4dd user: drh tags: trunk
2011-04-24
22:56
Disable the transfer optimization if the destination table contains any foreign key constraint and foreign key constraints are enabled. Ticket [6284df89debdf]. check-in: ddeea5ab user: drh tags: trunk
2011-04-22
22:55
Add the "getlock" utility for determining if a database file (on unix) is currently locked. check-in: 0ab24b13 user: drh tags: trunk
2011-04-20
13:35
Update a comment in e_createtable.test. check-in: d8b149f5 user: dan tags: trunk
2011-04-19
06:43
Avoid passing NULL to the xOpen method of an FTS3/4 tokenizer. check-in: 0dd09fc0 user: dan tags: trunk
2011-04-18
17:30
Merge trunk changes into sessions branch. check-in: b91b4c31 user: dan tags: sessions
15:47
Fix further missing comments and other minor issues in the session module code. check-in: 99f0f350 user: dan tags: sessions
12:05
Fix some missing comments and other issues with session module code. check-in: 20d7c280 user: dan tags: sessions
07:36
Further coverage tests for the session module. check-in: 69a01c70 user: dan tags: sessions
2011-04-17
17:25
Version 3.7.6.2 check-in: 154ddbc1 user: drh tags: release, version-3.7.6.2, branch-3.7.6
17:17
Bump the version number to 3.7.6.2 check-in: c429edf3 user: drh tags: branch-3.7.6
17:14
Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. check-in: 986f2f25 user: drh tags: branch-3.7.6
17:09
Change the prototype for the open() system call to agree with Posix. Though a faulty function prototype in a pointer cast is a seemingly innocuous error, the correct prototype is necessary for pthreads to work correctly on NetBSD. check-in: 3e135748 user: drh tags: trunk
00:55
Adjust some test cases in triggerC.test to handle non-default SQLITE_MAX_TRIGGER_DEPTH settings. check-in: 9d6c6129 user: shaneh tags: trunk
2011-04-16
19:23
Improve test coverage of session module. check-in: f46d4b64 user: dan tags: sessions
2011-04-15
21:37
Adjust test case in quota.test to handle Windows dir seperators. check-in: 75ed1bce user: shaneh tags: trunk
20:18
Updates to test code in os_win to bring winSync inline with unixSync (test code only). Updated a few test scripts to account for dirsync counting issues on Windows. check-in: 8f99c5bf user: shaneh tags: trunk
19:30
Remove stray semi-colon that MSVC complained about. check-in: 7a085271 user: shaneh tags: trunk
19:18
Improve coverage of session module. check-in: 3dfd1d63 user: dan tags: sessions
16:39
Changes to memory allocator usage tracking to delay the onset of integer overflow. check-in: 4e33a0ea user: drh tags: trunk
16:03
Add tests and fixes for OOM handling in sqlite3changeset_concat(). check-in: df0b2d21 user: dan tags: sessions
15:04
Have sqlite3changeset_concat() return SQLITE_SCHEMA if an attempt is made to concatenate changesets based on incompatible database schemas. check-in: 343b6451 user: dan tags: sessions
14:46
Do not do full table scans of unordered indices. check-in: a8761a91 user: drh tags: trunk
14:33
Fix #ifs involving SQLITE_ENABLE_LOCKING_STYLE so that they check the value of that macro and not whether it is defined. check-in: 8775f159 user: drh tags: trunk
13:29
Add retry logic to GetFileAttributesEx() on windows. Closed-Leaf check-in: 1cca9a49 user: drh tags: experimental
12:36
Make sure the unix backend returns SQLITE_FULL if write() fails with an ENOSPC error code. check-in: 721e3c16 user: drh tags: trunk
12:04
Add documentation for sqlite3changeset_concat() to sqlite3session.h. check-in: ada9efa5 user: dan tags: sessions
2011-04-14
18:01
Add further tests for the sqlite3changeset_concat() function. Also fixes. check-in: 1fc3f15d user: dan tags: sessions
11:16
Start adding the sqlite3changeset_concat() function to the session module. check-in: 8927b226 user: dan tags: sessions
2011-04-13
23:42
Remove extra CR and NL characters from FormatMessage() generated error messages in the windows VFS. check-in: 8332949c user: drh tags: trunk
20:26
Add new extended error codes for I/O errors on seek and shared-memory map. Add sqlite3_log() calls in the windows backend to record details of errors. check-in: fe603217 user: drh tags: trunk
16:52
Fix a usage comment typo in the showdb utility. check-in: 8744ced4 user: drh tags: trunk
14:40
Version 3.7.6.1 check-in: a35e83ea user: drh tags: trunk, release, version-3.7.6.1
14:02
Bump the version number to 3.7.6.1 in preparation for a bug-fix release. check-in: 5f0c394a user: drh tags: trunk
13:42
Make sure the array of overloadable system calls is always correctly sized, regardless of the compile-time configuration. Ticket [bb3a86e890c8e96ab]. check-in: c6e727ab user: drh tags: trunk
2011-04-12
01:58
Version 3.7.6. check-in: f9d43fa3 user: drh tags: trunk, release, version-3.7.6
2011-04-11
18:35
Do not override the fchmod system call in unix unless the SQLITE_ENABLE_LOCKING_STYLE compile-time option is engaged. check-in: 51029d84 user: drh tags: trunk
15:36
Updates to the OS/2 patches. This change also move the location of a global variable declaration in shell.c which might effect other build targets. check-in: 73906b67 user: drh tags: trunk
15:35
Fix a signed integer overflow problem in the testcase() macro. check-in: f18f5f58 user: drh tags: trunk
13:57
Apply OS2 WAL patch. Changes to os_os2.c only. check-in: eac17106 user: dan tags: trunk
05:38
Change exists.test to run all tests with and without "PRAGMA journal_mode=WAL". check-in: c4e624db user: dan tags: trunk
2011-04-10
16:39
Add a simple test program to aid in verifying that journals are cross-platform. check-in: a65a7a59 user: drh tags: trunk
2011-04-09
19:17
Add test file unordered.test. check-in: f346dae1 user: dan tags: trunk
18:07
Merge the latest trunk changes into the sessions branch. check-in: 83705e90 user: drh tags: sessions
17:53
Remove an always-true conditional. Replace it with an assert(). check-in: 1c2f0f84 user: drh tags: trunk
17:32
Add VerifyCookie instructions to "DROP XXX IF EXISTS" statements if the specified database object does not exist when the statement is prepared. check-in: a46f3290 user: dan tags: trunk
15:39
Add an OP_VerifyCookie instruction to "CREATE XXX IF NOT EXISTS" commands. This way, if the specified database object existed when the statement was compiled but removed from the database before sqlite3_step() was called, the statement still works as expected (and creates the object). check-in: b9dbd993 user: dan tags: trunk
03:20
If the keyword "unordered" appears at the end of the SQLITE_STAT1.STAT column for an index, then use that index for equality lookups only, never for range queries or sorting. This feature is currently undocumented and my change or be removed in a future release. check-in: 8a42e236 user: drh tags: trunk
03:04
Back out the SQLITE_OMIT_UNIQUE_ENFORCEMENT compile-option. It is an unneeded complication. check-in: 927e955b user: drh tags: trunk
02:34
When ATTACH-ing a new database to an existing database with a codec, do not enable the codec in the attached database if it is not enabled in the existing database and it is not requested by the USING clause. check-in: 4caa5fc8 user: drh tags: trunk
02:09
Do not do a backup if the number of reserved bytes in the source and destination do not match. Try to make the match, but if unable fail. check-in: 0ca8a233 user: drh tags: trunk
2011-04-08
21:35
Always make sure the left-hand side of the IS NOT NULL operator is a simple column, not a general expression, before applying the IS NOT NULL query optimization. check-in: 543f75a6 user: drh tags: trunk
18:47
Add some rtree tests to the backcompat.test script. check-in: 8ea3601c user: dan tags: trunk
17:22
Fix incrvacuum2.test so that it works with the inmemory_journal permutation. check-in: 7b8e1761 user: dan tags: trunk
2011-04-07
19:56
Change two new internal functions in where.c from global to file scope. check-in: 5bbfa17d user: drh tags: trunk
15:24
Add test case to verify [d03d63d77e] works. check-in: bf78acb9 user: dan tags: trunk
14:47
When searching a list of freelist trunk pages looking for a specific page to allocate, avoid unnecessary journalling of the unchanged trunk pages towards the start of the list. check-in: d03d63d7 user: drh tags: trunk
14:05
Avoid running thread1.test or thread2.test if SQLITE_MUTEX_NOOP is defined. check-in: 532ae32e user: dan tags: trunk
10:09
Do not run multi-threaded Tcl tests if the library was built with SQLITE_MUTEX_NOOP defined. check-in: e4e99606 user: dan tags: trunk
05:17
Fix test script attach4.test so that it works with type 1 VFS implementations (no wal). And wal.test so that it work with a small default pager cache size. check-in: 29c7b425 user: dan tags: trunk
03:41
Fix a couple of MSVC compiler warnings; check-in: 748c9109 user: shaneh tags: trunk
01:54
Fix an issue with an analyze test. No code changes. check-in: cddf79db user: shaneh tags: trunk
01:14
Fix typos in documentation comments. No changes to code. check-in: 9c64b5a9 user: drh tags: trunk
2011-04-06
23:40
Add a missing "extern C" terminator to the end of sqlite3session.h. check-in: 29090b69 user: drh tags: sessions
23:39
Fix VC++ compiler warnings. check-in: 7b7c8d36 user: drh tags: sessions
22:33
Merge in the latest changes from the trunk. check-in: 435b57dc user: drh tags: sessions
22:05
Fix a performance regression: Keep two btree masks in each prepared statement; one for btrees used and another for btrees that require locks. Only try to lock the btrees identified by the second mask. check-in: 614de91a user: drh tags: trunk
19:15
Fix a benign inaccuracy in the os_unix.c SQLITE_FCNTL_SIZE_HINT code. check-in: 61a6ccbe user: dan tags: trunk
17:54
Changes to support building with various SQLITE_OMIT_XXX options defined. check-in: 2039ed95 user: dan tags: trunk
12:38
Update a comment in sqliteLimit.h. No changes to code or tests. check-in: b7296fd3 user: dan tags: trunk
12:37
Add configurations featuring the -ftrapv switch and large values for SQLITE_MAX_ATTACHED to releasetest.tcl. check-in: 989588ab user: dan tags: trunk
2011-04-05
22:13
Merge the latest trunk changes into the sessions branch. check-in: 45f20261 user: drh tags: sessions
22:08
Suppress many harmless compiler warnings, mostly signed/unsigned comparisons within asserts or unused parameters in extensions. check-in: 3eeb0ff7 user: drh tags: trunk
19:27
Simplifications to the sqlite3BtreeEnterAll() and LeaveAll() routines. Just have them call BtreeEnter and BtreeLeave() repeatedly rather than trying to be clever. check-in: 51039b35 user: drh tags: trunk
19:26
Simplifications to the sqlite3ResetInternalSchema() logic to eliminate unreachable branches. check-in: a4c3ac98 user: drh tags: trunk
18:34
Remove dead code from the OP_JournalMode opcode in the VDBE. This code seems to have been useless since [f88c6367d2] on 2010-08-07. check-in: a89f24e2 user: drh tags: trunk
17:31
Remove the mutex counter and the logic that attempts to verify that btree mutexes are held continuously. We are not making that assumption at this time. check-in: 242ce7cf user: drh tags: trunk
16:09
When committing a WAL transaction, do not write any pages to the WAL file with page numbers greater than the size of the database image in pages. check-in: 311d0b61 user: dan tags: trunk
14:22
Fix a documentation typo. check-in: d25c17ef user: drh tags: trunk
13:27
Pull the latest trunk changes (and hence the schema-parse-refactor changes) into the sessions branch. check-in: 03ca8342 user: drh tags: sessions
13:12
Merge the scheme-parse-refactor changes into trunk: (1) added sqlite3SchemaMutexHeld() asserts, (2) Use -1 instead of 0 to mean "all" in sqlite3ResetInternalSchema(), and other cosmetic changes. check-in: 5db4511d user: drh tags: trunk