1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00

2168 Commits

Author SHA1 Message Date
danielk1977
d8123366c4 (1) Modifications to the user-function interface and (2) Internal changes
to automatically created indices. (CVS 1575)

FossilOrigin-Name: 5903f53828b5d282b33e27813417e4317c9ecf0b
2004-06-12 09:25:12 +00:00
danielk1977
2a764eb0cd Change prototype for busy callbacks to "int xBusy(void *, int);" (CVS 1573)
FossilOrigin-Name: 4f1cfca5ca703d0068cf8d6222dc8e0cfb7e24b6
2004-06-12 01:43:26 +00:00
danielk1977
dc8453fd7a Use the SQLITE_UTF* symbols instead of the old internal TEXT_Utf* symbols. (CVS 1572)
FossilOrigin-Name: 9b84f2f488e1d37ba1a4c4cf31490bcbba0f6edd
2004-06-12 00:42:34 +00:00
danielk1977
ce2663ccc8 Have the vdbe aggregator use a btree table instead of a hash table. (CVS 1569)
FossilOrigin-Name: 8d56118f64dbaf8c8006266fa7026f900a4a16bd
2004-06-11 13:19:21 +00:00
danielk1977
dc1bdc4f9d Fix various collation sequence issues. (CVS 1568)
FossilOrigin-Name: 66835ee67051027456a536e33b2f88a741654525
2004-06-11 10:51:27 +00:00
drh
ff13c7d6a3 If a commit fails due to lock contention right after the COMMIT command, take
the database back out of autocommit mode.  Do not rollback.  This gives the
user the chance to try the COMMIT again. (CVS 1551)

FossilOrigin-Name: 39b4ba95c4a16b28b5e8c7a3331e09cb5796e258
2004-06-09 21:01:11 +00:00
drh
c9e0686ead Turn on the atomic multifile commit logic. It does not work right yet, but
it has at least stopped failing asserts. (CVS 1550)

FossilOrigin-Name: 3674b25edc37145b2b1275dd20580015ace66aa7
2004-06-09 20:03:08 +00:00
danielk1977
0202b29ef7 Some progress on user-defined collation sequences. (CVS 1544)
FossilOrigin-Name: c634e71f1909819fb55c728bc410e5cc390428e3
2004-06-09 09:55:16 +00:00
drh
80242055e5 Start all transactions and verify all schema cookies near the beginning of
of each vdbe program. (CVS 1543)

FossilOrigin-Name: 1086196460e261718e78512d77e25dde021a117d
2004-06-09 00:48:12 +00:00
danielk1977
d02eb1fdf4 Enhance user function API to support association of meta-data with constant
arguments and the specification of text encoding preference. The LIKE
operator takes advantage of both. (CVS 1534)

FossilOrigin-Name: 92337d8f79b9754cd61c73e7db2e792a1f482f50
2004-06-06 09:44:03 +00:00
danielk1977
682f68b020 Add the sqlite3_set_auxdata() and sqlite3_get_auxdata() APIs. (CVS 1532)
FossilOrigin-Name: c2899b437366d879258ab4f6ae47868441010eca
2004-06-05 10:22:17 +00:00
danielk1977
24162fe668 Move the 'busy-callback' logic to the pager layer. (CVS 1527)
FossilOrigin-Name: ff70b6d2b60c143e3ada0606ceff97571998c7e3
2004-06-04 06:22:00 +00:00
danielk1977
13adf8a071 Untested updates to support atomic multi-file transactions (CVS 1526)
FossilOrigin-Name: d57e5252c8baaf615c2cd218a33356ea5d95a5e2
2004-06-03 16:08:41 +00:00
drh
7a224deb5f Work toward combining the OP_MakeKey, OP_MakeIdxKey, and OP_MakeRecord
opcodes into one.  The work is incomplete. (CVS 1524)

FossilOrigin-Name: 165d69a04cca719dec2b042117f848f153721a1d
2004-06-02 01:22:02 +00:00
danielk1977
f20b21c8fd Remove the sqlite3_error_string() API. (CVS 1514)
FossilOrigin-Name: af8e2006d808031a040f293c44f3bfbe841b866b
2004-05-31 23:56:42 +00:00
drh
9c054830b4 Change all SQLITE3 preprocessor macros to SQLITE. Documentation updates. (CVS 1511)
FossilOrigin-Name: adf7e29ff60dc559f64832fadb09f0b9decc0e76
2004-05-31 18:51:57 +00:00
danielk1977
ee5741ea78 Add read-transactions to the btree and vdbe. The compiler doesn't invoke
them yet. (CVS 1502)

FossilOrigin-Name: 6b43633a96c674a5d470578ef80ebf2227da0682
2004-05-31 10:01:34 +00:00
danielk1977
1d850a72c2 Replace OP_Begin, OP_Commit and OP_Rollback with OP_AutoCommit. (CVS 1500)
FossilOrigin-Name: b8ed812c92f2dbb4431d45aeb41646ceb53e0cbc
2004-05-31 08:26:49 +00:00
drh
a19b775db9 Add 3-byte and 6-byte integer serial types. This makes databases smaller
and faster.  Should we go ahead and add 5- and 7-byte integer types too? (CVS 1499)

FossilOrigin-Name: e6685af815c4c0c7f09bb097a59a121862b865cf
2004-05-30 21:14:58 +00:00
drh
e51c44f481 Various speed enhancements. (CVS 1498)
FossilOrigin-Name: a0db15bba64af0c529d5be366659bca1165ff21b
2004-05-30 20:46:09 +00:00
drh
3a41a3fe66 Additional minor speed improvements. (CVS 1496)
FossilOrigin-Name: a90264c0a4c73097fe0ae8933dcebb15b8eaa2bb
2004-05-30 02:14:17 +00:00
danielk1977
0f69c1e3ec Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492)
FossilOrigin-Name: 3225de8902b0e7e60c4d9f3a5ef51bc74f57d364
2004-05-29 11:24:50 +00:00
danielk1977
ef2cb63e9e Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488)
FossilOrigin-Name: 4060a37d0baaa60c50f2dde4a1ab344133fcabbb
2004-05-29 02:37:19 +00:00
drh
51846b56ed Factor common code for generating index keys into a procedure. Other
speed improvements and bug fixes. (CVS 1487)

FossilOrigin-Name: 6661bb5f9c1692f94b8b7d900b6be07f027e6324
2004-05-28 16:00:21 +00:00
danielk1977
cbb18d2256 Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)
FossilOrigin-Name: 4984a130ccf3b8e486941a5d0d0cc70a691f0dac
2004-05-28 11:37:27 +00:00
drh
f3218fea00 Tables and indices use the same record format. (CVS 1481)
FossilOrigin-Name: ebd564d10b0ecd7ff15cbd6cd2b979c9f767476c
2004-05-28 08:21:02 +00:00
drh
25aa1b4580 Remove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit
version of sqlite3GetVarint for schema-level parameters. (CVS 1480)

FossilOrigin-Name: 321f8c463520e99681de878b743027c570b73e35
2004-05-28 01:39:01 +00:00
drh
d3194f5a4a Change the record format to include an extra varint at the beginning to record the number of bytes in the header. (CVS 1478)
FossilOrigin-Name: 0c4d138807f367d75b3fb5b2dadf206df725659f
2004-05-27 19:59:32 +00:00
drh
5f3b4ab53c Remove the COPY command. (CVS 1477)
FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43
2004-05-27 17:22:54 +00:00
danielk1977
c572ef7fcd Various bugfixes. 68 Test cases still fail. (CVS 1471)
FossilOrigin-Name: 67a140cf78d99e38ccd94751c4f8ead1a2b96859
2004-05-27 09:28:41 +00:00
drh
f44795013f Fixes to the MEM changes. The library now links. (CVS 1470)
FossilOrigin-Name: f33d15d95f195e26e1ef396158597a2caa06f374
2004-05-27 03:12:53 +00:00
drh
eb2e176a12 More MEM changes in the vdbe.c. Still will not compile. (CVS 1469)
FossilOrigin-Name: dbdd1a7f316e576d0611748ec63c9ef00d4c10db
2004-05-27 01:53:56 +00:00
drh
4f26d6c429 Refactoring of the vdbe Mem functions and the APIs that deal with them.
The code will not compile in its current state. (CVS 1465)

FossilOrigin-Name: bba6684d502ba1ecd9614d2470ec94296e3c07c2
2004-05-26 23:25:30 +00:00
drh
f9b596ebc0 Remove dataType and includeTypes flags from function definitions. Added new
P3_FUNCDEF type for P3 arguments on opcodes.  Fixes to several user functions.
28 tests fail now. (CVS 1464)

FossilOrigin-Name: 36e031625995b2f7baf7654d771ca8fb764a0085
2004-05-26 16:54:42 +00:00
danielk1977
b77f5dadbf Ensure the type of an sqlite3_value* is not modified by calls to
sqlite3_value_*() calls. (CVS 1463)

FossilOrigin-Name: ce8b15203413f38a8b7127eb08ae5db1c1eb164a
2004-05-26 13:27:00 +00:00
danielk1977
3cf8606395 Add some tests for the new API. Many more to come. (CVS 1462)
FossilOrigin-Name: d5659f2ee6788e0205fb5e03eeaf64e6c0aa9bed
2004-05-26 10:11:05 +00:00
danielk1977
6590493d53 Use the new form of the sqlite3_create_function() API. (CVS 1460)
FossilOrigin-Name: 0317bef4b0c219ca2888c90553201e53230fb360
2004-05-26 06:18:37 +00:00
danielk1977
fc57d7bf72 Use the new API calls more consistently. (CVS 1459)
FossilOrigin-Name: 17e7db488dac6b30d174f2272edf1046c2bb9990
2004-05-26 02:04:57 +00:00
danielk1977
17240fd90f More changes to do with the new sqlite3_step() API. (CVS 1458)
FossilOrigin-Name: e83138250ce0a8caacbd1822eec2e06796d2f5f2
2004-05-26 00:07:25 +00:00
danielk1977
22322fd42b Move the sqlite3_exec() function to legacy.c. (CVS 1455)
FossilOrigin-Name: 9385ad5ca82c82d9ef699102ca0b53661d02a052
2004-05-25 23:35:17 +00:00
danielk1977
7e18c259fe Use the new API for returning values and errors from user functions. (CVS 1453)
FossilOrigin-Name: 4eccae03b4a7f37804fea30416579787c3584bb2
2004-05-25 11:47:24 +00:00
danielk1977
6ddcca553d Aggregate functions also use sqlite_value* instead of const char * for
arguments. (CVS 1451)

FossilOrigin-Name: 5c28ed5e9b5a3ecb3081ce0c5c9450d6ae8dc77d
2004-05-24 23:48:25 +00:00
danielk1977
51ad0ecd28 Non-aggregate SQL functions use sqlite_value* instead of const char * for
argument values. (CVS 1449)

FossilOrigin-Name: 1e47d7384d5fdfceb6ec737c656f70be59ba5b01
2004-05-24 12:39:02 +00:00
danielk1977
7e435458a0 Fix typo in vdbe.c from previous commit. (CVS 1448)
FossilOrigin-Name: a554bf6c7075839f760a2ff944ac61b32cab0821
2004-05-24 09:15:39 +00:00
danielk1977
0ffba6b269 Add the sqlite3_value_*() access functions. (CVS 1447)
FossilOrigin-Name: 4bf925fcfccb18e66be031f8a234f370d581e9ea
2004-05-24 09:10:10 +00:00
danielk1977
bd7e46086e Fix for retrieving UTF-16 little-endian text from a big-endian database. (CVS 1446)
FossilOrigin-Name: 8104baf23dd28fc982cf260e3e8c90f0c582f602
2004-05-24 07:34:48 +00:00
danielk1977
8a6b5411b3 Have the vdbe handle strings in the same encoding as the database. (CVS 1445)
FossilOrigin-Name: b7155db2b13aa3ca5f6c68e948d9e8740ebcac47
2004-05-24 07:04:25 +00:00
danielk1977
93d4675d67 Begin changing the vdbe so all stack values use the database encoding. (CVS 1444)
FossilOrigin-Name: f47de3a933b51b37629a0ca2e492a534a12e7339
2004-05-23 13:30:58 +00:00
drh
7906975a0f Remove the OP_SetInsert opcode. (CVS 1443)
FossilOrigin-Name: 18e690e405710c9a8010340c01754bbfa3231fe9
2004-05-22 21:30:40 +00:00
drh
60ca804396 Bug fix in vdbe.c - variable declarations must come before code in ANSI C. (CVS 1440)
FossilOrigin-Name: c36203de22f673691783529e06ce5a58bcebeedc
2004-05-22 11:09:30 +00:00