Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
121 check-ins using file src/pragma.c version 216d12e4
|
2010-11-19
| ||
| 18:20 | Add file test_superlock.c with example code for obtaining an exclusive lock on either rollback or wal mode databases. Closed-Leaf check-in: 1a3e7417 user: dan tags: superlock | |
| 14:37 | Add the SQLITE_FCNTL_FILE_POINTER verb to sqlite3_file_control(). check-in: 4425b064 user: drh tags: superlock | |
|
2010-11-18
| ||
| 16:58 | Ensure tcl is using utf-8 as the system encoding when running capi3e.test. check-in: 0a95589f user: dan tags: trunk | |
| 15:44 | Added some tests to check that umlaut characters are supported in filenames. check-in: c36f275d user: shaneh tags: trunk | |
| 13:52 | Restrict the scope of the fts3ExprCost() subroutine inside of FTS3. check-in: 76681870 user: drh tags: trunk | |
| 13:47 | Fix compiler warnings. check-in: 6c4f1d5c user: drh tags: trunk | |
| 12:31 | Prevent a possible segfault when the sqlite3_value_numeric_type() interface is misused to try to determine the numeric type of the NULL value returned from sqlite3_column_value() with an invalid column number. check-in: 501b743b user: drh tags: trunk | |
|
2010-11-17
| ||
| 02:02 | Restrict the scope of the sqlite3_stmt_readonly() interface to a specific subset of prepared statement types. check-in: 919b06c3 user: drh tags: trunk | |
|
2010-11-16
| ||
| 23:10 | Adding the sqlite3_stmt_readonly() interface. check-in: fd5b2f23 user: drh tags: trunk | |
| 02:49 | Use the estimated number of rows computed for subqueries in the cost computations for outer queries. check-in: 56bbc539 user: drh tags: trunk | |
|
2010-11-15
| ||
| 21:50 | Change the EQP output for the min/max optimization from "SCAN" to "SEARCH". Other changes in where.c in support of full branch coverage testing. check-in: d52b5939 user: drh tags: trunk | |
| 16:29 | Fix the EQP logic so that it correctly reports OOM errors while formatting "detail" text. check-in: 136c2ac2 user: drh tags: trunk | |
| 16:12 | Change some test cases to account for the new EXPLAIN QUERY PLAN output. check-in: 88a854e1 user: dan tags: trunk | |
| 14:51 | Test some example code from documentation page eqp.html. check-in: 547bc2c2 user: dan tags: trunk | |
| 14:44 | Merge the EXPLAIN QUERY PLAN changes from experimental into trunk. check-in: ce27bf38 user: drh tags: trunk | |
| 11:35 | Minor additions to vacuum.test. check-in: a397ed16 user: dan tags: trunk | |
|
2010-11-13
| ||
| 16:42 | Change the EXPLAIN QUERY PLAN output to use "USING INDEX" instead of "BY INDEX", and to use "SEARCH" instead of "SCAN" for loops that are not full-table scans. Closed-Leaf check-in: 6611b76b user: dan tags: experimental | |
|
2010-11-12
| ||
| 17:41 | Add EXPLAIN QUERY PLAN test cases to check that the examples in the documentation work. check-in: 85fdad85 user: dan tags: experimental | |
| 15:49 | Change the test_multiplex.c code to use wrapper functions for all sqlite3_vfs methods (instead of copying function pointers from the underlying vfs into the multiplex vfs). This is required to work with test_osinst.c. check-in: 1244ef9f user: dan tags: trunk | |
| 15:36 | Reduce the number of branches that need to be tested in the explainIndexRange() function of where.c. check-in: 6fdae9a6 user: drh tags: experimental | |
|
2010-11-11
| ||
| 17:48 | Use "COMPOUND" instead of "COMPOSITE" in the EXPLAIN QUERY PLAN output to describe UNION, UNION ALL, EXCEPT and INTERSECT operations. check-in: 28643b85 user: dan tags: experimental | |
| 16:46 | Add a row of EXPLAIN QUERY PLAN output for each composite select operation (UNION, EXCEPT etc.) in the query. check-in: 00fb8468 user: dan tags: experimental | |
| 11:43 | Fix a bug in the EXPLAIN QUERY PLAN code. check-in: 7ae06895 user: dan tags: experimental | |
| 10:36 | Modifications to test cases to account for new EXPLAIN QUERY PLAN output. check-in: 30904ef8 user: dan tags: experimental | |
|
2010-11-09
| ||
| 20:33 | Fix an assert that fired incorrectly when PRAGMA omit_readlock was set. check-in: e0687582 user: shaneh tags: trunk | |
| 17:49 | Merge with latest trunk changes. check-in: 4b5c93bc user: dan tags: experimental | |
| 17:35 | Add missing comments and fix other issues with routines used by new EQP features. check-in: 925f35c5 user: dan tags: experimental | |
| 14:49 | Further enhancements and fixes for explain query plan. check-in: 73c93f5a user: dan tags: experimental | |
|
2010-11-08
| ||
| 19:16 | Changes to the multiplex VFS to optionally (compiler define) allow the "chunk extension" to overwrite the right-most chars of the filename instead of simply being appended. check-in: 07da0a0b user: shaneh tags: trunk | |
| 19:01 | Experimental changes to EXPLAIN QUERY PLAN. check-in: f4747eb8 user: dan tags: experimental | |
|
2010-11-05
| ||
| 20:50 | Fix to xTruncate and more journal mode tests for the multiplex VFS. check-in: 65fa1164 user: shaneh tags: trunk | |
| 18:07 | Fix os_unix.c so that it works with the test_multiplex module. check-in: 72ba3e36 user: dan tags: trunk | |
| 17:51 | More tests and added support for xDelete in multiplex VFS. check-in: f2004b44 user: shaneh tags: trunk | |
| 03:58 | Additional error checking and tests for multiplex VFS. check-in: 1ab9a592 user: shaneh tags: trunk | |
| 03:43 | Additional tests and commenting for the multiplex VFS. check-in: 8ed944ba user: shaneh tags: trunk | |
| 00:04 | Update the configure script for version 3.7.4. check-in: 18a73795 user: drh tags: trunk | |
| 00:01 | Merge the multiplexer VFS demo into the trunk. check-in: 1635d927 user: drh tags: trunk | |
| 00:00 | Fix the Makefile.in so that it works with the multiplexer VFS. Closed-Leaf check-in: 54e2efb6 user: drh tags: experimental | |
|
2010-11-04
| ||
| 21:14 | Back out an unintended change to permutations.test. check-in: 57fe3535 user: drh tags: experimental | |
| 21:13 | Another change for testing on Windows. check-in: 2625886b user: shaneh tags: experimental | |
| 21:03 | Fix the main.mk makefile to include test_multiplex.c for testfixture. check-in: c27c5118 user: drh tags: experimental | |
| 20:50 | First attempt at a sharding VFS to split large DBs. check-in: dd4dc8a4 user: shaneh tags: experimental | |
| 20:47 | Fix icon size so it's really 32x32. check-in: 62c494f6 user: shaneh tags: experimental | |
| 20:46 | Updates for Windows. check-in: cc9d9a12 user: shaneh tags: experimental | |
| 04:47 | Include the print_pager_state() function only if SQLITE_DEBUG is defined. check-in: 3104f17e user: dan tags: trunk | |
|
2010-11-02
| ||
| 17:41 | Changes to allow FTS4 tables to be created without the underlying %_docsize table (in order to save space). check-in: 31989b18 user: dan tags: trunk | |
| 15:26 | Add evidence marks for the sqlite3_blob_reopen() interface. Fix compiler warnings in test1.c. Fix incorrect evidence marks on e_select.tcl. check-in: 3771faa8 user: drh tags: trunk | |
|
2010-11-01
| ||
| 18:45 | Add test cases to restore coverage of pager.c and wal.c. check-in: 6cae5529 user: dan tags: trunk | |
| 17:38 | If a database file with the WAL flag set is opened in exclusive-locking mode, use heap memory to store the wal-index instead of shared-memory. check-in: 8dd5c691 user: dan tags: trunk | |
| 14:34 | Change the version number to 3.7.4. check-in: db64843b user: drh tags: trunk | |
| 05:54 | Fix a broken test case in exclusive.test. check-in: 582db832 user: dan tags: trunk | |
| 05:42 | Changes to test scripts so that they work with SQLITE_ENABLE_ICU. check-in: 465c819f user: dan tags: trunk | |
|
2010-10-31
| ||
| 22:47 | Fix a test module comment typo reported on the mailing list. check-in: 87eb1f04 user: drh tags: trunk | |
| 22:42 | Fix a typo in a comment inserted by the amalgamation builder. Typo reported on the mailing list. check-in: 6a6bb6ce user: drh tags: trunk | |
|
2010-10-30
| ||
| 15:21 | Test cases and minor changes to make fts3 more robust in the face of a corrupt database. check-in: b7702905 user: dan tags: trunk | |
|
2010-10-29
| ||
| 18:45 | Add extra test cases and changes to fts3 to avoid crashing on a corrupt database. check-in: 252f0e45 user: dan tags: trunk | |
|
2010-10-28
| ||
| 15:52 | Add new "dynamic_triggers" test case to threadtest3.c. check-in: a4691563 user: dan tags: trunk | |
| 15:49 | This was suppose to go on "trunk" but got committed to the wrong branch. Add new "dynamic_triggers" test case to threadtest3.c. Closed-Leaf check-in: d9e588ef user: dan tags: mistake | |
| 11:31 | Enforce the MAX_EXPR_DEPTH limit while building expression trees during SQL parsing. check-in: 2625eee0 user: dan tags: trunk | |
|
2010-10-27
| ||
| 19:23 | Add tail recursion to the sqlite3ExprDelete() routine in order to keep down stack space usage for really, really large expressions. Later: The tail recursion is dangerous since the recursion might happen after the expression has been freed. check-in: 7324c7f2 user: drh tags: mistake | |
| 19:08 | Avoid trying to allocate a negative number of bytes of memory in the test wrapper for sqlite3_blob_read(). check-in: 739b5d9a user: dan tags: trunk | |
| 18:10 | Merge experimental fts3/fts4 changes with trunk. check-in: 988164cf user: dan tags: trunk | |
| 16:52 | Fix a buffer overread in fts3 that can occur if the database is corrupt. Closed-Leaf check-in: 84194c41 user: dan tags: experimental | |
| 15:36 | Fix a memory leak in the update_hook method of the TCL interface. check-in: 1d17e3dc user: drh tags: trunk | |
| 10:55 | In fts4, store the total number of bytes of for all records in the table in the %_stat table. check-in: 941647d1 user: dan tags: experimental | |
|
2010-10-26
| ||
| 18:42 | Structural coverage tests for vdbeblob.c. Including experimental new API sqlite3_blob_reopen(). check-in: 97c6b261 user: dan tags: experimental | |
| 11:56 | Add missing header comments for changes related to the experimental sqlite3_blob_reopen() API. check-in: d1cc5c93 user: dan tags: experimental | |
| 07:14 | More coverage tests for fts3.c. check-in: 7a2f2864 user: dan tags: experimental | |
|
2010-10-25
| ||
| 19:01 | Further improvements to coverage of fts3.c. Fixes for bugs revealed by the same. check-in: 918b6092 user: dan tags: experimental | |
| 12:47 | Test coverage improvements for fts3.c. check-in: a8b1d998 user: dan tags: experimental | |
| 09:01 | Add test for matchinfo when a phrase includes some common tokens. check-in: 80a54ebc user: dan tags: experimental | |
|
2010-10-23
| ||
| 19:07 | Fixes for the matchinfo() function related to FTS4 common token handling. check-in: deb80eac user: dan tags: experimental | |
|
2010-10-22
| ||
| 19:03 | Add new test file fts3defer2.test. check-in: 5a4d5bfc user: dan tags: experimental | |
| 16:44 | Add missing comments and fix compiler warnings in new FTS3/4 code. Other minor fixes too. check-in: 1c9c70fe user: dan tags: experimental | |
| 13:55 | Prevent an assert from failing when opening a zero-length database file with an apparently hot journal with locking_mode=exclusive set. check-in: f000ac1e user: dan tags: trunk | |
|
2010-10-21
| ||
| 22:58 | Make sure the estimated row count for ephemeral tables is initialized so that automatic indices can be used on those tables. check-in: d30f7b2d user: drh tags: trunk | |
| 15:49 | Merge trunk changes into experimental branch. check-in: fd1e5cad user: dan tags: experimental | |
| 15:12 | Fix some segfaults that could occur in obscure circumstances where error messages contained characters that could be mistaken for printf format specifiers. check-in: f91471e7 user: dan tags: trunk | |
| 12:34 | Fix a typo-bug that prevented --disable-amalgamation from working in Makefile.in. Also fix an overly long line in Makfile.in. check-in: 2c3c4ba0 user: drh tags: trunk | |
| 03:13 | Add new WHERETRACE macros for better diagnostics of the query planner. Added a new test case for the performance regression fixed by the previous check-in. check-in: 1e0db997 user: drh tags: trunk | |
| 02:05 | Fix the query planner so that it uses the multi-index OR-clause solution if that is the lowest cost estimate. A prior bug cause the multi-index solution to be ignored in some circumstances. check-in: 28ba6255 user: drh tags: trunk | |
|
2010-10-20
| ||
| 18:56 | Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. check-in: d0a450ce user: dan tags: experimental | |
|
2010-10-19
| ||
| 14:08 | Experimental changes to fts4 to try to selectively avoid loading very large doclists. check-in: 5ae0ba44 user: dan tags: experimental | |
|
2010-10-14
| ||
| 01:17 | Avoid taking locks on unused database connections when committing a read transaction. check-in: c0ee614f user: drh tags: trunk | |
| 01:16 | Check-in [d3c95e3a4e08d0] was incorrect. This is the correct fix for sqlit3_bind_blob(). Ticket [860399cc408f2dd5f4] check-in: ea8c2f5f user: drh tags: trunk | |
|
2010-10-12
| ||
| 02:13 | Fix the sqlite3_bind_blob() interface (and its kin) so that the destructor is invoked if the binding fails. Ticket [860399cc408f2dd5f41aed44b] Update the documentation to explain which interfaces invoke their destructors on failure and which do not. check-in: d3c95e3a user: drh tags: trunk | |
|
2010-10-11
| ||
| 17:58 | Make sure the sqlite3_create_collation() interfaces always return an error code if they fail. Ticket [a04e42a3fcacaffa3133436]. check-in: 6464276e user: drh tags: trunk | |
| 17:57 | Further changes to extension loading to support compile-time options. check-in: f818fb6f user: drh tags: trunk | |
| 13:12 | Make APIs added since version 3.6.0 accessible to loadable extensions. check-in: 76c64a35 user: drh tags: trunk | |
|
2010-10-08
| ||
| 16:09 | Add tests to e_createtable.test. check-in: 38bec827 user: dan tags: trunk | |
| 02:34 | Version 3.7.3 check-in: 26778480 user: drh tags: trunk, release | |
|
2010-10-07
| ||
| 13:29 | Update the CLI test script to expect a version number of 3.7.3. check-in: e55ada89 user: drh tags: trunk | |
|
2010-10-06
| ||
| 20:25 | Update the configure script and Makefile so that they work with 3.7.3. check-in: 97b63a11 user: drh tags: trunk | |
| 18:55 | Fix long-standing bugs with the handling of LIMIT clausing in compound SELECT statements with FROM clause subqueries. Ticket [38cb5df375078d3f9]. check-in: b0450120 user: drh tags: trunk | |
| 16:42 | Fix minor test suite problems causing errors on OSX. check-in: 759c954f user: dan tags: trunk | |
| 09:57 | Fix a bug in test code that was causing a valgrind error. No changes to production code. check-in: f29da7be user: dan tags: trunk | |
|
2010-10-05
| ||
| 18:22 | Do not embedded #if inside an assert() statement. Fix for check-in [dca8763872a] check-in: d7d4a94f user: drh tags: trunk | |
| 17:02 | Have the pager change to at least WRITER_CACHEMOD state before marking any pages as dirty (instead of immediately after). Otherwise, if an error occurs, the pager may be left in WRITER_LOCKED state with dirty pages in the cache. check-in: 471a4efb user: dan tags: trunk | |
| 15:41 | If walLockExclusive() fails for reasons other than SQLITE_BUSY inside of walRestartLog() then propagate that error back up to the application. check-in: 04dcba6b user: drh tags: trunk | |
| 12:05 | Avoid all memory allocation (and hence the possiblitity of OOM failure) in sqlite3_value_double() and sqlite3_column_double(). check-in: 4afdf970 user: drh tags: trunk | |
| 11:33 | Fix an assert() failing on OSX. check-in: dca87638 user: dan tags: trunk | |
| 08:13 | Prevent backcompat.test from mistaking directories for binary executables. check-in: 717a1e50 user: dan tags: trunk | |
|
2010-10-04
| ||
| 23:55 | Fix a performance regression (relative to version 3.6.23.1) caused by the query planner taking into account non-indexable WHERE clause terms to select the outermost join loops when it should be selecting tables for the outermost loop that do not benefit from being in an inner loop. check-in: ece641eb user: drh tags: trunk | |
| 16:06 | Fix a couple of test script problems. check-in: dd106901 user: dan tags: trunk | |
| 15:47 | Fix memsubsys1.test so that it works with TEMP_STORE>=2. check-in: 8ad88ee0 user: dan tags: trunk | |
| 14:11 | Warning cleanup from MSVC. check-in: cde62657 user: shaneh tags: trunk | |
| 11:01 | Fix broken evidence marks in e_expr.test. check-in: 37ff94ce user: dan tags: trunk | |
| 10:45 | Add tests for table-constraints to e_createtable.test. check-in: 70f51187 user: dan tags: trunk | |
|
2010-10-01
| ||
| 19:04 | Add tests for CHECK and UNIQUE constraints to e_createtable.test. check-in: fb8db558 user: dan tags: trunk | |
| 17:23 | Add #ifndef USE_SYSTEM_SQLITE...#endif around the bundled SQLite library for the TCL bindings. check-in: 8d85584a user: drh tags: trunk | |
| 15:11 | Not true: For a zeroblob, the Mem.z pointer can be null: The Mem.z pointer can never been NULL for a string or blob, even a zero-length string or blob. Assert this fact. Closed-Leaf check-in: efda3104 user: drh tags: mistake | |
| 13:28 | Updates to the showjournal.c utility in order to bring it up to version 3. check-in: fa97d895 user: drh tags: trunk | |
|
2010-09-30
| ||
| 20:33 | Merge experimental into trunk: Refactor the text-to-numeric conversion routines to work without zero-terminators and in UTF16 as well as UTF8. Avoid invalidating strings with doing affinity conversions. check-in: 07ee080e user: drh tags: trunk | |
| 20:11 | Fix some matching issues in enc4.test affected by TCL versions. Closed-Leaf check-in: dd6d61a9 user: shaneh tags: experimental | |
| 18:30 | Fix memory leak in enc4.test script. check-in: bfc294ae user: shaneh tags: experimental | |
| 18:19 | Additional encoding tests. check-in: c7f93636 user: shaneh tags: experimental | |
| 18:12 | Remove unnecessary calls to memAboutToChange() in vdbe.c. An affinity change no longer invalidates shallow copies. check-in: afb0fd0b user: drh tags: experimental | |
| 17:33 | Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. check-in: ca154f97 user: drh tags: experimental | |
| 16:51 | Changes to remove sqlite3FitsIn64Bits(). check-in: 43fef1ca user: shaneh tags: experimental | |
| 14:48 | Fix the handling of default values for ALTER TABLE ADD COLUMN columns so that is able to deal with negative numbers, including large negative numbers. Ticket [8454a207b9fd2243c4] check-in: ce6cc16e user: drh tags: experimental | |
| 00:50 | Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. check-in: 14eed3a0 user: drh tags: experimental | |