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

12859 Commits

Author SHA1 Message Date
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
drh
9199ac1048 Updates to the sqlite3_file_control() documentation. No changes to code. 
FossilOrigin-Name: 240e32ab1f2a18e3c9b92f577b1cc8f8ecb4c68c44eac863d859491e042cb72a
 2018-01-02 13:48:48 +00:00
drh
cde7b77932 Do not attempt to use pragma_module_list in the command-line shell unless 
it has been compiled with -DSQLITE_INTROSPECTION_PRAGMAS.

FossilOrigin-Name: 39ca5fcd31c902cbade4da05125b0dbf2bc5e2b8901af1645f113c9d3dbc8209
 2018-01-02 12:50:40 +00:00
drh
667a2a25ba The ".schema" command in the command-line shell now shows the structure of 
table-valued functions and eponymous virtual tables if they are named on the
".schema" command line.  Example:  ".schema sql%" shows the structure of
the "sqlite_dbstat" and "sqlite_stmt" virtual tables.

FossilOrigin-Name: f80f6651df0b2843c6c9619a8f3e05c56cd50363402800a2e166e6eb664f7768
 2018-01-02 00:04:37 +00:00
drh
1d315cf7b8 Improved name quoting and escaping in the auxiliary column info section 
of the ".schema" output for views and virtual tables.

FossilOrigin-Name: d64b14e37d9624bf5d86059ddd091170d8e6d341a8043f84548b9b3dbb96a908
 2018-01-01 21:49:43 +00:00
drh
ceba792a2f In the output of ".schema", show the column names of virtual tables and 
views in a separate comment.

FossilOrigin-Name: 2234a87fa905312b23f46d52e06cff7cacbf23b187e16c4398a42e6bdae0ee9f
 2018-01-01 21:28:25 +00:00
drh
c22b716e31 Minor simplification to the ".schema" logic in the command-line shell. 
FossilOrigin-Name: add45c47288248ca3745e0fceb5e0d9062a852d173d93ff2ff1a0f8fdf3237dc
 2018-01-01 20:11:23 +00:00
dan
373dc3bb3f Update ext/misc/zipfile.c to support creating and adding entries to existing 
zip archives.

FossilOrigin-Name: 2dec2dec592c0726ebe87b841b9c8d493dea7074a99f278eb1bf0b744d658a9d
 2017-12-29 20:19:03 +00:00
drh
c64487b9c8 Add support for the sqlite_unsupported_offset() SQL function if and only 
if compiled using -DSQLITE_ENABLE_OFFSET_SQL_FUNC.  Use that definition
when compiling the command-line shell.

FossilOrigin-Name: 4f1f1f521ae6da96b899e10bfeff6bc1ab7a45de0705076febaae20b441f48c6
 2017-12-29 17:21:21 +00:00
drh
092457b18c Change the function name to sqlite_unsupported_offset(X). Only enable the 
function if compiled with -DSQLITE_ENABLE_OFFSET_SQL_FUNC.  The makefiles add
that definition to shell builds.

FossilOrigin-Name: 7a7f826e324b1a2c332e2f1d0740fd0babffcaca6275a798572f02ad367b99ab
 2017-12-29 15:04:49 +00:00
drh
fe6d20e9f4 Enhance location(X) so that it works with indexes and WITHOUT ROWID tables. 
The function might return an offset to the main table or to an index,
depending on whether the column X would be loaded from the main table or
from the index.

FossilOrigin-Name: dd94d6a880dfec4bddd247239b815b84964f804d24841e25f33f1d46a4b5274d
 2017-12-29 14:33:54 +00:00
drh
7a8573bafa Merge recent enhancements from trunk. 
FossilOrigin-Name: 6251e438f2a76170fd1e95aa512a46086ed88ab93b9b97a1dba97c4558689305
 2017-12-29 13:35:09 +00:00
drh
e307e11d0a Omit all sqlite3_trace() output from the triggers associated with 
foreign key constraints.

FossilOrigin-Name: fda08e3d10cc850664a356efdafcfc68187053849e1b00991b0b35d892a6776b
 2017-12-27 21:30:34 +00:00
dan
b5090e4897 Improve the shell tool ".ar --list --verbose" command. 
FossilOrigin-Name: b64681a644c419bb98d00980a6cb56ef5a0aff5ef5321955631f0b4c88aac283
 2017-12-27 21:13:21 +00:00
drh
f259df5fc8 Show the text of individual statements within a trigger, as they 
execute, as comments in the output from sqlite3_trace() and sqlite3_trace_v2().

FossilOrigin-Name: fe3d2b97d8945e6a9636472f77bcdc92cc5dda8b3e6e3a4fcbdd0a212ea5b9aa
 2017-12-27 20:38:35 +00:00
drh
9b2e0435d2 Add and use the internal sqlite3DbSpanDup() interface. 
FossilOrigin-Name: a8e1545cb7aacb6a26a8c92a3ad4a3d584d150c3a00d2828c8adbb1ee19fcb6d
 2017-12-27 19:43:22 +00:00
drh
908cc6207f Merge recent enhancements from trunk. 
FossilOrigin-Name: 76373091354f27577e5235e96cfaa4b31429a38d1e0e1d6e094c4cc323b92a0a
 2017-12-27 19:27:26 +00:00
dan
5a78b81b1b Have the shell tool ".ar --list" and ".ar --extract" commands support zip 
files. Currently the "-zip" switch is required.

FossilOrigin-Name: a532a0f6fd59e81086d46f09151ba7fb26725198231d902c71d0f95cb01dbe91
 2017-12-27 18:54:11 +00:00
dan
9ebfaad25d Add new file ext/misc/zipfile.c, containing a virtual table for read-only 
access to simple zip archives.

FossilOrigin-Name: 8e366b99b13d765d8bf000a7ec5919e582702e51dc07c27a746b6002898a2302
 2017-12-26 20:39:58 +00:00
drh
4fb5c2dcc1 Merge bug fixes from trunk. 
FossilOrigin-Name: d76e12066fa6950f877cbe33b1892e2b0afa948978815d5b9a90cde1fff8ec98
 2017-12-26 18:14:53 +00:00
drh
0d9de99c5c Add support for measuring and reporting coverage of the parser state machine 
using the SQLITE_TESTCTRL_PARSER_COVERAGE test-control.

FossilOrigin-Name: 1253a872dbf48656d4efd588ab61223a5ac550d9b2b932249d6ba585276ba573
 2017-12-26 18:04:23 +00:00
drh
02a43f6def Faster and smaller implementation of sqlite3AtoF() based on a suggestion 
from Cezary H. Noweta.

FossilOrigin-Name: fd2e0e7a770c2ce9355068aad1024c3d2861c104fd3be304a91c55ca742155fa
 2017-12-26 14:46:20 +00:00
drh
5060a67c4d Fix an assertion fault on a syntax error input caused by check-in 
[6b2ff26c25bb9da3].  Problem discovered by OSSFuzz.

FossilOrigin-Name: 90d6e4f10d3055a776d24854c442a2a68e726af8fc382cdb6241a834082e4c4c
 2017-12-25 13:43:54 +00:00
drh
512795dfea Fix a NULL pointer dereference after a syntax error that can occur as a 
result of check-in [6b2ff26c25bb9da3] yesterday.  This problem was
discovered by the OSSFuzz.

FossilOrigin-Name: d49afb8f9804e96662d1e3cadc4c6643908706d848a53d5ed019919c98f2ccba
 2017-12-24 18:56:28 +00:00
drh
d3f5d6110b Grammar changes: the sclp non-terminal should always be followed by a scanpt. 
FossilOrigin-Name: 74a0181fc016fb0b7934188cfcc2ec26c689f0d33cc42453875f4392b7240d3a
 2017-12-24 17:01:54 +00:00
drh
1be266ba08 Remove the ExprSpan object. Instead, keep track of the test of subphrases in 
the parse using the "scanpt" non-terminal.

FossilOrigin-Name: 3eab7bdc44e0878b83dc86f27058a40c2ffafeacadc566f03693f6dc7e40a504
 2017-12-24 00:18:47 +00:00
drh
60ba57d9c5 Merge enhancements from trunk. 
FossilOrigin-Name: 150f07fec1e6d1fc0601820d717d8712fc513fe0d4bed67c8679eb51bca30d53
 2017-12-23 18:34:49 +00:00
drh
88a921ce60 Simplification to the error handling logic in the extension loader. 
FossilOrigin-Name: 07c773148d8db185fa54991df09298b64f4fef28879e6c9395759265e8183977
 2017-12-23 14:39:36 +00:00
drh
ab42a2fe8e Improve the error message that comes back when sqlite3_load_extension() 
fails because the named file exists but is not a valid shared library.

FossilOrigin-Name: 05fee1a21ea398f1e4d6f1cf361657eff25ed6cd8f85ab398262dcfd30da57e9
 2017-12-23 13:55:43 +00:00
drh
755b0fd358 Move the generation of output column names earlier in the case of a 
CREATE TABLE AS.  This is a fix for ticket [3b4450072511e62] and a
continuation of check-in [ade7ddf1998190b2b63] that fixes cases of
ticket [de3403bf5ae5f72ed6] that were missed previously.

FossilOrigin-Name: 6b2ff26c25bb9da344add79c93fb3e49fa034a89b38ef56e08e18d21de61f707
 2017-12-23 12:33:40 +00:00
drh
07859486c6 Add a SELECTTRACE() macro to indicate when column names are assigned to 
a SELECT statement.  This helps with debugging for tickets like
[de3403bf5ae5f72e] and [3b4450072511e621].

FossilOrigin-Name: 8f194008c3aaa4ef287200e37bc5278ba9c377a7091ee3f95bad66513226b083
 2017-12-23 11:51:40 +00:00
drh
5a699a01ca In the sqlite3TreeViewExprList() routine, show the "AS" alias name for 
each expression in the list, if it exists.

FossilOrigin-Name: 5efd854fe21470336ba4140294b6c90ef39af32e103b92c664438d7485c50f9a
 2017-12-22 19:53:02 +00:00
drh
efc88d020c Modify the new sqlite3_vtab_collation() interface so that it takes a 
pointer to the sqlite3_index_info object passed into xBestIndex rather than
an sqlite3 connection pointer, which the xBestIndex method might not have
access to.

FossilOrigin-Name: 5c1fe6666019147a26480b5db1bf2f474a5d072c234c736f16ed5d2a9a040b3f
 2017-12-22 00:52:50 +00:00
drh
ef7231b865 Fix SQLITE_DBCONFIG_TRIGGER_EQP so that it works even if SQLITE_DEBUG is 
not defined.

FossilOrigin-Name: afbbfff72002089fa73b5473cc98360df14288d489e93e667332d6e884ef60da
 2017-12-21 21:41:13 +00:00
drh
ada7045eab Add the ".eqp trigger" option to the ".eqp" command in the command-line 
shell.  Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control.

FossilOrigin-Name: 2c51644a12a638d89e4f7cc3fd561236ce424f2d4e1db31f1e8388f77add02b8
 2017-12-21 21:02:27 +00:00
dan
2e1ea57f8b Add the ".expert" command to the shell tool's ".help" output. 
FossilOrigin-Name: fc6193af5d216b4066fbc47e75a7d0538fd5fda40b94ee15e2ff4037ea89221b
 2017-12-21 18:55:24 +00:00