database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-26 21:59:27 +03:00
Code Activity
18,672 Commits 1,786 Branches 392 Tags
sessions-stat1
Commit Graph

12859 Commits

Author SHA1 Message Date
dan
3739f29807 Fix a problem in the sessions module with logging sqlite_stat1 rows for which 
(idx IS NULL) is true.

FossilOrigin-Name: 25bf734be1b3883fccf12ac4d93d50289aa307fb60a52e0e32df12f7ee4edc7a
 2018-01-17 20:57:20 +00:00
drh
b968518559 Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. 
FossilOrigin-Name: bfbeffab7735461acb3773242ba31dae15af9f8b0291c54a6734747bb1b36e66
 2018-01-17 13:15:23 +00:00
mistachkin
98e2cb8bd1 Simplifications to winOpenSharedMemory in the Win32 VFS. 
FossilOrigin-Name: 3e04999dabb87715de46255b1a9b08d5dfa70d140e0a09a37ea2842d71c77caf
 2018-01-17 01:40:57 +00:00
mistachkin
5685257b83 Corrections to error code handling in os_win.c, pursuant to walfault.test. 
FossilOrigin-Name: 568192228c9578b8ea34c363e10ff28450045cda76248b2f0f89f84b3a57e680
 2018-01-17 01:26:05 +00:00
drh
8c9e30ba2f Remove an unused field from the internal definition of the sqlite3_context 
object.

FossilOrigin-Name: 948a26b5a64d8a89c4ec7546ec4a4bee36e29e82edda677ca75424e7091325d0
 2018-01-16 21:05:10 +00:00
drh
4a4532bbb7 Make the new sqlite3_vtab_collation() interface accessible to loadable 
extensions.

FossilOrigin-Name: f301db3c2343fd2086bc5b69a17b2d226175584ccd09549ebb2cb603590da487
 2018-01-16 20:50:37 +00:00
drh
eb0b6f364e Remove the unused SQLITE_CANTOPEN_DIRTYWAL result code. 
FossilOrigin-Name: 3c786305fc6eaa6856ec6c71fc7969f61de266ba1bea0abf0ae133eb94e54b2d
 2018-01-16 20:37:56 +00:00
drh
0ed2fd8a25 Move the ZLIB version announcement in the CLI out of the default banner 
and put it in the ".version" command.

FossilOrigin-Name: 231679d6f8c0c3d957c8daa88b0743449b60b47159e114f4bc073a8612a73b2a
 2018-01-16 20:05:27 +00:00
mistachkin
fff5367c24 Show version of zlib in use when running the shell tool in interactive mode. 
FossilOrigin-Name: a8906b527a8f7a2cec88cc3b05c063a2785f0d1d141e148d954fc7440972a484
 2018-01-16 19:03:51 +00:00
dan
0c2ba13e02 Fix a problem causing an infinite loop or other malfunction in some UPDATE 
statements with an OR term in the WHERE clause.

FossilOrigin-Name: feb2c2b6f66b0f45490beb1642d99cdb89fa220e299a8c118929df557c814189
 2018-01-16 13:37:43 +00:00
drh
a9be508a97 Fix an error in the setDeviceCharacteristics() procedure for the 
(unsupported) QNX code in os_unix.c.

FossilOrigin-Name: 8151913a3987f4dd2d6efee046727f5fa9b6f11d5d3867ea8f512c03a212ac2b
 2018-01-15 14:32:37 +00:00
drh
b058d05452 Avoid excess stack usage when a VALUES clause with lots of rows occurs 
within a scalar expression.  This fixes a problem discovered by OSSFuzz.

FossilOrigin-Name: a4fa0581ba7cfd45fabe0198f55b3c2c8ee3ecfd2825aeed91116f44e77d760b
 2018-01-14 20:12:23 +00:00
drh
cdb60978b9 Fully initialize the Mem object for serial-type 10, in case such a 
serial-type is found in a corrupt database file.

FossilOrigin-Name: bd70a07d819a54346cb6c40fab681424c5af0dfb6bf29321a3de9fc99d285376
 2018-01-13 14:28:00 +00:00
drh
76506cd3a7 Add the new "nochange" APIs to the extension loading mechanism. 
FossilOrigin-Name: cd7c42699e73b688dbed29ed5d243d06439d7dbe0ba8c42d8299e04cc0dd4464
 2018-01-13 01:53:09 +00:00
drh
9df81a2989 Add the sqlite3_value_nochange() API, usable from within the xUpdate method 
of a virtual table to discover whether or not a column was unchanged at the
SQL level.

FossilOrigin-Name: dec3ea4e4e6c4b1761ddc883a29eaa50dcd663ce6199667cc0ff82f7849d4f2a
 2018-01-12 23:38:10 +00:00
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