Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 ancestors of [4cb67252]
|
2018-12-19
| ||
| 16:03 | Add interfaces sqlite3_bind_pointer(), sqlite3_result_pointer(), and sqlite3_value_pointer() used to safely move pointer values through SQL without exposing underlying memory address information. Cherrypick from commit [8201f4e1] on branch-3.18. check-in: 4cb67252 user: dan tags: branch-3.9 | |
| 01:57 | Add extra defenses against strategically corrupt databases to fts3/4. check-in: 882ef4e3 user: drh tags: branch-3.9 | |
|
2016-03-31
| ||
| 21:36 | Version 3.9.3 check-in: dfbfd34b user: drh tags: release, branch-3.9, version-3.9.3 | |
| 21:16 | Enhance the query planner so that IS and IS NULL operators are able to drive an index on a LEFT OUTER JOIN. check-in: f1e6bb95 user: drh tags: branch-3.9 | |
|
2015-11-02
| ||
| 18:31 | Version 3.9.2 check-in: bda77dda user: drh tags: release, branch-3.9, version-3.9.2 | |
| 11:19 | When creating an automatic-index on a sub-query, add a unique integer to the end of each index key to ensure the entire key is unique. Fix for [8a2adec1]. check-in: c0c4b6b3 user: drh tags: branch-3.9 | |
| 11:10 | Aborted releaset of 3.9.2. check-in: c33a275b user: drh tags: branch-3.9 | |
|
2015-11-01
| ||
| 21:42 | Increase the version number to 3.9.2. check-in: 14bd4fbf user: drh tags: branch-3.9 | |
| 21:35 | If a table-constraint PRIMARY KEY lists a single column in single-quotes and that column has type INTEGER, then make that column an integer primary key, for historical compatibility. Fix for ticket [ac661962a2aeab3c331]. check-in: dab0e607 user: drh tags: branch-3.9 | |
|
2015-10-16
| ||
| 17:31 | Version 3.9.1 check-in: 767c1727 user: drh tags: release, branch-3.9, version-3.9.1 | |
| 15:56 | Cherrypick the json form-feed fix, and other #ifdef and build script changes to address minor issues that came to light after the 3.9.0 release. Update the version number to 3.9.1. No logic changes except for the form-feed bug-fix in json1 (ticket [57eec374ae1d0a1d4a]). check-in: 746fcd2f user: drh tags: branch-3.9 | |
|
2015-10-14
| ||
| 12:29 | Version 3.9.0 check-in: a721fc0d user: drh tags: trunk, release, version-3.9.0 | |
| 10:56 | Add the missing 'extern "C" {...}' blocks to fts5.h and sqlite3rbu.h. check-in: 47a2ce97 user: dan tags: trunk | |
|
2015-10-12
| ||
| 22:31 | Remove the unused fts5ExprColsetTest() routine. check-in: 9ecafc0c user: drh tags: trunk | |
| 22:20 | Fix a couple harmless compiler warnings. check-in: 7f896a97 user: mistachkin tags: trunk | |
| 19:12 | Further tweaks to improve fts5 prefix query performance. check-in: 1c20c1c2 user: dan tags: trunk | |
| 04:56 | Change all references to 3.8.12 into 3.9.0. Comment changes only - no changes to code. check-in: 6f2858f6 user: drh tags: trunk | |
|
2015-10-11
| ||
| 20:39 | Detect and report circularly defined views even if the views have the columns defined in the CREATE VIEW statement. check-in: 9ab9c8c6 user: drh tags: trunk | |
| 20:08 | Remove an unreachable branch in the query flattener substitution logic. check-in: 46ee3453 user: drh tags: trunk | |
| 19:46 | Improved substitution logic in the query flattener. Saves code space, and (more importantly) works correctly with table-valued functions. check-in: 3d0bd95e user: drh tags: trunk | |
|
2015-10-10
| ||
| 16:41 | Work around a "security feature" bug in memcpy() on OpenBSD. check-in: fab6f090 user: drh tags: trunk | |
| 15:57 | Remove another instance of strcpy() from FTS5, to mollify OpenBSD. check-in: 35e6248a user: drh tags: trunk | |
| 15:11 | Omit the use of strcpy() in FTS5 since OpenBSD hates strcpy(). check-in: bc24a5bb user: drh tags: trunk | |
| 14:41 | Compiler warning fixes: Rename some local variables from "j1" to avoid a name collision with the j1() bessel function in the math library. Omit a dummy initializer that gcc 4.6.3 does not like. check-in: 9ddef84d user: drh tags: trunk | |
| 14:00 | Add some #ifdef-ery to json1.c to avoid a duplicate typedef when used in the amalgamation, since some compilers become upset over duplicate typedefs. check-in: de28acd4 user: drh tags: trunk | |
|
2015-10-09
| ||
| 20:40 | The previous fix to JSON1 was not complete. A few more tweaks are needed for correct handling of all oversized integers. check-in: 4a47f017 user: drh tags: trunk | |
| 18:21 | Fix the JSON1 extension so that it renders integers outside the range of -9223372036854775808 to +9223372036854775807 as floating-point numbers. check-in: ae736e35 user: drh tags: trunk | |
| 17:54 | Remove fts5 sources from TESTSRC2 in main.mk as there is no SQLITE_TEST code in said files. check-in: c1840639 user: dan tags: trunk | |
| 14:37 | Add --enable-fts5 and --enable-json1 options to the amalgamation autoconf package. check-in: 8a4e1988 user: dan tags: trunk | |
| 14:23 | In the MSVC makefile, adjust the names of two nmake variables for consistency. check-in: 92aa4b6b user: mistachkin tags: trunk | |
| 13:42 | Change the version number of the next release to 3.9.0. check-in: aa8fdadf user: drh tags: trunk | |
| 13:39 | Add the JSON1 and FTS5 extensions to the amalgamation. Add new options to ./configure: --enable-json1 and --enable-fts5. check-in: 1eb76993 user: drh tags: trunk | |
| 13:29 | Fix a typo in the MSVC Makefile Closed-Leaf check-in: c8a12082 user: drh tags: amalg-json1-fts5 | |
| 12:48 | Add configure script options --enable-fts5 and --enable-json1. Automatically search for -lm when using --enable-fts5. check-in: a0c44f1d user: drh tags: amalg-json1-fts5 | |
| 11:09 | Makefile and fts5 changes so that fts5 works with main.mk. Still does not work with Makefile.in. check-in: 6ebac32d user: dan tags: amalg-json1-fts5 | |
| 01:42 | Trying to get FTS5 tests to build and run using main.mk. Not yet working. check-in: 206174f9 user: drh tags: amalg-json1-fts5 | |
|
2015-10-08
| ||
| 23:37 | Json1 tests are working. Builds without FTS5 enabled. Still some problems building with FTS5. check-in: 2928f8e8 user: drh tags: amalg-json1-fts5 | |
| 21:02 | Remove calls to "load_static_extension" from fts5 test scripts. check-in: 53dd7c4c user: dan tags: amalg-json1-fts5 | |
| 21:00 | Further tweaks to main.mk so that fts5 builds as part of testfixture. check-in: 97e11b79 user: dan tags: amalg-json1-fts5 | |
| 20:40 | Fix further fts5 compilation issues. check-in: 0d7f301f user: dan tags: amalg-json1-fts5 | |
| 20:28 | Fix two more warnings in fts5 code. check-in: 5343e601 user: dan tags: amalg-json1-fts5 | |
| 20:11 | Fix a couple of errors in fts5 compilation. This branch still does not build with -Wall -Werror. check-in: e9e76e12 user: dan tags: amalg-json1-fts5 | |
| 19:29 | First attempt to add json1 and fts5 to the amalgamation. This check-in does not compile. check-in: d820a1bd user: drh tags: amalg-json1-fts5 | |
| 17:35 | In the RBU extension, use MoveFile() instead of rename() on Windows CE. check-in: df9ef61f user: mistachkin tags: trunk | |
| 02:44 | Remove two unused lines of code - discovered by scan-build. check-in: 77b707b7 user: drh tags: trunk | |
|
2015-10-07
| ||
| 19:06 | Further optimizations for fts5 prefix queries without a prefix index. check-in: 83dc1ff7 user: dan tags: trunk | |
| 17:06 | Fix harmless compiler warning in FTS5. check-in: 13adcd03 user: mistachkin tags: trunk | |
| 17:01 | Allow the subsitute character (codepoint 26 - 0x1A) to appear in fts5 barewords. check-in: baec1b96 user: dan tags: trunk | |
| 16:14 | Adjustments to spellfix2.test so that it works reliably on mac. check-in: d591e860 user: drh tags: trunk | |
| 13:24 | Add tests for fts5 phrase queries with column filters. check-in: f20f9f81 user: dan tags: trunk | |
| 09:02 | Add further tests for fts5 prefix queries. check-in: accdc98b user: dan tags: trunk | |
| 04:20 | Fix a typo in the previous check-in. check-in: 80027709 user: mistachkin tags: trunk | |
| 03:07 | When running tests on Tcl 8.6 under Windows, skip tests 'uri-1.12.*' due to a change in Tcl behavior related to NTFS ADS (alternate data streams). check-in: 8a0a2aa5 user: mistachkin tags: trunk | |
| 00:35 | Remove three obsolete and unused files from tool/ check-in: 0abd6529 user: drh tags: trunk | |
|
2015-10-06
| ||
| 21:49 | Fix typo in comments. No changes to code. check-in: a05f903c user: mistachkin tags: trunk | |
| 21:07 | Simplifications to the VDBE bytecode that handles LIMIT and OFFSET. check-in: 041df7c2 user: drh tags: trunk | |
| 20:53 | Optimizations for fts5 expressions that filter on column. More still to come. check-in: bf1607ac user: dan tags: trunk | |
| 17:27 | Fix the LIMIT and OFFSET handling for UNION ALL queries that contain a subquery with ORDER BY on the right-hand side. Fix for ticket [b65cb2c8d91f668584]. check-in: 4b631364 user: drh tags: trunk | |
| 01:44 | Adjustments to sqlite3MemoryBarrier() when compiling with MSVC and/or WinCE. check-in: 3168326e user: mistachkin tags: trunk | |
|
2015-10-05
| ||
| 19:41 | Improve performance of prefix queries without a prefix index on fts5 tables. check-in: f2f0184e user: dan tags: trunk | |
| 15:39 | Update fts3 so that expressions to the left and right of a NOT operator are balanced. This prevents relatively small expressions (a dozen terms or so) that are children of NOT operators from triggering the "expression tree is too large" error. check-in: d6b66cd7 user: dan tags: trunk | |
| 11:57 | Add fts5txt2db.tcl, a tool for creating sample fts4/5 databases from text files. check-in: 44f1ce30 user: dan tags: trunk | |
|
2015-10-03
| ||
| 15:38 | Update fts5 to support the table function syntax. "... FROM fts5_tbl WHERE fts5_tbl MATCH ?1 AND rank MATCH ?1" can now be written "FROM fts5_tbl(?1, ?2)". check-in: 41d17d9e user: dan tags: trunk | |
| 12:23 | Add tests for the rtree module to verify that attempts to insert non-integer primary key values or non-numeric dimensions into an rtree table are handled correctly. check-in: f653fce9 user: dan tags: trunk | |
|
2015-10-02
| ||
| 20:04 | Update fts5 to avoid using a statement journal for UPDATE and DELETE operations that affect at most a single row. check-in: 5c83b9db user: dan tags: trunk | |
|
2015-10-01
| ||
| 18:31 | Fix an fts3 bug causing NEAR queries on uncommitted data to malfunction. check-in: 6f90839e user: dan tags: trunk | |
|
2015-09-30
| ||
| 14:30 | Add a corrupt database to test/fuzzdata3.db to validate the previous check-in. check-in: e796c0ef user: drh tags: trunk | |
| 14:19 | Fix an assert() in btree.c that is only true for non-corrupt databases. check-in: 29f7227f user: drh tags: trunk | |
| 12:59 | Clear the BTCF_ValidNKey flag when putting a cursor into REQUIRESEEK state. Fix for [1b266395]. check-in: a6d5e4e8 user: dan tags: trunk | |
| 11:19 | Improve error handling in shell command ".tables". check-in: 31a91ee7 user: dan tags: trunk | |
|
2015-09-29
| ||
| 17:20 | Use symbolic names XN_ROWID and XN_EXPR in place of the (-1) and (-2) magic numbers in Index.aiColumn[]. Add asserts to help verify that Index.aiColumn[] is always used correctly. Fix one place in FK processing where Index.aiColumn[] was not being used correctly. check-in: 7d272aa6 user: drh tags: trunk | |
| 16:47 | Add the sqlite3_index_info.idxFlags field, allowing xBestIndex() implementations to specify to SQLite that a strategy may visit at most one row. Add support for this to fts3/4. Omit the statement journal from virtual table UPDATE and DELETE operations that are guaranteed not to affect more than one row. check-in: a1d08fd3 user: dan tags: trunk | |
| 16:41 | Ensure that the xSavepoint() virtual table method is correctly invoked if there are already open savepoints (or statement transactions) the first time a virtual table is written within a transaction. check-in: 77948b5e user: dan tags: trunk | |
| 15:50 | Remove dead code, replacing with assert() statements that make sure the code really was dead. Closed-Leaf check-in: 0e317dda user: drh tags: vtab-onepass | |
| 13:25 | Create the sqlite3IsToplevel(Parse*) interface to check to see if a top-level VDBE is being coded (versus a trigger) and use that interface. check-in: 59662cd2 user: drh tags: vtab-onepass | |
| 12:32 | Fix compiler warnings. check-in: d1a07838 user: drh tags: vtab-onepass | |
| 12:19 | Fix an off-by-one error in test function fts5_decode(). check-in: 3a9f0762 user: dan tags: trunk | |
| 11:59 | Merge latest trunk change into this branch. check-in: b519c0d6 user: dan tags: vtab-onepass | |
| 11:57 | Change the name of the new sqlite3_index_info.flags field to "idxFlags". Add documentation for the same to sqlite.h.in. check-in: f61203bc user: dan tags: vtab-onepass | |
| 10:11 | Add tests for fts3 and onepass update/delete operations. Also fix a problem with onepass updates that do not affect any rows. check-in: 820c8044 user: dan tags: vtab-onepass | |
|
2015-09-28
| ||
| 20:03 | Also allow UPDATE on virtual tables to use the onepass strategy. check-in: 1aa27d70 user: dan tags: vtab-onepass | |
| 17:05 | Extra information provided by .wheretrace on input flags to the query planner and on the result of sqlite3WhereOkOnePass(). check-in: c5566bb3 user: drh tags: trunk | |
| 15:23 | Update fts3 to use the onepass strategy for delete operations. check-in: fffab4f7 user: dan tags: vtab-onepass | |
| 15:20 | Changes to allow DELETE operations on virtual tables to use the onepass strategy under some circumstances. check-in: e73f919f user: dan tags: vtab-onepass | |
| 15:08 | Add test cases to the ONEPASS optimization corruption problem fixed by the previous check-in. check-in: 5c14d447 user: drh tags: trunk | |
| 14:40 | Fix a database corruption bug caused by the ONEPASS optimization added in check-in [8b93cc5937000535]. Bug detected (prior to release) by sqllogictest. Test cases to follow. check-in: 9d057f52 user: drh tags: trunk | |
|
2015-09-26
| ||
| 17:44 | Enable adding JSON1 by appending the json1.c source file to the amalgamation and compiling with -DSQLITE_ENABLE_JSON1 check-in: 33404b20 user: drh tags: trunk | |
| 11:15 | Fix a memory leak that can occur following a syntax error in CREATE VIEW. check-in: f4704035 user: drh tags: trunk | |
| 03:31 | Fix the title of the documentation on sqlite3_value_subtype(). This is a comment change only. check-in: b7902354 user: drh tags: trunk | |
| 03:23 | Expand the header comment to clarify the purpose for the sqlite3MemoryBarrier() function. check-in: b89495ae user: drh tags: trunk | |
| 01:28 | Remove an assert in the windows worker-thread logic that can fail in a race condition. check-in: d7bfb960 user: drh tags: trunk | |
|
2015-09-25
| ||
| 23:40 | Fix threads.c so that setting sqlite3FaultSim(200) using the SQLITE_TESTCTRL_FAULT_INSTALL callback causes both unix and windows worker threads to be sequential and deterministic, so that they can be tested reliably. check-in: 2d867c05 user: drh tags: trunk | |
| 20:49 | Fix PRAGMA integrity_check so that it works with a UNIQUE index over expressions. check-in: 113181ce user: drh tags: trunk | |
| 13:42 | Report an error if the number of named columns in a VIEW is different from the number of result columns in the SELECT statement that implements the VIEW. check-in: 6e4ac0be user: drh tags: trunk | |
| 01:09 | Fix a problem computing affinities for indexes during skip-scan code generation when SQLITE_ENABLE_STAT4 is on. Bug introduced by check-in [1ee089a72d789002]. check-in: 1350dd42 user: drh tags: trunk | |
|
2015-09-24
| ||
| 18:47 | Enhance the query planner so that it is able to use indexed expressions to help fulfill an ORDER BY clause. check-in: 668fc1eb user: drh tags: trunk | |
| 17:38 | Fix over-length source code lines in where.c. No logic changes. check-in: 1c8c5380 user: drh tags: trunk | |
| 12:40 | Strengthen the implementations of xShmMemoryBarrier on both the unix and windows VFSes, so that they likely work even if SQLITE_THREADSAFE=0 is used. check-in: c6ab807b user: drh tags: trunk | |
| 12:19 | Make sure joins work correctly when both sides of the join are connected using indexed expressions. check-in: c2fcb032 user: drh tags: trunk | |
| 11:26 | Correctly handle the case of a WHERE-clause term with indexed expressions on both sides of the == sign. check-in: d9b716a6 user: drh tags: trunk | |
| 11:06 | Fix a JSON1 test case so that it works on builds that omit virtual tables. check-in: a4444c0f user: drh tags: trunk | |