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
19,540 Commits 1,786 Branches 392 Tags
expr-node-copy-patch
Commit Graph

151 Commits

Author SHA1 Message Date
drh
7922183250 Merge all enhancements and fixes from the 3.21.0 release. 
FossilOrigin-Name: 13be3a441dc8d856a9d372aaf695fe346727cfcaa0ed763a7b8537a5ffbb5a80
 2017-10-24 19:12:33 +00:00
drh
efeaec365f Updates to test procedures so that they all work with encryption. No changes 
to the core SQLite code.

FossilOrigin-Name: 0481330756e861de8e1eb7136e7dca2f333b2a82377949d2e0eba401af7d73dd
 2017-10-23 16:34:07 +00:00
drh
d33bcb8a3c Improvements to PRAGMA integrity_check for better detection of malformed 
records.  Integrity_check now avoids returning SQLITE_CORRUPT on a corrupt
record.  Also includes microoptimizations that I stumbled over while working
on integrity_check.

FossilOrigin-Name: 8525c30c1d6676e51b9d9c642450aae3722c129edafdbc39b8435fcfe09b1817
 2017-09-13 00:33:36 +00:00
drh
74588ceb31 PRAGMA integrity_check returns SQLITE_OK even if it encounters corruption 
while scanning indexes.

FossilOrigin-Name: 81f62e99f27dedf3dc10fa1593c4cd9fc158680867206aee853e503a0cc8df71
 2017-09-13 00:13:05 +00:00
drh
3e1e14d818 Make sure all connections are closed in the pragma.test script. 
Test change only - no changes to code.

FossilOrigin-Name: d7b7f038a2c5e81a58c1dd4b556096b58ce10c30eb74fd4b770445927fdb62f3
 2017-09-12 00:24:45 +00:00
drh
af9861af87 Merge trunk enhancements 
FossilOrigin-Name: 6a0b9d9d4ed3e712bbbd3591c9b138f92b93c39e94234297aa182334bcba876f
 2017-09-09 06:10:15 +00:00
dan
3841372350 Update "PRAGMA integrity_check" to detect inconsistencies between a single 
record's header and body.

FossilOrigin-Name: 9e393a0edf1a578ddecc16a72fe3c54b75c2a650d507bcbc37c9724fbede1494
 2017-09-05 20:16:19 +00:00
drh
0ef6378073 Merge in all the latest trunk enhancements. 
FossilOrigin-Name: 7f48f6ab2af071ec20204105ed703c60e9fa92602558b910d14b09cc634bed7d
 2017-07-07 22:58:12 +00:00
drh
a690ff360b Change the error message text for SQLITE_ERROR to omit the part about 
"missing database" as that meaning is now obsolete (since approx SQLite 2.0).

FossilOrigin-Name: 732f90d6327c5c6368fc8b4cc207bd644ef08e3ae6d2e7295258ab099deaba63
 2017-07-07 19:43:23 +00:00
drh
2b78c0d38b Merge enhancements from trunk, and in particular the TEMP file deferred I/O 
enhancements.

FossilOrigin-Name: 81b76901e63d670c0f2302f56f1aeafcc7ff9922
 2016-04-29 15:52:58 +00:00
drh
cb9e7a56af Merge all recent enhancements from trunk. 
FossilOrigin-Name: a15c49aed09a6f431022bc73aa98b04165649192
 2016-04-21 15:35:21 +00:00
drh
518aca114f Merge updates from trunk. 
FossilOrigin-Name: cc28106e5c196c0a9678fbbd06f6afd49271a8e8
 2016-04-21 15:03:37 +00:00
drh
a6dddd9bde Remove quotes from identifiers used as datatype names in a CREATE TABLE 
statement.  Fix for ticket [7d7525cb01b68]

FossilOrigin-Name: eba27d4d17a76884292667d570d542e580ee3e77
 2016-04-18 15:46:14 +00:00
dan
9131ab9386 For a pager backed by a temp file, store the main journal in memory until it is at least sqlite3_config.nStmtSpill bytes in size. Prevent the backup API from being used to change the page-size of a temp file. 
FossilOrigin-Name: 84c557010c211595d2ec80b62c63af1c7f4714bd
 2016-04-06 18:20:51 +00:00
drh
2a73755f4e Merge updates from trunk - FTS5 fixes and enhancemenets to the tests scripts 
so that they work with SEE.

FossilOrigin-Name: f41a7361a1c59d0d681f2a81c2f70c1a9bbf7aee
 2016-03-15 12:45:43 +00:00
drh
7da56b4f65 Many more test cases fixed. Only a few remain. 
FossilOrigin-Name: 99b9d7eef68fd6d5c9eecb5fbe3dfe002c1ca4a8
 2016-03-14 18:34:42 +00:00
drh
81ab26904b Merge OOM handling optimizations and PRAGMA synchronous=EXTRA as well as 
other enhancements from trunk.

FossilOrigin-Name: 201fcbeef35d3d06d71ef5770fb72152840fcc2e
 2016-02-05 14:29:18 +00:00
drh
6841b1cb3d Add "PRAGMA synchronous=EXTRA" which syncs the directory containing the 
rollback journal when the rollback journal is deleted in order to commit a 
transaction in DELETE mode.

FossilOrigin-Name: af92401826f5cf49e62c278f344ab75252a18da2
 2016-02-03 19:20:15 +00:00
drh
9827122af5 Merge trunk enhancements into the apple-osx branch. 
FossilOrigin-Name: f12b8a0f7958260cb8e6b9be1aaa583cf383b39c
 2015-09-15 17:20:41 +00:00
drh
b3366b99c8 Update evidence marks due to wording changes in requirements text. No 
changes to code.

FossilOrigin-Name: 86781093bdb4c4fdedd228cb1c8961db48a483bb
 2015-09-11 20:54:44 +00:00
drh
3fa3114310 Merge all recent trunk enhancements and fixes into the apple-osx branch. 
FossilOrigin-Name: 74b7bf17446bc21a73fa5b75c2942b5660b0ad7e
 2015-04-20 01:25:56 +00:00
drh
d99d28361e Ensure that semantic SQL errors are always reported back up to the syntax 
parser.  Also:  Improve the defense against invalid PRAGMA synchronous settings.

FossilOrigin-Name: 7aeade9a07f29bf26e50394042ea18d0121fe7a3
 2015-04-17 15:58:33 +00:00
drh
59ac655d02 Silently ignore requests to change the PRAGMA synchronous setting to an 
illegal integer value, rather than raising an assertion.

FossilOrigin-Name: e0a88176fcfbed7b554a036948261a332c920053
 2015-04-16 16:04:39 +00:00
drh
e8c1a641b1 Merge recent trunk fixes and enhancements into the apple-osx branch. 
FossilOrigin-Name: bfc7142ad295c4b04078f9c01030bdbd15f024e8
 2015-04-15 13:51:38 +00:00
drh
1b6789697d Remove an incorrect ALWAYS() from the table_info pragma. 
FossilOrigin-Name: 0e087c0183bc7a758cf2a1d39158bc24fde833a2
 2015-04-15 07:19:27 +00:00
drh
5817b2a18e Merge recent trunk enhancements into the apple-osx branch. 
FossilOrigin-Name: 5e04eec88e4f5cb9d57577ee2d9e3569de930fbb
 2015-03-09 13:18:22 +00:00
drh
7be0fd9c58 New test cases and requirements marks for PRAGMA index_info, index_xinfo, 
and index_list.

FossilOrigin-Name: e5b13634d9794e4c75378cea89b64c5ecc5aa3e5
 2015-03-05 15:34:15 +00:00
drh
5e7028c210 Revert "PRAGMA index_info" to output only three columns, for complete 
compatibility with prior versions.  The new "PRAGMA index_xinfo" can be
used to get the extra information in 4th, 5th, and 6th columns.

FossilOrigin-Name: fc543c2c5ced30a7dc3a05b0c1ad80fdc838df8e
 2015-03-05 14:29:02 +00:00
drh
51a74d4cbd More test cases and requirements marks for pragmas. 
FossilOrigin-Name: fc51037cd97063069620213a62efdeff5d898706
 2015-02-28 01:04:27 +00:00
drh
9d356fbe6e New requirements marks and a few new test cases to go with them. No changes 
to code.

FossilOrigin-Name: 8c2b29d9acb92d47f4deec21a7c2dca52db63345
 2015-02-27 20:28:08 +00:00
drh
77cb4f3bf5 Merge all recent trunk enhancements into the apple-osx branch. 
FossilOrigin-Name: 44711921fea2bb2d804d57b23872ab84156a04ba
 2015-02-06 16:03:44 +00:00
drh
4bb8cb0927 Merge all recent trunk changes, including the movement of the pragma 
table into the separate pragma.h header file.

FossilOrigin-Name: 3af19f84446ba5fc1ed754d0d73f6a6d7fb2f365
 2015-02-04 23:13:48 +00:00
drh
c228be5b1f Add the "index_xinfo" pragma. Add new columns to the "index_info" and 
"index_list" pragmas.

FossilOrigin-Name: 30f51d7b3b292191e8351223242e708bb7f3dfa6
 2015-01-31 02:00:01 +00:00
drh
79e319ef93 Merge latest fixes and enhancements from trunk into apple-osx. 
FossilOrigin-Name: 2c1d8ddab23b36dbdd30ff82401925f97ffc5d76
 2014-12-16 00:29:06 +00:00
drh
7efa426ee9 Make sure the sqlite3BtreeCount() routine does not leave index cursors in an 
inconsistent state, as doing so might result in an assertion fault inside
of sqlite3BtreeKey() called from saveAllCursors() if content is deleted out
from under the statement that issued the sqlite3BtreeCount() call.

FossilOrigin-Name: 5b1b697040116048e464b3ebab8395fe088e389a
 2014-12-16 00:08:31 +00:00
drh
6f34c36a39 Merge all recent enhancements and bug fixes from trunk into the apple-osx 
branch.

FossilOrigin-Name: 43c4ba26a20ca0230d898a6431ed9ae5cfdb63d3
 2014-12-02 16:38:43 +00:00
drh
2d8233157d Fix a benign test error on PRAGMA collation_list 
introduced by a recent checkin.

FossilOrigin-Name: 332cc9591d05508ac9cb56fde2b82e20e0342d1f
 2014-11-20 23:11:30 +00:00
drh
72ab0c824d Merge 3.8.6 beta changes in from trunk. 
FossilOrigin-Name: b2e01080cce405de2bba7a5294001f9cc463a3c4
 2014-08-06 01:51:19 +00:00
drh
cefc87fca5 Enhance the PRAGMA integrity_check command to detect UNIQUE and NOT NULL 
constraint violations.

FossilOrigin-Name: 9abcf2698c09f4f6a44a68e74f9f6b538f3253d6
 2014-08-01 01:40:33 +00:00
drh
b9f41b4fd1 Initial attempt to merge in all trunk changes over the previous 1.5 years. 
This check-in compiles but there are compiler warnings and "make test"
segfaults after only running a few test modules.

FossilOrigin-Name: 9411d7dc6fbee689730c6f74736341bccd333d9e
 2014-05-08 23:01:59 +00:00
dan
597515d70c Update some test cases that deal with corrupt databases. 
FossilOrigin-Name: 3a09f5605ac7c6e503eb10acfdc607010414d917
 2014-02-28 18:39:51 +00:00
dan
1fed5dab0d Attempt to speed up sqlite3VdbeRecordCompare() by various means. This code is in an interim state. 
FossilOrigin-Name: 85206e0bbac29adab52bef795f6d1479f2ae2c0e
 2014-02-25 21:01:25 +00:00
drh
6fbe41acf2 Continue working to get UPDATE operational for WITHOUT ROWID tables. 
Fix PRAGMA integrity_check so that it works on WITHOUT ROWID tables.

FossilOrigin-Name: 0d4fea7462c0f61cd1c736cbcd7bea5ec2034d54
 2013-10-30 20:22:55 +00:00
drh
3ef261567a Restore the index_list pragma back to its former operation. Create a new 
PRAGMA stats used to access the table and index widths and heights.

FossilOrigin-Name: f0cf8c85dcbcc7778aed2816792c368d777f79cb
 2013-10-12 20:22:00 +00:00
drh
833d198fb1 Fix test cases for the new information in PRAGMA index_list. 
FossilOrigin-Name: dd03be1065537679c2daf5e4200902c47714fceb
 2013-10-08 22:25:22 +00:00
drh
fdaac671b8 Improved estimates of the relative speed of index scans based on declared 
datatypes of columns in the table.  Add "r" column to PRAGMA index_info,
showing the estimated relative scan rate.

FossilOrigin-Name: 07462bb6059f023c22a6c84a4a02afbd84e69255
 2013-10-04 15:30:21 +00:00
drh
4ee09b4bcc Allocate 4 bytes of unused header space for an "Application ID". Add 
the "PRAGMA application_id" command to set and query this identifier.
Add the "magic.txt" file to show how the posix file command might use
this application id.

FossilOrigin-Name: 28c9e7fdee2471a3026ee05ff591194d5f398131
 2013-05-01 19:49:27 +00:00
drh
c95e01da22 Verify that the schema has not changed before running PRAGMA table_info, 
index_list, index_info, and foreign_key_list.

FossilOrigin-Name: 82952d08f3e3aa80a7f51e80dbc89742cb4a09f0
 2013-02-14 16:16:05 +00:00
drh
384b7fe221 Enhance the table_info pragma so that the pk column shows the order of the 
columns in a multi-column primary key.

FossilOrigin-Name: 3076a89015071e9b40e728bd55160e3a6ed98820
 2013-01-01 13:55:31 +00:00
drh
78fffbf2c2 Merge all the latest trunk changes into the apple-osx branch. 
FossilOrigin-Name: 6723add4f492c30b20db8de6ed818c191dedea40
 2012-08-25 01:38:39 +00:00