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
15,498 Commits 1,786 Branches 392 Tags
default-synchronous
Commit Graph

10891 Commits

Author SHA1 Message Date
drh
c2ae2073d9 Make the SQLITE_DEFAULT_SYNCHRONOUS and SQLITE_DEFAULT_WAL_SYNCHRONOUS 
values zero-based to agree with PRAGMA synchronous.

FossilOrigin-Name: 592d2104361500e5002783ba329a2609389c57b9
 2016-03-08 15:30:01 +00:00
drh
e243de5cf5 If SQLITE_DEFAULT_WAL_SYNCHRONOUS is not the same value as 
SQLITE_DEFAULT_SYNCHRONOUS and the application has not run
"PRAGMA synchronous", then set synchronous to the 
SQLITE_DEFAULT_WAL_SYNCHRONOUS setting when entering WAL mode for
the first time.

FossilOrigin-Name: 5791407b523abd24e832fc2361b3e9f01ee2f36a
 2016-03-08 15:14:26 +00:00
drh
50a1a5aaca Add compile-time options SQLITE_DEFAULT_SYNCHRONOUS and 
SQLITE_DEFAULT_WAL_SYNCHRONOUS used to specify the default synchronous
settings for all database connections.

FossilOrigin-Name: 1fefa967aa93372d232b96b1e0232b7b855d6d00
 2016-03-08 14:40:11 +00:00
drh
6702f761ea Fix ATTACH to use the symbolic name PAGER_SYNCHRONOUS_FULL rather than 
an integer literal.

FossilOrigin-Name: c4e192a0e5a408e198dbacb2752859a00d2b572f
 2016-03-08 14:16:23 +00:00
drh
0dba3304f6 Fix comments on pager flag settings to include synchronous=EXTRA. 
FossilOrigin-Name: 3a65a1fc0fd2408c6984153801ec5dcd5211c897
 2016-03-08 13:56:02 +00:00
drh
6de32e7cdb Simplified error detection in the xBestIndex processing. 
FossilOrigin-Name: 82ca2131b670505578628687746135ac413d156b
 2016-03-08 02:59:33 +00:00
drh
8426e36c8f Add the ALLBITS macro as a shorthand for "(Bitmask)(-1)". 
FossilOrigin-Name: 91bd619d27e4d91510a187bbb88de961a31c8a2e
 2016-03-08 01:32:30 +00:00
drh
599d576456 Add a NEVER() to the code generator. Change the parameter name "mExtra" 
to "mPrereq" in the query planner, to more closely reflect its meaning.

FossilOrigin-Name: 721ae51e443647291f3a8f7f2128aa410fee2682
 2016-03-08 01:11:51 +00:00
drh
fb826b8c13 Changes so that some assert()s in the virtual table query planner are 
correct even following an OOM error.

FossilOrigin-Name: 9805f6f85211dcb5a0ab3ceca204e6f2e48530ea
 2016-03-08 00:39:58 +00:00
drh
237b2b7111 Avoid a NULL pointer dereference following an OOM while generating code 
for IN operators on virtual tables.

FossilOrigin-Name: c924008692e35f1f5144830af08d6de051dd21dd
 2016-03-07 19:08:27 +00:00
drh
8c71a98ce1 Add the SQLITE_CONFIG_STMTJRNL_SPILL option for sqlite3_config(). 
FossilOrigin-Name: b6c4202432dc96f8f1740f52d0bf872116357fcc
 2016-03-07 17:37:37 +00:00
dan
104ead923e Fix a problem in the previous commit affecting queries with three or more tables joined together to the right of a LEFT or CROSS JOIN operator. 
FossilOrigin-Name: d8d89d69a490a708b83147945f74134ae0e4b387
 2016-03-05 21:32:14 +00:00
dan
115305ff00 Change the way SQLite invokes the xBestIndex method of virtual tables so that N-way joins involving virtual tables work as expected. 
FossilOrigin-Name: ffc65968ede2c402e616147e6e3d737e6f9de21d
 2016-03-05 17:29:08 +00:00
drh
c2f18adde5 Remove the unused journal.c source file (its function have been subsumed into 
memjournal.c).  Refactor some of the names in memjournal.c.  No functional
changes.

FossilOrigin-Name: 5f2a262d3f6b1531001326faf1d3b3d92c20a30a
 2016-03-05 15:35:09 +00:00
drh
65a7e769e7 Work around (incorrect) ASAN warnings in memjournal.c. 
FossilOrigin-Name: 4de09777dad6188b7e897473700af3c9655e8547
 2016-03-05 15:03:31 +00:00
drh
07eab3b87f Fix an integer size mismatch problem in test_bestindex.c 
FossilOrigin-Name: 2e35eb6b7464455467c868adfbcaad4da16d3207
 2016-03-05 14:19:32 +00:00
drh
14bfd99143 Fix an incorrect #ifdef on sqlite3LogEstToInt(). 
FossilOrigin-Name: dca7b23354a6b08c926b6ed3f7345d942a409862
 2016-03-05 14:00:09 +00:00
drh
6f17c09fcf Fix an assert() in sqlite3VarintLen(), even though it is impossible to hit 
in SQLite due to the way sqlite3VarintLen() is used.

FossilOrigin-Name: 251424c5869f43012fc1e1a545de362036b883db
 2016-03-04 21:18:09 +00:00
drh
14520bfd23 Merge changes from trunk. 
FossilOrigin-Name: a87305dfd49ee17632d0bce66ce7c2e9407b7b3e
 2016-03-04 13:08:35 +00:00
drh
94580868f5 Change the default cache_size to -2000 (which means 2000*1024 bytes 
independent of page_size).

FossilOrigin-Name: 2682e8e413fadbca0673f242769af17bfd291559
 2016-03-04 04:01:43 +00:00
drh
9878fefd6f Change the default page size for new database files to 4096 (from 1024). 
Except, when building the testfixture, preserve the legacy page size.
Also fix a comment on SQLITE_MAX_ATTACHED.

FossilOrigin-Name: 2e8a9ca9d3d6efddc31f01074d14acae56568c37
 2016-03-04 03:43:10 +00:00
drh
79a2ca3944 Further fixes to the pread()/pwrite() enabling logic. 
FossilOrigin-Name: 38fb54e7854ac0500a88585ff9dd7487b4b2e586
 2016-03-04 03:14:39 +00:00
drh
a46cadc42e Fix the build for cases when pread()/pwrite() are not available. 
FossilOrigin-Name: 7d67d876b70c7a4199697c5b112d809c600e140e
 2016-03-04 03:02:06 +00:00
drh
e32a256acd Update the configure script to detect pread/pwrite and update os_unix.c to 
use those routines if they are available.

FossilOrigin-Name: 2cffb9e50bed77d1079603f5b4a71b7559de7294
 2016-03-04 02:38:00 +00:00
drh
ff6b826631 Get in-memory subjournals working for builds without SQLITE_ENABLE_ATOMIC_WRITE. 
FossilOrigin-Name: b5378dcea53d4cd1744d13ddee5e50869607b771
 2016-03-04 00:13:29 +00:00
drh
a05fc913ab Merge the latest updates from trunk. 
FossilOrigin-Name: 55c00f716dc98b188c91f3a5a010242c9497785f
 2016-03-03 21:29:10 +00:00
drh
862acaa3f4 Reduce the amount of heap memory required to store many schemas by storing 
the column datatype appended to the column name (with a \000 separator), 
rather than in separate memory allocation.

FossilOrigin-Name: 16fbf2e19c22df9441aef5c8b7f5670adc38a6b6
 2016-03-03 21:22:53 +00:00
drh
2b33f6e775 Allow the left-hand side of IN operators on virtual tables to have the 
aConstraintUsage[].omit flag clear.

FossilOrigin-Name: 3eb74342740cd393e03aa38cd01690ccab173b76
 2016-03-03 20:42:18 +00:00
drh
5b38201708 Merge 3.11.1 changes into trunk. 
FossilOrigin-Name: 7abc2dd953477797fa05421b061d73596aa025fb
 2016-03-03 17:54:30 +00:00
dan
512c09b0bd Add an extra test for the change on this branch. 
FossilOrigin-Name: d2d28251566d2a0ec1a07fe5b8ed047136840bfd
 2016-03-02 16:13:53 +00:00
dan
9cc24c8002 Enhance test_bestindex.c so that it can be used to test plans generated by xBestIndex. 
FossilOrigin-Name: 3c15a9bf45cd7dae2fbd99123b8dd75ce278d6e4
 2016-03-02 16:01:41 +00:00
drh
dbc49161c0 Allow the left-hand side of IN operators on virtual tables to have the 
aConstraintUsage[].omit flag clear.

FossilOrigin-Name: 1622623cbbfc4325c53d731aba78ca9c382ec612
 2016-03-02 03:28:07 +00:00
drh
7434b1dbf4 New test cases and infrastructure for testing the xBestIndex method of 
virtual tables.

FossilOrigin-Name: 1d41c161165006d6c2af47e476f05fb13039f8b8
 2016-03-01 22:48:00 +00:00
drh
4fb48e4eb1 Improved debugging output with wheretrace. Fix some typos in test script 
comments.

FossilOrigin-Name: 13a37fd487ce7d4f98a12f7a67a9c05dadc66557
 2016-03-01 22:41:27 +00:00
dan
23c3c38dd6 Fix a memory leak in the test code on this branch. 
FossilOrigin-Name: 7a1add56341f43dc41adc7b370e58860f4dd50a3
 2016-03-01 18:35:55 +00:00
dan
a3a44dd379 Allow test_bestindex.c to set the omit flag for a constraint. 
FossilOrigin-Name: 759b9d5b22aa60cc1d6b606f81eb7366c28cbcbe
 2016-03-01 18:24:36 +00:00
dan
8e4251b633 Add test code useful for testing the planners use of teh virtual table xBestIndex() method. 
FossilOrigin-Name: de034c0db66298454ae8418949d58eb6e223c0de
 2016-03-01 18:07:43 +00:00
dan
6e76326d18 When using a temporary file for a statement journal, store the first 64KiB in memory. If the file grows larger than that, flush it to disk and free the memory. Hardcoding to 64KiB is just an experiment to check that the memjournal.c code works. 
FossilOrigin-Name: 44b2dc18e200e87cf062cb8f1659727c53fa36e9
 2016-02-29 20:18:21 +00:00
dan
5f37ed5121 Fix minor problems with new code in memjournal.c. 
FossilOrigin-Name: 9fd3f7b9c93325a83cdbe7dc9ee312b22a9c2898
 2016-02-29 20:00:13 +00:00
drh
94eaafa9ce Reduce the amount of heap required to store many schemas by storing each 
column datatype appended to the column name, rather than as a separate
allocation.

FossilOrigin-Name: 842b21162713bb141b845b01c136457a31af4ab0
 2016-02-29 15:53:11 +00:00
drh
986dde7052 Further simplifications to the grammar. 
FossilOrigin-Name: 519fd03b845c9b53df9e5397282df2e99f36a672
 2016-02-29 13:37:21 +00:00
drh
2881ab6298 Update the parser so that it pulls out the column name and type all in one 
go, rather than using separate reductions.

FossilOrigin-Name: ad3ffe2eec8e8ea2591a78c723d2665735553cb0
 2016-02-27 23:25:36 +00:00
drh
94fa9c414a Eliminate the need for the Column.zDflt (using Column.pDflt instead) to reduce 
the amount of memory needed to hold the schema.

FossilOrigin-Name: d8c94a46dfa94930732c2de2aa79675c5087d36e
 2016-02-27 21:16:04 +00:00
dan
2491de28f1 Extend the code in memjournal.c so that it subsumes the role of journal.c. And (untested) can flush journal or statement journal files to disk after they grow to a specified size. 
FossilOrigin-Name: e0b0b4316531fc8afa74b4882d9c74a91030ec69
 2016-02-27 20:14:55 +00:00
drh
fc1a84c57b Tighter description of I/O stats in the shell. Show I/O stats on speedtest1.c. 
FossilOrigin-Name: f681d800340e0e710f73d0f7c09101f899249183
 2016-02-27 19:19:22 +00:00
drh
3478490332 Enhance the ".stats" command in sqlite3.exe to show one-time stats information 
if invoked with one argument.  Also show /proc/PID/io information if run on
Linux.

FossilOrigin-Name: 3c36948f16b58fe8042c37d0df634308b4e48217
 2016-02-27 17:12:36 +00:00
drh
d892ac97bb Enhance documentation of sqlite3_snapshot_open() to explain that the database 
connection must have participated in at least one read operation prior to
the beginning of the transaction for which the snapshot is to be opened.
Add test cases for this fact.

FossilOrigin-Name: 33dd671cb9c17f08dbc61aed91e80eaeb84bfaf5
 2016-02-27 14:00:07 +00:00
drh
d42908fb0e Provide the new SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER option to 
sqlite3_db_config() that can be used to activate the two-argument version
of fts3_tokenizer() for a specific database connection at run-time.

FossilOrigin-Name: 374b5108087a2eae03676c0f3469b37a272145bf
 2016-02-26 15:38:24 +00:00
drh
5f7d411e98 Fix a typo in a comment (though an important comment in that it is used 
to generate documentation).

FossilOrigin-Name: ff3d7f845e1875d6729f64f5231db1c376892f31
 2016-02-26 13:22:21 +00:00
drh
26bcc7cf40 Ephemeral tables used to hold manifested views may not be unordered since 
they might be subject to an ordered comparison if they are part of a join.

FossilOrigin-Name: 3ef6a3153267d5328202fea24fd29ff4d5409295
 2016-02-26 04:13:39 +00:00