Initialize the 18-byte overrun area on the buffer used to reconstruct
overflow btree cells during a btree search, to avoid a harmless
jump-depends-on-uninit-values warning.
check-in: 4b05caeb user: drh tags: trunk

Make sure the OP_Concat opcode always correctly zero-terminates a UTF16
string, even if the input strings are ill-formed. This is a followup to
check-in [3a16ddf91f0c9c516a7] that fixes a case the previous check-in missed.
Also add assert()s to prove correct zero termination.
check-in: d612fb78 user: drh tags: trunk

Fix a problem with the fix for [9cf6c9bb51] (commit [658b84d7]) that could cause a cursor to be left in an invalid state following a (rowid < text-value) search.
check-in: bc7d2c16 user: dan tags: trunk

A new implementation for the sqlite3ExprImpliesExpr() theorem prover that
does a better job of answering TRUE to "(NOT A) OR B" when B is a NOT NULL
expression.
check-in: b3413197 user: drh tags: trunk

Disable the optimization where a REAL value with no fractional part
is stored as an INTEGER when the integer uses as much space as the real
value it proposes to stand in for (8 bytes). This avoids corner cases
of comparing integers against real values that are beyond the resolution
of an IEEE 754 double. Fix for ticket [6c1d3febc00b22d457c78c2]check-in: 9b091527 user: drh tags: trunk

Ensure that the sqlite3BtreeLast() interface initializes the *pRes return
to zero if the cursor is already sitting on the last entry of the table.
Manuel Rigger found the obscure test case for which this makes a difference.
check-in: ebe4845c user: drh tags: trunk

Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to
omit the case_sensitive_like pragma. This change, in combination with
documentation changes, is the current solution to ticket
[a340eef47b0cad5].
check-in: eabe7f2d user: drh tags: trunk

In the sqlite3_value or Mem object, make the MEM_IntReal type completely
independent from MEM_Int and MEM_Real. This helps avoid problems when
inserting non-float values into a "REAL" column.
check-in: 5a8a23ee user: drh tags: trunk

Add the SQLITE_TESTCTRL_RESULT_INTREAL test-control and use it to create
the intreal() SQL function in testfixture. Write a few simple tests to
prove this all works. TH3 will hold most of the INTREAL tests, probably.
check-in: c9838731 user: drh tags: int-real

Ensure that UTF16 strings are properly zero-terminated before returning them
in an sqlite3_value_text16() request, even if the string is invalid UTF16
because it was formed from an arbitrary and/or odd-length BLOB.
check-in: 3a16ddf9 user: drh tags: trunk

Make MEM_IntReal a completely independent type, meaning a floating point
value stored as an integer. This fixes a problem with arithmetic within
arguments to string functions on indexes of expressions. But it is a big
change and needs lots of new testcase() macros for MC/DC and so it is
initially put on this branch.
check-in: dba836e3 user: drh tags: int-real

The "LIKE Optimization" (which converts a LIKE into a BETWEEN operator that is
able to use an index) does not work and cannot be used if
the collating sequence of the column is not TEXT and if the pattern
starts with a "+" sign. This is another case of ticket
[c94369cae9b561b1f996d005]. The new test case was discovered by Manuel Rigger.
check-in: b043a54c user: drh tags: trunk

When values have real affinity and are converted into strings for CHECK
constraints or index expressions, do the conversions into a real-number format
even if the values are stored as integers for efficiency.
This appears to fix ticket [ae0f637bddc5290b446].
check-in: 5997d075 user: drh tags: trunk

Do not de-duplicate columns index columns associated with a WITHOUT ROWID table
if the columns have different collating sequences. This is the fix for
ticket [3182d3879020ef3b2]. There is one test case added, but most of the
tests are done in TH3.
check-in: 1b1dd4d4 user: drh tags: trunk

Fix a stack overflow that could occur when renaming a table that has a trigger containing a window function invocation that itself contains a specific syntax error.
check-in: c621fc66 user: dan tags: trunk

Take collating sequence into account when removing redundant columns from
indexes on WITHOUT ROWID tables. This is the first proof-of-concept fix
for ticket [3182d3879020ef3]. More testing needed.
check-in: b34fa5bf user: drh tags: tkt-3182d38790

Changes to the --hexdb decoder option in the shell (and also in the TCL
test code) so that it works on systems where sscanf() does not recognize
"%hhx" as wanting to delivery results into a character-size variable.
check-in: 4258e42d user: drh tags: trunk

Avoid a sanitizer error in test1.c. Have releasetest.tcl/wapptest.tcl create a file called "makecommand.sh" that can be used to rerun a test from the command line.
check-in: 4de4480f user: dan tags: trunk

Tweaks to wapptest.tcl: Ensure that the "Debug" checkbox is disabled unless the app is in "config" state, and have Debug variants run "test" instead of "fulltest".
check-in: dd248c18 user: dan tags: trunk

Further refinement of the sqlite3VdbeMEmExpandBlob() fix of check-in
[df58774e994bd] to prevent a reference to an unused variable - problem
discovered by Valgrind.
check-in: 09435b57 user: drh tags: trunk

Eliminate the tool/addopcodes.tcl script. The purpose of that script was to
keep the number of parser codes below 256 in order to save parser table space.
But we have long since blown through that ceiling so the addopcodes.tcl script
was just needless complexity. There is no longer any reason to keep it around.
check-in: d2728192 user: drh tags: trunk

In the xfer-optimization, do early detection of when the source and destination
index share the same btree, to avoid a long delay prior to reporting the
database corruption.
check-in: af1e5873 user: drh tags: trunk

This page was generated in about
0.012s by
Fossil 2.10 [b94e15cff7] 2019-09-13 13:54:36