aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Add sqlite3_win32_set_directory8() and sqlite3_win32_set_directory16() ↵mistachkin2018-05-02
| | | | | functions. FossilOrigin-Name: 6cf0f4e2b4536d56e559c228f01eafafc86c5cdc4af1fe260df2dd00c2985456
* Document and expose sqlite3_win32_set_directory() function for use on Win32.mistachkin2018-04-28
| | | FossilOrigin-Name: f677065aab61037914fc980456caaa60132a19b387d6d717ec1a6b6fa7c61a10
* Fix a problem causing the LEFT JOIN strength reduction optimization to bedan2018-04-10
| | | | | | incorrectly applied in some cases where the WHERE clause of the query contains a filter expression of the form "lhs.x IS NOT ?". FossilOrigin-Name: 1fdaf2c34431adcac1c7ff29aae0623c4cbaa6a7f38e843c786bd407d8b3e730
* When testing, avoid injecting an OOM fault into a file-control call made bydan2018-04-10
| | | | | SQLite on an unopened file-descriptor. FossilOrigin-Name: 9c1a5eba3ec37c877af4b83c6f8c05b7140304f3d23e49832ba63e321247fc8d
* Fix a problem causing the LEFT JOIN strength reduction optimization to bedan2018-04-10
| | | | | | incorrectly applied in some cases where the WHERE clause of the query contains a filter expression of the form NOT(x AND y). Ticket [1e39b966]. FossilOrigin-Name: 38d319c153641ea4138fab2d5a47c31a86f57a071a1e1c299ca54c980cfb2b60
* Remove an unnecessary SQLITE_UNTESTABLE compile-time conditional fromdrh2018-04-10
| | | | | the command-line shell. FossilOrigin-Name: 80b75a34a2a4c11bc35b8638f8f05d999db416c81edc1a1c81aa5029f0301da1
* Minor changes to the input grammar resulting in a faster and slightly smallerdrh2018-04-09
| | | | | parser. FossilOrigin-Name: a2c443c0ee9a0e0b2d10298b8a74ff00a1a66e3f96f4093348f0fef977587204
* Enhance the query planner so that it detects when the xBestIndex methoddrh2018-04-09
| | | | | | of a virtual table gives out-of-sequence argvIndex values and reports an error. Secondary fix for ticket [2b8aed9f7c9e6]. FossilOrigin-Name: 9506ec14fb9e58986c1b79a3ca78430ad94b10966944c864e0429a7688dd1454
* Improvements to ".wheretrace" output.drh2018-04-09
| | | FossilOrigin-Name: ea2e5b34bf35ade602dfcef359b64f810674f304fda14326b7f2dedefcc5f340
* Fix a (harmless) signed integer overflow warning.drh2018-04-09
| | | FossilOrigin-Name: 43c2c60caf0ba105f57e32fc7fe6938dc29538c04d477a35b9b8bba2fb8fdd07
* Fix an instance where an uninitialized VM register might be accessed. Fix fordan2018-04-05
| | | | | [093420fc0]. This problem was found by OSSFuzz. FossilOrigin-Name: a3b02db74681a215996c5ed110eb0ece5ed24f71a1b131c10e9f33e666af0256
* Fix the sqlite3WhereTrace mechanism so that it compiles withdrh2018-04-05
| | | | | | the --disable-amalgamation and the --enable-debug options to ./configure using clang. FossilOrigin-Name: 813224363d9ac22fcb37f657c4ac988f76fa39989301faec7206e9ba0b1f4476
* Change the LEFT JOIN strength reduction optimization so that assumes thatdrh2018-04-03
| | | | | | virtual table constraints can be true even if terms within the constraint are NULL. This works around dodgy virtual table implementations. FossilOrigin-Name: cbb977fe1908431f3aad8e67668588b119e7d491724f2042af436f509a4f6623
* Better solution to the LIKE problem from the previous check-in that worksdrh2018-04-02
| | | | | even if the SQLITE_LIKE_DOESNT_MATCH_BLOBS compile-time option is used. FossilOrigin-Name: b850dd159918af568c55c00ff146ba9c9c04d33ff384fe1eb0ad74164bc401bb
* Fix a logic error discovered by OSSFuzz.drh2018-03-31
| | | FossilOrigin-Name: fc06ddd458fc1028b33b3927cc3b113b7106caa67136993de2e57926a8a19623
* Fix an assertion failure triggered by a SELECT with a compound sub-query thatdan2018-03-31
| | | | | | | contains an incorrectly placed ORDER BY clause. This problem is just an assert() failure - non-DEBUG builds are not affected. Problem found by OSSFuzz. FossilOrigin-Name: 823779d31eb09cda5effe747d9adb35e600a52d4274226586437f674e7824d91
* Modify the sqlite3OsFileControl() interface to detect unopened sqlite3_filedrh2018-03-29
| | | | | objects and return SQLITE_NOTFOUND. FossilOrigin-Name: 1fc72b707d4f4df049c19b023ae3f70cb45d6a6768bb68efc519cfdcd2d2ecda
* Fix a harmless compiler warning.drh2018-03-28
| | | FossilOrigin-Name: f0d12354bba96056f930e5ed3e88c37ec139211be09e6cd6eb7310e979de56c8
* Remove tab characters. No logical changes to code.drh2018-03-28
| | | FossilOrigin-Name: eb29b3369e76ec1df25a5484d8ec5fb924e23d5c70aaa4d794b2b17ee18784c8
* Minor comment changes.drh2018-03-28
| | | FossilOrigin-Name: d282f064698782cf7b584138549a6b27befa0b945ae96b52a3ef6f8a13448077
* The push-down optimization was being too aggressive such that it sometimesdrh2018-03-27
| | | | | | | generated incorrect results. Reinstate the restriction (4) (with qualifications) that was removed by check-ins [b5d3dd8cb0b1e4] and [dd568c27b1d765]. FossilOrigin-Name: f08c1731b0b1dddcba190b094a35306a159713d3db939330f73075ff1d72c81e
* Do not inject OOM errors on SQLITE_FCNTL_LOCK_TIMEOUT calls as an OOM isdrh2018-03-26
| | | | | not possible in that context. FossilOrigin-Name: 5474e560eeb0269964b70bcd876bb86b4197c4fb164bc13454fb8204f083062c
* Avoid a race condition that might cause a busy_timeout to last longer thandrh2018-03-26
| | | | | it should. FossilOrigin-Name: b81960561b47a1b49646f2f8870dd0684dc4ca7c0b9e11076fd713de66b75972
* Add infrastructure to support for using F_SETLKW with a timeout on systemdrh2018-03-26
| | | | | that support that functionality. Requires SQLITE_ENABLE_SETLK_TIMEOUT. FossilOrigin-Name: 2e54a7433ece4eb27e71bda6f2d121d5aa46ddd5a481357d8543d1432aaad689
* Refactor some internal object element names used by the busy handler, todrh2018-03-26
| | | | | simplify analysis. FossilOrigin-Name: 6c40c5574f4ae9795a142d01a8f84afd1b72678ea5f6bfca14a8646c4e862605
* Add testcase() macros and improve comments in the LEFT JOIN strength reductiondrh2018-03-24
| | | | | optimization. FossilOrigin-Name: 5613457714dd74d6da8e387132a0d8e64980ba4a921a9f53773540b02c0ccec6
* Yet another fault in the sqlite3ExprImpliesNotNull() routine, causing errorsdrh2018-03-24
| | | | | | in the LEFT JOIN strength reduction optimization of check-in [dd568c27b1d76563]. FossilOrigin-Name: e88cf3d4df64097ebc19aae464b88d0faf9b7d4c30d057042b582d78327e7ad3
* Bug fix in the LEFT JOIN strength reduction optimization ofdrh2018-03-24
| | | | | | | check-in [dd568c27b1d76563]. The sqlite3ExprImpliesNotNull() routine was mistakenly assuming that a CASE expression must always be NULL if contained any reference to a variable that was NULL. FossilOrigin-Name: cf171abe954a5f25262161dd69f2e8cecdbf9446c3f6b298201507dbc743567e
* Fix the -readonly option on the CLI so that it actually works.drh2018-03-23
| | | FossilOrigin-Name: 0477fb3fd68509547f3bfd588247aac59aa4aa885ed8a21269852eda64e257ad
* Fix typo in a comment used for documentation. No changes to code.drh2018-03-23
| | | FossilOrigin-Name: 49974d3b30faaad0891a43d5e840f5dd2dc50ad6c4e6c408292de04e9e8a8868
* Enhance .schema in shell to enable matching patterns with literal underscores.mistachkin2018-03-23
| | | FossilOrigin-Name: 98e3f5247a6012f58642a2fcdc9be062f7afe8f2e154d06007f4935a0fd87aac
* Fix an error in the CLI in the previous ([0249d9aecf69948]) check-in.drh2018-03-23
| | | | | Only the pattern to sqlite3_strlike() need to be escaped. FossilOrigin-Name: 71d5f6e6322dc037a0e9089049e5d154100b2918830826e30f8043f01a287c00
* Fix the ANALYZE command so that it will process tables whose names begindrh2018-03-23
| | | | | with "sqlite" as long as they do not being with "sqlite_". FossilOrigin-Name: 0249d9aecf69948d9343feef9291273beef5fc98aa9a8f95b1e35cc2ce8e6cbd
* Fix harmless compiler warnings seen with MSVC.mistachkin2018-03-23
| | | FossilOrigin-Name: 2f2be1b1811e6b83fc8945da06e57b8b54233ff8a6ebd9d71b22c6bab2e74afb
* Relax LEFT-JOIN restrictions on the push-down optimization.drh2018-03-21
| | | FossilOrigin-Name: b5d3dd8cb0b1e42ed0671a12d22af05194ea9522e4f41fd4bb0deff70b8b0757
* Do a more thorough job of cleaning erasing traces of the strength-reduceddrh2018-03-20
| | | | | LEFT JOIN. FossilOrigin-Name: 08833dda3a25965cc509d0244d7cd68bdb2306351ca52862f347e1efe5db4508
* If terms of the WHERE clause require that the right table in a LEFT JOINdrh2018-03-20
| | | | | not be a null row, then simplify the LEFT JOIN into an ordinary JOIN. FossilOrigin-Name: 5b7abecc7ab8ccbbb8cb5e0f672e67625c2555ad03442efbf34cb395f5bb71a8
* Improvements to the HAVING-to-WHERE optimization. The code uses less spacedrh2018-03-20
| | | | | and less CPU, and there is now ".selecttrace" output. FossilOrigin-Name: 5ad668d4339397fe66fe085e0527e37a1930917da88d462a8d89a465faa15e28
* Avoid unnecessary write to the sqlite_sequence table when an insertdrh2018-03-20
|\ | | | | | | | | | | is done into an autoincrement table with an application-specified rowid that is less than the maximum. FossilOrigin-Name: ec7addc87f97bcff3c3694b14a680453b52de3f8c106436f0708a1cc04b90faa
| * Avoid writing the sqlite_sequence table when it has not actually changed.drh2018-03-16
| | | | | | FossilOrigin-Name: 3e3849a9d1a06673e6c713a42194f5da339fbf6533fa418c38f63d09bc045867
* | Remove a debugging statement accidently left in drh2018-03-20
| | | | | | | | | | check-in [eddc35f3057e59fd] FossilOrigin-Name: 85a31557ac0d0401c1bf2e23a502dc2ea57d9b1bc23c01de693f5d3fe22d8341
* | In the CLI, avoid extra .selecttrace and .wheretrace output when in ".eqp full"drh2018-03-20
| | | | | | | | | | mode. FossilOrigin-Name: 427bbf318a28e827bf03d43c2912c8ad937dd52f829feaf7fe374093692ed61b
* | Closer reading of the sqlite3_db_config() documentation show that it isdrh2018-03-20
| | | | | | | | | | subtly incorrect. This check-in fixes the problem. No code changes. FossilOrigin-Name: 44d90e7f4bc83680e8fbbf1a0423c6f5cc2cc2aed118b7af1c4c3d9e09b05dd7
* | Fix a minor formatting issue on the sqlite3_db_config() documentation.drh2018-03-20
| | | | | | | | | | No changes to code. FossilOrigin-Name: 8a439a6dda390d7486feb837f87a83e16abd283c882e81e637bd1235d2684379
* | Add the ability to disable the push-down optimization using the 0x1000 bit ofdrh2018-03-20
| | | | | | | | | | SQLITE_TESTCTRL_OPTIMIZATIONS. FossilOrigin-Name: eddc35f3057e59fdc25a6911abfaa53a10cc43d8030925b65737b2f51f907421
* | Minor improvements to ".selecttrace". No changes to non-debug code.drh2018-03-19
| | | | | | FossilOrigin-Name: 03e541f606ead1a13e1084db88e168278c82a2ba72b18c89baafeab3141367b4
* | In the compile_options pragma, show the actual value of thedrh2018-03-19
| | | | | | | | | | SQLITE_ENABLE_CEROD compile-time option, if it exists. FossilOrigin-Name: 1ec339fd109b31e1d2b1e73345bd7a00c3d755f2c45c14d050a8203969163d60
* | Improved ".selecttrace" output formatting. No changes in non-debug code.drh2018-03-19
| | | | | | FossilOrigin-Name: 30704d2a52d37717d8b34a402c99ea32453e5c1a9840037dba96591f4acc1503
* | Do not use sqlite3_column_decltype() in the CLI if it is compiled withdrh2018-03-17
| | | | | | | | | | SQLITE_OMIT_DECLTYPE. FossilOrigin-Name: 442e816b5fed80ebeb58c7c0ab9c2ef999bf488519bf5da670e9cec477034540
* | Detect corruption in the form of the sqlite_sequence table pointing to thedrh2018-03-16
| | | | | | | | | | wrong type of btree. FossilOrigin-Name: 525deb7a67fbd64726c89d5cc36a54b090111e31239431efeeb2bda9836828e0