aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
* Automatically disable directory fsync when compiling for AIX.drh2024-08-18
| | | FossilOrigin-Name: 8d170e07e20c21a5bb97fdc8c2d01d92178f5fe740e60d203e4621747cfce33e
* Fix a typo in an "ifdef" that broke SQLITE_OMIT_ANALYZE builds.dan2024-08-17
| | | FossilOrigin-Name: c09da26cb6f772a18c595ff0eb55d8345a377c3ef5ed02a5e539ffdbe9d07f85
* If a subquery has an ORDER BY clause and that ordering is helpfile indrh2024-08-16
|\ | | | | | | | | | | | | satisfying the ORDER BY or GROUP BY of the outer query without doing an extra sort, then omit or reduce the sort in the outer query. Call this the "order-by-subquery optimization". FossilOrigin-Name: 7a0cdc7edb704a88a77b748cd28f6e00c49849cc2c1af838b95b34232ecc21f9
| * Fix handling of COLLATE. Add test cases for the same. Code cleanup fordrh2024-08-16
| | | | | | | | | | improved understandability and maintainability. FossilOrigin-Name: 41a41c173a9d15d94f23d73a5c04bfb1616cb9223bc81d41808f9b4d00817fbf
| * Bug fix in the subquery ORDER BY propagator.drh2024-08-16
| | | | | | FossilOrigin-Name: 5a9a3b8af7ac0aa1c04ad2d735e341c92d67952acb9a1d30217c0471e92cd468
| * Improvements to the subquery ORDER BY decision algorithm. Fewer false-negatives.drh2024-08-16
| | | | | | FossilOrigin-Name: b82421e3f5811946e9d60b845fc882b6ea5c53c648695654c6900754427bf9bf
| * If a subquery is materialized due to an ORDER BY and that ordering is usefuldrh2024-08-15
| | | | | | | | | | | | in helping to satisfy the ORDER BY or GROUP BY in the order query without doing an extra sort, then omit the extra sort. FossilOrigin-Name: 2fbb4dc2327ee435cb2b7a4adcddf5a9cee6dff7de96e2ecb761166427b5ddea
* | Ensure that memory allocations in ANALYZE are always 8-byte aligned in orderdrh2024-08-16
|/ | | | | to satisfy a new assert() added by [539e4f661767ef90]. FossilOrigin-Name: a1915cbdeccac2ed49fb8a9733abf2c6239396e3174fed2ff275f66b606c48b6
* Fix harmless compiler warning related to the TCL8-to-TCL9 transition. Thisdrh2024-08-10
| | | | | change in testing code only and is not relevante to the core SQLite. FossilOrigin-Name: c86ef65545485eae6aca23b4582e8115d4edfdd6084afa77858e11b21aa270f6
* Fix behavior change in the offset() SQL function introduced by drh2024-08-10
| | | | | check-in [f0b671183f44d0ae]. FossilOrigin-Name: c2ac17f183082d6388336338b8d5c0b334095e5f77a27bc08419431f37471d22
* Enhancements to covering-index prediction. In particular, avoid thedrh2024-08-10
|\ | | | | | | | | | | | | | | | | false-positive prediction described by [forum:/forumpost/e60e4c295d22f8ce|forum post e60e4c295d22f8ce]. Add early detection of over-prediction of covering-indexes so that sqlite3_prepare() will return an error rather than just generate bad bytecode. FossilOrigin-Name: f0b671183f44d0ae294956e7651a1653f47bd6219f9636872d15993f30f28dfb
| * Import the second ALTER TABLE fix from trunk.drh2024-08-09
| |\ | | | | | | FossilOrigin-Name: 1de3e5883613ff6093203720f3cdcf6b3a3e626c99735284fae95a438e1ce24f
| * \ Merge the error code fix from trunk.drh2024-08-09
| |\ \ | | | | | | | | FossilOrigin-Name: 81dfb8cd5d59ecf974018b03175ddabd11366d2aca0211dc982f7e14ff314d4d
| * | | Do not attempt to use a covering index based purely on columns-useddrh2024-08-09
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | when doing an UPDATE or DELETE of a WITHOUT ROWID table. Raise an SQLITE_INTERNAL error if there is ever a situation where a table reference cannot be converted into an index reference when the query planner thinks that a covering index is appropriate. FossilOrigin-Name: fae39ae9320c0f4fcc2e3b3baf0a4170ba2b9a04634a0a1fa41dd4918a74b106
* | | | Fix a few minor TCL9 compatibilities issues.drh2024-08-09
| |_|/ |/| | | | | FossilOrigin-Name: 69eed19914ef52bc0101f4ae1c7b242df4ee28675b3581e1f4d60a35494f9f76
* | | Fix another instance where ALTER TABLE was returning SQLITE_INTERNAL insteaddrh2024-08-09
| |/ |/| | | | | | | of SQLITE_ERROR one malformed input. FossilOrigin-Name: b416756320dfb46ad72b843a7fbf18807d3fd1966251c320de626280b5238a5c
* | Fix the internal routine sqlite3ResolveExprListNames() so that it returnsdrh2024-08-09
|/ | | | | | | SQLITE_OK or SQLITE_ERROR instead of WRC_Continue or WRC_Abort. Without this fix, some times of obscure syntax errors end up returning SQLITE_INTERNAL rather than SQLITE_ERROR. FossilOrigin-Name: 9052187efd1f78abd9b285ac94269a3ba4d65b6aa74c9fa34002ee0628c83919
* Do not let the number of terms on a VALUES clause be limited bydrh2024-08-08
| | | | | | | SQLITE_LIMIT_COMPOUND_SELECT, even if the VALUES clause contains elements that appear to be variables due to the use of double-quoted string literals. [https://issues.chromium.org/issues/358174302|Chromium issue 358174302]. FossilOrigin-Name: 670beb133eb203065a75022f0c6db7c605a4e0e22c8ef6d6b4724be2663ff3dc
* Back out the --memory option to ".parameter init" in the CLI, as thedrh2024-08-08
| | | | | | | capability is no longer needed for testing due to the new "$int_N" and "$text_T" automatic bindings, and the "init --memory" is hence just added complication. FossilOrigin-Name: 3b1b0c141993eb0f8749f54ea40d6014f9bdccbe0fdb3ccccad971a0baea8d3c
* In the CLI, recognize magic parameter names "$int_NNN" and "$text_TTT" anddrh2024-08-08
| | | | | | bind them with integer value NNN and text value TTT respectively. Intended for testing and debugging use only. FossilOrigin-Name: a929cdb00ff74d77cdf55087d32abf53578f7127b36276f89b64ccbef1d4a9a4
* Add the --memory option to the ".parameter init" CLI command. When present,drh2024-08-08
| | | | | | | | the --memory option causes the sqlite_parameters table to be created in a completely independent :memory: database. This can be done to avoid parameter binding queries from being affected by debug settings such as ".wheretrace", ".treetrace", "PRAGMA vdbe_addoptrace=on", and similar. FossilOrigin-Name: 4e69dce2093b75b7db4fbdca4953b664b907be15d991ed352ea1d87c64fbf9d2
* Add a new assert() to help static analyzers understand that a pointer isdrh2024-08-07
| | | | | never NULL. FossilOrigin-Name: 433f2b942ee6f79d50ebe9b08fa3ea8162db6a10ce9d80e2bc193124baa1b083
* Fix a harmless compiler warning in an assert().drh2024-08-07
| | | FossilOrigin-Name: 5e4c9a74b2efa74ace67f644fb6bb37e07f5982f8faaca9463e3daa50b0469d7
* Change the AggInfoColumnReg() and AggInfoFuncReg() macros fordrh2024-08-06
| | | | | | compilers that cannot parse empty elements of a comma expression. [forum:/forumpost/8fd21998dc|Forum post 8fd21998dc]. FossilOrigin-Name: 533a6251f188805363f0e39613ea03b1bfd758eaea00e0855803238585bdfec7
* Fix to the previous checkin: The colUsed parameter should have high-order bitdrh2024-08-03
| | | | | | | set if any of the 64-th or greater columns of the virtual table is used. The lower 63 bits of colUsed always show the usage of the first 63 columns of the virtual table. FossilOrigin-Name: 90ac8457750ace1d76d7bc957af7877e86e6301bb07361e19beaf5c7b3b6085a
* Ensure that the sqlite3_index_info.colUsed mask always includes the PK ↵drh2024-08-03
|\ | | | | | | | | fields of WITHOUT ROWID virtual tables. FossilOrigin-Name: ff4ac279b02190cc2107b0b110806dd7abcea47a6589d827b5ee39d4b80fb719
| * Ensure the sqlite3_index_info.colUsed mask always includes the PK fields of ↵dan2024-08-03
| | | | | | | | | | WITHOUT ROWID vtabs in cases where they may be used. FossilOrigin-Name: c327c0c02cfefdba373cfb15933a9cdfddb578b6582f2ce7c08929203743ffe9
* | Fix a typo in [c327c0c0] preventing the shell tool from running ".dump" ↵dan2024-08-03
|/ | | | | scripts that feature virtual tables. FossilOrigin-Name: 10e97abb878debb67410902ea1af4df75a9ced1e38fec710b1796c5143aff48e
* Make sure the input buffer is big enough for an memcpy() when doing thedrh2024-08-02
| | | | | restore autodetection in the shell. FossilOrigin-Name: 1637d29d518b3b4534a1b4c0dc0eddcb770f6f71763e4177812a3e79b97d2365
* Simplification the ./configure script. Carry Makefile CFLAGS and OPTS throughdrh2024-08-01
| | | | | | into builttclext.tcl. Fix a bug in tclsqlite.c introduced by the previous check-in. FossilOrigin-Name: 72a80aa0abb121a23f8cc1eb1af04ba06c733a7a40c06f1fe9e62f2a0a26ca6e
* Add the tclextension-list makefile target. The the makefile running on Mac.drh2024-08-01
| | | FossilOrigin-Name: 2f667cc8e54167342e17e63e1a017388365ebf4cd379f9c16c12e4603b34a326
* Make the #include section of tclsqlite.c the same as tclsqlite.h.drh2024-07-31
| | | FossilOrigin-Name: 2afadbeb124d6d7bb81d473379269014ebd8601f98f231e2218f54350a2e5fd3
* Use `<tcl.h>` instead of `"tcl.h"` to include the TCL interface.drh2024-07-31
| | | FossilOrigin-Name: 4e32d4aed7c487ee9ed39a7e4486c2989a01781a3edbe9cdce52c6ed357f6366
* More tweaks to testfixture-implemented TCL commands to make them safe for Tcl9.drh2024-07-31
| | | FossilOrigin-Name: 67897ca97d8c98e119a498a3adb39548a579e12ee477e9dd74e9564a6f5e4c2b
* Fixes to testfixture routines needed to test snapshots.drh2024-07-31
| | | FossilOrigin-Name: 66f61c3b35383b2575774d309043a722cc87a53d03518d339d6dbdcf342adc93
* Remove obsolete testfixture TCL commands formerly required by Windowsdrh2024-07-31
| | | | | but now handled by Tcl itself. Update tests case accordingly. FossilOrigin-Name: 4f065fb638b24b33283518af8ad55f28a49cfac4086fa5e4568e2f3a6814962d
* Minor adjustments to get Tcl9-based testing working on Macs.drh2024-07-31
| | | FossilOrigin-Name: 066c8672ee85a6ce972de38fcd3793fc2c1ef4f21c3de2379746d0ff18df8dc0
* Fixes to tclsqlite.c to facilitate TEA installs.drh2024-07-31
| | | FossilOrigin-Name: 7157c3c910565c9385a028793a0c0106c5064ab6a8a6efbe29dd1f1cdb2bd48d
* Implement a new comparison routine to compare text renderings ofdrh2024-07-31
| | | | | | floating point values. This gets the number of failures down to just 5. But the routine needs work, and probably refactoring. FossilOrigin-Name: 71f2ee5db01150707401804b136641170e7ed44760fccec20de19184e4d0a840
* More adjustments to the incrblob channel: Apparently you need to waitdrh2024-07-30
| | | | | | until the close2Proc is called with a flag of 0 before actually shutting down the channel. FossilOrigin-Name: fa549a5507b5f805b469b4360c11155aa9d22043f01f6d9428bf44d0f2351eb0
* Tcl_ChannelType implementations for Tcl9 apparently require thatdrh2024-07-30
| | | | | | | wideSeekProc be implemented. Also adjust minor test script issues for fts5 tests so that they can be run sequentially and so that they do not depend on the specific floating point output formats generated by Tcl. FossilOrigin-Name: 19fda979c5dc1a385ed3f8ab8df34388c1acfc7ff951fe1b183a79186bd20cdb
* Fix the incrblob channel so that partial close works with Tcl9.drh2024-07-30
| | | FossilOrigin-Name: d54ec2de78c2aed12be643e59a30b6827fe4728a0ab6504dd64ee9116e5f885a
* First attempt at getting the build to work with Tcl 9.0.drh2024-07-30
| | | FossilOrigin-Name: 6e5bb48a74d63fb8c30528f0005d1763cd2dbb882abf86baf1565721e6bfcf84
* Fix documentation typo. drh2024-07-27
| | | | | [forum:/forumpost/993cb82402|Forum post 993cb82402] FossilOrigin-Name: 86de4e755e37dc1cbcbd59018927aa87ff49fc15f706a36187631d8f14075c12
* Add the percentile extension to the CLI by default.drh2024-07-24
| | | FossilOrigin-Name: bcc31846964102385d5a21eb5e85d7db153b155e76b4e2847c9453d3d0e1af04
* Fixes to TreeView debugging output for VALUES clauses.drh2024-07-21
| | | FossilOrigin-Name: b6aed8bcb06edc7f0221fd707d5adc227856fe62dbcaae5ffe1fb4faa5c542e1
* Improved debugging output when using PRAGMA vdbe_addoptrace:drh2024-07-21
| | | | | Show the range of opcodes being checked for Column-to-Copy conversion. FossilOrigin-Name: 2c122026db979a099a3d1a14ae1e01a0a64a559905ea414b2d80ed7dc3e04846
* Fix an oversized allocation in sqlite3ExprCodeIN().dan2024-07-20
| | | FossilOrigin-Name: d7be326a80e7b3aa8fd6e5e059c04e6ad3feaffcb20b1e3c251d7195ddc1be8b
* Add extra assert() statements to the fixes on this branch.dan2024-07-17
| | | FossilOrigin-Name: 81b6360050eea95e4367de1b41b5864a640b4d1c5c8fc3bea3b96ed770cb0325
* Fixes for platforms with 32-bit pointers that require 64-bit values to be ↵dan2024-07-13
| | | | | aligned. FossilOrigin-Name: 2212d7488ed4ec2839ffa45cb9567056b36519434834634e4ecc441c330694d7