Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
100 most recent check-ins
|
2019-08-24
| ||
| 21:02 | Minor performance improvement for balance_nonroot(). Leaf check-in: d7434cae user: dan tags: trunk | |
| 17:11 | Fix a potential buffer overrun in fts5 caused by corrupt database records. check-in: 156d6128 user: dan tags: trunk | |
|
2019-08-23
| ||
| 23:05 | Fix the built-in edit() SQL function in the CLI so that it works with zero-length blobs. check-in: e3249012 user: drh tags: trunk | |
| 21:11 | Attempt to parse the NULLS LAST clause more efficiently. A few cycles were saved, but at the expense of more code. And there is a bug was introduced somewhere. Not worth continuing down this line. Closed-Leaf check-in: 12d2cf88 user: drh tags: dead-end | |
| 20:33 | Move some things in parse.y so that TK_COLUMN and TK_AGG_COLUMN are assigned the same values as they are on trunk for a very small speedup. Leaf check-in: d26fdfa3 user: dan tags: nulls-last | |
| 17:09 | Revise the VDBE comments for NULL-scan so that they also work make sense when reading a NULLS FIRST plan. check-in: bfe79378 user: drh tags: nulls-last | |
| 17:00 | Additional simplifications of the WHERE loop code generator logic for NULLS LAST. check-in: 1383680d user: drh tags: nulls-last | |
| 16:12 | Simplification of the WHERE loop code generator for NULLS LAST saves a few CPU cycles and about a hundred bytes of code space. check-in: e3ed2f49 user: drh tags: nulls-last | |
| 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: bf875e1a 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: 649b08ea user: drh tags: nulls-last | |
|
2019-08-22
| ||
| 21:13 | Add additional VDBE coverage macros. check-in: d3531f5b 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: 63e625c8 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: 44578865 user: drh tags: trunk | |
| 11:11 | Fix a false-positive in sqlite3ExprNeedsNoAffinityChange(). Ticket [ac184eb571d5e6e0] check-in: e62eddbb 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: 81b9f0f5 user: drh tags: trunk | |
|
2019-08-21
| ||
| 19:58 | Add missing VdbeCoverage() macros to new code. check-in: b1cbcdc6 user: dan tags: nulls-last | |
| 17:46 | Disable broken test case in expert1.test. check-in: 73e30c2e user: dan tags: nulls-last | |
| 15:41 | Update this branch with latest trunk changes. check-in: 6153bcf4 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: d02490a2 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: 4c01e017 user: dan tags: trunk | |
|
2019-08-20
| ||
| 20:09 | Further tests for the special null-handling on this branch. check-in: 0dbbb51f 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: 00e9a8f2 user: dan tags: trunk | |
| 17:51 | Add tests for sort-by-index cases that use IN() and non-default NULL handling. check-in: 09d660ec user: dan tags: nulls-last | |
| 17:14 | Bring the hard-heap-limit branch up-to-date with trunk. Leaf check-in: 9b14eb77 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: a9a82ee8 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: 75aec4fc user: dan tags: trunk | |
| 13:49 | Add the new sqlite3_drop_modules() interface to the loadable extension mechanism. check-in: 658bd516 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: 511da081 user: dan tags: trunk | |
| 02:19 | Fix a typo and a harmless compiler warning. check-in: ec4c63e0 user: mistachkin tags: trunk | |
|
2019-08-19
| ||
| 20:44 | Add the sqlite3_drop_modules() interface. check-in: e2c6fed8 user: drh tags: trunk | |
| 20:35 | Omit the "_except" term from the name of the new interface. Closed-Leaf check-in: e5ba47c2 user: drh tags: sqlite3_drop_modules_except | |
| 19:59 | Fix problems with window frames that use ORDER BY ... NULLS LAST etc. check-in: 75d665a4 user: dan tags: nulls-last | |
| 17:26 | Prevent NULLS FIRST/LAST from being used in CREATE INDEX and other statements. check-in: bb9767a2 user: dan tags: nulls-last | |
|
2019-08-17
| ||
| 19:58 | Add some extra tests for the lsm virtual table module. check-in: 4cb009b0 user: dan tags: trunk | |
| 19:55 | Fix to the query planner for the LSM1 extension. check-in: 7496e872 user: drh tags: trunk | |
| 19:45 | The experimental sqlite3_drop_modules_except() interface. check-in: 0851db4d 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: 5d6f4dfe 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: 43e8b143 user: dan tags: trunk | |
| 18:16 | Add tests to ensure that this branch really does fix ticket [f8a7060ece]. check-in: f8920664 user: dan tags: nulls-last | |
| 17:55 | Fix problem with DESC indexes on this branch. check-in: b49df1fe 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: 500c9152 user: drh tags: trunk | |
| 15:47 | Merge trunk changes into this branch. check-in: db1e6080 user: dan tags: nulls-last | |
| 15:27 | Activate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. check-in: 9c4bca64 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: de767376 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: 31e34fa3 user: drh tags: trunk | |
| 21:07 | Add support for using indexes for some ORDER BY clauses that use non-default NULL handling. Still some problems on this branch. check-in: 81069d71 user: dan tags: nulls-last | |
|
2019-08-15
| ||
| 23:11 | Fix harmless compiler warnings in the TCL interface. check-in: f17e7229 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: 61b4bccd 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: fc745845 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: 98357d8c 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: 4f5b2d93 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: b2e79f8f user: drh tags: trunk | |
| 13:17 | Ensure that the cell overwrite optimization does not overwrite the header of the b-tree page. check-in: 4cc5694c 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: b517a52f 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: 4d41ca7d user: drh tags: trunk | |
|
2019-08-13
| ||
| 20:34 | Add some static to the 'regexp' extension. check-in: a21d1dde user: mistachkin tags: trunk | |
| 17:56 | Update test cases so that they work with ICU enabled. check-in: 408144a1 user: dan tags: trunk | |
| 17:27 | Update some corruption test cases to take [724f4df9c] into account. check-in: 927cd7b4 user: dan tags: trunk | |
| 15:22 | Merge latest trunk changes with this branch. Leaf check-in: 5b4689d8 user: dan tags: reuse-schema | |
| 15:11 | Fix a problem with RBU function sqlite3rbu_bp_progress() when used during an RBU vacuum. check-in: 8c44b02f 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: 7dae7b96 user: drh tags: trunk | |
| 16:36 | 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 | |
| 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: 636ca447 user: drh tags: trunk | |
| 15:37 | Fix the build for compilation using separate files rather than the amalgamation. Leaf check-in: 1e0f4869 user: drh tags: sha3 | |
| 15:19 | Make the sha3 extension part of the amalgamation, enabled using SQLITE_ENABLE_SHA3. check-in: a48a7b78 user: drh tags: sha3 | |
| 14:17 | Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. check-in: 48d9b48a 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: 724f4df9 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: da01ba4f user: drh tags: trunk | |
| 14:35 | Add extra test cases related to the previous commit. check-in: 3c690b2b 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: 712e4771 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: eaf15d9b user: drh tags: trunk | |
| 14:54 | 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 | |
| 01:59 | Modify signature of sqlite3VdbeChangeOpcode() to accept int instead of u32. check-in: 68b7f2ac user: mistachkin tags: trunk | |
| 01:11 | Fix more compiler warnings. check-in: 1b85442b user: drh tags: trunk | |
|
2019-08-08
| ||
| 19:40 | Fix harmless compiler warnings. check-in: 1eef4dde 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: f1cd234c 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: 83450d10 user: drh tags: trunk | |
| 16:23 | More legacy STAT3 code removed. Closed-Leaf check-in: 845d2f17 user: drh tags: omit-stat3 | |
| 15:47 | 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 | |
| 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: 1e17ea2f user: drh tags: omit-stat3 | |
| 11:44 | 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 | |
| 01:39 | Remove a NEVER() that is reachable from a corrupt database. check-in: 30e6ee27 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: 7f2246a1 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: f5d0436d user: dan tags: trunk | |
| 17:45 | Eliminate some more cases of redundant sorting in window-function queries. check-in: 8158d2ac 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: 193c87fc 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: 17b3d221 user: dan tags: trunk | |
| 20:55 | Improved reuse of file descriptors for which close() is delayed to prevent clearly of posix advisory locks. check-in: 509c1ba2 user: drh tags: trunk | |
| 20:26 | Enhance the ".recover" output in the shell to use double-quotes around table and column identifiers. check-in: 846d2d2d 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: bfc29e62 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: 9c8c1092 user: drh tags: trunk | |
| 15:18 | Performance optimization to the new affinity handling logic. Closed-Leaf check-in: c9724e76 user: drh tags: pending | |
| 15:02 | Add a multi-threaded test to threadtest3.c for the feature on this branch. check-in: 62557fab user: dan tags: reuse-schema | |
| 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: e8234f69 user: drh tags: pending | |
| 11:45 | Add an assert() to the code on this branch. check-in: fdd44bbb user: dan tags: reuse-schema | |
|
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: e15a0977 user: dan tags: pending | |
| 20:45 | Add test cases to this branch. Closed-Leaf check-in: f37317d8 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: 7480db30 user: dan tags: tkt-61c853-A | |
| 19:34 | 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 | |
| 19:32 | 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 | |