SQLite
Timeline
Not logged in

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

50 most recent timeline items

2015-08-29
19:41
[1da60c3dda] Leaf: 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. (user: drh, tags: trunk)
19:03
[2e8e239cec] Link the json1 extension into the command-line shell by default. (user: drh, tags: trunk)
18:46
[98d07d16ca] Leaf: Add a test for an fts5 tokenizer that supports synonyms by adding multiple entries to the fts index. (user: dan, tags: fts5-incompatible)
18:30
[daff4832af] New test cases for the json1 extension. (user: drh, tags: trunk)
17:22
[752918def7] Fix the build with -DSQLITE_OMIT_VIRTUALTABLE. (user: drh, tags: trunk)
16:02
[fd19ff029f] Do not consider an empty string to be valid JSON. Add some additional JSON test cases. (user: drh, tags: trunk)
15:44
[fc71868496] Another change to the fts5 tokenizer API. (user: dan, tags: fts5-incompatible)
00:54
[3aa0855fd4] Change the json1.c module so that it throws an error if any of the JSON selector paths are malformed. (user: drh, tags: trunk)
2015-08-28
20:07
[dc9ce7b18c] 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. (user: drh, tags: trunk)
19:56
[90b85b42f2] Change the fts5 tokenizer API to allow more than one token to occupy a single position within a document. (user: dan, tags: fts5-incompatible)
18:11 • Edit [ab93024da7bd577d|ab93024da7]: Marked "Closed". (user: dan)
16:41
[0fdc36fe35] Fix compiler warnings in rbu code. (user: dan, tags: trunk)
16:18
[a84cf4f5d3] When searching the wal file for a frame, do not search that part that was already checkpointed when the transaction was opened. (user: dan, tags: trunk)
15:50
[ab93024da7] Closed-Leaf: Merge latest trunk into this branch. (user: dan, tags: wal-read-change)
15:35
[650111f667] Leaf: Fix a potential segfault in the VFS logic that checks for fail renames out from under SQLite. (user: drh, tags: apple-osx)
13:27
[bd911496cb] 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. (user: drh, tags: apple-osx)
09:27
[57bc0194f4] Leaf: Merge latest trunk changes with this branch. (user: dan, tags: experimental-begin-unlocked)
03:48
[64abb65d4d] Add the json_check() function, which returns its argument if the argument is well-formed JSON or which throws an error otherwise. (user: drh, tags: trunk)
03:33
[44f103d886] 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 '$'. (user: drh, tags: trunk)
02:12
[da8646582a] Merge trunk enhancements into the apple-osx branch. Most tests works, but there are yet a few issues to be resolved. (user: drh, tags: apple-osx)
2015-08-27
23:42
[cf452028d1] Leaf: Fix the OR-optimization so that it always ignores subplans that do not use an index. (user: drh, tags: index-expr)
23:18
[66f92a1686] Fix the OR-optimization so that it always ignores subplans that do not use an index. (user: drh, tags: trunk)
20:33
[73d361ce9e] Fix EXPLAIN QUERY PLAN output for indexed-expressions. Fix another obscure fault in the WHERE term scanner. (user: drh, tags: index-expr)
19:57
[437c7e219d] Add header comments for new methods in pager.c. (user: dan, tags: experimental-begin-unlocked)
19:56
[0337501769] Fix problems in the indexed-expression handling in the optimizer. (user: drh, tags: index-expr)
19:22
[fd4798cb7a] Add test cases for concurrent transactions and long-lived SELECT statements. (user: dan, tags: experimental-begin-unlocked)
18:24
[42f93f582e] Activate the ability to use expressions in indexes in a query. There are some test failures, but mostly this seems to work. (user: drh, tags: index-expr)
17:42
[fc17f73170] Fix a problem whereby concurrent transactions would not consider pages read by the transaction before the first write statement. (user: dan, tags: experimental-begin-unlocked)
16:07
[c80e9e8e8c] Merge changes from trunk. (user: drh, tags: index-expr)
15:58
[5611130a59] Adjustments to the WHERE term scanning, to better handle scanning terms of an index. (user: drh, tags: index-expr)
2015-08-26
21:08
[cbc3c9a8bf] Reduce the size of the WhereScan object by 24 bytes while also clarifying its operation. (user: drh, tags: trunk)
18:54
[69394ddaa2] Fix an assert() in pager.c that could fail in a concurrent transaction. (user: dan, tags: experimental-begin-unlocked)
18:04
[ec6ddb3d48] Merge enhancements from trunk. (user: drh, tags: index-expr)
18:02
[a0566382d5] Fix a problem allowing some conflicting transactions to be committed. (user: dan, tags: experimental-begin-unlocked)
14:01
[c2f3bbad77] Evaluate expressions only once when the same expression is used in both the result set and in the ORDER BY clause. (user: drh, tags: trunk)
11:40
[58ba73630e] Refactor With.a.zErr into With.a.zCteErr. No logic changes. (user: drh, tags: trunk)
11:34
[65a8918776] Update the TreeView output for compound SELECT statements so that all entries are shown vertically aligned rather than each successive entry being indented. (user: drh, tags: trunk)
2015-08-25
19:42
[b3732a4e1b] Move sqlite3IndexColumnAffinity() inside of SQLITE_ENABLE_STAT3_OR_STAT4. (user: drh, tags: trunk)
19:24
[e8b02902c4] Merge trunk enhancements. (user: drh, tags: index-expr)
19:20
[1ee089a72d] Use the sqlite3IndexColumnAffinity() routine to quickly and correctly find the affinity of an index column. (user: drh, tags: trunk)
19:10
[779b1d0e17] Add miscellaneous test cases for concurrent transactions. (user: dan, tags: experimental-begin-unlocked)
17:16
[f32b57b493] If "PRAGMA integrity_check" is run while the database is being written by a CONCURRENT transaction, do not consider unreferenced pages to be an error. They may be part of the free-page list, which is not visible at the b-tree layer when running a CONCURRENT transaction. (user: dan, tags: experimental-begin-unlocked)
16:57
[efaabdb716] Add code to maintain indexes with expression arguments across DELETE, INSERT, and UPDATE statements. Legacy tests pass, but the new code paths are still largely untested. The query planner currently makes no effort to use expression indexes. (user: drh, tags: index-expr)
16:01
[c746e0bd20] Test that if a corrupt wal-index header is encountered when attempting to commit a concurrent transaction, SQLITE_BUSY_SNAPSHOT is returned to the caller. (user: dan, tags: experimental-begin-unlocked)
14:37
[231b588022] Fix a segfault that could occur following an OOM condition in the concurrent transaction code. (user: dan, tags: experimental-begin-unlocked)
11:16
[3e7d6dd62d] Merge latest trunk changes with this branch. (user: dan, tags: experimental-begin-unlocked)
00:34
[8f1d9f1f30] Fix a memory leak that might occur when compiling with SQLITE_OMIT_CHECK. (user: drh, tags: trunk)
00:27 • Edit [0ad0f8d77d8f95ca|0ad0f8d77d]: Edit check-in comment. (user: drh)
00:27
[0ad0f8d77d] Changes toward being able to process indexes on expressions. Not there yet - this check-in is just movement in that direction. Some tests are failing. (user: drh, tags: index-expr)
2015-08-24
22:06
[47280f2a2b] Remove duplicated line of code. (user: mistachkin, tags: experimental-begin-unlocked)