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

21 years agoRework the fix to ticket #461 so that we do not have to do redundant tests
drh [Wed, 7 Jan 2004 20:37:52 +0000 (20:37 +0000)] 
Rework the fix to ticket #461 so that we do not have to do redundant tests
of WHERE clause terms looking for NULLs.  See also check-in (1103). (CVS 1167)

FossilOrigin-Name: 5fd581787e88173f0303f870fc956ec9285cca4e

21 years agoPermit sqlite_exec() to be called from within user-defined functions. (CVS 1166)
drh [Wed, 7 Jan 2004 19:24:48 +0000 (19:24 +0000)] 
Permit sqlite_exec() to be called from within user-defined functions. (CVS 1166)

FossilOrigin-Name: 03636c94a542b1f90a3acfbe65a9c2976872073f

21 years agoDefer the {quote: MoveTo}
drh [Wed, 7 Jan 2004 18:52:56 +0000 (18:52 +0000)] 
Defer the {quote: MoveTo}
opcode in VDBE until the data is actually needed.  Sometimes
the data is never needed, resulting in a performance increase.  On an indexed
order search with a large OFFSET, queries times can be an order of magnitude
faster. (CVS 1165)

FossilOrigin-Name: d3e96da20d269a068188915b3cc0eb02d330d316

21 years agoMake it safe to call sqliteMalloc() with a request for 0 bytes. Ticket #534. (CVS...
drh [Wed, 7 Jan 2004 03:41:03 +0000 (03:41 +0000)] 
Make it safe to call sqliteMalloc() with a request for 0 bytes.  Ticket #534. (CVS 1164)

FossilOrigin-Name: 6c858db2c099c7ba73d72e02b19bf6173620db13

21 years agoPreserve the HH:MM:SS for most date/time modifiers. Ticket #551. (CVS 1163)
drh [Wed, 7 Jan 2004 03:29:16 +0000 (03:29 +0000)] 
Preserve the HH:MM:SS for most date/time modifiers.  Ticket #551. (CVS 1163)

FossilOrigin-Name: 70df32b716b0d6a4f72bb3ae6496431e53733b6a

21 years agoUse "long double" to hold intermediate values when doing ascii to binary
drh [Wed, 7 Jan 2004 03:04:27 +0000 (03:04 +0000)] 
Use "long double" to hold intermediate values when doing ascii to binary
and binary to ascii conversions of floating point numbers. (CVS 1162)

FossilOrigin-Name: 8371f662d22be0a3c58e0503c7511faea1640955

21 years agoAdd a typecast to work around a bug in the Metrowerks Code Warrior compiler.
drh [Wed, 7 Jan 2004 02:52:07 +0000 (02:52 +0000)] 
Add a typecast to work around a bug in the Metrowerks Code Warrior compiler.
Ticket #553. (CVS 1161)

FossilOrigin-Name: 4146f8cc3ff5339b5685e9c5121888ae08ee0807

21 years agoVersion 2.8.9 (CVS 1160)
drh [Tue, 6 Jan 2004 02:23:46 +0000 (02:23 +0000)] 
Version 2.8.9 (CVS 1160)

FossilOrigin-Name: d8ae6bddeb70f1450ccd3a4735ccf6fe3a042a07

21 years agoAdditional integer overflow boundary case tests. (CVS 1159)
drh [Tue, 6 Jan 2004 01:52:34 +0000 (01:52 +0000)] 
Additional integer overflow boundary case tests. (CVS 1159)

FossilOrigin-Name: 532170d4b8fc7a4e596a817257e9e1f81d364940

21 years agoIncrease the version number and update the change log prior to the next
drh [Tue, 6 Jan 2004 01:27:00 +0000 (01:27 +0000)] 
Increase the version number and update the change log prior to the next
release. (CVS 1158)

FossilOrigin-Name: b99b68d026a0d58338a1d578e15a40dcdcdb47a9

21 years agoFix problem in the code generator were incorrect code was being created if
drh [Tue, 6 Jan 2004 01:13:46 +0000 (01:13 +0000)] 
Fix problem in the code generator were incorrect code was being created if
the SQL source contained a negative integer that was too large to fit in
a 32-bit signed integer variable.  Ticket #552. (CVS 1157)

FossilOrigin-Name: b8381d9fe99273507e8626638110646801afef06

21 years agoAdd the sqlite_current_time variable for testing purposes. (CVS 1156)
drh [Tue, 6 Jan 2004 00:44:24 +0000 (00:44 +0000)] 
Add the sqlite_current_time variable for testing purposes. (CVS 1156)

FossilOrigin-Name: 23fa407d50741bc0719259792398f28c1d0f12c2

21 years agoThe "EST" timezone designation is ambiguous. Do not use it in the test
drh [Fri, 2 Jan 2004 15:08:43 +0000 (15:08 +0000)] 
The "EST" timezone designation is ambiguous.  Do not use it in the test
scripts. (CVS 1155)

FossilOrigin-Name: 720b565e2d02344e4d38263f4995dfabc60c0860

21 years agoAvoid an assertion fault that can occur with invalid UTF8 on the LENGTH()
drh [Fri, 2 Jan 2004 13:17:48 +0000 (13:17 +0000)] 
Avoid an assertion fault that can occur with invalid UTF8 on the LENGTH()
function.  Ticket #548. (CVS 1154)

FossilOrigin-Name: 7080fc39eaf98ef7a7d1c1819603f67841f35c72

21 years agoRemove unused code from the integrity_check logic. Ticket #545. (CVS 1153)
drh [Thu, 1 Jan 2004 12:33:43 +0000 (12:33 +0000)] 
Remove unused code from the integrity_check logic.  Ticket #545. (CVS 1153)

FossilOrigin-Name: ee51e205fb6ef412db6a46077e8bc1554aadcca1

21 years agoFix a bug in the SQLITE_PROFILE conditional compilation. (CVS 1152)
drh [Wed, 31 Dec 2003 17:57:10 +0000 (17:57 +0000)] 
Fix a bug in the SQLITE_PROFILE conditional compilation. (CVS 1152)

FossilOrigin-Name: 597b33f696c0cde84529cd06a8f95a8ccc8f1e8e

21 years agoFix for ticket #542. (CVS 1151)
drh [Wed, 31 Dec 2003 17:25:47 +0000 (17:25 +0000)] 
Fix for ticket #542. (CVS 1151)

FossilOrigin-Name: 458cfa5ba82f2d676e398437a4b1d26d77582d10

21 years agoFix a bug (ticket #541) introduced by the previous check-in ((1149)). (CVS 1150)
drh [Wed, 31 Dec 2003 16:00:19 +0000 (16:00 +0000)] 
Fix a bug (ticket #541) introduced by the previous check-in ((1149)). (CVS 1150)

FossilOrigin-Name: 646244008fb8a6eef4169291d75da59fa1ab26f9

21 years agoReduce the randomness in the sqliteRandomSeed() routine in order to silence
drh [Wed, 31 Dec 2003 13:21:18 +0000 (13:21 +0000)] 
Reduce the randomness in the sqliteRandomSeed() routine in order to silence
bogus errors from valgrind.  Tickets #535 and #536. (CVS 1149)

FossilOrigin-Name: cfe0acf9ec6c89f1e77b8be7dcc23029984de1ce

21 years agominor edits for new date.c with mingw/msys on Windows (CVS 1148)
dougcurrie [Wed, 24 Dec 2003 01:41:19 +0000 (01:41 +0000)] 
minor edits for new date.c with mingw/msys on Windows (CVS 1148)

FossilOrigin-Name: 9392c514501be333a3c22b552dc036e083eb22b4

21 years agoUpdate date/time functions so that they correctly handle NULL arguments. (CVS 1147)
drh [Tue, 23 Dec 2003 16:34:12 +0000 (16:34 +0000)] 
Update date/time functions so that they correctly handle NULL arguments. (CVS 1147)

FossilOrigin-Name: a5a5fbd60153dd068ec2559455146e84da075b90

21 years agoAdd localtime<-->UTC conversions to the date functions. (CVS 1146)
drh [Tue, 23 Dec 2003 16:22:18 +0000 (16:22 +0000)] 
Add localtime<-->UTC conversions to the date functions. (CVS 1146)

FossilOrigin-Name: 8482b8c44766e7f80fc449b3dbdd3f37396c332b

21 years agoTest functions tolerate an "0x" before a pointer value. Ticket #452. (CVS 1145)
drh [Tue, 23 Dec 2003 03:06:23 +0000 (03:06 +0000)] 
Test functions tolerate an "0x" before a pointer value.  Ticket #452. (CVS 1145)

FossilOrigin-Name: c6c5e07b65ae1c30117f0276a1002d5036697cf1

21 years agoUse a built-in atof() function instead of the one from the library to
drh [Tue, 23 Dec 2003 02:17:35 +0000 (02:17 +0000)] 
Use a built-in atof() function instead of the one from the library to
avoid problems with locale.  Ticket #305. (CVS 1144)

FossilOrigin-Name: 4d9edbc50f7dee64edbadad2e2dc4f93d8248b3b

21 years agoOptimizations to the LEMON parser template. (CVS 1143)
drh [Mon, 22 Dec 2003 14:53:19 +0000 (14:53 +0000)] 
Optimizations to the LEMON parser template. (CVS 1143)

FossilOrigin-Name: 06db29df8f0c1cd29e696537e622f0c5456056f5

21 years agoFix some minor problems with the new test4.c module used for doing thread
drh [Sat, 20 Dec 2003 04:00:52 +0000 (04:00 +0000)] 
Fix some minor problems with the new test4.c module used for doing thread
testing. (CVS 1142)

FossilOrigin-Name: 952924084aac4a7fa84a7cb7aaac869d35db1896

21 years agoUpdate configuration and make files for mingw/msys on Windows (CVS 1141)
dougcurrie [Fri, 19 Dec 2003 20:09:51 +0000 (20:09 +0000)] 
Update configuration and make files for mingw/msys on Windows (CVS 1141)

FossilOrigin-Name: 1e9689672c94e5ab89f07099c1402e157c8b02c1

21 years agoRemove a comma at the end of an enum definition. Some compilers could not
drh [Fri, 19 Dec 2003 12:32:45 +0000 (12:32 +0000)] 
Remove a comma at the end of an enum definition.  Some compilers could not
deal with it. (CVS 1140)

FossilOrigin-Name: b1890a5b9c1222086b3aae92e49eb090a17a6492

21 years agoMakefile updates for the new "test4.c" module. Also disable large file
drh [Fri, 19 Dec 2003 12:31:19 +0000 (12:31 +0000)] 
Makefile updates for the new "test4.c" module.  Also disable large file
tests for archic TCL versions. (CVS 1139)

FossilOrigin-Name: 55e2488912871381959326ab7fa89123ab30d659

21 years agoA better fix for ticket #530 - one that is likely to work on unix
drh [Fri, 19 Dec 2003 08:40:22 +0000 (08:40 +0000)] 
A better fix for ticket #530 - one that is likely to work on unix
implementations in addition to linux.  Also more tests for multi-thread
locking added. (CVS 1138)

FossilOrigin-Name: 7dddbeb586504de30c64a1e61614da447f18c8ba

21 years agoAdd new thread-testing code and fix locking under Linux threads. Ticket #530. (CVS...
drh [Fri, 19 Dec 2003 02:52:05 +0000 (02:52 +0000)] 
Add new thread-testing code and fix locking under Linux threads.  Ticket #530. (CVS 1137)

FossilOrigin-Name: b36a4bb61094d539273c21a9e4042384f10a7806

21 years agoTypo on the "datatypes.html" document. (CVS 1136)
drh [Thu, 18 Dec 2003 14:19:41 +0000 (14:19 +0000)] 
Typo on the "datatypes.html" document. (CVS 1136)

FossilOrigin-Name: 80b1e277123c07b2db7441a9e600dd69ef55a0da

21 years agoVersion 2.8.8 (CVS 1135)
drh [Thu, 18 Dec 2003 01:22:54 +0000 (01:22 +0000)] 
Version 2.8.8 (CVS 1135)

FossilOrigin-Name: a0451ccf2d0377536073ecaa2d6b70d05f5a5734

21 years agoBump the version number and update the change log in preparation for the
drh [Thu, 18 Dec 2003 00:02:43 +0000 (00:02 +0000)] 
Bump the version number and update the change log in preparation for the
next release. (CVS 1134)

FossilOrigin-Name: 9ad0bdf624e7dba448587c58eacd1e9cd2784316

21 years agoMake sure the pagers in-memory cache states in sync with the disk file.
drh [Wed, 17 Dec 2003 23:57:34 +0000 (23:57 +0000)] 
Make sure the pagers in-memory cache states in sync with the disk file.
Ticket #529. (CVS 1133)

FossilOrigin-Name: da00efb13fe8ccf1c27e4e1193df6b53de9463f4

21 years agoImprovements to the way PRAGMA integrity_check works. More likely to output
drh [Tue, 16 Dec 2003 03:44:47 +0000 (03:44 +0000)] 
Improvements to the way PRAGMA integrity_check works.  More likely to output
userful information when given a corrupt database. (CVS 1132)

FossilOrigin-Name: b92c31d6c138f9462730cecfe14f7dde19778e79

21 years agoUpdates to the homepage - fix the CVS access instructions. (CVS 1131)
drh [Mon, 15 Dec 2003 17:51:19 +0000 (17:51 +0000)] 
Updates to the homepage - fix the CVS access instructions. (CVS 1131)

FossilOrigin-Name: 653a7dd97ed95e66bd2973169735ee73ee348576

21 years agoFix a bulk-memory initialization problem in the expression list logic. (CVS 1130)
drh [Wed, 10 Dec 2003 03:13:43 +0000 (03:13 +0000)] 
Fix a bulk-memory initialization problem in the expression list logic. (CVS 1130)

FossilOrigin-Name: d6549954408b01e5eaf865b9100739c94de28f16

21 years agoFix the code generator to a void a VDBE stack overflow on 3-way joins.
drh [Wed, 10 Dec 2003 01:31:21 +0000 (01:31 +0000)] 
Fix the code generator to a void a VDBE stack overflow on 3-way joins.
Ticket #519. (CVS 1129)

FossilOrigin-Name: 230a4ff2c8a3927533baf5b22edc9f25490d5443

21 years agoMake the VACUUM command run out of the VDBE like all other commands.
drh [Sun, 7 Dec 2003 00:24:35 +0000 (00:24 +0000)] 
Make the VACUUM command run out of the VDBE like all other commands.
(Ticket #464).  Make the VACUUM command work even if there are VIEWs
in the SQLITE_MASTER table that come before tables they reference.
(Ticket #515) (CVS 1128)

FossilOrigin-Name: 614cbbafa180469744421f8fbe56cb392f48d05f

21 years agoFail an ATTACH if the auxiliary database is locked. Ticket #514. (CVS 1127)
drh [Sat, 6 Dec 2003 22:22:35 +0000 (22:22 +0000)] 
Fail an ATTACH if the auxiliary database is locked.  Ticket #514. (CVS 1127)

FossilOrigin-Name: ac428c8d4a731678cc26cf198689814a8a56d141

21 years agoAlways use "(char*)0" to terminate the argument list of sqliteSetString().
drh [Sat, 6 Dec 2003 21:43:55 +0000 (21:43 +0000)] 
Always use "(char*)0" to terminate the argument list of sqliteSetString().
This is needed for 64-bit systems that use a 32-bit integer by default. (CVS 1126)

FossilOrigin-Name: 656c90387a4a714b4f31040ece9b0e15e30934af

21 years agoUse sqlite_freemem() instead of free() in the shell. Windows needs this.
drh [Thu, 4 Dec 2003 20:51:41 +0000 (20:51 +0000)] 
Use sqlite_freemem() instead of free() in the shell.  Windows needs this.
(Unix does not care.)  Ticket #444. (CVS 1125)

FossilOrigin-Name: e5e6a8481b2225e826c8e890ddc44f06759fe72b

21 years agoVersion 2.8.7 (CVS 1124)
drh [Thu, 4 Dec 2003 13:47:04 +0000 (13:47 +0000)] 
Version 2.8.7 (CVS 1124)

FossilOrigin-Name: d48b0b018d47470689cc49f3be4cde50db165454

21 years agoUpdate change log and version in preparation for the 2.8.7 release. (CVS 1123)
drh [Thu, 4 Dec 2003 13:44:32 +0000 (13:44 +0000)] 
Update change log and version in preparation for the 2.8.7 release. (CVS 1123)

FossilOrigin-Name: 9e79ab6ce06d68fcd7efa207d0ffcd1c51c13d58

21 years agoDisallow temporary indices on persistent tables. (CVS 1122)
drh [Thu, 27 Nov 2003 00:48:57 +0000 (00:48 +0000)] 
Disallow temporary indices on persistent tables. (CVS 1122)

FossilOrigin-Name: 72bf73b2c1e3594aa85920e47fc345bba56c80d0

21 years agoFix typos in file format documentation. Ticket #505. (CVS 1121)
drh [Tue, 25 Nov 2003 23:48:57 +0000 (23:48 +0000)] 
Fix typos in file format documentation.  Ticket #505. (CVS 1121)

FossilOrigin-Name: 4eef93814f4a26de4a088c464545443547281abd

21 years agoFix typo in file format documentation. Ticket #502. (CVS 1120)
drh [Mon, 24 Nov 2003 23:11:08 +0000 (23:11 +0000)] 
Fix typo in file format documentation.  Ticket #502. (CVS 1120)

FossilOrigin-Name: 72f3e7c2b0258271956ed7a43b3388bb74bf62ec

21 years agoFix a typo in a #define that was commented out. No impact to working code.
drh [Tue, 11 Nov 2003 23:30:35 +0000 (23:30 +0000)] 
Fix a typo in a #define that was commented out.  No impact to working code.
Ticket #476. (CVS 1119)

FossilOrigin-Name: 21c2f96e814004d00691e3d7a632f193b0e49ee5

21 years agoAdded information on MySQL 4.0.16 to the NULL-handling survey. (CVS 1117)
drh [Sat, 8 Nov 2003 12:07:01 +0000 (12:07 +0000)] 
Added information on MySQL 4.0.16 to the NULL-handling survey. (CVS 1117)

FossilOrigin-Name: e22e3ab53a841b26984240760b0438efc83661d7

21 years agoRevised date/time functions - now broken out into a separate source file.
drh [Sat, 1 Nov 2003 01:53:53 +0000 (01:53 +0000)] 
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

21 years agoFork the tree for project "shrike" (CVS 1118)
drh [Thu, 30 Oct 2003 06:59:59 +0000 (06:59 +0000)] 
Fork the tree for project "shrike" (CVS 1118)

FossilOrigin-Name: 181260c0aa7837feca9e415225ece0e9c4032c7a

21 years agoFix progress test error 1-2 (CVS 1115)
peter [Thu, 23 Oct 2003 15:27:11 +0000 (15:27 +0000)] 
Fix progress test error 1-2 (CVS 1115)

FossilOrigin-Name: c3a495026c7eafd576042a05a9a5f585ba8ba9b9

21 years agoComment changes to the lemon parser template. Change some sqliteMalloc() calls
drh [Wed, 22 Oct 2003 22:15:27 +0000 (22:15 +0000)] 
Comment changes to the lemon parser template.  Change some sqliteMalloc() calls
to sqliteMallocRaw() for speed.  Update the website template. (CVS 1114)

FossilOrigin-Name: c637caf13f579959ecdb6b134d0114e8efbcac60

21 years agoFix bugs in lemon associated with the change to a perfect hash table. (CVS 1113)
drh [Tue, 21 Oct 2003 16:34:41 +0000 (16:34 +0000)] 
Fix bugs in lemon associated with the change to a perfect hash table. (CVS 1113)

FossilOrigin-Name: c0d1b26966aeb445fea5792e5a9e93632e758c2a

21 years agoConvert lemon to use a single perfect hash table for storing the actions.
drh [Tue, 21 Oct 2003 13:16:03 +0000 (13:16 +0000)] 
Convert lemon to use a single perfect hash table for storing the actions.
This should make the resulting parser both smaller and faster. (CVS 1112)

FossilOrigin-Name: 4f955c00076b16166ff837749efb84201eab3c3a

21 years agoAdd sqlite_progress_handler() API for specifying an progress callback (CVS 1111)
danielk1977 [Sat, 18 Oct 2003 09:37:26 +0000 (09:37 +0000)] 
Add sqlite_progress_handler() API for specifying an progress callback (CVS 1111)

FossilOrigin-Name: ddb364635a207658664ea92fc677cf16a143a938

21 years agoUpdate to the date functions. (CVS 1110)
drh [Fri, 10 Oct 2003 02:09:56 +0000 (02:09 +0000)] 
Update to the date functions. (CVS 1110)

FossilOrigin-Name: 06d4e88394217fb1390b069bad82d6ac71981f72

21 years agoAllow quoted trigger names. Ticket #468. (CVS 1109)
drh [Fri, 3 Oct 2003 00:13:38 +0000 (00:13 +0000)] 
Allow quoted trigger names.  Ticket #468. (CVS 1109)

FossilOrigin-Name: 54aa0fb236d17b53b194a667d68c71007c8e7687

21 years agoAll LIKE and GLOB operators to use function notation. "A LIKE B" can be
drh [Tue, 30 Sep 2003 01:54:13 +0000 (01:54 +0000)] 
All LIKE and GLOB operators to use function notation.  "A LIKE B" can be
expressed as "LIKE(B,A)". (CVS 1108)

FossilOrigin-Name: 95b27ebd1322a877112dee514dffddb0937e45fa

21 years agoPatch the spec.template file (for generating RPMs) as suggested by
drh [Mon, 29 Sep 2003 12:20:51 +0000 (12:20 +0000)] 
Patch the spec.template file (for generating RPMs) as suggested by
Jeremy Hinegardner.  Untested. (CVS 1107)

FossilOrigin-Name: 703741ca1e2b0bf79a4e3cda3cf3c6862d7263eb

21 years agoRemove support for the Oracle8 outer join syntax. (CVS 1106)
drh [Sat, 27 Sep 2003 13:39:38 +0000 (13:39 +0000)] 
Remove support for the Oracle8 outer join syntax. (CVS 1106)

FossilOrigin-Name: 824430b3ce435386b83ceb882f1510ac9f27d8fa

21 years agoAdd a test case for ticket #464 but leave it commented out for now. We
drh [Sat, 27 Sep 2003 01:08:37 +0000 (01:08 +0000)] 
Add a test case for ticket #464 but leave it commented out for now.  We
will fix this problem when VACUUM is rewritten. (CVS 1105)

FossilOrigin-Name: 7ba8dc9b1e5c788f2c0ab32314754324c86aaa49

21 years agoAdd additional backslash escapes to the COPY command for compatibility
drh [Sat, 27 Sep 2003 00:56:31 +0000 (00:56 +0000)] 
Add additional backslash escapes to the COPY command for compatibility
with PostgreSQL.  Ticket #460. (CVS 1104)

FossilOrigin-Name: 70a50bdda318f353c8be1ba200f9aedc34642c93

21 years agoDo all WHERE clauses tests, even if an index is used for lookup so that
drh [Sat, 27 Sep 2003 00:41:27 +0000 (00:41 +0000)] 
Do all WHERE clauses tests, even if an index is used for lookup so that
we know the test cannot be FALSE.  The test might end up being NULL in which
case it would need to be treated as false.  Ticket #461. (CVS 1103)

FossilOrigin-Name: 5aea81488b2d3bcdc009ccf0f0ffcda046e38d79

21 years agoA failed malloc() could have resulted in a segfault. Fixed by this check-in. (CVS...
drh [Tue, 23 Sep 2003 10:25:32 +0000 (10:25 +0000)] 
A failed malloc() could have resulted in a segfault.  Fixed by this check-in. (CVS 1102)

FossilOrigin-Name: 4bb256ee3ecd44d71d90556e16bb56c0389fd5b5

21 years agoallow -enable-releasemode as an option and allow Makefile to produce version
xdong [Tue, 23 Sep 2003 00:36:50 +0000 (00:36 +0000)] 
allow -enable-releasemode as an option and allow Makefile to produce version
independent binary like libsqlite-2.8.6.so instead of libsqlite.so.0.0.0 (CVS 1101)

FossilOrigin-Name: 4fdd44a5ee5f7beb3cff11bc54fd3022b975b9e6

21 years agoregenerate configure to take -enalbe-releasemode as an option (CVS 1100)
xdong [Tue, 23 Sep 2003 00:35:21 +0000 (00:35 +0000)] 
regenerate configure to take -enalbe-releasemode as an option (CVS 1100)

FossilOrigin-Name: b85847b8f28f8f4be9e7f3d8674ecf42e1c5db38

21 years agomodify the configure file to allow cross-compile to work at arm and xscale (CVS 1099)
xdong [Thu, 18 Sep 2003 21:59:45 +0000 (21:59 +0000)] 
modify the configure file to allow cross-compile to work at arm and xscale (CVS 1099)

FossilOrigin-Name: 760f2fa2e5db102b970687f59b79bfb6f4d35b32

21 years agoThe tokenizer should never return a negative size of the next token.
drh [Fri, 12 Sep 2003 02:08:14 +0000 (02:08 +0000)] 
The tokenizer should never return a negative size of the next token.
Ticket #453. (CVS 1098)

FossilOrigin-Name: 4fbca3ab09596c530da7c50657f3bc9140178dd5

21 years agoAdd test cases that check out sqlite_get_table() on queries with results sets
drh [Tue, 9 Sep 2003 00:47:47 +0000 (00:47 +0000)] 
Add test cases that check out sqlite_get_table() on queries with results sets
containing 100 columns. (CVS 1097)

FossilOrigin-Name: f9feedec32c975235c0d0996962033f6a63312ba

21 years agoAdd initial test cases for the new sqlite_bind() API. Fix bugs that the new
drh [Sat, 6 Sep 2003 22:45:20 +0000 (22:45 +0000)] 
Add initial test cases for the new sqlite_bind() API.  Fix bugs that the new
test cases found. (CVS 1096)

FossilOrigin-Name: f6c4908e9b5b6ac9adc4af50dc5110dbb655dae3

21 years agoUpdate Makefile.in for the new vdbeaux.c file. Remove the experimental
drh [Sat, 6 Sep 2003 22:18:07 +0000 (22:18 +0000)] 
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

21 years agoSplit almost 1300 lines of code out of vdbe.c into separate files
drh [Sat, 6 Sep 2003 20:12:01 +0000 (20:12 +0000)] 
Split almost 1300 lines of code out of vdbe.c into separate files
vdbeInt.h and vdbeaux.c. (CVS 1094)

FossilOrigin-Name: bfd69391d3d63675f206ffd8ff0401ea1cbcc073