aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
| * Internal doc typo fixes, as reported in the forum. No code changes.stephan2024-06-18
| | | | | | FossilOrigin-Name: ea16b286b4344c1833ca3d17b6d315fb4ddcb99bcc232ff6444debeb634881f2
| * Do not omit the ORDER BY clause from a recursive CTE just because the drh2024-06-14
| | | | | | | | | | | | query that contains the CTE also contains an ORDER BY clause. Plus other changes imported from the recursive-cte-orderby-fix branch. FossilOrigin-Name: 13242289c5d412b706f50fc7e1553032ea3a52d41a3e34e155432adaf0551481
| * Fix a problem with rolling back hot journals using the unix-dotfile VFS.dan2024-06-12
| |\ | | | | | | FossilOrigin-Name: a44703135e8dd3cc67e548e1aa3c42e71df127fb7b593ccfc06025ec42a501fd
| | * Handle the case where unix-dotfile is used with URI parameter nolock=1.dan2024-06-11
| | | | | | | | | FossilOrigin-Name: 3925a5b904e159d54455cfc73fe837a9c6ea3a6d60da63afde3242b4d6f67c90
| | * Fix a problem with rolling back hot journals using the unix-dotfile VFS.dan2024-06-11
| | | | | | | | | FossilOrigin-Name: 4ae3300b79e03381fd7f1033bb7978bb6367369790f17c3bdacac51e205edaf9
| * | Slight API doc tweak for xCheckReservedLock(), based on forum feedback. No ↵stephan2024-06-12
| |/ | | | | | | | | code changes. FossilOrigin-Name: 2af7a96f6868a4529d689702926b350a4c00082f14da0ded5a8eaea295682d17
| * When compiling shell.c in SQLITE_SHELL_FIDDLE mode, ensure that the ↵stephan2024-06-11
| | | | | | | | | | shell_main_exit goto label is reachable. FossilOrigin-Name: 06e6f64533563ab9c059b773e5f0d78085df716f2624e547b7259f6789c3ffe0
| * Change constant expressions to pre-computed constants, because apparentlydrh2024-06-11
| | | | | | | | | | | | MSVC on ARM requires that. [forum:/forumpost/4feb1685cced0a8e|Forum thread 4feb1685cced0a8e]. FossilOrigin-Name: 6c103aee6f146869a3e0c48694592f2e4c6b57ecdb4450f46e762c38b4e686f1
| * Improved header comment on the sqlite3FpDecode() implementation.drh2024-06-10
| | | | | | | | | | | | For the fpdecode() SQL function (available in debug builds only) limit the value of the third parameter (mxRound) to be positive. FossilOrigin-Name: 56af06fa12104a1fe119d7087746011183af053834eac72d0fb69f60d98054c6
| * Disable the omit-noop-join optimization when there are 64 or more terms indrh2024-06-09
| | | | | | | | | | the ORDER BY clause. FossilOrigin-Name: 40de3939792e17df25598b3e60d1cebcecde2b00832acd55604f14b21398a9a7
| * Better optimize queries that use parameters in the LIMIT clause.drh2024-06-06
| | | | | | FossilOrigin-Name: e58cb304d1e0ec6e30260a165aaccc2cf096ce6c999efb06683c4ef600ee12ef
| * Re-enable [dcc2bb2c562e97e090174], as [296eeb26c816bc73] corrects the ↵stephan2024-06-06
| | | | | | | | | | wasi-sdk build problem the former check-in triggered. Reported in [forum:143e40d7f4e79c66|forum post 143e40d7f4e79c66]. FossilOrigin-Name: f66608bd356efe492d1003663c2e1ccd7cfbf2d40393d256f8720149904ad2d5
| * Adjust the parser so that the value of TK_ISNOT is similar to the value ofdrh2024-06-06
| | | | | | | | | | | | TK_IS. This helps the compiler generate faster switch() statements on the Expr.op fields when there are cases for TK_ISNOT and other common operators. FossilOrigin-Name: 34f05c3d89b2dd15e4b0d1ba292df7de3dfc54b505c0ba145cc3db52cf020845
| * Small performance optimization in the operatorMask routine of the WHEREdrh2024-06-06
| | | | | | | | | | clause analysis logic. FossilOrigin-Name: 9d69fc1c87ae673356869ecd89eb19734fd126702c0f9fe595336ecd7be89e08
| * Small performance optimization in the allowedOp() routine of the WHEREdrh2024-06-06
| | | | | | | | | | clause analysis code. FossilOrigin-Name: 4ba8be544711e07748e8dd3ca6b81f9897906061c0a1a1bb4fb3808dc27f734b
| * Small performance optimization in the codeEqualityTerm() routine of thedrh2024-06-05
| | | | | | | | | | code generator. FossilOrigin-Name: 8080c6eafd1280ea870a6ab1ba715ac5af67387e69771be6cbd46dda77c3eaa8
| * Fix a very obscure issue where the name resolver could get confused if ↵dan2024-06-05
| | | | | | | | | | aliases like "sqlite_schema" or "sqlite_master" were used in a query involving the sqlite_temp_schema table. FossilOrigin-Name: a096eb7554952f8137c6e9330c328164719fb27e958787fbd503bcd1364e6ae4
| * Better handle WHERE terms that are common to two or more OR branches when ↵dan2024-06-04
| |\ | | | | | | | | | | | | planning virtual table queries. FossilOrigin-Name: 1976c3f7e1fe77cf3367710e8ada230a3672ed374e316425164e42b2622526c7
| | * Be more aggressive about freeing memory associated with thedrh2024-06-02
| | | | | | | | | | | | | | | sqlite3_index_info.idxStr field. FossilOrigin-Name: 85dcd0a8479a658203833cfd75f22813faa26d4793ebfbb8843035d683bee105
| | * Further tests for OR constraints on virtual tables.dan2024-05-31
| | | | | | | | | FossilOrigin-Name: ff4a30056f8dbcbd045afdbee485f6671c3580b95187144aa9a77c97dfda2647
| | * Better handle WHERE terms that are common to two or more OR branches when ↵dan2024-05-31
| | | | | | | | | | | | | | | planning virtual table queries. FossilOrigin-Name: 4edd9b29f58621335b8a562280c991c34804bbba090f90c951261d043cff1965
| * | Fix a couple of memory leaks in the shell tool code that could occur when ↵dan2024-06-04
| | | | | | | | | | | | | | | processing errors. FossilOrigin-Name: e84f09d469ee76a5b5e44baf6a69b90c69d4160fa4c32de04a96f868643acd96
| * | Allow shell command "testctrl pending_byte" to be used in unsafe-testing ↵dan2024-06-04
| | | | | | | | | | | | | | | mode only. FossilOrigin-Name: afa45c4f5afc9248ca4a1e775404a460280bb9a58a92eae508ae00fb2f675dc6
| * | Address a corner-case associated with the call-function-once optimizationdrh2024-06-03
| | | | | | | | | | | | | | | | | | | | | of check-in [663f5dd32d9db832] that was causing a (harmless) use of an uninitialized bytecode register. dbsqlfuzz 8a44f675401a8b1f68a43bf813c4f4f72ad8f0ea FossilOrigin-Name: b37ac2d020873b78efa164036db4056406a67330679f850775da520cd8027cb9
| * | Omit an unused #define.drh2024-06-03
| | | | | | | | | FossilOrigin-Name: 9c2de28a146e4cdfa4c05bf8dbd4ebb1156c71104001edf68e6dd5db21deb91f
| * | Modify three #if checks in os_unix.c to improve handling of SQLITE_OMIT_WAL ↵stephan2024-06-03
| | | | | | | | | | | | | | | on WASI builds. Based on the discussion in/around [forum:57e918431735128a|forum post 57e918431735128a]. FossilOrigin-Name: 296eeb26c816bc734530cf446922f25be970b901c884df1a98083502f0d1e9f5
| * | Do not even try star-schema detection if the join has fewer than 5 tables,drh2024-05-31
| | | | | | | | | | | | | | | since 5 is the minimum for a positive detection. FossilOrigin-Name: a07ec16bbc056fbc23a7bd58e5e32ef691c13e9babeb542918cf9a01cac40c20
| * | Document the OP_Explain opcode. Add the WhereLoop.rRun value as P3 indrh2024-05-31
| | | | | | | | | | | | | | | OP_Explain opcodes associated with WhereLoops, for testing purposes. FossilOrigin-Name: 996c46e61d9a53a54018672dd407b8ba8c480dd6795393428f9d5fcb81b47ab5
| * | Back out [dcc2bb2c562e97e090174], as it breaks the --with-wasi-sdk builds.stephan2024-05-30
| |/ | | | | FossilOrigin-Name: 62199562c26f77d059aa0bbda42a421a7aece828aa94d14a40c701a6384d1cf6
| * Remove the unconditional SQLITE_OMIT_WAL when building in wasi-sdk mode, per ↵stephan2024-05-30
| | | | | | | | | | [forum:80003e91a7a6cb4d|requests in the forum]. FossilOrigin-Name: dcc2bb2c562e97e090174d4d0970bfa1551e5eb4db022e6d232c4dd786818e45
| * Ensure that the second pass call to wherePathSolver() always reports a positivedrh2024-05-30
| | | | | | | | | | | | | | value for the estimated number of output rows. This fixes a long-standing (though exceedingly minor) problem that was only revealed by a new assert() added yesterday. dbsqlfuzz 545d6debc2da496ab2b915e33ea34d9a35a935df FossilOrigin-Name: a47c644fef71f3ab3dc584ea917eaab9a8e5b4c9dcb57bdd29747ba32108e85f
| * Update shell.c to use the msteve fork of linenoise, per /chat discussion.stephan2024-05-30
| | | | | | FossilOrigin-Name: ee92fa8366b743266b17c692499087c0d11b9302d096c3dfb4e6356b467e939e
| * Change an assert() (incorrectly) added by the previous check-in into adrh2024-05-29
| | | | | | | | | | testcase(). FossilOrigin-Name: 5e64b541d175c10a5df67ef3419ecd74fcb51392af5f5458973cea85ee6a3246
| * Small performance enhancement in wherePathSolver()drh2024-05-29
| | | | | | FossilOrigin-Name: bdab69641df4704f7b080cf7841bbf39da9160222f7b664a79ed662b70ca7b0a
| * Improvements to comments and debugging output.drh2024-05-29
| | | | | | FossilOrigin-Name: 85164ee155e42809fe34e6c6b6fbe0a2baa9d616326a811173a0b0c8a885fcce
| * Remember the amount of the heuristic cost adjustment associated withdrh2024-05-29
| | | | | | | | | | | | star schemas and compensate when computing whether or not to use Bloom filters. FossilOrigin-Name: 21daf2463ef70e6b5dc73ba5bf62b3d2fb504e9189f645ac74b513d3d8b979c2
| * Use a heuristic in the query planner to help it better cope with largedrh2024-05-29
| | | | | | | | | | star schema queries. FossilOrigin-Name: a98be0f548f277fab8f38a2dec6ddcbe7a7fff27856ba19e76ad8c5641894b7b
| * Fix a couple of assert() statements so that they cannot firedrh2024-05-28
| | | | | | | | | | | | when the SQLITE_TESTCTRL_INTERNAL_FUNCTIONS debugging capability is activated. dbsqlfuzz f5b347cf167a62fbe08062b2feee65cb9306e363. FossilOrigin-Name: 273504b74cb9c3cfa2497a1339e706a1f2d2c3ce81b23a16beb47da9292535e0
| * Tweaks to the query planner so that it is better able to deal with stardrh2024-05-28
| | | | | | | | | | queries with many dimensions and bad indexes. FossilOrigin-Name: 1e49081001f93b75ee499536f8a61a0f49225a1745117bb9267249c38c4bf803
| * Increase the number of parallel paths in the query solver from 12 to 20.drh2024-05-28
| | | | | | | | | | | | In the .wheretrace output, sort the parallel paths in order of increasing cost. FossilOrigin-Name: 8ba2c2f5cb31f7bcc426bec78457316ef11d0b5debf24e8da8c6fc2f95878b1e
| * Documentation typo fix. [forum:/forumpost/772d6688f5|Forum post 772d6688f5].drh2024-05-28
| | | | | | FossilOrigin-Name: 1f2f9c709eaee3c45664afa062f0fb2b912de446581066c87ea144b8ba55b55c
| * Improve the automatic-index decision such that no attempt is made to createdrh2024-05-28
| |\ | | | | | | | | | | | | | | | | | | | | | an automatic index on a column that is known to be non-selective because if its use in other indexes that have been analyzed. See [src:/tktview/8ff324e120|ticket 8ff324e120] and [forum:/forumpost/b21c2101a559be0a|forum post b21c2101a559be0a]. FossilOrigin-Name: 2a7603c327d11d5e6bc4d40c29151fea544d650f51200ff76efb921adb0c38df
| | * Avoid creating an automatic index on a column that is known to be not verydrh2024-05-27
| | | | | | | | | | | | | | | selective. FossilOrigin-Name: 70409763f70faa2a0f4f072fd318a687b109a0905cc57906ad7f80d2885fe6d9
| * | Query planner tuning: Increase the maximum number of simultaneous solutionsdrh2024-05-28
| |/ | | | | | | | | to track int eh solver from 10 to 12. FossilOrigin-Name: fe2e1dadbacbe6392ceed44fd287a2ed82189cb8055f35631d37967d9a7a5d1d
| * The previous check-in was a little two aggressive about skipping thedrh2024-05-27
| | | | | | | | | | initialization of entries in the CellArray.ixNx array. Fixed here. FossilOrigin-Name: 1b6d1fbcdecf14bc79dc7b5df50e585d2fcc1484a9987b863c190e8f7ba2c39f
| * Fix typo in comment used to generate parts of the documentation.drh2024-05-27
| | | | | | | | | | [forum:/forumpost/da5a2ca4db|Forum post da5a2ca4db]. FossilOrigin-Name: 428aadf0c71473ccb0681b2b7146281c62949ee99556873e49895d44eec7aee5
| * Very small performance increase and size reduction by removing unnecessarydrh2024-05-27
| | | | | | | | | | | | ALWAYS() macros from the btree balance logic and replacing them with special initialization of CellArray and some assert()s. FossilOrigin-Name: 32b79041d9b6858e4ffade5841898619c7d25d20c4638bf85447a2ca9cc4a3d3
| * Doc typo fix. No code changes.stephan2024-05-27
| | | | | | FossilOrigin-Name: eaf07fe69f383938dd394f58cedad3f16f146d9b48e66bc1ba17446cf75ffb3f
| * For compatibility with PostgreSQL, when right-hand side of the ->> operatordrh2024-05-27
| | | | | | | | | | | | is negative, it should index from the right side of the JSON array on the left-hand side. FossilOrigin-Name: 82365a45b96536c1146a384e5d3efce80a6ec469a54713c7f40bf15eb834b5fd
| * Fix a possible buffer overwrite in the ".import" command. ↵dan2024-05-27
| | | | | | | | | | [forum:/forumpost/0c447f0548|forum post 0c447f0548]. FossilOrigin-Name: 0fd958fa9b56a8ef254127e29800ca2a267590e86edf739bd339239b25a5da6e
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-20 02:26:51 +0000