bahman/sqlite
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
29,306 Commits 1,672 Branches 385 Tags
commit-and-continue
Commit Graph

29306 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
2400eaa08c Bring all the latest trunk fixes and enhancements into the commit-and-continue branch. 
FossilOrigin-Name: 19e47df37a1ab76625de4a9643e78d2ab8d1241c9fb58ca2f9e3708622050d10
 2024-12-09 21:01:19 +00:00
drh
e57527c14f Make the TCL interface more rebust against very large strings coming 
out of TCL9.

FossilOrigin-Name: e2bae4143afd07de1ae55a6d2606a3b541a5b94568aa41f6a96e5d1245471653
 2024-12-09 20:46:36 +00:00
drh
e85e33d39c Enhance the ".import" command of the CLI so that it is able to insert into a 
view that has an instead-of trigger.
[forum:/info/3e03c73150f8b9f8|Forum post 3e03c73150f8b9f8].

FossilOrigin-Name: 7dcc3731a9057a91f1b173fbab2841d8a666a945d9bc61d4c20f8a2a279d5ff1
 2024-12-09 20:37:18 +00:00
drh
cb591953e4 Enhance the ".import" command of the CLI so that it is able to insert into a 
view that has an instead-of trigger.
[forum:/info/3e03c73150f8b9f8|Forum post 3e03c73150f8b9f8].

FossilOrigin-Name: c71acee1cf45abf0429e8b1668315c75b155d7c300d53833aeacd92c9bb3395d
 2024-12-09 20:36:14 +00:00
drh
c29bc733be Add NEVER() around branches that seems to have been made obsolete by 
[a350ea7c6b89725b].

FossilOrigin-Name: cb5bad5c748b7435c43f3ec051736c1cf91ced2be317b0519e5e22523c137290
 2024-12-09 13:02:13 +00:00
drh
54f96dc50e Further improvements to the decimal-to-float conversion for values close 
to LARGEST_UINT64.

FossilOrigin-Name: 453c949914770e8f7b9b9dd882db492bf8756c212c816f87bb2e3ed98bcd64e3
 2024-12-09 11:47:28 +00:00
dan
94ad4abc65 Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum [forum:5c8a069d23|thread 5c8a069d23]. 
FossilOrigin-Name: a350ea7c6b89725ba1a0058c77fc8e918f5cb78e868d100f5425cdee114d1320
 2024-12-09 11:37:37 +00:00
dan
4f5ae3fc4e Fix an obscure problem with multiple outer joins, ON clauses and query flattening. Forum [forum:5c8a069d23|thread 5c8a069d23]. 
FossilOrigin-Name: 289daf6cee39625e8f068179cd58efcc1d28242f46064e58ec4175a019cf48ad
 2024-12-09 11:12:12 +00:00
drh
a42db7ff40 Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing. 
FossilOrigin-Name: a0a36bad454fab55ff39cbada68bf9ec6494d48dc4fc88496c0f637ab100734c
 2024-12-09 10:57:01 +00:00
drh
fd360c3943 Resynchronize autoconf/Makefile.msc 
FossilOrigin-Name: 8f9c640818871c451e69f186224bf276f8a03c8d31a76806d81f34922a169f82
 2024-12-09 10:52:28 +00:00
stephan
29d1d91502 Add a note in Makefile.msc about EXTRA_SRC files possibly requiring manual editing, as discussed in [forum:903f721f3e7c0d25|forum thread 903f721f3e7c0d25]. 
FossilOrigin-Name: 229c2f013c171bc220148c78f7db5396578f2c6aac28ad6ff9b687c9fa4998ac
 2024-12-08 18:38:40 +00:00
drh
9f53d0c817 Yet another iteration of the solution to the floating-point conversion 
problem - this what avoids complaints about oversize double values
from -fsanitize.

FossilOrigin-Name: fc6904a508eb732b1cb5cc12321a0d637d97e1e066a022a2c93cb50595f3a86a
 2024-12-07 19:57:30 +00:00
drh
8703642803 A cleaner and more robust solution to the floating-point conversion problem 
originally fixed by [81342fa6dd03fffb].

FossilOrigin-Name: 351de57f80b73045448c71d3402d877ff5d72418b1f5fc34c8147a04f7c5cb78
 2024-12-07 19:06:25 +00:00
drh
92d252e06d Fix more harmless compiler warnings. 
FossilOrigin-Name: f5b8fd77635e5e6d2d88a1ce74e1bd6c4311260a2b695e5055b898b880bf5718
 2024-12-07 17:08:13 +00:00
drh
4597870108 Fix harmless compiler warning caused by the previous check-in. 
FossilOrigin-Name: 462700aeb7c183d739ead4d726ce5384b3297bcf7929abd010987fa3a5f64807
 2024-12-07 16:53:42 +00:00
drh
1a4b2117f1 On x64 hardware, round-trip uint64_t→double→uint64_t conversions 
fail for values greater than UINT64_MAX-2047.  This caused the SQLite
text-to-float converter routine to give incorrect results for values
between '1.8446744073709550592eNNN' and '1.8446744073709551609eNNN' for any
exponent NNN.  This problem was introduced by check-in [761d8fd18b0ee868]
and first appeared in version 3.47.0 and was reported by
[forum:/forumpost/569a7209179a7f5e|forum post 569a7209179a7f5e].  Fixed
by this check-in.

FossilOrigin-Name: 81342fa6dd03fffbe7d4d699ff049dcef4d30344578bb6f91cb58a4e5a4f6036
 2024-12-07 14:48:55 +00:00
drh
ef636cc3cd Add the SQLITE_PREPARE_DONT_LOG option for sqlite3_prepare_v3(), that prevents 
errors in the compilation of the SQL from being sent to sqlite3_log().

FossilOrigin-Name: 870403425493866232cf9e8fa62288861b7d0a4091b15d75727f8bb31da46f94
 2024-12-06 18:35:16 +00:00
stephan
c40329c9bf Minor doc update in auto.def. No functional changes. 
FossilOrigin-Name: d324be296de443bd2853c732b10960178bf3ba9f18c80c509f6b41e2cfb2f3af
 2024-12-06 00:12:43 +00:00
stephan
0448e00aaf Ensure that the post-config checks for @UNEXPANDED_VARS@ pass even if --disable-tcl is used, as reported in [forum:74ef8059fc|forum post 74ef8059fc]. 
FossilOrigin-Name: a38606bf44a1b5d0f684f67174c33f8c88c7927e23fc6a715e8d3ae7a6614bbd
 2024-12-06 00:09:05 +00:00
drh
eed134c4d3 Fix the build of sqlite3_analyzer.exe on Windows that was broken by 
check-in [80f3bf8c2ee31ba1].

FossilOrigin-Name: 223f47b2db8d80629d60a642942eb8b288611e3e466cf904964285229a5809fc
 2024-12-05 23:53:16 +00:00
stephan
76412af157 Minor doc correction in ext/misc/shathree.c, as reported in the forum. No functional changes. 
FossilOrigin-Name: 3b82d2c6b732617b9be205efadd07326057c93b71c47ffd42de63fc05093667b
 2024-12-04 16:01:25 +00:00
drh
33c120f9b7 Improve the output from the ".testctrl opt" command in the CLI. 
FossilOrigin-Name: de7064d118c33aab0fff39d072593b287c291870b843d093045300bde464420f
 2024-12-02 19:55:39 +00:00
dan
4b491d8565 Ensure that the query flattener does not change an ON clause term to a WHERE clause term. 
FossilOrigin-Name: bdd408a2557ff05c9ea962a94b442f7c078d8e1ec27035aa95bc23d4d2bd5606
 2024-12-02 17:21:52 +00:00
drh
c9ac238b92 Fix a comment typo on the sqlite3ExprIsSingleTableConstraint() routine. 
FossilOrigin-Name: 346a845bf1cd1c7e542f7bf763d86c197d9a3b4f3ea38ade416790a1cf80e6f2
 2024-12-02 16:24:47 +00:00
drh
bfdeb1f6d5 Fix a harmless typo in debugging output. 
FossilOrigin-Name: 578f76cfb2e298fe6bfd278b545091fe682d01feb0be56ef57b6c9f2c179ac61
 2024-12-02 16:07:38 +00:00
stephan
ed7fe45c7c Reformulate [9e09d5d6] so that memsys5 shows up in the late-config summary as being enabled and does the right thing if both --debug and --memsys3 are used. 
FossilOrigin-Name: 447db1cd0a6575432996e9735e78bbb09c83827c5e3080339b34df176ab86af0
 2024-12-02 14:14:30 +00:00
drh
3e1f302dbe Enable MEMSYS5 with the --dev configure option. 
FossilOrigin-Name: 9e09d5d60ac91423e1dec1169e9eb60a531f84261b48490c550cf4529540e6dc
 2024-12-02 13:47:53 +00:00
drh
224e356081 Slighly less confusing output from treeview during debugging. 
FossilOrigin-Name: 7aef0b93050cdb79cae68361e84047cea2e8e7251d0581ce917da03352bb1f16
 2024-12-02 13:29:29 +00:00
stephan
d004268b27 Trim a bit more from the sqlite370.svg border to get it closer in scaled size to the logo currently on the docsrc site. 
FossilOrigin-Name: 81c7277fc59af833365f0ee5af603db49c19a6ba87bd5f252ecdfe72df252d4e
 2024-12-01 15:23:40 +00:00
stephan
fd66549cb6 Correct the fill color for the background of sqlite370.svg - it was slightly darker than it should have been. 
FossilOrigin-Name: 732132407b3881aaa7fee151baafb6569664f1d2b82ef7743d89bd0a86cf0a09
 2024-12-01 14:20:19 +00:00
stephan
a13a645cdf Re-export sqlite370.svg to retain the gradient part and clip the size using the cutting guides in sqlite370.eps. 
FossilOrigin-Name: 12017b01c8e6c12fdd8de3c3c325e56b5be80343a1a392538b6e6ed066e46cee
 2024-12-01 14:14:50 +00:00
stephan
9bc351b3c7 Export a clipped copy of sqlite370.eps as sqlite370.svg, based on discussion in [forum:1bbd6d17ca|forum post 1bbd6d17ca]. 
FossilOrigin-Name: dd3a13c1209d0bac3d6eb105826429ef29b36682c347995dc266bf42e46a2193
 2024-12-01 14:02:19 +00:00
stephan
d6d9c54bb2 At the end of the configure script ensure that none of the files which are filtered for @VARS@ contain any unresolved @VAR@ placeholders, failing fatally if any do. 
FossilOrigin-Name: 301df5c2beb08e8e2944f7a9e46a10114603518385c05a9c30a838ab436369d4
 2024-11-30 17:48:31 +00:00
drh
c5b9da34f2 In sqlite_dbpage, cancel any pending truncate operation if there an error 
occurs later in the transaction.

FossilOrigin-Name: 1abab10f85a4dba5ffe51a30eeef30853c120e5566ed97b3af1526fff597c647
 2024-11-30 14:13:35 +00:00
drh
03e306b3a1 A NEVER() that was added by [eb5ac9e5b9a4f9c8] is violated by the ifnull() 
in-line function.  This check-in fixes that problem.

FossilOrigin-Name: 2220ccf4d6fea2413015c72fd318003b4b5afeae7cb7586b714fce36212d8c49
 2024-11-30 12:00:38 +00:00
drh
5c208f36a4 Fix a NEVER() in the iif() logic that can be true if compiled with 
SQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONS.  Problem introduced by [eb5ac9e5b9a4f9c8].

FossilOrigin-Name: 3ec2df5a6c731b59b0ab132ee59c74d107f9c4bd32cf47d9776887858b9c0dea
 2024-11-29 11:49:05 +00:00
stephan
2aac896611 Remove some outdated docs from Makefile.in. 
FossilOrigin-Name: cc2c5fc98b2d1957bd26f41f0b646921ecabe2ffe544b3c3565965ba8850b2ff
 2024-11-28 23:55:35 +00:00
stephan
25e042c0b0 Typo fixes and cleanups in autosetup/README.md. 
FossilOrigin-Name: 7f366565f41fa4eb532cfaf83074106e235436bfc377116e3bf823ac08fd01a5
 2024-11-28 20:46:51 +00:00
stephan
187c115a69 Configure script doc updates and cleanups. Skip check for EMSDK when doing an out-of-tree build, as ext/wasm does not support that build mode. 
FossilOrigin-Name: 9d2f4148db1641e9bf2989c2b1adf5b9dcb2b123526ecacd063bca208b3c36cf
 2024-11-28 16:14:19 +00:00
stephan
fed5234fb3 ext/icu/README.txt: clean up EOL whitespace and add a mention of the --with-icu-... configure flags available as of version 3.48. 
FossilOrigin-Name: 4976ac717bec2f2c89d94ac1d9b96afd1da573ba34e3c78637c3937287635e72
 2024-11-28 15:52:21 +00:00
drh
e8233f14bd Improvements to sqlite3ExprImpliesExpr() so that it recognizes that expressions like "iif(X,Y)" and "CASE WHEN X THEN Y END" imply X. 
FossilOrigin-Name: eb5ac9e5b9a4f9c85a2203107697da14c07c1667037dff672f9d786cea964a37
 2024-11-28 11:52:18 +00:00
drh
dc7b94e63f Simplification to the fix in the prior check-in. 
FossilOrigin-Name: f79cb748c9447ca4d2184a24219feb19571eb79870e0bedf14704743a3d5f8b9
 2024-11-28 02:09:27 +00:00
drh
3ff6aa6e39 The sqlite3ExprCompare() routine should always compare the same variables 
as equal to one another, regardless of whether or not QPSG is set.

FossilOrigin-Name: df95d5209a77c0302e08ea7b1f248646fb2a062ba5beca898678aee0a1d03a3a
 2024-11-28 01:47:44 +00:00
drh
bfb7f77a8c Add two NEVER() conditions. 
FossilOrigin-Name: 4f358ad20dc8a45e7aaa1a1996b40abd39caf34be6556ed54e1e0c80572b7ac0
 2024-11-28 00:58:37 +00:00
drh
60ad526639 Enhancements to sqlite3ExprImpliesExpr() so that it realizes that 
"iif(A,B)" implies "A".

FossilOrigin-Name: d96ecbee59b50eca25447456dfff2c168e8eade7a68e542932d5829f97debb31
 2024-11-28 00:34:20 +00:00
dan
0bce1d6c9f Fix an inaccuracy in the documentation in fts5.h. 
FossilOrigin-Name: ec3ca6f17972a9624018ae352e5a4be8dc34602a4569c80e827e09cd7fbed7f7
 2024-11-27 18:01:25 +00:00
drh
49e053f873 Use the P5 rather than the P3 parameter of OP_AutoCommit to avoid an 
unnecessary conflict in the begin-concurrent branch.  Fix some comments.

FossilOrigin-Name: e6f63526189bdd081af4f3de81ef2ba5e78dd2e722f9796eff9662bfd125a8c8
 2024-11-27 14:41:08 +00:00
drh
4bab0fdb37 Merge the latest trunk enhancements into the commit-and-continue branch. 
FossilOrigin-Name: adaddf49485d5c1bf71e4a1aa116eaebd77fef88f5a0061d441c13e3e58c330f
 2024-11-27 14:16:34 +00:00
drh
cf04895832 Allow the iif() function to work with two arguments. The third argument is 
then assumed to be NULL.  Also allow if() as an alternative spelling for iif().

FossilOrigin-Name: 1e405c39a8405e2081ce061559d1aacc70055fc74ab86d886b973076a3fb124b
 2024-11-26 23:40:54 +00:00
drh
966a158831 New test cases. 
FossilOrigin-Name: f1cb1a815a09d71eb52d5c7f2f4e5c7689535232dee365e46ac41cce7fd86c01
 2024-11-26 23:30:49 +00:00