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
7014aff37d Revised date/time functions - now broken out into a separate source file. 
See the DateAndTimeFunctions wiki page for additional information. (CVS 1116)

FossilOrigin-Name: 68ef9b45bd3abdedf3721011ad0fb22e8735e721
 2003-11-01 01:53:53 +00:00
danielk1977
348bb5d6c8 Add sqlite_progress_handler() API for specifying an progress callback (CVS 1111) 
FossilOrigin-Name: ddb364635a207658664ea92fc677cf16a143a938
 2003-10-18 09:37:26 +00:00
drh
dab3518880 Remove support for the Oracle8 outer join syntax. (CVS 1106) 
FossilOrigin-Name: 824430b3ce435386b83ceb882f1510ac9f27d8fa
 2003-09-27 13:39:38 +00:00
drh
7c972dec5c Update Makefile.in for the new vdbeaux.c file. Remove the experimental 
"sqlite_instantiate()" routine and replace it with "sqlite_bind()" which
is more like ODBC and JDBC. (CVS 1095)

FossilOrigin-Name: 990bb11898a539bb0795a4a216fcd989943a0fb2
 2003-09-06 22:18:07 +00:00
drh
78100cc928 Add a "pk" column to the table_info pragma which is true for each column 
that is part of the primary key.  Add a "foreign_key_list" pragma that gives
information about all foreign keys for a table.  Both changes are experimental. (CVS 1081)

FossilOrigin-Name: 5232b0665b84a9339a85918570093a376a0ea91f
 2003-08-23 22:40:53 +00:00
drh
771d8c3bae Add experimental date and time functions based on julian day number. (CVS 1069) 
FossilOrigin-Name: a6197e2075fdf9db862484255ac16b2855bbef0a
 2003-08-09 21:32:28 +00:00
drh
4305d10360 The {quote: SrcList} object was not being expanded correctly by a call to 
sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by
a call to sqliteSrcListDup().  Ticket #416. This check-in fixes that problem
by keeping a separate nAlloc field on {quote: SrcList}.  A similar change is made
to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067)

FossilOrigin-Name: da6273255471673841fdcadc688aeac80722e130
 2003-07-30 12:34:12 +00:00
drh
7b58daeafe Fix the LIMIT clause so that it applies to the entire query in a compound 
query.  Prior to this change LIMITs on compound queries did not work at
all.  Ticket #393. (CVS 1058)

FossilOrigin-Name: 543479e3aed77976a0c689cf40811bf88353f706
 2003-07-20 01:16:46 +00:00
drh
6cb2c52d96 Remove all references to SQLITE_OMIT_TRACE. Tracing is always enabled. 
Ticket #361. (CVS 1032)

FossilOrigin-Name: ec31a5292cbc5d2fb68449838b929638f48e31a7
 2003-06-23 11:06:01 +00:00
drh
7a73eb48f8 Fix compiler errors and warnings win SQLITE_OMIT_AUTHORIZATION is defined. 
Ticket #353. (CVS 1029)

FossilOrigin-Name: 6920b633c2e4a94ee5de7d2db3933a873ee3513b
 2003-06-16 19:18:12 +00:00
drh
4312db55d9 Additional testing of the ATTACH command with bug fixes for the new problems 
that the tests found. (CVS 998)

FossilOrigin-Name: 3e8889d7ce5e99fc855526fc1bb62ddbe282bfc5
 2003-06-03 01:47:11 +00:00
drh
1aa4965ae3 The OP_Checkpoint opcode is now a no-op if invoked on a database that already 
has an active checkpoint journal.  Ticket #333. (CVS 997)

FossilOrigin-Name: daf7b94017f03638da1ef65830f3762be030b93c
 2003-06-02 23:14:13 +00:00
drh
f26e09c87f Tighter binding of views, triggers, and indices to their respective 
databases.  Ticket #323.  Much more testing needs to be done to the
sqliteFix...() routines in attach.c. (CVS 990)

FossilOrigin-Name: 7202d4f1a8853368954a967b7ccca9d8a6645a2e
 2003-05-31 16:21:12 +00:00
drh
8372b8d134 Change the row-size limit back to 1MB. It was temporarily raised to 16MB. 
We'll probably move it to 16MB eventually, but not just yet. (CVS 989)

FossilOrigin-Name: b84c4035c6b06469055798cf412fa4da8b50fa17
 2003-05-29 17:50:55 +00:00
drh
9ac717d7f6 Modify the windows locking code so that it works correctly for a database 
being shared between Win95/98/ME and WinNT/2K/XP systems.  Ticket #310. (CVS 988)

FossilOrigin-Name: 8c402db7e0745622d9950e5ca5d4d8e933da436c
 2003-05-29 17:43:08 +00:00
drh
79a519c047 Prevent an infinite loop when deleting a table that has a TEMP trigger. (CVS 984) 
FossilOrigin-Name: c8c823b068916711857fa67db10fb479999b55c2
 2003-05-17 19:04:03 +00:00
drh
8bf8dc9208 Fix problems with TEMP indices that lead to corrupt databases. These 
problems were discovered while working on ticket #317.  No sure yet if
that ticket is fixed. (CVS 981)

FossilOrigin-Name: 01398fb78bab7e5c6f439f2b743f26e82118468a
 2003-05-17 17:35:10 +00:00
jplyon
a3643a2697 Removed never-used symbol SQLITE_ResultDetails. (CVS 965) 
FossilOrigin-Name: 26bd7bb1779e14f19c00e450aaa9529f2aabf131
 2003-05-10 03:04:34 +00:00
drh
6a3ea0e6ef VDBE cursors numbers for tables in a join do not have to be consecutive. 
This is one step on the road to fixing ticket #272. (CVS 947)

FossilOrigin-Name: be7aed2011b4af868b6a0c370c3d41354ae0cdf4
 2003-05-02 14:32:12 +00:00
drh
63eb5f294c The sqlite_complete() function should ignore carriage-return characters. 
(Oops - some unrelated edits also made it into this check-in.) (CVS 942)

FossilOrigin-Name: c6bf62e41cf44e8ebf740b103204b00e8b826c90
 2003-04-29 16:20:44 +00:00
drh
85e2096fb6 Report the correct authorization context in the authorization callback 
when coding an INSTEAD OF trigger on an update or delete. (CVS 936)

FossilOrigin-Name: 67746833fc8de3afff80db413bd63a362bb28218
 2003-04-25 17:52:11 +00:00
drh
5cf590c128 Fix some issues with INSTEAD OF triggers. (CVS 930) 
FossilOrigin-Name: 206b17397b1d2b55179c935927ff1d8215728c32
 2003-04-24 01:45:04 +00:00
drh
b5a20d3ceb Remove the begin_hook and commit_hook APIs. They were a bad idea. Add a 
"trace" method to the TCL interface. (CVS 929)

FossilOrigin-Name: 6289b863590ecc5de3d1efaaa60aa6f3f64fefb3
 2003-04-23 12:25:23 +00:00
drh
e22a334b78 Update the authorizer API so that it reports the database that table and 
indices belong to and so that it reports when actions are taken in response
to a trigger. (CVS 928)

FossilOrigin-Name: c675a5504138f34cae6def782b5d3add2c67d2bc
 2003-04-22 20:30:37 +00:00
drh
f0f258b11b Add support for TEMPORARY triggers. Such triggers can write temporary or 
permanent tables. (CVS 926)

FossilOrigin-Name: 58ddd587b0f5d565ae3b0ba3a1fa5c20d459f3fc
 2003-04-21 18:48:45 +00:00
drh
ea1ba17cda Update comments. Remove unused field from the Index structure. (CVS 921) 
FossilOrigin-Name: 7084e05093e72f6e5b65ff0b574336898396826f
 2003-04-20 00:00:23 +00:00
drh
a69d91681d Fix triggers to work in an ATTACHed database. Ticket #295. (CVS 915) 
FossilOrigin-Name: 1e5e00fb73c308378efd034cb291caf338c9fe84
 2003-04-17 22:57:53 +00:00
drh
bb07e9a34f Simplify the number processing code. Fix for ticket #281. (CVS 910) 
FossilOrigin-Name: 4326b52a39cad4632dc2db37aa53a285a31af138
 2003-04-16 02:17:35 +00:00
drh
70ce3f0c58 Get triggers working on tables with INTEGER PRIMARY KEYs. Ticket #291. 
This may also fix #159.  Still need to add tests so both bugs remain open
for the time being. (CVS 908)

FossilOrigin-Name: 0b996959b8d8bc2c82eab9cccc190befd0056505
 2003-04-15 19:22:22 +00:00
drh
13bff81537 Change some variable names and comments in the new in-memory database file 
implementation.  Partial (non-working) implementation of the VACUUM command. (CVS 904)

FossilOrigin-Name: e76787f877c456abdc8bc88bfefc50eaeed68744
 2003-04-15 01:19:47 +00:00
paul
b0208ccaa3 Support in-memory databases for temp tables (CVS 903) 
FossilOrigin-Name: 96336bffde6c441af197a521ee9e56fdfd7efff8
 2003-04-13 18:26:49 +00:00
drh
0d1a643aea Added experimental APIs: sqlite_begin_hook() and sqlite_commit_hook(). (CVS 896) 
FossilOrigin-Name: 5efbf62313519d0a6e8b8f5dbb29d3ef428d73e8
 2003-04-03 15:46:04 +00:00
drh
665de47ac3 Minor follow-on changes to the recent ATTACH patch. (CVS 892) 
FossilOrigin-Name: e80afe75b33d4eacb40ef6128cf688f7c3253984
 2003-03-31 13:36:09 +00:00
drh
da93d238c2 Add the sqliteErrorMsg() function and use it to generate error message 
text during parsing and code generation.  This simplifies the code
somewhat and makes it easier to handle names with a database prefix. (CVS 891)

FossilOrigin-Name: 1d3fc977211abdc7ba3fd51d661863e8ce5aef69
 2003-03-31 02:12:46 +00:00
drh
1c2d84148a The ATTACH and DETACH statements are now coded but are still mostly untested. (CVS 890) 
FossilOrigin-Name: c7c5e927a54f0fbc2ca625754787aff4d9c4eff1
 2003-03-31 00:30:47 +00:00
drh
812d7a21dd Regression tests now work - except for some changes in error message 
text.  The library is now safe to use for experimental work. (CVS 885)

FossilOrigin-Name: 8a593e9c2d57e758739a7ef54fa40ca6a0071a9a
 2003-03-27 13:50:00 +00:00
drh
d24cc427b7 Changes to the "sqlite" structure that allow simultaneous operations on 
multiple database files.  Many regession tests pass - but not all of them.
Do not use this version except for debugging SQLite itself. (CVS 883)

FossilOrigin-Name: d2fb2bb50cf1e13feb90995079f291384abd6ba9
 2003-03-27 12:51:24 +00:00
drh
113088ec68 Record the database name in addition to the table name for DELETE, INSERT, 
and UPDATE statements. (CVS 879)

FossilOrigin-Name: a5d8fc95ee58dc3205a0bbbcadaa3b9c902a941b
 2003-03-20 01:16:58 +00:00
drh
001bbcbb8f Modifications to the VDBE to support more than one database file. (CVS 878) 
FossilOrigin-Name: 875da9eed981bfa27b98e95025f9fdbed74b4098
 2003-03-19 03:14:00 +00:00
drh
94e9203247 Added test code to check for file descriptor leaks. All regression tests pass 
now on both win2k and linux. (CVS 868)

FossilOrigin-Name: 75ba78280f7ab6b6acce5878859312f3223ee898
 2003-02-16 22:21:32 +00:00
drh
973b6e333d Added the new FULL option to the SYNCHRONOUS pragma. Still need to test it. (CVS 863) 
FossilOrigin-Name: 792a9e157dd066fcaffd4f5b373010151fb4ca61
 2003-02-12 14:09:42 +00:00
drh
968af52acf Modify the journal format to be more robust against garbage that might appear 
in the file after a power failure.  The changes are mostly working but more
testing is still required.  This check-in is to checkpoint the changes so far. (CVS 861)

FossilOrigin-Name: 8ec5632536eea31197a3b1fd6abc57881a0cf1d7
 2003-02-11 14:55:40 +00:00
drh
483750ba8a Better error messages on constraint violations. Additional tests and bug fixes 
for the callback-free API. (CVS 854)

FossilOrigin-Name: ccc82f1ab4539a60ee5cc2625743c5389f9ccd8e
 2003-01-29 18:46:51 +00:00
drh
326dce7451 The callback-free API is now working, though much more testing is need. (CVS 853) 
FossilOrigin-Name: 162b259188e6967fe9c3722da26b81aab5655d83
 2003-01-29 14:06:07 +00:00
drh
b86ccfb26e First code for the new callback-free API. All regression tests pass but the 
new API is mostly untested and is unlikely to work. (CVS 852)

FossilOrigin-Name: 065fa818ffc8d7562889172acea16e4e44e773ef
 2003-01-28 23:13:10 +00:00
drh
fcb78a4900 Fix datatype reporting and collating sequence selection so that it works 
correctly on views and with the UNION, EXCEPT, and INTERCEPT operators. (CVS 839)

FossilOrigin-Name: 71cc292dce59cf8224b205d1cdbff59ad12f1043
 2003-01-18 20:11:05 +00:00
drh
18de4824f6 Add the sqlite_trace() hook for tracing the SQL that an application executes. 
The plan is to leave this API undocumented for the time being, in case we
want to make changes to it later. (CVS 836)

FossilOrigin-Name: f67bff8ff3db9694f87daf1a549d24ea9612da6b
 2003-01-16 16:28:53 +00:00
drh
e5f9c6442f Revise the sqlite_set_authorizer API to provide more detailed information 
about the SQL statement being authorized.  Only partially tested so far. (CVS 830)

FossilOrigin-Name: 45de93f913a18026a45de6254963dbcd1b0f1a19
 2003-01-13 23:27:31 +00:00
drh
ed6c8671b3 Initial check-in of the code for the new sqlite_set_authorizer() API function. 
The code is mostly untested at this point. (CVS 827)

FossilOrigin-Name: 52d5007f64d0af5286b2a0e1f0b9e53c86bece3f
 2003-01-12 18:02:16 +00:00
drh
836faa4843 Remove the ColumnCount opcode, which had become a no-op. (CVS 821) 
FossilOrigin-Name: 86deb12d68026913d181f9498144fa56445899f2
 2003-01-11 13:30:57 +00:00