]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
21 years agoAdd 3-byte and 6-byte integer serial types. This makes databases smaller
drh [Sun, 30 May 2004 21:14:58 +0000 (21:14 +0000)] 
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

21 years agoVarious speed enhancements. (CVS 1498)
drh [Sun, 30 May 2004 20:46:09 +0000 (20:46 +0000)] 
Various speed enhancements. (CVS 1498)

FossilOrigin-Name: a0db15bba64af0c529d5be366659bca1165ff21b

21 years agoImproved comments and speed tweaks to btree.c. (CVS 1497)
drh [Sun, 30 May 2004 19:19:05 +0000 (19:19 +0000)] 
Improved comments and speed tweaks to btree.c. (CVS 1497)

FossilOrigin-Name: c86b7c065a798cd108189b96e87d100115862ff2

21 years agoAdditional minor speed improvements. (CVS 1496)
drh [Sun, 30 May 2004 02:14:17 +0000 (02:14 +0000)] 
Additional minor speed improvements. (CVS 1496)

FossilOrigin-Name: a90264c0a4c73097fe0ae8933dcebb15b8eaa2bb

21 years agoFaster version of sqlite3VdbeSerialGet. (CVS 1495)
drh [Sun, 30 May 2004 01:51:52 +0000 (01:51 +0000)] 
Faster version of sqlite3VdbeSerialGet. (CVS 1495)

FossilOrigin-Name: 80985505fe8ba8e505842dae95d37bf412fc586d

21 years agoDo not include the P3 parameter on OP_Integer opcodes if the integer will fit
drh [Sun, 30 May 2004 01:38:43 +0000 (01:38 +0000)] 
Do not include the P3 parameter on OP_Integer opcodes if the integer will fit
in 32 bits.  The P3 conversion is slow. (CVS 1494)

FossilOrigin-Name: fcd84ebabca72023e76e6954514948aa9a3ab999

21 years agoA file format change for btree.c makes it between 10 and 20% faster. (CVS 1493)
drh [Sat, 29 May 2004 21:46:49 +0000 (21:46 +0000)] 
A file format change for btree.c makes it between 10 and 20% faster. (CVS 1493)

FossilOrigin-Name: cbcaece7f45a0bc994e6c54a996afa4e6529da6a

21 years agoTransform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they...
danielk1977 [Sat, 29 May 2004 11:24:50 +0000 (11:24 +0000)] 
Transform OP_HexBlob and OP_String8 to OP_Blob and OP_String the first time they are executed. (CVS 1492)

FossilOrigin-Name: 3225de8902b0e7e60c4d9f3a5ef51bc74f57d364

21 years agoEnsure vacuum handles table names with spaces in them. (CVS 1491)
danielk1977 [Sat, 29 May 2004 10:43:06 +0000 (10:43 +0000)] 
Ensure vacuum handles table names with spaces in them. (CVS 1491)

FossilOrigin-Name: 0a6689be843e695902fbfef863f128915545499e

21 years agoFix vacuum so that it works with blobs. (CVS 1490)
danielk1977 [Sat, 29 May 2004 10:23:19 +0000 (10:23 +0000)] 
Fix vacuum so that it works with blobs. (CVS 1490)

FossilOrigin-Name: 4feb4b9a71ce7a92924d2358a7ccecb4cca19223

21 years agoAvoid arithmetic on void pointers. (CVS 1489)
danielk1977 [Sat, 29 May 2004 02:44:02 +0000 (02:44 +0000)] 
Avoid arithmetic on void pointers. (CVS 1489)

FossilOrigin-Name: 3d68703e2e4e793012cb3c13a6744e915475e006

21 years agoAllow CREATE and DROP TRIGGER on attached databases. (CVS 1488)
danielk1977 [Sat, 29 May 2004 02:37:19 +0000 (02:37 +0000)] 
Allow CREATE and DROP TRIGGER on attached databases. (CVS 1488)

FossilOrigin-Name: 4060a37d0baaa60c50f2dde4a1ab344133fcabbb

21 years agoFactor common code for generating index keys into a procedure. Other
drh [Fri, 28 May 2004 16:00:21 +0000 (16:00 +0000)] 
Factor common code for generating index keys into a procedure.  Other
speed improvements and bug fixes. (CVS 1487)

FossilOrigin-Name: 6661bb5f9c1692f94b8b7d900b6be07f027e6324

21 years agoFix a bug in the sqlite3_column_decltype() API. (CVS 1486)
danielk1977 [Fri, 28 May 2004 13:13:02 +0000 (13:13 +0000)] 
Fix a bug in the sqlite3_column_decltype() API. (CVS 1486)

FossilOrigin-Name: c8a40218c20cf5d0abad330e8fa59ca4c36e7608

21 years agoAllow CREATE and DROP VIEW on attached databases. (CVS 1485)
danielk1977 [Fri, 28 May 2004 12:33:30 +0000 (12:33 +0000)] 
Allow CREATE and DROP VIEW on attached databases. (CVS 1485)

FossilOrigin-Name: ad879a957d93c0b49c289947826b451d3ea37e5b

21 years agoAllow DROP TABLE and DROP INDEX on attached databases. (CVS 1484)
danielk1977 [Fri, 28 May 2004 12:11:21 +0000 (12:11 +0000)] 
Allow DROP TABLE and DROP INDEX on attached databases. (CVS 1484)

FossilOrigin-Name: 2fb3708e10a06660ad1974ef8e9742b706a0a9fc

21 years agoAllow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)
danielk1977 [Fri, 28 May 2004 11:37:27 +0000 (11:37 +0000)] 
Allow CREATE TABLE and CREATE INDEX on attached databases. (CVS 1483)

FossilOrigin-Name: 4984a130ccf3b8e486941a5d0d0cc70a691f0dac

21 years agoTables and indices use the same record format. (CVS 1482)
drh [Fri, 28 May 2004 08:21:05 +0000 (08:21 +0000)] 
Tables and indices use the same record format. (CVS 1482)

FossilOrigin-Name: 1b15b32bdbccae555243e67aa011139c50dc2fb3

21 years agoTables and indices use the same record format. (CVS 1481)
drh [Fri, 28 May 2004 08:21:02 +0000 (08:21 +0000)] 
Tables and indices use the same record format. (CVS 1481)

FossilOrigin-Name: ebd564d10b0ecd7ff15cbd6cd2b979c9f767476c

21 years agoRemove the encoding argument from sqlite3VdbeSerialGet. Use the 32-bit
drh [Fri, 28 May 2004 01:39:01 +0000 (01:39 +0000)] 
Remove the encoding argument from sqlite3VdbeSerialGet.  Use the 32-bit
version of sqlite3GetVarint for schema-level parameters. (CVS 1480)

FossilOrigin-Name: 321f8c463520e99681de878b743027c570b73e35

21 years agoAdd API functions sqlite3_open_varargs(), sqlite3_open16_varargs() and
danielk1977 [Thu, 27 May 2004 23:56:16 +0000 (23:56 +0000)] 
Add API functions sqlite3_open_varargs(), sqlite3_open16_varargs() and
sqlite3_complete16(). (CVS 1479)

FossilOrigin-Name: 203af2b2e3a25f4fe0e128e350c21834cad0bd7f

21 years agoChange the record format to include an extra varint at the beginning to record the...
drh [Thu, 27 May 2004 19:59:32 +0000 (19:59 +0000)] 
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

21 years agoRemove the COPY command. (CVS 1477)
drh [Thu, 27 May 2004 17:22:54 +0000 (17:22 +0000)] 
Remove the COPY command. (CVS 1477)

FossilOrigin-Name: 287f86731c71401dbac098e08357367b4f8e5a43

21 years agoEnhance the C function used to test sqlite3_create_function() from Tcl. (CVS 1476)
danielk1977 [Thu, 27 May 2004 14:23:36 +0000 (14:23 +0000)] 
Enhance the C function used to test sqlite3_create_function() from Tcl. (CVS 1476)

FossilOrigin-Name: c85e5f1528d098ea330ed0cf7e3c01cf9be93c10

21 years agoTest sqlite3_bind_blob(). (CVS 1475)
danielk1977 [Thu, 27 May 2004 13:55:27 +0000 (13:55 +0000)] 
Test sqlite3_bind_blob(). (CVS 1475)

FossilOrigin-Name: 42247b2fb0c94e75a432b3e067fff9a1be328fc8

21 years agoA couple of test cases and fixes for blob literals. (CVS 1474)
danielk1977 [Thu, 27 May 2004 13:35:19 +0000 (13:35 +0000)] 
A couple of test cases and fixes for blob literals. (CVS 1474)

FossilOrigin-Name: 6d552af67cf6fa6935373ba39de5c47ebf613eb9

21 years agoAlter the Tcl eval sub-command so that it supports blobs. (CVS 1473)
danielk1977 [Thu, 27 May 2004 12:11:31 +0000 (12:11 +0000)] 
Alter the Tcl eval sub-command so that it supports blobs. (CVS 1473)

FossilOrigin-Name: b5d5f0ad717ef43a9714dd1cc40e20d1b94a3e58

21 years agoA few more bugfixes. Test cases pass now. (CVS 1472)
danielk1977 [Thu, 27 May 2004 10:30:52 +0000 (10:30 +0000)] 
A few more bugfixes. Test cases pass now. (CVS 1472)

FossilOrigin-Name: c9e3015faffb650d8dbf1f7f95a7057a36361bac

21 years agoVarious bugfixes. 68 Test cases still fail. (CVS 1471)
danielk1977 [Thu, 27 May 2004 09:28:41 +0000 (09:28 +0000)] 
Various bugfixes. 68 Test cases still fail. (CVS 1471)

FossilOrigin-Name: 67a140cf78d99e38ccd94751c4f8ead1a2b96859

21 years agoFixes to the MEM changes. The library now links. (CVS 1470)
drh [Thu, 27 May 2004 03:12:53 +0000 (03:12 +0000)] 
Fixes to the MEM changes.  The library now links. (CVS 1470)

FossilOrigin-Name: f33d15d95f195e26e1ef396158597a2caa06f374

21 years agoMore MEM changes in the vdbe.c. Still will not compile. (CVS 1469)
drh [Thu, 27 May 2004 01:53:56 +0000 (01:53 +0000)] 
More MEM changes in the vdbe.c.  Still will not compile. (CVS 1469)

FossilOrigin-Name: dbdd1a7f316e576d0611748ec63c9ef00d4c10db

21 years agoMore test cases for the new query API. (CVS 1468)
danielk1977 [Thu, 27 May 2004 01:49:51 +0000 (01:49 +0000)] 
More test cases for the new query API. (CVS 1468)

FossilOrigin-Name: 74097ecdb0b1e0eec143c5a3f8ca2f0d63d6f38d

21 years agoAdd TCL test bindings and some more test cases for the new query API. (CVS 1467)
danielk1977 [Thu, 27 May 2004 01:04:07 +0000 (01:04 +0000)] 
Add TCL test bindings and some more test cases for the new query API. (CVS 1467)

FossilOrigin-Name: d72adf0c522b442d5e1663862bdd639c282d4495

21 years agoBreak Mem.flags into Mem.type and Mem.enc. (CVS 1466)
drh [Wed, 26 May 2004 23:43:11 +0000 (23:43 +0000)] 
Break Mem.flags into Mem.type and Mem.enc. (CVS 1466)

FossilOrigin-Name: 68ef17028621681f5d091e77d5df84f663a15e27

21 years agoRefactoring of the vdbe Mem functions and the APIs that deal with them.
drh [Wed, 26 May 2004 23:25:30 +0000 (23:25 +0000)] 
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

21 years agoRemove dataType and includeTypes flags from function definitions. Added new
drh [Wed, 26 May 2004 16:54:42 +0000 (16:54 +0000)] 
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

21 years agoEnsure the type of an sqlite3_value* is not modified by calls to
danielk1977 [Wed, 26 May 2004 13:27:00 +0000 (13:27 +0000)] 
Ensure the type of an sqlite3_value* is not modified by calls to
sqlite3_value_*() calls. (CVS 1463)

FossilOrigin-Name: ce8b15203413f38a8b7127eb08ae5db1c1eb164a

21 years agoAdd some tests for the new API. Many more to come. (CVS 1462)
danielk1977 [Wed, 26 May 2004 10:11:05 +0000 (10:11 +0000)] 
Add some tests for the new API. Many more to come. (CVS 1462)

FossilOrigin-Name: d5659f2ee6788e0205fb5e03eeaf64e6c0aa9bed

21 years agoRemove the show_datatypes pragma. (CVS 1461)
danielk1977 [Wed, 26 May 2004 06:58:43 +0000 (06:58 +0000)] 
Remove the show_datatypes pragma. (CVS 1461)

FossilOrigin-Name: 93bb958d939302795027f738b8f663cbce3e8783

21 years agoUse the new form of the sqlite3_create_function() API. (CVS 1460)
danielk1977 [Wed, 26 May 2004 06:18:37 +0000 (06:18 +0000)] 
Use the new form of the sqlite3_create_function() API. (CVS 1460)

FossilOrigin-Name: 0317bef4b0c219ca2888c90553201e53230fb360

21 years agoUse the new API calls more consistently. (CVS 1459)
danielk1977 [Wed, 26 May 2004 02:04:57 +0000 (02:04 +0000)] 
Use the new API calls more consistently. (CVS 1459)

FossilOrigin-Name: 17e7db488dac6b30d174f2272edf1046c2bb9990

21 years agoMore changes to do with the new sqlite3_step() API. (CVS 1458)
danielk1977 [Wed, 26 May 2004 00:07:25 +0000 (00:07 +0000)] 
More changes to do with the new sqlite3_step() API. (CVS 1458)

FossilOrigin-Name: e83138250ce0a8caacbd1822eec2e06796d2f5f2

21 years agoMinor code fixes in btree.c and pragma.c to help with watcom C. (CVS 1457)
drh [Wed, 26 May 2004 00:01:53 +0000 (00:01 +0000)] 
Minor code fixes in btree.c and pragma.c to help with watcom C. (CVS 1457)

FossilOrigin-Name: 143c502a59e727975f61c8d13b6c5a90dad038f3

21 years agoAdd file legacy.c with old APIs. (CVS 1456)
danielk1977 [Wed, 26 May 2004 00:01:35 +0000 (00:01 +0000)] 
Add file legacy.c with old APIs. (CVS 1456)

FossilOrigin-Name: ae18fcb7ad91096f8029605b54d71ec225f31f32

21 years agoMove the sqlite3_exec() function to legacy.c. (CVS 1455)
danielk1977 [Tue, 25 May 2004 23:35:17 +0000 (23:35 +0000)] 
Move the sqlite3_exec() function to legacy.c. (CVS 1455)

FossilOrigin-Name: 9385ad5ca82c82d9ef699102ca0b53661d02a052

21 years agoChange a couple of symbol names for the new user function API. (CVS 1454)
danielk1977 [Tue, 25 May 2004 12:05:56 +0000 (12:05 +0000)] 
Change a couple of symbol names for the new user function API. (CVS 1454)

FossilOrigin-Name: 8f6b20c2938ded7ab9e400494c02370ecf7e9311

21 years agoUse the new API for returning values and errors from user functions. (CVS 1453)
danielk1977 [Tue, 25 May 2004 11:47:24 +0000 (11:47 +0000)] 
Use the new API for returning values and errors from user functions. (CVS 1453)

FossilOrigin-Name: 4eccae03b4a7f37804fea30416579787c3584bb2

21 years agoAdd manifest type aware versions of the min() and max() aggregates. (CVS 1452)
danielk1977 [Tue, 25 May 2004 01:13:20 +0000 (01:13 +0000)] 
Add manifest type aware versions of the min() and max() aggregates. (CVS 1452)

FossilOrigin-Name: b77c268ebebd5401c3f519a72cfb81438207368c

21 years agoAggregate functions also use sqlite_value* instead of const char * for
danielk1977 [Mon, 24 May 2004 23:48:25 +0000 (23:48 +0000)] 
Aggregate functions also use sqlite_value* instead of const char * for
arguments. (CVS 1451)

FossilOrigin-Name: 5c28ed5e9b5a3ecb3081ce0c5c9450d6ae8dc77d

21 years agoUpdate the typeof() operator to respect manifest types. (CVS 1450)
danielk1977 [Mon, 24 May 2004 12:55:54 +0000 (12:55 +0000)] 
Update the typeof() operator to respect manifest types. (CVS 1450)

FossilOrigin-Name: 162cf42e33691f4c9ec3a25abcaa2bdcdca2b5e0

21 years agoNon-aggregate SQL functions use sqlite_value* instead of const char * for
danielk1977 [Mon, 24 May 2004 12:39:02 +0000 (12:39 +0000)] 
Non-aggregate SQL functions use sqlite_value* instead of const char * for
argument values. (CVS 1449)

FossilOrigin-Name: 1e47d7384d5fdfceb6ec737c656f70be59ba5b01

21 years agoFix typo in vdbe.c from previous commit. (CVS 1448)
danielk1977 [Mon, 24 May 2004 09:15:39 +0000 (09:15 +0000)] 
Fix typo in vdbe.c from previous commit. (CVS 1448)

FossilOrigin-Name: a554bf6c7075839f760a2ff944ac61b32cab0821

21 years agoAdd the sqlite3_value_*() access functions. (CVS 1447)
danielk1977 [Mon, 24 May 2004 09:10:10 +0000 (09:10 +0000)] 
Add the sqlite3_value_*() access functions. (CVS 1447)

FossilOrigin-Name: 4bf925fcfccb18e66be031f8a234f370d581e9ea

21 years agoFix for retrieving UTF-16 little-endian text from a big-endian database. (CVS 1446)
danielk1977 [Mon, 24 May 2004 07:34:48 +0000 (07:34 +0000)] 
Fix for retrieving UTF-16 little-endian text from a big-endian database. (CVS 1446)

FossilOrigin-Name: 8104baf23dd28fc982cf260e3e8c90f0c582f602

21 years agoHave the vdbe handle strings in the same encoding as the database. (CVS 1445)
danielk1977 [Mon, 24 May 2004 07:04:25 +0000 (07:04 +0000)] 
Have the vdbe handle strings in the same encoding as the database. (CVS 1445)

FossilOrigin-Name: b7155db2b13aa3ca5f6c68e948d9e8740ebcac47

21 years agoBegin changing the vdbe so all stack values use the database encoding. (CVS 1444)
danielk1977 [Sun, 23 May 2004 13:30:58 +0000 (13:30 +0000)] 
Begin changing the vdbe so all stack values use the database encoding. (CVS 1444)

FossilOrigin-Name: f47de3a933b51b37629a0ca2e492a534a12e7339

21 years agoRemove the OP_SetInsert opcode. (CVS 1443)
drh [Sat, 22 May 2004 21:30:40 +0000 (21:30 +0000)] 
Remove the OP_SetInsert opcode. (CVS 1443)

FossilOrigin-Name: 18e690e405710c9a8010340c01754bbfa3231fe9

21 years agoMove btree_rb.c into the attic. (CVS 1442)
drh [Sat, 22 May 2004 17:46:37 +0000 (17:46 +0000)] 
Move btree_rb.c into the attic. (CVS 1442)

FossilOrigin-Name: 4159ef235d780ec941677439e77c6fa96e24997c

21 years agoSplit up os.c into separate files, one for each platform. (CVS 1441)
drh [Sat, 22 May 2004 17:41:58 +0000 (17:41 +0000)] 
Split up os.c into separate files, one for each platform. (CVS 1441)

FossilOrigin-Name: 5c61be1c47ac960fba2a642e69a98436ce1cd725

21 years agoBug fix in vdbe.c - variable declarations must come before code in ANSI C. (CVS 1440)
drh [Sat, 22 May 2004 11:09:30 +0000 (11:09 +0000)] 
Bug fix in vdbe.c - variable declarations must come before code in ANSI C. (CVS 1440)

FossilOrigin-Name: c36203de22f673691783529e06ce5a58bcebeedc

21 years agoAdd a couple of tests for UTF-16 databases. (CVS 1439)
danielk1977 [Sat, 22 May 2004 10:33:04 +0000 (10:33 +0000)] 
Add a couple of tests for UTF-16 databases. (CVS 1439)

FossilOrigin-Name: 891be63a92097384e1b00993d35f002048c4b42e

21 years agoAdd a couple of tests for UTF-16 databases. (CVS 1438)
danielk1977 [Sat, 22 May 2004 10:33:04 +0000 (10:33 +0000)] 
Add a couple of tests for UTF-16 databases. (CVS 1438)

FossilOrigin-Name: d7551df8c32c4981d94eb57cd2a999592e91f50f

21 years agoUse the new form of the sqlite3_open() API everywhere. (CVS 1437)
danielk1977 [Sat, 22 May 2004 09:21:21 +0000 (09:21 +0000)] 
Use the new form of the sqlite3_open() API everywhere. (CVS 1437)

FossilOrigin-Name: b449217318ade3196757bef8aaf7302634f0f9b6

21 years agoTests for the functions in utf.c. (CVS 1436)
danielk1977 [Sat, 22 May 2004 08:16:11 +0000 (08:16 +0000)] 
Tests for the functions in utf.c. (CVS 1436)

FossilOrigin-Name: 802d65affcafffda33e2ff1cbd4e4869dc3814df

21 years agoStore the text encoding in the database (as meta value 4). (CVS 1435)
danielk1977 [Sat, 22 May 2004 08:09:11 +0000 (08:09 +0000)] 
Store the text encoding in the database (as meta value 4). (CVS 1435)

FossilOrigin-Name: 7f00ca5801889724c0e768961aa15f5ce0b8e7b5

21 years agoA few bugfixes related to UTF-16 databases. sqlite3_open() still assumes a
danielk1977 [Sat, 22 May 2004 07:27:46 +0000 (07:27 +0000)] 
A few bugfixes related to UTF-16 databases. sqlite3_open() still assumes a
UTF-8 database, and sqlite3_open16() still assumes a UTF-16 db. (CVS 1434)

FossilOrigin-Name: b3581d2796c8cb6581b7156774698a05fc8f800e

21 years agoSteps towards UTF-16 databases. Some tests are failing because of this
danielk1977 [Sat, 22 May 2004 03:05:33 +0000 (03:05 +0000)] 
Steps towards UTF-16 databases. Some tests are failing because of this
commit. (CVS 1433)

FossilOrigin-Name: c4a8246864eee7cb993ab7b703324d92c284d72a

21 years agoUpdate comments and remove dead code from btree.c (CVS 1432)
drh [Sat, 22 May 2004 02:55:23 +0000 (02:55 +0000)] 
Update comments and remove dead code from btree.c (CVS 1432)

FossilOrigin-Name: 8069caca82bc4d40d8ac95bafdd91a18a70ab1e0

21 years agoFloating point values are serialized in big-endian byte order. (CVS 1431)
drh [Fri, 21 May 2004 21:12:42 +0000 (21:12 +0000)] 
Floating point values are serialized in big-endian byte order. (CVS 1431)

FossilOrigin-Name: acb65297b69c531813287166175fa7864c900fe6

21 years agoRemove the OP_SetFound opcode and its cousins. (CVS 1430)
drh [Fri, 21 May 2004 13:39:50 +0000 (13:39 +0000)] 
Remove the OP_SetFound opcode and its cousins. (CVS 1430)

FossilOrigin-Name: 5524075ec02102446f8d153e068546f763d4bf7a

21 years agoEliminate some unused code (CVS 1429)
danielk1977 [Fri, 21 May 2004 11:39:05 +0000 (11:39 +0000)] 
Eliminate some unused code (CVS 1429)

FossilOrigin-Name: 550a53b3f28ddb288bcb6c21849ca83b0a20bde4

21 years agoPretty-print blobs in vdbe-traces. (CVS 1428)
danielk1977 [Fri, 21 May 2004 10:49:47 +0000 (10:49 +0000)] 
Pretty-print blobs in vdbe-traces. (CVS 1428)

FossilOrigin-Name: 5eb94c97657b34ed2df6455e23875e2840743bda

21 years agoFurther work on the new API. All the functions to execute queries are there
danielk1977 [Fri, 21 May 2004 10:08:53 +0000 (10:08 +0000)] 
Further work on the new API. All the functions to execute queries are there
now. (CVS 1427)

FossilOrigin-Name: fc94575d77f9865e1553bb70c2e3eda2a0b8669e

21 years agoEliminate the OP_SortMakeRec and OP_SortCallback opcodes. Sort using the
drh [Fri, 21 May 2004 03:01:58 +0000 (03:01 +0000)] 
Eliminate the OP_SortMakeRec and OP_SortCallback opcodes.  Sort using the
standard record format. (CVS 1426)

FossilOrigin-Name: 25643a0137d395572f16cfec3ab3327d913138ba

21 years agoMost sorting problems are fixed. Dead code has been removed. 3 test failures
drh [Fri, 21 May 2004 02:14:24 +0000 (02:14 +0000)] 
Most sorting problems are fixed.  Dead code has been removed.  3 test failures
remain but will be fixed by the new function API once it gets implemented. (CVS 1425)

FossilOrigin-Name: 3b55095e036d68886d007239333bbf90acd15692

21 years agoFix typo in bind.test that was causing a seg-fault. (CVS 1424)
danielk1977 [Fri, 21 May 2004 02:11:40 +0000 (02:11 +0000)] 
Fix typo in bind.test that was causing a seg-fault. (CVS 1424)

FossilOrigin-Name: d1af1a4acce77b87367049da93b13746b743e831

21 years agoAdd new sqlite3_open() and sqlite3_open16() APIs. (CVS 1423)
danielk1977 [Fri, 21 May 2004 01:47:26 +0000 (01:47 +0000)] 
Add new sqlite3_open() and sqlite3_open16() APIs. (CVS 1423)

FossilOrigin-Name: 307b55006c401f10ec5fa5b12cc7d5ba860f9a46

21 years agoSorting bug fixes. Now only 17 tests fail. (CVS 1422)
drh [Fri, 21 May 2004 01:29:06 +0000 (01:29 +0000)] 
Sorting bug fixes.  Now only 17 tests fail. (CVS 1422)

FossilOrigin-Name: 0736b7e8401f587f8b412602d029ef9bd69425f6

21 years agoFix a bug that prevented sorting by index. Down to 162 failed tests. (CVS 1421)
drh [Thu, 20 May 2004 23:37:54 +0000 (23:37 +0000)] 
Fix a bug that prevented sorting by index.  Down to 162 failed tests. (CVS 1421)

FossilOrigin-Name: b032b646b72a03e828d732ac22192f992904d79f

21 years agoAdd internal support for collating sequences. This breaks 244 tests. (CVS 1420)
drh [Thu, 20 May 2004 22:16:29 +0000 (22:16 +0000)] 
Add internal support for collating sequences.  This breaks 244 tests. (CVS 1420)

FossilOrigin-Name: a6cb09d7af537726acc87b9133f68c81e839e047

21 years agosqlite3MemCompare now takes a CollSeq* argument. (CVS 1419)
drh [Thu, 20 May 2004 13:54:53 +0000 (13:54 +0000)] 
sqlite3MemCompare now takes a CollSeq* argument. (CVS 1419)

FossilOrigin-Name: 5c1e47a25244eacc69b688f5f4e62cec9f09665a

21 years agoFix problems with types and the recognition of BLOB as having no affinity. (CVS 1418)
drh [Thu, 20 May 2004 12:41:19 +0000 (12:41 +0000)] 
Fix problems with types and the recognition of BLOB as having no affinity. (CVS 1418)

FossilOrigin-Name: 8411718f0ac17e9c2376fdf8b5fa0cc5fc88be9b

21 years agoDefault type affinity is now NUMERIC. The affinity.html file checked into
drh [Thu, 20 May 2004 12:10:20 +0000 (12:10 +0000)] 
Default type affinity is now NUMERIC.  The affinity.html file checked into
the doc directory. (CVS 1417)

FossilOrigin-Name: 948307f07d6f8cc1cc186167ff7aaa5dfd5d8a2e

21 years agoAdd some more elements of the new API. (CVS 1416)
danielk1977 [Thu, 20 May 2004 11:00:52 +0000 (11:00 +0000)] 
Add some more elements of the new API. (CVS 1416)

FossilOrigin-Name: 2821767b947ae1a70e98dd7f47d69e424c37947f

21 years agoFix the misc3.test test file. (CVS 1415)
drh [Thu, 20 May 2004 03:30:10 +0000 (03:30 +0000)] 
Fix the misc3.test test file. (CVS 1415)

FossilOrigin-Name: 478836f44825d8154c0106e46e9a2b2daaa4cf33

21 years agoBug fix associated with misc3.test. (CVS 1414)
drh [Thu, 20 May 2004 03:02:47 +0000 (03:02 +0000)] 
Bug fix associated with misc3.test. (CVS 1414)

FossilOrigin-Name: a7f02db73881eb2d899daa93646962960dac5375

21 years agoBug fix associated with OP_SetNumColumns in insert.c. Also changed a
drh [Thu, 20 May 2004 02:42:16 +0000 (02:42 +0000)] 
Bug fix associated with OP_SetNumColumns in insert.c.  Also changed a
variable name in OP_Column. (CVS 1413)

FossilOrigin-Name: bf2181f13fdad72d8c90eccc2d29034178181731

21 years agoVACUUM works again. (CVS 1412)
drh [Thu, 20 May 2004 02:01:26 +0000 (02:01 +0000)] 
VACUUM works again. (CVS 1412)

FossilOrigin-Name: c4e1d02ffded1421c09b0c8e45954e69f3583297

21 years agoAdd some comments for sqlite3_bind_*() APIs. (CVS 1411)
danielk1977 [Thu, 20 May 2004 01:40:18 +0000 (01:40 +0000)] 
Add some comments for sqlite3_bind_*() APIs. (CVS 1411)

FossilOrigin-Name: 46b0942239dde9982abaaa7f77d5cf8375eb4209

21 years agoAdd support for the new sqlite3_bind_*() APIs. (CVS 1410)
danielk1977 [Thu, 20 May 2004 01:12:34 +0000 (01:12 +0000)] 
Add support for the new sqlite3_bind_*() APIs. (CVS 1410)

FossilOrigin-Name: e8f980d842fcd793552acd32708db55c8f014634

21 years agoGet more tests running. (CVS 1409)
drh [Wed, 19 May 2004 21:09:31 +0000 (21:09 +0000)] 
Get more tests running. (CVS 1409)

FossilOrigin-Name: 7eb3f29e305d0f455f6544560c567fa6b6e24986

21 years agoCorrectly handle 64-bit integers in SQL statements. (CVS 1408)
drh [Wed, 19 May 2004 20:41:03 +0000 (20:41 +0000)] 
Correctly handle 64-bit integers in SQL statements. (CVS 1408)

FossilOrigin-Name: 34f03ba6a9d6e2144d0c6cbbbeb37b4c69705f1f

21 years agoChange opcode names and comments to better describe the operation of
drh [Wed, 19 May 2004 14:56:55 +0000 (14:56 +0000)] 
Change opcode names and comments to better describe the operation of
the incrKey flag.  OP_MoveTo becomes OP_MoveGe. (CVS 1407)

FossilOrigin-Name: 8f249c45cbc77f4320798ff1a830b55e5c74888a

21 years agoBug fixes in where.c. The where.test test works again. (CVS 1406)
drh [Wed, 19 May 2004 13:13:08 +0000 (13:13 +0000)] 
Bug fixes in where.c.  The where.test test works again. (CVS 1406)

FossilOrigin-Name: 7c31e257e2d109bfedf63dc307b422e1abd46d0e

21 years agoReally remove the OP_StrEq opcode this time - appearently I didn't save the
drh [Wed, 19 May 2004 11:31:12 +0000 (11:31 +0000)] 
Really remove the OP_StrEq opcode this time - appearently I didn't save the
file out of the editor before doing the check-in (1397). (CVS 1405)

FossilOrigin-Name: 821b0b297c11a5e8d08d73b5eff810652e5a0d27

21 years agoVariable name change: azVar to apVar. (CVS 1404)
drh [Wed, 19 May 2004 11:24:25 +0000 (11:24 +0000)] 
Variable name change: azVar to apVar. (CVS 1404)

FossilOrigin-Name: 45169ce015da07da9a874b5b075ea6a05f59f162

21 years agoTests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS...
danielk1977 [Wed, 19 May 2004 10:36:43 +0000 (10:36 +0000)] 
Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1403)

FossilOrigin-Name: f71844bc27c9fc799af3337daf2a212370d4a724

21 years agoTests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS...
danielk1977 [Wed, 19 May 2004 10:35:01 +0000 (10:35 +0000)] 
Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1402)

FossilOrigin-Name: a0f3f6ed2327992036267627cf663e5ca56bd3ae

21 years agoTests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS...
danielk1977 [Wed, 19 May 2004 10:34:56 +0000 (10:34 +0000)] 
Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1401)

FossilOrigin-Name: 33293ae1849dcb4587b8463466bdde2dd9336b82

21 years agoTests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS...
danielk1977 [Wed, 19 May 2004 10:34:51 +0000 (10:34 +0000)] 
Tests for text encoding conversion functions. Also new sqlite3_bindXX APIs. (CVS 1400)

FossilOrigin-Name: 4e602bb473e22cc45de2f5788c035d18586cb836