Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 most recent check-ins using file test/subtype1.test version 7fe0949635
|
2024-09-18
| ||
| 18:04 | Improvements to the scope of valueFromFunction(). (Leaf check-in: b021399a6e user: drh tags: branch-3.28) | |
|
2024-06-07
| ||
| 00:20 | Allow the query planner access to the argument of LIMIT even if that argument is a bound parameter. (check-in: 148d505ca0 user: drh tags: branch-3.28) | |
|
2024-06-06
| ||
| 16:06 | Better optimize queries that use parameters in the LIMIT clause. (Closed-Leaf check-in: b44f267671 user: drh tags: branch-3.28-var-in-limit) | |
|
2024-04-02
| ||
| 18:48 | Fix typos in comments. Provided ".wheretrace" debugging output for the interstage heuristic module. Do omit automatic index loops in the interstage heuristic. (check-in: 357d9513d2 user: drh tags: branch-3.28) | |
| 18:31 | Fix table-valued functions so that they will work as the right table in a LEFT JOIN. Ticket [2ae0c599b735d59e] (check-in: 1f97086d62 user: drh tags: branch-3.28) | |
| 11:54 | Add a heuristic in between the two solver() passes of the query planner that tries to prevent a very slow query plan in cases where the output row count estimate is imprecise. (check-in: 74b247d958 user: drh tags: branch-3.28) | |
|
2023-11-29
| ||
| 16:26 | Fix a duplicate assert() caused by the second cherrypick in the previous check-in. (check-in: f10d4fc4a8 user: drh tags: branch-3.28) | |
| 16:07 | Remove Window objects from the corresponding Select.pWin list when they are deleted, as they are, for example, when the ORDER BY clause is optimized out. (check-in: f9c6e6a710 user: drh tags: branch-3.28) | |
|
2023-10-19
| ||
| 21:05 | Ensure that when an ephemeral cursor is reopened with a second invocation of to OP_OpenEphemeral, the sequence counter is reset and the cache marked as stale. Fix for [9cdc5c46]. (check-in: d4bfa8d21a user: drh tags: branch-3.28) | |
|
2023-09-15
| ||
| 20:04 | Drop support for the view-scan optimization as it was causing multiple performance regressions. In its place, reduce the estimated row count for DISTINCT subsqueries by a factor of 8. (check-in: 796a65fa61 user: drh tags: branch-3.28) | |
|
2023-02-26
| ||
| 11:52 | In the omit-unused-subquery-columns optimization, be sure to remove the EP_Skip and EP_Unlikely flags from the result set expressions that get nulled-out. dbsqlfuzz bf1d3ed6e0e0dd8766027797d43db40c776d2b15. Also fix an incorrect ".selecttrace" code block. (check-in: 83a7f13edb user: drh tags: branch-3.28) | |
|
2023-02-16
| ||
| 21:01 | Fix an #ifdef that uses a different macro name from the main branch. (check-in: ad6ac5d3e8 user: drh tags: branch-3.28) | |
| 19:04 | Back-port omit-unused-subquery-column enhancements into the 3.28 branch. (check-in: 57a4e91f43 user: drh tags: branch-3.28) | |
| 14:29 | Do not compute result columns of subqueries that are never used. Make those columns NULL instead. This optimization potentially resolves the enhancement request described by [ticket baa5bb76c35a124c]. (check-in: 0163b697dd user: drh tags: branch-3.28) | |
| 01:29 | Do not compute unused result columns of subqueries. This optimization will potentially resolve the performance optimization request of [ticket baa5bb76c35a124c]. (Closed-Leaf check-in: 0c21b6a5f8 user: drh tags: branch-3.26) | |
| 01:21 | Update test cases so that they work with TCL 8.7 and later. (check-in: e9b762de0e user: drh tags: branch-3.26) | |
|
2023-02-15
| ||
| 13:00 | Update the configure script so that it contains the correct version number. (check-in: a7cbf30808 user: drh tags: branch-3.26) | |
|
2022-12-18
| ||
| 10:27 | WIP, pre-sync-to-trunk check-in to capture extensive changes to shell source. (WASM and usual shell tweaks) (check-in: 3db119c8d7 user: larrybr tags: cli_extension) | |
|
2022-10-24
| ||
| 13:50 | Improve the ability of the query planner to recognize covering indexes even on tables with more than 63 columns and where the index is over columns beyond the 63rd column. (check-in: 3d1992de47 user: drh tags: branch-3.28) | |
|
2022-10-19
| ||
| 11:22 | If a query uses an index where one or more of the columns of the index is an expression and if the corresponding expression is used elsewhere in the query, then strive to read the value of the expression out of the index, rather than recomputing it. This is the "Indexed Expression Optimizations". (check-in: 3da1032878 user: drh tags: branch-3.28) | |
|
2022-09-27
| ||
| 17:00 | Fix a potential division by zero error in this version of RBU that might occur if an external client checkpoints a wal file created by a suspended RBU process. (Leaf check-in: 73edd93adf user: dan tags: branch-3.14) | |
|
2022-09-01
| ||
| 10:41 | In the query planner, add a heuristic that will reduce the cost of a full table scan for a materialized view or subquery if the full scan is the outer-most loop. This is shown to speed up some queries. (check-in: e3754cc188 user: drh tags: branch-3.28) | |
|
2022-08-10
| ||
| 17:03 | Merge the branch-3.28a fixes into branch-3.28. (check-in: ba6bf33147 user: drh tags: branch-3.28) | |
|
2022-08-09
| ||
| 20:22 | Fix a rounding error caused by scalar->logarithm->scalar conversion when using stat4 data to estimate some range scans. (check-in: 68d86f2b20 user: drh tags: branch-3.28) | |
|
2022-06-08
| ||
| 18:29 | Move an #ifdef in shell.c to avoid a harmless "unused function" compiler warning. (check-in: 5abb5ef500 user: drh tags: trunk) | |
| 18:20 | Avoid zeroing the value returned by sqlite3_changes() when a DML statement is automatically reprepared in sqlite3_step(). (check-in: 09c8f9f197 user: dan tags: trunk) | |
| 17:48 | Improved comments on the new query flattener restriction of the previous check-in. Also a NEVER() macro on an unreachable branch. (check-in: 8c9e2d6315 user: drh tags: trunk) | |
| 15:38 | Fix the query flattener so that it refuses a flattening that might leave both an inner-join and outer-join ON-clause constraint (or equivalent) on the same term of the FROM clause. (check-in: f6c4fb48b6 user: drh tags: trunk) | |
| 15:30 | Add restriction (29) to the query flattener - do not allow flattening that would leave both EP_InnerON and EP_OuterON constraints on the same join term. (Leaf check-in: c585d6a467 user: drh tags: right-join-query-flattener) | |
| 13:13 | New test cases refute check-in [3f45007d544e5f78]. (check-in: 12d3c96c39 user: drh tags: right-join-query-flattener) | |
| 12:46 | Do not allow a partial index scan on the left table of a RIGHT JOIN, because since the index is partial, some rows will be omitted from the scan, and those rows will subsequently be picked up by the no-match logic in the right-join post-processing loop. forum post c4676c4956. (check-in: 615c002611 user: drh tags: trunk) | |
| 12:35 | Minor fix to test/index9.test so that it can be invoked with other index tests using a wildcard. (check-in: ccbd6e7749 user: drh tags: trunk) | |
| 12:20 | Update the routine that determines whether or not a partial index can be used so that it is not specific to LEFT JOIN. (check-in: 5a107fd7fa user: drh tags: trunk) | |
|
2022-06-07
| ||
| 13:09 | Fix the query flattener to deal with a RIGHT JOIN corner case described by forum post 323f86cc30. (check-in: 3f45007d54 user: drh tags: trunk) | |
| 11:02 | Test cases for forum post 323f86cc30 added to join8.test, though commented out so that they do not (yet) run. (check-in: 7f97cb67d0 user: drh tags: trunk) | |
| 10:14 | Preserve the database encoding on the CAST operator in the sqlite3ValueFromExpr() routine. Forum thread 800eecf5e6cdc3f4. Test case in TH3. (check-in: 3f6a442099 user: drh tags: trunk) | |
|
2022-06-06
| ||
| 23:22 | More precise determination of when a WHERE clause can be used to drive an index on an outer join. (check-in: 318543a911 user: drh tags: trunk) | |
| 22:33 | More precise determination of when a WHERE/ON clause term can be used as an indexed join constraint. Testcase macros added to ensure test coverage. (Closed-Leaf check-in: f419e98c51 user: drh tags: outer-join-tests) | |
| 21:08 | Extra test cases for outer joins. (check-in: c750576528 user: dan tags: outer-join-tests) | |
| 15:27 | Do not allow a WHERE clause constraint to be used to drive an index for the right operand of a RIGHT JOIN, since this can cause problem if the constraint implies a not-NULL value for one of the columns for the left operand of the same join. See forum post 206d99a16dd9212f. (check-in: 4a31b7942a user: drh tags: trunk) | |
| 15:22 | In CLI, drop .dbinfo command when build options prevent it from working. (check-in: 4b50a55165 user: larrybr tags: trunk) | |
| 14:00 | Sync w/trunk, pickup fts3corrupt6.test change. (Closed-Leaf check-in: 268072f636 user: larrybr tags: dbinfo-guard) | |
| 06:29 | fiddle: replaced the huge file selection widget with a smaller proxy button. (check-in: f7c17449ea user: stephan tags: trunk) | |
| 06:17 | Fix a test case in fts3corrupt6.test. Was failing due to [f1dfbc4f]. (check-in: 04b2e47784 user: dan tags: trunk) | |
| 04:09 | shell: in WASM mode, permit ATTACH because the filesystem is a virtual sandbox and ATTACH can be used to provide more import/export options. Minor doc updates in sqlite3-api.js. (check-in: f28de5b726 user: stephan tags: trunk) | |
|
2022-06-05
| ||
| 22:58 | In CLI, drop .dbinfo command when build options prevent it from working. (check-in: 2512d2f68d user: larrybr tags: dbinfo-guard) | |
| 22:40 | Create new branch named "dbinfo-guard" (check-in: 8d942ba72e user: larrybr tags: dbinfo-guard) | |
|
2022-06-03
| ||
| 14:08 | Fix to test case in fts3corrupt.test. No changes to source code. (check-in: d18818afc6 user: dan tags: trunk) | |
| 13:52 | Fix a 1-byte overread in fts3 that could occur when processing corrupt records. (check-in: f1dfbc4f74 user: dan tags: trunk) | |
|
2022-06-02
| ||
| 16:26 | Fix a problem with flattening and window functions causing an "IS <column>" to be transformed to "IS TRUE" or "IS FALSE" when <column> is a view or sub-select expression that is the literal value "TRUE" or "FALSE". (check-in: 2a952c7738 user: dan tags: trunk) | |
| 02:45 | Avoid a direct use of abort() in debug builds to prevent a compilation issue for Windows CE. (check-in: 8eb9a7dd07 user: mistachkin tags: trunk) | |
|
2022-06-01
| ||
| 20:08 | New test cases for row values and RIGHT JOIN. (check-in: 5f0582b90f user: drh tags: trunk) | |
| 16:05 | Ensure that subqueries associated with row-values are invoked before being used when processing a RIGHT JOIN. Fix for the problem described by forum post 087de2d9ec87305b. (check-in: 5a9465dcc0 user: drh tags: trunk) | |
| 16:04 | fiddle: added another UI element to the list of those which are disabled during long-running activities. Added DB.close() binding to the Worker-based wasm binding. (check-in: 5933163ed1 user: stephan tags: trunk) | |
| 15:53 | Ensure that all necessary row-value subqueries are invoked while running the right-join post processing. (Closed-Leaf check-in: e4e71b4cd4 user: drh tags: row-value-right-join) | |
| 14:52 | Minor tweaks to, and consolidation of, the wasm-related build flags. (check-in: f0ad6b1b32 user: stephan tags: trunk) | |
| 14:32 | Fix a minor problem in the Tcl "incrblob" command. This does not affect the SQLite core. (check-in: e96feccc21 user: dan tags: trunk) | |
| 13:32 | Candidate fix for the problem with row-value WHERE clause constraints on a RIGHT JOIN. (check-in: fdd782a7bb user: drh tags: row-value-right-join) | |
| 13:32 | Only include the code for sqlite_offset() if compiled with -DSQLITE_ENABLE_OFFSET_SQL_FUNC. (check-in: 382cd7e10b user: drh tags: trunk) | |
| 13:01 | Fix a typo in a comment in a test case. No changes to code. (check-in: 570efa45dd user: drh tags: row-value-right-join) | |
| 11:58 | Additional enhancements to the test cases. (check-in: 55cfad74ca user: drh tags: row-value-right-join) | |
| 11:46 | Fix test cases in the previous check-in to make them postgres-compatible. (check-in: f223ba72b6 user: drh tags: row-value-right-join) | |
| 11:43 | Test case for forum post 087de2d9ec showing a problem when a row-value constraint is used with RIGHT JOIN. (check-in: d1e3e0d26e user: drh tags: row-value-right-join) | |
| 11:20 | The Worker-specific variants of the most significant DB-class JS bindings are implemented, most notably various uses of DB.exec(). (check-in: 371d6f7497 user: stephan tags: trunk) | |
| 11:05 | Move the sqlite_offset() function implementation to be an in-line function, thereby avoiding special case code and freeing up a bit in the FuncDef.flags field. (check-in: 1c9812c458 user: drh tags: trunk) | |
| 08:09 | Initial proof of concept code for a JavaScript binding which runs in the main window thread but acts on a db handle running in a Worker thread. Expanded the DB.exec() and DB() constructor to simplify certain use cases. (check-in: d9efe3e92d user: stephan tags: trunk) | |
| 00:00 | Initial bits for a JS API variant in which the client operates in the main thread and sqlite3 in a Worker. This is far from complete. (check-in: f6d6f96979 user: stephan tags: trunk) | |
|
2022-05-31
| ||
| 18:18 | New FULL JOIN test cases. No changes to code. (check-in: 13e89ef664 user: drh tags: trunk) | |
| 17:24 | More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb]. (check-in: f2d224c5fa user: drh tags: trunk) | |
| 15:18 | Fix an assert that is incorrect for a corrupt database. (check-in: fe0a840805 user: drh tags: trunk) | |
| 14:19 | Many new PG-confirmed test cases in joinD.test. (check-in: 481e89c764 user: drh tags: trunk) | |
| 11:22 | Restore an ON-clause test case (removed by [3869fd9a2b9483cb]) that turns out to be necessary for correct operation. Fix for forum post c2554d560bac97c5. (check-in: f407ec678f user: drh tags: trunk) | |
| 11:13 | Add back in a test case for ON-clauses that was removed yesterday by [3869fd9a2b9483cbf] but which turned out to be necessary after all. (Closed-Leaf check-in: aba52a90ee user: drh tags: right-join-bug-20220531) | |
| 10:48 | Add test cases for forum post c2554d560bac97c5. (check-in: e66d5ae86c user: drh tags: right-join-bug-20220531) | |
| 02:03 | Updated the wasm builds to generate gzip'ed copies of relevant files to take advantage of althttpd's new capability of substituting gzip files in place of requested files. This cuts over-the-wire size of the fiddle app by more than half. (check-in: 40925585f1 user: stephan tags: trunk) | |
|
2022-05-30
| ||
| 17:33 | For an outer join, then ON-clause constraints need to be evaluated at just the right moment - not too early and not too late. Fix for the problem reported by forum post 3902c7b833. (check-in: 3869fd9a2b user: drh tags: trunk) | |
|
2022-05-28
| ||
| 15:01 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 4d46296ef6 user: drh tags: reuse-schema) | |
| 14:51 | Merge the latest trunk enhancements into the begin-concurrent-pnu-wal2 branch. (check-in: 4d65f45b31 user: drh tags: begin-concurrent-pnu-wal2) | |
| 14:44 | Merge the latest trunk enhancements into the wal2 branch. (check-in: 934656f13d user: drh tags: wal2) | |
| 14:32 | Merge the latest trunk enhancements into the begin-concurrent-report branch. (check-in: 034d2c511a user: drh tags: begin-concurrent-report) | |
| 14:25 | Merge the latest trunk enhancements into the begin-concurrent branch. (check-in: d6f6ee5cbc user: drh tags: begin-concurrent) | |
| 14:03 | Apply the UPDATE-FROM file from check-in [98b3816bbaf539ea] to update-delete-limit builds. (check-in: 7e87892c24 user: drh tags: trunk) | |
| 11:59 | fiddle: changed the internal key of the session/local storage to avoid conflicts with the pikchr fiddle app (which is derived from this one) when running from the same HTTP origin as an instance of that app in a dev environment. (check-in: fd668da5cc user: stephan tags: trunk) | |
| 11:29 | fiddle: corrected a piece of far-corner-case error handling and made the various checkbox config options persistent. (check-in: 2ba429a4f8 user: stephan tags: trunk) | |
|
2022-05-27
| ||
| 18:06 | Mark an always-true conditional as ALWAYS(). (check-in: 3492fe8a21 user: drh tags: trunk) | |
| 17:36 | Minor simplification to ALTER TABLE logic. (check-in: 01beb0365c user: drh tags: trunk) | |
| 17:13 | Corrected a broken HTML comment (was using a C-style comment closer). (check-in: db742e3e7d user: stephan tags: trunk) | |
| 15:33 | Fix another problem with ALTER TABLE and UPDATE...FROM in triggers. (check-in: 33cf12235e user: dan tags: trunk) | |
| 15:04 | Fix further issues with ALTER TABLE and triggers that contain UPDATE..FROM statements. (check-in: 53fbc269dd user: dan tags: trunk) | |
| 14:41 | Omit an unnecessary branch. (check-in: f56473f9cc user: drh tags: trunk) | |
| 03:27 | fiddle: added an option to completely wipe/reset the db. The Options area can now be toggled on/off via tapping the label at its top. Running the input SQL is now limited to the selected area if any text is currently selected, per suggestion in the forum. (check-in: d100283e37 user: stephan tags: trunk) | |
|
2022-05-26
| ||
| 19:10 | Fix issues with ALTER TABLE and triggers containing "UPDATE...FROM" statements. (check-in: 2fba0d41b7 user: dan tags: trunk) | |
| 17:33 | Correct handling of outer joins in the FROM clause of an UPDATE statement that occurs inside of a trigger. Follow-on to [98b3816bbaf539ea]. (check-in: 664a49fa81 user: drh tags: trunk) | |
| 14:46 | Clarification of the meaning of the N parameter in sqlite3_db_name(). Documentation only. No changes to code. (check-in: f22f41d2c8 user: drh tags: trunk) | |
| 05:18 | Fixed a minor cut/paste mistake in the previous checkin. Affects only internal docs. (check-in: 37e3764839 user: stephan tags: trunk) | |
| 05:08 | Makefile.in: added explanations, intended for maintainers and hackers, of the various emcc flags used for building the wasm files. No code or build rule changes. (check-in: 1a15915909 user: stephan tags: trunk) | |
|
2022-05-25
| ||
| 13:10 | Slight increase in the accuracy of log10(). (check-in: c48a735bd4 user: drh tags: trunk) | |
| 12:49 | Do not allow the right operand of a RIGHT JOIN to be reordered with other FROM clause terms that are even further to the right. Fix for the issue identified by forum post 5cfe08eed6. (check-in: 4be0c60e38 user: drh tags: trunk) | |
| 11:17 | Add in a VdbeCoverage() macro accidentally omitted from [d64ae49a1f251317]. (check-in: 18b5cea039 user: drh tags: trunk) | |
| 11:09 | Fix the UPDATE-FROM logic so that it works the same as PostgreSQL when the FROM clause contains an outer join. (check-in: 98b3816bba user: drh tags: trunk) | |
| 08:51 | Got the sqlite3-api JS bits wrapped up in deferred-load module. Whether that's going to be easier to use, in practice, remains to be seen. Consolidated two of the test-related JS files. (check-in: dd83cc05f2 user: stephan tags: trunk) | |
| 04:38 | Renamed EXPORTED_FUNCTIONS.sqlite3 to EXPORTED_FUNCTIONS.sqlite3-api to avoid any potential confusion about that file (not) being an sqlite3 database. (check-in: 3d6245c6f9 user: stephan tags: trunk) | |
| 04:35 | Add the ability to import/export db files into/from fiddle. (check-in: e0c30438a4 user: stephan tags: trunk) | |
| 04:20 | Further minor cleanups and docs in the fiddle app and worker. (Closed-Leaf check-in: 199e01799d user: stephan tags: fiddle-local-db) | |
| 03:08 | fiddle: refactored so that it no longer exposes any global symbols. Doing so with the main sqlite3.api module will be much tricker. (Edit: it _does_ export a global symbol, but it's the function to init the module instead of the module itself. Not sure that's any cleaner.) (check-in: cd227be805 user: stephan tags: fiddle-local-db) | |
| 02:32 | An attempt to get UPDATE FROM working when the FROM clause contains a RIGHT or FULL JOIN. (Closed-Leaf check-in: a124e4f96f user: drh tags: update-from-right-join) | |
|
2022-05-24
| ||
| 22:16 | fiddle: added support for exporting (downloading) the current db file. To do this we had to fall back to named dbs, instead of defaulting to an in-memory one, but the virtual filesystem is an in-memory FS, so the end effect is the same. (check-in: 7c7fd34c8a user: stephan tags: fiddle-local-db) | |
| 19:01 | fiddle: initial work on loading a client-side db file. Works but requires some cleanup. Export is not yet implemented. (check-in: 0fa8378c00 user: stephan tags: fiddle-local-db) | |
| 16:05 | When an ON clause on an INNER JOIN references a table to the right of of the join, just convert the ON clause to an ordinary WHERE clause term, in order to be compatible with older versions of SQLite. See forum thread 687b0bf563a1d4f1 for details. (check-in: 2b6ebba26d user: drh tags: trunk) | |
| 14:45 | Use more descriptive var names in ext/fiddle/Makefile. (check-in: 2f9a42fb14 user: stephan tags: trunk) | |
| 14:36 | fiddle: lots of generic refactoring, restructuring, and cleanup in the higher-level code. Added push-fiddle ext/fiddle/Makefile target to push the fiddle app to a remote server via rsync. (check-in: ed19fef345 user: stephan tags: trunk) | |
| 01:15 | wasm/JS: minor doc updates, corrected bind()ing of the undefined value to behave as documented, removed some superfluous code. (check-in: 526c8c7280 user: stephan tags: trunk) | |
| 00:35 | wasm/JS: documented DB.selectValue() and corrected the fetching of NULL columns via Stmt.get(). (check-in: 70f91fab82 user: stephan tags: trunk) | |
| 00:22 | wasm/JS: added support for scalar UDFs. Fixed a deallocation problem with bind()ed strings/blobs. (check-in: 325a9ee31a user: stephan tags: trunk) | |
|
2022-05-23
| ||
| 19:38 | wasm: minor refactoring and doc updates. (check-in: 6044605b2a user: stephan tags: trunk) | |
| 16:54 | fiddle: cleaned up and documented the status-loading progress mechanism in prep for reusing it in the sqlite3-api worker. (check-in: 107e349786 user: stephan tags: trunk) | |
| 13:55 | wasm: added missing 'use strict' and fixed an undeclared var use caught by that. (check-in: c16a7f4950 user: stephan tags: trunk) | |
| 13:52 | wasm: corrected isSupportedBindType() to behave as documented. (check-in: 7e2d2e8072 user: stephan tags: trunk) | |
| 12:37 | New test cases to further demonstrate the difference in name matching rules for LEFT JOIN versus RIGHT JOIN that protect legacy behavior. Forum thread e90a8e6e6fa652ac. (check-in: 2c586060a0 user: drh tags: trunk) | |
| 11:51 | Add an assert() to clear a harmless static-analyzer warning. (check-in: 919ba2f047 user: drh tags: trunk) | |
| 10:57 | Do not run the subroutine that materializes a view or subquery until just before the materialization is actually needed, so that if the materialization turns out to never been needed, unnecessary work can be avoided. (check-in: d64ae49a1f user: drh tags: trunk) | |
| 01:11 | WASM: removed the in64-related bindings, as MDN says that calling a wasm function which has an int64 type in its signature will currently throw because JS has no 64-bit integer support. Those bindings now use doubles and simply hope that the user doesn't exceed their integer precision (2^53-1, approx 9 quadrillion). (check-in: 392e848282 user: stephan tags: trunk) | |
|
2022-05-22
| ||
| 22:10 | WASM: an arg handling fix for DB.exec({multi:true...}). (check-in: 0d6332f706 user: stephan tags: trunk) | |
| 22:00 | WASM: added exec(), execMulti(), and several getters. Various touchups and fixes. (check-in: b790c91b85 user: stephan tags: trunk) | |
| 19:09 | Implemented Stmt.get() and friends for WASM OO #1 wrapper. Added basic tests for prepare/step/get. Restructured module init output to introduce only 1 global-scope symbol instead of 2. (check-in: 601dc3fa29 user: stephan tags: trunk) | |
| 16:25 | WASM: added bindings for sqlite3_compileoption_get/used(), moved OO #1 into sqlite3-api.js since it can only be used from the same thread as that API and separating them complicates client-side use. Started adding test utilities and tests for the OO1 API. (check-in: f3bc0328c8 user: stephan tags: trunk) | |
| 14:07 | WASM OO wrapper #1: prepare() and bind() APIs are in place but are untested, pending fetch/get APIs. (check-in: 84c8f63a1c user: stephan tags: trunk) | |
| 00:27 | Build refactoring for the fiddle/wasm bits. Set up wasm binding of a chunk of the core C API and added some infastructure for creating test pages for it. (check-in: dea098b64e user: stephan tags: trunk) | |
|
2022-05-21
| ||
| 21:13 | Minor fiddle-related build restructuring to support upcoming development of the C-style wasm sqlite3 interface, plus some commentary about the plans and goals for that. (check-in: c7cfdd4c36 user: stephan tags: trunk) | |
| 18:03 | Defer materializing a view or subquery until the materialization is actually needed, so that if it is not needed, not useless work is performed. (Closed-Leaf check-in: 16bf350683 user: drh tags: deferred-materialize) | |
| 15:54 | Fix a typo in a comment. (check-in: 34d7045b2c user: drh tags: deferred-materialize) | |
| 15:12 | Use the newer OP_BeginSubrtn opcode instead of OP_Integer to start the subroutine used to matrialize a view. This does not change execution but does make the byte code a little easier to read. (check-in: cebd4fd606 user: drh tags: deferred-materialize) | |
| 14:19 | fiddle: refactor into main thread (UI) and worker thread (wasm module). Added bits needed to support triggering sqlite3_interrupt() but do not yet have a second SharedWorker to test it with. (check-in: 5ff3326856 user: stephan tags: trunk) | |
| 00:45 | fiddle: add a selection list of example queries. (check-in: 74abf03977 user: stephan tags: trunk) | |
| 00:01 | In the shell WASM build, call open_db() early so that we can get access to the global db handle from certain experimentation-only function without having to first run some SQL code. (check-in: 31706ef851 user: stephan tags: trunk) | |
|
2022-05-20
| ||
| 13:50 | Added the standard sqlite license header to the the fiddle JS files. Minor internal renamings in those same files. (check-in: 67e40d99ff user: stephan tags: trunk) | |
| 13:27 | Add a terminal-style view to the fiddle app, based on jquery.terminal. (Leaf check-in: 82b57f2e21 user: stephan tags: fiddle-terminal-view) | |
|
2022-05-19
| ||
| 22:04 | #if'd out the '.nonce' and '.check' commends in WASM builds. (check-in: 326f79ea54 user: stephan tags: trunk) | |
| 21:56 | #if'd out the the '.cd' and '.clone' commands for WASM builds. (check-in: fa391868dd user: stephan tags: trunk) | |
| 18:14 | fiddle: consolidated two duplicate CSS rules. Internal doc typo fix. (check-in: d3175a793f user: stephan tags: trunk) | |
| 17:47 | Added a disclaimer about fiddle's experimental and subject-to-change/removal nature. (check-in: 75b4f57408 user: stephan tags: trunk) | |
| 16:59 | Merge the changes to support the "fiddle" extension. (check-in: 58585f01aa user: drh tags: trunk) | |
| 16:49 | When building fiddle from its own directory (e.g. from emacs instead of the normal build process), force -O0 the sake of compilation speed. The top-level build now defaults to -Oz, which is more appropriate for that case. (Closed-Leaf check-in: 56b82ae806 user: stephan tags: fiddle) | |
| 16:42 | Tweaks to the fiddle make target so that it builds with all of the same extensions as the standard CLI. (check-in: d46a6cb974 user: drh tags: fiddle) | |
| 16:30 | Added a toggle to swap input/output field positions and simplified setup of checkboxes which toggle a CSS class on a given element. (check-in: eae3ab10c8 user: stephan tags: fiddle) | |
| 16:11 | Default to top/bottom layout with input on the bottom. Offer a toggle to swap input/output positions. (check-in: 362d236aca user: stephan tags: fiddle) | |
| 15:58 | Numerous layout tweaks, the most significant being that the layout now adapts to the window size. Swapped positions of the input/output areas. This version supports, by uncommenting a few bits, a jquery.terminal-based view but alternatives to that 300kb dependency are still under investigation. (check-in: 1aad3642c9 user: stephan tags: fiddle) | |
| 10:58 | fiddle make target now accepts fiddle_cflags=... from the CLI to overrid -Ox and such for one-off builds. (check-in: 4609a4f862 user: stephan tags: fiddle) | |
| 10:38 | Ensure that the output area is cleared of any init-time messages which the emscripten bootstrapping process emits when downloading of the wasm module is slow. (check-in: 1d8d059357 user: stephan tags: fiddle) | |
| 10:24 | #if'd out the '.log' command in WASM builds. Cleaned up the user-visible parts of the WASM module initialization. (check-in: b5fa12f824 user: stephan tags: fiddle) | |
| 09:55 | Split the fiddle JS code into separate pre-/post-init files to simplify editing. emcc will combine these into the final fiddle.js, so the number of output deliverables does not change. (check-in: d3d8ea0118 user: stephan tags: fiddle) | |
| 09:22 | Added an option to auto-clear the output area before submitting the input. Experimentally inverted the colors in the input/output areas. (check-in: 1a1e4e7fdb user: stephan tags: fiddle) | |
| 01:12 | Replaced the toggle for the notes/caveats section of the fiddle UI with a button to remove that section. (check-in: 6661d60527 user: stephan tags: fiddle) | |
| 00:38 | #if'd out the '.import' command in WASM builds. Several minor cosmetic UI tweaks. (check-in: e4f87eb7c3 user: stephan tags: fiddle) | |
|
2022-05-18
| ||
| 23:40 | #if out the '.load' command in WASM builds. Several UI layout tweaks. (check-in: 67d98297f0 user: stephan tags: fiddle) | |
| 22:58 | In wasm builds, ifdef out shell commands which require file I/O, pipes, or which trigger an exit() (.quit and .exit). Documented some of the quirks and limitations of the C/WASM crossover. Keep the JS code from calling into the C code after an exit() has been triggered. (check-in: bee436e62a user: stephan tags: fiddle) | |
| 21:18 | Improved handling/reporting of conditions which trigger an exit() from native code, e.g. calling the '.read' command. Added a Help button which simply submits the '.help' command. Added commented-out variants of various -Ox flags to simplify experimenting with them. (check-in: bf06ddf412 user: stephan tags: fiddle) | |
| 20:44 | Experimental code to provide a SIZE_HINT when writing the -wal file. (Leaf check-in: 3b29080dbf user: drh tags: wal-size-hint) | |
| 18:10 | Code style fixes: s/char const/const char/. (check-in: 9bf042b2eb user: stephan tags: fiddle) | |
| 17:40 | The fiddle input/output areas now stretch and shrink as needed to account for their available space. (check-in: 4eec05457f user: stephan tags: fiddle) | |
| 17:22 | Increased default size of the fiddle output area, changed the .nullvalue default in the input area, and minor CSS tweaks. (check-in: 281aaae731 user: stephan tags: fiddle) | |
| 17:14 | Initial version of an sqlfiddle-style application using a WASM build of the sqlite3 shell. (check-in: af9c21c9e0 user: stephan tags: fiddle) | |
|
2022-05-17
| ||
| 15:33 | Merge the latest trunk enhancements into the reuse-schema branch. (check-in: 495f0353db user: drh tags: reuse-schema) | |
| 15:11 | Fix harmless compiler warnings in the new unixFullPathname implementation. (check-in: f7e1ceb5b5 user: drh tags: trunk) | |
| 15:01 | Avoid treating constant expressions like "? IN ()" or "? NOT IN ()" as integers if they appear in a GROUP BY or ORDER BY clause. (check-in: d8b249e8cd user: dan tags: trunk) | |
| 14:59 | Add the sqlite3_db_name() interface. (check-in: 2ad152236c user: drh tags: trunk) | |
|
2022-05-16
| ||
| 16:55 | Add memory barriers to multi-threaded code in test4.c. (check-in: 9260f4e0fd user: dan tags: trunk) | |
| 16:10 | Fix a problem in test file swarmvtab3.test causing occasional failures. (check-in: f935c155ef user: dan tags: trunk) | |
|
2022-05-14
| ||
| 19:05 | Do not allow an index scan on an index-on-expression for a RIGHT JOIN because the index might not be positioned on the correct row when running the the right-join no-match loop. dbsqlfuzz 39ee60004ff027a9e2846cf76e02cd5ac0953739 (check-in: 2277f9ba70 user: drh tags: trunk) | |
| 17:40 | Improved debugging comment generation for the OP_Column opcode. (check-in: 3e073bfddf user: drh tags: trunk) | |
| 15:59 | Improvements to the decision of when to check ON constraints for an inner join that is an operand to a RIGHT JOIN. Fix for issue identify by forum post c06b10ad7e. (check-in: 9d17233c7d user: drh tags: trunk) | |
|
2022-05-13
| ||
| 23:01 | Change an unreachable branch into an assert(). (check-in: 778e57a558 user: drh tags: trunk) | |
| 20:11 | Transitive equality constriants do not work on a RIGHT JOIN, since the right-hand side might be a non-matched row. (check-in: 0f96810b84 user: drh tags: trunk) | |
| 19:50 | Walk back the optimization from check-in [cc458317bd77046c] that tries to reuse the same ephemeral cursor of a list subquery when that subquery is reused, as it does not work in cases where the list subquery is used both for lookups and for scans. (check-in: 12ee29d632 user: drh tags: trunk) | |
| 17:45 | Defer generating WHERE clause constraints for a RIGHT JOIN until after the ON-clause processing for the RIGHT JOIN has done its own row elimination. This fixes and incorrect output from some RIGHT JOINs that was identified by forum post 41cc3851d864c5e6. (check-in: 238d9c247c user: drh tags: trunk) | |
| 16:38 | Redefine the acccess rules for the Expr.w union so that the Expr.w.iJoin member is accessible on either EP_OuterON or EP_InnerON. (check-in: 6f741d6cfb user: drh tags: trunk) | |
| 15:36 | Corrections to the header comment to the new joinE.test script. Add the generator TCL as a comment at the bottom of the script. (check-in: 2f4456f67f user: drh tags: trunk) | |
| 15:31 | New test cases for outer joins. Case joinE-32 currently gets an incorrect answer. See forum post 41cc3851d8 for the bug report. (check-in: 02b24863e6 user: drh tags: trunk) | |
| 14:52 | Improved names for flags on the Expr object: EP_FromJoin becames EP_OuterON and EP_InnerJoin becomes EP_InnerON. (check-in: 1ffea07ff9 user: drh tags: trunk) | |
|
2022-05-12
| ||
| 17:09 | Fix a harmless compiler warning in the CLI. (check-in: 7a2ac303d1 user: drh tags: trunk) | |
| 11:56 | Ensure that ON clauses are applied to the correct outer join. (check-in: c7e3a13a32 user: drh tags: trunk) | |
| 11:45 | Add IS NOT DISTINCT FROM and IS DISTINCT FROM binary operators which are equivalent to IS and IS NOT, respectively, for compatability with PostgreSQL and hence standard SQL. (check-in: db27611e17 user: drh tags: trunk) | |
| 11:01 | Fix the ".echo" command of the CLI so that it shows the results of input lines immediately, before invoking sqlite3_prepare(). (check-in: cf7fdabdba user: drh tags: trunk) | |
|
2022-05-11
| ||
| 20:29 | Zap stray --help output from intermediate version. (Closed-Leaf check-in: deb7372b18 user: larrybr tags: echo-sql) | |
| 19:59 | Change .echo on effect so that SQL is echoed before prepare. This slightly alters echoed output when multiple SQL statements are submitted at once. Also sync with trunk. (check-in: c1eff632c4 user: larrybr tags: echo-sql) | |
| 17:57 | The unix interface now resolves all symbolic links in filenames before actually using those filenames. (check-in: d55273e36e user: drh tags: trunk) | |
| 17:45 | Use osReadlink() in os_unix.c, not readlink() directly. (Closed-Leaf check-in: c3da4c1611 user: drh tags: resolve-symlinks) | |
| 16:46 | For the unix VFS, rewrite the xFullPathname method so that it automatically resolves all symbolic links, rendering a canonical pathname that contains no symlinks. (check-in: 40c9273d0e user: drh tags: resolve-symlinks) | |
| 03:42 | Fix .import leak in CLI and add shell leak testing to debug builds and the Tcl test suite. (check-in: df842ebc79 user: larrybr tags: trunk) | |
| 03:29 | Sync w/ trunk (Closed-Leaf check-in: 1284225b0a user: larrybr tags: import-leak-plug) | |
|
2022-05-10
| ||
| 23:28 | Fix a bug in the sqlite3WhereMalloc() routines that were added by chekc-in [f237e1d8cc41b937]. The bug was detected by dbsqlfuzz test case 4c5e3e89bc251d28378be88233f531b84ec66901. (check-in: 764b71267e user: drh tags: trunk) | |
| 22:32 | Make tester.tcl work on more Windows Tcl installations. And sync w/ trunk. (check-in: d25fbdf877 user: larrybr tags: import-leak-plug) | |
| 18:43 | New requirement marks. (check-in: e8479e56c6 user: drh tags: trunk) | |
| 18:18 | Fix a stale requirement mark. (check-in: fcda7fb1f1 user: drh tags: trunk) | |
| 17:42 | Fix a stale requirement mark. (check-in: 3eda4030f7 user: drh tags: echo-sql) | |
| 15:55 | Fix a harmless UBSAN warning. (check-in: 8f9355028b user: drh tags: trunk) | |
| 14:57 | Sync w/ trunk (check-in: b7285f92bb user: larrybr tags: echo-sql) | |
| 14:55 | For CLI, add ".echo sql" dot-command. (check-in: 35cef458ca user: larrybr tags: echo-sql) | |
| 13:06 | Merge all recent trunk changes into the reuse-schema branch. (check-in: 9f6d6e6135 user: drh tags: reuse-schema) | |
| 12:45 | Merge the latest trunk enhancements into theh begin-concurrent-pnu-wal2 branch. (check-in: d28af1f8a5 user: drh tags: begin-concurrent-pnu-wal2) | |