]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 years agoAdd cases to fuzz.test. Some tests in this file fail at the moment. (CVS 3973)
danielk1977 [Thu, 10 May 2007 17:32:48 +0000 (17:32 +0000)] 
Add cases to fuzz.test. Some tests in this file fail at the moment. (CVS 3973)

FossilOrigin-Name: 1e8fcb3fbed7beb8bb1370953ecf3d4b9db01ede

18 years agoAdd some UTF-8 test infrastructure. Treat NaN as NULL. The printf routines
drh [Thu, 10 May 2007 17:23:11 +0000 (17:23 +0000)] 
Add some UTF-8 test infrastructure.  Treat NaN as NULL.  The printf routines
print infinity as "Inf" not as "NaN".  Ticket #2345. (CVS 3972)

FossilOrigin-Name: ffe615a71107a38b6f60c7baf4284a5b0aecdc22

18 years agoAdd new test file fuzz.test, to test SQLite with fuzzily generated SQL. (CVS 3971)
danielk1977 [Thu, 10 May 2007 15:37:52 +0000 (15:37 +0000)] 
Add new test file fuzz.test, to test SQLite with fuzzily generated SQL. (CVS 3971)

FossilOrigin-Name: 1e9e6fe75d01d8cf4e1a23505c45f28491f1e902

18 years agoFix a C++ism in func.c. (CVS 3970)
drh [Thu, 10 May 2007 13:23:22 +0000 (13:23 +0000)] 
Fix a C++ism in func.c. (CVS 3970)

FossilOrigin-Name: 9c0050a10c6bea75ada902c16eb28eb3cf864718

18 years agoAnother test for overflow in strftime(). It was not broken. (CVS 3969)
danielk1977 [Thu, 10 May 2007 11:43:53 +0000 (11:43 +0000)] 
Another test for overflow in strftime(). It was not broken. (CVS 3969)

FossilOrigin-Name: 5800d0327ebc122e679ef860b58098b3c08eb709

18 years agoAdd code to enforce the MAX_EXPR_DEPTH limit. (CVS 3968)
danielk1977 [Thu, 10 May 2007 10:46:56 +0000 (10:46 +0000)] 
Add code to enforce the MAX_EXPR_DEPTH limit. (CVS 3968)

FossilOrigin-Name: 2c9c94a24d52a1c9f5d1b32cbdff794a2dd74126

18 years agoMake sure compound queries inside a subquery only return a single result
drh [Wed, 9 May 2007 22:56:39 +0000 (22:56 +0000)] 
Make sure compound queries inside a subquery only return a single result
column.  Ticket #2347. (CVS 3967)

FossilOrigin-Name: 66954bdd81dabfb60306de8480b5477a4acb1d9e

18 years agoFix a typo in a comment. Ticket #2348. (CVS 3966)
drh [Wed, 9 May 2007 20:35:31 +0000 (20:35 +0000)] 
Fix a typo in a comment.  Ticket #2348. (CVS 3966)

FossilOrigin-Name: c0dbac46301039246afd4bebb71dd8184fc5c0c7

18 years agoFix a problem with strange expressions being fed to an ATTACH or DETACH
drh [Wed, 9 May 2007 20:31:29 +0000 (20:31 +0000)] 
Fix a problem with strange expressions being fed to an ATTACH or DETACH
statement. (CVS 3965)

FossilOrigin-Name: 0c91dc9ee0c5d441a7789b631476515260cb887f

18 years agoFix an obscure cache corruption that could occur after an SQLITE_FULL error. (CVS...
danielk1977 [Wed, 9 May 2007 15:56:39 +0000 (15:56 +0000)] 
Fix an obscure cache corruption that could occur after an SQLITE_FULL error. (CVS 3964)

FossilOrigin-Name: e8e879aca67dee959bab42627028964c474da72f

18 years agoAdd further test cases for compile time limits. (CVS 3963)
danielk1977 [Wed, 9 May 2007 11:37:22 +0000 (11:37 +0000)] 
Add further test cases for compile time limits. (CVS 3963)

FossilOrigin-Name: 9bf2c594a48a4661700f0833562ee2b3ff7b761c

18 years agoFix enforcement of the LIKE_PATTERN limit. (CVS 3962)
danielk1977 [Wed, 9 May 2007 08:24:44 +0000 (08:24 +0000)] 
Fix enforcement of the LIKE_PATTERN limit. (CVS 3962)

FossilOrigin-Name: 8819617b7cf7ccd64bf6bb4ba208f37126964ec2

18 years agoRemove a keyword from the header comment in date.c (CVS 3961)
drh [Tue, 8 May 2007 21:56:00 +0000 (21:56 +0000)] 
Remove a keyword from the header comment in date.c (CVS 3961)

FossilOrigin-Name: 03349ec0be208fd8701d94515a2ed13129cb8422

18 years agoRemove compiler warnings in the amalgamation. (CVS 3960)
drh [Tue, 8 May 2007 21:45:27 +0000 (21:45 +0000)] 
Remove compiler warnings in the amalgamation. (CVS 3960)

FossilOrigin-Name: c5754530c6b1a8151c558f33d27fed70c95a988b

18 years agoDisable tracing pragmas when not in debug mode. This eliminates an external
drh [Tue, 8 May 2007 20:59:49 +0000 (20:59 +0000)] 
Disable tracing pragmas when not in debug mode.  This eliminates an external
dependency on stdout. (CVS 3959)

FossilOrigin-Name: 5a0fe9854849bf3f04008a5dbb7a74e7d0d815ca

18 years agoFix the amalgamation generator so that all non-API functions have file scope. (CVS...
drh [Tue, 8 May 2007 20:37:38 +0000 (20:37 +0000)] 
Fix the amalgamation generator so that all non-API functions have file scope. (CVS 3958)

FossilOrigin-Name: e9f56ead0514f3eac75807ea710c1f035b8add4f

18 years agoUpdate the release builder script. (CVS 3957)
drh [Tue, 8 May 2007 18:30:36 +0000 (18:30 +0000)] 
Update the release builder script. (CVS 3957)

FossilOrigin-Name: 21299b917812920c70001c2d3d9b65f66eca6b24

18 years agoFix a null-pointer dereference that follows a malloc() failure introduced in (3954...
danielk1977 [Tue, 8 May 2007 18:04:46 +0000 (18:04 +0000)] 
Fix a null-pointer dereference that follows a malloc() failure introduced in (3954). (CVS 3956)

FossilOrigin-Name: 251ba1981e32fb80818965ffe1ef455069e88abd

18 years agoUpdate the amalgamation builder for the latest changes. (CVS 3955)
drh [Tue, 8 May 2007 17:59:42 +0000 (17:59 +0000)] 
Update the amalgamation builder for the latest changes. (CVS 3955)

FossilOrigin-Name: becd64d3615fc5738da4c70610d8849e0a70bed8

18 years agoAdd a few more tests to sqllimit1.test. (CVS 3954)
danielk1977 [Tue, 8 May 2007 17:54:43 +0000 (17:54 +0000)] 
Add a few more tests to sqllimit1.test. (CVS 3954)

FossilOrigin-Name: eeee6b71e5643511320cbe15bafa170cfd02877f

18 years agoAdd a test case that uses a trigger to insert many rows to sqllimits1.test. (CVS...
danielk1977 [Tue, 8 May 2007 16:13:45 +0000 (16:13 +0000)] 
Add a test case that uses a trigger to insert many rows to sqllimits1.test. (CVS 3953)

FossilOrigin-Name: 6368222558d00f968b49f862bfe672573e86fbcf

18 years agoAdd new test file sqllimits1.test. (CVS 3952)
danielk1977 [Tue, 8 May 2007 15:59:05 +0000 (15:59 +0000)] 
Add new test file sqllimits1.test. (CVS 3952)

FossilOrigin-Name: c8974603976ebc02edbc9ab271e87e57f8eb365e

18 years agoDo not allocate so much surplus memory in the implementation of the
drh [Tue, 8 May 2007 15:46:18 +0000 (15:46 +0000)] 
Do not allocate so much surplus memory in the implementation of the
replace() function. (CVS 3951)

FossilOrigin-Name: 0cf518ceebda8e7421d054813f97cc447d292344

18 years agoLimit the length of the patterns on LIKE and GLOB to avoid problems with
drh [Tue, 8 May 2007 15:34:47 +0000 (15:34 +0000)] 
Limit the length of the patterns on LIKE and GLOB to avoid problems with
deep recursion and N^2 behavior. (CVS 3950)

FossilOrigin-Name: 42e6c826998e69462462b0787d3650246d36f3b5

18 years agoIntroduce the (experimental) sqlite3_result_error_toobig() API that
drh [Tue, 8 May 2007 15:15:02 +0000 (15:15 +0000)] 
Introduce the (experimental) sqlite3_result_error_toobig() API that
function implementations can use to signal SQLite that the function
result is too big to represent. (CVS 3949)

FossilOrigin-Name: 17c4235c492f746867c1d2b8621043b93f8aa10e

18 years agoAdd the max_page_count pragma used to limit the maximum size of a database
drh [Tue, 8 May 2007 14:51:36 +0000 (14:51 +0000)] 
Add the max_page_count pragma used to limit the maximum size of a database
file.  Untested. (CVS 3948)

FossilOrigin-Name: b1b74f06688fd90fcaf54cf95e2e7beeb5fc1040

18 years agoFix a potential buffer overrun in the replace() function. (CVS 3947)
danielk1977 [Tue, 8 May 2007 14:39:04 +0000 (14:39 +0000)] 
Fix a potential buffer overrun in the replace() function. (CVS 3947)

FossilOrigin-Name: b0fb4a3cf6ddbc17ccd0c719b34a720d9090bc93

18 years agoAdd more code to enforce the limits specified in limits.h. (CVS 3946)
drh [Tue, 8 May 2007 13:58:26 +0000 (13:58 +0000)] 
Add more code to enforce the limits specified in limits.h. (CVS 3946)

FossilOrigin-Name: c59d436095b5258d7132a432c0cb6cd5a7990d85

18 years agoAvoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS...
danielk1977 [Tue, 8 May 2007 13:57:34 +0000 (13:57 +0000)] 
Avoid evaluating (INT_MIN/-1) with 32 bit signed numbers. It can cause SIGFPE. (CVS 3945)

FossilOrigin-Name: 2f186e916c982cde557e0bc1b925b10e6d58f8a1

18 years agoDo not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger...
danielk1977 [Tue, 8 May 2007 12:37:45 +0000 (12:37 +0000)] 
Do not crash in the internal functions sqlite_rename_table() or sqlite_rename_trigger() if they are somehow passed unexpected input. (CVS 3944)

FossilOrigin-Name: c2f90b465e37ea49c9e44415f6461e4f636bb64f

18 years agoBegin adding code to explicitly limit the size of strings and blobs. (CVS 3943)
drh [Tue, 8 May 2007 12:12:16 +0000 (12:12 +0000)] 
Begin adding code to explicitly limit the size of strings and blobs. (CVS 3943)

FossilOrigin-Name: 031a5915b68ec6827fee38b8b9dc74a9e0e09302

18 years agoFix a bug in the test logic introduced by check-in (3928). (CVS 3942)
drh [Tue, 8 May 2007 11:27:15 +0000 (11:27 +0000)] 
Fix a bug in the test logic introduced by check-in (3928). (CVS 3942)

FossilOrigin-Name: 47d1678d2d795196e51b7f0f185198f2b338636b

18 years agoBegin implementing a new system of upper bounds on the capabilities
drh [Tue, 8 May 2007 01:08:49 +0000 (01:08 +0000)] 
Begin implementing a new system of upper bounds on the capabilities
of SQLite.  By clearly defining the upper bounds, we make those
upper bounds explicitly testable.  This check-in is just infrastructure.
The upper bounds are not yet enforced. (CVS 3941)

FossilOrigin-Name: 93b623b232a43f78d2c90bfa2389dd5b28ad7280

18 years agoFix an NULL deref in the randomblob() function following a malloc failure. (CVS 3940)
drh [Mon, 7 May 2007 19:31:15 +0000 (19:31 +0000)] 
Fix an NULL deref in the randomblob() function following a malloc failure. (CVS 3940)

FossilOrigin-Name: 011e7db253f9a60c19977215eab1687930f15637

18 years agoAdd a version of the LIKE operator to the icu extension. Requires optimisation. ...
danielk1977 [Mon, 7 May 2007 16:58:02 +0000 (16:58 +0000)] 
Add a version of the LIKE operator to the icu extension. Requires optimisation. (CVS 3939)

FossilOrigin-Name: 3e96105c1f084a4ab4dad4de6f4759e43fc497f7

18 years agoChange the name of create_collation_x() to create_collation_v2(). Also add some tests...
danielk1977 [Mon, 7 May 2007 14:58:53 +0000 (14:58 +0000)] 
Change the name of create_collation_x() to create_collation_v2(). Also add some tests for it. (CVS 3938)

FossilOrigin-Name: ddc4e4797ff902692c4f0d86ec5f4e94cc7f0741

18 years agoFix typo in Makefile.in. Ticket #2343 (CVS 3937)
drh [Mon, 7 May 2007 13:11:10 +0000 (13:11 +0000)] 
Fix typo in Makefile.in.  Ticket #2343 (CVS 3937)

FossilOrigin-Name: db51f59a7bb7530f919858e2c51057839f6c9f4d

18 years agoAdd interface to configure SQLite to use ICU collation functions. (CVS 3936)
danielk1977 [Mon, 7 May 2007 11:53:13 +0000 (11:53 +0000)] 
Add interface to configure SQLite to use ICU collation functions. (CVS 3936)

FossilOrigin-Name: b29a81b4fbb926fa09186340342848b9fe589033

18 years agoChange sqlite3_snprintf() so that it does not write a zero-terminator if
drh [Mon, 7 May 2007 11:24:30 +0000 (11:24 +0000)] 
Change sqlite3_snprintf() so that it does not write a zero-terminator if
the buffer size argument is less than 1.  Ticket #2341.  Added documentation
about the sqlite3_snprintf() function. (CVS 3935)

FossilOrigin-Name: f3ae4ac5fe0bfa2f91e76a6def86c444e51fe80b

18 years agoAdd the experimental create_collation_x() api. (CVS 3934)
danielk1977 [Mon, 7 May 2007 09:32:45 +0000 (09:32 +0000)] 
Add the experimental create_collation_x() api. (CVS 3934)

FossilOrigin-Name: ff49d48f2f025898a0f4ace1fc227e1d367ea89f

18 years agoFix missing word in the copyright.html web page. (CVS 3933)
drh [Sun, 6 May 2007 21:20:43 +0000 (21:20 +0000)] 
Fix missing word in the copyright.html web page. (CVS 3933)

FossilOrigin-Name: 2d1348dda2cbdf958a15267432063f359550c303

18 years agoDo not flatten subqueries that are part of a compound SELECT and which
drh [Sun, 6 May 2007 20:04:24 +0000 (20:04 +0000)] 
Do not flatten subqueries that are part of a compound SELECT and which
have both an ORDER BY and a LIMIT clause.  Ticket #2339. (CVS 3932)

FossilOrigin-Name: 9600a998043c6dd1d5ecb03d1ee9a9273910243d

18 years agoAdd the start of the ICU extension. (CVS 3931)
danielk1977 [Sun, 6 May 2007 16:04:11 +0000 (16:04 +0000)] 
Add the start of the ICU extension. (CVS 3931)

FossilOrigin-Name: f473e8526770b6a332dfde3e1fd1ddf8df493e9a

18 years agoAdd "Powered By SQLite" logo contributed by Alberto Simoes. (CVS 3930)
drh [Sat, 5 May 2007 22:45:00 +0000 (22:45 +0000)] 
Add "Powered By SQLite" logo contributed by Alberto Simoes. (CVS 3930)

FossilOrigin-Name: 25cfa7740a0899511d9200d99c2617c45ff00f32

18 years agoFix a header problem introduced in the previous check-in. (CVS 3929)
drh [Sat, 5 May 2007 18:49:53 +0000 (18:49 +0000)] 
Fix a header problem introduced in the previous check-in. (CVS 3929)

FossilOrigin-Name: bece7a6bae3a52da03c25b577e15a648eb91805a

18 years agoFactor out btree test logic into a separate test_btree.c file. (CVS 3928)
drh [Sat, 5 May 2007 18:39:25 +0000 (18:39 +0000)] 
Factor out btree test logic into a separate test_btree.c file. (CVS 3928)

FossilOrigin-Name: d51274f1cc3a75f6a03e90259ce829ac1dacf78f

18 years agoFix a sprintf() problem introduced by (3916). (CVS 3927)
drh [Sat, 5 May 2007 12:06:24 +0000 (12:06 +0000)] 
Fix a sprintf() problem introduced by (3916). (CVS 3927)

FossilOrigin-Name: 54a1d275aa0154a88d433a3c4df538d52c2c3ecb

18 years agoRefactoring. Split btreeInt.h off from btree.c. Split malloc.c off from
drh [Sat, 5 May 2007 11:48:52 +0000 (11:48 +0000)] 
Refactoring.  Split btreeInt.h off from btree.c.  Split malloc.c off from
util.c.  Expect much more to follow. (CVS 3926)

FossilOrigin-Name: ad549a40ed3500fb3d552ed19ff791d1280e0b62

18 years agoRefactoring. Split btreeInt.h off from btree.c. Split malloc.c off from
drh [Sat, 5 May 2007 11:48:52 +0000 (11:48 +0000)] 
Refactoring.  Split btreeInt.h off from btree.c.  Split malloc.c off from
util.c.  Expect much more to follow. (CVS 3925)

FossilOrigin-Name: 16041116aaaa2d52a289aa02a24bef579ba60896

18 years agoAdd documentation on the incremental vacuum feature. (CVS 3924)
drh [Fri, 4 May 2007 19:16:30 +0000 (19:16 +0000)] 
Add documentation on the incremental vacuum feature. (CVS 3924)

FossilOrigin-Name: b3e2cdaed3638f033437b5561705cb253449c392

18 years agoFix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923)
danielk1977 [Fri, 4 May 2007 19:03:02 +0000 (19:03 +0000)] 
Fix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923)

FossilOrigin-Name: a0f8adc692839d0645daf0630533a87b0543f6e8

18 years agoTest interaction of incremental io and other database writes. (CVS 3922)
danielk1977 [Fri, 4 May 2007 18:36:44 +0000 (18:36 +0000)] 
Test interaction of incremental io and other database writes. (CVS 3922)

FossilOrigin-Name: 4516416b4d38679ea7d259155f241e54c4c58d7d

18 years agoChange incremental vacuum to be triggered by a pragma rather than a command.
drh [Fri, 4 May 2007 18:30:40 +0000 (18:30 +0000)] 
Change incremental vacuum to be triggered by a pragma rather than a command.
We have a lot to learn about this yet and we do not want to paint ourselves
into a corner by commiting to specific syntax too early. (CVS 3921)

FossilOrigin-Name: b13e497a326697ab42b429993a1eee7df3c0c3eb

18 years agoTighter compression of the keyword hash table. (CVS 3920)
drh [Fri, 4 May 2007 17:07:52 +0000 (17:07 +0000)] 
Tighter compression of the keyword hash table. (CVS 3920)

FossilOrigin-Name: 681216767d7fabfccb0b12f6a81b18b6d1c252bf

18 years agoOptional parameter in the INCREMENTAL VACUUM statement specifies how many
drh [Fri, 4 May 2007 16:14:38 +0000 (16:14 +0000)] 
Optional parameter in the INCREMENTAL VACUUM statement specifies how many
pages to vacuum from the database. (CVS 3919)

FossilOrigin-Name: ed713f9ccb5d0f306a79ab9931e43db2327fb435

18 years agoGet tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)
drh [Fri, 4 May 2007 14:36:22 +0000 (14:36 +0000)] 
Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)

FossilOrigin-Name: b94d39e4d903bc34a9d0bbedd971677abc0ddfc0

18 years agoMake "incremental" a fallback token so that you can set
drh [Fri, 4 May 2007 14:14:45 +0000 (14:14 +0000)] 
Make "incremental" a fallback token so that you can set
"auto_vacuum=incremental"
without having to quote the "incremental". (CVS 3917)

FossilOrigin-Name: 9d7a2e2bb41e7baed2cdcf199cb04d7aef19c010

18 years agoEliminate all uses of sprintf() and strcpy(). These were not being
drh [Fri, 4 May 2007 13:15:55 +0000 (13:15 +0000)] 
Eliminate all uses of sprintf() and strcpy().  These were not being
misused.  But getting rid of them removes a library dependency.  And
it avoids warnings from the OpenBSD compiler.  Ticket #2336. (CVS 3916)

FossilOrigin-Name: ba4845b32bdf38e623c4f7246e6e327715bbba4b

18 years agoTest cases and corrections to IO and malloc() error handling in incremental blob...
danielk1977 [Fri, 4 May 2007 12:05:56 +0000 (12:05 +0000)] 
Test cases and corrections to IO and malloc() error handling in incremental blob IO functions. (CVS 3915)

FossilOrigin-Name: 641e55284e1ba6070073c83ac6ed78ffb29f7e60

18 years agoFix a formatting errror in I/O logging. (CVS 3914)
drh [Fri, 4 May 2007 12:01:02 +0000 (12:01 +0000)] 
Fix a formatting errror in I/O logging. (CVS 3914)

FossilOrigin-Name: 2d37687a08a7b6b3a7f77f55a7c2e29a1f8731a8

18 years agoAdd compile-time option -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 that uses
drh [Fri, 4 May 2007 11:59:31 +0000 (11:59 +0000)] 
Add compile-time option -DSQLITE_MIXED_ENDIAN_64BIT_FLOAT=1 that uses
mixed-endian doubles.  This is needed on ARM7 to make database file
formats compatible with all other processors.  Tickets #2278 and #2335. (CVS 3913)

FossilOrigin-Name: 2a178d0c7950c9d403c0bc43c2043de945fb24e0

18 years agoRework accessPayload() function for clarity. (CVS 3912)
danielk1977 [Fri, 4 May 2007 08:32:13 +0000 (08:32 +0000)] 
Rework accessPayload() function for clarity. (CVS 3912)

FossilOrigin-Name: 42d07c70ec1eb6dd9619c97d753c9d2824aeae32

18 years agofix from Gentoo for allowing TCLLIBDIR to be overridden in env (CVS 3911)
vapier [Thu, 3 May 2007 20:06:11 +0000 (20:06 +0000)] 
fix from Gentoo for allowing TCLLIBDIR to be overridden in env (CVS 3911)

FossilOrigin-Name: e54a49e264ecd54083587f8d3b17cce4c811fddc

18 years agoTest some more incremental IO error cases. (CVS 3910)
danielk1977 [Thu, 3 May 2007 18:14:10 +0000 (18:14 +0000)] 
Test some more incremental IO error cases. (CVS 3910)

FossilOrigin-Name: 64705410bdf43b6283f7a7e59ce8c20d09cd46e4

18 years agoImprovements to I/O tracing output. Require -DSQLITE_ENABLE_IOTRACE when
drh [Thu, 3 May 2007 17:18:36 +0000 (17:18 +0000)] 
Improvements to I/O tracing output.  Require -DSQLITE_ENABLE_IOTRACE when
compiling shell.c in order to link in the I/O tracing capability. (CVS 3909)

FossilOrigin-Name: 8a43e1676fdd29903e0b3f9d3b05d217d42962b8

18 years agoGet the amalgamation builder working with incremental I/O. (CVS 3908)
drh [Thu, 3 May 2007 16:55:32 +0000 (16:55 +0000)] 
Get the amalgamation builder working with incremental I/O. (CVS 3908)

FossilOrigin-Name: 92b53601657be3f1be70873b2960cd97b97f72a1

18 years agoTest cases and minor bugfixes for incremental blob APIs. (CVS 3907)
danielk1977 [Thu, 3 May 2007 16:31:26 +0000 (16:31 +0000)] 
Test cases and minor bugfixes for incremental blob APIs. (CVS 3907)

FossilOrigin-Name: e12c522383bd40af375a52d2e68612c4dc7fd4db

18 years agoFix a bug where accessPayload() was calling PagerWrite() on the wrong page handle...
danielk1977 [Thu, 3 May 2007 13:11:32 +0000 (13:11 +0000)] 
Fix a bug where accessPayload() was calling PagerWrite() on the wrong page handle. Ticket #2332. (CVS 3906)

FossilOrigin-Name: cf9eeba7be64ad29cddd320832db10c799fb6e8e

18 years agoUse memmove() instead of memcpy() when moving between memory regions that
drh [Thu, 3 May 2007 13:02:26 +0000 (13:02 +0000)] 
Use memmove() instead of memcpy() when moving between memory regions that
might overlap.  Ticket #2334. (CVS 3905)

FossilOrigin-Name: 678d672b73cc7b7f563c15daee3831cb5bbd890e

18 years agoMinor bugfixes for incrblob mode. (CVS 3904)
danielk1977 [Thu, 3 May 2007 11:43:34 +0000 (11:43 +0000)] 
Minor bugfixes for incrblob mode. (CVS 3904)

FossilOrigin-Name: b84d597c902d60341607bc405440603868ac52c8

18 years agoMinor bugfixes for incrblob mode. (CVS 3903)
danielk1977 [Thu, 3 May 2007 11:43:33 +0000 (11:43 +0000)] 
Minor bugfixes for incrblob mode. (CVS 3903)

FossilOrigin-Name: db54a9466e3bea9c03740ce0b755cfa02bafaccd

18 years agoAllow CREATE TABLE to occur while other queries are running. DROP TABLE is
drh [Wed, 2 May 2007 17:54:55 +0000 (17:54 +0000)] 
Allow CREATE TABLE to occur while other queries are running.  DROP TABLE is
still prohibited, however, since we do not want to delete a table out
from under an running query. (CVS 3902)

FossilOrigin-Name: 5b4bf1fce4d589337cfb1b46d75c751bbdc607d5

18 years agoCombine the internal btree functions BtreePutData() and getPayload(). (CVS 3901)
danielk1977 [Wed, 2 May 2007 17:48:45 +0000 (17:48 +0000)] 
Combine the internal btree functions BtreePutData() and getPayload(). (CVS 3901)

FossilOrigin-Name: a100a5304b0e7cbbdb6dac71a39c78eb71d44a03

18 years agoMore fixes and improvements to the zeroblob() mechanism. (CVS 3900)
drh [Wed, 2 May 2007 16:51:59 +0000 (16:51 +0000)] 
More fixes and improvements to the zeroblob() mechanism. (CVS 3900)

FossilOrigin-Name: 83ab25014e890b1cc6ea08ca1ebeeee0078da466

18 years agoCache the location of overflow pages in cursors used for incremental blob IO. (CVS...
danielk1977 [Wed, 2 May 2007 16:48:37 +0000 (16:48 +0000)] 
Cache the location of overflow pages in cursors used for incremental blob IO. (CVS 3899)

FossilOrigin-Name: 349f1ea7895f06c40affc985a13aa6686dfdea07

18 years agoFix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898)
drh [Wed, 2 May 2007 15:36:01 +0000 (15:36 +0000)] 
Fix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898)

FossilOrigin-Name: 4dbbfff4a7d4be197aac19c80400dafe10dd5e58

18 years agoAdd support for zero-blobs to the OP_MakeRecord opcode.
drh [Wed, 2 May 2007 13:30:27 +0000 (13:30 +0000)] 
Add support for zero-blobs to the OP_MakeRecord opcode.
First test cases of zeroblob functionality. (CVS 3897)

FossilOrigin-Name: e6d560ddeeb48fb0cbd9f5a10612280b055baef7

18 years agoUse the pointer-map pages to make the incremental blob API more efficient. (CVS 3896)
danielk1977 [Wed, 2 May 2007 13:16:30 +0000 (13:16 +0000)] 
Use the pointer-map pages to make the incremental blob API more efficient. (CVS 3896)

FossilOrigin-Name: 93a3bf71d576096f4b5a3db256ca6f9b5521d137

18 years agoFix some compiler warnings. Add the (untested) zeroblob() SQL function. (CVS 3895)
drh [Wed, 2 May 2007 02:08:28 +0000 (02:08 +0000)] 
Fix some compiler warnings.  Add the (untested) zeroblob() SQL function. (CVS 3895)

FossilOrigin-Name: 6f4f8ba7ec15f214f36fa78e593dd4522ab717f5

18 years agoBegin adding the zeroblob API to support incremental blob i/o. (CVS 3894)
drh [Wed, 2 May 2007 01:34:31 +0000 (01:34 +0000)] 
Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894)

FossilOrigin-Name: 7a01836dde45098796693bc6cb6045c4059adf1a

18 years agoEnable prefix-search in query-parsing and snippet generation. If the
shess [Tue, 1 May 2007 18:25:52 +0000 (18:25 +0000)] 
Enable prefix-search in query-parsing and snippet generation.  If the
character immediately after the end of a term is '*', that term is
marked for prefix matching.  Modify term comparison in
snippetOffsetsOfColumn() to respect isPrefix.  fts2n.test runs prefix
searching through some obvious test cases. (CVS 3893)

FossilOrigin-Name: 7c4c65924035d9f260f6b64eb92c5c6cf6c04b7b

18 years agoFirst approximation of incremental blob IO API. (CVS 3892)
danielk1977 [Tue, 1 May 2007 17:49:49 +0000 (17:49 +0000)] 
First approximation of incremental blob IO API. (CVS 3892)

FossilOrigin-Name: c444836e7b690c16dd6acff571c613a23beb42dc

18 years agoModify loadSegmentLeavesInt() to correctly handle prefix searching.
shess [Tue, 1 May 2007 17:14:59 +0000 (17:14 +0000)] 
Modify loadSegmentLeavesInt() to correctly handle prefix searching.
The new function docListUnion() is used to accumulate a union of the
hits for the matching terms, which will be merged across segments
using docListMerge(). (CVS 3891)

FossilOrigin-Name: 72c796307338c2751a91c30f6fb16989afbf3816

18 years agoThe pager takes the sector size to be the larger of the sector size
drh [Tue, 1 May 2007 16:59:48 +0000 (16:59 +0000)] 
The pager takes the sector size to be the larger of the sector size
reported by sqlite3OsSectorSize() and the page size. (CVS 3890)

FossilOrigin-Name: e5e6af55ccc5c1a8a9206b42f1dd7bf547cb97ca

18 years agoPropagate prefix flag through implementation of doclist query code.
shess [Mon, 30 Apr 2007 22:09:36 +0000 (22:09 +0000)] 
Propagate prefix flag through implementation of doclist query code.
Also implement correct prefix-handling for traversal of interior nodes
of segment tree.  A given prefix can span multiple children of an
interior node, and from there the branches need to be followed in
parallel. (CVS 3889)

FossilOrigin-Name: cae844a01a1d87ffb00bba8b4e7b62a92e633aa9

18 years agoFix a potential segfault following a malloc() failure during a call
drh [Mon, 30 Apr 2007 21:39:16 +0000 (21:39 +0000)] 
Fix a potential segfault following a malloc() failure during a call
to sqlite3_prepare() where the nBytes parameter is positive but less than
the length of the input SQL string. (CVS 3888)

FossilOrigin-Name: 27bf3fc3cf3c9c7acdbf9281a4669c9f642b0097

18 years agoLift docListMerge() call out of loadSegmentLeavesInt() for prefix
shess [Mon, 30 Apr 2007 17:52:51 +0000 (17:52 +0000)] 
Lift docListMerge() call out of loadSegmentLeavesInt() for prefix
search.  Doclists from multiple prefix matches will need a union merge
function, which will have to logically happen across a segment before
doclists are merged between segments. (CVS 3887)

FossilOrigin-Name: 7ddb82668906e33e2d6a796f2da1795032e036d5

18 years agoTry to avoid reading pages when moving overflow chains to the free-list. (CVS 3886)
danielk1977 [Mon, 30 Apr 2007 16:55:00 +0000 (16:55 +0000)] 
Try to avoid reading pages when moving overflow chains to the free-list. (CVS 3886)

FossilOrigin-Name: 8cccec68bd9073b2b19d3d31cf0b77b0ce76172e

18 years agoAdd some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885)
danielk1977 [Sat, 28 Apr 2007 15:47:43 +0000 (15:47 +0000)] 
Add some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885)

FossilOrigin-Name: 89b1b3f897bda1fffceb9cf72fa4d42b809ccb8e

18 years agoBreak interior-node and leaf-node readers apart in loadSegment().
shess [Fri, 27 Apr 2007 22:02:57 +0000 (22:02 +0000)] 
Break interior-node and leaf-node readers apart in loadSegment().
Previously, the code looped until the block was a leaf node as
indicated by a leading NUL.  Now the code loops until it finds a block
in the range of leaf nodes for this segment, then reads it using
LeavesReader.  This will make it easier to traverse a range of leaves
when doing a prefix search. (CVS 3884)

FossilOrigin-Name: 9466367d65f43d58020e709428268dc2ff98aa35

18 years agoInternationalize the TRIM functions. Ticket #2323. (CVS 3883)
drh [Fri, 27 Apr 2007 21:59:52 +0000 (21:59 +0000)] 
Internationalize the TRIM functions.  Ticket #2323. (CVS 3883)

FossilOrigin-Name: ff1f4e744728c8f55afae265246797b30fe98fb0

18 years agoLift code to traverse interior nodes out of loadSegment().
shess [Fri, 27 Apr 2007 21:24:18 +0000 (21:24 +0000)] 
Lift code to traverse interior nodes out of loadSegment().
Refactoring towards prefix searching. (CVS 3882)

FossilOrigin-Name: 25935db73877c0cb132acb30c2fed2544d0e5e32

18 years agoRefactor fts2 loadSegmentLeaf() in preparation for prefix-searching.
shess [Fri, 27 Apr 2007 21:01:59 +0000 (21:01 +0000)] 
Refactor fts2 loadSegmentLeaf() in preparation for prefix-searching.
Prefix-searching will want to accumulate data across multiple leaves
in the segment, using LeavesReader instead of LeafReader is the first
step in that direction. (CVS 3881)

FossilOrigin-Name: 22ffdae4b6f3d0ea584dafa5268af7aa6fdcdc6e

18 years agoMake sure sqlite3_value_bytes() does not reformat the content after a
drh [Fri, 27 Apr 2007 17:16:20 +0000 (17:16 +0000)] 
Make sure sqlite3_value_bytes() does not reformat the content after a
call to sqlite3_value_blob().  Add documentation to explain this hazard.
Add many new tests.  Ticket #2321. (CVS 3880)

FossilOrigin-Name: e92bd97a3726bbb7978489e2994747127c4aefcf

18 years agoExtra tests for incremental vacuum. (CVS 3879)
danielk1977 [Fri, 27 Apr 2007 07:55:37 +0000 (07:55 +0000)] 
Extra tests for incremental vacuum. (CVS 3879)

FossilOrigin-Name: 40ba6493e9e8ba135552a2a0943ab499713ac001

18 years agoModifications to btree integrity check so that it can be run inside a transaction...
danielk1977 [Fri, 27 Apr 2007 07:05:44 +0000 (07:05 +0000)] 
Modifications to btree integrity check so that it can be run inside a transaction after an incr vacuum. (CVS 3878)

FossilOrigin-Name: 4d4180d6474d8d74460fb9333580b9b60c89f353

18 years agoThe replace() function should return NULL if the second argument is an
drh [Fri, 27 Apr 2007 01:18:02 +0000 (01:18 +0000)] 
The replace() function should return NULL if the second argument is an
empty string.  Ticket #2324. (CVS 3877)

FossilOrigin-Name: e6a0c90dd9b4f7efe2153dd0c899b6e3d9846bd8

18 years agoAdd largely untested code for the incremental vacuum function. (CVS 3876)
danielk1977 [Thu, 26 Apr 2007 14:42:34 +0000 (14:42 +0000)] 
Add largely untested code for the incremental vacuum function. (CVS 3876)

FossilOrigin-Name: f6a6d2b8872c05089810b1e095f39011f3035408

18 years agoIn the pager, load the content of pages which were initialized with
drh [Thu, 26 Apr 2007 12:11:28 +0000 (12:11 +0000)] 
In the pager, load the content of pages which were initialized with
noContent==1 if they are subsequently requested with noContent==0. (CVS 3875)

FossilOrigin-Name: d0745a43b6e037d16e1ec38c7c4d961a80d1ef48

18 years agoFix segfaults that can occur if a malloc failure happens just before
drh [Wed, 25 Apr 2007 18:23:52 +0000 (18:23 +0000)] 
Fix segfaults that can occur if a malloc failure happens just before
a built-in function calls sqlite3_value_text(). (CVS 3874)

FossilOrigin-Name: 9cb0ed6ee9827bc6884a0195044d5b6ad0de698e