database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
583 Commits 1,782 Branches 392 Tags
version-2.4.11
Commit Graph

52 Commits

Author SHA1 Message Date
drh
c8d30ac109 Fix for bug #15: Add the sqlite_changes() API function for retrieving the 
number of rows that changed in the previous operation. (CVS 526)

FossilOrigin-Name: 6e71493b9dc77d508c3ce90562766789e87e6d80
 2002-04-12 10:08:59 +00:00
drh
b04a5d8768 Fix for bug #16: Check for invalid functions in the VALUES clause of an 
INSERT statement. (CVS 525)

FossilOrigin-Name: 43a77f019d34e1a6b3f502ad0ec31a00c8fdbe6e
 2002-04-12 03:55:15 +00:00
drh
feeb1394ee Fix for bug #11: Output the correct row count when and INSERT does an 
IGNORE action. (CVS 524)

FossilOrigin-Name: bb83642e9a6c1c9ade861618496933c9f922a8f8
 2002-04-09 03:28:01 +00:00
drh
fe1a1773a8 Fix for bug #10: Pop the stack by the right amount on an IGNORE so that the 
stack does not grow without bound. (CVS 523)

FossilOrigin-Name: f46acfc3b828620e4e97b09f9aff119b9313e5d7
 2002-04-09 03:15:06 +00:00
drh
e1e68f4974 When an attempt is made to insert an explicit NULL into an INTEGER 
PRIMARY KEY column, automatically convert the NULL value into a unique
integer key.  This was already happening when an implied NULL was
inserted - when the INTEGER PRIMARY KEY column was omitted from the
list of columns being inserted.  Patches from Christian Werner. (CVS 510)

FossilOrigin-Name: 9e3cf4aa2cb44932015b8bd3fd800d7678cb09b6
 2002-03-31 18:29:03 +00:00
drh
417be79cd1 VIEWs are bound to tables when they are used, not when they are first 
entered.  This works around the problem of what to do if a table is deleted
that a view refers to. (CVS 415)

FossilOrigin-Name: 6121e5ab9328c90c64d40ade3de73ad11d4aaf4e
 2002-03-03 18:59:40 +00:00
drh
832508b7ea Subquery flattening is implemented and passes all regression tests. 
We still need to add addition tests to the suite to further exercise
the flattener, however. (CVS 408)

FossilOrigin-Name: d5d3e79cc58da5bd315cc1fea1f7cbf46274da16
 2002-03-02 17:04:07 +00:00
drh
a76b5dfca6 Code to implement CREATE VIEW is in place. A quick smoke test shows that 
it works, but there are probably still many bugs. (CVS 387)

FossilOrigin-Name: 39fed2df11382b9855d518502a6c2ca200fa66b8
 2002-02-23 02:32:10 +00:00
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
e64e7b203e Allow general expressions in the VALUES clause of an INSERT statement. (CVS 376) 
FossilOrigin-Name: ec1f3fae6f8cd8466892cd370e1802e492a76e6e
 2002-02-18 13:56:36 +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
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
ef6764a1d9 Better testing of the ON CONFLICT logic. (CVS 358) 
FossilOrigin-Name: 9bbddb8e013b47547164f71f2d7abd995f8d7385
 2002-01-30 04:32:00 +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
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
9aa028daa2 Bug fix in the out-of-order INSERT. (CVS 336) 
FossilOrigin-Name: a26d0880b20ca5534400a3689d1da31fe6aaa934
 2001-12-22 21:48:29 +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
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
1bee3d7b43 Added support for the COUNT_CHANGES pragma in order to help out the 
ODBC driver.  Fixed a but on count(*) when applied to empty tables. (CVS 289)

FossilOrigin-Name: 747bf1b30b74cfd0e9c27e7c0bc5172637f35520
 2001-10-15 00:44:35 +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
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
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
ecdc7530dd Fixes to the locking and rollback behavior. (CVS 261) 
FossilOrigin-Name: 337b3d3b2a903328d9744c111979909a284b8348
 2001-09-23 02:35:53 +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
50e5dadf2c Everything is working on Linux. This is release 2.0-Alpha-1. (CVS 246) 
FossilOrigin-Name: 14474fa144fe7c5dc63e0990d6cc92d769e6013e
 2001-09-15 00:57:28 +00:00
drh
3fc190cc3f All tests now pass. But there are still issues. For example, inserts 
are way too slow.  And additional tests are needed for new features. (CVS 243)

FossilOrigin-Name: e7b65e37fd88c4d69c89cfe73ab345b8b645ada6
 2001-09-14 03:24:23 +00:00
drh
be0072d249 The BTree changes are now integrated and the whole thing compiles and 
links. I have not yet tried to run it, though. (CVS 239)

FossilOrigin-Name: a0a1e701abc52a164d9b09a5426eb12af1fe6a4c
 2001-09-13 14:46:09 +00:00
drh
5e00f6c7d5 The code is in place to replace GDBM with BTree. But I have not yet 
attempted to compile it.  I am sure the code contains bugs. (CVS 238)

FossilOrigin-Name: 6ecc8b20d4f402f45f03d46d8d4fa40dea666e97
 2001-09-13 13:46:56 +00:00
drh
daffd0e597 better handling of out-of-memory errors (CVS 207) 
FossilOrigin-Name: 86b30cd0975dfea9424b9f9f0d4194aa71ce508b
 2001-04-11 14:28:42 +00:00
drh
345fda3ef5 continued progress toward version 2.0 (CVS 177) 
FossilOrigin-Name: c6ffb7ec6acb596907ead8992dfad94e18e83866
 2001-01-15 22:51:08 +00:00
drh
967e8b7351 :-) (CVS 104) 
FossilOrigin-Name: e1bf96a467b739373191bf75e6a097fc0f24bffc
 2000-06-21 13:59:10 +00:00
drh
1ccde15d69 :-) (CVS 101) 
FossilOrigin-Name: 6ed35a1d477906dc7e35bea0579951484fcdc858
 2000-06-17 13:12:39 +00:00
drh
d8bc708652 :-) (CVS 74) 
FossilOrigin-Name: 2ffeb8509c469f5a499d56bb109da079fcdff570
 2000-06-07 23:51:50 +00:00
drh
cc85b411c7 :-) (CVS 70) 
FossilOrigin-Name: d3baa046c946a2c4d5567ee57d96a6c8aa5740b9
 2000-06-07 15:11:27 +00:00
drh
5974a30f1a :-) (CVS 1697) 
FossilOrigin-Name: 5d773b5d4e9c23b81f53afd0cef7bd2300fff329
 2000-06-07 14:42:26 +00:00
drh
19a775c249 :-) (CVS 52) 
FossilOrigin-Name: c02268bdf4c28edc2542ce0ca1ba24fd6b5058fa
 2000-06-05 18:54:46 +00:00
drh
c61053b771 rework the VDBE engine. NULL is now distinct from "" (CVS 49) 
FossilOrigin-Name: 6ea5cebf05562de00d2cf0b9e2aac5f3857638ee
 2000-06-04 12:58:36 +00:00
drh
7020f6516c added default values (CVS 46) 
FossilOrigin-Name: 27c0678623de37f3166cb9952989fd03484cdb8d
 2000-06-03 18:06:52 +00:00
drh
bed8690fde :-) (CVS 37) 
FossilOrigin-Name: 2b55f9b790e2914bbd2fd27ef23bbab79fa76937
 2000-06-02 13:27:59 +00:00