/ Timeline
Login

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

50 descendants and 50 ancestors of [8c44b02f14]

2019-08-23
13:32
Invert the meaning of the regBignull flag so that it is 1 when doing the normal scan and 1 when scanning nulls. This enables the re-do jump at the bottom of the loop to be coded with a single OP_IfNotZero opcode, rather than a sequence of OP_If, OP_Integer, OP_Goto. check-in: bf875e1a25 user: drh tags: nulls-last
13:08
Extra VDBE comments in the NULLS LAST logic provide landmarks to help understand the EXPLAIN output. check-in: 649b08ead5 user: drh tags: nulls-last
2019-08-22
21:13
Add additional VDBE coverage macros. check-in: d3531f5be7 user: drh tags: nulls-last
19:35
Merge fixes from trunk. Also fix a reference to the KeyInfo.aSortOrder field, which should now be KeyInfo.aSortFlags check-in: 63e625c8eb user: drh tags: nulls-last
16:38
Fix the likely(), unlikely(), and likelihood() functions so that they have no affinity, just like any other function. Ticket [7e07a3dbf5a8cd26] check-in: 44578865fa user: drh tags: trunk
11:11
Fix a false-positive in sqlite3ExprNeedsNoAffinityChange(). Ticket [ac184eb571d5e6e0] check-in: e62eddbb04 user: drh tags: trunk
00:53
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: 81b9f0f550 user: drh tags: trunk
2019-08-21
19:58
Add missing VdbeCoverage() macros to new code. check-in: b1cbcdc6eb user: dan tags: nulls-last
17:46
Disable broken test case in expert1.test. check-in: 73e30c2e92 user: dan tags: nulls-last
15:41
Update this branch with latest trunk changes. check-in: 6153bcf41a user: dan tags: nulls-last
14:54
Avoid assuming that "column IS ?", where column is declared UNIQUE, matches only a single row (as "?" might be NULL). Fix for [b8689402]. check-in: d02490a2f0 user: dan tags: trunk
11:31
Fix a broken assert() in the fts3 snippet code that was failing for queries containging more than 64 phrases. check-in: 4c01e0170e user: dan tags: trunk
2019-08-20
20:09
Further tests for the special null-handling on this branch. check-in: 0dbbb51f4d user: dan tags: nulls-last
19:11
Fix a problem with fts5 "ORDER BY rank" queries when the fts5 table name requires quoting. check-in: 00e9a8f273 user: dan tags: trunk
17:51
Add tests for sort-by-index cases that use IN() and non-default NULL handling. check-in: 09d660ecde user: dan tags: nulls-last
17:14
Bring the hard-heap-limit branch up-to-date with trunk. Leaf check-in: 9b14eb7754 user: drh tags: hard-heap-limit
15:47
Do not pass ORDER BY clauses with non-standard NULL handling to virtual table implementations. check-in: a9a82ee88d user: dan tags: nulls-last
14:43
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: 75aec4fc88 user: dan tags: trunk
13:49
Add the new sqlite3_drop_modules() interface to the loadable extension mechanism. check-in: 658bd51623 user: drh tags: trunk
11:43
Retain the affinity of an expression in a WHERE clause when it is transformed to a reference to an index column on the same expression. Fix for [f043b113]. check-in: 511da08156 user: dan tags: trunk
02:19
Fix a typo and a harmless compiler warning. check-in: ec4c63e00c user: mistachkin tags: trunk
2019-08-19
20:44
Add the sqlite3_drop_modules() interface. check-in: e2c6fed8f8 user: drh tags: trunk
20:35
Omit the "_except" term from the name of the new interface. Closed-Leaf check-in: e5ba47c2d8 user: drh tags: sqlite3_drop_modules_except
19:59
Fix problems with window frames that use ORDER BY ... NULLS LAST etc. check-in: 75d665a494 user: dan tags: nulls-last
17:26
Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. check-in: bb9767a287 user: dan tags: nulls-last
2019-08-17
19:58
Add some extra tests for the lsm virtual table module. check-in: 4cb009b0f7 user: dan tags: trunk
19:55
Fix to the query planner for the LSM1 extension. check-in: 7496e872a1 user: drh tags: trunk
19:45
The experimental sqlite3_drop_modules_except() interface. check-in: 0851db4d33 user: drh tags: sqlite3_drop_modules_except
19:31
Fix the new ability to unregister virtual table modules so that it works for the automatic PRAGMA virtual tables. check-in: 5d6f4dfeea user: drh tags: trunk
19:13
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: 43e8b14314 user: dan tags: trunk
18:16
Add tests to ensure that this branch really does fix ticket [f8a7060ece]. check-in: f892066425 user: dan tags: nulls-last
17:55
Fix problem with DESC indexes on this branch. check-in: b49df1fe9b user: dan tags: nulls-last
17:07
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: 500c9152da user: drh tags: trunk
15:47
Merge trunk changes into this branch. check-in: db1e60800b user: dan tags: nulls-last
15:27
Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. check-in: 9c4bca64fb user: drh tags: trunk
00:53
The SQLITE_DIRECTONLY flag, when added to sqlite3_create_function() prevents the function from being used inside a trigger or view. check-in: de76737698 user: drh tags: trunk
2019-08-16
22:58
Add the ability to unregister a virtual table module by invoking sqlite3_create_module() with a NULL sqlite3_module pointer. check-in: 31e34fa339 user: drh tags: trunk
2019-08-15
23:11
Fix harmless compiler warnings in the TCL interface. check-in: f17e72291f user: drh tags: trunk
21:27
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: 61b4bccd29 user: drh tags: trunk
20:04
Provide the SQLITE_DIRECTONLY flag for app-defined functions that prohibits the use of those functions within triggers or views. Closed-Leaf check-in: fc745845d8 user: drh tags: directonly
14:35
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: 98357d8c12 user: drh tags: trunk
13:53
Ensure that SQLite does not attempt to process incompatible window functions in a single scan. Fix for [256741a1]. check-in: 4f5b2d9381 user: dan tags: trunk
13:46
Avoid downgrading SQLITE_CORRUPT errors detected by the schema parser into SQLITE_NOMEM or SQLITE_ERROR errors. check-in: b2e79f8ff0 user: drh tags: trunk
13:17
Ensure that the cell overwrite optimization does not overwrite the header of the b-tree page. check-in: 4cc5694cbd user: drh tags: trunk
00:04
Early detection out-of-bounds page numbers on the direct-overflow-read optimization gives consistent error messages regardless of whether or not the optimization is enabled. check-in: b517a52fa3 user: drh tags: trunk
2019-08-14
15:17
Always check for reads past the end of the file on the in-memory journal driver. This used to be an assert(). check-in: 4d41ca7d6e user: drh tags: trunk
2019-08-13
20:34
Add some static to the 'regexp' extension. check-in: a21d1dde73 user: mistachkin tags: trunk
17:56
Update test cases so that they work with ICU enabled. check-in: 408144a183 user: dan tags: trunk
17:27
Update some corruption test cases to take [724f4df9c] into account. check-in: 927cd7b4c5 user: dan tags: trunk
15:22
Merge latest trunk changes with this branch. check-in: 5b4689d89c user: dan tags: reuse-schema
15:11
Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. check-in: 8c44b02f14 user: dan tags: trunk
2019-08-12
18:26
Make sure the btree cursor overflow cache is cleared when overwriting a cell in sqlite3BtreeInsert(). Ticket [3cf9bb227e9a5d32] check-in: 7dae7b969e user: drh tags: trunk
16:25
For the ".testctrl prng_seed" command in the CLI, if the argument is "random" then select a random integer seed and print the seed value on stdout. check-in: 636ca4472c user: drh tags: trunk
14:17
Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. check-in: 48d9b48ab4 user: drh tags: trunk
00:08
Validate the type, name, and tbl_name fields of the sqlite_master table when loading the schema, unless writable_schema is engaged. check-in: 724f4df9cc user: drh tags: trunk
2019-08-10
15:06
Fix the sqliteExprImpliesExpr() routine so that it recognizes that "(NULL IS FALSE) IS FALSE" doe not imply "NULL NOT NULL". Ticket [9080b6227fabb466] check-in: da01ba4fa4 user: drh tags: trunk
14:35
Add extra test cases related to the previous commit. check-in: 3c690b2b05 user: dan tags: trunk
14:16
Remove two incorrect assert() statements from the logic used to derive column names and types from subqueries. check-in: 712e477148 user: drh tags: trunk
2019-08-09
20:26
Allow the RHS of a row-value IN operator to use a compound query with an ORDER BY clause. check-in: eaf15d9bae user: drh tags: trunk
01:59
Modify signature of sqlite3VdbeChangeOpcode() to accept int instead of u32. check-in: 68b7f2acf4 user: mistachkin tags: trunk
01:11
Fix more compiler warnings. check-in: 1b85442b61 user: drh tags: trunk
2019-08-08
19:40
Fix harmless compiler warnings. check-in: 1eef4ddea9 user: drh tags: trunk
19:19
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: f1cd234c98 user: drh tags: trunk
18:49
Fix a case of the Expr.affinity to Expr.affExpr refactor that was missed in the [a29f2a7d07beff64] check-in. check-in: 83450d1070 user: drh tags: trunk
16:23
More legacy STAT3 code removed. Closed-Leaf check-in: 845d2f17de user: drh tags: omit-stat3
15:24
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: 1e17ea2fd1 user: drh tags: omit-stat3
01:39
Remove a NEVER() that is reachable from a corrupt database. check-in: 30e6ee27a9 user: drh tags: trunk
2019-08-07
19:57
Remove use of the affinity() function from view.test, as it is only available in SQLITE_DEBUG builds. check-in: 7f2246a17b user: dan tags: trunk
18:34
Add "set TMP=%CD%" to the start of each msvc script output by releasetest_data.tcl. Otherwise, since binaries compiled with SQLITE_TEST all choose the same sequence of pseudo-random numbers, collisions between temp file names cause errors when running multiple tests in parallel. check-in: f5d0436d8d user: dan tags: trunk
17:45
Eliminate some more cases of redundant sorting in window-function queries. check-in: 8158d2aca6 user: dan tags: trunk
13:25
Do not make SQLITE_READ authorizer calls for tables without names, as all such tables will be internal-use-only tables for subqueries and whatnot. check-in: 193c87fc96 user: drh tags: trunk
2019-08-06
21:16
Ensure that when the col in an operator like "val IN(col)" is a column of a view, its affinity is not used to coerce val. Fix for [0a5e2c1d]. check-in: 17b3d2218c user: dan tags: trunk
20:55
Improved reuse of file descriptors for which close() is delayed to prevent clearing of posix advisory locks. check-in: 509c1ba26a user: drh tags: trunk
20:26
Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. check-in: 846d2d2d2f user: drh tags: trunk
18:40
Add "PRAGMA foreign_keys=OFF;" to the start of the script output by ".recover", just as is done for ".dump". check-in: bfc29e62ef user: dan tags: trunk
15:32
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: 9c8c1092a8 user: drh tags: trunk
15:18
Performance optimization to the new affinity handling logic. Closed-Leaf check-in: c9724e761b user: drh tags: pending
14:37
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: e8234f6939 user: drh tags: pending
2019-08-05
20:53
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: e15a0977dd user: dan tags: pending
20:45
Add test cases to this branch. Closed-Leaf check-in: f37317d81c user: dan tags: tkt-61c853-A
19:44
Fix the patch on this branch so that it works with sub-queries, as well as views. check-in: 7480db307c user: dan tags: tkt-61c853-A
19:32
One of two options on how to address ticket [61c853857f40da49]. In this mode, we back out the documentation change of [https://www.sqlite.org/docsrc/info/07b7749da88d54e5|[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: 09cd0c0c6e user: drh tags: tkt-61c853-A
18:01
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: a29f2a7d07 user: drh tags: trunk
16:22
Improved detection of corruption on the freeblock list of a btree page. check-in: 4b00799bdf user: drh tags: trunk
13:19
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: 2ac0e42f8a user: dan tags: trunk
12:55
Prevent an fts5 table from being its own content table, or part of a view that is the content table. check-in: b6d52c9364 user: dan tags: trunk
2019-08-03
19:06
Strengthen an assert() in the WHERE clause code generator for the min/max optimization. check-in: 1bd4b97d64 user: drh tags: trunk
16:37
Fix a problem with queries of the form "SELECT min(<expr>) ... WHERE <expr>=?" where there is an index on <expr>. Fix for [71e183ca]. check-in: d465c3eef4 user: dan tags: trunk
16:17
In the ".wheretrace 0x100" debugging mode, show the structure of the main parameters to sqlite3WhereBegin() calls. check-in: fd598e475d user: drh tags: trunk
01:40
Add the SQLITE_TESTCTRL_PRNG_SEED which can control the PRNG seed either directly or through the schema cookie of a supplied database connection. check-in: 2660e9292a user: drh tags: trunk
01:39
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: 49aa344806 user: drh tags: prng-seed-test-control
2019-08-02
21:03
Fixes to the PRNG_SEED pragma idea. check-in: c71098409c user: drh tags: prng-seed-test-control
20:45
Add the SQLITE_TESTCTRL_PRNG_SEED test control. check-in: 3ac5723164 user: drh tags: prng-seed-test-control
19:40
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: faaaae4940 user: dan tags: trunk
18:43
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: a7277ed062 user: dan tags: tkt-41866dc37
2019-08-01
22:48
The sqlite3_set_authorizer() interface should only expire prepared statements when it is setting a new authorizer, not when clearing the authorizer. And statements that are running when sqlite3_set_authorizer() is invoked should be allowed to continue running to completion. check-in: 961e2f08c3 user: drh tags: trunk
15:18
Add new release tests for windows to releasetest_data.tcl. check-in: 1b330ec24c user: dan tags: trunk
10:58
Fix a problem in ALTER TABLE triggered by views or triggers that include the construction "ORDER BY true" or "ORDER BY false". check-in: 8168021f9a user: dan tags: trunk
2019-07-31
21:08
Update "releasetest_data.tcl" so that it is a standalone script that generates sh or batch scripts to run each tcl test run at release time. Update wapptest.tcl to use it. check-in: 559c2dd672 user: dan tags: trunk
15:16
New test cases in test/fuzzdata8.db. check-in: 6e92d71c24 user: drh tags: trunk
12:13
Do not allow the json_set() function to overwrite the same element more than once. check-in: f237f60e4f user: drh tags: trunk