100 check-ins occurring around 1e0f4869dedabec0.

Fix the OP_SeekGE, OP_SeekGT, OP_SeekLE, and OP_SeekLT opcodes so that they
preserve the datatype of the value in the register used as the key.
Ticket [d9f584e936c7a8d0]check-in: 81b9f0f5 user: drh tags: trunk

Fix a segfault that could occur following an OOM while processing a SELECT statement for which one or more of the expressions in the window frame declaration are themselves sub-selects that use window functions.
check-in: 75aec4fc user: dan tags: trunk

When populating an ephemeral b-tree for the RHS of an IN(...) clause, avoid applying an affinity to a value that may be used later on for some other purpose. Fix for [c7a117190].
check-in: 43e8b143 user: dan tags: trunk

Ensure the functions that appear to be constant are not factored out of
expression that originate on the right-hand side of a LEFT JOIN.
Ticket [6710d2f7a13a2997]check-in: 500c9152 user: drh tags: trunk

Add the SQLITE_DBCONFIG_ENABLE_VIEW option, together with a "db config"
command in the TCL interface that can access that option as well as all the
other sqlite3_db_config() boolean options.
check-in: 61b4bccd user: drh tags: trunk

Ensure that the optional "sz=N" parameter that can be manually added to the
end of an sqlite_stat1 entry does not have an N value that is too small.
Ticket [e4598ecbdd18bd82]check-in: 98357d8c user: drh tags: trunk

Experimental implementation of NULLS FIRST/LAST. This branch still has problems - the most significant of which is that ORDER BY clauses with a non-default NULLS FIRST/LAST qualifier can never use an index.
check-in: 07babb0f user: dan tags: nulls-last

In shared-schema mode, handle the case where a connection has created a virtual-table object, but is later assigned a different shared-schema object for which the virtual-table schema has not yet been initialized.
check-in: e30c7414 user: dan tags: reuse-schema

Remove support for SQLITE_ENABLE_STAT3. The sqlite_stat3 table is now ignored,
if it exists. Run ANALYZE using STAT4 to get the equivalent functionality,
which presumably everybody has been doing for a long time now.
check-in: f1cd234c user: drh tags: trunk

Fix spurious "no such table: x1" errors in shared-schema mode that could occur
when a query that is a join across two or more databases needs to call the xConnect() methods of a virtual table.
check-in: edf45cd7 user: dan tags: reuse-schema

Remove support for STAT3. The sqlite_stat3 tables are ignored, if they
exist. STAT4 continues to work as it always has, and as it is a superset of
STAT3 is the recommended replacement.
check-in: 1e17ea2f user: drh tags: omit-stat3

Fix a bug causing "no such table" and other similar sqlite3_prepare*() errors to return SQLITE_SCHEMA instead of SQLITE_ERROR in shared-schema mode when there is an attached database for which the schema has never been loaded.
check-in: 111e2c73 user: dan tags: reuse-schema

Ensure that columns of views and sub-queries that are expressions with
no affinity are comparied without any type conversions, as required in the
documentation. Tickets [61c853857f40da49] and [d52a29a9e6bc55c5].
check-in: 9c8c1092 user: drh tags: trunk

Use 0x40 (ASCII '@') instead of 0x00 to mean "no affinity" so that columns
with no affinity can appear in a zero-terminated string. Use the new
SQLITE_AFF_NONE macro for this new magic number.
check-in: e8234f69 user: drh tags: pending

Ensure that columns of views and sub-queries that are expressions with no affinity are not assigned BLOB affinity. This matches the documentation. Fix for [61c853857f40da49]. (On a branch because there are still subtle issues.)
check-in: e15a0977 user: dan tags: pending

The second option for [61c853857f40da49]: In this mode, columns of VIEWs
and subqueries that are formed by expressions have affinity BLOB rather than
affinity none, as has usually been the case for a while. But this mode fixes
a couple of corner cases involving query flattening and the push-down
optimization where that rule was violated.
Closed-Leaf
check-in: 470ac8d5 user: drh tags: tkt-61c853-B

One of two options on how to address ticket [61c853857f40da49]. In this
mode, we back out the documentation change of
[07b7749da88d54e5]
and change the core to work as it has been documented to work since 2017,
rather than how it has actually worked since 2009.
check-in: 09cd0c0c user: drh tags: tkt-61c853-A

Refactor field Expr.affinity into Expr.affExpr to avoid confusion with other
fields and variables named "affinity" and display affExpr it in
sqlite3TreeViewExpr() output.
check-in: a29f2a7d user: drh tags: trunk

Fix a problem with renaming a table when a view or trigger within the schema uses a FILTER with an aggregate function that is not currently registered with the database.
check-in: 2ac0e42f user: dan tags: trunk

Give the SQLITE_TESTCTRL_PRNG_SEED two arguments. The second argument if not
NULL is a pointer to a database connection which seeds the connection from
its schema cookie. In this way, fuzzers can control the PRNG seed.
Closed-Leaf
check-in: 49aa3448 user: drh tags: prng-seed-test-control

If a query like "SELECT min(a), b FROM t1" visits no rows where "a" is not null, extract a value for "b" from one of the rows where "a" is null. Fix for ticket [41866dc37].
check-in: faaaae49 user: dan tags: trunk

If a query like "SELECT min(a), b FROM t1" visits no rows where "a" is not null, extract a value for "b" from one of the rows where "a" is null. Possible fix for ticket [41866dc37].
Closed-Leaf
check-in: a7277ed0 user: dan tags: tkt-41866dc37

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