database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-11-12 13:01:09 +03:00
Code Activity
29,836 Commits 1,607 Branches 185 Tags
json-opt
Commit Graph

19158 Commits

Author SHA1 Message Date
drh
2530378003 Only evaluate expressions once for UPDATE and INSERT statements that 
have BEFORE triggers.  Fix for ticket #980. (CVS 2158)

FossilOrigin-Name: 4852186aca3be6ea40069b6831079197e5fa757a
 2004-12-07 15:41:48 +00:00
drh
dca7684141 Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) 
FossilOrigin-Name: 8e164ab27771aced9a592ea4b7c27e9f184181a5
 2004-12-07 14:06:13 +00:00
drh
81db88e630 Remove the unused sqlite3_context.isStep element. (CVS 2156) 
FossilOrigin-Name: 7b20f2b71f679e72b6cb3b78ccb31b4e7c4bd48b
 2004-12-07 12:29:17 +00:00
drh
32c0d4f17b Updates to API documentation and comments in sqlite3.h. (CVS 2155) 
FossilOrigin-Name: 46584348f3cc10c0c6e9ba42110a6c03caf1497e
 2004-12-07 02:14:51 +00:00
drh
61212b69c1 Get the build of sqlite3_analyzer working with Makefile.in. (CVS 2154) 
FossilOrigin-Name: f7415a0d6433980ff6c25cf2238f5e9881c38873
 2004-12-02 20:17:00 +00:00
drh
3b7b78b312 Fix a memory leak in pager.c. (CVS 2151) 
FossilOrigin-Name: 0ad4ed87ce1112663ca94805dea167372485396a
 2004-11-24 01:16:43 +00:00
danielk1977
8b840013da Fix a memory leak in ALTER TABLE. (CVS 2149) 
FossilOrigin-Name: ba71716ce21ae99b10b2d0b61092497872770ef7
 2004-11-23 16:31:16 +00:00
danielk1977
1d54df88e3 Add authorization callbacks for REINDEX. (CVS 2148) 
FossilOrigin-Name: 9f0d744ee4d99f44e88c6f799821791c3b5f31b6
 2004-11-23 15:41:16 +00:00
danielk1977
ae82558bd0 Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) 
FossilOrigin-Name: 557be3ff5b1c46a3f3836ea3a9d9dede5dc46998
 2004-11-23 09:06:55 +00:00
drh
e4e7207248 More work on the implementation of cursors, but they are still not 
functioning. (CVS 2142)

FossilOrigin-Name: 8b61d1ae1ca469b80f2b344d550c3b363448b193
 2004-11-23 01:47:30 +00:00
drh
b6c29897eb Add initial infrastructure for cursors. In where.c, optimize out clauses 
of the form "ORDER BY rowid" if a table scan is being performed.  Do a
reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141)

FossilOrigin-Name: fc8c1393c86017a816beb52725b68af3b973f979
 2004-11-22 19:12:19 +00:00
drh
8237d45ed8 Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine. 
The problem has gone unnoticed before now because it only occurs when you
use the OP_Prev opcode on a B+Tree. (CVS 2140)

FossilOrigin-Name: 3d2536c479c943b3a55047898068625f91c872ae
 2004-11-22 19:07:09 +00:00
danielk1977
27c774388a Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) 
FossilOrigin-Name: 007be591b7829f9ff38e4b14ba5a5043796c2ff3
 2004-11-22 13:35:41 +00:00
danielk1977
81650dc6c8 Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) 
FossilOrigin-Name: 53894988ac1ad44ec65a1e1c420e2a26eb4c2efd
 2004-11-22 11:51:13 +00:00
danielk1977
299b187d76 Back out changes allowing writes to tables that have open cursors. (CVS 2133) 
FossilOrigin-Name: 91acd87e52509a8f78894d0f4b625b54376cac21
 2004-11-22 10:02:10 +00:00
danielk1977
03aded4924 Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) 
FossilOrigin-Name: 9df837c03939cdcb31856ac17b2425a6dd92d7b2
 2004-11-22 05:26:27 +00:00
drh
b9ecf6fa8e Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2127) 
FossilOrigin-Name: d10560c75244daebe55da5630ef7e7b84ba7f77a
 2004-11-20 20:44:13 +00:00
drh
42cac6dacb Correct use of usableSize versus pageSize in btree.c. Ticket #1010. (CVS 2125) 
FossilOrigin-Name: 5a4013ec9cabb2c933cbf45495f5d1e8b3b20da5
 2004-11-20 20:31:11 +00:00
drh
b08153d0fb Better error message on an SQLITE_RANGE error. Ticket #991. (CVS 2124) 
FossilOrigin-Name: accd432e4d9626353e555e63298fb7a56a41e53d
 2004-11-20 20:18:55 +00:00
drh
6c90fecc96 Omit the maximum loop count on the random name chooser in the VACUUM command. 
Add a comment to explain why this is safe and does not result in an
infinite loop.  Ticket #1009. (CVS 2122)

FossilOrigin-Name: 1241086f23a2ef7aef85139817f0c1b90140481d
 2004-11-20 19:18:55 +00:00
drh
4693423b09 Rig the sqliteMalloc() routine so that we can make it fail multiple times 
in a row.  Modify the malloc.test procedure to make malloc fail in this
way and verify that the failures are still handled correctly. (CVS 2121)

FossilOrigin-Name: 519bc9d9975bbdb4ba056799534d5c465e0cd042
 2004-11-20 19:18:00 +00:00
drh
73c42a1386 Fix segfaults that might occur after a malloc failure. (CVS 2119) 
FossilOrigin-Name: 368774487e7a0266465f5a1c2701c9b14573d26c
 2004-11-20 18:13:10 +00:00
danielk1977
2097e949f6 Add a documentation page for compilation options. Still some work to go. (CVS 2117) 
FossilOrigin-Name: 5efa2d2a602c3b7249c4e6701e97b16b5ad0280d
 2004-11-20 06:05:56 +00:00
danielk1977
023f41762c Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) 
FossilOrigin-Name: f635b6aae661ac85eec49b197f3bb4b85172a457
 2004-11-19 08:41:34 +00:00
danielk1977
aacd732b11 Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) 
FossilOrigin-Name: 6e971868808e3c3f77fa521de626f1510ba9644a
 2004-11-19 08:02:14 +00:00
danielk1977
4d36b81ea0 When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) 
FossilOrigin-Name: 0514107bff970ab1e5ce96c8b1fa13dcbf75cb71
 2004-11-19 07:07:30 +00:00
danielk1977
343e92610e Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) 
FossilOrigin-Name: 1fd8e835a3656799c23f4ef6ea1311fecf5a15cb
 2004-11-19 05:14:54 +00:00
danielk1977
d641d646ff Handle triggers correctly in ALTER TABLE. (CVS 2111) 
FossilOrigin-Name: c61b7de107cea76b561d0d6cd90c752b62c5df95
 2004-11-18 15:44:29 +00:00
drh
20fc0887f5 Speed improvement on the LIKE command. (CVS 2110) 
FossilOrigin-Name: 85d56beb7494ce63e70ab1ffc3797c2ee4c36749
 2004-11-18 13:49:25 +00:00
drh
e854c5607b Fix an obsolete comment that resulted in incorrect documentation. 
Ticket #1003. (CVS 2109)

FossilOrigin-Name: c93a9e18d2bf53690f577a901e0defd8a449d56a
 2004-11-18 02:10:55 +00:00
danielk1977
7c6303c042 Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) 
FossilOrigin-Name: 49268c2b7a84c4c618214dac8bef0f541440fe6b
 2004-11-17 16:41:29 +00:00
danielk1977
c7dc75334f Extra tests and resulting bugfixes for btree cursors. (CVS 2106) 
FossilOrigin-Name: e1530854c9004c25f5ffa21f9cfb9c44c83cc7f0
 2004-11-17 10:22:03 +00:00
danielk1977
ed326d7047 Perform deletes in a single pass. (CVS 2104) 
FossilOrigin-Name: a2e1c35b327e33684ab19e5f65727c42c7b2949c
 2004-11-16 15:50:19 +00:00
danielk1977
6a43f9b3ff Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) 
FossilOrigin-Name: 6ad5fc8e1a119b750a82fc1426704164a2042d57
 2004-11-16 04:57:24 +00:00
drh
670fb032ab Fix a typo in the header comment to the MakeRecord opcode so that the 
documentation generator will actually see the opcode description.
Ticket #1001. (CVS 2102)

FossilOrigin-Name: 33c9b647aa70d1a9dab0e999daf853aa71d7df37
 2004-11-15 23:42:27 +00:00
drh
6c62608fc6 The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) 
FossilOrigin-Name: 98c7a55478f7c465b219edc1a33eee222586fd65
 2004-11-14 21:56:29 +00:00
drh
5436dc2d97 Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) 
FossilOrigin-Name: 59a0a8b7cebc011731654bd0545cf8d19612ca8e
 2004-11-14 04:04:17 +00:00
drh
13d7042a73 More compile-time options for removing components. (CVS 2098) 
FossilOrigin-Name: dcbc0c22cf269e2f67002aa3f1bc0c66aaeff5f1
 2004-11-13 15:59:14 +00:00
danielk1977
ce9a7b1e57 Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097) 
FossilOrigin-Name: 5eaa18d43f2996a9d354bb4fb9c81e267e98be29
 2004-11-13 13:19:56 +00:00
drh
f338814455 Autoincrement is now working and has regression tests. (CVS 2095) 
FossilOrigin-Name: 10c712a21961dbc3bff89c49d5ec3b84b9187c80
 2004-11-13 03:48:06 +00:00
danielk1977
b92b70bb0a Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) 
FossilOrigin-Name: 5e058318441bb5043c609cc8fba1653995e90efb
 2004-11-12 16:11:59 +00:00
danielk1977
1c8c23cc36 Add authorization callbacks to ALTER TABLE. (CVS 2093) 
FossilOrigin-Name: c4115aa3a1b010704af76c5ae9f6dcbfa4038df8
 2004-11-12 15:53:37 +00:00
danielk1977
9fd2a9a028 Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) 
FossilOrigin-Name: a1b2cc63e604785bd51e358ff72c485d858752e3
 2004-11-12 13:42:30 +00:00
drh
2958a4e6a5 Autoincrement code installed. Simple smoke-testing only. No regression 
tests developed yet. (CVS 2091)

FossilOrigin-Name: 8fde833c812b91c5a574208a70b5f92b9d4b0a87
 2004-11-12 03:56:15 +00:00
danielk1977
dae2495b1f Add the schema_cookie and user_cookie pragmas. (CVS 2089) 
FossilOrigin-Name: d28d1d68e5104726e6088361dfa7bf2cdd9985c7
 2004-11-11 05:10:43 +00:00
danielk1977
2df9fabf3c Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) 
FossilOrigin-Name: c85f13f8f252faf423f12a3804f1fe2f950da660
 2004-11-11 01:50:30 +00:00
danielk1977
45901d622c Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) 
FossilOrigin-Name: 0747b55882cf218c03b443e1eadec9eb19889554
 2004-11-10 15:27:38 +00:00
danielk1977
e6efa74b9f Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) 
FossilOrigin-Name: 8e5c2e5df8b824f7efb27e776240f005c6f1f0ff
 2004-11-10 11:55:10 +00:00
danielk1977
752e679a1e Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) 
FossilOrigin-Name: f81b9c1c022772378aad32ec45d0027beeb36574
 2004-11-09 16:13:33 +00:00
danielk1977
7977a17f06 Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) 
FossilOrigin-Name: 0d27c8ff48f327ad82dd5b5b3b47b8d221f119b7
 2004-11-09 12:44:37 +00:00