aboutsummaryrefslogtreecommitdiff
path: root/src
Commit message (Collapse)AuthorAge
...
* | Increased precision of floating-point to decimal conversions when thedrh2023-02-23
| | | | | | | | | | | | floating point value has no fractional part. [forum:/forumpost/d1387c3979c7f557|Forum post d1387c3979c7f557] FossilOrigin-Name: 18de3a8e6b431a075143631eafdcf0e1b1a21868b417394c365d46d2feca10b5
* | Fix harmless compiler warnings and a code indentation error.drh2023-02-23
|/ | | FossilOrigin-Name: de6c5c6bb49a0beca793cdc0462da2c17bb05f3292e08dd815be29b45b59a8fb
* Provide -DHAVE_LOG2=0 and -DHAVE_LOG10=0 compile-time options for use on systemsdrh2023-02-23
| | | | | | that lack the log2() and log10() standard math library routines, to cause SQLite to substitute its own alternatives. FossilOrigin-Name: 7ee22f95e7a7d8650f961f20e304e56c7813e624f05655d7392ca9347748270f
* Enable the count-of-view optimization by default.drh2023-02-22
| | | | | Enhancement request [eaed8e36ce888f1e]. FossilOrigin-Name: a4aacdd323a854d771c8cb1e2e4cfc4fb66b0020cfed23525733603605f5c63b
* Avoid computing the values for unused result-set columns in subqueries.drh2023-02-22
|\ | | | | | | | | Performance optimization request [baa5bb76c35a124c]. FossilOrigin-Name: 7c2d3406000dc8ac5a99cc205b036356b67e4b0b94738592ffc5680749696904
| * Provide an optimization-disable mask for this optimization. Do not do thedrh2023-02-16
| | | | | | | | | | | | | | optimization if the subquery is an aggregate or is distinct, but allow it to be an ephemeral subquery. Do not omit columns that are used in the ORDER BY of the subquery. FossilOrigin-Name: 6b1a1f374d1372f11f5420d99645b218867100bf070bd3a8885bf5f00c189dff
| * Do not perform the omit-unused-subquery-columns optimizations on adrh2023-02-16
| | | | | | | | | | subquery that is DISTINCT, as that can lead to incorrect results. FossilOrigin-Name: cc148503db8ef180bce984328da7e84959afadd6a9613c2d03bc1eafeb95dfad
| * Fix the subquery result column NULL-ifier so that it correctly handlesdrh2023-02-15
| | | | | | | | | | subquery columns past the 63rd column. FossilOrigin-Name: 77b220a7240425fa83e142ceef78505208e6e38d797070e146b9f7d255f753c7
| * Do not compute result columns of subqueries that are never used. Make thosedrh2023-02-15
| | | | | | | | | | | | columns NULL instead. This optimization potentially resolves the enhancement request described by [/tktview/baa5bb76c35a124c|ticket baa5bb76c35a124c]. FossilOrigin-Name: 5dec3cc0225296a043d17f73126d477d90a604f82b3180628176d8f950adbce8
* | Remove the push-down optimization restriction that was added bydrh2023-02-22
| | | | | | | | | | | | | | | | check-in [1ad41840c5e0fa70] because it is no longer needed after the enhancements to compound query processing in check-in [27655c9353620aa5] This resolves the performance regression reported by [forum:/forumpost/bcc4375032|forum post bcc4375032]. FossilOrigin-Name: aa6bd6dff751223e302575c60f335707e4bb820bff716cab3706b564e18ed7ed
* | Yet another comment typo fix. No changes to working code.drh2023-02-21
| | | | | | FossilOrigin-Name: cdbdc8013fcfa8ce1bd4f5521c8d98afc53b9c577d43e5e6d0d1e15c789b910f
* | Fix a minor typo in a comment. No changes to working code.drh2023-02-21
| | | | | | FossilOrigin-Name: 7981671d1449b3fc6eb214deb558d91b87dc4fa6e38e24606625a146cc71664a
* | Fix formatting and improved documentation on the various sqlite3_file_control()drh2023-02-21
| | | | | | | | | | opcodes. Other minor documentation changes. No changes to working code. FossilOrigin-Name: 13280f720a4ef5a1f7f2a2fbe72f374d3a2e12be9bc0c50f7fce50d0cd28a67f
* | Fix an incorrect #ifdef in the CLI.drh2023-02-20
| | | | | | FossilOrigin-Name: 3c4d29cf227511bf218ef620d497dc72c708dcc819971b34c7629f3ed11803fb
* | Fix a harmless compiler warning.drh2023-02-19
| | | | | | FossilOrigin-Name: b2534d8de5051a3516f4b9ee5a4b99e1dcf455e9af88c60815d2c2a479fc8566
* | Fix stale requirement marks and fix a typo in the documentation fordrh2023-02-18
| | | | | | | | | | sqlite3_preupdate_hook(). FossilOrigin-Name: 655991f5d9afdd3281049eb430921046e0ba90eef215020c2fb149adc0d3c4c5
* | Fix a harmless UBSAN warning in debugging code of the new unhex() function.drh2023-02-18
| | | | | | FossilOrigin-Name: 315574d5cbe5c805ff2163052d986b054985984fb45bfb064d1a7b39a22b90eb
* | Do not allow the COUNTOFVIEW optimization to run if the count() containsdrh2023-02-17
|/ | | | | a FILTER clause. dbsqlfuzz 4f8e0de6e272bbbb3e1b41cb5aea31e0b47297e3 FossilOrigin-Name: 29fc06465efb948f98d2733bb25ffa1e0662a0189304006b3d0be9fec7dd28c5
* Ignore extra parentheses around a subquery on the RHS of an IN operator,drh2023-02-13
| | | | | because that is what PostgreSQL does. FossilOrigin-Name: ecdeef43b27412b0b0b09e09a62ad3a03836a3fc80f2070268090e7ca8f02712
* Do not allow WHERE clause terms to match constant string index terms, whichdrh2023-02-13
| | | | | | can happen if DQS_DDL is enabled. Follow-up to [44200596aa943963]. dbsqlfuzz 54c9db85ed4af7055f5fd0d50877875c82b11d46. FossilOrigin-Name: 2d2b91cc0f6fed8cb6f738dc7019047ce0f1e86b5eb8efa997095d08a32cbcb6
* Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index.dan2023-02-13
|\ | | | | FossilOrigin-Name: 18a99d9cfbc3a0419342b3fe91a83d2217578d0f6e8ee1084237d000946b1942
| * Allow vector-IN expressions like "(a, b) IN ( (?,?), (?,?) )" to use an index.dan2023-02-13
| | | | | | FossilOrigin-Name: 1815b15ddb8785a25b7617aab19e13c2410b9377389c16a85176025b3d9400e8
* | Fix compile time option SQLITE_DEFAULT_SYNCHRONOUS so that it works ↵dan2023-02-13
|/ | | | | consistently. FossilOrigin-Name: bf6f1ee77c4bf653f6cd2a3db5292b8c5c83f18ea9acf951107d22807546b28a
* In the LIKE optimization, do not analyze the new virtual WHERE clause termsdrh2023-02-13
| | | | | | | | until both have been added, since they are expected to be consecutive and the analysis might add complementary terms. This fixes a problem caused by [44200596aa943963] and discovered by dbsqlfuzz and recorded as case 7e3b5983727d843b910b2d9ab556e4afcd777cfb. FossilOrigin-Name: d35de3ad3fac6b30d3f266cbe4b1e9923eb31a1eff4a869205bbc3ba122eeec5
* Change a variable from 32 to 64-bits to avoid a harmless compiler warningdrh2023-02-11
| | | | | in Xcode. [forum:/forumpost/402d733c22|Forum post 402d733c22]. FossilOrigin-Name: 0216ce23cf23bc147c5de6de178a6689b7ad744bf0ee0098809938b5fe10708b
* Do a better job of detecting when a WHERE clause term might be useful todrh2023-02-10
| | | | | | an expression index. Fix for performance regression reported by [forum:/forumpost/e65800d8cb|forum thread e65800d8cb]. FossilOrigin-Name: 44200596aa943963bc6ca98b5d4fd5b9235d1109d8dfc1a75eeae353b4239142
* Ensure that the valueFromFunction() routine does not clear a priordrh2023-02-10
| | | | | parser error. dbsqlfuzz 6fa816f20cf5b62260d635d110b88f38e29d8fe1. FossilOrigin-Name: 734766451123c98a467c3407562eaa097b3307c8a275e1c8dd93e4654fe78014
* Squelch two harmless signedness comparison warnings in shell.c.in.stephan2023-02-09
| | | FossilOrigin-Name: bdd3edec13fa1142a8074c316e9ecec93fb278d42836eeb38587376fdf22cebd
* The "flexnum" affinity that was added by [44135d6ea84f7ba6] needs to alsodrh2023-02-09
| | | | | | be added to the output of the affinity() built-in function. dbsqlfuzz d309eaa5fe492c9606a8be876c2bc7dedb29d3d8 FossilOrigin-Name: f4ec68ceefa3a607f37d6355aac89fd1ae1704da4061bad7f271db1f17c1dd3a
* Back out the 'txn' enhancement to date/time functions. The duration of adrh2023-02-08
| | | | | | "transaction" is confused and needs to be straightened out prior to moving forward with this change. FossilOrigin-Name: 4a145f07322d768a07619bed27e0390d50f3a01d07787b9296234a5ceb6f1218
* Always use 64-bit integers for stats associated with STAT1 and STAT4.drh2023-02-08
| | | FossilOrigin-Name: 6647d1cb8b53102c8114b1f3e34173d907504d78aa3140eab53f88027a36660b
* Cause gcc warning suppression in shell.c to be nice in other project(s).larrybr2023-02-08
| | | FossilOrigin-Name: 6b41ba2e996ab7b9c3943ab93a19748db5cf37792f5d59d20eec301085282355
* Update an assert() in the stat4 code that is only true for a well-formed ↵dan2023-02-08
| | | | | database. FossilOrigin-Name: 04439f3b23b22a3c187637f286764568ee922227e3e34b2e63075876b4d1f2ac
* Fix an incorrect assert() in STAT4 logic added just a few days ago ondrh2023-02-08
| | | | | [2023-02-01|/info/55a26c67ed4a3a93]. FossilOrigin-Name: 168fa2fb22b8c1ad80c7001a429d3a80b48acfbfebb5414a0caa76964ea647c3
* Add the 'txn' date/time format. Change CURRENT_TIMESTAMP and similar to usedrh2023-02-08
|\ | | | | | | | | 'tnx'-style semantics instead of 'now'-style. FossilOrigin-Name: 61cc8ed8d3541eddf23a9d542179c3f0223c5b8519b54d3be79988a376e25a89
| * Revert the behavior of date/time functions with no arguments so that theydrh2023-02-08
| | | | | | | | | | | | once again work like 'now', even while CURRENT_TIMESTAMP and similar work like 'txn'. FossilOrigin-Name: 06180caff0f5d8aba83b9f7be682ccdd6cb2ffc228b557ee6c1fd00fe5c23e92
| * Change the behavior of date-time functions without any arguments (and thusdrh2023-02-08
| | | | | | | | | | | | | | the CURRENT_TIME, CURRENT_DATE, and CURRENT_TIMESTAMP variables) so that they work like 'txn' instead of like 'now'. This is an incompatibility with legacy, but brings SQLite into conformance with all other SQL systems. FossilOrigin-Name: 1ac78be54502779236645eac35b962797f2fb98307d059d2aa19658c4fa74cb7
| * Simplify the code and add test cases.drh2023-02-07
| | | | | | FossilOrigin-Name: d3bed4caff561e71c396cc869c5b4d9bf216ba203485e738c12ec62741f1aba5
| * Add support for the 'txn' argument to date/time functions that works likedrh2023-02-07
| | | | | | | | | | 'now' but keeps the same time for the entire transaction. FossilOrigin-Name: 5e4f45af96247e29910403a63ac148cb313b005f9c014b37a9a49d98f5fef9a6
* | Merge wasi-patches branch into trunk.stephan2023-02-08
|\ \ | |/ |/| FossilOrigin-Name: 9902e66a37d59c1909593bbc296091df3fa3bfa12ec7062bd84e458030f77c8d
| * Merge trunk into wasi-patches branch.stephan2023-02-06
| |\ | | | | | | FossilOrigin-Name: 656d36f50f630da68262469087bad1ac71b10325e233a7963103c8cbc232f61a
| * \ Merge trunk into wasi-patches branch.stephan2023-01-27
| |\ \ | | | | | | | | FossilOrigin-Name: 2ce89f5efcdb8b4c58eb2d30833a76d79ae0134c31d5ab8564be9e1cf5a1f4f0
| * \ \ Merge trunk into wasi-patches branch.stephan2023-01-21
| |\ \ \ | | | | | | | | | | FossilOrigin-Name: 6fc20d75d49310aedbc3351a4a5f1aa9ef5b4100501c7bfbe556aca2be2e44d7
| * \ \ \ Merge trunk into wasi-patches branch and add missing yes/no result to the ↵stephan2023-01-11
| |\ \ \ \ | | | | | | | | | | | | | | | | | | | | | | | | configure script's output for the --with-wasi-sdk=PATH test. FossilOrigin-Name: adc0ede0a43241b85563408d0de8e640a75ec4f7bdfe5e48acc5cdd6b182b88c
| * \ \ \ \ Merge trunk into wasi-patches branch.stephan2022-12-24
| |\ \ \ \ \ | | | | | | | | | | | | | | FossilOrigin-Name: 52f40ab12e437c59af2b91c7ac105ab7784db57fc8d9ab7a1356f17092681f43
| * \ \ \ \ \ Merge trunk into wasi-patches branch.stephan2022-12-10
| |\ \ \ \ \ \ | | | | | | | | | | | | | | | | FossilOrigin-Name: 13dade955d46020ab408734123261e9fadb8bccbaf67003b111112af4789d8c0
| * \ \ \ \ \ \ Merge trunk into wasi-patches branch.stephan2022-11-30
| |\ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 64cf34a85505814b4c93e82855c25559c8096bb3ce38cdc5e0fb9218c6bcce32
| * \ \ \ \ \ \ \ Merge trunk into wasi-patches branch to clean up the diff view.stephan2022-11-21
| |\ \ \ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 95de6742d3d96d2b21eec57195dc7a2236d3f61640633ae1baa36bf142a3485b
| * | | | | | | | | Remove check for WASM_WASI macro when detecting wasi compilation mode, as ↵stephan2022-11-20
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | that macro is project-specific. Rely only on __wasi__ (exposed by clang) to detect wasi compilation mode. FossilOrigin-Name: d469ac0c448eced26a697751ce9be316e8bc3cd029fda2b50966523c7850854f
| * | | | | | | | | Elide a wasi-incompatible shell.c block in SQLITE_WASI builds.stephan2022-11-19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | FossilOrigin-Name: 9b8b15a779158ec7c39d936f6bfa6a35e12063a36933341ade051809993a5678
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-21 18:12:32 +0000