Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
74 check-ins using file src/vdbe.c version d24a43b6b1
|
2021-01-20
| ||
| 14:10 | Version 3.34.1 (Leaf check-in: 10e20c0b43 user: drh tags: release, patch, version-3.34.1, branch-3.34) | |
|
2021-01-19
| ||
| 20:38 | Fix an issue with sha3_query() when the first argument contains blank SQL statements. (check-in: a1a7a5f238 user: drh tags: branch-3.34) | |
| 20:17 | Bump the version number to 3.34.1. (check-in: cea7d0f8a3 user: drh tags: branch-3.34) | |
| 20:09 | Fix a problem handling sub-queries with both a correlated WHERE clause and a "HAVING 0" clause where the parent query is itself an aggregate. The problem was apparently introduced by check-in [6e6b3729e0549de0] (check-in: 30a4c32365 user: drh tags: branch-3.34) | |
| 20:04 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: 69e31d52b2 user: drh tags: branch-3.34) | |
|
2020-12-16
| ||
| 13:20 | Fix a typo in the sqlite3_free_filename() documentation. (check-in: 7316ee19c5 user: drh tags: branch-3.34) | |
|
2020-12-14
| ||
| 13:52 | Minor changes for test coverage. (Closed-Leaf check-in: e5a8fa50f4 user: drh tags: generalized-upsert) | |
|
2020-12-12
| ||
| 00:43 | More test cases. No new problems discovered. (check-in: f34dd67e2d user: drh tags: generalized-upsert) | |
| 00:28 | New test cases with corresponding bug fixes. (check-in: f22c21a94c user: drh tags: generalized-upsert) | |
|
2020-12-11
| ||
| 19:36 | Begin adding test cases. Fix one bug found so far. More are pending. (check-in: aadd67ddf2 user: drh tags: generalized-upsert) | |
| 17:11 | Small performance tweaks. (check-in: 5321d60c57 user: drh tags: generalized-upsert) | |
| 16:49 | Bug fixes so that legacy tests pass. New tests for new functionality have not yet been added. (check-in: aa76790e58 user: drh tags: generalized-upsert) | |
| 01:17 | Logic is in place to handle multiple ON CONFLICT clauses, but it does not work. Any use of ON CONFLICT will likely lead to memory faults. This is an incremental check-in to save my place. (check-in: 155142314f user: drh tags: generalized-upsert) | |
|
2020-12-10
| ||
| 20:31 | Use an iterator for the index loop in sqlite3GenerateConstraintChecks(). The idea is that this iterator can be enhanced to traverse the indexes in any order, as required by multi-index UPSERT. (check-in: 64a4a91ecc user: drh tags: generalized-upsert) | |
| 13:49 | Add an optional function to the chsumvfs extension. When activated by the SQLITE_CKSUMVFS_INIT_FUNCNAME macro, this function will invoke the file-control that sets the number of reserved bytes to 8. This can be used to initialize a cksumvfs database file by programming languages that do not have access to the sqlite3_file_control() interface. (check-in: 01841fb4bf user: drh tags: trunk) | |
| 12:49 | The DO UPDATE code generator searches for the correct ON CONFLICT clause to use. (check-in: a47e35ee2d user: drh tags: generalized-upsert) | |
|
2020-12-09
| ||
| 23:35 | Fix compilation issues with MSVC related to C99. (check-in: c0de6c1fb2 user: mistachkin tags: trunk) | |
| 20:30 | For upsert, the constraint check code generator uses a copy of the index list for the target table, which can potentially be reordered. (check-in: 3194c00c2c user: drh tags: generalized-upsert) | |
| 16:49 | Add tests for a 'delete' command on a contentless table where values that weren't actually inserted are NULL. (check-in: 818c647cec user: dan tags: trunk) | |
| 13:11 | Improved comments in sqliteInt.h. No changes to code. (check-in: 8ccb8d1d55 user: drh tags: generalized-upsert) | |
| 01:34 | Initialize all terms in the ON CONFLICT clause stack. (check-in: 5e683fd1cb user: drh tags: generalized-upsert) | |
|
2020-12-08
| ||
| 14:29 | Enhance UPSERT parsing to allow multiple ON CONFLICT clauses. Only the very last clause may omit the conflict target, but the conflict target may now be omitted for the DO UPDATE resolution. (check-in: 2ca62f4c71 user: drh tags: generalized-upsert) | |
|
2020-12-07
| ||
| 23:14 | Fix a bad assert() in math1Func(). (check-in: 4b28612913 user: drh tags: trunk) | |
| 21:19 | Fix to the --disable-math option to ./configure. (check-in: 99ff641849 user: drh tags: trunk) | |
| 21:13 | Many more math functions. Semantics follows PG wherever possible. (check-in: 6b93627b5d user: drh tags: trunk) | |
| 17:15 | Begin adding new SQL functions that depend on -lm: ceil(), ceiling(), floor(), ln(), log(), and log10() so far. More to follow. (check-in: 4db5f2f787 user: drh tags: trunk) | |
|
2020-12-04
| ||
| 17:05 | Fix harmless compiler warnings associated with the recent FTS5 enhancements. (check-in: 1db7c75191 user: drh tags: trunk) | |
| 16:58 | Fix a bug in the ".eqp" command of the shell that was introduced by the recent sqlite3SelectTrace/SQLITE_TESTCTRL_TRACEFLAGS changes. (check-in: fd02dffceb user: drh tags: trunk) | |
| 16:49 | Ensure that fts5 function matchinfo() is registered before running tests that use it in fts5corrupt3.test. (check-in: 932e05e093 user: dan tags: trunk) | |
| 16:26 | Fix a test script problem in walvfs.test. (check-in: 4c5076fbe4 user: dan tags: trunk) | |
| 16:25 | Fix an incorrect datatype no the sqlite3WhereTrace variable in test1.c. (check-in: 4e6dab30f6 user: drh tags: trunk) | |
| 16:09 | Eliminate the sqlite3_unsupported_selecttrace global variable by creating a new test-control to control SELECT tracing. Note that SELECT tracing is only available on debug builds. (check-in: fb07c4e3c7 user: drh tags: trunk) | |
| 16:04 | Further changes to the trace variables to try to eliminate (harmless) compiler warnings in all configurations. (Closed-Leaf check-in: 3a4c98b989 user: drh tags: traceflags-test-control) | |
| 01:17 | Alternative implementation of ".selecttrace" and ".wheretrace" that uses a test-control rather than global variables. (check-in: d36d6f2923 user: drh tags: traceflags-test-control) | |
|
2020-12-03
| ||
| 21:22 | When merging prefix lists in fts5, use 16-way merges instead of 2-way merges. This faster. (check-in: 026a93508e user: dan tags: trunk) | |
| 19:25 | Do not simulate OOM faults on the SQLITE_FCNTL_CKPT_START and SQLITE_FCNTL_CKPT_DONE file-controls, as those are write-only and the return value is always ignored. (check-in: 62a2d39483 user: drh tags: trunk) | |
| 14:21 | Enhance the generate_series() table-valued function to support negative step values. (check-in: 9b60fc4870 user: drh tags: trunk) | |
|
2020-12-02
| ||
| 20:07 | Prevent potential segfault in the sqlite-expert idxPopulateStat1 context cleanup code. (check-in: c24f13448b user: mistachkin tags: trunk) | |
| 19:08 | Allow a search for an N character prefix in fts5 to use a prefix index of size N+1, if no prefix index of size N exists. (check-in: 78a7801d8f user: dan tags: trunk) | |
| 18:27 | Fix the ".open" command in the CLI so that it accepts command-line options both before and after the filename. (check-in: d330bf0c02 user: drh tags: trunk) | |
| 16:23 | Improve performance for fts5 column filters that filter for more than one column. e.g. "{col1 col2 col3}:phrase". (check-in: d8de2f236d user: dan tags: trunk) | |
| 02:58 | Parameterize the hash function in mkkeywordhash.c. This was an attempt to find a better hash function, which turned out to not be successful. (check-in: 2195d731f5 user: drh tags: trunk) | |
| 00:22 | Increase the version number to 3.35.0 to begin the next development cycle. (check-in: edbabaa308 user: drh tags: trunk) | |
| 00:20 | Slightly faster tokenization of non-keyword identifiers. (check-in: 55fa22bd40 user: drh tags: trunk) | |
|
2020-12-01
| ||
| 23:18 | Add the --lookaside SIZE COUNT command-line option to the dbfuzz2 testing tool. (check-in: 2466960c0b user: drh tags: trunk) | |
| 16:14 | Version 3.34.0 (check-in: a26b6597e3 user: drh tags: trunk, release, major-release, version-3.34.0) | |
|
2020-11-30
| ||
| 18:52 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (check-in: 23212b1a05 user: dan tags: trunk) | |
| 18:43 | Update the tea/win/makefile.vc file that ships as part of the autoconf package to use "sqlite3" instead of "tclsqlite3" for the installed dll filename. (Closed-Leaf check-in: 93d4d9dc05 user: dan tags: win-tea-fix) | |
| 14:20 | Do not reuse the obsolete SQLITE_TESTCTRL_PRNG_RESET value for SQLITE_TESTCTRL_SEEK_COUNT. Give SEEK_COUNT its own unique value. This avoids incompatibility with legacy test code. (check-in: fdba0b1290 user: drh tags: trunk) | |
|
2020-11-27
| ||
| 20:56 | Improve the speed of the tokenizer by recognizing that tokens starting with letters "_", "Y", or "Z" can never be SQL keywords and must be ordinary identifiers. (Closed-Leaf check-in: 16e281ed62 user: drh tags: faster-tokenizer) | |
| 19:40 | Fix a compiler warning in fts5_aux.c. (check-in: 8edb983bc8 user: dan tags: trunk) | |
| 16:15 | Add missing cast to fts5 bm25() code. (check-in: 6ff9673847 user: dan tags: trunk) | |
| 16:08 | Remove a redundant "if( rc==SQLITE_OK )" from the fts5 bm25() code. (check-in: d85f4f27f5 user: dan tags: trunk) | |
| 16:05 | Move an "if( rc==SQLITE_OK )" to outside a loop body in the fts5 bm25() code. (check-in: 14a4dcf347 user: dan tags: trunk) | |
| 15:28 | Fix a case in the FTS5 integrity check where a corrupt database could cause a buffer overread. (check-in: a32b4f650d user: dan tags: trunk) | |
|
2020-11-26
| ||
| 20:13 | Update mkunicode.tcl to match the change erroneously made to machine generated file fts5_unicode2.c in [b7b7bde9]. (check-in: 326d579d77 user: dan tags: trunk) | |
|
2020-11-25
| ||
| 18:44 | Update a requirement mark in the e_expr.test script. (check-in: bb174a074b user: drh tags: trunk) | |
| 16:28 | Fix harmless compiler warnings about unused function parameters. (check-in: 25d067c270 user: drh tags: trunk) | |
| 15:29 | Fix a potential NULL pointer dereference in the geopoly_overlap() routine of the GeoPoly extension. (check-in: b5665712e6 user: drh tags: trunk) | |
| 14:50 | Fix the shell1.test test script so that it works on windows. (check-in: 9bd15b07e5 user: drh tags: trunk) | |
| 13:59 | Change the -init option to the command-line shell to honor the -bail option. Also change it to report an error if the filename mentioned cannot be opened. (check-in: a29f54bd2c user: drh tags: trunk) | |
|
2020-11-24
| ||
| 23:40 | Fix a typo in the sqlite3_txn_state() documentation. (check-in: 5b4325295b user: drh tags: trunk) | |
| 21:19 | Add the new sqlite3_txn_state() interface to the set of routines accessible by run-time loadables extensions. (check-in: db25f1dc8e user: drh tags: trunk) | |
| 19:55 | Fix a harmless typo in a comment. (check-in: b2a201f1b5 user: drh tags: trunk) | |
| 17:55 | Fix a bug in OOM handling code introduced by [6a28713d]. (check-in: 8a786ce994 user: dan tags: trunk) | |
| 16:44 | Ensure that super-journal and other journal filenames passed by SQLite to an sqlite3_vfs.xOpen() implementation may be safely passed to sqlite3_uri_parameter() and similar functions. (check-in: 6a28713d59 user: dan tags: trunk) | |
| 13:14 | Remove the VERSION_NUMBER macro from configure.ac as it has been unused since 2009 check-in [7f4810747b086498]. See also forum post bb2c634fcd. (check-in: 5466dd55d4 user: drh tags: trunk) | |
|
2020-11-23
| ||
| 21:05 | Syntactic changes to work around a bug in gcov 9.3.0. No changes to the generated code for release builds. (check-in: 4f1573b146 user: drh tags: trunk) | |
| 17:36 | In os_unix.c, put ALWAYS() on unreachable branches associated with pathname normalization. (check-in: b45a08e3c7 user: drh tags: trunk) | |
| 15:30 | Fix a test script problem causing crash8.test to fail when run with leak-sanitizer. (check-in: 2c437f7a2c user: dan tags: trunk) | |
| 14:50 | Allow "substring()" as an alias for "substr()" for compatibility with other SQL engines. (check-in: aa2ee5754c user: drh tags: trunk) | |
|
2020-11-20
| ||
| 14:16 | Add file doc/vdbesort-memory.md, containing notes on the way vdbesort.c uses heap memory. (check-in: 07f53899a9 user: dan tags: trunk) | |
|
2020-11-19
| ||
| 21:12 | The xFullPathname method of the unix VFS now normalizes the filenames by omitting surplus "/", "/./" and "/../" strings. (check-in: c38dec6f52 user: drh tags: trunk) | |
| 19:43 | Use an ephemeral table rather than a RowSet to remember rowids in the two-pass UPDATE algorithm, as this uses much less memory for large UPDATEs. (check-in: 842c432772 user: drh tags: trunk) | |