]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
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

21 years agoFix typo. Ticket #577. (CVS 1196)
drh [Thu, 22 Jan 2004 23:38:21 +0000 (23:38 +0000)] 
Fix typo.  Ticket #577. (CVS 1196)

FossilOrigin-Name: 3dc951951947a9188ecba1b84e48c65e34c4df16

21 years agoIn test programs, an SQLITE_SCHEMA return is retried repeatedly, not just once. ...
drh [Wed, 21 Jan 2004 13:35:13 +0000 (13:35 +0000)] 
In test programs, an SQLITE_SCHEMA return is retried repeatedly, not just once. (CVS 1195)

FossilOrigin-Name: df3509e13dc05751b7a5af07b57bca449fe5244c

21 years agoMake ATTACH and DETACH work with the non-callback API. Ticket #574. (CVS 1194)
drh [Tue, 20 Jan 2004 11:54:03 +0000 (11:54 +0000)] 
Make ATTACH and DETACH work with the non-callback API.  Ticket #574. (CVS 1194)

FossilOrigin-Name: c32a80fe3cd6dda5238e59bd48d9dd22b4856304

21 years agodocumented pragma foreign_key_list().
jplyon [Mon, 19 Jan 2004 05:09:24 +0000 (05:09 +0000)] 
documented pragma foreign_key_list().
updated docs for removed behavior: Oracle join syntax and temp indexes. (CVS 1193)

FossilOrigin-Name: 06bd5070966b59730a91bc4d384df4f8abaadd37

21 years agocomment typos (CVS 1192)
jplyon [Mon, 19 Jan 2004 04:57:53 +0000 (04:57 +0000)] 
comment typos (CVS 1192)

FossilOrigin-Name: 7972ee321974380a59fef752f5643d98f9df38cc

21 years agocomment typos (CVS 1191)
jplyon [Mon, 19 Jan 2004 04:55:56 +0000 (04:55 +0000)] 
comment typos (CVS 1191)

FossilOrigin-Name: de35c36ed7657903ebba0c5acff75baaa0453f87

21 years agocoment typo (CVS 1190)
jplyon [Mon, 19 Jan 2004 04:54:28 +0000 (04:54 +0000)] 
coment typo (CVS 1190)

FossilOrigin-Name: 0d2683dc5ecb886ae9625484b51e65df49b3235d

21 years agocoment typo (CVS 1189)
jplyon [Mon, 19 Jan 2004 04:53:24 +0000 (04:53 +0000)] 
coment typo (CVS 1189)

FossilOrigin-Name: 8210b2d818ab83a97b3b71b432770436116f4770

21 years agocomment (CVS 1188)
jplyon [Mon, 19 Jan 2004 04:52:29 +0000 (04:52 +0000)] 
comment (CVS 1188)

FossilOrigin-Name: fa55c9861e1cc372a36958383a86895dc311bb4b

21 years agoDo not use strcpy() on overlapping buffers. (CVS 1187)
drh [Sat, 17 Jan 2004 01:16:21 +0000 (01:16 +0000)] 
Do not use strcpy() on overlapping buffers. (CVS 1187)

FossilOrigin-Name: ed6bd2eb39a0940c4f41d365ddc81ecc7066cf4e

21 years agoAccess to free()ed memory problem fixed. Found by electric fence.
drh [Fri, 16 Jan 2004 20:01:31 +0000 (20:01 +0000)] 
Access to free()ed memory problem fixed.  Found by electric fence.
Only an issue when doing an EXPLAIN of a CREATE INDEX. (CVS 1186)

FossilOrigin-Name: 6604e5f7d332b484e84d177f93c9d9f2ab54a32b

21 years agoSee ticket #569; eliminates warnings for Cygwin v1.5 and above. (CVS 1185)
dougcurrie [Fri, 16 Jan 2004 19:11:28 +0000 (19:11 +0000)] 
See ticket #569; eliminates warnings for Cygwin v1.5 and above. (CVS 1185)

FossilOrigin-Name: a0f8b1f3cea9a0542f8d36898bf98df3c59f12e0

21 years agoMore compaction of expr.c. (CVS 1184)
drh [Fri, 16 Jan 2004 16:42:53 +0000 (16:42 +0000)] 
More compaction of expr.c. (CVS 1184)

FossilOrigin-Name: 92e7f78057c4e8f6214b6e0a2d80c3ffcbfdf68e

21 years agoIncremental code compaction in expr.c. Now about 4% smaller.
drh [Fri, 16 Jan 2004 15:55:37 +0000 (15:55 +0000)] 
Incremental code compaction in expr.c.  Now about 4% smaller.
Lots more work to do. (CVS 1183)

FossilOrigin-Name: d292ba5148059dce3893b80eabdca4af9f75194e

21 years agoFix a buffer-overflow problem in the randStr function (used only for testing). (CVS...
drh [Fri, 16 Jan 2004 13:58:18 +0000 (13:58 +0000)] 
Fix a buffer-overflow problem in the randStr function (used only for testing). (CVS 1182)

FossilOrigin-Name: 42c79edc2e8d1051b3bca915b4b205c601b8077f

21 years agoMore aggressive retry schedule in sqlite_busy_timeout(). (CVS 1181)
drh [Thu, 15 Jan 2004 13:29:31 +0000 (13:29 +0000)] 
More aggressive retry schedule in sqlite_busy_timeout(). (CVS 1181)

FossilOrigin-Name: 5e85025be7aa4a03b0cfb4d0f28a2e44653b9d3f

21 years agoAllow "<expr> IN <table>" as a shorthand for
drh [Thu, 15 Jan 2004 03:30:24 +0000 (03:30 +0000)] 
Allow "<expr> IN <table>" as a shorthand for
"<expr> IN (SELECT * FROM <table>)" (CVS 1180)

FossilOrigin-Name: 01874d252ac44861e927dea3f5534f67e19b1fa8

21 years agoReinsert the experimental sqlite_commit_hook() API. (CVS 1179)
drh [Thu, 15 Jan 2004 02:44:03 +0000 (02:44 +0000)] 
Reinsert the experimental sqlite_commit_hook() API. (CVS 1179)

FossilOrigin-Name: 72bc84f2f18f6eeb279a4ad670310e85d154f663

21 years agoFix comparisons of ROWID against floating point numbers so that they work
drh [Wed, 14 Jan 2004 21:59:22 +0000 (21:59 +0000)] 
Fix comparisons of ROWID against floating point numbers so that they work
correctly.  Ticket #377 and #567. (CVS 1178)

FossilOrigin-Name: c9ac3db8e08403398ec344757385334601a59374

21 years agoVersion 2.8.11 (CVS 1177)
drh [Wed, 14 Jan 2004 13:50:59 +0000 (13:50 +0000)] 
Version 2.8.11 (CVS 1177)

FossilOrigin-Name: a9f25347de6d2bf843a8aebf7935e9c8a1f2319c

21 years agoBump the version number for the next release. (CVS 1176)
drh [Wed, 14 Jan 2004 13:43:43 +0000 (13:43 +0000)] 
Bump the version number for the next release. (CVS 1176)

FossilOrigin-Name: 2812dd5fc99c959f41b24b0f6b280b67b06fe9d9

21 years agoIgnore NULLs in a subquery as the right operand of IN. Ticket #565. (CVS 1175)
drh [Wed, 14 Jan 2004 13:38:54 +0000 (13:38 +0000)] 
Ignore NULLs in a subquery as the right operand of IN.  Ticket #565. (CVS 1175)

FossilOrigin-Name: c9e7996fb9080b715e9b273a3ac3ed3744e10a77

21 years agoVersion 2.8.10 (CVS 1174)
drh [Wed, 14 Jan 2004 03:49:43 +0000 (03:49 +0000)] 
Version 2.8.10 (CVS 1174)

FossilOrigin-Name: 8bef75ab85197d926d924ae689769207df9a12f8

21 years agoMove some files around and bump the version number in preparation for the
drh [Wed, 14 Jan 2004 03:32:37 +0000 (03:32 +0000)] 
Move some files around and bump the version number in preparation for the
release of 2.8.10. (CVS 1173)

FossilOrigin-Name: 74c661850e1899c457d4e822d8284bb66e1dc651

21 years agoRemove an incomplete comment that somehow snuck into the sources. (CVS 1172)
drh [Wed, 14 Jan 2004 03:12:42 +0000 (03:12 +0000)] 
Remove an incomplete comment that somehow snuck into the sources. (CVS 1172)

FossilOrigin-Name: ea1ad4653e6248f112d5516a0dcf3a72aa9b60d7

21 years agoOn unix, embargo close() operations until all locks have cleared from the
drh [Mon, 12 Jan 2004 00:39:05 +0000 (00:39 +0000)] 
On unix, embargo close() operations until all locks have cleared from the
file.  Ticket #561. (CVS 1171)

FossilOrigin-Name: 1ebe5fc7b03a6b070a5d52ffedb95f0d519ab068

21 years agoPrevious commit of changes to the in-memory backend was not quite right.
drh [Mon, 12 Jan 2004 00:38:18 +0000 (00:38 +0000)] 
Previous commit of changes to the in-memory backend was not quite right.
This check-in should square things away. (CVS 1170)

FossilOrigin-Name: 75d91e3bca44787768b1970203878dd4b1e31e55

21 years agoMake sure the in-memory database can handle malloc failures. (CVS 1169)
drh [Mon, 12 Jan 2004 00:21:52 +0000 (00:21 +0000)] 
Make sure the in-memory database can handle malloc failures. (CVS 1169)

FossilOrigin-Name: ba92af182c6c9c6b2e3816006191eedd424cdf1a

21 years agoRemove unused code and tighten existing code to make the library a little
drh [Thu, 8 Jan 2004 02:17:31 +0000 (02:17 +0000)] 
Remove unused code and tighten existing code to make the library a little
smaller. (CVS 1168)

FossilOrigin-Name: 34a6b7416c6c9bcdf301f5e7b072a0362a746105