database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
18,634 Commits 1,785 Branches 392 Tags
sqlite3_value_nochange
Commit Graph

12844 Commits

Author SHA1 Message Date
drh
41fb367a2c Improved comments. Slightly tighter implementation, but no big changes. 
FossilOrigin-Name: a1b3f28569f2a8d82b2931527fdfe191b421f3e1ea18ee30e04211e1ad645993
 2018-01-12 23:18:38 +00:00
drh
ce2fbd1b02 Add the experimental sqlite3_value_nochange() interface usable by xUpdate 
methods of virtual tables to see if a column has actually changed values.

FossilOrigin-Name: 8b7be15ece9e2e83959bb0e21e240106fe1077431242c3cc6b81f1baa2382f40
 2018-01-12 21:00:14 +00:00
drh
4ec6f3a075 Simplification to the implementation of OP_Insert. 
FossilOrigin-Name: 6acbdba59e9df4313a6232d925a70390acdc43dfa380b4fba7bb8bd442d6e728
 2018-01-12 19:33:18 +00:00
drh
84ebe2b303 Avoid an unnecessary branch when not using pre-update hooks. 
FossilOrigin-Name: ec96707eb359c7e0597ee22e5ae017774366463dffa6bdb06e4438b09549f5c0
 2018-01-12 18:46:52 +00:00
dan
614efe2b4b Experimental change to include changes made to the sqlite_stat1 table in 
changesets generated by the sessions module. sqlite_stat1 entries in such
changesets are ignored by legacy clients.

FossilOrigin-Name: bd46c4429693545eb16db85692fc591ac529796aa746f5f21df1ce4380619320
 2018-01-12 16:44:29 +00:00
drh
6f390beb7f Add the sqlite3_vtab_nochange() method which virtual table implementations 
can use to optimize UPDATEs.

FossilOrigin-Name: d444b1ff39f0a1673a977b8047e1e14a49d461c9934be080d27c2392a830c1c0
 2018-01-11 17:04:26 +00:00
drh
24cd20ffa4 Fix typo in comment. No code changes. 
FossilOrigin-Name: 2c55571baaae58d6f5b6210cf85d0fa325a9977682bd449e3802191f7a4142de
 2018-01-11 13:43:04 +00:00
drh
536c345107 Update the .help screen in the CLI. Make sure the temporary files for 
".open" are not deleted too soon.

FossilOrigin-Name: b8d92d8dc239597c6f01a6e572b047f98ce374a8f48257683fa839dde3ec993f
 2018-01-11 00:38:39 +00:00
drh
9791313474 Add the built-in edit(VALUE) and edit(VALUE,EDITOR) function to the CLI. 
FossilOrigin-Name: ef823c47a0ac4f3b001e6c89c38354b45b5229d872cfc69a29c82e99414b89c8
 2018-01-11 00:04:00 +00:00
drh
3c484e8c1f Save and restore the output mode when doing ".once -x" or ".excel". 
FossilOrigin-Name: f697c164518d36f2a63c87d9f2708d0f9481fad3ded2de61f3f48c393cf7a500
 2018-01-10 22:27:21 +00:00
drh
a92a01a77e An attempt to get ".once -e" working reliably on Windows. 
FossilOrigin-Name: 9b97f9d2c876162139dbd9485fcf68412d1572d9ddc179b08938b8a602e895d6
 2018-01-10 22:15:37 +00:00
drh
7f3bf8a9fb Fix a potential SQLITE_MISUSE in the .excel command when no database is open. 
FossilOrigin-Name: 9b95ff1abfb8d49bbe5a727f5c917a455e4289b4d69196377dc9294409341d70
 2018-01-10 21:50:08 +00:00
drh
13c209330d Add support for the ".excel" command (and ".once -e" and ".once -x") in 
the CLI.

FossilOrigin-Name: 23fa7c57c2b204d1ddcc2a939b5271628cf26689ad4ede6976038113095a9801
 2018-01-10 21:41:55 +00:00
drh
ca7733b782 Modify the new "--append" option to the .archive so that it takes a filename 
argument, the same as "--file".

FossilOrigin-Name: 58e3b07cc8cb5cc915f7d430483bd455b03f14120e0db23286d2e20dbb5391c5
 2018-01-10 18:09:20 +00:00
drh
e15c5e532a Add the lsmode(MODE) function in the fileio.c extension and use that function 
in the .archive implementation.  Add the --append and --dryrun options to
the .archive command and remove the --zip option, making it automatic.

FossilOrigin-Name: 38f28029d16df8489772c27867de8888dd1c26b170861acdc977fd4023939dde
 2018-01-10 17:44:03 +00:00
drh
346606494a Fix minor problems with the new ".archive" command changes. 
FossilOrigin-Name: 612b30c95f948438016bd11470e9dd114d7bb064418a57e5954a094d2ca77f69
 2018-01-10 17:39:54 +00:00
drh
410cad975f In the fileio.c extension, change the filetype(MODE) function into lsmode(MODE). 
Use the new lsmode(MODE) function in shell.c.

FossilOrigin-Name: 52d12ba9f33c1f2620776e189c81f3bf991759344ecdd167ea2a6107f0972b9d
 2018-01-10 17:19:16 +00:00
drh
634c70fa15 Implement the ".ar --create" command using a single 
"REPLACE INTO sqlar SELECT ... FROM fsdir();" statement.  Add the
shell_putsnl() SQL function for providing --verbose output.

FossilOrigin-Name: 28ab930436fea33c79073e84f39d9e381fa60b4702a5dcbfaaed72baeeae8431
 2018-01-10 16:50:18 +00:00
drh
a5676c4d2d The ".ar" command deduces whether or not the target file is 
a ZIP or SQLAR and does the appropropriate thing.  The "-z" option is omitted.
The "--append" option is added to open auxiliary databases using apndvfs.

FossilOrigin-Name: 430d1a7daa823ae53606b7a158af4e7c16f62ff9b072b90606524e7c3f6131df
 2018-01-10 15:17:34 +00:00
drh
a82c95b47d Allow the use of ".ar -t" without specifying an archive file or the "-z" 
option when the command-line shell is opened on a ZIP archive.

FossilOrigin-Name: 9340a2c145bcb4b38d19276a16264a37341c617f0554d66e1da653f1d9f85163
 2018-01-10 14:00:00 +00:00
drh
e75d1f5290 Tag an unreachable branch using ALWAYS(). 
FossilOrigin-Name: c42c734f11c58724f5d8b32cb1c92e274be350028868d6ed045b2cfd274c64e7
 2018-01-10 13:58:23 +00:00
drh
b376b3d6aa Work on the ".archive" command. 
(1) Add the --dryrun option.
(2) Do not require --file when open on a ZIP archive.
(3) Miscellaneous code simplifications.
This is an incremental check-in of work in progress.

FossilOrigin-Name: a2baada429e84dc4b7243173a056e3c8bc042682f7efb01fdf8d2cc452c97e04
 2018-01-10 13:11:51 +00:00
dan
a688ca5ea9 Fix a problem in os_unix.c causing it to return SQLITE_CANTOPEN instead of 
SQLITE_READONLY_RECOVERY.

FossilOrigin-Name: 6a16f554f027ba268276b728588b5eaea837cbed85358a06a2f6da3b70e834ad
 2018-01-10 11:56:03 +00:00
drh
5af0698356 Rearrange some routines in shell.c to avoid the need to forward reference a 
static function.

FossilOrigin-Name: fd7f51a107806666d5c3a3a7a62528ec3e1fb71c4256f49d57b4dcdac4bf8680
 2018-01-10 00:53:55 +00:00
drh
6116ee4eee Compute the correct column name even if the column identifier is the 
very last token in the SQL statement.  This fixes a problem introduced
by check-in [0fdf97efe5df745510c6b] and reported by the community during
beta-testing.

FossilOrigin-Name: 36b89d728ff13d395fe0e1db8e7c01263f73dccb278b3ece27f6ef78e909b492
 2018-01-10 00:40:06 +00:00
dan
9898c4a0c4 In the os_unix.c implementation of xOpen(), do not return 
SQLITE_READONLY_DIRECTORY in cases where the file cannot be opened for reasons
other than a readonly directory, such as the process running out of file
descriptors.

FossilOrigin-Name: fa8b80bb967792de99808712ac03e37ace0f11eb8fbe444aacd3d19184c425ea
 2018-01-09 20:34:53 +00:00
dan
e2d22ffaa3 Fix another -fsanitize issue in new shell code. 
FossilOrigin-Name: 6ee7b54c580de0240e0f49a5fd2d11ddcdbcce8a2ae4b249618d0ab2d54b5e5b
 2018-01-09 15:57:55 +00:00
dan
6b046be41a Fix the shell so that it can be built with SQLITE_OMIT_VIRTUALTABLE. 
FossilOrigin-Name: 931421a22507a5e1edb46e19cb5b3958ec3904807836ab5bcc7a90f37f476e6a
 2018-01-09 15:25:55 +00:00
mistachkin
562f0c8e46 Improve portability of compile-time MinGW detection for the command line shell. 
FossilOrigin-Name: 4a7236140cb0f40fa846da4673a0d56218def1929d58cf016909ce881a681140
 2018-01-09 00:28:24 +00:00
dan
7c15ac1ada Update the zipfile module so that it matches the documentation. 
FossilOrigin-Name: 7e7e472fa91a2bad2e521d4d67f176c8eb9edc1a07b283e425ea0fa2b6abba1f
 2018-01-08 19:59:59 +00:00
dan
dcfbff9a86 Fix a malloc/sqlite3_free mismatch in the shell tool code. 
FossilOrigin-Name: fe053b2ecdc04b918367fa503bf10292fd7cd84a6929670857b2e9153df4d1f9
 2018-01-08 17:05:32 +00:00
drh
03491a1a1a Remove the dependency on test_windirent.h from the generated shell.c file. 
FossilOrigin-Name: 0a50c9e3bb0dbdaaec819ac6453276ba287b475ea322918ddda1ab3a1ec4b58b
 2018-01-07 21:58:17 +00:00
drh
8682e12190 Modify the sqltclsh startup script to look for a properly formatted 
SQLAR at the end of the executable.  Fix the CLI so that it automatically
links against appendvfs and so that the --append command-line option works.

FossilOrigin-Name: 67c4a8c6881e33b830aa27c80e7e3d697a4222939edd77cd5ca77ece16471ea4
 2018-01-07 20:38:10 +00:00
drh
1fa6d9f96f The shell detects and opens ZIP archives using the zipfile extension. 
FossilOrigin-Name: 05c99eb8cefbb3366b6d4ae91e10aa0c82bdf5ea361f4b3375413783af9167ac
 2018-01-06 21:46:01 +00:00
drh
e37c0e1ce7 In the shell, include the ".archive" command only if compiling with 
SQLITE_HAVE_ZLIB.  Add ".archive" to the ".help" output.

FossilOrigin-Name: 366469f5603367fabcadfc9ffe8cd1e23c649fea49a560178ca0858a16a7e4d1
 2018-01-06 19:19:50 +00:00
drh
afba1802a0 Better whitespace in the "CREATE TABLE sqlar()" statement for the ".ar" 
command.

FossilOrigin-Name: 252ee55a7fc0b068b707af27bd912e684c28320996e78f0675217046b8c2fb49
 2018-01-06 15:49:57 +00:00
drh
11be81d413 Improved output from ".schema --indent" when a column definition is followed 
by a comment.

FossilOrigin-Name: 87da7efff07327278b1437f862ed8683c2d5d6ada7ea7461601a58f9762646b4
 2018-01-06 15:46:20 +00:00
drh
1e506b5527 Make sure i64 and u64 typedefs are available throughout shell.c. 
FossilOrigin-Name: 656fb5aab32f40412389e43de209867cedee1589533949cc8c01ba24218ea434
 2018-01-05 21:01:37 +00:00
mistachkin
2f74b3c3ab MinGW does not define the S_ISLNK macro; therefore, define it in the shell when needed. 
FossilOrigin-Name: 73023febbe57495a22db05904bd6ddff439d6c25970cbe87e0ba4a923f3e8a29
 2018-01-05 20:26:06 +00:00
mistachkin
acae8c3e5d Fix shell compilation with MinGW by including the 'dirent.h' header. 
FossilOrigin-Name: dfe510b51046a53c7f5c54fe73ec9de3364923eabd4b909c11984552e6bea406
 2018-01-05 20:08:46 +00:00
mistachkin
91f7211caa Add some missing #ifdefs for building without zlib. 
FossilOrigin-Name: c63fb1700c0f67d90857b1f3859c203880d0939f356a64d8ae7cafc814ea72bf
 2018-01-05 16:03:52 +00:00
drh
af2770f842 Fix compiler warnings. 
FossilOrigin-Name: 364ac333b030f0e3372937df723f1098183da87913ba0e8ae162864ee24a50d3
 2018-01-05 14:55:43 +00:00
mistachkin
3acaf4c07a Add missing #ifdef. 
FossilOrigin-Name: a0e18aea0950f5ebdf4112f826ff64d24e8660b341031132dcb65bb15579ef1c
 2018-01-05 00:53:03 +00:00
mistachkin
e55988074f Remove 'timespec' related code from the shell that has no effect and a (now) superfluous 'timespec' typedef from the Win32 dirent header file. 
FossilOrigin-Name: 57dac995dd028e4b7c8ce6806f5769831715c1bb9b886318fceb3fa50563d537
 2018-01-04 22:50:52 +00:00
mistachkin
dfdfd8c7f2 Get the shell enhancements compiling with MSVC. 
FossilOrigin-Name: 335387f9e0d4569097d34cd99cd332b38a282e9b7ae25f088eb47df5c25837ef
 2018-01-04 22:46:08 +00:00
drh
c76ed3d57d Merge in all recent trunk enhancements. 
FossilOrigin-Name: 406f79183736b6ad360169b837172afef2c82a4312f5787db08c54167a44b15e
 2018-01-04 19:54:55 +00:00
drh
35100fb194 Remove the snarky "_supported_" qualifier from the name of the 
sqlite_offset() SQL function.

FossilOrigin-Name: a6eee0fcd89d3958f8720ebdb5f0a8558b4795d747128091dae283eb81c4f74f
 2018-01-04 19:20:37 +00:00
drh
64c1990c00 Fix a broken documentation hyperlink. No code changes. 
FossilOrigin-Name: d91e3f3d343d281af374dd23eea333e61228539023ad5c5aea622085e5863bc7
 2018-01-04 16:40:44 +00:00
drh
d9620b8555 Fix code indentation. No logic changes. 
FossilOrigin-Name: e115f2583499df0c7ee991d372bed4b89aa717b10a4e4b10977864390cb4fc11
 2018-01-02 21:29:42 +00:00
drh
4d795ef7e4 In the constraint resolution logic, be careful not to cache column values 
in registers whose initialization might be bypassed by an OP_NoConflict opcode.
Fix for ticket [dc3f932f5a147771] reported by OSSFuzz.

FossilOrigin-Name: 2846458af5d029a8e4fdcc8f50873a44e57897bbfe6aee8a23a01ffc34c5579f
 2018-01-02 18:11:11 +00:00