Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins
|
2024-05-31
| ||
| 20:32 | Further tests for OR constraints on virtual tables. Leaf check-in: ff4a30056f user: dan tags: xbestindex-or-terms | |
| 19:26 | Better handle WHERE terms that are common to two or more OR branches when planning virtual table queries. check-in: 4edd9b29f5 user: dan tags: xbestindex-or-terms | |
| 15:39 | Do not even try star-schema detection if the join has fewer than 5 tables, since 5 is the minimum for a positive detection. Leaf check-in: a07ec16bbc user: drh tags: trunk | |
| 14:39 | Document the OP_Explain opcode. Add the WhereLoop.rRun value as P3 in OP_Explain opcodes associated with WhereLoops, for testing purposes. check-in: 996c46e61d user: drh tags: trunk | |
|
2024-05-30
| ||
| 21:54 | Back out [dcc2bb2c562e97e090174], as it breaks the --with-wasi-sdk builds. check-in: 62199562c2 user: stephan tags: trunk | |
| 17:56 | Remove the unconditional SQLITE_OMIT_WAL when building in wasi-sdk mode, per [forum:80003e91a7a6cb4d|requests in the forum]. check-in: dcc2bb2c56 user: stephan tags: trunk | |
| 13:27 | Ensure that the second pass call to wherePathSolver() always reports a positive 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 check-in: a47c644fef user: drh tags: trunk | |
| 11:25 | Experimentally enable linenoise multiline mode in shell.c. Closed-Leaf check-in: 33ad9d8a3c user: stephan tags: linenoise-multiline | |
| 11:14 | Update shell.c to use the msteve fork of linenoise, per /chat discussion. check-in: ee92fa8366 user: stephan tags: trunk | |
|
2024-05-29
| ||
| 15:16 | Remove an unused parameter from fts5ConfigParseSpecial(). Compiler-warning fix only - no functional changes. check-in: c08dd245f7 user: drh tags: trunk | |
| 15:08 | Use a heuristic of artifically lowering the cost of fact tables in a star-schema query in order to prevent plans where the fact tables are in outer loops from being trimmed by the path limiter. This helps to generate better (faster) query plans in those particular cases. check-in: 38db9b5c83 user: drh tags: trunk | |
| 14:32 | Change an assert() (incorrectly) added by the previous check-in into a testcase(). Closed-Leaf check-in: 5e64b541d1 user: drh tags: star-schema | |
| 14:04 | Small performance enhancement in wherePathSolver() check-in: bdab69641d user: drh tags: star-schema | |
| 13:29 | Improvements to comments and debugging output. check-in: 85164ee155 user: drh tags: star-schema | |
| 10:40 | Remember the amount of the heuristic cost adjustment associated with star schemas and compensate when computing whether or not to use Bloom filters. check-in: 21daf2463e user: drh tags: star-schema | |
| 09:53 | Fix typos in the star-schema test cases. check-in: 4080937353 user: drh tags: star-schema | |
| 03:35 | Fix sqldiff out-of-bounds char classification error [forum:/forumpost/c9b8d923d5|mentioned in the forum.] check-in: b31933d873 user: larrybr tags: trunk | |
| 00:38 | Use a heuristic in the query planner to help it better cope with large star schema queries. check-in: a98be0f548 user: drh tags: star-schema | |
|
2024-05-28
| ||
| 19:08 | Fix a couple of assert() statements so that they cannot fire when the SQLITE_TESTCTRL_INTERNAL_FUNCTIONS debugging capability is activated. dbsqlfuzz f5b347cf167a62fbe08062b2feee65cb9306e363. check-in: 273504b74c user: drh tags: trunk | |
| 18:53 | Tweaks to the query planner so that it is better able to deal with star queries with many dimensions and bad indexes. check-in: 1e49081001 user: drh tags: trunk | |
| 18:41 | Fix another problem with the sqlite3_log() message identifying the table or index that a conflicting page belongs to. Leaf check-in: 19d5fd8a48 user: dan tags: bedrock | |
| 18:35 | Fix another problem with the sqlite3_log() message identifying the table or index that a conflicting page belongs to. Leaf check-in: d033d94350 user: dan tags: begin-concurrent | |
| 15:37 | For query planning purposes, assume every table holds at least 100 rows, as this seems to give better worst-case performance if the table row count estimate turns out to be inaccurate. Park this change on a branch for now and consider it for a future enhancement. Leaf check-in: 76c7d9334f user: drh tags: min-row-estimate | |
| 12:41 | Increase the number of parallel paths in the query solver from 12 to 20. In the .wheretrace output, sort the parallel paths in order of increasing cost. check-in: 8ba2c2f5cb user: drh tags: trunk | |
| 11:24 | Documentation typo fix. [forum:/forumpost/772d6688f5|Forum post 772d6688f5]. check-in: 1f2f9c709e user: drh tags: trunk | |
| 10:57 | Fix a problem with the error message reported by fts5 in some OOM cases. check-in: c7aaa28f78 user: dan tags: trunk | |
| 00:16 | Improve the automatic-index decision such that no attempt is made to create 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 ticket [8ff324e120d5e9bd] and [forum:/forumpost/b21c2101a559be0a|forum post b21c2101a559be0a]. check-in: 2a7603c327 user: drh tags: trunk | |
| 00:01 | Query planner tuning: Increase the maximum number of simultaneous solutions to track int eh solver from 10 to 12. check-in: fe2e1dadba user: drh tags: trunk | |
|
2024-05-27
| ||
| 21:55 | Avoid creating an automatic index on a column that is known to be not very selective. Closed-Leaf check-in: 70409763f7 user: drh tags: auto-index-improvements | |
| 19:52 | The previous check-in was a little two aggressive about skipping the initialization of entries in the CellArray.ixNx array. Fixed here. check-in: 1b6d1fbcde user: drh tags: trunk | |
| 18:15 | Fix typo in comment used to generate parts of the documentation. [forum:/forumpost/da5a2ca4db|Forum post da5a2ca4db]. check-in: 428aadf0c7 user: drh tags: trunk | |
| 15:13 | Very small performance increase and size reduction by removing unnecessary ALWAYS() macros from the btree balance logic and replacing them with special initialization of CellArray and some assert()s. check-in: 32b79041d9 user: drh tags: trunk | |
| 13:41 | Doc typo fix. No code changes. check-in: eaf07fe69f user: stephan tags: trunk | |
| 13:24 | For compatibility with PostgreSQL, when right-hand side of the ->> operator is negative, it should index from the right side of the JSON array on the left-hand side. check-in: 82365a45b9 user: drh tags: trunk | |
| 11:38 | Fix a possible buffer overwrite in the ".import" command. Leaf check-in: 55eee9f920 user: drh tags: branch-3.46 | |
| 11:35 | Fix a possible buffer overwrite in the ".import" command. [forum:/forumpost/0c447f0548|forum post 0c447f0548]. check-in: 0fd958fa9b user: dan tags: trunk | |
| 11:31 | Add new assert() statements to help out a static analyzer. Response to [forum:/forumpost/17fe8ac32e0de4f5|forum post 17fe8ac32e0de4f5]. check-in: 857f6d5309 user: drh tags: trunk | |
|
2024-05-25
| ||
| 23:17 | Ensure that sqlite3ViewGetColumnNames() returns non-zero on any error. check-in: 01ead0a2d9 user: drh tags: branch-3.46 | |
| 23:13 | Ensure that sqlite3ViewGetColumnNames() returns non-zero on any error. dbsqlfuzz d9de2a508f693e5a228d7a01d5341e3c64326fbb. check-in: 57aeb3a287 user: drh tags: trunk | |
|
2024-05-24
| ||
| 23:44 | Ensure that queries like "SELECT func(a) FROM tab GROUP BY 1" only call the func() function once per row. Fix for the issue described in [forum:/forumpost/bf8f43aa522c2299|forum thread bf8f43aa522c2299]. check-in: 663f5dd32d user: drh tags: trunk | |
| 21:38 | Fix another fts5 problem related to unknown tokenizer modules. check-in: e78b778304 user: dan tags: trunk | |
| 21:23 | Fix a crash in fts5 that could occur within "PRAGMA integrity_check" if the specified tokenizer was unknown. check-in: 061d7b69e6 user: dan tags: trunk | |
| 20:18 | When omitting result columns for the vector-IN optimization, make sure that any result-set column references in both the ORDER BY clause and the GROUP BY clause are updated appropriately. Closed-Leaf check-in: f890812df0 user: drh tags: group-by-consistency | |
| 18:31 | Ensure that queries like "SELECT indeterministic(a) FROM tbl GROUP BY 1" invoke the indeterministic function only once for each row of tbl. check-in: 4555d66547 user: dan tags: group-by-consistency | |
| 14:16 | Add the stmtrand() extension function for use in testing. check-in: 5c97a5b9d1 user: drh tags: trunk | |
| 13:33 | Fix an "ifcapable" expression in values.test. check-in: b8442d2a60 user: dan tags: trunk | |
|
2024-05-23
| ||
| 23:34 | Increase the version number to 3.46.1 check-in: 170e3a91d5 user: drh tags: branch-3.46 | |
| 23:30 | Fix the window-function group_concat() so that it returns an empty string if it has one or more empty string inputs. check-in: 7fe11274fc user: drh tags: branch-3.46 | |
| 23:26 | Fix the window-function group_concat() so that it returns an empty string if it has one or more empty string inputs. This fixes a bug introduced by [c6da39115d3e2b0f] on 2019-03-26 (version 3.28.0) and reported by [forum/forumpost/bf8f43aa522c2299|forum post bf8f43aa522c2299]. check-in: cec6bb3fc9 user: drh tags: trunk | |
| 15:05 | Merge various enhancements that were being held on a branch until after the 3.46.0 release. (1) Allow arbitrary expressions in the second argument to the RAISE() function. (2) Performance optimization to the OP_OpenRead and OP_OpenWrite bytecode operators. (3) Allow FTS5 tables to be dropped even if the associated tokenizer is not available. (4) Performance optimizations in FTS5. (5) Generate better bytecode to improve performance of ONEROW scans. check-in: 1e5385ffc3 user: drh tags: trunk | |