aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Add extra debugging code for sqlite3_stmt_scanstatus_v2() to test1.c.dan2023-06-30
| | | FossilOrigin-Name: f936f101406069b29218c89a36581b4497226fb61906782ea368f12d943c901c
* Completely unwind the enhanced precision sum() from [a915f15a916af698] sodrh2023-06-30
| | | | | as not to offend UBSAN and OSS-Fuzz. FossilOrigin-Name: 85be05b66ef975f02a3e7b2984bcab97d9280c7f3b6ee1e16718de549f240d46
* Omit the doubleToReal() function in vdbemem.c. Use thedrh2023-06-30
| | | | | equivalent sqlite3RealToI64() function in its place. FossilOrigin-Name: 625820e8ebfdcf513c81b1b632bbe2aa882a8fbba52001113dc6f56270fa5ceb
* Make the sum() function less precise and slower in order to avoiddrh2023-06-30
| | | | | harmless signed integer overflow UBSAN warnings from OSS-Fuzz. FossilOrigin-Name: 1be0646a2c352dbf03d2af87fd48b6f9edfd68666790ac6863144ac95f3e0621
* Fix harmless compiler warnings about unused function arguments.drh2023-06-29
| | | FossilOrigin-Name: 24927c1377314a10177da4a57191593440aa97fd0c5949fdf25a22df1d947600
* Improve the range of floating-point numbers that can be handled as integersdrh2023-06-29
| | | | | for numeric-to-text conversion. FossilOrigin-Name: 41580ba452fdbc3f73da60d8030289d38614c4cab8d24140d7cc44a54b2da8d2
* Further refine the dtostr() testing function in the CLI so that it takes andrh2023-06-29
| | | | | optional second parameter which is the number of significant digits to display. FossilOrigin-Name: 2f9d4444aa503102a00d6e6769dadc57d4b26a2c07f145f23f2f28e0c161246d
* Change the (undocumented) dtostr() SQL function in the CLI so that it onlydrh2023-06-29
| | | | | | shows the first 26 significant digits - 10 more digits than are available in a 64-bit double. FossilOrigin-Name: d758859f6ab94ddb9b3ee6f6f5f24b16e2b7a7712761080cfc6540d68b5a0c97
* CLI enhancements to facilitate SQLite core testing:drh2023-06-29
| | | | | | | | (1) Add built-in functions strtod() and dtostr() that convert text to floating point and back using C-library routines. (2) Do not disable all of ".testctrl" without --unsafe-testing, but only those subcommands of .testctrl that are actually dangerous. FossilOrigin-Name: 669996a8ddcbf35f3de66cf466508fc1e6dd09ab269aba395ac86a11b2ec238c
* Enhance the SUM() aggregate (and related AVG() and TOTAL()) so that the runningdrh2023-06-28
|\ | | | | | | | | sum is accurate to about 100 bits. FossilOrigin-Name: a915f15a916af698e0cef46c8b3e7ed11bda19349179d2d414073cd39c4cce24
| * Use ideas from T. J. Dekker in "A Floating-Point Technique for Extending thedrh2023-06-26
| | | | | | | | | | | | Available Precision" (1971-07-26) to enhance the accuracy of the SUM() aggregate function in cases where input magnitudes vary wildly. FossilOrigin-Name: 439fc00fee62b4db3751860485e21a99cae4fd1f5d911b2c08651a1466245ecc
* | Improved accuracy of floating-point conversion constants as suggested bydrh2023-06-28
| | | | | | | | | | [forum:/info/598d32f6135c41c1|forum post 598d32f6135c41c1]. FossilOrigin-Name: 4943e8a1819e189747eefc414d02c0485e1620deff9cf92664295b21a8a9a83c
* | Fix CLI .sha3sum error message for keyword identifiers, reported in ↵larrybr2023-06-26
|/ | | | | [forum:/forumpost/7cbe081746dd|forum post 7cbe081746dd]. FossilOrigin-Name: 9d7813ddcf67f1256e7331c5f390cb122b3f7e35cf46e0b33b610216a5396a00
* Optimize the argument to the octet_length() function so that it does notdrh2023-06-22
| | | | | attempt to read content from disk. FossilOrigin-Name: 8b8ea4e3f52d96cc217bd1fb27ca4a83489ef1f250756ed2f790d1b0ee529a3a
* Merge recent trunk enhancements into the octet_length branch.drh2023-06-22
|\ | | | | FossilOrigin-Name: d35c214811aac7dec0000ca2aa77231f74a7963dd0c53cf25a65ade5ef0f8dc0
| * Simplification to the getAndInitPage() routine that results in improveddrh2023-06-22
| | | | | | | | | | performance. FossilOrigin-Name: 2e9734c2335d8c06fedc9f4cca02baaf326f7fa276bd464f3214f383715a48d6
| * Improved comment on the getAndInitPage() in btree.c. No code changes.drh2023-06-21
| | | | | | FossilOrigin-Name: dc468cfdb825083b3a4b6cb95c913961e9312e22103c5a0cd923b75c83c65e13
| * Add the --pcachetrace option to the CLI.drh2023-06-21
| | | | | | FossilOrigin-Name: 61dfa92b44ad38a7aac76a09e167819ce5d0acace3e06ba9ed17b3264cc043c1
| * Omit unnecessary calls to table locking routines in the common case whendrh2023-06-20
| | | | | | | | | | there is no shared cache. FossilOrigin-Name: f94f3021cde1d46373ee8fc8e5028d7507a937240c59cf0d0d19ab22acbd3c41
| * Avoid unnecessary calls to sqlite3DeleteTable() with NULL pointers.drh2023-06-20
| | | | | | FossilOrigin-Name: 4a35f391995a88757d7b46f52bf241f523ee2a6a7b6726df00cddaec8cee7080
| * Avoid unnecessary calls to sqlite3CodeRowTrigger().drh2023-06-20
| | | | | | FossilOrigin-Name: 27c174dbd0e7ba029d13fb005fc950ac99eb6aee31903ee3acfc88c262d13f6a
| * Performance optimization in sqlite3VdbeAddOp4Int().drh2023-06-20
| | | | | | FossilOrigin-Name: 456a24324bd42e1e3384ffa8474b7d0760b27df95be0e92ddce5eb87339f6272
| * Avoid unnecessary NULL pointer checks on calls to sqlite3WalkExpr().drh2023-06-19
| | | | | | FossilOrigin-Name: 73d86a12fb068456a884c030fddd87020d6ec9d56376de541cf082b2104174d3
| * Small performance improvement and size reduction by recognizing that nodrh2023-06-19
| | | | | | | | | | SQL keywords have less than 2 characters. FossilOrigin-Name: 6b3d25b7982623ab4b25161aff9ab44778e136069043ab425543597c42c98ae5
| * Fix large integer constants so that they work on older C compilers.drh2023-06-19
| | | | | | FossilOrigin-Name: 3c94f87806a8b408d8204fc7deec16d01c085ee199ff21a1f20b6346ce816cfe
| * Fix harmless compiler warnings that show up on 32-bit RaspberryPI builds.drh2023-06-17
| | | | | | FossilOrigin-Name: bc4d20f362925e4ce5c79f0d7a27a8e9bbac92525bd4cea2ae983798e3f8c37d
| * In date/time functions, fix the rendering of "subsecond" and thedrh2023-06-17
| | | | | | | | | | | | computeHMS() routine to better deal with floating point rounding errors that arise on some 32-bit systems. FossilOrigin-Name: e46a00ae880dd12df090105498a85017d1367f88bf27d86f0b0200cf0536a906
| * Address various harmless compiler warnings fromdrh2023-06-16
| | | | | | | | | | [forum:/forumpost/d526da8ee4|forum post d526da8ee4]. FossilOrigin-Name: 365caf2f97e8f15842f52536e8d05d359e9d6e863182e020ce14a9a9f27ee057
| * Fix the pager such that if the xOpen() message sends back the SQLITE_OPEN_MEMORYdrh2023-06-16
| | | | | | | | | | | | | | flag, the pager is opened in journal-mode MEMORY, even if compiled with SQLITE_OMIT_DESERIALIZE. No changes to the logic as long as that OMIT flag is omitted. We need to better document the behavior of xOpen to describe this. FossilOrigin-Name: da1252b29852191eccbea98e0314408c75bb83a51f9d68d589705d4971a23850
| * Work around what appears to be a GCC 32-bit optimization problem in thedrh2023-06-14
| | | | | | | | | | computeHMS() routine of the date/time logic. FossilOrigin-Name: aebdbcbebff1319dd00551c9fb9ad4b08859f10e87f097295d564ae1ba188c02
| * Improved sqlite3_error_offset() values for bare column errors on '*' anddrh2023-06-13
| | | | | | | | | | 'table.*' expressions in SELECT statements. FossilOrigin-Name: 118fe600876686273f85d0a080a21267e83c11826365f3220336b1bd39562518
| * Extended the time-diff format so that it can have a 5-digit year. This enablesdrh2023-06-13
| | | | | | | | | | | | | | time differences to span the full range of dates supported by SQLite. Also fix some inaccuracies in the computation of time differences and add new test cases. FossilOrigin-Name: d57ddbf4eeeb3ccfe31871f098045b9e58634153a3c3030f597cb58c1177218a
| * Fix a problem causing bloom filters to be used less efficiently than they ↵dan2023-06-12
| | | | | | | | | | might be. Problem reported by forum post [forum:/info/06c3f01da6 | 06c3f01da6]. FossilOrigin-Name: 56d9bb7aa63043f5db4a1e5e8eefe46762dba433145807c6e27a8316f1d03d7a
| * Check-in [70e12efd1b189560] left a path through lockBtree() that failed todrh2023-06-12
| | | | | | | | | | | | set the BTS_PAGESIZE_FIXED flag. That omission is fixed by this check-in. dbsqlfuzz 02c9ab74eb0619c9ae3b894ce157fae1d7f94645 FossilOrigin-Name: 30dcc872eb1c9549708009c86357826c4f15ffa17e379dab5cd4aec596643728
| * Make sure temporary sqlite3_value objects used by STAT4 are reset to NULL priordrh2023-06-11
| | | | | | | | | | | | | | to being reused, to prevent a memory leak associated with the custom xDel string value destructor. dbsqlfuzz 65209ab5d5730e4fd14fff9d024325a77239036e. FossilOrigin-Name: 88be7075cdc7000d3a1e84e49064cf8c28fc7caca9c464f44a83265223961b51
| * Defer setting the BTS_PAGESIZE_FIXED flag until after we are certain theredrh2023-06-10
| | | | | | | | | | are no errors and the page size has been set. FossilOrigin-Name: 70e12efd1b189560e07f59db03a20b8c1ab19224aae4fc3d7c0bdfd2568064ea
| * Fix an assert that can go bad if STAT4 content is corrupt. This is adrh2023-06-10
| | | | | | | | | | follow-up to the previous check-in. FossilOrigin-Name: ac1d3860af4eb30e4a7444b01d7b5afc91a4b1f5e3fe5414a491c6edc7ff1631
| * Extra space to prevent a buffer overread on corrupt STAT4 records.drh2023-06-10
| | | | | | | | | | dbsqlfuzz 7128d1b41ce9df2c007f9c24c1e89e2f1b2590ca. FossilOrigin-Name: b99135288b157044e2319833e8632c89483778f876aa45ee66e46ffb6ae42ab2
| * Simplify a memcpy() in defragmentPage(). It now might copy more content thandrh2023-06-09
| | | | | | | | | | | | | | | | | | is strictly necessary, but runs faster and uses less code space. Possible reasons for the improved performance: (1) the copy is now always 8-byte aligned, (2) fewer intermediate results are required which means less register pressure which helps the compiler to optimize the subroutine. FossilOrigin-Name: 6e5607ae4d872954483a8d7a5c866aa41e4af70fae9652fb7eb211b316ab724d
| * Fix straggler misspellings and tidy the custom dictionary. Also include ↵larrybr2023-06-07
| |\ | | | | | | | | | | | | pickups from [forum:/info/c61fb09afd|forum post c61fb09afd]. FossilOrigin-Name: 8c291d99946eb32b20b743921202f9c7cfb716268ff526817b27adbb7942e40b
| | * Remove additional traces of FTS1 and FTS2 that were missed by [2bb50d5aedef0fd2]drh2023-06-07
| | | | | | | | | FossilOrigin-Name: 9a12bac5d24c7a8364d2127fd12c3409a53ef83e408d10f344ddd311cdba98af
| * | Add a C-source spell-checking facility. make misspell (on Nix)larrybr2023-06-07
| |/ | | | | FossilOrigin-Name: 26c1bb4bd9e9f56613c3aa87407a7f562fd4ebde5bfd6dece02078001d9a45f8
* / Prototype implementation of the octet_length() SQL function.drh2023-06-03
|/ | | FossilOrigin-Name: 2db989c8635f7e89b3ea58d1fde94787fced039ac1a118d9b6362811eda73f87
* Clarify sqlite3_is_interrupted() return. No code change.larrybr2023-06-02
| | | FossilOrigin-Name: b6c2d3d203100a34335aeba23a8fb82a13297b65eed494d5044ade3bed683bc3
* Restore the LEFT JOIN strength reduction that was partially lost indrh2023-06-02
| | | | | [d747afda5683ca5f] when strength reduction was generalized to all OUTER JOINs. FossilOrigin-Name: 2d962b84dd8ac2d0968f0283f8f082c1c2a7a1f99b59053b2ad8f58745396447
* Do that last CLI fix more simply, using established means.larrybr2023-06-02
| | | FossilOrigin-Name: a1823b297616bc2bd64eda9df4850fb460d8da8959ae3728195db896d1f89e7b
* Fix CLI fault on missing -nonce reported by [forum:/info/f8c14a1134|forum ↵larrybr2023-06-02
| | | | | post f8c14a1134]. FossilOrigin-Name: cd24178bbaad4a1dafc3848e7d74240f90030160b5c43c93e1e0e11b073c2df5
* Fix the OUTER JOIN strength reduction theorem prover's handling of the CASEdrh2023-06-02
| | | | | operator. FossilOrigin-Name: 73d7b14b1713d93c4ae07995e9aa6485cbad90bd6125584dbaeccb0cc9410ea3
* Generalize the LEFT JOIN strength reduction optimization so that it works fordrh2023-06-01
| | | | | | RIGHT and FULL JOIN as well. Rename it to the "OUTER JOIN strength reduction" optimization. FossilOrigin-Name: d747afda5683ca5feb92866a14ccc4c5127d3378ece5cad2c3da819f2477b457
* If the filename argument to sqlite3_load_extension() is an empty string, thendrh2023-06-01
| | | | | | | raise an error. It turns out that if dlopen() is called with an empty filename, it tries to load the current executable. And then if the caller requests some other function from the current executable, mischief can result. FossilOrigin-Name: d01688554715eb4aaa1b1fd1a6b660b84e930edb0e062156ecf5228ee81ca754