database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
30,100 Commits 1,570 Branches 184 Tags
optimize-null-values
Commit Graph

1295 Commits

Author SHA1 Message Date
drh
a3cc007df4 Simplication and optimization of error message handling. 
FossilOrigin-Name: 9d347f547e7ba9590b0c68edf50a14ad94a2bb92
 2013-12-13 16:23:55 +00:00
drh
b0e7704e9f Simplify and improve the performance of the sqlite3VdbeMemGrow() routine. 
FossilOrigin-Name: 48ecf18774ba9572d86696c60d87007a619d9f53
 2013-12-10 19:49:00 +00:00
mistachkin
091a81b91d Add the SQLITE_READONLY_DBMOVED error code to the sqlite3ErrName() function. 
FossilOrigin-Name: 7789f801d720db5394117e764675cd4bbe6b2da1
 2013-12-06 19:58:32 +00:00
drh
52208a6332 Merge all recent 3.8.2 beta changes from trunk. 
FossilOrigin-Name: 67c34ccfa9596a923695dc4994ec87b331f8326c
 2013-12-02 21:58:19 +00:00
drh
09fe614372 Add a new sqlite3_test_control() that indicates that database files are 
always well-formed.  Use this during testing to enable assert() statements
that prove conditions that are always true for well-formed databases.

FossilOrigin-Name: 15e4f63d1f3cbcd0aa789fd3e460cd6e4d3338f9
 2013-11-29 15:06:27 +00:00
drh
1b2ee4fe1a Merge in performance enhancements from trunk. 
FossilOrigin-Name: fc9ae839569eb28eb734c52d95676c59b2e27494
 2013-11-26 18:00:29 +00:00
mistachkin
af8641bd45 Clarify docs for the SQLITE_CONFIG_WIN32_HEAPSIZE option. 
FossilOrigin-Name: 51e876074af4e34ba01ed122e3bcc042243c9e88
 2013-11-25 21:49:04 +00:00
mistachkin
ac1f10458b Add experimental sqlite3_config option to control the native Win32 heap size. 
FossilOrigin-Name: f09f11e94b5a7c2e51d99c3700d2acd2f3903de9
 2013-11-23 00:27:29 +00:00
drh
cbf1b8ef7d Merge in the WITHOUT ROWID changes. A few tests are failing now. They will 
be fixed in a follow-on check-in.

FossilOrigin-Name: 5addd1234ded59ce60fb633b76ac87d483377edd
 2013-11-11 22:55:26 +00:00
drh
41e13e1268 Make sure cached KeyInfo objects are only valid for a single database 
connection.  Clear all cached KeyInfo objects on any collating sequence 
change.

FossilOrigin-Name: 55eea1782aead6a6aaf93f14d85486f8fd2209ad
 2013-11-07 14:09:39 +00:00
drh
f9c8ce3ced Standardize the error messages generated by constraint failures to a format 
of "$TYPE constraint failed: $DETAIL".  This involves many changes to the
expected output of test cases.

FossilOrigin-Name: 54b221929744b1bcdbcc2030fef2e510618afd41
 2013-11-05 13:33:55 +00:00
drh
a63b852992 Synchronize with the trunk. 
FossilOrigin-Name: 136445ba020c9475d3f5a7843d7d0add98477138
 2013-10-10 20:13:18 +00:00
drh
d36e104112 Combine the FuncDef.iPrefEnc and FuncDef.flags fields into a single 
new FuncDef.funcFlags field.

FossilOrigin-Name: 97b10e66e98e84755aa577f8da017bf1aea2056c
 2013-09-06 13:10:12 +00:00
drh
59255f9a98 Merge in all the latest trunk changes, including the win32-longpath VFS and 
the fix for the segfault in the omit-left-join optimization.

FossilOrigin-Name: cdd3838b7876639cf99904b2054884247fbff529
 2013-09-03 14:49:07 +00:00
mistachkin
d95a3d3527 Add support for Cygwin when handling temporary file names. Improve error codes and diagnostic messages for temporary file name handling on Windows. Rename winConvertUtf8Filename to winConvertFromUtf8Filename. Improve placement and comments for forward function declarations. 
FossilOrigin-Name: a411df725153119acb3bcf44fb71deecaa307887
 2013-08-30 21:52:38 +00:00
drh
db78b96111 Merge in all the latest updates and enhancements from trunk. 
FossilOrigin-Name: 67587a3348b84424b2ab1f2df1ea923a5168e2e4
 2013-08-19 12:49:06 +00:00
drh
40c3941cfa Add the cache_spill pragma. 
FossilOrigin-Name: cdb181c04fa99c6c29f23eb68ccb5475e7f6bf9c
 2013-08-16 20:42:20 +00:00
mistachkin
037933b8a7 Fix an outdated comment and a comment typo. No changes to code. 
FossilOrigin-Name: ac336959490083ffeaaf25aaec97ecb59a2f4536
 2013-08-13 22:33:41 +00:00
drh
ab80be99e3 If the SQLITE_EXTRA_INIT function is defined, make sure it is called only 
once by the effective sqlite3_initialize() call.

FossilOrigin-Name: e2b597cafe7c8a8313b051d6a302fed54f235727
 2013-08-08 14:38:45 +00:00
drh
869c0409e3 If the SQLITE_ALLOW_URI_AUTHORITY compile-time option is set, then allow 
non-localhost authorities on URI filenames and pass them through as a UNC
to the underlying VFS.

FossilOrigin-Name: 3adb6c1bfda897859dc9cf9ae7f1e6719855ee68
 2013-08-07 23:15:52 +00:00
drh
7fb30bd0dd Merge in the latest trunk changes, including partial indexes, the MAX_PATH 
fix in os_win.c, and the sqlite3_cancel_auto_extension() API.

FossilOrigin-Name: 7e1acb390770d1bd189fac7a3a7f96106f96e3a4
 2013-08-02 20:44:48 +00:00
mistachkin
16a2e7a053 Use a new error code to represent a failure to get the configured temporary directory on Windows. 
FossilOrigin-Name: c93d891b03c626b9ed01ed5ef2f246b2d4a40a64
 2013-07-31 22:27:16 +00:00
dan
1d1f07df58 Fix a typo in main.c: SQLITE_DEAULT_AUTOMATIC_INDEX -> SQLITE_DEFAULT_AUTOMATIC_INDEX 
FossilOrigin-Name: cc78e21c7794948a187e694773735058fc7460d7
 2013-07-25 16:41:39 +00:00
drh
6f855952d0 Merge recent trunk changes (such as the query_only PRAGMA, the 
defer_foreign_keys PRAGMA, and the SQLITE_DBSTATUS_DEFERRED_FKS parameter
to sqlite3_db_status()) into the sessions branch.

FossilOrigin-Name: 8dfc0b78c38e519b64a796243ff7c0aff688ff36
 2013-07-11 15:31:57 +00:00
drh
648e264342 Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS 
value for sqlite3_db_status().  This is a cherry-pick of a sequence of five
checkins in the sessions branch between [1d44e5d3c2] and [d39e65fe70].

FossilOrigin-Name: 527121ac3cdc96ac33ad975c227a6685a2f7e999
 2013-07-11 15:03:32 +00:00
drh
963c74df59 Rename the SQLITE_DeferForeignKeys macro to shorter SQLITE_DeferFKs. Move 
the "defer_foreign_keys" pragma into the flagPragma() routine.

FossilOrigin-Name: 3a2ab74c85a40e0e7ef2d6aef6ec23837cb788e6
 2013-07-11 12:19:12 +00:00
drh
8f8c65f79b Fix harmless compiler warnings in the progress callback logic. 
FossilOrigin-Name: 908141d5bf7a9ad8f40c2332476847733eca7fdc
 2013-07-10 18:14:29 +00:00
drh
888e16e7c5 Pull in all the latest changes from trunk. 
FossilOrigin-Name: af3ca4c6e557e6bc92584586b5a97d9be41b0b82
 2013-07-09 13:05:49 +00:00
dan
cb3e4b797e Experimental change to the handling of foreign key constraint violations when applying a changeset: all foreign keys, immediate and deferred, are deferred until the end of the transaction (or sub-transaction) opened by the sqlite3changeset_apply(). A single call to the conflict-handler (if any) is made if any FK constraint violations are still present in the database at this point. The conflict-handler may choose to rollback the changeset, or to apply it, constraint violations and all. 
FossilOrigin-Name: 1d44e5d3c2b1dc958442f9114a960b256e002ed3
 2013-07-03 19:53:05 +00:00
drh
8d56e2059c Issue the new SQLITE_WARNING_AUTOINDEX warning on the SQLite log whenever 
an automatic index is created.

FossilOrigin-Name: 338826ef3f8a209b14f8d42370855cab9ac9ed45
 2013-06-28 23:55:45 +00:00
drh
986b38792f Add the SQLITE_DEFAULT_AUTOMATIC_INDEX compile-time option, which if set to 
zero turns automatic indices off by default.  Increase the estimated cost
of an automatic index.  Additional minor refactoring of the automatic
index code.

FossilOrigin-Name: 459b3179023c2c45994ea4acbf34ed5f87cf3c18
 2013-06-28 21:12:20 +00:00
drh
4f7d3a5f06 Refactor names of fields in the sqlite3 object: "activeVdbeCnt" becomes 
"nVdbeActive".  Related fields becomes "nVdbeRead", "nVdbeWrite", and
"nVdbeExec".

FossilOrigin-Name: 14f796963474350e7aee8d3757acd3315fe78e4f
 2013-06-27 23:54:02 +00:00
dan
f73819af05 Add extended error code SQLITE_BUSY_SNAPSHOT - returned in WAL mode when a read-transaction cannot be upgraded to a write-transaction because it is reading from a snapshot other than the most recently committed. 
FossilOrigin-Name: 361c22969aa75340ed696e00e3dc5d17d5493bee
 2013-06-27 11:46:27 +00:00
drh
fd64cedc4b Bring the sessions branch up-to-date with all the latest trunk changes. 
FossilOrigin-Name: 086a127236ee99d67513490fb7b5549e8b752c44
 2013-06-26 13:31:50 +00:00
drh
cda73feaa2 Finish removing the sqlite3.inTrans field. In the previous check-in, it was 
merely commented out because I failed to select File->Save on my text editor.

FossilOrigin-Name: 2f97e38a6611cb17c24d74332d3ac3777dc0dd3e
 2013-05-28 17:30:52 +00:00
drh
4580d759fb Remove the obsolete and unused sqlite3.inTrans field. 
FossilOrigin-Name: c3381cd4957013d46075996c3b865177c888d2a8
 2013-05-28 17:25:48 +00:00
drh
f7b5496e8e Many small harmless comment changes. Removal of obsolete comments and 
fixing misspelled words.  No changes to code.

FossilOrigin-Name: a0d5cc9315dc6e9ef7dee4c3dfabf4e562d64376
 2013-05-28 12:11:54 +00:00
drh
466af9baae Update the sessions branch to the latest 3.7.17 beta. 
FossilOrigin-Name: af8057ef5dcaa72dc0d2ab5d1553b06757449fa1
 2013-05-17 10:58:08 +00:00
dan
617dc8602d In sqlite3_close_v2(), do not attempt to roll back a transaction if there exist active statement objects. Any open transaction will be rolled back when the last of these statement objects is finalized. 
FossilOrigin-Name: d11e76072a17fe833b87595d9d79f2c4b0b09cb3
 2013-05-16 11:57:28 +00:00
drh
ad1818d9ed Update the sessions branch with the latest trunk changes. 
FossilOrigin-Name: d09355050a74344c1cb6d303af9f601cd41e2368
 2013-05-15 18:45:14 +00:00
dan
6743081784 When closing a connection, avoid tripping active cursors belonging to a different shared-cache client. Also, if sqlite3_close() is called while there are still active statements belonging to the connection, return SQLITE_BUSY and do not roll back any active transaction. 
FossilOrigin-Name: 6071b7cce067c807e040283fc4b7449dc6eca498
 2013-05-15 10:21:50 +00:00
dan
cd7b91a7f1 Candidate fixes for problems revealed by notify2.test. Notify2.test is still failing at this point. 
FossilOrigin-Name: ea0428f9b6e63066e7444a2ba2f8c12a2e3ab7e4
 2013-05-13 18:23:15 +00:00
drh
644abec3a4 Merge trunk changes into the sessions branch. 
FossilOrigin-Name: 512f8a1ef8c4cf50723cfc4a78b7370dc37358d9
 2013-05-09 23:40:58 +00:00
mistachkin
10269dc676 Define the sqlite3ErrName() function only when necessary. More robust handling of unknown return codes. 
FossilOrigin-Name: e47cd314371c2be6e00d96392b3892a7f3015f98
 2013-04-30 07:54:42 +00:00
mistachkin
e84d8d3219 More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. 
FossilOrigin-Name: 05ba5e23fcc5da416d47a8ad5e667ed6a0c7a34a
 2013-04-29 03:09:10 +00:00
mistachkin
f2c1c99f15 Initial work on reforming usage of OSTRACE by the Windows VFS. 
FossilOrigin-Name: b347b5d1a01301f44e6fd20ee03a9529ffd25788
 2013-04-28 01:44:43 +00:00
drh
16fb176814 Merge the latest trunk changes into the sessions branch. 
FossilOrigin-Name: 6994826c0784280f2e9728dfa4185848846d03df
 2013-04-22 23:59:06 +00:00
drh
9b4c59fa1b Refactoring the mmap interface. The controlling pragma is now "mmap_size" 
instead of "mmap_limit".  Also change SQLITE_CONFIG_MMAP_LIMIT and
SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and
SQLITE_FCNTL_MMAP_SIZE, respecctively.  
The default mmap_size is now always 0, meaning that
memory mapped I/O is off by default.  There is a new compile-time option
SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size.
Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic
and causes it to be omitted from the build.  An extra argument is added
to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE
at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we 
know that it does not work, meaning that it cannot be turned on by mistake
on those platforms.

FossilOrigin-Name: ea1404a10abd7f68e1f8e0708c8a3199d1f79665
 2013-04-15 17:03:42 +00:00
drh
a1f42c7c32 Add the SQLITE_CONFIG_MMAP_LIMIT configuration option for overriding the 
SQLITE_DEFAULT_MMAP_LIMIT compile-time setting.  Enhance "PRAGMA mmap_limit"
so that without a specific database name, it sets the limit on all database
files and changes the default for any future databases that might be added
using ATTACH.

FossilOrigin-Name: 78141d0a16dd1d56b575fccd149de7fa789cb06c
 2013-04-01 22:38:06 +00:00
drh
8dd661aad1 Merge the changes for the 3.7.16.1 release candidate into the sessions branch. 
FossilOrigin-Name: ee35a89712b8ea9f4e70d61a29150348896b519f
 2013-03-28 01:19:26 +00:00