1
0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00

2168 Commits

Author SHA1 Message Date
drh
aaab5725db Change the name of the sanity_check PRAGMA to "integrity_check" and make
it available on all compiles. (CVS 381)

FossilOrigin-Name: c6e9048e66c8d8e2d5f6c62aa724eef3e9d9f572
2002-02-19 13:39:21 +00:00
drh
24e97df9c7 Fix a serious bug in INSERT when the source is a SELECT. (CVS 366)
FossilOrigin-Name: 20ea737536700b016385c70105a2af8b2bffce2b
2002-02-03 19:06:02 +00:00
drh
1dd397f091 The VACUUM command now does a database sanity check. (CVS 364)
FossilOrigin-Name: 95d1f8389dd5e168bdf0290169662296b6a0f6d9
2002-02-03 03:34:07 +00:00
drh
0d65dc0e90 Five-algorithm conflict resolution appears to be working. (CVS 363)
FossilOrigin-Name: 0115518f8e4591123582e3d2bb67282111ebcf60
2002-02-03 00:56:09 +00:00
drh
663fc63a77 Get the ABORT conflict resolution algorithm working. (CVS 362)
FossilOrigin-Name: 9be4d4c6f12056782966396dca0b8e2d384d0cf2
2002-02-02 18:49:19 +00:00
drh
1c92853dac Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL,
IGNORE, and REPLACE.  This checkin is code only.  Documentation and
tests are still needed.  Also, ABORT is not fully implemented. (CVS 360)

FossilOrigin-Name: d0e7cf4a83e6abad7129bed356b7492dddaff474
2002-01-31 15:54:21 +00:00
drh
b419a926d4 Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359)
FossilOrigin-Name: cf1538d71c9ce12d5e59f367e03642cbcaf6b717
2002-01-30 16:17:23 +00:00
drh
bb37fdc782 More bug fixes in the ON CONFLICT enhancement. (CVS 357)
FossilOrigin-Name: 8229b5f6a348a56432a4a609ee125520c5831973
2002-01-30 00:54:55 +00:00
drh
0ca3e24b2e The new ON CONFLICT logic is in and passes the legacy tests. But the
new capabilities have not been tested and are likely broken. (CVS 356)

FossilOrigin-Name: ac8a4189e2a0c41161ee359db25de94435420368
2002-01-29 23:07:02 +00:00
drh
9cfcf5d4f6 Beginning to insert the infrastructure for ON CONFLICT clauses. (CVS 355)
FossilOrigin-Name: e00a9ff8f99dd58f7cb19a6195fac21f4c8b4af9
2002-01-29 18:41:24 +00:00
drh
6b12545f4f Bug fix: The IN operator was not working if either side derived from
an INTEGER PRIMARY KEY. (CVS 354)

FossilOrigin-Name: dbcfe198fbaa155874ef82a96b6a4b993ccf3931
2002-01-28 15:53:03 +00:00
drh
af9ff33ac1 Added the last_insert_rowid API function. Improved documentation of
the random ROWID algorithm. (CVS 349)

FossilOrigin-Name: f74d61aaf3fec06cde2c4a6f1465f86ac9058ad2
2002-01-16 21:00:27 +00:00
drh
1ab4300ebc Fix warning messages in VC++. Patches from nicolas352001. (CVS 347)
FossilOrigin-Name: f3038d218c91b44b70b75a7b881ea24c87fa6a02
2002-01-14 09:28:19 +00:00
drh
aacc543e23 Comment updates most. Also some small changes to the VDBE. (CVS 339)
FossilOrigin-Name: 9b0be4fcc1cbca69f5fee906f86dfb36a323fe84
2002-01-06 17:07:40 +00:00
drh
c6b52df32d An attempt to delete a single row using a WHERE clause that specifies
the rowid would result in an error if the rowid did not exist.  This
problem has been resolved. (CVS 338)

FossilOrigin-Name: 011be9a9d2632d261489005d97c69b0a0bc5a108
2002-01-04 03:09:29 +00:00
drh
c839258651 Comment changes. Change the use of BTree so that either the key is
an integer or the data is empty. (CVS 337)

FossilOrigin-Name: 18e606f7486eb3a4ab128504d88a44f53d39e5b2
2001-12-31 02:48:51 +00:00
drh
8aff10153e Bug fixing in the new integer primary key code. (CVS 334)
FossilOrigin-Name: 29cab124b4f7eae9d9feb60d2f3a2c443fd9b9aa
2001-12-22 14:49:24 +00:00
drh
4a32431ce7 Added support for the INTEGER PRIMARY KEY column type. (CVS 333)
FossilOrigin-Name: 236a54d289e858a1e0505a20d907a2a40c01b521
2001-12-21 14:30:42 +00:00
drh
a84f6005a9 Bug fix: Sometimes NULL results were not being passed as nulls to the
callback function. (CVS 312)

FossilOrigin-Name: 94ce8282360d4a0dd2032564aae06f0f1902cb5b
2001-11-13 19:35:14 +00:00
drh
7900eaded1 Update change log prior to release of 2.1.0. (CVS 311)
FossilOrigin-Name: 6b3ccb37bf4c10b2d8f96ef8efc22ed8253f1886
2001-11-12 13:51:43 +00:00
drh
84e6b7b5ae Fix to the SUBSTR() function and to the bigrow test. (CVS 310)
FossilOrigin-Name: 8437076c25330759ae058918a8190df26d0881da
2001-11-12 13:10:52 +00:00
drh
58a11680d1 Comment changes (CVS 308)
FossilOrigin-Name: 2d2ad264aad6fbdcef586e73d750e3fde842252f
2001-11-10 13:51:08 +00:00
drh
487ab3ca18 The new code for taking advantage of inequalities in WHERE clauses
is in place.  It appears to work. (CVS 305)

FossilOrigin-Name: 262bcd17df19f45def6144b5a7e0602ca5b03deb
2001-11-08 00:45:21 +00:00
drh
6b56344d4a New Next opcode and indexing style implemented. (CVS 304)
FossilOrigin-Name: decbeb9151885fee473b3fa58c8cf78a2338d2d8
2001-11-07 16:48:26 +00:00
drh
8721ce4ae7 Incremental update. We are in the middle of modifying the index system
to support range queries without doing a complete table scan. (CVS 303)

FossilOrigin-Name: e6ca23fa4569bc33065bf57ce7ce6132cd6a9de0
2001-11-07 14:22:00 +00:00
drh
9bbca4c1c0 Implement indices that occur in sort order and the LIMIT...OFFSET clause
of SELECT statements. (CVS 301)

FossilOrigin-Name: eb07768ae93f14bf6c150c1c4329948857a9d01c
2001-11-06 04:00:18 +00:00
drh
80ff32f5be Increase maximum row size to 1MB. (CVS 300)
FossilOrigin-Name: 7dd58fad398253608f55867cf1c7749eef005657
2001-11-04 18:32:46 +00:00
drh
a8b38d286e Remove cruft: restrict the number of sorters and lists in the VDBE to one
since no more than one was ever used anyway.  This eliminates several
op-codes and simplifies the implementation of several others. (CVS 297)

FossilOrigin-Name: e1370276c2a0d045b29c981ddcb59f737e19a91c
2001-11-01 14:41:34 +00:00
drh
18b81e5a93 Comment changes only. (CVS 296)
FossilOrigin-Name: b2cb118fb7c6713684d32a48a7ba8ffffe596687
2001-11-01 13:52:52 +00:00
drh
6d4abfbee5 More changes for 2.0.7. (CVS 293)
FossilOrigin-Name: f8328a5f11801c5124f9a8dace22df3c1cfb2191
2001-10-22 02:58:08 +00:00
drh
01a346616f 2.0.7 (CVS 292)
FossilOrigin-Name: a835658e507fc7d0c684959c0f0afb9018b6a8d4
2001-10-20 12:30:10 +00:00
drh
6a535340bc Version 2.0.6 (CVS 291)
FossilOrigin-Name: 8467d84fc6e67bd93051f54338a8f6c9b1711ee1
2001-10-19 16:44:56 +00:00
drh
98808babd3 Support for UTF-8 and ISO8859 characters in identifiers. Bug fix in
the column name generator for selects (was coreing). (CVS 290)

FossilOrigin-Name: 22948fc685299ca888907eea68edb8a6e87c3f49
2001-10-18 12:34:46 +00:00
drh
e21a57320e Bug fix. Raised version number to 2.0.4. (CVS 288)
FossilOrigin-Name: 26972afd645e21e0d16de9a0bb0d03754e909044
2001-10-13 21:56:34 +00:00
drh
bf4133cba1 2.0.3 (CVS 287)
FossilOrigin-Name: 75e90cf09b64ee1fcb39a711fc9ac6d3d2b849a5
2001-10-13 02:59:08 +00:00
drh
99fcd718e1 Remove the P3 and label arguments from the internal sqliteVdbeAddOp()
function.  This makes the code easier to read and perhaps smaller as
well. (CVS 286)

FossilOrigin-Name: 288ef1247b94c6c933451d120cdc78e471efc14e
2001-10-13 01:06:47 +00:00
drh
ad75e9874b Fix the locking protocol. (CVS 280)
FossilOrigin-Name: 484b82d8a1c84f3d9725a509de93276b9fa9b294
2001-10-09 04:19:46 +00:00
drh
f57b339988 Support for temporary tables added. Still need more testing. (CVS 279)
FossilOrigin-Name: 9368c62e4097aae3081a325962c1dec167fd253d
2001-10-08 13:22:32 +00:00
drh
382c0247c7 Adding table column query capability to support ODBC. (CVS 278)
FossilOrigin-Name: b63b3f3684a3d584ef99f54cde76b6c483bbfef7
2001-10-06 16:33:02 +00:00
drh
adbca9cfde Fixed the support of UNIQUE and PRIMARY KEY. (CVS 268)
FossilOrigin-Name: 116fdad06868acf6aca9e75c2c3497c0511a42c3
2001-09-27 15:11:53 +00:00
drh
717e640294 Added basic support for enforcement of UNIQUE on indices and primary
keys.  Support for addition constraints is to follow. (CVS 267)

FossilOrigin-Name: 34c42967f3d52dfb65d9f31db4f6995d098ec1f7
2001-09-27 03:22:32 +00:00
drh
afa4a020f2 Tests for inserting lots of data (~64K) into a single row of a table. (CVS 264)
FossilOrigin-Name: a462c85083d23aa34bd3d0c61d01062fc5ae8230
2001-09-24 03:12:39 +00:00
drh
f3256d2c82 RowIDs are now always expressed in native byte order. (CVS 263)
FossilOrigin-Name: bb4313a94bc079d072078f353e54f3804971060d
2001-09-23 20:17:55 +00:00
drh
90bfcdace3 Additional test cases with locking fixes. Also, make the code thread-safe. (CVS 262)
FossilOrigin-Name: bd7d6a64afa03cc64f6537f828d6c94975bf5f02
2001-09-23 19:46:51 +00:00
drh
ecdc7530dd Fixes to the locking and rollback behavior. (CVS 261)
FossilOrigin-Name: 337b3d3b2a903328d9744c111979909a284b8348
2001-09-23 02:35:53 +00:00
drh
beae319476 Put in a generic hash table system in place of the various ad-hoc
hash table scattered everywhere.  Except, the page hash table in
the pager is unchanged. (CVS 260)

FossilOrigin-Name: 9114420dd01d92cc8890046500a8806a297a4e65
2001-09-22 18:12:08 +00:00
drh
db5ed6d55d Fix a problem in GROUP BY with multiple columns. (CVS 255)
FossilOrigin-Name: 22132ce18cad31482cdb9b380cedc3f53bc532b8
2001-09-18 22:17:44 +00:00
drh
1eaa2694bf Bug fixes. Trying to make it go faster. (CVS 254)
FossilOrigin-Name: 8f28a83abac59a2161d486c96386b8df726468d0
2001-09-18 02:02:23 +00:00
drh
b19a2bc603 Disclaimed copyright. Preparing for release 2.0. (CVS 250)
FossilOrigin-Name: 4e926efe2b59adfec4086eb1d2ba830238facb4c
2001-09-16 00:13:26 +00:00
drh
872ff86f2c Separate columns in keys using nulls instead of tabs. (CVS 249)
FossilOrigin-Name: 8e2f3f751ea342372c94977ff27baaff5126009a
2001-09-15 14:43:39 +00:00