database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-08 14:02:16 +03:00
Code Activity
25,662 Commits 1,570 Branches 184 Tags
branch-3.28
Commit Graph

2101 Commits

Author SHA1 Message Date
drh
4ff6dfa7de More bugs fixed for views. (CVS 416) 
FossilOrigin-Name: 813077623087ffc6cd506f57cf6d1e3d9239f806
 2002-03-03 23:06:00 +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
2d0794e325 Suppress superfluous OP_OpenTemps when flattening subqueries. (CVS 412) 
FossilOrigin-Name: 000441c8fec48cc172894eb767ae9549b8ed8c34
 2002-03-03 03:03:52 +00:00
drh
1b2e032999 Bug fixes and additional tests for the subquery flattener. (CVS 411) 
FossilOrigin-Name: 2c05389eda391e38894fc6969e29766df82a8fec
 2002-03-03 02:49:51 +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
0bce8354b4 Completely remove the old SQL function system and replace it with the 
new user functions.  The code currently compiles but it coredumps on the
test suite.  Do not use in its present state. (CVS 400)

FossilOrigin-Name: 50797fee5066ec9ea23b720e5ab7e8fc8ccc1988
 2002-02-28 00:41:10 +00:00
drh
1350b030c1 Revise the API for user-defined functions. (CVS 398) 
FossilOrigin-Name: 633951f0fa11c91f93aa2862df84691750c01e73
 2002-02-27 19:00:20 +00:00
drh
ff78bd2f07 Bug fixes in the VIEW implementation. (CVS 396) 
FossilOrigin-Name: 668ef6380eba256ef82477b63aef850249a619a0
 2002-02-27 01:47:11 +00:00
drh
e5095355d6 Code for user-defined aggregates added. Legacy tests all pass but there 
has been no testing of the new user-defined aggregate code. (CVS 392)

FossilOrigin-Name: 1e037eb303d8508cb2ea3418e71b03315d895fbd
 2002-02-24 03:25:14 +00:00
drh
dc04c58360 Move the build-in function definitions into a new source file "func.c". (CVS 391) 
FossilOrigin-Name: 530b0f4f2def89e200b7b0724a5967bf981bd91d
 2002-02-24 01:55:15 +00:00
drh
8e0a2f903a Added support for user-defined normal functions. Support for user-defined 
aggregates is pending. (CVS 390)

FossilOrigin-Name: c490a1ff951c5d4a2de8e4f8d349189bfaef7f74
 2002-02-23 23:45:45 +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
17f7193434 Change the SQLITE_MASTER format to version 2 in preparation for adding views. (CVS 386) 
FossilOrigin-Name: b2a9807fed544e83002366149b9a363759338c5d
 2002-02-21 12:01:27 +00:00
drh
5cf8e8c7fa New ROWIDs are numbered sequentially. (CVS 383) 
FossilOrigin-Name: 1686196a8aea326f616bc8205df99cd84d955ec4
 2002-02-19 22:42:05 +00:00
drh
969fa7c128 Add support for CREATE TABLE AS. (CVS 377) 
FossilOrigin-Name: 78a50971e9adc8739e7888201c79465a40e1a152
 2002-02-18 18:30:32 +00:00
drh
22f70c32f0 Add support for subqueries in the FROM clause of a SELECT. Still need 
to add tests for this feature. (CVS 372)

FossilOrigin-Name: 89ffa9ff132858b62a91df1fb7fe49b2d58c01e7
 2002-02-18 01:17:00 +00:00
drh
1d83f05257 Make the sqliteParseInfoReset() function locale to the select.c file. (CVS 371) 
FossilOrigin-Name: 2336b1eadaedf2556a1988acc7bdf133135154dc
 2002-02-17 00:30:36 +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
9208643d2a Constant ORDER BY or GROUP BY expressions are an error. (CVS 352) 
FossilOrigin-Name: 035984a5b00b4a1a6505405f40b15c7695283c0a
 2002-01-22 14:11:29 +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
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
74e24cd0fa Working on a bug: Dropping and recreating a table within a transaction 
causes an assertion failure. (CVS 342)

FossilOrigin-Name: b3656a5cfef91c89de2cbb9790087d0d53c03e6f
 2002-01-09 03:19:59 +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
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
4a32431ce7 Added support for the INTEGER PRIMARY KEY column type. (CVS 333) 
FossilOrigin-Name: 236a54d289e858a1e0505a20d907a2a40c01b521
 2001-12-21 14:30:42 +00:00
drh
b8ca307e7b Bug fix: sqlite_exec() would sometimes return SQLITE_PROTOCOL when it 
should have returned SQLITE_BUSY.  There was also a deadlock that the
previous bug was masking. (CVS 322)

FossilOrigin-Name: 585ed5ebf1c1afc8ae1d569b121208018d8ecd49
 2001-12-05 00:21:20 +00:00
drh
c3a64ba0a6 Fix a bug in the locking protocol. (CVS 315) 
FossilOrigin-Name: a9db1c12c5a4d5741de0e5eb5aa87c647a5646b8
 2001-11-22 00:01:27 +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
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
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
6d4abfbee5 More changes for 2.0.7. (CVS 293) 
FossilOrigin-Name: f8328a5f11801c5124f9a8dace22df3c1cfb2191
 2001-10-22 02:58:08 +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
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
bf4133cba1 2.0.3 (CVS 287) 
FossilOrigin-Name: 75e90cf09b64ee1fcb39a711fc9ac6d3d2b849a5
 2001-10-13 02:59:08 +00:00
drh
81a20f21d5 Fix an assertion failure when the disk fills up. Add tests for a full 
disk situation. (CVS 285)

FossilOrigin-Name: 0a7848b6190981cb7eb673bbe68cb217694daf2e
 2001-10-12 17:30:04 +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
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
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
e3c413727b Add a new column in the SQLITE_MASTER table to record the root page 
number of primary key indices. (CVS 252)

FossilOrigin-Name: 602ea4f9f641070592c788ce22859b849739b42e
 2001-09-17 20:25:58 +00:00