drh
38640e15af
All the code is now in place for SQLite to distinguish between NUMERIC and
...
TEXT datatypes. Still need to turn on the new code and test it. (CVS 659)
FossilOrigin-Name: b4737a16c997a6c139d616211fb6bc4b0fae181c
2002-07-05 21:42:36 +00:00
drh
a9f9d1c08b
Add a few more tests and fix a few bugs that the tests uncovered. (CVS 652)
...
FossilOrigin-Name: 91c0db66c86facb21b5b522afadd83d91a488256
2002-06-29 02:20:08 +00:00
drh
e31847449e
The query optimizer now attempts to satisfy an ORDER BY clause using
...
an index. Sorting is still used if there are no suitable indices. (CVS 628)
FossilOrigin-Name: f09e19b43ef61073713cf32282c90ea666229eba
2002-06-19 14:27:05 +00:00
danielk1977
6f34903e85
Add RAISE() function, which allows more advanced flow-control in trigger programs (ticket #55 ) (CVS 614)
...
FossilOrigin-Name: d4a2fb10067203a0d49317db747759872e62927e
2002-06-11 02:25:40 +00:00
drh
ad3cab52fe
Split the IdList structure into IdList and SrcList. SrcList is used to
...
represent a FROM clause and IdList is used for everything else. This change
allows SrcList to grow to support outer joins without burdening the other
uses of IdList. (CVS 584)
FossilOrigin-Name: a167b71d8c27e870bc3079c6132e483bffc83298
2002-05-24 02:04:32 +00:00
drh
bd5a451d5d
Change the names of the PushList and PopList opcodes to ListPush and ListPop
...
so that they will appear together with the other List opcodes in the
documentation. (CVS 583)
FossilOrigin-Name: c53b0b9283c5c34def87d58b03fd979d03dc0890
2002-05-23 22:07:02 +00:00
drh
07d6e3a74c
Partial fix for ticket #49 . The correct result is computed, but now we have
...
a memory leak. I'm not sure if the memory leak was pre-existing or a result
of this change. (CVS 581)
FossilOrigin-Name: 4d27ee411902a197cd72416ca9da9197d3f87f13
2002-05-23 12:50:18 +00:00
drh
c977f7f596
Additional code cleanup resulting from a review of the new trigger code. (CVS 572)
...
FossilOrigin-Name: 37dbdd551e88440933066133ec9cc1e10b03fc1a
2002-05-21 11:38:11 +00:00
danielk1977
f29ce55958
Style fixes to triggers code in various *.c files (partial fix to ticket #39 ) (CVS 571)
...
FossilOrigin-Name: 8a4195c7466962291a296e8f53034ea8cb25005f
2002-05-19 23:43:12 +00:00
drh
9adf9ac4e4
Remove all tabs from the beginning of source code lines. Replace tabs with
...
the appropriate number of spaces. (CVS 565)
FossilOrigin-Name: 690f9a163173c4c7af7e8e92e942cee4184c7974
2002-05-15 11:44:13 +00:00
danielk1977
c3f9bad209
Added FOR EACH ROW triggers functionality (CVS 562)
...
FossilOrigin-Name: 794bf67b6b36fce8854d5daff12f21dbb943240c
2002-05-15 08:30:12 +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
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
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
a2e00042a1
The right-hand side of an AS in a SELECT can be used within expressions of
...
the WHERE, ORDER BY, GROUP BY, and/or HAVING clauses. (CVS 350)
FossilOrigin-Name: 3684beab0f8a71ebdf453871bbde7a9ab1f65385
2002-01-22 03:13:42 +00:00
drh
9647ff85fe
Fix a bug that could cause UPDATE to fail for a table that contains
...
both an INTEGER PRIMARY KEY and an index. (CVS 346)
FossilOrigin-Name: 96cd07a881d7bea86a66d7dfe54713be9c81cb4c
2002-01-14 02:56:24 +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
5a2c2c20af
Attempting to add support for 64-bit platforms. (CVS 314)
...
FossilOrigin-Name: 03673adbfe0c8a92d79f86ddf1136736594208ad
2001-11-21 02:21:11 +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
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
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
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
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
b072950e24
Fix a bug on systems where malloc(0) return NULL.
...
Add code to detect this bug even on systems were it used not to
occur. (CVS 190)
FossilOrigin-Name: bda83e2b75843b9a078c2f4e64fcd4d2145a716b
2001-03-14 12:35:57 +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
6206d50a4a
:-) (CVS 102)
...
FossilOrigin-Name: 8cce4d279de00da45c5970c8f0946f49e03e6846
2000-06-19 19:09:08 +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
4794b98035
added IN and BETWEEN operators (CVS 57)
...
FossilOrigin-Name: 54d198189b58366e4e40139102bc6de94ac55e18
2000-06-06 13:54:14 +00:00
drh
7020f6516c
added default values (CVS 46)
...
FossilOrigin-Name: 27c0678623de37f3166cb9952989fd03484cdb8d
2000-06-03 18:06:52 +00:00
drh
58b9576b7a
:-) (CVS 34)
...
FossilOrigin-Name: 52338f4ab5990fefc61f615cd65c3a724b365199
2000-06-02 01:17:37 +00:00
drh
cce7d17614
added aggregate functions like count(*) (CVS 21)
...
FossilOrigin-Name: dee7a8be88a95014534b90b96716d9e2e6b16579
2000-05-31 15:34:51 +00:00
