]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
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

21 years agoAdd definitions of the CollSeq and KeyInfo structures. (CVS 1399)
drh [Tue, 18 May 2004 23:21:35 +0000 (23:21 +0000)] 
Add definitions of the CollSeq and KeyInfo structures. (CVS 1399)

FossilOrigin-Name: cd1be81569aa6d5a365eb27b7d067a153079ce45

21 years agoRemove dead code from vdbeaux.c. Add comments describing desired changes
drh [Tue, 18 May 2004 22:38:31 +0000 (22:38 +0000)] 
Remove dead code from vdbeaux.c.  Add comments describing desired changes
to OP_Sort processing in select.c (CVS 1398)

FossilOrigin-Name: ae37e8a0bff39fd1568eae83f8761c34cd0184fc

21 years agoRemove the OP_StrEq opcodes. (CVS 1397)
drh [Tue, 18 May 2004 22:17:45 +0000 (22:17 +0000)] 
Remove the OP_StrEq opcodes. (CVS 1397)

FossilOrigin-Name: 238442bbd267faee3eb70048bd9419af99c02931

21 years agoRemove dead code from util.c (CVS 1396)
drh [Tue, 18 May 2004 22:03:42 +0000 (22:03 +0000)] 
Remove dead code from util.c (CVS 1396)

FossilOrigin-Name: 3ce42e85a2e6c95ebc0857436d5fe9384cab8628

21 years agoNew varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395)
drh [Tue, 18 May 2004 15:57:42 +0000 (15:57 +0000)] 
New varint encoding gives a maximum varint length of 9 instead of 10. (CVS 1395)

FossilOrigin-Name: 61bdb53a363644074d01682fab8220078523676b

21 years agoAdditional debugging output from btree.c (CVS 1394)
drh [Tue, 18 May 2004 12:50:17 +0000 (12:50 +0000)] 
Additional debugging output from btree.c (CVS 1394)

FossilOrigin-Name: b2def1852c5357629cf69f0071963f9883074a70

21 years agoFix many problems with manifest types and column affinity. Most things are
danielk1977 [Tue, 18 May 2004 10:06:24 +0000 (10:06 +0000)] 
Fix many problems with manifest types and column affinity. Most things are
working now. (CVS 1393)

FossilOrigin-Name: ad4a964158ba9ca9d221cf7ea0439577f3894890

21 years agoFix many problems with manifest types and column affinity. Most things are
danielk1977 [Tue, 18 May 2004 09:58:06 +0000 (09:58 +0000)] 
Fix many problems with manifest types and column affinity. Most things are
working now. (CVS 1392)

FossilOrigin-Name: a62872aacd544a1465b06e007153168663f3c83a

21 years agoBugfix for row format. (CVS 1391)
danielk1977 [Tue, 18 May 2004 01:31:14 +0000 (01:31 +0000)] 
Bugfix for row format. (CVS 1391)

FossilOrigin-Name: c1745f47ae6597953426c852559c3ba559b5ecd4

21 years agoOmit the '\0' at the end of UTF-8 strings on disk (it is implied). Also
danielk1977 [Tue, 18 May 2004 01:23:38 +0000 (01:23 +0000)] 
Omit the '\0' at the end of UTF-8 strings on disk (it is implied). Also
don't store the number of rows at the beginning of each table record. (CVS 1390)

FossilOrigin-Name: 202a470f2c1804a96e69f16709d1a92e405971f0

21 years agoMore changes to support the new types model. Compound SELECTs are currently
danielk1977 [Mon, 17 May 2004 10:48:57 +0000 (10:48 +0000)] 
More changes to support the new types model. Compound SELECTs are currently
broken. (CVS 1389)

FossilOrigin-Name: 0f6c9b05e688e281fa168aacdd867db408df2863

21 years agoFix a bug meant real numbers with a negative sign were being stored as
danielk1977 [Sun, 16 May 2004 22:55:28 +0000 (22:55 +0000)] 
Fix a bug meant real numbers with a negative sign were being stored as
strings by default (instead of IEEE floats). (CVS 1388)

FossilOrigin-Name: 9321e7426337e04064b5791c48dd5fc3c1eecaa2

21 years agoFix a bug in the BTree balancing routine. (CVS 1387)
drh [Sun, 16 May 2004 16:24:36 +0000 (16:24 +0000)] 
Fix a bug in the BTree balancing routine. (CVS 1387)

FossilOrigin-Name: 6c73544bfacb891aae8d6124a2903ccff616494b

21 years agoFix two bugs that were causing lots of tests to fail. (CVS 1386)
danielk1977 [Sun, 16 May 2004 11:57:28 +0000 (11:57 +0000)] 
Fix two bugs that were causing lots of tests to fail. (CVS 1386)

FossilOrigin-Name: 5cba8a510c0aeae740db695e960c60e5f6c303f5

21 years agoMore changes to support the manifest type model. A few things are currently
danielk1977 [Sun, 16 May 2004 11:15:36 +0000 (11:15 +0000)] 
More changes to support the manifest type model. A few things are currently
broken. (CVS 1385)

FossilOrigin-Name: a4af838f8d1b81ec6c8db97655c6876aca0738d9

21 years agoMore speed improvements to btree. (CVS 1384)
drh [Sat, 15 May 2004 00:29:24 +0000 (00:29 +0000)] 
More speed improvements to btree. (CVS 1384)

FossilOrigin-Name: aab4b794b4238bad5c4a6aee7d4443732921127d

21 years agoAllocates VDBE cursors one by one in separate memory so that pointers to
drh [Fri, 14 May 2004 21:59:40 +0000 (21:59 +0000)] 
Allocates VDBE cursors one by one in separate memory so that pointers to
cursors can persist through a realloc(). (CVS 1383)

FossilOrigin-Name: d8bacc16801606176fe8639b2f55b4584ad549df

21 years agoCache record headers in the OP_Column opcode. (CVS 1382)
drh [Fri, 14 May 2004 21:12:22 +0000 (21:12 +0000)] 
Cache record headers in the OP_Column opcode. (CVS 1382)

FossilOrigin-Name: 8d9eab178f285415775060369f372a88c7091f9f

21 years agoMore speed improvements. (CVS 1381)
drh [Fri, 14 May 2004 19:08:17 +0000 (19:08 +0000)] 
More speed improvements. (CVS 1381)

FossilOrigin-Name: cf75cac9b6bd43e60c6e25042b194ec5c60e5671

21 years agoOptimized varint routines and tests added. (CVS 1380)
drh [Fri, 14 May 2004 16:50:06 +0000 (16:50 +0000)] 
Optimized varint routines and tests added. (CVS 1380)

FossilOrigin-Name: d4e0933dc72b66157164610e0b03f339bc535fb9

21 years agoPerformance improvements (CVS 1379)
drh [Fri, 14 May 2004 15:27:27 +0000 (15:27 +0000)] 
Performance improvements (CVS 1379)

FossilOrigin-Name: cad47917267d32ab00c8b949151c8bc3c6638479

21 years agoTable 1 of a database (the sqlite_master table) defaults to use B+trees. (CVS 1378)
drh [Fri, 14 May 2004 12:17:46 +0000 (12:17 +0000)] 
Table 1 of a database (the sqlite_master table) defaults to use B+trees. (CVS 1378)

FossilOrigin-Name: 45b60de5c7deb83d10ab54759434e32847f0c2ef

21 years agoUse B+trees for tables (CVS 1377)
danielk1977 [Fri, 14 May 2004 12:16:11 +0000 (12:16 +0000)] 
Use B+trees for tables (CVS 1377)

FossilOrigin-Name: c6604a94d25d148fbb42b47ae9a8195e4697c681

21 years agoDelete some code no longer in use (CVS 1376)
danielk1977 [Fri, 14 May 2004 11:16:56 +0000 (11:16 +0000)] 
Delete some code no longer in use (CVS 1376)

FossilOrigin-Name: f24aedc2b0c401d8b714ba39b604d7caa7f6a430

21 years agoImplement type affinity for table and index records (CVS 1375)
danielk1977 [Fri, 14 May 2004 11:00:53 +0000 (11:00 +0000)] 
Implement type affinity for table and index records (CVS 1375)

FossilOrigin-Name: dbfe6e93166d9557d66cab9dca7977baa3501e5e

21 years agoChanges to btree and pager in preparation for moving to run-time page
drh [Fri, 14 May 2004 01:58:11 +0000 (01:58 +0000)] 
Changes to btree and pager in preparation for moving to run-time page
size determination. (CVS 1374)

FossilOrigin-Name: f63fb6dd4e8e33d4c1983396b1a0305836ee4df7

21 years agoChanges to make regression tests in rowid.test pass. (CVS 1373)
danielk1977 [Thu, 13 May 2004 13:38:52 +0000 (13:38 +0000)] 
Changes to make regression tests in rowid.test pass. (CVS 1373)

FossilOrigin-Name: 790226c94493a6d58a7e52fd3ed35ef495fab11e

21 years agoChange the OP_ListXX opcodes to use 64 bit integers (CVS 1372)
danielk1977 [Thu, 13 May 2004 12:32:11 +0000 (12:32 +0000)] 
Change the OP_ListXX opcodes to use 64 bit integers (CVS 1372)

FossilOrigin-Name: da9b3dce334bde99360db45b4a3d41be519ec2d1

21 years agoUpdate quick.test (CVS 1371)
danielk1977 [Thu, 13 May 2004 11:46:00 +0000 (11:46 +0000)] 
Update quick.test (CVS 1371)

FossilOrigin-Name: a61eefa081c219704d9e6c4ee20ef9bf01d76b7f

21 years agoVarious minor fixes and updates to make more test cases pass. (CVS 1370)
danielk1977 [Thu, 13 May 2004 11:34:16 +0000 (11:34 +0000)] 
Various minor fixes and updates to make more test cases pass. (CVS 1370)

FossilOrigin-Name: dbe8385ecf1df8bf0b1baf5e811ec5a1de5c4c42

21 years agoCommit vdbeaux.c, which should of gone in with the previous commit. (CVS 1369)
danielk1977 [Thu, 13 May 2004 05:20:26 +0000 (05:20 +0000)] 
Commit vdbeaux.c, which should of gone in with the previous commit. (CVS 1369)

FossilOrigin-Name: 5378a6404058f5e9d3e91269ab27afef9874b43a

21 years agoManifest types in indices. At the moment indices use manifest typing, but
danielk1977 [Thu, 13 May 2004 05:16:15 +0000 (05:16 +0000)] 
Manifest types in indices. At the moment indices use manifest typing, but
some other parts of the SQL engine do not, which can lead to some strange
results. (CVS 1368)

FossilOrigin-Name: 9f2b6d9d3a07e25fcdb7e8290da7a182a65c37b2

21 years agoAllocate more overflow data onto overflow pages, thus wasting less disk space. (CVS...
drh [Thu, 13 May 2004 01:12:56 +0000 (01:12 +0000)] 
Allocate more overflow data onto overflow pages, thus wasting less disk space. (CVS 1367)

FossilOrigin-Name: 1d52a4bb478648ef53a0dbb21865ccb9281dc24a

21 years agoFix a problem with B+trees. (CVS 1366)
drh [Wed, 12 May 2004 21:11:27 +0000 (21:11 +0000)] 
Fix a problem with B+trees. (CVS 1366)

FossilOrigin-Name: 64a75c4cd40f79c7b384bb2972922ff0c10212a4

21 years agoImplement a B+tree option (all data stored on leaves). (CVS 1365)
drh [Wed, 12 May 2004 19:18:15 +0000 (19:18 +0000)] 
Implement a B+tree option (all data stored on leaves). (CVS 1365)

FossilOrigin-Name: b8f70d17f06531269caa0a127efb2d25ad0f3e1c

21 years agoBtree uses signed integers for the rowid. The intToKey() and keyToInt() macros
drh [Wed, 12 May 2004 15:15:47 +0000 (15:15 +0000)] 
Btree uses signed integers for the rowid.  The intToKey() and keyToInt() macros
are now no-ops. (CVS 1364)

FossilOrigin-Name: fb3c80301441f0d255164578601439db3e0c7a61

21 years agoThe pager now handles file ":memory:" complete in memory with no disk I/O. (CVS 1363)
drh [Wed, 12 May 2004 13:30:07 +0000 (13:30 +0000)] 
The pager now handles file ":memory:" complete in memory with no disk I/O. (CVS 1363)

FossilOrigin-Name: 97de9f7ceebab859ef984d155808575ad321afc0

21 years agoAdd some more code to support manifest typing in indices. Not activated yet. (CVS...
danielk1977 [Wed, 12 May 2004 11:24:02 +0000 (11:24 +0000)] 
Add some more code to support manifest typing in indices. Not activated yet. (CVS 1362)

FossilOrigin-Name: 2f16c9ef3c101c4280991ce3cb0c3bea7b6ed439

21 years agoChange the table record format to support manifest typing. (CVS 1361)
danielk1977 [Wed, 12 May 2004 07:33:33 +0000 (07:33 +0000)] 
Change the table record format to support manifest typing. (CVS 1361)

FossilOrigin-Name: 0242c9e4f7c85e9c911cf30d90b0cdb1015f3d7d

21 years agoChange sqlite_ to sqlite3_ in the attach2.test test script. (CVS 1360)
drh [Tue, 11 May 2004 10:04:48 +0000 (10:04 +0000)] 
Change sqlite_ to sqlite3_ in the attach2.test test script. (CVS 1360)

FossilOrigin-Name: 98f756e6a0809e7034bfb587ff9d9085baac0c6e

21 years agoA different fix for the problem with opening existing files. See also
drh [Tue, 11 May 2004 09:57:35 +0000 (09:57 +0000)] 
A different fix for the problem with opening existing files.  See also
check-in (1358). (CVS 1359)

FossilOrigin-Name: 93deaf54c6e1daee0c89a5e2a7d4a5e712ece3f4

21 years agoFix a bug that was preventing the library from opening existing files. (CVS 1358)
danielk1977 [Tue, 11 May 2004 09:50:02 +0000 (09:50 +0000)] 
Fix a bug that was preventing the library from opening existing files. (CVS 1358)

FossilOrigin-Name: ad064bd429602fcac26b377841da90a1a56f5966

21 years agoFix an offset problem in the meta values that was causing problems for
drh [Tue, 11 May 2004 09:31:31 +0000 (09:31 +0000)] 
Fix an offset problem in the meta values that was causing problems for
many tests. (CVS 1357)

FossilOrigin-Name: 6d378cb7e7e081bb3bcd3a347bc1e02f50ee25cc

21 years agoRemove the unused upgrade_3_schema subroutine from main.c. (CVS 1356)
drh [Tue, 11 May 2004 09:05:48 +0000 (09:05 +0000)] 
Remove the unused upgrade_3_schema subroutine from main.c. (CVS 1356)

FossilOrigin-Name: b5d2771ee0e9c77967b4a64a97dcd56c067bc7b8

21 years agoMore small changes to get test cases to execute. (CVS 1355)
danielk1977 [Tue, 11 May 2004 08:48:10 +0000 (08:48 +0000)] 
More small changes to get test cases to execute. (CVS 1355)

FossilOrigin-Name: 6dc6004684a97fbdba2f2dce94086dc2c4967a42

21 years agoRemove code dealing with old file formats. (CVS 1354)
danielk1977 [Tue, 11 May 2004 07:11:51 +0000 (07:11 +0000)] 
Remove code dealing with old file formats. (CVS 1354)

FossilOrigin-Name: dfde112116b982017a5516590ff1780e8aa519ce

21 years agoMore minor changes to accomadate the new btree. All the select* tests
danielk1977 [Tue, 11 May 2004 06:55:14 +0000 (06:55 +0000)] 
More minor changes to accomadate the new btree. All the select* tests
pass now. (CVS 1353)

FossilOrigin-Name: 941d0fdc97ad0a2ba0e823ce40022bdef857aa6e

21 years agoMinor changes to the vdbe so that more tests pass. (CVS 1352)
danielk1977 [Tue, 11 May 2004 06:17:21 +0000 (06:17 +0000)] 
Minor changes to the vdbe so that more tests pass. (CVS 1352)

FossilOrigin-Name: 16078fe0ea146537f75b869e6b0cce202af6781b