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