bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity

Commit Graph

  • d964b8cfa3 Add the new "retest" command to testrunner.tcl, which reruns any tests that failed or never completed in the previous invocation. New makefile target "retest" for both unix and Windows that runs testrunner.tcl with "retest". drh 2025-12-31 17:21:30 +00:00
  • 634a915132 Enhance testrunner.tcl so that it can always be run from an ordinary tclsh as long as that tclsh can load the sqlite3 package. drh 2025-12-31 14:17:51 +00:00
  • 31f6052f03 Fix test/shellB.test so that it works under Device-One. Also bring the header comment of shellB up to date. drh 2025-12-31 11:46:26 +00:00
  • f8cae0b149 Update the autoconf tarball Makefile.msc to align with the canonical makefile. drh 2025-12-31 11:00:51 +00:00
  • bc9cebcd1d Use sqlite3_malloc64() in all places in the compress.c extension to avoid integer overflow. drh 2025-12-31 10:59:40 +00:00
  • f8bd7df996 Use sqlite3_malloc64() in all places in the compress.c extension to avoid integer overflow. [forum:/forumpost/2025-12-31T01:04:00z|Forum post 2025-12-31T01:04:00z]. drh 2025-12-31 01:19:51 +00:00
  • 2b0579b06b Fix a typo in check-in 0819fe670f9ceec7 that lead to incomplete protection against buffer overflow in the zipfile extension. drh 2025-12-31 01:11:36 +00:00
  • 03380a55a5 Fix a typo in [0819fe670f9ceec7] that lead to incomplete protection against buffer overflow in the zipfile extension. [forum:/forumpost/2025-12-30T23:57:19z|Forum post 2025-12-30T23:57:19z] drh 2025-12-31 01:01:14 +00:00
  • d32e21ac95 Fix the output from the (undocumented) --test-argv option of the CLi so that it correctly displays UTF8 text on Windows. drh 2025-12-30 13:10:10 +00:00
  • 9f44bc5ea0 Add missing free() to winmain.c drh 2025-12-30 13:01:05 +00:00
  • 02ceb91875 Improved handling of the process entry point in Windows, to translate arguments into UTF8. drh 2025-12-30 12:38:43 +00:00
  • 918efe3cce Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter. dan 2025-12-30 11:36:23 +00:00
  • 01f2907d48 Fix the change on this branch so that it works with amalgamation builds. fts5-int-overflow-fix dan 2025-12-30 11:33:30 +00:00
  • 6e92494955 Avoid signed integer overflow when an fts5 'merge' command is passed -2147483648 as a parameter. dan 2025-12-30 11:19:27 +00:00
  • 9924b07cc2 Fix the new .import logic in the CLI so that it honors ".bail on". [forum:/forumpost/6c1c0e213d|Forum post 6c1c0e213d]. drh 2025-12-29 23:56:05 +00:00
  • fb795dbe73 Fix error messages associated with .import, along with corresponding test cases. drh 2025-12-29 21:39:48 +00:00
  • 7dfb1431dc Incremental improvements to .import, and new test cases. drh 2025-12-29 19:04:41 +00:00
  • bd91ba71d5 Update to the unix build documentation. drh 2025-12-29 12:46:35 +00:00
  • ce36cccd36 Fix the "testfixture" makefile target so that it builds with a static TCL library on Mac-ARM. Fix the "tool-zip" target so that it uses ordinary tclsh rather than testfixture to run the tool/mmktoolzip.tcl script that builds the archive. drh 2025-12-29 12:34:37 +00:00
  • 6693e78772 Test cases for .import, as well as minor enhancements to .import and to .check. drh 2025-12-28 21:37:58 +00:00
  • c00c0a8392 If the filename argument to the .import command is of the form "<<endmark" then the content is read from the script (or stdin) until the first line that begins with "endmark". drh 2025-12-28 14:32:28 +00:00
  • 38c8014940 Improvements to the .import command of the CLI. drh 2025-12-28 14:01:52 +00:00
  • 35f37ec959 Change a single integer variable to 64-bit in the tokenizer to avoid any possibility of an integer overflow. drh 2025-12-27 19:57:59 +00:00
  • 7f56d23f9c Work around the Windows "Worst-Fit" bug in the "sqldiff.exe" program. drh 2025-12-26 20:13:32 +00:00
  • 4056656047 To ensure that the sqlite3_hard_heap_limit() call it makes is effective, add "sqlite3_config(SQLITE_CONFIG_MEMSTATUS, 1);" to fuzzcheck.c. dan 2025-12-26 17:23:25 +00:00
  • 91d0ffa576 Doc typo fixes in the configure script pieces. stephan 2025-12-24 18:12:08 +00:00
  • 683df60dbf Enhance the omit-noop-join optimization so that it is able to omit a chain of noop-joins. Optimization improvement suggested by [forum:/forumpost/11a53f2bad|forum post 11a53f2bad]. drh 2025-12-24 14:03:15 +00:00
  • 337fce82f0 Additional changes to support the ".schema" command on builds that omit virtual tables. drh 2025-12-23 17:24:10 +00:00
  • f256886b8e Fix the ".schema" command in the CLI so that it works on builds that omit virtual table support. drh 2025-12-23 16:51:49 +00:00
  • 8511ee1e19 Harmless typo fixes in shell.c drh 2025-12-23 11:13:52 +00:00
  • 766389bd65 API documentation enhancements. drh 2025-12-22 17:06:37 +00:00
  • add73c831b Add the SQLITE_PREPARE_FROM_DDL flag to sqlite3_prepare_v3(). Use this to prevent fts3/4 tables in non-trusted schemas from calling unsafe SQL functions. dan 2025-12-22 15:22:02 +00:00
  • 8d41b94bb4 Fix spurious error log reports caused by [d25c8a6222d4e3f2]. See [forum:/forumpost/d2326687662430c1|forum post d2326687662]. drh 2025-12-22 12:33:27 +00:00
  • 3b81f93532 Fix a harmless signed integer overflow warning in the ieee754() extension function. drh 2025-12-22 12:00:57 +00:00
  • 19a3f74bdc Remove unused thunk cases from os_win.c, so that it will (hopefully) compile again on WinXP. drh 2025-12-22 11:28:16 +00:00
  • 323199b57e Fix a memory leak in the fileio extension on windows. Other changes to makefiles and similar to get zipfile testing working on Windows. drh 2025-12-19 23:47:07 +00:00
  • 174dabe096 Add experimental compile-time option SQLITE_ALLOW_TRIGGERS_ON_SYSTEM_TABLES. drh 2025-12-19 13:17:40 +00:00
  • 683c563241 Bug fix in the vt02.c test virtual table. drh 2025-12-18 20:44:48 +00:00
  • 65bc1f0ff4 Allow queries that use "GROUP BY e1 ORDER BY e2" where e1 and e2 are identical aprt from ASC/DESC sort-orders to be optimized using a single index. Also allow virtual tables to optimize DISTINCT in cases where the result-set of a query does not exactly match the ORDER BY clause. dan 2025-12-18 18:47:49 +00:00
  • ae66a8d760 New options for vt02.c that allow tests to configure it to partially de-duplicate a DISTINCT query. drh 2025-12-18 16:14:38 +00:00
  • ce46f82bc4 Improve tests in bestindexF.test. No changes to non-test code. dan 2025-12-18 16:05:05 +00:00
  • 4461335b00 Better orderByConsumed logic in the vt02.c test virtual table. drh 2025-12-18 15:35:50 +00:00
  • 1b7b75679a Enhance the sqlite3_load_extension() so that when the entry point is not specified, after trying sqlite3_extension_init() and sqlite3_X_init() where X is the alphabetic part of the base filename, if neither or found it tries again with X as the alpha*numeric* part of the base filename. Hence, a shared library named "vt02.so" can be loaded with just ".load vt02" and without having to specify the entry point separately. drh 2025-12-18 14:01:43 +00:00
  • 93c6b19f92 Enhance the vt02.c test virtual table with the ability to process ORDER BY DESC. drh 2025-12-18 12:49:44 +00:00
  • 6c2f5dabf4 Fix the return value of sqlite3_vtab_distinct() in cases where a virtual table query has similar GROUP BY and ORDER BY expression lists. dan 2025-12-17 21:00:06 +00:00
  • 89bc8e8a34 Fix a FILE* leak in the CLI drh 2025-12-17 13:10:23 +00:00
  • 93ecf30068 CLI: The .imposter command matches the index name regardless of case. Minor fixes to .check. drh 2025-12-16 13:43:35 +00:00
  • 6c26b5db71 CLI improvements. In the .check command, ignore leading and trailing whitespace unless the --exact option is used. In the .limit command, do not print the new limit when changing the limit, but only when requesting the current value of the limit. drh 2025-12-16 13:25:45 +00:00
  • 28ec7be607 Stricter enforcement of the LIKE_PATTERN_LENGTH for the regexp extension. drh 2025-12-16 13:13:21 +00:00
  • a1dbb7a93e Fix for optimizing "SELECT DISTINCT ...cols... FROM vtab" in cases where the virtual table implementation is able to deliver results sorted by "...cols...". dan 2025-12-15 18:45:22 +00:00
  • 97601244e2 Enhance the vtablog extension so that it shows the value of sqlite3_vtab_distinct() in xBestIndex, and so that provides the new consume_order_by option that can cause xBestIndex to set the orderByConsumed flag. drh 2025-12-15 17:32:56 +00:00
  • 67767084b6 Enhance the unixIsSharingShmNode() code (check-in [6385a1962c69c69c]) to avoid possible deadlocks with threads in findResuableFd(). dan 2025-12-15 14:56:57 +00:00
  • 22546e1d7e Clarify the affect of nCharLimit, nLineLimit, and nTitleLimit on the xRender output from QRF. drh 2025-12-15 13:58:41 +00:00
  • 586a649698 Fix the test/vt100-a.sql script to use .testcase and .check. drh 2025-12-15 13:26:27 +00:00
  • e2bb4cf412 Enable an ORDER BY clause to refer to columns in outer queries. drh 2025-12-15 11:59:47 +00:00
  • 76f1fe2942 Use the correct wildcard character in sqlite3_strlike() in the previous check-in. drh 2025-12-13 23:18:04 +00:00
  • 5266818aed In the CLI, if a command-line argument names a file and the filename ends with .sql or .txt, then process that file as an SQL script. Use this feature for better testing. drh 2025-12-13 21:11:49 +00:00
  • ce43bf85fa Back out the --compat option from the CLI. drh 2025-12-13 00:13:40 +00:00
  • 4f3ab29aab Get the .testcase and .check commands working in the CLI. drh 2025-12-12 18:22:07 +00:00
  • d031267c17 Add new assert() statements designed to detect and prevent the kind of system interface numbering errors that happened in [108691a3cb2f296f] and that were not fixed until [fe49703034bd23fa]. drh 2025-12-12 12:06:42 +00:00
  • 48915e7c7d Omit unused entries in the aSysCall array for the Windows driver. Fix incorrect numbering in alter entries of that array. drh 2025-12-12 11:50:37 +00:00
  • 462289df52 Remove from os_win.c a reference to unused system call CreateEventExW() left over from the now removed winrt support. dan 2025-12-12 11:02:18 +00:00
  • 63f1fb40be Fix an inaccuracy in the qrfRelaxable() routine in QRF when the input is an empty string. drh 2025-12-12 10:21:52 +00:00
  • 5eba66ad66 Include the latest Makefile.msc changes and the new "make.bat" script in the amalgamation tarballs. drh 2025-12-12 00:21:10 +00:00
  • c2cd606f8a Prevent a malicious delta from causing an integer overflow in the fossildelta extension. This code is not used in the SQLite core. drh 2025-12-11 23:24:05 +00:00
  • b304b0d165 Update build instructions for Windows to explain how to link against ZLIB. drh 2025-12-11 18:16:39 +00:00
  • e29acd77c3 Adjust the MSVC Makefile so that when it invokes the zlib makefile, it changes CFLAGS to use the correct -M compiler option to match SQLite. drh 2025-12-11 17:49:17 +00:00
  • 9334b9f1b8 Fix calls to sqlite3_wal_checkpoint_v2(SQLITE_CHECKPOINT_NOOP) so that they do not return SQLITE_MISUSE. dan 2025-12-11 11:05:26 +00:00
  • c0160fa11a Use macros for the default values for QRF limits in the CLI, rather than hard-coded magic numbers. drh 2025-12-10 19:43:06 +00:00
  • 85fb541ac0 Various improvements to the .mode command of the CLI, and especially to how it handles the --limits option. drh 2025-12-10 19:04:49 +00:00
  • 3262f769ee In fiddle, remove the default .dot-commands it runs, as they do not reflect current shell defaults. stephan 2025-12-10 16:20:44 +00:00
  • 2f2b5d7b20 Add the --titlelimit option to CLI, defaulting to 20. In "line" mode of the CLI, the default seperator is changed from " = " to ": ". This can be overridden using the --colsep option. drh 2025-12-10 16:10:26 +00:00
  • 9d5f00706f Do not show the --titlelimit setting in ".mode" setting output unless -v is used or unless the current style is tabular or line. title-limit drh 2025-12-10 15:55:44 +00:00
  • 1debc25ef8 Test cases and documentation tweaks. drh 2025-12-10 15:50:23 +00:00
  • 9bf37cc3eb Add the nTitleLimit option to QRF. Also change "line" style so that it uses zColumnSep as the divider between the title and the value. drh 2025-12-10 15:24:46 +00:00
  • 30ba9bec54 Fix the processing of implied LIMIT clauses when flattening a compound query. branch-3.28-limit-patch drh 2025-12-09 19:15:52 +00:00
  • b4f6c09e60 In fts5, avoid holding an open blob handle after an INSERT/UPDATE/DELETE statement, as this can interfere with sqlite3_interrupt(). Forum post [forum:/forumpost/95413eb410 | 95413eb410]. dan 2025-12-09 13:41:01 +00:00
  • 55385fb79c Fix an incorrect answer that might arise if a scalar query is both DISTINCT and contains an OFFSET clause. drh 2025-12-09 13:29:08 +00:00
  • 567dcbb5db Update the added-in-version stamp to some kvvfs JS APIs. stephan 2025-12-08 13:11:17 +00:00
  • 91479c6b10 Introducing kvvfs v2 for the JS bindings. Summary: no longer hard-coded to session/localStorage, available outside of the main UI thread (non-persistently), a simpler-to-use import/export API, and adds an asynchronous event interface intended for creating page-by-page db backups. stephan 2025-12-08 13:06:27 +00:00
  • 50ef2f7813 Replace some double-quotes with single quotes an SQL doc snippet in the csv example virtual table. kvvfs-v2 stephan 2025-12-08 12:24:23 +00:00
  • 1241fe1450 Minor tweaks to the QRF documentation. No changes to code. drh 2025-12-07 18:19:22 +00:00
  • ee9f4acb10 Do not return too many bytes from the zipfile extension given a malformed ZIP file. drh 2025-12-06 23:58:09 +00:00
  • 5a05c59d4d In the zipfile extension, only return as many bytes as Inflate actually generated. [forum:/forumpost/761eac3c82|Forum post 761eac3c82]. Adjust ./configure so that it builds zipfile into testfixture if ZLIB is available, so that tests get run on unix platforms. zipfile-fix drh 2025-12-06 20:41:24 +00:00
  • 4a33eed6e9 Remove #ifdefs intended to make SQLite compatible with Windows RT. WinRT was short-lived and has been discontinued for a long time. drh 2025-12-06 19:56:40 +00:00
  • 97b5c8c624 Fix a harmless compiler warning inside an assert() in FTS3. drh 2025-12-06 18:40:14 +00:00
  • 6cc0da6e7d Fox the "box" format, use rounded corners and use a double-line to separate the header from the content. Add the "-quote relaxed" text rendering mode and make it the default for TTYs. drh 2025-12-06 11:54:43 +00:00
  • 4ccd61107f Fix typos and harmless compiler warnings. Omit the use of ctypes.h in QRF. qrf-box-enhancements drh 2025-12-06 11:50:36 +00:00
  • 4ddf151841 New test cases to cover the "--quote relaxed" feature. drh 2025-12-06 11:35:30 +00:00
  • 5fb9d599ed Update test cases to work with the new box format and with --quote relaxed. drh 2025-12-06 11:02:14 +00:00
  • cff66960fd New text rendering style of QRF_TEXT_Relaxed. drh 2025-12-06 10:07:15 +00:00
  • a3647d17c8 When drawing boxes using QRF, use rounded corners and use a double-line to separate column headers from the content. drh 2025-12-05 22:04:49 +00:00
  • 989e893392 In the Windows Makefile.msc, never set -DNDEBUG. And add the "env" target which prints out the value of all 127 configuration variables that Makefile.msc uses. drh 2025-12-05 19:45:43 +00:00
  • 1af2607177 Fix a memory leak in the fileio extension on windows. dan 2025-12-05 19:23:20 +00:00
  • 8da97114b5 Omit obsolete features (Ex: Windows Phone support) from the Windows Makefile.msc. More of this kind of thing is pending... drh 2025-12-05 16:06:34 +00:00
  • 14706ff98d Minor adjustment to the zipfile.test script so that it works on Windows. drh 2025-12-05 15:09:42 +00:00
  • e1a2674f06 Enhance the unixIsSharingShmNode() code (check-in [6385a1962c69c69c]) so that it more understandable by humans, and so that it does not trigger false positive deadlock warnings in TSAN. drh 2025-12-05 12:22:23 +00:00
  • fced18af1a Increase the patch number to 3.51.2 drh 2025-12-05 01:43:23 +00:00
  • 334fa0eb5a Ensure that the EXISTS-to-JOIN break happens even if the inner loop is a "no-op" loop that never executes more than once because it is controlled by a UNIQUE index. drh 2025-12-05 01:38:59 +00:00
  • 38ba1adb36 Another fix to [e33da6d5dc964db8]: Ensure that the EXISTS-to-JOIN break happens even if the inner loop is a "no-op" loop that never executes more than once because it is controlled by a UNIQUE index. This resolves the error reported in [forum:/forumpost/7992838ba2|forum post 7992838ba2]. Test cases are in TH3. drh 2025-12-05 01:33:23 +00:00