1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Commit Graph

9695 Commits

Author SHA1 Message Date
danielk1977
7de68a097e Add a version of the LIKE operator to the icu extension. Requires optimisation. (CVS 3939)
FossilOrigin-Name: 3e96105c1f084a4ab4dad4de6f4759e43fc497f7
2007-05-07 16:58:02 +00:00
danielk1977
a393c03686 Change the name of create_collation_x() to create_collation_v2(). Also add some tests for it. (CVS 3938)
FossilOrigin-Name: ddc4e4797ff902692c4f0d86ec5f4e94cc7f0741
2007-05-07 14:58:53 +00:00
danielk1977
2559136971 Add interface to configure SQLite to use ICU collation functions. (CVS 3936)
FossilOrigin-Name: b29a81b4fbb926fa09186340342848b9fe589033
2007-05-07 11:53:13 +00:00
drh
6885390791 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
2007-05-07 11:24:30 +00:00
danielk1977
a9808b31a8 Add the experimental create_collation_x() api. (CVS 3934)
FossilOrigin-Name: ff49d48f2f025898a0f4ace1fc227e1d367ea89f
2007-05-07 09:32:45 +00:00
drh
ad91c6cd40 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
2007-05-06 20:04:24 +00:00
drh
16a9b8363d Factor out btree test logic into a separate test_btree.c file. (CVS 3928)
FossilOrigin-Name: d51274f1cc3a75f6a03e90259ce829ac1dacf78f
2007-05-05 18:39:25 +00:00
danielk1977
32a0d8bb8c Fix compilation and testing with OMIT_INCRBLOB defined. (CVS 3923)
FossilOrigin-Name: a0f8adc692839d0645daf0630533a87b0543f6e8
2007-05-04 19:03:02 +00:00
danielk1977
dcbb5d3f47 Test interaction of incremental io and other database writes. (CVS 3922)
FossilOrigin-Name: 4516416b4d38679ea7d259155f241e54c4c58d7d
2007-05-04 18:36:44 +00:00
drh
ca5557f91d 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
2007-05-04 18:30:40 +00:00
drh
9c61cd77a5 Optional parameter in the INCREMENTAL VACUUM statement specifies how many
pages to vacuum from the database. (CVS 3919)

FossilOrigin-Name: ed713f9ccb5d0f306a79ab9931e43db2327fb435
2007-05-04 16:14:38 +00:00
drh
847d3ab43d Get tests working with SQLITE_OMIT_AUTOVACUUM=1. (CVS 3918)
FossilOrigin-Name: b94d39e4d903bc34a9d0bbedd971677abc0ddfc0
2007-05-04 14:36:22 +00:00
drh
5bb3eb9b9a 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
2007-05-04 13:15:55 +00:00
danielk1977
92d4d7a92e Test cases and corrections to IO and malloc() error handling in incremental blob IO functions. (CVS 3915)
FossilOrigin-Name: 641e55284e1ba6070073c83ac6ed78ffb29f7e60
2007-05-04 12:05:56 +00:00
danielk1977
f1819244aa Test some more incremental IO error cases. (CVS 3910)
FossilOrigin-Name: 64705410bdf43b6283f7a7e59ce8c20d09cd46e4
2007-05-03 18:14:10 +00:00
danielk1977
8cbadb0211 Test cases and minor bugfixes for incremental blob APIs. (CVS 3907)
FossilOrigin-Name: e12c522383bd40af375a52d2e68612c4dc7fd4db
2007-05-03 16:31:26 +00:00
danielk1977
44e6c8d3cf Fix a bug where accessPayload() was calling PagerWrite() on the wrong page handle. Ticket #2332. (CVS 3906)
FossilOrigin-Name: cf9eeba7be64ad29cddd320832db10c799fb6e8e
2007-05-03 13:11:32 +00:00
danielk1977
20713f34a5 Minor bugfixes for incrblob mode. (CVS 3903)
FossilOrigin-Name: db54a9466e3bea9c03740ce0b755cfa02bafaccd
2007-05-03 11:43:33 +00:00
drh
b7af4452d9 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
2007-05-02 17:54:55 +00:00
drh
ae7e151a24 More fixes and improvements to the zeroblob() mechanism. (CVS 3900)
FossilOrigin-Name: 83ab25014e890b1cc6ea08ca1ebeeee0078da466
2007-05-02 16:51:59 +00:00
drh
7a928d75f4 Fix an invalid UTF8 encoding in the tests for the trim function. (CVS 3898)
FossilOrigin-Name: 4dbbfff4a7d4be197aac19c80400dafe10dd5e58
2007-05-02 15:36:01 +00:00
drh
fdf972a9ba Add support for zero-blobs to the OP_MakeRecord opcode.
First test cases of zeroblob functionality. (CVS 3897)

FossilOrigin-Name: e6d560ddeeb48fb0cbd9f5a10612280b055baef7
2007-05-02 13:30:27 +00:00
danielk1977
d04417963f Use the pointer-map pages to make the incremental blob API more efficient. (CVS 3896)
FossilOrigin-Name: 93a3bf71d576096f4b5a3db256ca6f9b5521d137
2007-05-02 13:16:30 +00:00
drh
b026e05eb2 Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894)
FossilOrigin-Name: 7a01836dde45098796693bc6cb6045c4059adf1a
2007-05-02 01:34:31 +00:00
shess
290283fe69 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
2007-05-01 18:25:52 +00:00
danielk1977
b4e9af9ff9 First approximation of incremental blob IO API. (CVS 3892)
FossilOrigin-Name: c444836e7b690c16dd6acff571c613a23beb42dc
2007-05-01 17:49:49 +00:00
drh
276fdbfd61 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
2007-04-30 21:39:16 +00:00
danielk1977
b4626a3e16 Add some tests (and 2 resulting bug fixes) to incr vacuum mode. (CVS 3885)
FossilOrigin-Name: 89b1b3f897bda1fffceb9cf72fa4d42b809ccb8e
2007-04-28 15:47:43 +00:00
drh
d1e3a616ca Internationalize the TRIM functions. Ticket #2323. (CVS 3883)
FossilOrigin-Name: ff1f4e744728c8f55afae265246797b30fe98fb0
2007-04-27 21:59:52 +00:00
drh
9310ef23e2 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
2007-04-27 17:16:20 +00:00
danielk1977
ba6d351486 Extra tests for incremental vacuum. (CVS 3879)
FossilOrigin-Name: 40ba6493e9e8ba135552a2a0943ab499713ac001
2007-04-27 07:55:37 +00:00
danielk1977
e5321f0e75 Modifications to btree integrity check so that it can be run inside a transaction after an incr vacuum. (CVS 3878)
FossilOrigin-Name: 4d4180d6474d8d74460fb9333580b9b60c89f353
2007-04-27 07:05:44 +00:00
drh
709cff33dc The replace() function should return NULL if the second argument is an
empty string.  Ticket #2324. (CVS 3877)

FossilOrigin-Name: e6a0c90dd9b4f7efe2153dd0c899b6e3d9846bd8
2007-04-27 01:18:02 +00:00
danielk1977
dddbcdcc68 Add largely untested code for the incremental vacuum function. (CVS 3876)
FossilOrigin-Name: f6a6d2b8872c05089810b1e095f39011f3035408
2007-04-26 14:42:34 +00:00
drh
7a521cfb79 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
2007-04-25 18:23:52 +00:00
drh
0b3d55d4f9 Disable tests in misc7 that do not work on windows due to limitations of
the windows file system. (CVS 3873)

FossilOrigin-Name: 66646d6fda067e19240808aef65fafd8fa177cdd
2007-04-25 15:42:25 +00:00
drh
2824d55a99 Fix a file descriptor leak in the exclusive2 test script. (CVS 3871)
FossilOrigin-Name: 2d2e68da74459340c262a6454fdd05149bc94c59
2007-04-25 12:06:58 +00:00
drh
b556ce15ca Fix duplicate test IDs in the test suite. No changes to code. Ticket #2319. (CVS 3869)
FossilOrigin-Name: 0935cdf82a0be599421881117a981d315933bb7e
2007-04-25 11:32:30 +00:00
drh
e0e11e2df6 Fix a bug in the sqlite3_changes() function reported on the mailing list. (CVS 3868)
FossilOrigin-Name: 58ea768c3e9905bd9db137f1b31dd3dd6c6001d0
2007-04-25 11:28:16 +00:00
drh
309169a118 When the write_version flag in the database header is larger than what
the library understands, make the database read-only.  The old behavior
was to make the database unreadable. (CVS 3866)

FossilOrigin-Name: 10648e99929b4f640855433b6e47702687039286
2007-04-24 17:27:51 +00:00
drh
af30469d67 Get the build working with -DSQLITE_OMIT_UTF16=1. Ticket #2314. (CVS 3865)
FossilOrigin-Name: 25c1c7aaa8ef203120c2c242cf72ce4750f78abd
2007-04-23 23:56:31 +00:00
shess
3b2f10cd8f Fix bug in fts2 handling of OR queries. When one doclist ends before
the other, the code potentially tries to read past the end of the
doclist.  http://www.sqlite.org/cvstrac/tktview?tn=2309 (CVS 3862)

FossilOrigin-Name: dfac6082e8ffc52a85c4906107a7fc0e1aa9df82
2007-04-19 18:36:32 +00:00
drh
5f7b5bf419 Comment changes in the ioerr tests. No changes to code. (CVS 3859)
FossilOrigin-Name: b7ed0e1e88a019c830f56abb14658104a30a1c43
2007-04-19 12:30:54 +00:00
danielk1977
7e29e9561c Fix a bug whereby sqlite3_prepare_v2() could return both an out-of-memory error and a valid statement handle. (CVS 3858)
FossilOrigin-Name: 8795d11c3c5bb39d34bc5194621ce97097a320e7
2007-04-19 11:09:01 +00:00
drh
5ea2df9107 Fix a memory leak introduced by (3842) associated with ticket #2296. (CVS 3848)
FossilOrigin-Name: cdc7608b8d590b2ca19be37f94f2cd17423ba8ac
2007-04-16 17:07:55 +00:00
danielk1977
113e545f45 Add test cases to make sure virtual tables cannot be used in shared-cache mode. (CVS 3847)
FossilOrigin-Name: 66e468adfcf0132e558a666b847ce7c1e024d6fd
2007-04-16 15:49:41 +00:00
danielk1977
a04a34ff1a Ensure sqlite3_finalize() can be called from within the xDisconnect() method of virtual tables. (CVS 3845)
FossilOrigin-Name: 8d6c3bfc4dfdd380a2915d778e256d3e49d22d72
2007-04-16 15:06:25 +00:00
drh
86a88114fa Detect database file changes using a 128-bit segment of the file header
that includes the change counter.  Ticket #2303. (CVS 3844)

FossilOrigin-Name: e44995debf2456e55b502783849e93a045a527c8
2007-04-16 15:02:19 +00:00
drh
94ccde58d0 Match ORDER BY terms to columns using names in compound queries. Make sure
this works for subqueries, especially in the right-hand side of an IN
operator. Ticket #2296. (CVS 3842)

FossilOrigin-Name: cfc6f933dc60ca88ae848f7f0c402e820437c2ff
2007-04-13 16:06:32 +00:00
drh
6558db80c0 Additional tests designed to detect future performance regressions. (CVS 3840)
FossilOrigin-Name: 764e7262b93a7a5073128ecd4db265b0c728a701
2007-04-13 03:23:21 +00:00