]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
21 years agoPrototypes for sqlite_encode_binary() and sqlite_decode_binary() added
drh [Sun, 14 Mar 2004 22:12:34 +0000 (22:12 +0000)] 
Prototypes for sqlite_encode_binary() and sqlite_decode_binary() added
to sqlite.h. (CVS 1296)

FossilOrigin-Name: 359f0e787ff2d4d10fd23059e2ce99670e93f66a

21 years agoMake sqlite_encode_binary() and sqlite_decode_binary() an official part of
drh [Sun, 14 Mar 2004 22:11:59 +0000 (22:11 +0000)] 
Make sqlite_encode_binary() and sqlite_decode_binary() an official part of
the library. (CVS 1295)

FossilOrigin-Name: 786fe545560ec6c42bb0e344345031f425bf177a

21 years agoUpdates to the architecture document. (CVS 1294)
drh [Sun, 14 Mar 2004 11:57:58 +0000 (11:57 +0000)] 
Updates to the architecture document. (CVS 1294)

FossilOrigin-Name: c661cc81b6981c536c107f40525ad9783b11ea82

21 years agoFix the min/max optimizer so that it works when the FROM clause is a
drh [Sat, 13 Mar 2004 14:00:36 +0000 (14:00 +0000)] 
Fix the min/max optimizer so that it works when the FROM clause is a
subquery.  Ticket #658. (CVS 1293)

FossilOrigin-Name: 31c94acc72d318b5dec0fef1485621943add45c8

21 years agoTypecast to work around a bug in {quote: CodeWarrior} Studio v9.1.
drh [Wed, 10 Mar 2004 18:57:31 +0000 (18:57 +0000)] 
Typecast to work around a bug in {quote: CodeWarrior} Studio v9.1.
Ticket #654. (CVS 1292)

FossilOrigin-Name: 5864fc6937b933b7da0c00e6c4c2ee1b9b939cff

21 years agoFixed default target. (CVS 1291)
a.rottmann [Wed, 10 Mar 2004 18:53:09 +0000 (18:53 +0000)] 
Fixed default target. (CVS 1291)

FossilOrigin-Name: af19ab32c5b329b053f3daf3c812eb593b89cd7f

21 years ago* Added rule for rebuilding Makefile from Makefile.in.
a.rottmann [Wed, 10 Mar 2004 16:32:03 +0000 (16:32 +0000)] 
* Added rule for rebuilding Makefile from Makefile.in.
* Fixed double-slash problem induced by adding DESTDIR support. (CVS 1290)

FossilOrigin-Name: 957827e35cca65de11894eb2dfc78327f4034dfc

21 years agoThe BTree layer now returns SQLITE_READONLY on an attempt to open a write
drh [Wed, 10 Mar 2004 13:42:37 +0000 (13:42 +0000)] 
The BTree layer now returns SQLITE_READONLY on an attempt to open a write
cursor on a read-only database.  Previously, the failure would not occur
until there was an attempt to write to the cursor. (CVS 1289)

FossilOrigin-Name: 8a8be4687bf9fd88952b303f30f93aa6fed75b60

21 years agoThe shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288)
drh [Tue, 9 Mar 2004 13:37:45 +0000 (13:37 +0000)] 
The shell program now ignores extra whitespace at the end of dot-commands. (CVS 1288)

FossilOrigin-Name: b6817e99bd97f427b1cfd16328d612e1a7d70d0a

21 years agoVersion 2.8.13 (CVS 1287)
drh [Mon, 8 Mar 2004 13:57:54 +0000 (13:57 +0000)] 
Version 2.8.13 (CVS 1287)

FossilOrigin-Name: 4d5bbb3dc32412ee7fa5dec42d3278836a362e8c

21 years agoUpdate change log for version 2.8.13. (CVS 1286)
drh [Mon, 8 Mar 2004 13:45:24 +0000 (13:45 +0000)] 
Update change log for version 2.8.13. (CVS 1286)

FossilOrigin-Name: 4431e63746311d2e3429203656f8168c227ecb6e

21 years agoBump the version number to 2.8.13. Patch up the limit test so that it works
drh [Mon, 8 Mar 2004 13:26:17 +0000 (13:26 +0000)] 
Bump the version number to 2.8.13.  Patch up the limit test so that it works
in spite of ticket #521 - we don't want any tests failing in an official
release even if there are bugs. :-D (CVS 1285)

FossilOrigin-Name: 2c6bd21ed0e212109cfb4a37cfac2a10ab58a024

21 years agoCorrect duplicate tracing of SQL statements. (CVS 1284)
rdc [Thu, 4 Mar 2004 19:09:20 +0000 (19:09 +0000)] 
Correct duplicate tracing of SQL statements. (CVS 1284)

FossilOrigin-Name: bb67311b3db49ce772533da14f62497c55432fae

21 years agoA vdbe stack element might have a string value even after a call to
drh [Wed, 3 Mar 2004 01:51:24 +0000 (01:51 +0000)] 
A vdbe stack element might have a string value even after a call to
Integerify().  Ticket #641. (CVS 1283)

FossilOrigin-Name: 3cac4b7b526d6c5dbf394009b534707bcb65b0da

21 years agoMake sure a LIMIT clause on a SELECT cleans up the vdbe stack so that if it
drh [Tue, 2 Mar 2004 18:37:41 +0000 (18:37 +0000)] 
Make sure a LIMIT clause on a SELECT cleans up the vdbe stack so that if it
occurs inside a trigger, it won't cause a stack overflow.  Ticket #640. (CVS 1282)

FossilOrigin-Name: 5aaa2939baa972231def086ed5f9d9ba63302532

21 years agoUpdated aclocal.m4 and configure. (CVS 1281)
a.rottmann [Sun, 29 Feb 2004 15:18:31 +0000 (15:18 +0000)] 
Updated aclocal.m4 and configure. (CVS 1281)

FossilOrigin-Name: 76d42921a475c531a77677c3fe73b6da265a878d

21 years agoOne more fix to the new HH:MM:SS modifier. This time add some test
drh [Sun, 29 Feb 2004 01:08:17 +0000 (01:08 +0000)] 
One more fix to the new HH:MM:SS modifier.  This time add some test
procedures too. (CVS 1280)

FossilOrigin-Name: 7b3b8968ee9a5349dd6e9ae1e7a311bf8906607c

21 years agoTry again to get the HH:MM:SS modifier change right... (CVS 1279)
drh [Sun, 29 Feb 2004 00:50:33 +0000 (00:50 +0000)] 
Try again to get the HH:MM:SS modifier change right... (CVS 1279)

FossilOrigin-Name: e20d51f94ed67b8864a435e5735f61f396662c21

21 years agoFix a bug in the HH:MM:SS modifier change that was just checked in. (CVS 1278)
drh [Sun, 29 Feb 2004 00:48:08 +0000 (00:48 +0000)] 
Fix a bug in the HH:MM:SS modifier change that was just checked in. (CVS 1278)

FossilOrigin-Name: 248b5500900bc8f401006aaa9b7dac090ae419fa

21 years agoAllow time modifiers of the form HH:MM:SS.SSS with an option "+" or "-"
drh [Sun, 29 Feb 2004 00:40:32 +0000 (00:40 +0000)] 
Allow time modifiers of the form HH:MM:SS.SSS with an option "+" or "-"
prefix.  The specified amount of time is added into the date-time begin
modified. (CVS 1277)

FossilOrigin-Name: 559002a52fe3c42fe71ffce364eff4a036ae6b83

21 years agoFix some compiler warnings in LCC. The warnings did not indicate real
drh [Sun, 29 Feb 2004 00:11:30 +0000 (00:11 +0000)] 
Fix some compiler warnings in LCC.  The warnings did not indicate real
problems.  Ticket #634.  Not all warnings in ticket #634 were fixed. (CVS 1276)

FossilOrigin-Name: e97089b7df3e2fbfcf36062099d02ecb75e9a870

21 years agoMake Windows .dll build use the real .o files, not the libtool-faked .lo
a.rottmann [Sat, 28 Feb 2004 18:02:20 +0000 (18:02 +0000)] 
Make Windows .dll build use the real .o files, not the libtool-faked .lo
ones. (CVS 1275)

FossilOrigin-Name: cce5bbf49b0a30c40d24a559bc6cb4585dd9aea5

21 years agoBuild system update:
a.rottmann [Thu, 26 Feb 2004 19:47:42 +0000 (19:47 +0000)] 
Build system update:

* Update of generated/libtoolized files: config.guess, config.sub,
   configure, ltmain.sh
* Removal of libtool, which is generated by configure
* Changes to Makefile.in, adding better support for newer libtools (CVS 1274)

FossilOrigin-Name: 22d63bbf78997f0b31bb39054fbcfccf9d974bd6

21 years agoAdd comments and prototype for experimental sqlite_last_statement_changes() API funct...
rdc [Wed, 25 Feb 2004 22:51:06 +0000 (22:51 +0000)] 
Add comments and prototype for experimental sqlite_last_statement_changes() API function. Also, allow function to be called from tcl. (CVS 1273)

FossilOrigin-Name: ca99920b0dbf773962b47766d690154fd1276513

21 years agoMin() and max() functions honor the distinction between TEXT and NUMERIC
drh [Wed, 25 Feb 2004 13:47:31 +0000 (13:47 +0000)] 
Min() and max() functions honor the distinction between TEXT and NUMERIC
data.  Ticket #623.  typeof() is now a user function.  Some tests are
now failing due to ticket #521. (CVS 1272)

FossilOrigin-Name: adbe31adf1ad0ca723203ca3d7dc480324c60d43

21 years agoFix the return type of sqliteRunVacuum. Ticket #627. (CVS 1271)
drh [Wed, 25 Feb 2004 02:33:34 +0000 (02:33 +0000)] 
Fix the return type of sqliteRunVacuum.  Ticket #627. (CVS 1271)

FossilOrigin-Name: 9c9f4a867a4ea708847cbb0839b7279eb33ecd7c

21 years agoShell program saves command-line history on a ".quit". Ticket #614. (CVS 1270)
drh [Wed, 25 Feb 2004 02:25:37 +0000 (02:25 +0000)] 
Shell program saves command-line history on a ".quit".  Ticket #614. (CVS 1270)

FossilOrigin-Name: 114b72f8608b8e08fad863a1446fb1ef59610efd

21 years agoDisable an assert which (as it turns out) is not always true. Ticket #615. (CVS...
drh [Wed, 25 Feb 2004 02:20:41 +0000 (02:20 +0000)] 
Disable an assert which (as it turns out) is not always true.  Ticket #615. (CVS 1269)

FossilOrigin-Name: 2773c1d384b750eee037e6ccc61bc56b5204d690

21 years agoRefactor parts of write operations. (CVS 1268)
drh [Tue, 24 Feb 2004 01:05:31 +0000 (01:05 +0000)] 
Refactor parts of write operations. (CVS 1268)

FossilOrigin-Name: 5b0147aece7785373e6f7439c32e5f58c6b12562

21 years agoMake sure BEGIN, COMMIT, and ROLLBACK are really no-ops when preceded
drh [Tue, 24 Feb 2004 01:04:11 +0000 (01:04 +0000)] 
Make sure BEGIN, COMMIT, and ROLLBACK are really no-ops when preceded
by EXPLAIN.  Ticket #626. (CVS 1267)

FossilOrigin-Name: 2af1f065b5eb39fd3ecac00f8a66d1b4186aead5

21 years agoUse sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266)
drh [Sun, 22 Feb 2004 20:05:00 +0000 (20:05 +0000)] 
Use sqliteVdbeOp3 instead of sqliteVdbeChangeP3 where applicable. (CVS 1266)

FossilOrigin-Name: 51f1e8f7539596b33bc3365ec8f34041602d049c

21 years agoCode cleanup in build.c. (CVS 1265)
drh [Sun, 22 Feb 2004 18:56:49 +0000 (18:56 +0000)] 
Code cleanup in build.c. (CVS 1265)

FossilOrigin-Name: 9211e14cf81f4de125bad246d8a289786f2854aa

21 years agoUse sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264)
drh [Sun, 22 Feb 2004 18:40:56 +0000 (18:40 +0000)] 
Use sqliteErrorMsg instead of sqliteSetString whereever practical. (CVS 1264)

FossilOrigin-Name: 69aac043af7f93e7b3f036622c0ac9261cae1839

21 years agoCode cleanup in the date and time functions. (CVS 1263)
drh [Sun, 22 Feb 2004 17:49:32 +0000 (17:49 +0000)] 
Code cleanup in the date and time functions. (CVS 1263)

FossilOrigin-Name: 9b3bcde1530091602e551435ffd7820eb79727d5

21 years agoRearrange the grammar some so that tokens that are used together appear
drh [Sun, 22 Feb 2004 16:27:00 +0000 (16:27 +0000)] 
Rearrange the grammar some so that tokens that are used together appear
together in the grammar file.  This reduces the size of the parser tables
and some of the jump tables in switch statements. (CVS 1262)

FossilOrigin-Name: d372c16ec6621dbab371bff7f1803ca096862984

21 years agoDo not sort terminal symbols by name. The terminals remain in the same order
drh [Sun, 22 Feb 2004 00:08:04 +0000 (00:08 +0000)] 
Do not sort terminal symbols by name.  The terminals remain in the same order
that they are encountered in the grammar file.  This results in parse tables
that are 25% smaller. (CVS 1261)

FossilOrigin-Name: f36b122d9767fa9e6dc5bcce04b5606d67cad3d9

21 years agoTest cases for printf of double overflows. (CVS 1260)
drh [Sat, 21 Feb 2004 19:41:04 +0000 (19:41 +0000)] 
Test cases for printf of double overflows. (CVS 1260)

FossilOrigin-Name: 96a6d2d3ff5bd0aaff188ee1c5e2f02cbea435b2

21 years agoFix a long-standing memory leak that the new last_insert_rowid() tests
drh [Sat, 21 Feb 2004 19:17:17 +0000 (19:17 +0000)] 
Fix a long-standing memory leak that the new last_insert_rowid() tests
brought to light. (CVS 1259)

FossilOrigin-Name: 7d5ede5b6ef515808995d4631f8d19aca95a9105

21 years agoCleanup the printf code to make it smaller and more modular.
drh [Sat, 21 Feb 2004 19:02:30 +0000 (19:02 +0000)] 
Cleanup the printf code to make it smaller and more modular.
Fix a memory leak in the new OP_ContextPush opcode. (CVS 1258)

FossilOrigin-Name: 2756f7af3382fa9d186ab99cf76f469fb891a3c3

21 years agoFlag pragmas like vdbe_trace now return their current setting if they
drh [Sat, 21 Feb 2004 14:00:29 +0000 (14:00 +0000)] 
Flag pragmas like vdbe_trace now return their current setting if they
are called with no arguments. (CVS 1257)

FossilOrigin-Name: 6a5fb5b89a98307060bb4a92a499b5d3dba74553

21 years agoMore code cleanup and size reduction. (CVS 1256)
drh [Sat, 21 Feb 2004 13:31:09 +0000 (13:31 +0000)] 
More code cleanup and size reduction. (CVS 1256)

FossilOrigin-Name: 8e3eda2a909bd80b2b14ace36ab44303750a4409

21 years agoEnhance date/time functions to work with negative years. Ticket #617. (CVS 1255)
drh [Sat, 21 Feb 2004 03:28:18 +0000 (03:28 +0000)] 
Enhance date/time functions to work with negative years.  Ticket #617. (CVS 1255)

FossilOrigin-Name: ffa971934867b6bbe943c004154d5f161e0ea697

21 years agoTurn the short_column_names pragma off by default - for the time being. (CVS 1254)
drh [Fri, 20 Feb 2004 23:34:07 +0000 (23:34 +0000)] 
Turn the short_column_names pragma off by default - for the time being. (CVS 1254)

FossilOrigin-Name: 6954d2c3240459842be655b600c6b160e918e74a

21 years agoAdd sqlite.def file required for correct operation of "make implib" option in Makefil...
rdc [Fri, 20 Feb 2004 22:55:41 +0000 (22:55 +0000)] 
Add sqlite.def file required for correct operation of "make implib" option in Makefile.in (CVS 1253)

FossilOrigin-Name: b1b23c410260293f57614f32232cf1276f41c16b

21 years agoFixed behaviour of last_insert_rowid() with triggers and add last_statement_change_co...
rdc [Fri, 20 Feb 2004 22:54:25 +0000 (22:54 +0000)] 
Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1252)

FossilOrigin-Name: 6734c923395ca41ce453f56dd7d6e7794fbb3bb5

21 years agoFixed behaviour of last_insert_rowid() with triggers and add last_statement_change_co...
rdc [Fri, 20 Feb 2004 22:53:38 +0000 (22:53 +0000)] 
Fixed behaviour of last_insert_rowid() with triggers and add last_statement_change_count() function that works correctly with triggers. (CVS 1251)

FossilOrigin-Name: 3383413a53bff0fef0765144de3bb9a298a5bb5c

21 years agoThe name of a result column is now the name of column it originated from, by
drh [Fri, 20 Feb 2004 14:50:58 +0000 (14:50 +0000)] 
The name of a result column is now the name of column it originated from, by
default.  This can be turned off with PRAGMA short_column_names=OFF.  This
is to be more like PostgreSQL.  More testing needed. (CVS 1250)

FossilOrigin-Name: 574dd444e7ff00e0fccc3436fe617ad832daae40

21 years agoFix a bug in the parser table compression algorithm of lemon. (CVS 1249)
drh [Thu, 19 Feb 2004 18:41:53 +0000 (18:41 +0000)] 
Fix a bug in the parser table compression algorithm of lemon. (CVS 1249)

FossilOrigin-Name: 8d3e924975681a871e0eeac3b6a62cffdb947ac7

21 years agoFix a memory leak that occurs if you call sqlite_interrupt() on a query
drh [Wed, 18 Feb 2004 16:57:23 +0000 (16:57 +0000)] 
Fix a memory leak that occurs if you call sqlite_interrupt() on a query
using aggregate functions where the aggregate function returns a string
longer than 32 characters. (CVS 1248)

FossilOrigin-Name: 2c1e74e58a702fd2be954467a12e69a33b252831

21 years agoBegin updating the architecture description to better describe how things
drh [Wed, 18 Feb 2004 16:56:32 +0000 (16:56 +0000)] 
Begin updating the architecture description to better describe how things
are currently put together. (CVS 1247)

FossilOrigin-Name: 062ecc1368d6bb6d15da31e8d6f5953e8f5628b9

21 years agoAdd more tests of the sqlite_interrupt() logic - looking for a reported
drh [Wed, 18 Feb 2004 01:31:53 +0000 (01:31 +0000)] 
Add more tests of the sqlite_interrupt() logic - looking for a reported
memory leak.  (Didn't find it.) (CVS 1246)

FossilOrigin-Name: e4c8b1c3aa9d288f518c6394187354e6fa18978e

21 years agoAvoid line endings munging by Cygwin; ticket #370 (CVS 1245)
dougcurrie [Tue, 17 Feb 2004 18:26:57 +0000 (18:26 +0000)] 
Avoid line endings munging by Cygwin; ticket #370 (CVS 1245)

FossilOrigin-Name: 50e67948f89380f2f4b536add0b8179e6db960a5

21 years agoRemove the NullCallback opcode. Handle the empty_result_set pragma inside
drh [Mon, 16 Feb 2004 03:44:01 +0000 (03:44 +0000)] 
Remove the NullCallback opcode.  Handle the empty_result_set pragma inside
the sqlite_exec() function. (CVS 1244)

FossilOrigin-Name: f72134852bf33d13fd2bc6f35251e4b33bc10fac

21 years agoEliminate obsolete code associated with the older callback functionality. (CVS 1243)
drh [Sat, 14 Feb 2004 23:59:57 +0000 (23:59 +0000)] 
Eliminate obsolete code associated with the older callback functionality. (CVS 1243)

FossilOrigin-Name: 2dbc4593ca5c1cf75039c8b4471b1e47faa849f0

21 years agoEliminate the use of callbacks during schema initialization. (CVS 1242)
drh [Sat, 14 Feb 2004 23:05:52 +0000 (23:05 +0000)] 
Eliminate the use of callbacks during schema initialization. (CVS 1242)

FossilOrigin-Name: af5c2be4aed1c50f69eb9634cf051a26263dcf51

21 years agoFix problems with malloc-failure handling. (CVS 1241)
drh [Sat, 14 Feb 2004 17:35:07 +0000 (17:35 +0000)] 
Fix problems with malloc-failure handling. (CVS 1241)

FossilOrigin-Name: 398bc294c839368e7fa75a97ba8cc8d1639f9436

21 years agoThe sqlite_exec() function is now implemented using sqlite_compile() and
drh [Sat, 14 Feb 2004 16:31:02 +0000 (16:31 +0000)] 
The sqlite_exec() function is now implemented using sqlite_compile() and
sqlite_step().  This opens up lots of opportunity to remove old code. (CVS 1240)

FossilOrigin-Name: 9771ad1e811e02e10bb738550fbea447749083c5

21 years agoDisable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239)
drh [Sat, 14 Feb 2004 01:39:50 +0000 (01:39 +0000)] 
Disable the malloc.test tests if not compiled with -DMEMORY_DEBUG (CVS 1239)

FossilOrigin-Name: 41b6ad78a6097f35bfac6ff40d2e5d6071a1c4cd

21 years agoFix an uninitialized variable in shell.c that would cause a crash if you
drh [Fri, 13 Feb 2004 20:09:41 +0000 (20:09 +0000)] 
Fix an uninitialized variable in shell.c that would cause a crash if you
specified SQL on the command-line. (CVS 1238)

FossilOrigin-Name: 5a56090dde10ee29863021356d21c3f8c86e3f46

21 years agoBegin the process over converting sqlite_exec() over to use sqlite_compile()
drh [Fri, 13 Feb 2004 16:30:09 +0000 (16:30 +0000)] 
Begin the process over converting sqlite_exec() over to use sqlite_compile()
and sqlite_step().  The new sqlite_exec() is still commented out. (CVS 1237)

FossilOrigin-Name: b8f2ba7880b761e380b95ae63d8ab721f018443e

21 years agoFix a bug in the query flattener when trying to find the datatype of the
drh [Fri, 13 Feb 2004 16:22:22 +0000 (16:22 +0000)] 
Fix a bug in the query flattener when trying to find the datatype of the
rowid of a view.  Also fix a problem with sqlite_compile() and authorization
failures. (CVS 1236)

FossilOrigin-Name: aa0490ccd4a820a707dfb4905e67c01ffb4f758b

21 years agoFix an uninitialized variable introduced by check-in (1202). (CVS 1235)
drh [Fri, 13 Feb 2004 14:07:12 +0000 (14:07 +0000)] 
Fix an uninitialized variable introduced by check-in (1202). (CVS 1235)

FossilOrigin-Name: 9f149fdc1c6af1c663b91c878ed1903f82f80245

21 years agoAdd a new parameter to the (unimplemented) encryption API. (CVS 1234)
drh [Thu, 12 Feb 2004 20:49:36 +0000 (20:49 +0000)] 
Add a new parameter to the (unimplemented) encryption API. (CVS 1234)

FossilOrigin-Name: 5fe8f02306cf1c0af2148835cee0df3003ad0874

21 years agoAdd the SQLITE_NOTADB return code for cases when you try to open a file
drh [Thu, 12 Feb 2004 19:01:04 +0000 (19:01 +0000)] 
Add the SQLITE_NOTADB return code for cases when you try to open a file
that does not even remotely resemble an SQLite database file. (CVS 1233)

FossilOrigin-Name: 0c77cee70f078152969933c1d340cea1c86286b0

21 years agoAdd hooks on each attached database connection for storing auxiliary
drh [Thu, 12 Feb 2004 18:46:38 +0000 (18:46 +0000)] 
Add hooks on each attached database connection for storing auxiliary
information.  Add the USING clause to ATTACH. (CVS 1232)

FossilOrigin-Name: 800c11f4bce014a07110eb539992a609e6418406

21 years agoAll REPLACE INTO syntax inside of triggers. Ticket #610. (CVS 1231)
drh [Thu, 12 Feb 2004 17:28:13 +0000 (17:28 +0000)] 
All REPLACE INTO syntax inside of triggers.  Ticket #610. (CVS 1231)

FossilOrigin-Name: a6b862a9db6d409a53cc13e7008b27d4848b5509

21 years agoRemove unused variable. (CVS 1230)
drh [Thu, 12 Feb 2004 15:32:53 +0000 (15:32 +0000)] 
Remove unused variable. (CVS 1230)

FossilOrigin-Name: 74b234264ba2910ebd38e7b7ebbc369108a235cb

21 years agoAlways reload the schema after a rollback. Ticket #594. (CVS 1229)
drh [Thu, 12 Feb 2004 15:31:21 +0000 (15:31 +0000)] 
Always reload the schema after a rollback.  Ticket #594. (CVS 1229)

FossilOrigin-Name: 12c7a83f8e4055c4590983ef212648c781ebd963

21 years agoVACUUM returns SQLITE_INTERRUPT when interrupted. Ticket #593. (CVS 1228)
drh [Thu, 12 Feb 2004 13:02:55 +0000 (13:02 +0000)] 
VACUUM returns SQLITE_INTERRUPT when interrupted.  Ticket #593. (CVS 1228)

FossilOrigin-Name: 2fe9f5101cb0f743532912ece3d37f6c873e7025

21 years agoOnly define _FILE_OFFSET_BITS if it is not already defined. Ticket #605. (CVS 1227)
drh [Wed, 11 Feb 2004 16:38:06 +0000 (16:38 +0000)] 
Only define _FILE_OFFSET_BITS if it is not already defined.  Ticket #605. (CVS 1227)

FossilOrigin-Name: 300c5543dc83c6b7eacb0c81ed06f95004c0f6d8

21 years agoFix the shells so that they always enable the codec if it is available,
drh [Wed, 11 Feb 2004 10:37:23 +0000 (10:37 +0000)] 
Fix the shells so that they always enable the codec if it is available,
even if no key is supplied. (CVS 1226)

FossilOrigin-Name: 95989717e17d52b2306374f5cf7613c3bd4e7801

21 years agoFix an uninitialized variable in expr.c. Ticket #604. (CVS 1225)
drh [Wed, 11 Feb 2004 10:35:29 +0000 (10:35 +0000)] 
Fix an uninitialized variable in expr.c.  Ticket #604. (CVS 1225)

FossilOrigin-Name: 1673bf7c7b64542530ee03328186be33cb88c98d

21 years agoRefactor the interface to the randomness generator. (CVS 1224)
drh [Wed, 11 Feb 2004 09:46:30 +0000 (09:46 +0000)] 
Refactor the interface to the randomness generator. (CVS 1224)

FossilOrigin-Name: f2bdccf4bb2f796aafb64c33e55f62a1794d750c

21 years agoPass all (relevant) regression tests when using the codec. (CVS 1223)
drh [Wed, 11 Feb 2004 02:18:05 +0000 (02:18 +0000)] 
Pass all (relevant) regression tests when using the codec. (CVS 1223)

FossilOrigin-Name: 5200e9edc5fdba0285a3cb1cd808cbf66d7a349e

21 years agoAdjustments to the codec in the pager. (CVS 1222)
drh [Tue, 10 Feb 2004 23:51:05 +0000 (23:51 +0000)] 
Adjustments to the codec in the pager. (CVS 1222)

FossilOrigin-Name: be5122e99caacbeb5e568a2782fe2faf634ad355

21 years agoPerform updates in search order. Ticket #602. (CVS 1221)
drh [Tue, 10 Feb 2004 13:41:52 +0000 (13:41 +0000)] 
Perform updates in search order.  Ticket #602. (CVS 1221)

FossilOrigin-Name: cf1cec74ae039cd7cbc8a1032d29f067dedb4210

21 years agoFix for ticket #603. (CVS 1220)
drh [Tue, 10 Feb 2004 13:19:35 +0000 (13:19 +0000)] 
Fix for ticket #603. (CVS 1220)

FossilOrigin-Name: d0624d257789ac3f4cd3a7473bb741030c999b65

21 years agoMake the pager accessible from the btree structure always, not just during
drh [Tue, 10 Feb 2004 02:57:59 +0000 (02:57 +0000)] 
Make the pager accessible from the btree structure always, not just during
debugging. (CVS 1219)

FossilOrigin-Name: 9c6b4758a4b13a91f71be17751a76c0c14b4d4c3

21 years agoMove the file-format-2 to file-format-3 conversion into sqliteInit(). (CVS 1218)
drh [Tue, 10 Feb 2004 02:27:04 +0000 (02:27 +0000)] 
Move the file-format-2 to file-format-3 conversion into sqliteInit(). (CVS 1218)

FossilOrigin-Name: dcbe2800be2f805818724a7b9e468c4fd4f02529

21 years agoAllow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217)
drh [Tue, 10 Feb 2004 01:54:28 +0000 (01:54 +0000)] 
Allow SQLITE_PAGE_SIZE to be redefined on the compiler command-line. (CVS 1217)

FossilOrigin-Name: 4c7bf714b5f3d2bb7366367ddf906141a7e36407

21 years agoAfter code is generated for a subquery, delete the Select structure in order
drh [Mon, 9 Feb 2004 14:37:50 +0000 (14:37 +0000)] 
After code is generated for a subquery, delete the Select structure in order
to force the temporary table to be used and to prevent the subquery from
being evaluated a second time.  Ticket #601. (CVS 1216)

FossilOrigin-Name: 1cff18868dab5f8ead8ed8d07e088d7fdda04569

21 years agoAdd test case for ticket #601. (CVS 1215)
drh [Mon, 9 Feb 2004 14:35:28 +0000 (14:35 +0000)] 
Add test case for ticket #601. (CVS 1215)

FossilOrigin-Name: 096312dacb9eb2f8da3cec1504aef8629b505e7f

21 years agoAdd an optional codec to the pager layer. (CVS 1214)
drh [Mon, 9 Feb 2004 01:20:36 +0000 (01:20 +0000)] 
Add an optional codec to the pager layer. (CVS 1214)

FossilOrigin-Name: 2f0c122cfb84dea58d112324a0bdd8b85552a9fa

21 years agoVersion 2.8.12 (CVS 1213)
drh [Sun, 8 Feb 2004 18:10:50 +0000 (18:10 +0000)] 
Version 2.8.12 (CVS 1213)

FossilOrigin-Name: 1736d415d776aa1cbdd33d987d21365ebf260f11

21 years agoPerpare for the 2.8.12 release. (CVS 1212)
drh [Sun, 8 Feb 2004 18:07:34 +0000 (18:07 +0000)] 
Perpare for the 2.8.12 release. (CVS 1212)

FossilOrigin-Name: 93ccd1b1d63b5b914b84b0463f2267bcfaadafa3

21 years agoFix a bug in the VDBE that occurs when a CreateTable or CreateIndex fails. (CVS 1211)
drh [Sun, 8 Feb 2004 06:17:19 +0000 (06:17 +0000)] 
Fix a bug in the VDBE that occurs when a CreateTable or CreateIndex fails. (CVS 1211)

FossilOrigin-Name: 42cfd541dcc31d1ef92387e3fd2346db61d0ecbd

21 years agoAdd the crashtest1.c program used to test the ability of the database to
drh [Sun, 8 Feb 2004 06:06:37 +0000 (06:06 +0000)] 
Add the crashtest1.c program used to test the ability of the database to
survive a program crash or power failure.  Ticket #599. (CVS 1210)

FossilOrigin-Name: 597a59a72d662b291fb09a069547efd08aa5adb1

21 years agoFix inaccuracies and add details to comments in the pager. Change the name
drh [Sun, 8 Feb 2004 06:05:46 +0000 (06:05 +0000)] 
Fix inaccuracies and add details to comments in the pager.  Change the name
of one function to make its purpose clearer.  Ticket #599. (CVS 1209)

FossilOrigin-Name: 48832d35ed0d5ba02908822c749591e76b790c48

21 years agoPreliminary fix for ticket #599. More testing and analysis needed. (CVS 1208)
drh [Sun, 8 Feb 2004 00:40:52 +0000 (00:40 +0000)] 
Preliminary fix for ticket #599.  More testing and analysis needed. (CVS 1208)

FossilOrigin-Name: dc5be2c82b591a385adf02863d89e113272e2ebd

21 years agoRemove undocumented extensions from sqlite_mprintf() and friends in order to
drh [Mon, 2 Feb 2004 12:29:25 +0000 (12:29 +0000)] 
Remove undocumented extensions from sqlite_mprintf() and friends in order to
make it about 10% smaller. (CVS 1207)

FossilOrigin-Name: 0b3f552b986fd89c48c350b0746be93b9d276ecc

21 years agoFix the handling of -init option to the sqlite shell. Ticket #568.
drh [Sun, 1 Feb 2004 01:22:50 +0000 (01:22 +0000)] 
Fix the handling of -init option to the sqlite shell. Ticket #568.
Also add hooks for encrypting the database. (CVS 1206)

FossilOrigin-Name: 3c796de8d1af55944f396f08feaa9e69c1652896

21 years agoFix a bug introduced by the previous check-in. (CVS 1205)
drh [Sat, 31 Jan 2004 20:40:42 +0000 (20:40 +0000)] 
Fix a bug introduced by the previous check-in. (CVS 1205)

FossilOrigin-Name: 04cf22785e68fcd4098e6c10a89386108cd0bf07

21 years agoA few more optimizations to the VDBE. (CVS 1204)
drh [Sat, 31 Jan 2004 20:20:29 +0000 (20:20 +0000)] 
A few more optimizations to the VDBE. (CVS 1204)

FossilOrigin-Name: 06e7ff4cb8c73fd690c6d5b5f530a30d83f4f10c

21 years agoRework internal data structures to make the VDBE about 15% smaller. (CVS 1203)
drh [Sat, 31 Jan 2004 19:22:56 +0000 (19:22 +0000)] 
Rework internal data structures to make the VDBE about 15% smaller. (CVS 1203)

FossilOrigin-Name: 8273c74bd09d1a044cb5154498b0a39939f6e3ed

21 years agoRework the VDBE data structures to combine string representations into the
drh [Fri, 30 Jan 2004 14:49:16 +0000 (14:49 +0000)] 
Rework the VDBE data structures to combine string representations into the
same structure with integer and floating point.  This opens the door to
significant optimizations. (CVS 1202)

FossilOrigin-Name: c0faa1c67a967f028cd018e58988fb08bc814d3d

21 years agoMake sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201)
drh [Fri, 30 Jan 2004 02:01:03 +0000 (02:01 +0000)] 
Make sure min() and max() optimizations work for subqueries. Ticket #587. (CVS 1201)

FossilOrigin-Name: af73fbca839f8cbe39c21f1f9e439fe9b79005c8

21 years agoChange permissions on the install-sh file to be executable. Ticket #582. (CVS 1200)
drh [Tue, 27 Jan 2004 17:46:55 +0000 (17:46 +0000)] 
Change permissions on the install-sh file to be executable.  Ticket #582. (CVS 1200)

FossilOrigin-Name: eafa714d1f0abe7e4822a6d137c2a7c6179ffab3

21 years agoAdd a web page describing when it is appropriate to use SQLite and when it
drh [Tue, 27 Jan 2004 15:58:37 +0000 (15:58 +0000)] 
Add a web page describing when it is appropriate to use SQLite and when it
is not. (CVS 1199)

FossilOrigin-Name: d77e47764818ef495894013fb26b1a510f2f1a7e

21 years agoModularize the column name resolution code so that it is smaller, faster,
drh [Sun, 25 Jan 2004 22:44:58 +0000 (22:44 +0000)] 
Modularize the column name resolution code so that it is smaller, faster,
and ready for some enhancements that will fix long-standing name
resolutions problems. (CVS 1198)

FossilOrigin-Name: d3648034b409822909d79eb5aa4e64cafa986541

21 years agoAdd the ability to group FROM terms using parentheses. Names of columns in
drh [Sat, 24 Jan 2004 20:18:12 +0000 (20:18 +0000)] 
Add the ability to group FROM terms using parentheses.  Names of columns in
a join no longer include the table name. (CVS 1197)

FossilOrigin-Name: 3626f6d4a1adb4209d5bd9e6477343b52bddbdf2