- 0dbb3db Sync w/trunk, pickup fts3corrupt6.test change. by larrybr ยท 3 years, 6 months ago dbinfo-guard
- 8fca1c7 fiddle: replaced the huge file selection widget with a smaller proxy button. by stephan ยท 3 years, 6 months ago
- fd80fa9 Fix a test case in fts3corrupt6.test. Was failing due to [f1dfbc4f]. by dan ยท 3 years, 6 months ago
- 626aa48 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. by stephan ยท 3 years, 6 months ago
- f3d6e8f In CLI, drop .dbinfo command when build options prevent it from working. by larrybr ยท 3 years, 6 months ago
- b61c242 Create new branch named "dbinfo-guard" by larrybr ยท 3 years, 6 months ago
- 93a4b41 Fix to test case in fts3corrupt.test. No changes to source code. by dan ยท 3 years, 7 months ago
- 181d75e Fix a 1-byte overread in fts3 that could occur when processing corrupt records. by dan ยท 3 years, 7 months ago
- 410fac3 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". by dan ยท 3 years, 7 months ago
- bf15436 Avoid a direct use of abort() in debug builds to prevent a compilation issue for Windows CE. by mistachkin ยท 3 years, 7 months ago
- 4861916 New test cases for row values and RIGHT JOIN. by drh ยท 3 years, 7 months ago
- f89f4ef Ensure that subqueries associated with row-values are invoked before being by drh ยท 3 years, 7 months ago
- 4e5aeb5 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. by stephan ยท 3 years, 7 months ago
- a5d06a3 Ensure that all necessary row-value subqueries are invoked while running by drh ยท 3 years, 7 months ago row-value-right-join
- 23aa8ff Minor tweaks to, and consolidation of, the wasm-related build flags. by stephan ยท 3 years, 7 months ago
- f74f4ed Fix a minor problem in the Tcl "incrblob" command. This does not affect the SQLite core. by dan ยท 3 years, 7 months ago
- 0f4b534 Candidate fix for the problem with row-value WHERE clause constraints on by drh ยท 3 years, 7 months ago
- 6d013d8 Only include the code for sqlite_offset() if compiled with by drh ยท 3 years, 7 months ago
- 1324b28 Fix a typo in a comment in a test case. No changes to code. by drh ยท 3 years, 7 months ago
- 0286cdb Additional enhancements to the test cases. by drh ยท 3 years, 7 months ago
- 47b4969 Fix test cases in the previous check-in to make them postgres-compatible. by drh ยท 3 years, 7 months ago
- 36c19f7 Test case for [forum:/forumpost/087de2d9ec|forum post 087de2d9ec] showing by drh ยท 3 years, 7 months ago
- ea7a4e4 The Worker-specific variants of the most significant DB-class JS bindings are implemented, most notably various uses of DB.exec(). by stephan ยท 3 years, 7 months ago
- 645682a Move the sqlite_offset() function implementation to be an in-line function, by drh ยท 3 years, 7 months ago
- 6ffa895 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. by stephan ยท 3 years, 7 months ago
- bff17db 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. by stephan ยท 3 years, 7 months ago
- c7fc08f New FULL JOIN test cases. No changes to code. by drh ยท 3 years, 7 months ago
- aa03c69 More JOIN test cases inspired by the problem fixed in [3869fd9a2b9483cb]. by drh ยท 3 years, 7 months ago
- f51672a Fix an assert that is incorrect for a corrupt database. by drh ยท 3 years, 7 months ago
- d69820c Many new PG-confirmed test cases in joinD.test. by drh ยท 3 years, 7 months ago
- 9f67cc2 Restore an ON-clause test case (removed by [3869fd9a2b9483cb]) that turns out by drh ยท 3 years, 7 months ago
- c9dfe2b Add back in a test case for ON-clauses that was removed yesterday by by drh ยท 3 years, 7 months ago right-join-bug-20220531
- b1f08bc Add test cases for by drh ยท 3 years, 7 months ago
- 5fd9f03 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. by stephan ยท 3 years, 7 months ago
- 404bf6b For an outer join, then ON-clause constraints need to be evaluated at just by drh ยท 3 years, 7 months ago
- 1943005 Apply the UPDATE-FROM file from check-in [98b3816bbaf539ea] to by drh ยท 3 years, 7 months ago
- 1a66ff3 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. by stephan ยท 3 years, 7 months ago
- e9ab04a fiddle: corrected a piece of far-corner-case error handling and made the various checkbox config options persistent. by stephan ยท 3 years, 7 months ago
- 5af8a86 Mark an always-true conditional as ALWAYS(). by drh ยท 3 years, 7 months ago
- abe1ff3 Minor simplification to ALTER TABLE logic. by drh ยท 3 years, 7 months ago
- 23b34bb Corrected a broken HTML comment (was using a C-style comment closer). by stephan ยท 3 years, 7 months ago
- ca29bbc Fix another problem with ALTER TABLE and UPDATE...FROM in triggers. by dan ยท 3 years, 7 months ago
- 4209d55 Fix further issues with ALTER TABLE and triggers that contain UPDATE..FROM statements. by dan ยท 3 years, 7 months ago
- 8d2f661 Omit an unnecessary branch. by drh ยท 3 years, 7 months ago
- cd69784 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. by stephan ยท 3 years, 7 months ago
- b8bbe3e Fix issues with ALTER TABLE and triggers containing "UPDATE...FROM" statements. by dan ยท 3 years, 7 months ago
- 26c4df0 Correct handling of outer joins in the FROM clause of an UPDATE statement by drh ยท 3 years, 7 months ago
- e91bde4 Clarification of the meaning of the N parameter in sqlite3_db_name(). by drh ยท 3 years, 7 months ago
- 78907bb Fixed a minor cut/paste mistake in the previous checkin. Affects only internal docs. by stephan ยท 3 years, 7 months ago
- c121e08 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. by stephan ยท 3 years, 7 months ago
- 724e298 Slight increase in the accuracy of log10(). by drh ยท 3 years, 7 months ago
- 7bfbd25 Do not allow the right operand of a RIGHT JOIN to be reordered with other by drh ยท 3 years, 7 months ago
- 361e0ed Add in a VdbeCoverage() macro accidentally omitted from [d64ae49a1f251317]. by drh ยท 3 years, 7 months ago
- ddcdf0b Fix the UPDATE-FROM logic so that it works the same as PostgreSQL when the by drh ยท 3 years, 7 months ago
- 26542e7 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. by stephan ยท 3 years, 7 months ago
- e599cc4 Renamed EXPORTED_FUNCTIONS.sqlite3 to EXPORTED_FUNCTIONS.sqlite3-api to avoid any potential confusion about that file (not) being an sqlite3 database. by stephan ยท 3 years, 7 months ago
- 085c5c6 Add the ability to import/export db files into/from fiddle. by stephan ยท 3 years, 7 months ago
- d0b22b8 Further minor cleanups and docs in the fiddle app and worker. by stephan ยท 3 years, 7 months ago fiddle-local-db
- 79669c2 fiddle: refactored so that it no longer exposes any global symbols. Doing so with the main sqlite3.api module will be much tricker. by stephan ยท 3 years, 7 months ago
- fb98dac An attempt to get UPDATE FROM working when the FROM clause contains a by drh ยท 3 years, 7 months ago update-from-right-join
- 80bf869 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. by stephan ยท 3 years, 7 months ago
- de1e02e fiddle: initial work on loading a client-side db file. Works but requires some cleanup. Export is not yet implemented. by stephan ยท 3 years, 7 months ago
- 6af03b4 When an ON clause on an INNER JOIN references a table to the right of by drh ยท 3 years, 7 months ago
- 73c6ad1 MoUse re descriptive var names in ext/fiddle/Makefile. by stephan ยท 3 years, 7 months ago
- 400ee2e 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. by stephan ยท 3 years, 7 months ago
- 2f6a729 wasm/JS: minor doc updates, corrected bind()ing of the undefined value to behave as documented, removed some superfluous code. by stephan ยท 3 years, 7 months ago
- 64f0e93 wasm/JS: documented DB.selectValue() and corrected the fetching of NULL columns via Stmt.get(). by stephan ยท 3 years, 7 months ago
- a240a24 wasm/JS: added support for scalar UDFs. Fixed a deallocation problem with bind()ed strings/blobs. by stephan ยท 3 years, 7 months ago
- e145136 wasm: minor refactoring and doc updates. by stephan ยท 3 years, 7 months ago
- 325b56b fiddle: cleaned up and documented the status-loading progress mechanism in prep for reusing it in the sqlite3-api worker. by stephan ยท 3 years, 7 months ago
- dc5888e wasm: added missing 'use strict' and fixed an undeclared var use caught by that. by stephan ยท 3 years, 7 months ago
- 192201d wasm: corrected isSupportedBindType() to behave as documented. by stephan ยท 3 years, 7 months ago
- ea488b1 New test cases to further demonstrate the difference in name matching rules by drh ยท 3 years, 7 months ago
- 51e5d44 Add an assert() to clear a harmless static-analyzer warning. by drh ยท 3 years, 7 months ago
- 43baa1d Do not run the subroutine that materializes a view or subquery until just by drh ยท 3 years, 7 months ago
- 71eacea 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). by stephan ยท 3 years, 7 months ago
- c21c0e2 WASM: an arg handling fix for DB.exec({multi:true...}). by stephan ยท 3 years, 7 months ago
- 744a65c WASM: added exec(), execMulti(), and several getters. Various touchups and fixes. by stephan ยท 3 years, 7 months ago
- f686856 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. by stephan ยท 3 years, 7 months ago
- 40b5b19 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. by stephan ยท 3 years, 7 months ago
- d60b727 WASM OO wrapper #1: prepare() and bind() APIs are in place but are untested, pending fetch/get APIs. by stephan ยท 3 years, 7 months ago
- 166542c 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. by stephan ยท 3 years, 7 months ago
- 4ec29fc 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. by stephan ยท 3 years, 7 months ago
- 40822eb Defer materializing a view or subquery until the materialization is actually by drh ยท 3 years, 7 months ago deferred-materialize
- 660dfbd Fix a typo in a comment. by drh ยท 3 years, 7 months ago
- b800bd6 Use the newer OP_BeginSubrtn opcode instead of OP_Integer to start the by drh ยท 3 years, 7 months ago
- 4257373 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. by stephan ยท 3 years, 7 months ago
- 0592b20 fiddle: add a selection list of example queries. by stephan ยท 3 years, 7 months ago
- 2eb4541 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. by stephan ยท 3 years, 7 months ago
- 056b72a Added the standard sqlite license header to the the fiddle JS files. Minor internal renamings in those same files. by stephan ยท 3 years, 7 months ago
- e26d162 #if'd out the '.nonce' and '.check' commends in WASM builds. by stephan ยท 3 years, 7 months ago
- 1c0dcec #if'd out the the '.cd' and '.clone' commands for WASM builds. by stephan ยท 3 years, 7 months ago
- 2f72d71 fiddle: consolidated two duplicate CSS rules. Internal doc typo fix. by stephan ยท 3 years, 7 months ago
- 091fb16 Added a disclaimer about fiddle's experimental and subject-to-change/removal nature. by stephan ยท 3 years, 7 months ago
- 9d023c2 Merge the changes to support the "fiddle" extension. by drh ยท 3 years, 7 months ago
- d59ac28 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. by stephan ยท 3 years, 7 months ago fiddle
- 7db1289 Tweaks to the fiddle make target so that it builds with all of the same by drh ยท 3 years, 7 months ago
- 2d0a85c Added a toggle to swap input/output field positions and simplified setup of checkboxes which toggle a CSS class on a given element. by stephan ยท 3 years, 7 months ago
- e9e0208 Default to top/bottom layout with input on the bottom. Offer a toggle to swap input/output positions. by stephan ยท 3 years, 7 months ago
- 3824059 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. by stephan ยท 3 years, 7 months ago