database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-06-10 17:21:47 +03:00
Code
29,842 Commits 1,551 Branches 179 Tags
Commit Graph

9709 Commits

Author SHA1 Message Date
danielk1977
687566d786 Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) 
FossilOrigin-Name: d12481f09cbe51c7ea499bc22afec5de3af14ad4
 2004-11-02 12:56:41 +00:00
drh
b7f9164e98 Insert #ifdefs that can optionally remove features at compiletime resulting 
in a database engine with a smaller footprint. (CVS 2034)

FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad
 2004-10-31 02:22:47 +00:00
drh
27d258a3ec Begin adding the ability to remove unused features at compile-time and still 
have all the tests pass. (CVS 2033)

FossilOrigin-Name: 2aa506ccb003a25555b414772002d0130db93052
 2004-10-30 20:23:09 +00:00
drh
887dc4c275 Fix alignment problems in btree and pager and allow page sizes that are 
not a multiple of 8. (CVS 2026)

FossilOrigin-Name: 0539c2d2b8e16efcbe4db3afeae9c7b426e11b05
 2004-10-22 16:22:57 +00:00
drh
6138df56e7 Reinsert code deleted by (1998) that we thought was unused but was in fact 
needed.  Fix for ticket #966. (CVS 2025)

FossilOrigin-Name: 370ca539506a431dbe77dcb644215886760f34e9
 2004-10-19 16:40:59 +00:00
drh
b45bb9f17d Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) 
FossilOrigin-Name: 77542beb31349b85bdf404c46980da346dde3266
 2004-10-18 21:34:46 +00:00
drh
57790b8fca Sort the output of glob in test script attach2.test. Ticket #948. (CVS 2012) 
FossilOrigin-Name: 3d04eef9b7decd21acc30d47af1bb1386333c351
 2004-10-07 22:22:39 +00:00
drh
684917c269 Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) 
FossilOrigin-Name: 81ff8107ad63113782cf5a9ba7a512496114ba08
 2004-10-05 02:41:42 +00:00
drh
047d4836ff Additional code to test the SQLITE_FULL return when the disk is full. (CVS 1994) 
FossilOrigin-Name: 44e56f0bba61245d342d6e75510d6c35785efd49
 2004-10-01 14:38:02 +00:00
drh
c60d04464f Allow functions to be created when there are outstanding VMs. 
(Ticket #926)  Fix problems with sqlite3_errcode().  Add tests for
sqlite3_errcode(). (CVS 1989)

FossilOrigin-Name: d0f1dc5898382258b283308c2cce55a8bc378ee4
 2004-09-30 13:43:13 +00:00
drh
971a7c87bc Avoid a segfault in sqlite3_bind_parameter_index when there are 
unnamed parameters.  Ticket #918. (CVS 1977)

FossilOrigin-Name: 49f25ddf8382d588e00bf927e2acae93e332e4d4
 2004-09-24 12:48:12 +00:00
drh
ad6d94607f Add comments to unused P3 fields of selected instructions when NDEBUG is 
not defined.  This makes VDBE program dumps more readable during debugging. (CVS 1973)

FossilOrigin-Name: 4871c77f8fce36ff230e1f026f4e4e49492515e9
 2004-09-19 02:15:24 +00:00
drh
31f33e1369 Close stray statements prior to finishing trace.test, to avoid a file 
descriptor leak. (CVS 1965)

FossilOrigin-Name: 8bb0221da8ab49d766db7cd2f815ba2a305e15de
 2004-09-17 20:46:54 +00:00
drh
a42707b234 The INSERT code generator does a better job of detecting if the table 
being written into is used in the SELECT on the right-hand side.
ticket #901. (CVS 1961)

FossilOrigin-Name: 709bb22d6ddbd713029059180aaf77ac483b5bb8
 2004-09-17 17:23:15 +00:00
drh
c16a03b54b The callback on sqlite3_trace() is invoked the first time sqlite3_step() 
is called after sqlite3_prepare() or sqlite3_reset().  Ticket #900. (CVS 1960)

FossilOrigin-Name: 0cc2f40e6afa157ead45140c4e28a9a33c469b73
 2004-09-15 13:38:10 +00:00
drh
fd241b0ea4 Remove the encode/decode from the version 3.0 source tree. (CVS 1959) 
FossilOrigin-Name: c1f1320be5ce0b6e52491577078ba2b939882fbd
 2004-09-13 13:46:01 +00:00
drh
5689123ca6 Fix a segfault in the authorizer when it is given a SELECT statement with 
no FROM clause.  Ticket #896. (CVS 1954)

FossilOrigin-Name: 97d63b9290ef88b3cd8012c71fdd5b3c74eebc8f
 2004-09-09 13:55:50 +00:00
drh
6aff507e73 Trying to get some tests in printf.test to pass on 64-bit systems. (CVS 1952) 
FossilOrigin-Name: b12fc46dcd5aa901fc781a17d49f8f110fed5b8d
 2004-09-09 00:35:29 +00:00
drh
fe63d1c98b More changes directed at getting things to work on 64-bit platforms. (CVS 1949) 
FossilOrigin-Name: 39755d216608e9d12e1055433549f820f63608a7
 2004-09-08 20:13:04 +00:00
drh
fa6bc0000f Wildcards with the same name map into the same variable number. New 
api sqlite3_bind_parameter_index() added to map wildcard names into
wildcard index numbers.  Support for "?nnn" wildcards. (CVS 1945)

FossilOrigin-Name: 435b3f301fbb6953adc974c7f03589b06e9114c3
 2004-09-07 16:19:52 +00:00
drh
1807ce37b8 Fix the onecolumn method in the TCL interface so that it works the same 
as the eval method in all ways except for returning just the first value
in the result set. (CVS 1944)

FossilOrigin-Name: f323e4f86a08fe6448cbd4ff7cab459e8039d9f1
 2004-09-07 13:20:35 +00:00
drh
f2a611c988 Make VACUUM work when the page size is different than the default 1024. 
Ticket #890. (CVS 1939)

FossilOrigin-Name: fa82becae7e41c47a6387061932f692c6f9f472e
 2004-09-05 00:33:43 +00:00
drh
2e38c32b67 Modify btree.c so that is allocates big data structures using malloc() 
instead of allocating from the stack.  Stack allocations cause problems
for embedded systems and pthreads implementations that only allocate a
limited amount of stack space. (CVS 1937)

FossilOrigin-Name: 4595292f936bdbec10734f42682824e91ff71d11
 2004-09-03 18:38:44 +00:00
drh
2c7e56798b More tests of sqlite3_step() and SQLITE_BUSY added. (CVS 1936) 
FossilOrigin-Name: 9e6645dd781cb8e422e371ca23766dc1b689481e
 2004-09-03 00:27:56 +00:00
drh
32fc1a5c51 Fix a bug in the pagesize test script. (CVS 1931) 
FossilOrigin-Name: 1cf05bc607c88a3c0b81e82ee2d4fc761f08901a
 2004-09-02 15:49:07 +00:00
drh
51a6ec4892 Fix VACUUM so that it works on files whose name contains '. Ticket #873 (CVS 1930) 
FossilOrigin-Name: 8dd938e48048ffeb11181db9d98112ea2adbcfa6
 2004-09-02 15:27:41 +00:00
drh
5bb7ffe1ea Fix a problem with EXPLAIN on pragmas that return single integer values. 
Ticket #886 (CVS 1929)

FossilOrigin-Name: 8ce3d730b0bf1a9b9472ff38c58c462ebc3566e3
 2004-09-02 15:14:00 +00:00
drh
92f02c31d4 Transactions commit on the last sqlite3_step(), not on sqlite3_finalize(). 
This allows the sqlite3_step() to return SQLITE_BUSY if the commit is
blocked by a lock.  Ticket #885. (CVS 1928)

FossilOrigin-Name: d1b29156558f1c576002cdb2544dffaa693da39b
 2004-09-02 14:57:08 +00:00
drh
855eb1cf02 Simplifications and optimizations. Also: disable the corrupt.test for now. (CVS 1924) 
FossilOrigin-Name: 8fd65e704888a8e2f4a712a94fd0e3f866c10ef3
 2004-08-31 13:45:11 +00:00
drh
ee696e2218 Better detection and handling of corrupt database files. (CVS 1922) 
FossilOrigin-Name: 8f5b199e845fa7ae3444ef69bd840716d305cf73
 2004-08-30 16:52:17 +00:00
drh
8cdbf83690 Corrections to transient table handling in compound select statments. 
Tickets #826 and #875. (CVS 1912)

FossilOrigin-Name: 9cc765be4611a248cfcce1243fd1bbeaf5202968
 2004-08-29 16:25:03 +00:00
drh
2c6674cf7e Host parameter names conform to SQL-2003. (CVS 1902) 
FossilOrigin-Name: fd584d1ccf6643b723c2ff0a7a16c2aea3f1142c
 2004-08-25 04:07:01 +00:00
drh
fdb38064b0 Fix a pager bug that might have made multi-database commits non-atomic 
if a power failure occurred at just the wrong moment. (CVS 1900)

FossilOrigin-Name: b6eb4bf8c7763ef73723fc3d3697af435c19bae4
 2004-08-21 19:20:42 +00:00
drh
290c19482e Optimizations to the code generator. (CVS 1899) 
FossilOrigin-Name: bd6649c5aae1bf182610eb267b546c297a34481d
 2004-08-21 17:54:45 +00:00
drh
92febd92ad Tcl interface transfers values directly between SQLite and Tcl_Objs, without 
at translation to strings. (CVS 1898)

FossilOrigin-Name: e97c331362545ce21117776c7b61d3488668f2bf
 2004-08-20 18:34:20 +00:00
drh
895d747226 Add support for named wildcards in SQL statements. (CVS 1897) 
FossilOrigin-Name: d3be0b7c5a39c02b9b2d6d85f1595d591984a569
 2004-08-20 16:02:39 +00:00
drh
cb4c40ba0e Make sure the database file is correctly truncated after a ROLLBACK that 
occurs after a statement abort. (CVS 1893)

FossilOrigin-Name: 6afe467d146828d67ad17af21604c2e691aa5dff
 2004-08-18 19:09:43 +00:00
drh
2b74d70a38 Better debug logging of the pager. (CVS 1892) 
FossilOrigin-Name: 1cc0323f2597584b3f3239e8948ac3ff3db8da03
 2004-08-18 16:05:18 +00:00
drh
34f4732b06 Be more agressive about not creating or opening the TEMP database if there 
are no TEMP tables. (CVS 1891)

FossilOrigin-Name: 6b2b6b2dbd821070a2781685c4b63a50bc8f5cae
 2004-08-18 15:58:22 +00:00
drh
dc3ff9c34c Avoid creating a TEMP database unless it is absolutely necessary. (CVS 1890) 
FossilOrigin-Name: 5914a11caa4c6e778cd7ca010427897c8f971552
 2004-08-18 02:10:15 +00:00
drh
ae15787643 If meta(3)>0 then make the database readonly for now. This allows the current 
database to interact with future releases that might include autovacuum. (CVS 1888)

FossilOrigin-Name: 7619bf4771781005da23a3e9d7b00de405e27a64
 2004-08-14 19:20:09 +00:00
drh
8dcd7cab83 Attempting to open a locked table for writing should fail immediately. 
Ticket #842. (CVS 1880)

FossilOrigin-Name: fc879a9b1d05ddb8f8c552c1d334597e41b29b27
 2004-08-08 19:43:29 +00:00
drh
1d64fc1a5e Do not invoke the busy callback when trying to promote a lock from SHARED 
to RESERVED.  This avoids a deadlock. (CVS 1879)

FossilOrigin-Name: d33771a303d9c20dd477b1a973024ff763203211
 2004-08-07 23:54:48 +00:00
drh
00afe0b374 Fix a bug in the logic that converts numbers into strings inside the VM. 
Ticket #844 (CVS 1878)

FossilOrigin-Name: 863540be248d3079e1a997349be6c74199149511
 2004-08-06 17:00:40 +00:00
drh
db2d9a0bbb Fix a memory leak when the auxiliary data of a database structure is used. (CVS 1874) 
FossilOrigin-Name: 7ecff04a6153aa200233e6c0846a65e0213c3179
 2004-08-01 03:52:17 +00:00
drh
9796ef5804 Additional test case to cover ticket #831. (CVS 1872) 
FossilOrigin-Name: a62129af99b4a576a48eb4931f417af257f510c7
 2004-07-27 13:38:47 +00:00
drh
adfa3daf49 Honor the ORDER BY clause in a subquery that is the right-hand side of an IN 
operator.  Ticket #827. (CVS 1871)

FossilOrigin-Name: 76fe68cff6ce75dada510544b063dc1069eb2e0e
 2004-07-26 23:32:26 +00:00
drh
cced337e35 Get VACUUM working with UNIQUE indices. Ticket #829. (CVS 1870) 
FossilOrigin-Name: 88a19a4386708c3c10448740d2bbe149055bcc6e
 2004-07-26 23:07:51 +00:00
drh
1211de3709 Fix problems for 64-bit machines and when SQLITE_OMIT_AUTHORIZATION is defined. (CVS 1868) 
FossilOrigin-Name: e3cad1ab6226089265b4d15c6fc67cc33a31425f
 2004-07-26 12:24:22 +00:00
drh
956bc92cde Prepared statements now work with CREATE and DROP. All tests pass. 
No memory leaks. (CVS 1866)

FossilOrigin-Name: ebdb661e0eefe123c422d3c1c371e325bb6cf673
 2004-07-24 17:38:29 +00:00