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
10,026 Commits 1,785 Branches 392 Tags
shared-schema
Commit Graph

7263 Commits

Author SHA1 Message Date
drh
a19b89627e Make sure the Index.azColl pointers do not point to connection-specific memory. 
Also, remove an unnecessary reinitialization to sqlite3.pDfltColl.

FossilOrigin-Name: c469850b2eb61a63150cc5fc7d2fe98f0b5abffb
 2012-06-06 10:56:22 +00:00
drh
bae591a960 Merge the latest trunk changes into shared-schema branch. Also fix a C99-ism 
in that branch.

FossilOrigin-Name: 42338e9e6979bb497823527f8f39e96f63623c59
 2012-06-05 19:20:03 +00:00
drh
98c78ea63f Add sqlite3_quota_ferror() and sqlite3_quota_file_available() interfaces to 
test_quota.c.  Change sqlite3_quota_fwrite() to use a const input buffer.

FossilOrigin-Name: 61669c95859e187618fb2fb4249306a947ae8d26
 2012-06-05 13:56:15 +00:00
drh
ed46682719 Avoid calling fchown() if the process is not running as root. 
FossilOrigin-Name: 70c419a434be77b042a23174483d6a411899eb5d
 2012-05-31 13:10:49 +00:00
drh
1b28b89319 Link the NDEBUG macro to SQLITE_DEBUG so that when SQLITE_DEBUG is defined, 
NDEBUG is automatically undefined an dwhen SQLITE_DEBUG is undefined
NDEBUG is automatically defined.

FossilOrigin-Name: 07935d10d341fe6265cfd3b09e2c4ef4005c4826
 2012-05-29 19:25:20 +00:00
drh
666a1d8d1e Fix a typo (a repeated "or") in the documentation. No changes to code. 
FossilOrigin-Name: 6fec6cf1fbac881a33a35ea99aac2f5f1cf27c2a
 2012-05-29 17:59:11 +00:00
drh
d3d8c04fd1 Changes some NDEBUG macros to SQLITE_DEBUG in os_unix.c. The is a notational 
change only and really should not effect the code.

FossilOrigin-Name: 8e3025709e4954803919c84f3a810c7c63c60601
 2012-05-29 17:02:40 +00:00
drh
9cb7200815 Updates regarding URI query parameters and shared cache in the documentation 
derived from comments in sqlite.h.in.  No changes to code.

FossilOrigin-Name: bcc72d413e8db5fe8b32147ac22d406e2cd6bb60
 2012-05-28 17:51:53 +00:00
drh
9c67b2aae0 Add the mode=memory option to URI filenames, which when present forces the 
database to be an in-memory database.  This enables named in-memory databases.

FossilOrigin-Name: 651520fa84ee0c488bef660bab9865500309d5e9
 2012-05-28 13:58:00 +00:00
drh
2bfcce45eb Merge into trunk the changes that permit :memory: databases to use shared cache. 
FossilOrigin-Name: e72179f3a43e4df36b7c2955eaacce6c804272c6
 2012-05-27 22:42:57 +00:00
drh
d4e0bb0e65 Have user interfaces report out the filename of in-memory databases as an 
empty string, as it always has.  This simplifies the changes.

FossilOrigin-Name: 595dfdbffefb2598cba89980f885289d1c5f5833
 2012-05-27 01:19:04 +00:00
drh
4ab9d254e0 Only allow :memory: databases to share cache if there are created using a 
URI filename.  This minimizes the risk of breakages in legacy applications
that have shared-cache enabled but also use :memory: databases which they
expect to keep separate.

FossilOrigin-Name: e3ad61e0308a8442c2bdb7cdb3465576cd39ed4a
 2012-05-26 20:08:49 +00:00
dan
7946c53009 If SQLITE_DISABLE_FTS3_UNICODE is defined, do not build the "unicode61" tokenizer. 
FossilOrigin-Name: e71495a817b479bc23c5403d99255e3f098eb054
 2012-05-26 18:28:14 +00:00
drh
afc8b7f0c1 Enable the use of shared cache for an in-memory database, so that separate 
database connections can share the same in-memory database.

FossilOrigin-Name: 4590e433f2a595bb80fb061024b0a3d2ca25b7b2
 2012-05-26 18:06:38 +00:00
drh
bbabe19767 Mark and always-true conditional as such. Add the fuzz-oss1.test test module. 
FossilOrigin-Name: bdc01fd0fa0c15efbb32bf18527c71e3e4dc48ed
 2012-05-21 21:20:57 +00:00
drh
3a8c4be7d4 Candidate fix for the nested aggregate query problem of ticket 
[c2ad16f997ee9c8e].

FossilOrigin-Name: f3dd1fafd4718558de1f06139419a8c560d727f5
 2012-05-21 20:13:39 +00:00
drh
a51009b251 Convert the NameContext object from using u8 booleans to using individual 
bits in a single u8 as its booleans.  This change might become a basis for
a fix for [c2ad16f997ee9c].

FossilOrigin-Name: 722260969306778029b738402f22e3c154dd77a1
 2012-05-21 19:11:25 +00:00
drh
3608f177ba Make sure lookaside memory allocations are unusable after they are freed. 
FossilOrigin-Name: 3869aef6348018f584137f36f6924193a790e52f
 2012-05-21 16:59:16 +00:00
drh
94e858b15b Move some #defines earlier in the file for test_quota.c in order to avoid 
a use before definition.

FossilOrigin-Name: fda1ea0bee0fe283e0ed5710058fdfc403519bac
 2012-05-21 12:25:42 +00:00
mistachkin
84ee0af524 Allow the sqlite3ExplainBegin function to be compiled by MSVC. 
FossilOrigin-Name: 18555128f59b59d8c67446cd778ece9a181b30a5
 2012-05-21 05:02:22 +00:00
drh
ac43e98d61 Change the ".schema" command of the shell to output VIEWs in declared order, 
rather than alphabetical order, so that nested views will appear in the 
correct order.  Fix for ticket [cfe84e86839e59e8].

FossilOrigin-Name: e092ff69e25363f97495adc622f4250041ca9708
 2012-05-21 03:15:06 +00:00
dan
ca8b9bac3b Return SQLITE_MISUSE if an application attempts to register a virtual table module with the same name as an existing module. 
FossilOrigin-Name: ea2cd55e098b21cd8997fd6c1978131d3ef2fab4
 2012-05-16 14:29:11 +00:00
drh
5efb314525 Avoid using sqlite3ResetAllSchemasOfConnection() purely for its side-effects. 
FossilOrigin-Name: 5587c73badc07d3e01a7c5c5964e178b5112dd24
 2012-05-16 01:24:34 +00:00
drh
81028a455d The former sqlite3ResetInternalSchema() routine was really two different 
routines, selected by parameter, each with a confused mission.  So split
this routine up into three separate smaller routines, calling each
separately as needed.  Hopefully this will make further refactoring and
schema reset collateral damage containment easier.

FossilOrigin-Name: aa0c3493d3647d7efe527067e9fcccefda8e3008
 2012-05-15 18:28:27 +00:00
dan
bba02a95d9 When a connection disconnects from a shared-cache database, only delete the in-memory schema if there are no other connections. 
FossilOrigin-Name: 46f4eb5430d7bc9a339cdf7124ff4bd518eaa39b
 2012-05-15 17:15:34 +00:00
drh
29ddd3acdd Add assert()s to verify that Table objects in the schema never use 
lookaside memory.

FossilOrigin-Name: 736d6ea677f58e4aa2914fa79a3156b775c5a3f5
 2012-05-15 12:49:32 +00:00
drh
74ea19b489 Add an assert() that verifies that the statement pointer from 
the sqlite3_prepare() family of functions is always NULL if the routines
return other than SQLITE_OK.

FossilOrigin-Name: 0bb1cfc63f982db7b29c8e6be6698a6dad100f70
 2012-05-14 12:20:54 +00:00
drh
5b6c44a112 Fix a typo in a comment which is used to generate documentation. No changes 
to code.

FossilOrigin-Name: af525b5d25b5dee20528acc8321b8c6ca9aa98ae
 2012-05-12 22:36:03 +00:00
drh
ab35eaed1f Parser bug fix: Make sure the table constraints allowed by prior releases 
can still be parsed, even if they are technically not allowed by the
syntax diagram.

FossilOrigin-Name: e536ac041815b118c461ceee798f9b7283269f58
 2012-05-12 18:29:53 +00:00
drh
26d8b0fb49 Fix a harmless compiler warning inside an assert() statement within test code. 
FossilOrigin-Name: e68a3527decb434e8d0ac6b23a3cedba5992cedd
 2012-05-11 15:53:18 +00:00
drh
d187655341 Fix an evidence-mark typo in the comments of sqlite3.h. No changes to code. 
FossilOrigin-Name: 2b074085911d066a4411e46ce8e26a9d08cc0ce3
 2012-05-11 15:31:47 +00:00
drh
dd9819c4c1 Fix a harmless compiler warning. 
FossilOrigin-Name: 2b77301b9613c7caa02147095d728fd5b65dd120
 2012-05-11 11:28:40 +00:00
drh
aeb281c2ea Further changes to constraint parsing to support legacy syntax. 
FossilOrigin-Name: 38bf90af1ede6ee64ef7be66392e895e60c9126e
 2012-05-08 11:17:33 +00:00
drh
4dc330dd33 Adjust the parser so that certain legacy schema constructs (that are not 
valid according to the syntax diagram) continue to be accepted, so that
older databases that happen to use those constructs are still readable.
This fixes an issue introduced by check-in [1b75f301affac6]

FossilOrigin-Name: a1c014d8a87c8940b3a037d8d8cc4d5678809802
 2012-05-07 19:21:36 +00:00
mistachkin
48a55aa988 Simplify directory checking for winOpen and add checking to winDelete. 
FossilOrigin-Name: b08530e1a02cba03afefd65dc101e074e8847c07
 2012-05-07 17:16:07 +00:00
drh
1e039a240f Do not do the AV retry loop on open if the file that is attempting to be 
opened is really a directory.

FossilOrigin-Name: 03875633f465e82fbe99829f96db25f6d32bd333
 2012-05-07 13:15:20 +00:00
drh
a4c5860e6f Fix a minor deviation from the coding style guidelines. 
FossilOrigin-Name: 1e51bffe777587cd05bd7db5e02d6291c3eb8c1a
 2012-04-27 16:38:11 +00:00
drh
70331cd725 Enhance the processing of ORDER BY clauses on compound queries to better 
match terms of the order by against expressions in the result set, in order
to enable better query optimization.

FossilOrigin-Name: a49e909c8738317c8383ce93771c0a9c4cf270bc
 2012-04-27 01:09:06 +00:00
drh
9250581af4 All virtual table constructors to be invoked recursively. A test case for 
this has been added to TH3.

FossilOrigin-Name: 696a5a40bb28c4a54c9951f877b67015dc00bf55
 2012-04-26 22:47:20 +00:00
drh
b202d70a87 Fix a sign-extension problem for BLOB output in ".insert" mode of the 
command-line shell.

FossilOrigin-Name: 282f2a74c23aa3fca6087bdeaf5d961b4f5bbe47
 2012-04-24 12:12:57 +00:00
drh
9878123752 Update the ".table" command in the shell to show all tables in all 
attached databases, and to avoid using the deprecated sqlite3_get_table()
function.

FossilOrigin-Name: ce2d06e2533763a8008e7a405630293d8f9a3108
 2012-04-23 12:38:05 +00:00
drh
9b8d3572a9 If terminating interactive input to the command-line shell with ^D, issue 
an extra \n to move the cursor to the next line before exiting.

FossilOrigin-Name: feff1ef0b8f7b51ae80a9d34380b46a5103bf6cd
 2012-04-21 11:33:39 +00:00
dan
6a36f43586 Do not consider a DISTINCT clause redundant unless a subset of the result-set is collectively subject to a UNIQUE constraint and it can be guaranteed that all columns of the subset are NOT NULL (either due to NOT NULL constraints WHERE clause terms). Fix for [385a5b56b9]. 
FossilOrigin-Name: 7b8548b1872cc1225355ba8311e93dd08d6526e2
 2012-04-20 16:59:24 +00:00
dan
99f8fb66a4 Fix for 2a5629202f. When considering whether or not a UNIQUE index may be used to optimize an ORDER BY clause, do not assume that all index entries are distinct unless there is some reason to believe that the index contains no NULL values. 
FossilOrigin-Name: 9870e4c4fef10112c987c40cb1b95255a7214202
 2012-04-20 15:24:53 +00:00
drh
83cc139231 Fix harmless compiler warnings on x64 MSVC, mostly in test code, but also in 
tclsqlite.c and in the FTS4 module.

FossilOrigin-Name: 3281972eaa46cb57fd9f0387063f47430dc0a3b4
 2012-04-19 18:04:28 +00:00
drh
7ed243b71a Fix a harmless compiler warning in tclsqlite.c for MSVC x64. Fix a test 
case associated with the FTS4 merge feature.

FossilOrigin-Name: de3f7187eb2ff24683a1854ae523e7d30c290893
 2012-04-19 17:19:51 +00:00
drh
d5a336ef58 Fix harmless compiler warnings (unused parameter warnings) in the aggregate 
query analyzer.

FossilOrigin-Name: 2d43562084316ec180a4c2cfc3fee08d58432204
 2012-04-19 15:49:19 +00:00
drh
374fdce485 Improved handling of aggregate subqueries within an aggregate query. 
FossilOrigin-Name: 430bb59d798286a86c351de92c429345f016b3f0
 2012-04-17 16:38:53 +00:00
drh
d8621b90c9 Add an undocumented and possibly ephemeral ".breakpoint" command to the 
command-line shell, to call a no-op routine on which it is convenient to 
set a symbolic debugger breakpoint.

FossilOrigin-Name: 8e2363ad76446e863d03ead91fd621e59d5cb495
 2012-04-17 09:09:33 +00:00
drh
8c5058bbdb Fix a bug in the command-line shell logic that attempts to continue with a 
".dump" even after encountering database corruption.

FossilOrigin-Name: 020b5e90f950a42299074ff770612b9e68850d95
 2012-04-16 17:22:30 +00:00