aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * | | Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain theredrh2023-06-10
| | | | | | | | | | | | | | | | | | | | are no errors and the page size has been set. FossilOrigin-Name: 70e12efd1b189560e07f59db03a20b8c1ab19224aae4fc3d7c0bdfd2568064ea
| * | | Fix an assert that can go bad if STAT4 content is corrupt. This is adrh2023-06-10
| | | | | | | | | | | | | | | | | | | | follow-up to the previous check-in. FossilOrigin-Name: ac1d3860af4eb30e4a7444b01d7b5afc91a4b1f5e3fe5414a491c6edc7ff1631
| * | | Extra space to prevent a buffer overread on corrupt STAT4 records.drh2023-06-10
| | | | | | | | | | | | | | | | | | | | dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca. FossilOrigin-Name: b99135288b157044e2319833e8632c89483778f876aa45ee66e46ffb6ae42ab2
| * | | Simplify a memcpy() in defragmentPage(). It now might copy more content thandrh2023-06-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. FossilOrigin-Name: 6e5607ae4d872954483a8d7a5c866aa41e4af70fae9652fb7eb211b316ab724d
| * | | Fix straggler misspellings and tidy the custom dictionary. Also include ↵larrybr2023-06-07
| |\ \ \ | | | | | | | | | | | | | | | | | | | | pickups from [forum:/info/c61fb09afd|forum post c61fb09afd]. FossilOrigin-Name: 8c291d99946eb32b20b743921202f9c7cfb716268ff526817b27adbb7942e40b
| | * | | Remove additional traces of FTS1 and FTS2 that were missed by [2bb50d5aedef0fd2]drh2023-06-07
| | | | | | | | | | | | | | | FossilOrigin-Name: 9a12bac5d24c7a8364d2127fd12c3409a53ef83e408d10f344ddd311cdba98af
| * | | | Add a C-source spell-checking facility. make misspell (on Nix)larrybr2023-06-07
| |/ / / | | | | | | | | FossilOrigin-Name: 26c1bb4bd9e9f56613c3aa87407a7f562fd4ebde5bfd6dece02078001d9a45f8
* / / / Prototype implementation of the octet_length() SQL function.drh2023-06-03
|/ / / | | | | | | FossilOrigin-Name: 2db989c8635f7e89b3ea58d1fde94787fced039ac1a118d9b6362811eda73f87
* | | Clarify sqlite3_is_interrupted() return. No code change.larrybr2023-06-02
| | | | | | | | | FossilOrigin-Name: b6c2d3d203100a34335aeba23a8fb82a13297b65eed494d5044ade3bed683bc3
* | | Restore the LEFT JOIN strength reduction that was partially lost indrh2023-06-02
| | | | | | | | | | | | | | | [d747afda5683ca5f] when strength reduction was generalized to all OUTER JOINs. FossilOrigin-Name: 2d962b84dd8ac2d0968f0283f8f082c1c2a7a1f99b59053b2ad8f58745396447
* | | Do that last CLI fix more simply, using established means.larrybr2023-06-02
| | | | | | | | | FossilOrigin-Name: a1823b297616bc2bd64eda9df4850fb460d8da8959ae3728195db896d1f89e7b
* | | Fix CLI fault on missing -nonce reported by [forum:/info/f8c14a1134|forum ↵larrybr2023-06-02
| | | | | | | | | | | | | | | post f8c14a1134]. FossilOrigin-Name: cd24178bbaad4a1dafc3848e7d74240f90030160b5c43c93e1e0e11b073c2df5
* | | Fix the OUTER JOIN strength reduction theorem prover's handling of the CASEdrh2023-06-02
| | | | | | | | | | | | | | | operator. FossilOrigin-Name: 73d7b14b1713d93c4ae07995e9aa6485cbad90bd6125584dbaeccb0cc9410ea3
* | | Generalize the LEFT JOIN strength reduction optimization so that it works fordrh2023-06-01
| | | | | | | | | | | | | | | | | | RIGHT and FULL JOIN as well. Rename it to the "OUTER JOIN strength reduction" optimization. FossilOrigin-Name: d747afda5683ca5feb92866a14ccc4c5127d3378ece5cad2c3da819f2477b457
* | | If the filename argument to sqlite3_load_extension() is an empty string, thendrh2023-06-01
| | | | | | | | | | | | | | | | | | | | | raise an error. It turns out that if dlopen() is called with an empty filename, it tries to load the current executable. And then if the caller requests some other function from the current executable, mischief can result. FossilOrigin-Name: d01688554715eb4aaa1b1fd1a6b660b84e930edb0e062156ecf5228ee81ca754
* | | Add an ALWAYS() on an unreachable branch.drh2023-06-01
| | | | | | | | | FossilOrigin-Name: a00928d48061c1169d5564996e19e7d7c2b962842100bb119846d0f696123c23
* | | Fix the LEFT JOIN strength reduction for IN operators in the WHERE clause.drh2023-06-01
| | | | | | | | | | | | | | | Further simplifications and refinement of the algorithm. FossilOrigin-Name: 96c72dde79d4069f6c2f81467a35b617633f86f7a7dcafbda991affdaa1f8537
* | | Add a comment to explain why both sides of an AND must be non-null-row in orderdrh2023-05-31
| | | | | | | | | | | | | | | for the overall expression to be non-null-row. No code changes. FossilOrigin-Name: 8396032ce14a75f408f0a75bcb36a6504d5188f20886e275746a2c336a74296f
* | | Improved detection of when the LEFT JOIN strength reduction optimizationdrh2023-05-31
| | | | | | | | | | | | | | | can be applied. FossilOrigin-Name: f544a8e47cdd5ad7233887a558489983f4f305a39391ff463c43e2e4157da087
* | | Minor enhancement to the sqlite3_trace_v2() documentation. No codedrh2023-05-31
| | | | | | | | | | | | | | | changes. FossilOrigin-Name: fba97230e38276f2a02fc24353c3d911dfa24f3a4f75f691de9461d4daf3ae54
* | | Simplifications to the new timediff() logic.drh2023-05-30
| | | | | | | | | FossilOrigin-Name: d6954259bd3f8475f3804fd02a1591d037efa9df54da45776863c024ff90e596
* | | All date/time modifiers of the form (+/-)YYYY-MM-DD without the followingdrh2023-05-30
| | | | | | | | | | | | | | | HH:MM:SS.SSS. FossilOrigin-Name: fa9237a8ab803ca3f67fe753516b7bdb98be3d625e8e241ddf9b02509210e225
* | | Problems fixed. All tests are passing now.drh2023-05-30
| | | | | | | | | FossilOrigin-Name: cff293b0a79107def7bfe54fd60ac4a721c5098c85229d9b46a4e2c4cbf34a6a
* | | Improvements to the timediff() function. Test cases added. Not all testdrh2023-05-30
| | | | | | | | | | | | | | | cases are passing. FossilOrigin-Name: 2cf6518140d61e2123dc20f39d7e97e7bce17e7641405df7fd63e1cdda444ae0
* | | New date/time modifier: (+|-)YYYY-MM-DD HH:MM(:SS.SSS)?drh2023-05-29
| | | | | | | | | FossilOrigin-Name: 3832b8a9ef84d9b53b48dfce9c1e724897cd7b3e05711e01675419655f894eac
* | | Prototype implementation of a proposed "timediff(X,Y)" SQL function.drh2023-05-29
| | | | | | | | | FossilOrigin-Name: 054a195125a273bab026ada5f07cc7c32818007027a1fd028ca59d2f179276d4
* | | Avoid performing aggregate processing more than once for a single ↵dan2023-05-23
| | | | | | | | | | | | | | | expression. [forum:/info/36ff78b2a3|Forum post 36ff78b2a3]. FossilOrigin-Name: 367b4cc549a14222d54530538e692e9d1a365002c1b8c4ef80ddc0523bfdb3a2
* | | When converting an aggregate expression to AGG_COLUMN, be sure to removedrh2023-05-23
| | | | | | | | | | | | | | | | | | the EP_Unlikely flag if it is present. [forum:/info/fbfe330a2009d036|Forum post fbfe330a2009d036]. FossilOrigin-Name: 48e65f18b2ebbe786e84e208f2c6c68de6067ba86912fea5a120fd41d0af2184
* | | Avoid duplicate WIN32_LEAN_AND_MEAN #define. Fix a trivial nit likely never ↵larrybr2023-05-22
| | | | | | | | | | | | | | | observed. FossilOrigin-Name: 81ffcf41d69ae73ee8c037f675e18e2b46a15bee34062914640456381262d6fc
* | | Improved documentation for sqlite3_reset(), in response todrh2023-05-19
| | | | | | | | | | | | | | | [forum:/forumpost/a72bab3dea|forum post a72bab3dea]. FossilOrigin-Name: 1dfeb3dceee8f30daf5462683f264b9de23e7068e036e70b11ee1b608ac2f7fa
* | | Correct typo in an 'extern' decl name, reported in ↵stephan2023-05-19
| | | | | | | | | | | | | | | [forum:1d4342156439233b|forum post 1d4342156439233b]. FossilOrigin-Name: 6ac18827d8c5be35442dc452af703023c759916c179f165c4e54b3e430a8f7b0
* | | Fix incorrect b-tree root page reports from the enhanced PRAGMA integrity_checkdrh2023-05-18
| | | | | | | | | | | | | | | output introduced in version 3.42.0. FossilOrigin-Name: 9b538f62539bcde7d7d7ad06eccdc558ecbd3f9160db35197568f4d3b4247c76
* | | Fast-path the btree transaction start for the common case where adrh2023-05-17
| | | | | | | | | | | | | | | transaction is already active. FossilOrigin-Name: 798c3ff20c606b5f9fde16dc67781f238370a7c450bc239c3a98d0f4ca370399
* | | Simplification, performance improvement, and size reduction in thedrh2023-05-17
| | | | | | | | | | | | | | | codeAllEqualityTerms() function of the code generator. FossilOrigin-Name: 4fbe02651e877e442d62308d7f607e503695104cd71c5565132fcd1398c120df
* | | New assert() statements to verify that Expr.iColumn is never used as andrh2023-05-17
| | | | | | | | | | | | | | | array index when its value is negative. FossilOrigin-Name: 6084c5fb6d3fcedf35cd6c597a44ec7bf8b4a2576c7b277e5342d2a7905318e7
* | | Improved assertions on substExpr().drh2023-05-17
| | | | | | | | | FossilOrigin-Name: 6dbd5b3cc801a75ea23842a43eb7106b62fc1d26dd5a8477a0217325539a7c1a
* | | Avoid an assert() failure that could occur in ↵dan2023-05-17
| | | | | | | | | | | | | | | SQLITE_ENABLE_UPDATE_DELETE_LIMIT builds when a WITH clause attached to an UPDATE or DELETE statement created a CTE of the same name as the table being modified. FossilOrigin-Name: 8edf56d1698c3db38250db3b25864f658488414efb3a6b3e1443283b6affd26d
* | | Fix two assert() statements that failed to take into accountdrh2023-05-17
| | | | | | | | | | | | | | | the likely() built-in function. This does not impact production code. FossilOrigin-Name: 8504fe812c5b4956c8acad515d537add54cb591bc81747113f9b24526d7685b8
* | | As evidenced by [forum:/forumpost/f3f546025a|forum post f3f546025a], thedrh2023-05-15
| | | | | | | | | | | | | | | | | | | | | | | | | | | new RIGHT JOIN related restriction on the push-down optimization implemented by [da3fba18742b6e0b] also needs to apply to the automatic index (a.k.a. hash-join) optimization and to the Bloom filter optimization. Computation of the restriction is now moved into the sqlite3ExprIsSingleTableConstraint() routine. FossilOrigin-Name: 4902015dcf3869f08d9986e422faa231d9218a5e0fc59ba8df0f407e4eb3d605
* | | Simplify the interface to constructAutomaticIndex().drh2023-05-15
| | | | | | | | | FossilOrigin-Name: c5da16551619718bf649c517515261706843e11e131f0b99e1fd6927d0f7e238
* | | Remove unnecessary call to sqlite3_dbdata_init() from shell.c.dan2023-05-13
| | | | | | | | | FossilOrigin-Name: 84ca2000007d217f911a3b1586143fc9261c0697a9e9fadda6bd3dd6afdfb099
* | | Add an "#ifndef SQLITE_HAVE_SQLITE3R" directive to shell.c.in, to avoid ↵dan2023-05-13
| | | | | | | | | | | | | | | including the recovery code a second time if the shell is being compiled with sqlite3r.c. FossilOrigin-Name: 6f1a60fb7b3ef463b4131dfecbc72b7c778c794a9aa13ce4617ab6dd895508b2
* | | Mention that sqlite3_mutex_free() accepts NULL as a no-op.larrybr2023-05-13
| | | | | | | | | FossilOrigin-Name: 603d9ad5012ca8996783996d7b8cd6a1aabf12b21604a2ccc137f4c2d99427b9
* | | Fix unlikely strange result of CLI edit().larrybr2023-05-12
| | | | | | | | | FossilOrigin-Name: ab3797e844c97fed344b36f30cfb788aca9e0d68c574fb833712219eb712db44
* | | Ensure the _O_U16TEXT is defined for Windows builds of the CLI.drh2023-05-12
| | | | | | | | | | | | | | | [forum:/forumpost/c80aa942dc6bf2|Forum post c80aa942dc6bf2]. FossilOrigin-Name: 504effa89b48c0dc6cd12b3eaf6017be3f32017c601af17759a3cc185346d868
* | | Remove a stray CR from end of line in a source file.drh2023-05-12
| | | | | | | | | FossilOrigin-Name: 48139fb904de4b7b383e7f8c29bed83ad878eb22b1dd773c366a0aee74613d23
* | | Fix harmless typos in comments.drh2023-05-12
| | | | | | | | | FossilOrigin-Name: 607c3efbe0293d7c11a955a9f21e24fb9f7f1bb758e13e60f4ba0cc0ac8b900c
* | | Ensure that all prepared statements are expired and forced to repreparedrh2023-05-12
| | | | | | | | | | | | | | | | | | whenever the database text encoding changes. [forum:/forumpost/43cbfc4d23|Forum post 43cbfc4d23]. FossilOrigin-Name: 469718f106e1cfa7f8f4714a9e743108c361af81e0258061c2b76880a7c352ae
* | | Add [/info/cec6a06508239c09e363?ln=5525-5531|restriction (5)] to thedrh2023-05-11
| | | | | | | | | | | | | | | | | | omit-noop-join optimization. Fix for the issue reported by [forum/forumpost/49f2c7f690|forum post 49f2c7f690]. FossilOrigin-Name: 3e9c9bbdb59b9d500ff218db538c047c83da7ac18ebb95c3ee7629ab15e0b43a
* | | Fix a minor typo in a comment. No code changes.drh2023-05-11
| | | | | | | | | FossilOrigin-Name: 607cfb5bc5c0fb8b789944c2326cfdebf0629e45fbf0a61dd5f667ed685a1bbe
generated by cgit v1.2.3 (git 2.25.1) at 2025-06-15 11:30:14 +0000