Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
65 check-ins using file src/select.c version b52c80f2
2015-09-03
| ||
18:05 | Add documentation for fts5 synonym support. (check-in: 58aa1f43 user: dan tags: fts5-incompatible) | |
15:37 | Add tests to improve coverage of fts5_varint.c. (check-in: 89f24f31 user: dan tags: fts5-incompatible) | |
14:22 | Remove some more code from fts5_index.c by consolidating similar functions. (check-in: 59ae30b9 user: dan tags: fts5-incompatible) | |
11:17 | Remove dead code from fts5_index.c. (check-in: 8a0a9b01 user: dan tags: fts5-incompatible) | |
11:00 | Fix the fts5 integrity-check so that it works with columnsize=0 tables. (check-in: 11b887b1 user: dan tags: fts5-incompatible) | |
10:27 | Fix a memory leak in fts5_expr.c. (check-in: 399932a1 user: dan tags: fts5-incompatible) | |
2015-09-02
| ||
19:48 | Further tests to raise coverage of fts5 synonym code to 100%. Fix a dropped error code in the same. (check-in: bdedd838 user: dan tags: fts5-incompatible) | |
18:56 | Fix an issue with fts5 synonyms and NEAR(...) queries. (check-in: f2e59070 user: dan tags: fts5-incompatible) | |
17:55 | Change sqlite3_sql() so that it always returns the SQL text of the prepared statement, if the text is available, even if the the prepared statement was generated using sqlite3_prepare() instead of sqlite3_prepare_v2(). Also include some minor comment fixes and code simplifications. (check-in: 2f5472cf user: drh tags: trunk) | |
17:34 | Fix a problem with fts5 synonyms and phrase queries. Also fix an OOM handling bug in fts5. (check-in: a4c35fa2 user: dan tags: fts5-incompatible) | |
16:51 | Small simplification to the EXPLAIN QUERY PLAN logic. (check-in: d1592d20 user: drh tags: trunk) | |
15:37 | Use sqlite3XPrintf() instead of sqlite3StrAccumAppend() in a few places for better performance and a smaller footprint. (check-in: 82355e41 user: drh tags: trunk) | |
14:56 | The sqlite3_memory_alarm() interface has been deprecated and undocumented for almost 8 years (since version 3.5.3). Change it into a no-op. (check-in: 5d3f5df4 user: drh tags: trunk) | |
14:17 | Fix a problem handling OOM conditions within fts5 queries that feature synonyms. (check-in: 11fa9808 user: dan tags: fts5-incompatible) | |
12:52 | This change is not correct for the boundary case of nCellKey==0. Was: Small performance gain and size reduction in sqlite3VdbeIdxKeyCompare(). (Closed-Leaf check-in: 6e0298cd user: drh tags: mistake) | |
08:22 | Fix a problem with fts5 synonyms and the xQueryPhrase() auxiliary function API. (check-in: cf3e45e7 user: dan tags: fts5-incompatible) | |
2015-09-01
| ||
23:51 | Very minor optimizations in the unix VFS. (check-in: 6db3ff45 user: drh tags: trunk) | |
22:29 | Performance improvement in sqlite3VarintLen(). (check-in: adf9fefb user: drh tags: trunk) | |
20:09 | Small size reduction and performance increase in sqlite3DbMallocSize(). (check-in: 8a80967f user: drh tags: trunk) | |
19:51 | Reduce the number of calls to sqlite3BeginBenignMalloc(). (check-in: 0bee6583 user: drh tags: trunk) | |
18:52 | Merge recent enhancements from trunk. (check-in: cb772366 user: drh tags: sessions) | |
18:44 | Fix a problem that occurs when more than 4 synonyms for a term appear within a single row. (check-in: cd359550 user: dan tags: fts5-incompatible) | |
18:40 | Merge the latest trunk enhancements. (check-in: 4af79477 user: drh tags: apple-osx) | |
18:08 | Add tests for fts5 synonyms implemented by adding extra terms to queries. And fixes for the same. (check-in: dbcb7380 user: dan tags: fts5-incompatible) | |
18:01 | Merge the latest trunk enhancements. (check-in: 3dea0474 user: drh tags: begin-concurrent) | |
17:48 | Fixes so that it builds without warnings both with and without SQLITE_ENABLE_CONCURRENT. (check-in: 5ed2a445 user: drh tags: begin-concurrent) | |
13:17 | Rename SQLITE_FUNC_VARYING to SQLITE_FUNC_SLOCHNG - a more descriptive name for what that bit means. (check-in: ff5137a6 user: drh tags: index-expr) | |
00:42 | Remove unreachable branches. (check-in: fd4da231 user: drh tags: index-expr) | |
2015-08-31
| ||
23:09 | Fix a bug in error reporting when a UNIQUE index on expressions fails its uniqueness test. (check-in: 5a2c0e90 user: drh tags: index-expr) | |
21:16 | Not only date/time functions, but also functions like sqlite_version() and changes() need to be prohibited from use inside of indexes. (check-in: 48713130 user: drh tags: index-expr) | |
20:06 | Begin changes to allow synonym support by adding multiple terms to a query (an alternative to adding multiple terms to the FTS index). (check-in: ad7feaed user: dan tags: fts5-incompatible) | |
19:38 | Always assume that indexed expressions can generate a NULL. Get indexed expressions working for the case of two or more expressions in the same index. (check-in: cc60321a user: drh tags: index-expr) | |
18:13 | Case should not be significant when comparing function names. (check-in: e2f1caf1 user: drh tags: index-expr) | |
17:34 | Make the distinction between truly deterministic functions and date/time functions which only return the same answer for a single query. Only truly deterministic functions are allowed in indexes. Add new expression index test cases. (check-in: c77554b5 user: drh tags: index-expr) | |
15:58 | Improved analysis and usage of indexed expressions in the query planner. (check-in: f8893696 user: drh tags: index-expr) | |
14:27 | Merge the latest enhancements from trunk. (check-in: 7bde6d4d user: drh tags: index-expr) | |
2015-08-29
| ||
19:41 | Enhance the json_extract() function so that if given multiple PATH arguments it will return a JSON array with all of the answers. Also update comments within the json1 extension to reflect stricter interpretation of JSON and PATH arguments. (check-in: 1da60c3d user: drh tags: trunk) | |
19:03 | Link the json1 extension into the command-line shell by default. (check-in: 2e8e239c user: drh tags: trunk) | |
18:46 | Add a test for an fts5 tokenizer that supports synonyms by adding multiple entries to the fts index. (check-in: 98d07d16 user: dan tags: fts5-incompatible) | |
18:30 | New test cases for the json1 extension. (check-in: daff4832 user: drh tags: trunk) | |
17:22 | Fix the build with -DSQLITE_OMIT_VIRTUALTABLE. (check-in: 752918de user: drh tags: trunk) | |
16:02 | Do not consider an empty string to be valid JSON. Add some additional JSON test cases. (check-in: fd19ff02 user: drh tags: trunk) | |
15:44 | Another change to the fts5 tokenizer API. (check-in: fc718684 user: dan tags: fts5-incompatible) | |
00:54 | Change the json1.c module so that it throws an error if any of the JSON selector paths are malformed. (check-in: 3aa0855f user: drh tags: trunk) | |
2015-08-28
| ||
20:07 | Back out the json_check() routine. Instead, throw an error if the input to a json function (other than json_valid()) is not valid JSON. (check-in: dc9ce7b1 user: drh tags: trunk) | |
19:56 | Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. (check-in: 90b85b42 user: dan tags: fts5-incompatible) | |
16:41 | Fix compiler warnings in rbu code. (check-in: 0fdc36fe user: dan tags: trunk) | |
16:18 | When searching the wal file for a frame, do not search that part that was already checkpointed when the transaction was opened. (check-in: a84cf4f5 user: dan tags: trunk) | |
15:50 | Merge latest trunk into this branch. (Closed-Leaf check-in: ab93024d user: dan tags: wal-read-change) | |
15:35 | Fix a potential segfault in the VFS logic that checks for fail renames out from under SQLite. (check-in: 650111f6 user: drh tags: apple-osx) | |
13:27 | Disable the read-only WAL-mode database tests on the apple-osx branch because read-only WAL-mode databases are specifically disallowed by Apple-specific changes. (check-in: bd911496 user: drh tags: apple-osx) | |
09:27 | Merge latest trunk changes with this branch. (check-in: 57bc0194 user: dan tags: begin-concurrent) | |
03:48 | Add the json_check() function, which returns its argument if the argument is well-formed JSON or which throws an error otherwise. (check-in: 64abb65d user: drh tags: trunk) | |
03:33 | Enhance the json_insert(), json_replace(), and json_set() functions with the ability to add JSON instead of text if the argument is text and if the PATH begins with '$$' instead of just '$'. (check-in: 44f103d8 user: drh tags: trunk) | |
02:12 | Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. (check-in: da864658 user: drh tags: apple-osx) | |
2015-08-27
| ||
23:42 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: cf452028 user: drh tags: index-expr) | |
23:18 | Fix the OR-optimization so that it always ignores subplans that do not use an index. (check-in: 66f92a16 user: drh tags: trunk) | |
20:33 | Fix EXPLAIN QUERY PLAN output for indexed-expressions. Fix another obscure fault in the WHERE term scanner. (check-in: 73d361ce user: drh tags: index-expr) | |
19:56 | Fix problems in the indexed-expression handling in the optimizer. (check-in: 03375017 user: drh tags: index-expr) | |
18:24 | Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. (check-in: 42f93f58 user: drh tags: index-expr) | |
16:07 | Merge changes from trunk. (check-in: c80e9e8e user: drh tags: index-expr) | |
15:58 | Adjustments to the WHERE term scanning, to better handle scanning terms of an index. (check-in: 5611130a user: drh tags: index-expr) | |
2015-08-26
| ||
21:08 | Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. (check-in: cbc3c9a8 user: drh tags: trunk) | |
18:04 | Merge enhancements from trunk. (check-in: ec6ddb3d user: drh tags: index-expr) | |
14:01 | Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (check-in: c2f3bbad user: drh tags: trunk) | |