database/sqlite
database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-04-21 19:26:38 +03:00
Code
29,836 Commits 1,540 Branches 176 Tags
Commit Graph

611 Commits

Author SHA1 Message Date
danielk1977
14db26653a Fix some errors to do with attached databases and text encodings in shared-cache mode. (CVS 2895) 
FossilOrigin-Name: 3e75d3d5efebc0dfff1adfc13d85e85ec39db3eb
 2006-01-09 16:12:04 +00:00
drh
15007a99e4 Get LIMIT and OFFSET working again for negative limits and offsets. 
Ticket #1586. (CVS 2889)

FossilOrigin-Name: b2ac0be07ec76ab23b7e5b800c0bc62d0bc97f4b
 2006-01-08 18:10:17 +00:00
drh
66560adab3 Change the OS interface layer to use traditional direct function call 
implementations instead of the more complicated virtual function table.
Omit the asynchronous I/O demo. (CVS 2870)

FossilOrigin-Name: 2529c2e11fa1d345ec61f647e4f6fae20a7133d6
 2006-01-06 14:32:19 +00:00
danielk1977
da18423620 Add the shared schema/pager modifications. Very few tests so far. (CVS 2859) 
FossilOrigin-Name: deeda0dc06c1595aedd8d06a0c4e88a8abf78cf7
 2006-01-05 11:34:32 +00:00
drh
2646da7e52 Clean up annoying (and pointless) compiler warnings about differing signedness. (CVS 2810) 
FossilOrigin-Name: 83a59151559d9496d4f546e03e65087ea974717d
 2005-12-09 20:02:05 +00:00
drh
3c4f2a4202 Provide a pragma to set the codec key. (CVS 2806) 
FossilOrigin-Name: a7c9e8989c752f6b1148e7cc7bf59bbd8b402e87
 2005-12-08 18:12:56 +00:00
drh
054889ec6d Restructure the OS interface yet again. This time make the OsFile object 
a virtual base class which is subclassed for unix, windows, and the crash
test simulator.  Add the new file "os.c" for common os layer code.  Move
all OS-specific routines into the sqlite3Os structure. (CVS 2795)

FossilOrigin-Name: bd8740d1aecba69e1b5d64d43db07e8ad8841f07
 2005-11-30 03:20:31 +00:00
drh
9c06c95309 Modify the OS layer so that I/O routines are called through a virtual function 
table.  The os_test.c module has been replaced by test6.c.  The crash tests
are busted now and need to be fixed. (CVS 2785)

FossilOrigin-Name: 1f69aec285dd8e26bd739d5e44bb50fe03a9682a
 2005-11-26 00:25:00 +00:00
drh
0cd2d4c9a1 Add the ignore_check_constraints pragma. VACUUM works even on a database 
that contains table entries that violate check constraints. (CVS 2757)

FossilOrigin-Name: be83bfee0211396a0038ffb125897199bea9a73f
 2005-11-03 02:15:02 +00:00
drh
23cc57f6a3 Check-in (2744) as incomplete and broke pragma integrity_check. This 
completes the change and fixes the problem. (CVS 2746)

FossilOrigin-Name: 4862eaafd875eb1069076864c7cad600a76620c7
 2005-10-06 13:59:26 +00:00
drh
b59005e5a3 Make sure pragma integrity_check does not report "ok" after first finding 
a bunch of errors. (CVS 2744)

FossilOrigin-Name: efec04dedfff8b92527b42e59cc32b4f69031021
 2005-10-05 11:41:48 +00:00
drh
d654be803f Code cleanup and simplification. Three new Mem opcodes added. 
The sqlite3VdbeJumpHere function added. (CVS 2730)

FossilOrigin-Name: 2471957feee57538e5e1e50a704a337f0927d10e
 2005-09-20 17:42:23 +00:00
drh
a67367e7d1 Fix a problem with the lock_status pragma and the UTF-16 encoding. (CVS 2710) 
FossilOrigin-Name: 1a737b457c59286d7d5c3a98391dec17dbc82d09
 2005-09-17 16:36:55 +00:00
drh
55ef4d9758 The case_sensitive_like pragma added. 
Test cases added for the LIKE optimization. (CVS 2592)

FossilOrigin-Name: 72ee21c05e618b6f46f5460f8c85779c72fe32d7
 2005-08-14 01:20:37 +00:00
drh
42b9d7c561 Fix a memory leak that occurs when a CREATE TABLE that contains a 
DEFAULT VALUE fails due to a name conflict.  Tickets #1356 and #1357. (CVS 2584)

FossilOrigin-Name: 25cfe9390dda79bb2a7740b3d7380f517a4e8d1b
 2005-08-13 00:56:27 +00:00
drh
2f47149691 Make sure the String8 opcode always has a non-null P3 argument in 
the foreign_key_list pragma.  Ticket #1297. (CVS 2525)

FossilOrigin-Name: bcf62dc7a1e8e7a3180138cf9b8944eb8fbd5490
 2005-06-23 03:15:07 +00:00
drh
f0863fe568 Update older opcode names to be more meaningful in light of the latest 
code design. (CVS 2506)

FossilOrigin-Name: 36f2da1f8d8d434f861ecad55c9d86549751c954
 2005-06-12 21:35:51 +00:00
drh
0ccebe7e2d Changes to support linking without a parser and without a disk I/O interface. (CVS 2504) 
FossilOrigin-Name: 62a7353d4af4886b1561832e8b36e8e788b38834
 2005-06-07 22:22:50 +00:00
danielk1977
3a3f38e090 Allow schema objects beginning with sqlite_ to be created if the 
SQLITE_WriteSchema flag is set. (CVS 2470)

FossilOrigin-Name: afc8ce42b6c321463f6451727d0f85c490c8e9ae
 2005-05-22 06:49:56 +00:00
drh
89dec819d2 Add hooks for the SSE extension. (CVS 2449) 
FossilOrigin-Name: 90f4cf2ad57309dbd20954fc7fd60859bc44bcf4
 2005-04-28 19:03:37 +00:00
danielk1977
53c0f7480b Add the SQLITE_OMIT_TEMPDB compile time macro. (CVS 2427) 
FossilOrigin-Name: c41d55443c2dd532147962b87f542fb7d37075fd
 2005-03-29 03:10:59 +00:00
drh
bf21627b6f Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362) 
FossilOrigin-Name: c167e9054249361d1f464d3840a5c277e6ed44ab
 2005-02-26 18:10:44 +00:00
danielk1977
48af65aeae Add experimental collation_list pragma. (CVS 2321) 
FossilOrigin-Name: f73a8aa34afd39e0b7df8f22b5c5d2c8d8979a1b
 2005-02-09 03:20:37 +00:00
drh
7bec505e26 Add the (highly experimental) omit_readlock pragma that disables the use 
of readlocks on read-only databases that are connected using ATTACH. (CVS 2317)

FossilOrigin-Name: 2155448d2128119f74241da0ea07d6713b71765c
 2005-02-06 02:45:41 +00:00
danielk1977
6a67fe8edf Remove code for SQL cursors. (CVS 2312) 
FossilOrigin-Name: 2eb90870556c90b8d85da3d5eb7554f74ec922c2
 2005-02-04 04:07:16 +00:00
danielk1977
a21c6b6fe0 Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) 
FossilOrigin-Name: d5233e0747789dea04d35a8350b408321d23a64d
 2005-01-24 10:25:59 +00:00
drh
d89bd007ba Add the experimental sqlite3_expired() API. (CVS 2263) 
FossilOrigin-Name: df648d50c0696cf7ada2fe5973d285b494891964
 2005-01-22 03:03:54 +00:00
danielk1977
b84f96f854 Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) 
FossilOrigin-Name: 5b1a9bf6aa5a5c466b88f649e322e81b8466851f
 2005-01-20 11:32:23 +00:00
danielk1977
2812956b18 Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) 
FossilOrigin-Name: 8ced491588764b1e1066787d0abf3cde8b60970b
 2005-01-11 10:25:06 +00:00
drh
268283bc7f Fixes to the temp_store_directory pragma. (CVS 2185) 
FossilOrigin-Name: 0a90eaf398aa4a689cd8326cd017951513ca748a
 2005-01-08 15:44:25 +00:00
drh
e6f85e71e9 Fix ticket #1046 by removing code and simplifying the query optimizer. 
Remarkably, this simplification also makes the optimizer do a better job.
Ticket #1051 was fixed as a side-effect. (CVS 2172)

FossilOrigin-Name: 5fd1f4711885e3dd6fb2c2700287f78bb0ea178a
 2004-12-25 01:03:13 +00:00
tpoindex
9a09a3caed Add PRAGMA 'temp_store_directory'. Added os_*.c function 
sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into
invalidateTempStorage(). (CVS 2171)

FossilOrigin-Name: 772e22cbd69463be41c2e73b4fd4eb33946193c4
 2004-12-20 19:01:32 +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
13d7042a73 More compile-time options for removing components. (CVS 2098) 
FossilOrigin-Name: dcbc0c22cf269e2f67002aa3f1bc0c66aaeff5f1
 2004-11-13 15:59:14 +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
dae2495b1f Add the schema_cookie and user_cookie pragmas. (CVS 2089) 
FossilOrigin-Name: d28d1d68e5104726e6088361dfa7bf2cdd9985c7
 2004-11-11 05:10:43 +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
danielk1977
951af8050b Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) 
FossilOrigin-Name: b9d5f007fc32d4f471e0e11cc4baadb100612878
 2004-11-05 15:45:09 +00:00
drh
b7f9164e98 Insert #ifdefs that can optionally remove features at compiletime resulting 
in a database engine with a smaller footprint. (CVS 2034)

FossilOrigin-Name: be661acfa849bb0d5692797dd221f5a8a457f8ad
 2004-10-31 02:22:47 +00:00
drh
722e95ac65 Minor optimizations in the pragma module. (CVS 2029) 
FossilOrigin-Name: 63efd50a1608eb4ccac44a233c0f77c3956f9fa0
 2004-10-25 20:33:44 +00:00
drh
f404083e56 Add the experimental and scary pragma "writable_schema". (CVS 2027) 
FossilOrigin-Name: 39f7870a54d90d5163fcad3f08cd63699c4bb567
 2004-10-22 20:29:21 +00:00
drh
5719628afb Convert many constants to have type "const". (CVS 2006) 
FossilOrigin-Name: d790c84c5a889928d07f5394fffef0cbb8d5f214
 2004-10-06 15:41:16 +00:00
drh
2783e4bc0e Use the database name supplied to table_info() and related pragmas. (CVS 2001) 
FossilOrigin-Name: 0415af325739fd4e0bd4761c889719355a1ec4ff
 2004-10-05 15:42:53 +00:00
drh
684917c269 Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) 
FossilOrigin-Name: 81ff8107ad63113782cf5a9ba7a512496114ba08
 2004-10-05 02:41:42 +00:00
drh
ae29ffbe23 Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) 
FossilOrigin-Name: 9ef4c24a9acc2128891303de1ffd2ef4509d779c
 2004-09-25 14:39:18 +00:00
drh
d900a46be0 The page_size pragma preserves the reserved area at the end of each page. (CVS 1964) 
FossilOrigin-Name: c34f3209e5028e008ea9e2c43f1e0d97d6db01d3
 2004-09-17 20:25:24 +00:00
drh
03c8988076 Always cast 0 to (char*)0 when it is an argument in a varargs function. (CVS 1948) 
FossilOrigin-Name: a1f532520c16a1f4b4285cd522774669292fb234
 2004-09-08 15:09:40 +00:00
drh
9bb575fd72 Fix a naming conflict between sqlite versions 2 and 3. An open sqlite3 
connection now *must* be called "sqlite3".  You cannot call it "sqlite".
This might break existing code. (CVS 1941)

FossilOrigin-Name: 3ddf5a9d1c480a2e3aa32685879063b11afddbe1
 2004-09-06 17:24:11 +00:00
drh
873cdcb2ce Comment changes and minor code cleanup. (CVS 1940) 
FossilOrigin-Name: dfa9ea89c473e1fea804ad07e8e58a9af1e92f6c
 2004-09-05 23:23:41 +00:00
drh
5bb7ffe1ea Fix a problem with EXPLAIN on pragmas that return single integer values. 
Ticket #886 (CVS 1929)

FossilOrigin-Name: 8ce3d730b0bf1a9b9472ff38c58c462ebc3566e3
 2004-09-02 15:14:00 +00:00