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

21 years agoThe beginnings of changes to support pre-compiled SQL. Mostly untested,
drh [Sat, 6 Sep 2003 01:10:47 +0000 (01:10 +0000)] 
The beginnings of changes to support pre-compiled SQL.  Mostly untested,
though all regression tests to pass. (CVS 1093)

FossilOrigin-Name: 912f47c72d3597c6d5acff765d94922bd660339a

21 years agoAdd a logo from Rasmus Schultz. (CVS 1092)
drh [Tue, 2 Sep 2003 15:26:33 +0000 (15:26 +0000)] 
Add a logo from Rasmus Schultz. (CVS 1092)

FossilOrigin-Name: aaa84c6202f6e16828bcd6aff2e424f3dba1f82b

21 years agoCVS missed a commit (because I pressed Ctrl-C in the middle). This
drh [Wed, 27 Aug 2003 22:57:07 +0000 (22:57 +0000)] 
CVS missed a commit (because I pressed Ctrl-C in the middle).  This
extra commit will hopefully help clear things up. (CVS 1091)

FossilOrigin-Name: 522c2efeb5bdccadf3306234d458425b94cdbbe3

21 years agoAdd locks to the in-memory backend so that recursive writes will be detected
drh [Wed, 27 Aug 2003 22:54:31 +0000 (22:54 +0000)] 
Add locks to the in-memory backend so that recursive writes will be detected
and rejected.  Ticket #436. (CVS 1089)

FossilOrigin-Name: 3403d28a49b27d3059d3d399ca057e8d33eb857a

21 years agoAdd locks to the in-memory database so that recursive writes will be detected
drh [Wed, 27 Aug 2003 22:52:34 +0000 (22:52 +0000)] 
Add locks to the in-memory database so that recursive writes will be detected
and rejected.  Ticket #436. (CVS 1090)

FossilOrigin-Name: 966b1a16f6687df08f8c21787c1c8b1af1d79e1e

21 years agoFix compiler warnings under OpenVMS. Ticket #357. (CVS 1088)
drh [Tue, 26 Aug 2003 11:41:27 +0000 (11:41 +0000)] 
Fix compiler warnings under OpenVMS.  Ticket #357. (CVS 1088)

FossilOrigin-Name: c95f347cac27732533a2f6fd4ba50bf00eef59f3

21 years agoTry to work around a bug in VC++ by only passing unsigned characters to
drh [Tue, 26 Aug 2003 11:35:00 +0000 (11:35 +0000)] 
Try to work around a bug in VC++ by only passing unsigned characters to
the isspace() routine.  Bug reported on the mailing list. (CVS 1087)

FossilOrigin-Name: cbe32216966c987902ceb4d85332fc95801dbda2

21 years agoFix a bug in sqliteRealloc() that only occurs if there is memory corruption
drh [Tue, 26 Aug 2003 11:29:07 +0000 (11:29 +0000)] 
Fix a bug in sqliteRealloc() that only occurs if there is memory corruption
and debugging is enabled.  Ticket #421. (CVS 1086)

FossilOrigin-Name: eebc82b77dbf35a18d2eae47336038d4b67806c6

21 years agoIf the database filename is an empty string, open a temporary file to hold
drh [Tue, 26 Aug 2003 11:25:58 +0000 (11:25 +0000)] 
If the database filename is an empty string, open a temporary file to hold
the database.  Ticket #432. (CVS 1085)

FossilOrigin-Name: da53369f0bf133b89b213bbb1ccea13eb93ab6ed

21 years agoClose files before deleting them on test scripts under Win2k.
drh [Tue, 26 Aug 2003 11:18:19 +0000 (11:18 +0000)] 
Close files before deleting them on test scripts under Win2k.
Ticket #434. (CVS 1084)

FossilOrigin-Name: 2a40b46140720783cf4002fb9993f7f6766dbf5f

21 years agoRemove extra backslashes from end of lines in the install target of the
drh [Tue, 26 Aug 2003 10:38:58 +0000 (10:38 +0000)] 
Remove extra backslashes from end of lines in the install target of the
Makefile.  Ticket #435. (CVS 1083)

FossilOrigin-Name: 1aa3658ef54fad7f2b7f61d91641472551468cdc

21 years agoFix a bug in the new "pk" column of the table_info pragma that was added
drh [Sun, 24 Aug 2003 16:38:17 +0000 (16:38 +0000)] 
Fix a bug in the new "pk" column of the table_info pragma that was added
by check-in (1081). (CVS 1082)

FossilOrigin-Name: ad7b017a1277c00b356343b36ade565baf404d6a

21 years agoAdd a "pk" column to the table_info pragma which is true for each column
drh [Sat, 23 Aug 2003 22:40:53 +0000 (22:40 +0000)] 
Add a "pk" column to the table_info pragma which is true for each column
that is part of the primary key.  Add a "foreign_key_list" pragma that gives
information about all foreign keys for a table.  Both changes are experimental. (CVS 1081)

FossilOrigin-Name: 5232b0665b84a9339a85918570093a376a0ea91f

21 years agoVersion 2.8.6 (CVS 1080)
drh [Fri, 22 Aug 2003 03:00:00 +0000 (03:00 +0000)] 
Version 2.8.6 (CVS 1080)

FossilOrigin-Name: 0bde7ae2ba57de554c3531f3cb7e36bf56d3b12c

21 years agoChange the CVSTrac website to www.sqlite.org. Update change summary for
drh [Fri, 22 Aug 2003 02:34:30 +0000 (02:34 +0000)] 
Change the CVSTrac website to www.sqlite.org.  Update change summary for
the 2.8.6 release. (CVS 1079)

FossilOrigin-Name: a4e3e075e3b36e0f5f692067c5bf5e1b660d893d

21 years agoUpdate the -version-info number on libtool in Makefile.in. (CVS 1078)
drh [Thu, 21 Aug 2003 14:36:38 +0000 (14:36 +0000)] 
Update the -version-info number on libtool in Makefile.in. (CVS 1078)

FossilOrigin-Name: dc36365eea7d0c8767d8947393a8d2746c02b220

21 years agoAdd the experimental "quote()" function to the set of build-in functions. (CVS 1077)
drh [Wed, 20 Aug 2003 01:03:33 +0000 (01:03 +0000)] 
Add the experimental "quote()" function to the set of build-in functions. (CVS 1077)

FossilOrigin-Name: 9699c68508db5da6238904e518835a629d430db6

21 years agoAdd the "onecolumn" method to the TCL language bindings. (CVS 1076)
drh [Tue, 19 Aug 2003 14:31:01 +0000 (14:31 +0000)] 
Add the "onecolumn" method to the TCL language bindings. (CVS 1076)

FossilOrigin-Name: c7b4c28fbc0bca5645af5750fd353f4eca400b40

21 years agoMake the compile work under cygwin.
drh [Sat, 16 Aug 2003 13:10:51 +0000 (13:10 +0000)] 
Make the compile work under cygwin.
Tickets #327, #213, #316, #322, #349, #373, and #429. (CVS 1075)

FossilOrigin-Name: 7d8d3252df1e9f6bec5e105b6eca3313cb7e226a

21 years agoDo not delete tables with the same name when dropping triggers.
drh [Sat, 16 Aug 2003 12:37:51 +0000 (12:37 +0000)] 
Do not delete tables with the same name when dropping triggers.
Ticket #430. (CVS 1074)

FossilOrigin-Name: ef58f163b08d13f8e9b69459bd83e0bf9d5b404b

21 years agoFix a segfault that occurs in the VACUUM command if run on an empty database
drh [Fri, 15 Aug 2003 13:24:51 +0000 (13:24 +0000)] 
Fix a segfault that occurs in the VACUUM command if run on an empty database
with the EMPTY_RESULT_CALLBACKS pragma enabled.  Ticket #427. (CVS 1073)

FossilOrigin-Name: 3563e9cf9d6b20f09e92deb21fdda93bcd8fb583

21 years agoUpdate the NULL-handling chart with new information about Firebird. (CVS 1072)
drh [Wed, 13 Aug 2003 11:29:23 +0000 (11:29 +0000)] 
Update the NULL-handling chart with new information about Firebird. (CVS 1072)

FossilOrigin-Name: 17bdfeb284880d82cd546e6c191c3a37121ec861

21 years agoMake the sqliteOsCurrentTime() function work for Windows. Code contributed
drh [Sun, 10 Aug 2003 16:16:22 +0000 (16:16 +0000)] 
Make the sqliteOsCurrentTime() function work for Windows.  Code contributed
by "e4liberty" on the mailing list. (CVS 1071)

FossilOrigin-Name: 02fac304c9ec9012f3cc4f04d2c4cac5e37b0024

21 years agotighter coding of the date and time functions. Better comments. A bug fix. (CVS...
drh [Sun, 10 Aug 2003 01:50:54 +0000 (01:50 +0000)] 
tighter coding of the date and time functions.  Better comments.  A bug fix. (CVS 1070)

FossilOrigin-Name: 94243edac14b90ef898093b85e1959c20fa23ae9

22 years agoAdd experimental date and time functions based on julian day number. (CVS 1069)
drh [Sat, 9 Aug 2003 21:32:28 +0000 (21:32 +0000)] 
Add experimental date and time functions based on julian day number. (CVS 1069)

FossilOrigin-Name: a6197e2075fdf9db862484255ac16b2855bbef0a

22 years agoProvide a more informative error message when a uniqueness constraint
drh [Tue, 5 Aug 2003 13:13:38 +0000 (13:13 +0000)] 
Provide a more informative error message when a uniqueness constraint
fails.  Ticket #419. (CVS 1068)

FossilOrigin-Name: 086aa1c9922b7bf399b3ee8b73ba7353d126b119

22 years agoThe {quote: SrcList} object was not being expanded correctly by a call to
drh [Wed, 30 Jul 2003 12:34:12 +0000 (12:34 +0000)] 
The {quote: SrcList} object was not being expanded correctly by a call to
sqliteSrcListAppend() if the {quote: SrcList} had previously been duplicated by
a call to sqliteSrcListDup().  Ticket #416. This check-in fixes that problem
by keeping a separate nAlloc field on {quote: SrcList}.  A similar change is made
to {quote: IdList} and {quote: ExprList} to avoid future problems. (CVS 1067)

FossilOrigin-Name: da6273255471673841fdcadc688aeac80722e130

22 years agoWhen creating a new journal file, open a (read-only) file descriptor on the
drh [Sun, 27 Jul 2003 18:59:42 +0000 (18:59 +0000)] 
When creating a new journal file, open a (read-only) file descriptor on the
directory containing the journal and sync that directory once to make sure
that the journal filename entry gets into the directory.  Ticket #410. (CVS 1066)

FossilOrigin-Name: 09c10fe3c99cffc64ed02c2929f206d99c8e3309

22 years agoMake sure the schema loader callback can handle EMPTY_RESULT_CALLBACKS being
drh [Sun, 27 Jul 2003 17:26:22 +0000 (17:26 +0000)] 
Make sure the schema loader callback can handle EMPTY_RESULT_CALLBACKS being
on.  Ticket #406. (CVS 1065)

FossilOrigin-Name: 8c163fc0c7c721b7a5fa6727b0e90bff4484c782

22 years agoIn the VDBE, when an integer value will not fit into a 32-bit int, store it
drh [Sun, 27 Jul 2003 17:16:06 +0000 (17:16 +0000)] 
In the VDBE, when an integer value will not fit into a 32-bit int, store it
in a double instead.  Ticket #408. (CVS 1064)

FossilOrigin-Name: 7514c3db165e8cc5c696b2b345844949a0e45a61

22 years agoVersion 2.8.5 (CVS 1063)
drh [Tue, 22 Jul 2003 13:20:28 +0000 (13:20 +0000)] 
Version 2.8.5 (CVS 1063)

FossilOrigin-Name: 95fba440e79c066c0d6f6205a3d7dcb6c870b1c9

22 years agoFix a typo in the index.html homepage. (CVS 1062)
drh [Tue, 22 Jul 2003 12:44:53 +0000 (12:44 +0000)] 
Fix a typo in the index.html homepage. (CVS 1062)

FossilOrigin-Name: 510761cf505222c68ce3404aad94e1cc28b703ed

22 years agoIncrement the version number and update the documentation in preparation
drh [Tue, 22 Jul 2003 12:41:59 +0000 (12:41 +0000)] 
Increment the version number and update the documentation in preparation
for the 2.8.5 release. (CVS 1061)

FossilOrigin-Name: c2115335de4abc25cbc1664d718dc3a6f70ebe6c

22 years agoAdd experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060)
danielk1977 [Tue, 22 Jul 2003 09:24:43 +0000 (09:24 +0000)] 
Add experimental sqlite_reset() API (allows pre-compiled queries) (CVS 1060)

FossilOrigin-Name: 1d2fcb017811db90e85d63f2ca76867c00ab8f1b

22 years agoMake sure temporary file names in windows have a full 15 characters of
drh [Tue, 22 Jul 2003 00:39:13 +0000 (00:39 +0000)] 
Make sure temporary file names in windows have a full 15 characters of
random text at the end. (CVS 1059)

FossilOrigin-Name: 6ccb92b14f2e6e01bb60dac10331fa7be0b4525e

22 years agoFix the LIMIT clause so that it applies to the entire query in a compound
drh [Sun, 20 Jul 2003 01:16:46 +0000 (01:16 +0000)] 
Fix the LIMIT clause so that it applies to the entire query in a compound
query.  Prior to this change LIMITs on compound queries did not work at
all.  Ticket #393. (CVS 1058)

FossilOrigin-Name: 543479e3aed77976a0c689cf40811bf88353f706

22 years agoMake sure the min() and max() optimizer works correctly when there
drh [Sat, 19 Jul 2003 00:44:14 +0000 (00:44 +0000)] 
Make sure the min() and max() optimizer works correctly when there
is a LIMIT clause.  Ticket #396. (CVS 1057)

FossilOrigin-Name: c35e50717678703763c696e3e9b265add2ca6454

22 years agoIn the sqlite shell, change the name of function getline() to local_getline()
drh [Fri, 18 Jul 2003 01:30:59 +0000 (01:30 +0000)] 
In the sqlite shell, change the name of function getline() to local_getline()
to avoid a clash with a library function.  Ticket #400. (CVS 1056)

FossilOrigin-Name: 558969ee8697180c74308f3f880d3240eb575af1

22 years agoIn the test scripts, do not try to delete files that are still open.
drh [Fri, 18 Jul 2003 01:25:34 +0000 (01:25 +0000)] 
In the test scripts, do not try to delete files that are still open.
Windows does not like it when you do.  Ticket #397. (CVS 1055)

FossilOrigin-Name: 93a2c961b17d2459272e2d8654bd4b972f52fbe1

22 years agoFix typo on the homepage. (CVS 1054)
drh [Wed, 16 Jul 2003 17:10:45 +0000 (17:10 +0000)] 
Fix typo on the homepage. (CVS 1054)

FossilOrigin-Name: c74107d63ace3d0e51da3b7bd7ee250c2a39205b

22 years agoMake LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS...
drh [Wed, 16 Jul 2003 11:51:35 +0000 (11:51 +0000)] 
Make LIMIT 0 return no rows.  LIMIT -1 still returns all rows.  Ticket #346. (CVS 1053)

FossilOrigin-Name: a31d0bd90af7cc95f8e36ca8ece21515f872235e

22 years agoAllow negative values for LIMIT and OFFSET. Add tests for negative LIMITs
drh [Wed, 16 Jul 2003 02:19:37 +0000 (02:19 +0000)] 
Allow negative values for LIMIT and OFFSET.  Add tests for negative LIMITs
and OFFSETs.  Make the OFFSET work even if LIMIT is 0 or negative. (CVS 1052)

FossilOrigin-Name: e6a752bfef24f773973c151c6262ff331a9dc57a