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
17,912 Commits 1,785 Branches 392 Tags
version-3.19.4
Commit Graph

17912 Commits

This Branch
This Branch
All Branches
Author SHA1 Message Date
drh
336bfad6e6 Version 3.19.4 
FossilOrigin-Name: 605907e73adb4533b12d22be8422f17a8dc125b5c37bb391756a11fc3a8c4d10
version-3.19.4 		2017-08-18 19:28:12 +00:00
drh
3517858862 Use batch atomic writes when running on a recent F2FS filesystem, if compiled 
with SQLITE_ENABLE_BATCH_ATOMIC_WRITE.

FossilOrigin-Name: 2dd0c77d54b333beee48c250e61c0002a03d34c5d4da07040ac414bdd36f56f9
 2017-07-31 13:22:31 +00:00
drh
0894a5c997 Move the generation of output column names earlier, to right after name 
resolution and before query transformations such as flattening.  This prevents
the names from getting mangled by query transformations, and obviates hacks
in the query flattener that attempt to work around the name mangling.
The resulting code is smaller and faster and gives more consistent output.
This is a fix for ticket [de3403bf5ae5f72ed] and a cherry-pick
of check-in [09834279aeca3bda]

FossilOrigin-Name: 499942b3eece097a6b1695ebe60d7eb3d7f3de397bc28ebf6b1fe038116487e8
 2017-07-31 13:11:26 +00:00
drh
d811aaac92 Correctly handle an "INTEGER PRIMARY KEY UNIQUE" column in a WITHOUT ROWID 
table.  This is a fix for ticket [bc115541132dad136], cherry-picked from
check-in [5216bfb73f1a49bdd8]

FossilOrigin-Name: 322a2ede6dae04a8e7e07fe0d99040f38f025fa142bd0493025ad6d65c2aaf6d
 2017-07-31 12:19:40 +00:00
drh
1e8ce3a204 Increase the version number to 3.19.4 
FossilOrigin-Name: b77f297d38426a4d6da6d957f652d215f11327c09ed0f1d7e26306918dfa70ea
 2017-07-31 12:07:52 +00:00
drh
fa58e6575a Merge further enhancements to the batch-atomic-write subsystem. 
FossilOrigin-Name: 4be4265d74b8a46f6b0b0d9108efb1d2a3fb197d902bac1238e1ee03125f975a
 2017-07-31 12:04:23 +00:00
drh
2fc2f92ed6 Disable the writecrash.test module on Windows. 
FossilOrigin-Name: 4c0520d4df7473eb4cc764774df7d99bb96cf067ac224755e09f0df47fb2a810
 2017-07-28 20:49:02 +00:00
drh
9e61104c68 More precise determination of when an in-memory journal needs to be 
spilled to disk.

FossilOrigin-Name: 6a505bdd9347783d3d8105cb8185aa787801bad0c855b623cfd780fb406f0e7b
 2017-07-28 18:16:14 +00:00
drh
344f763f72 Add new extended error codes for the atomic write file-controls. 
FossilOrigin-Name: 94a2004756ffe027b3495be91366750135c294a9c460edc9a1b4b9422dcc33bd
 2017-07-28 13:18:35 +00:00
dan
2912da0283 Add new test file test/atomic.test. 
FossilOrigin-Name: f9213e4864d0542be5489e03cf40c47d9127a86bbbbbabd963aa08525d5dc97b
 2017-07-28 11:05:33 +00:00
drh
ecf0cfef7e Backport of all batch-atomic-write changes through check-in 
[67bad7fb9b]

FossilOrigin-Name: def55027b1f1db9c083830019dbcc3daed94f6cc70a76b285ac1af9d82f81695
 2017-07-28 02:02:45 +00:00
drh
a66632d83a Add the SQLITE_ENABLE_BATCH_ATOMIC_WRITE macro to ctime.c 
FossilOrigin-Name: 67bad7fb9b2fdb29b63308f22062444084dc28191a542e08076dc2e39caf6f62
 2017-07-28 01:53:32 +00:00
dan
77b4f528fa Do not set device-capabilities flags SEQUENTIAL or SAFE_APPEND for f2fs 
file-systems.

FossilOrigin-Name: 4477e60cd801dab7a8aec12c5bc5e81e774bedbfed38abbc8eb8b37336141a44
 2017-07-27 18:34:00 +00:00
drh
e50dc1de3d Do now allow the geometry object in the right operand of a MATCH operator in 
the RTREE extension to be inpersonated by a BLOB literal.

FossilOrigin-Name: 24c9cd460051781f7e6417b7e205274319258f061ae1191a6c5ff5af615439c9
 2017-07-27 00:27:57 +00:00
dan
33447e7793 Add a test for the outcome of a process crash within an xWrite VFS method 
call.

FossilOrigin-Name: eb8718006cb23ba9304da5c30d19863d688495f0eaae3794c5ad870e481866f8
 2017-07-22 20:12:31 +00:00
dan
4da30f8888 Add the "atomic-batch-write" permutation to permutations.test. This 
permutation fails if not run on a file-system that supports
atomic-batch-writes.

FossilOrigin-Name: 9f1b83fae9c973eee80eefefe7bd3a1eb7bba8af4cd919d7a2ce911900dd9087
 2017-07-22 16:58:47 +00:00
drh
2df9478f5f Keep batch-atomic-writes turned on for journal_mode=MEMORY, but turn them 
off for synchronous=OFF.  Refuse to compile with both SQLITE_MMAP_READWRITE
and SQLITE_ENABLE_BATCH_ATOMIC_WRITE.  Fix up some comments in the commit
logic.

FossilOrigin-Name: 2e80e19e4faac30947ed56aa3601c45c758cafb27f84780df255fdbcdc9a6999
 2017-07-22 16:32:33 +00:00
drh
d76dba7eb5 Omit unused batch-atomic-write code if SQLITE_ENABLE_BATCH_ATOMIC_WRITE is 
not defined.

FossilOrigin-Name: a89b62c4966cd297326e8712da40e0962d2328d7ba1f201d5abcec911eeef347
 2017-07-22 16:00:34 +00:00
dan
9d70954094 Use ioctl(F2FS_IOC_GET_FEATURES) to determine whether or not atomic batch 
writes are available.

FossilOrigin-Name: 532bbf1f2b1028db4e581c756533aa660e482d833caaed4eafb299ef9b584f3a
 2017-07-21 21:06:24 +00:00
mistachkin
172861be76 Fix typo in comment. No changes to code. 
FossilOrigin-Name: 65ec077ba63ab84ab8da91033adcf4a57bb9269ebcdd10f9e6c97c265512a80c
 2017-07-21 20:29:06 +00:00
drh
d080e3d7ac Additional documentation on the new VFS interface. No changes to code. 
FossilOrigin-Name: 83077ec8b5804e6c709fa4f0b50afec9eae6d5b603cc4c3e8a408ed6b2bfaf28
 2017-07-21 14:49:58 +00:00
drh
35270d2604 Add the documentation text for the new VFS interfaces used by batch-atomic 
writes.

FossilOrigin-Name: 5e944eea5a32cb4d27a2d5ae283b9ce6fe08c1bc584256e8e8c78583c415eb2a
 2017-07-20 21:18:49 +00:00
drh
94e32acb56 Transform two #ifdef statements into #if statements. 
FossilOrigin-Name: f2c6b5845028ef25dcd17e23e11b93c9f7296c26c7a21718fdae8f4b48c4e1da
 2017-07-20 21:01:53 +00:00
dan
d67a97705c Split SQLITE_ENABLE_ATOMIC_WRITE into two options - the original and 
SQLITE_ENABLE_BATCH_ATOMIC_WRITE.

FossilOrigin-Name: 7eb9bf2c5b42c39901fd571553c1f70aa5a9dac71fdc8e318b3063b928ad58f7
 2017-07-20 21:00:03 +00:00
dan
efe1697191 Add support for F2FS atomic writes. Untested at this point. 
FossilOrigin-Name: 416973ede3bde8567d1f2699728f72352979e054ef988d1c1e1cfe4290f6f8b8
 2017-07-20 19:49:14 +00:00
drh
4562d0db0d Enhance the built-in date/time functions so that they can be used in 
CHECK constraints, in the WHERE clause or partial indexes, and index
expressions, provided that none of the non-deterministic keywords
("now", "localtime", "utc") are used as arguments.

FossilOrigin-Name: a90c062d46c63a1e6f83064b1c5afb26a16e93b6ee8620ca46d169fdb325c488
 2017-07-20 15:08:43 +00:00
drh
2fbeb7e8f0 New test cases for date/time functions in indexes on expressions, in the 
WHERE clause of partial indexes, and in CHECK constraints.

FossilOrigin-Name: b7f70c7fcabc10b8b3e62fe5ac68476cec23acaee037c7250ff70bca3f3ab541
 2017-07-20 14:36:26 +00:00
drh
6e97f8ec84 Combine the Parse.ckBase and Parse.iSelfTab fields into just Parse.iSelfTab. 
This fixes a problem with date/time functions in check-constraints.  Add
some test cases for date/time functions in index expressions and check
constraints.

FossilOrigin-Name: 22eda0985ecd1f456c073e6ad735a8417f3ff1fb6aaad1640e1cec01e50c51d8
 2017-07-20 13:17:08 +00:00
drh
3e34eabcdf Allow indexes to be created on date/time functions as long as the 'now' 
date and the 'localtime' and 'utc' modifiers are not used.

FossilOrigin-Name: 0a5e1c04d9d07bb7fd6546a9ddac1bf42b19ea19c2b79570aea6cd4226887a27
 2017-07-19 19:48:40 +00:00
mistachkin
885f410472 Remove some 'breakpoint' commands in test files. 
FossilOrigin-Name: d14fc621e918915bbf8e04597eb238ea78dff3d9c5eb4402cb88692d00dbdfee
 2017-07-19 18:01:42 +00:00
dan
d4603a2cab Add further tests to unionvtab.test. 
FossilOrigin-Name: c93284cd65b6471bffc38696e14dc24a2170698faf566cf91b727ba272f88c25
 2017-07-19 11:52:25 +00:00
drh
466004d5a4 Add VFS interfaces needed to make use of batch atomic write capabilities 
in the underlying filesystem.

FossilOrigin-Name: 929bc46b8be0111a7b6e3d6fe129f0cad869c6a551bd47569c122742597b9f1c
 2017-07-19 11:20:32 +00:00
dan
7f3d20acec Fix a crash in unionvtab caused by a misconfiguration. Add other test cases 
for the same.

FossilOrigin-Name: 255d6b99de2bb210c09ebee9f9481ba3d1130fda47e6e01b4cc8411d00679d09
 2017-07-18 21:19:17 +00:00
drh
5a75dd86c1 Fix shell.c.in so that it aligns with shell.c. 
FossilOrigin-Name: 505fdc8ff5150276d3c6ab6135a542b791e9e79e2f76323e592b73b3fdc9bc2a
 2017-07-18 20:59:40 +00:00
dan
ff0a4edb72 Add test cases and fix minor error-handling issues in unionvtab.c. 
FossilOrigin-Name: deadaad2a0801b3c30d2a076d8eb006b62d8557cff820e0939741c078477c83f
 2017-07-18 20:49:15 +00:00
mistachkin
aecd438737 Fix duplicate test name. No changes to code. 
FossilOrigin-Name: 47b80ecc679e656ef865e73809d6a9aa485eceeacab86d10d405881c5d9872bd
 2017-07-18 20:30:55 +00:00
drh
3935ce8e28 Fix another harmless compiler warning. Get the MSVC makefile working with unionvtab. 
FossilOrigin-Name: d49639c208ac366f6c675ac5671accc2a597558b62a51520194276c61f32d406
 2017-07-18 20:28:34 +00:00
drh
65e0f11451 Suppress harmless compiler warnings in union-vtab. 
FossilOrigin-Name: 4d147a1e28b93e267889fcb01b538d6a2a58d6b1655512c883fa5b53ddcc60a4
 2017-07-18 20:22:12 +00:00
dan
a18532353c Remove an unused variable from unionvtab.c. 
FossilOrigin-Name: a447fdf182c9090ca5b6c9c13147ae4b78d22d67f416ee7a0436ca408284c8fe
 2017-07-18 20:17:52 +00:00
dan
859e4a73b7 Improve the readability of the unionvtab code. 
FossilOrigin-Name: 5bcf0f86ea7fbbc31a13b2d5b1cf93a92e46fb65fe8e779b3d7e4a98d60d7061
 2017-07-18 20:03:49 +00:00
dan
090f68a390 Have unionvtab support constraints on the column that corresponds to the 
INTEGER PRIMARY KEY field of the underlying source tables in the same way as
rowid.

FossilOrigin-Name: 4a6c416fa025a34116ea30923a673cbb108b251b2676734ec8f603600e38e50e
 2017-07-18 19:51:11 +00:00
dan
8342aa0d81 Add test cases to unionvtab.test. 
FossilOrigin-Name: 6c9128e1a53f8cf26de9ef1bc07051f2c94287531edacfcfb69d3cd7590240b3
 2017-07-18 18:50:37 +00:00
drh
53e86ab36f Add the union-vtab extension - still experimental and under active 
development.

FossilOrigin-Name: 948f95046b7eaa8c68617b36625a7500dd0e69e52425ac6d748f2a311eb2474a
 2017-07-18 18:19:35 +00:00
dan
46133d98a6 Do not use the flattening optimization for a sub-query on the RHS of a LEFT 
JOIN if that subquery reads data from a virtual table. Because it prevents the
planner from creating an automatic index on the results of the sub-query, the
flattening optimization sometimes slows things down in this case.

FossilOrigin-Name: 9dbae1df75219e2accd8993015ce0ffc21966d7e69d04178b1a2cc46207fe260
 2017-07-18 17:34:41 +00:00
dan
bbccd52143 Avoid creating an automatic index on the RHS of a LEFT JOIN to optimize an IS 
term. Fix for [ce68383b].

FossilOrigin-Name: d2f0b2e859a8a413ee4e4bd7040e450ccd604069e4ea8dbc9ff924718c2b14d7
 2017-07-18 17:13:41 +00:00
drh
80f134c8aa Change the default command-line shell history depth to 2000 lines. 
FossilOrigin-Name: 0b69aa7e37495f15c3fcc36969b650262b5aa5500fb40800de9a5c56a03f309d
 2017-07-18 14:41:44 +00:00
dan
16bab5a7d9 Add test cases to test/unionvtab.test. 
FossilOrigin-Name: f2c4a584e83ffcc1cedd39460eb06d6f231a1a87f269bb3e75055232a866067e
 2017-07-17 21:03:13 +00:00
dan
bcd303ac7d Enhance error detection and fix other issues in unionvtab code. 
FossilOrigin-Name: 9c3f1b9a82e500e015deb0cc669fbb32e7f0cdc69f926ceff383ab946f8d8d18
 2017-07-17 20:25:21 +00:00
drh
b98ca04529 Merge all changes from branch-3.20. Improvements to the fts5() extension 
interface.  Work around a gcc/valgrind bug in the sqlite3_value_pointer()
interface.

FossilOrigin-Name: e0aca7d2c60d9859750a6e98d3e3b87f79779a45920348fc1bda7f1cb93ef996
 2017-07-17 18:45:23 +00:00
drh
06d4940a48 Interchange to branches within an "if" statement in sqlite3_value_pointer() 
in order to work around a bug in gcc.

FossilOrigin-Name: 8a606e4abab4efa03f2e5ffc33d7c5faa3c663f339da87b4ce9f3feed5dc7194
 2017-07-17 17:46:29 +00:00