Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
16 descendants and 100 ancestors of 4407e15ac953cca0e33d76bd1e6500d70ae9cb239ea2d776a19a13f59532b3f6
2018-11-23
| ||
13:21 | Make the winTruncate() method of the windows VFS be a no-op if there are outstanding references to the memory-mapped pages. Otherwise, memory might be deleted out from under those references when the file is remapped during the truncate operation. (Leaf check-in: 8576ccb4 user: drh tags: branch-3.25) | |
2018-11-05
| ||
20:37 | Version 3.25.3 (check-in: 89e099fb user: drh tags: release, version-3.25.3, branch-3.25) | |
13:48 | Disable the IS NOT NULL optimization when the IS NOT NULL operator is part of the ON clause of a LEFT JOIN. Fix for ticket [65eb38f6e46de8c75e188a17ec]. (check-in: 8d09ce5d user: drh tags: branch-3.25) | |
13:43 | Add extra defenses against strategically corrupt databases to fts3/4. (check-in: 940f2adc user: drh tags: branch-3.25) | |
13:37 | Increase the version number to 3.25.3. (check-in: 1250ab8f user: drh tags: branch-3.25) | |
13:35 | Fix a assert() in the query planner that can arise when doing row-value operations on a PRIMARY KEY that contains duplicate columns. Ticket [1a84668dcfdebaf12415d]. (check-in: 1309c84a user: drh tags: branch-3.25) | |
2018-10-25
| ||
15:25 | In the WHERE-constraint propagation optimization, if there are duplicate constraint, make sure only one of them propagates. Proposed fix for ticket [cf5ed20fc8621b165]. (check-in: caebf879 user: drh tags: branch-3.25) | |
2018-10-01
| ||
14:05 | Fix a potential crash that can occur while reading an index from a corrupt database file. The corruption is a record-header-size that is larger than 0x7fffffff. Problem detected by OSSFuzz against GDAL and reported to us (with a suggested fix) by Even Rouault. The test case is in TH3. (check-in: 5d291658 user: drh tags: branch-3.25) | |
11:00 | Ensure that the OP_VColumn opcode does set sqlite3_vtab_nochange() unless the OPFLAG_NOCHNG bit is set in P5. Fix for ticket [69d642332d25aa3b7315a6d385] (check-in: 31ac8dba user: drh tags: branch-3.25) | |
2018-09-27
| ||
13:10 | Disallow the use of window functions in the recursive part of a recursive CTE. Fix for ticket [e8275b415a2f03bee]. (check-in: b2849570 user: drh tags: branch-3.25) | |
2018-09-25
| ||
19:08 | Version 3.25.2 (check-in: fb90e718 user: drh tags: release, version-3.25.2, branch-3.25) | |
13:52 | Fix a problem in releasetest.tcl causing configuration "Fast-One" to fail. (check-in: 32ac0014 user: dan tags: branch-3.25) | |
01:38 | Bump the version number to 3.25.2. (check-in: 996d74f5 user: drh tags: branch-3.25) | |
01:35 | Fix a compilation issue in the "userauth" extension. Also fix a few test script errors that occur with SQLITE_USER_AUTHENTICATION=1 builds. (check-in: e7db5f59 user: drh tags: branch-3.25) | |
01:17 | Fix a problem building on Android with SQLITE_ENABLE_BATCH_ATOMIC_WRITE set. (check-in: b9ffa77c user: drh tags: branch-3.25) | |
2018-09-24
| ||
21:07 | Avoid incrementing the SQLITE_LOOKASIDE_MISS_SIZE stat before sqlite3_open() returns. Fix test script problem in lookaside.test. (check-in: 3bd94e43 user: drh tags: branch-3.25) | |
20:50 | Fix missing space in 'configure.ac' reported on the mailing list. (check-in: 4407e15a user: drh tags: branch-3.25) | |
20:48 | Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. (check-in: 31dc8b19 user: drh tags: branch-3.25) | |
19:41 | Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. (check-in: 3139af99 user: drh tags: branch-3.25) | |
19:32 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. (check-in: 8694c3d5 user: drh tags: branch-3.25) | |
19:21 | Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. (check-in: 8a82fcf0 user: drh tags: branch-3.25) | |
18:29 | Fix a problem with views that use window functions as part of complex expressions. (check-in: 1c0ecbbd user: drh tags: branch-3.25) | |
14:51 | Fix a problem with views that use window functions as part of complex expressions. (check-in: 507d892c user: dan tags: trunk) | |
14:10 | Allow a writable virtual table to have a schema with an INTEGER PRIMARY KEY and WITHOUT ROWID. This fixes ticket [f25d5ceebe1d710ff61a571e395356869d8272ef]. Test case in TH3. (check-in: 5a38d928 user: drh tags: trunk) | |
2018-09-23
| ||
02:01 | Fix a faulty assert() in the validation logic for the LEFT JOIN strength reduction optimization. Problem found by OSSFuzz. (check-in: 2fd62fcc user: drh tags: trunk) | |
2018-09-20
| ||
20:15 | Add the "PRAGMA legacy_alter_table=ON" command to enable the pre-3.25.0 behavior of ALTER TABLE that does not modify the bodies of triggers or views or the WHERE clause of a partial index. Enable the legacy behavior by default when running the xRename method of virtual tables. (check-in: 7edd26ed user: drh tags: trunk) | |
2018-09-19
| ||
15:08 | Fix the "sqlite3" command in the TCL interface so that it correctly returns an error if invoked with no arguments. (check-in: 2034fa80 user: drh tags: trunk) | |
2018-09-18
| ||
20:20 | Version 3.25.1 (check-in: 2ac9003d user: drh tags: release, version-3.25.1, branch-3.25) | |
2018-09-17
| ||
15:25 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: 36c75fd5 user: drh tags: branch-3.25) | |
15:19 | Disable the ORDER BY LIMIT optimization in queries using window functions. This fixes a problem that was introduced by check-in [206720129ed2fa8875a286] which attempted to fix ticket [9936b2fa443fec03ff25f9]. This changes is a fix for the follow-in tocket [510cde277783b5fb5de628]. (check-in: c6c9585f user: drh tags: trunk) | |
14:18 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. (check-in: 5ce568c0 user: drh tags: branch-3.25) | |
14:13 | Fix a false-positive in the post-ALTER-TABLE schema verification logic that prevents ALTER TABLE from working if the table being altered has a trigger that references any column of a virtual table. Ticket [b41031ea2b537237]. (check-in: 84105ea4 user: drh tags: trunk) | |
12:49 | Fix missing space in 'configure.ac' reported on the mailing list. (check-in: 96b00a3c user: mistachkin tags: trunk) | |
11:36 | Increase the version number to 3.25.1. (check-in: f3c8cfdb user: drh tags: branch-3.25) | |
2018-09-15
| ||
04:01 | Version 3.25.0 (check-in: b63af6c3 user: drh tags: trunk, release, version-3.25.0) | |
2018-09-14
| ||
17:42 | Fix minor typos in comments that get carried over into documentation. No changes to code. (check-in: 7921dd91 user: drh tags: trunk) | |
2018-09-13
| ||
17:11 | Update releasetest.tcl to run "make test" as part of the "Fast-One" configuration. (check-in: d5ebfe1c user: dan tags: trunk) | |
17:07 | Make sure the %z optimization for printf() is not invoked if there has been a prior error (SQLITE_NOMEM or SQLITE_TOOBIG) associated with the same printf() call. (check-in: a2304a34 user: drh tags: trunk) | |
13:17 | Fix a requirement mark on a test script. No changes to code. (check-in: 628d5c0a user: drh tags: trunk) | |
2018-09-12
| ||
20:32 | Fix an assert() in os_unix.c that is not true when using RBU. (check-in: 028ed861 user: dan tags: trunk) | |
15:51 | Restrict the scope of internal-use functions in alter.c. (check-in: 4396914f user: drh tags: trunk) | |
14:28 | Improvements to the documentation for SQLITE_FCNTL_DATA_VERSION. No changes to code. (check-in: 27837624 user: drh tags: trunk) | |
08:51 | Fix an invalid pointer comparison triggered by renaming a table column when there are views with explicit column names in the schema. (check-in: 572de7e4 user: dan tags: trunk) | |
01:05 | Fix some harmless compiler warnings seen with MSVC. (check-in: 78862252 user: mistachkin tags: trunk) | |
00:48 | For MSVC, migrate some commonly used shell compilation options to the library. (check-in: 68a71e5f user: mistachkin tags: trunk) | |
00:21 | Fix a harmless compiler warning that arose from the ENABLE_CURSOR_HINTS fix of check-in [0af18674ca5b34e67e] (check-in: f578e62a user: drh tags: trunk) | |
2018-09-11
| ||
19:05 | Do not do the byte-by-byte modifications in the resetdb.test script if the reserved-byte flag in the DB header is non-zero, because in that case the bytes will be in the wrong place and the test won't work. (check-in: 0af18674 user: drh tags: trunk) | |
13:38 | Fix a problem causing ENABLE_CURSOR_HINTS builds to segfault. (check-in: e7033104 user: dan tags: trunk) | |
2018-09-10
| ||
19:34 | Fix a test script issue in fts3ao.test. (check-in: 74c381b5 user: dan tags: trunk) | |
19:27 | Fix a minor problem causing an incorrect cursor-hint to be generated in some cases. (check-in: d879c47d user: dan tags: trunk) | |
17:21 | Add the ability for loadable extensions to access the new sqlite3_create_window_function() interface. (check-in: 3def6d8e user: drh tags: trunk) | |
16:38 | Fix a broken assert() in fts3.c. (check-in: 564fa751 user: dan tags: trunk) | |
14:43 | New testcase() macros on virtual table xBestIndex logic. (check-in: 3bbd9c5f user: drh tags: trunk) | |
12:40 | Fix the LIKE optimization so that it is disabled when the LHS of the expression does not have TEXT affinity and the RHS is the pattern '/%' or the RHS begins with the escape character. Fix for ticket [c94369cae9b561b1f996d0054b]. (check-in: f191431d user: drh tags: trunk) | |
12:17 | Fix a problem with processing a "vtab.col IS NULL" expression within the WHERE clause of a query when "vtab" is a virtual table on the rhs of a LEFT JOIN. (check-in: 83da4d41 user: dan tags: trunk) | |
2018-09-08
| ||
20:29 | Fix an unreachable branch in the new sqlite3WhereOrderByLimitOptLabel() function of the query planner. (check-in: 5a954533 user: drh tags: trunk) | |
20:09 | Fix multiple issues with the ORDER BY LIMIT optimization. This is the proposed resolution to ticket [9936b2fa443fec03ff25]. (check-in: 20672012 user: drh tags: trunk) | |
16:55 | Add a missing call to free() in Lemon. (check-in: 8b4cf33a user: mistachkin tags: trunk) | |
16:53 | Fix typo in the Win32-specific code for the fileio extension. (check-in: e812e5d5 user: mistachkin tags: trunk) | |
2018-09-07
| ||
19:12 | Remove a faulty ALWAYS() macro added by check-in [8fa254aa6329bdd0]. (check-in: fc47316e user: drh tags: trunk) | |
18:56 | Add extra test case to altertab.test. (check-in: 64c3ee3c user: dan tags: trunk) | |
18:52 | Add assert() and ALWAYS() to identify two unreachable branches. (check-in: 8fa254aa user: drh tags: trunk) | |
15:50 | Fix a problem with renaming a non-temp table that has at least one temp trigger and shares its name with a temp table. (check-in: ceb60bd7 user: dan tags: trunk) | |
11:51 | Minor fixes for problems revealed by releasetest.tcl. (check-in: 1a8aedc3 user: dan tags: trunk) | |
11:08 | Fix an uninitialized variable in the OP_ParseSchema opcode that comes up only if the schema is corrupt. (check-in: 725808d4 user: drh tags: trunk) | |
2018-09-06
| ||
20:33 | In all.test, do not attempt to run the RBU tests in non-RBU builds. (check-in: 10c3e5a0 user: dan tags: trunk) | |
19:36 | Fix a harmless compiler warning in os_unix.c. (check-in: b9d1fb5d user: drh tags: trunk) | |
18:56 | Fix a problem with ALTER TABLE when there are views or triggers in the schema that contain "<expr> IS NULL" expressions. (check-in: 91aab32e user: dan tags: trunk) | |
17:47 | Fix a problem in ALTER TABLE with SQLITE_OMIT_VIRTUALTABLE builds. (check-in: fa835145 user: dan tags: trunk) | |
17:23 | Fix test script problems causing SQLITE_OMIT_VIRTUALTABLE builds to fail. (check-in: 37ad064e user: dan tags: trunk) | |
16:50 | Merge accidental fork. (check-in: ebadb7dc user: mistachkin tags: trunk) | |
16:47 | Fix harmless compiler warning. (check-in: 88b39c46 user: mistachkin tags: trunk) | |
16:47 | Fix a problem causing SQLITE_OMIT_VIRTUALTABLE builds to fail. (check-in: 18beabc8 user: dan tags: trunk) | |
16:24 | Add new test file "alterauth.test". (check-in: 00940265 user: dan tags: trunk) | |
16:20 | Add an "ALTER TABLE RENAME COLUMN" command. Upgrade "ALTER TABLE RENAME TABLE" so that it modifies references to the renamed table embedded in SQL view and trigger definitions. (check-in: 4da59983 user: dan tags: trunk) | |
16:17 | Merge latest trunk changes into this branch. (Closed-Leaf check-in: 8a28a326 user: dan tags: alter-table-rename-column) | |
16:01 | Ensure that the tbl_name column in the sqlite_temp_master table is updated correctly as part of a RENAME TABLE operation. (check-in: ffecfca5 user: dan tags: alter-table-rename-column) | |
14:01 | Add the randomshape.tcl test-case generator script to the util subdirectory of the rtree extension. (check-in: 8f48991d user: drh tags: trunk) | |
11:14 | Fix excess memory usage in the JSON parser of GEOPOLY. (check-in: 9057e27e user: drh tags: trunk) | |
02:40 | Fix a problem with geopoly trying to update both the _shape and an auxiliary column in the same UPDATE statement. (check-in: 14c95515 user: drh tags: trunk) | |
2018-09-05
| ||
17:52 | Merge latest trunk changes into this branch. (check-in: 6f4f707f user: dan tags: alter-table-rename-column) | |
17:45 | Fix some test script errors. And an incorrect assert() in fts5. (check-in: f804336f user: dan tags: alter-table-rename-column) | |
16:16 | Remove an old testcase() macro that is no longer valid. (check-in: e6287133 user: drh tags: trunk) | |
14:36 | Avoid comparing pointer values after the object that they point to has been deleted. (check-in: 2ec7e50c user: dan tags: alter-table-rename-column) | |
08:28 | Fix minor code issues in alter.c. (check-in: 18ba35b8 user: dan tags: alter-table-rename-column) | |
2018-09-04
| ||
18:23 | Merge latest trunk changes into this branch. (check-in: ef9e0882 user: dan tags: alter-table-rename-column) | |
2018-09-03
| ||
20:05 | Improve the error messages emitted by RENAME TABLE. (check-in: 6805b590 user: dan tags: alter-table-rename-column) | |
17:11 | Ensure that FTS5 queries of the form "WHERE rowid BETWEEN ? AND ? AND tbl MATCH ? ORDER BY rank" do rowid filtering before sorting. (check-in: f1138a38 user: dan tags: trunk) | |
2018-09-01
| ||
20:38 | Add another test case to altertab.test. (check-in: 828e8849 user: dan tags: alter-table-rename-column) | |
20:23 | Fix a problem with renaming a column in a table that has a temp trigger that references another attached database. (check-in: 336b8a09 user: dan tags: alter-table-rename-column) | |
20:02 | Fixes for harmless compiler warnings. (check-in: 41b8f38b user: drh tags: alter-table-rename-column) | |
16:55 | Fix some harmless compiler warnings and improve defenses against OOM errors. (check-in: 2e2cf992 user: drh tags: alter-table-rename-column) | |
16:13 | Merge alter-table-rename-table back into this branch. (check-in: ad704a7c user: dan tags: alter-table-rename-column) | |
16:05 | Have "ALTER TABLE ADD COLUMN" reload the entire db schema, as "RENAME COLUMN" and "RENAME TABLE" do. (Closed-Leaf check-in: 8d89ddc1 user: dan tags: alter-table-rename-table) | |
15:55 | Merge fixes from the alter-table-rename-column branch that occurred after this branch separated from that one. (check-in: 22e785aa user: drh tags: alter-table-rename-table) | |
15:49 | Merge fixes and enhancements from trunk. (check-in: 589186c0 user: drh tags: alter-table-rename-table) | |
06:13 | Update test script snapshot_fault.test to account for the new sqlite3_snapshot_open() error code. (check-in: c1aca767 user: dan tags: trunk) | |
2018-08-31
| ||
23:22 | New hyperlink on the README.md file. (check-in: c663961e user: drh tags: trunk) | |
19:00 | If a call to sqlite3_snapshot_open() fails because the requested snapshot no longer exists, return SQLITE_ERROR_SNAPSHOT instead of SQLITE_BUSY_SNAPSHOT. (check-in: e0792312 user: dan tags: trunk) | |
18:23 | Ensure b-tree mutexes are always held when sqlite3FindTable() is called. Do not invoke the authorizer callback when parsing schema items as part of ALTER TABLE commands. Fix test script issues. (check-in: eac2aa7d user: dan tags: alter-table-rename-table) | |
2018-08-30
| ||
20:28 | Try to identify the places in WAL code where thread-safety depends on the underlying architecture supporting atomic load and store of aligned 32-bit values. (check-in: 47d44be4 user: drh tags: trunk) | |
20:03 | Test the schema after renaming a table. Ensure that temp database triggers and views are updated when renaming a column. (check-in: f3c27d91 user: dan tags: alter-table-rename-table) | |
18:53 | Give the debugging routine print_pager_stats() external linkage in order to suppress harmless compiler and TSAN warnings. (check-in: ff4dc082 user: drh tags: trunk) | |
16:26 | Fix an ALTER TABLE problem with processing temp schema views and triggers. (check-in: 72cfb1be user: dan tags: alter-table-rename-table) | |
01:52 | Improved JSON parser caching. (check-in: 58078c0d user: drh tags: trunk) | |
2018-08-29
| ||
21:01 | Additional test cases for geopoly. (check-in: 19b5eb45 user: drh tags: trunk) | |
21:00 | Extend RENAME TABLE to edit triggers and views. Still buggy. (check-in: 01308bae user: dan tags: alter-table-rename-table) | |
20:52 | Fixes to the UPDATE logic in Geopoly. (check-in: 7c3cee0a user: drh tags: trunk) | |
20:24 | Also free up the MEM_RowSet bit in the Mem.flags field and have RowSet objects be destroyed using Mem.xDel. This change results in faster code. (check-in: f48e9feb user: drh tags: trunk) | |
18:47 | Free up the MEM_Frame bit in Mem.flags object. Store VdbeFrame objects as MEM_Blob with a special Mem.xDel pointer instead. (check-in: 62db5fd4 user: drh tags: trunk) | |
15:50 | Add the geopoly_group_bbox() aggregate function to the Geopoly module. (check-in: 2d4debcc user: drh tags: trunk) | |
2018-08-28
| ||
21:12 | Disable the server1.test script on old PPC Macs due to problems in the pthreads implementation on those archaic machines. (check-in: 43efdd8c user: drh tags: trunk) | |
19:23 | Stricter enforcement of the JSON and GeoJSON standards in the Geopoly extension. (check-in: c0bf3ff3 user: drh tags: trunk) | |
15:51 | Fix new issues in the geopoly module discovered by TH3. (check-in: 22fff9af user: drh tags: trunk) | |
11:23 | Fix a problem causing spurious SQLITE_CORRUPT errors when using the snapshot API to read from old database snapshots. (check-in: 535155be user: dan tags: trunk) | |
2018-08-27
| ||
17:13 | Add support for the Geopoly extension to the R-Tree extension. This also involves adding the SQLITE_INDEX_CONSTRAINT_FUNCTION capability to the xFindFunction method of the sqlite3_module object, and to the sqlite3_index_info.aConstraint.op field in the xBestIndex implementation of virtual tables. (check-in: 666133e3 user: drh tags: trunk) | |
17:05 | Minor changes to the visual01.txt test script. (Closed-Leaf check-in: 4bc28eed user: drh tags: rtree-geopoly) | |