Enhance the processing of ORDER BY clauses on compound queries to better
match terms of the order by against expressions in the result set, in order
to enable better query optimization.
(check-in: a49e909c user: drh tags: trunk)

Enhance the do_test proc in the test suite so that if the expected result
is of the form "/.../" or "~/.../" then regular expression matching is done
between result and the "..." part of the expectation. In the ~/.../ case,
we expect there to be no match.
(check-in: c9a73440 user: drh tags: trunk)

If terminating interactive input to the command-line shell with ^D, issue
an extra \n to move the cursor to the next line before exiting.
This check-in also accidently adds the test_spellfix.c file to the source tree.
(check-in: feff1ef0 user: drh tags: trunk)

Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9].
(check-in: 7b8548b1 user: dan tags: trunk)

Fix for [2a5629202f]. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values.
(check-in: 9870e4c4 user: dan tags: trunk)

Add an undocumented and possibly ephemeral ".breakpoint" command to the
command-line shell, to call a no-op routine on which it is convenient to
set a symbolic debugger breakpoint.
(check-in: 8e2363ad user: drh tags: trunk)

In the unix VFS, always set every open file to close-on-exec using either
O_CLOEXEC at open (preferred) or FD_CLOEXEC in an ioctl after opening. Before
this changes, many files were done this way, but not all.
(check-in: 9efbeb11 user: drh tags: trunk)

Fix harmless static-analysis warnings, mosting having to do with memory
leaks in the command-line shell. Add a clang analysis of the command-line
shell to the "warnings-clang.sh" script. Other minor cleanups to the
command-line shell code.
(check-in: 93a0f452 user: drh tags: trunk)

Fix the application-defined function logic so that functions with a variable
number of parameters can be replaced or deleted correctly. Also refactor
some of the function-finder code for clarity of presentation.
(check-in: 09d5581c user: drh tags: trunk)

Improvements to comments. Minor changes to code in the hot path of
OP_Column - with the hope of get a few cycles of performance improvement.
(check-in: ca093103 user: drh tags: faster-typeof-and-length)

Remove the fts3merge.test script in favour of changing the fts4merge.test script so that it runs tests using both fts4 and fts3. Fix some problems with incr-merge and FTS3 tables.
(check-in: 5c447e22 user: dan tags: fts4-incr-merge)

In the fts3view utility, label the blank segments used to mark the end of a
segment sequence for a level/idx as "null". Improve the alignment of root
segment names.
(check-in: 04aea024 user: drh tags: fts4-incr-merge)

Allow multiple incremental merges to proceed concurrently. This is required to prevent a large crisis-merge from occuring while an even larger incremental-merge is underway.
(Closed-Leaf
check-in: 7ed9d2f2 user: dan tags: fts4-incr-merge-exp)

When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt.
(check-in: 341b703c user: drh tags: trunk)

When an incremental blob cursor is invalidated (occurs when an SQL statement modifies or deletes the row the blob cursor points to) release all page references held by the cursor. Otherwise, the presence of these references may cause other code in btree.c to incorrectly infer that the database is corrupt.
(check-in: 82c3f2ba user: dan tags: fts4-incr-merge)

This page was generated in about
0.007s by
Fossil 2.12 [16d68b0d4c] 2020-06-04 14:23:44