]> git.ipfire.org Git - thirdparty/sqlite.git/log
thirdparty/sqlite.git
18 years agoWork around a bug in GCC. Ticket #2469. (CVS 4173)
drh [Sat, 21 Jul 2007 19:41:45 +0000 (19:41 +0000)] 
Work around a bug in GCC.  Ticket #2469. (CVS 4173)

FossilOrigin-Name: 1924ba5207bdc8d503c17cd9460c1a9f9c357635

18 years agoWork around an AFP file system byte-range locking error caused by opening and closing...
aswift [Fri, 20 Jul 2007 20:25:37 +0000 (20:25 +0000)] 
Work around an AFP file system byte-range locking error caused by opening and closing a second file descriptor on the database file as RDWR which clears the exclusive byte-range lock and results in an fcntl error when the AFP locking code attempts to clear it afterwards.  This error is caused by the test harness and isn't a flaw in the sqlite or its implementation of AFP file locking. (CVS 4172)

FossilOrigin-Name: b2ba3e81fb1015d6f979a490e00a45fb7d5e1a9a

18 years agoUpdates to build scripts. Added scripts for building FTS2 shared libraries. (CVS...
drh [Fri, 20 Jul 2007 13:42:26 +0000 (13:42 +0000)] 
Updates to build scripts.  Added scripts for building FTS2 shared libraries. (CVS 4171)

FossilOrigin-Name: e269f6e9f6273210259a488c356f4996d75c6436

18 years agoVersion 3.4.1 (CVS 4170)
drh [Fri, 20 Jul 2007 10:56:07 +0000 (10:56 +0000)] 
Version 3.4.1 (CVS 4170)

FossilOrigin-Name: 81a4dd07c1d7099461e9e6668433dac5d99b1f32

18 years agoKeep sqlite3ext.h backwards compatible. This really should have been part
drh [Fri, 20 Jul 2007 10:48:35 +0000 (10:48 +0000)] 
Keep sqlite3ext.h backwards compatible.  This really should have been part
of the previous check-in. (CVS 4169)

FossilOrigin-Name: 7cf15a5f651f0777972e21e0a96d601cf294f0f3

18 years agoAdd new APIs to the end of the sqlite3_apis structure in loadext.c, in order
drh [Fri, 20 Jul 2007 10:33:58 +0000 (10:33 +0000)] 
Add new APIs to the end of the sqlite3_apis structure in loadext.c, in order
to preserve backwards compatibility.  Fix an incompatibility introduced
by (4108). (CVS 4168)

FossilOrigin-Name: 639993490ea829208b5f309bbe6c166c34e89d14

18 years agoDocumentation change in preparation for version 3.4.1. (CVS 4167)
drh [Fri, 20 Jul 2007 01:17:28 +0000 (01:17 +0000)] 
Documentation change in preparation for version 3.4.1. (CVS 4167)

FossilOrigin-Name: cf227766aca5065fd68e83f145943fe9d15cd7ef

18 years agoFix a memory leak in the Rename method of the echo test virtual table.
drh [Fri, 20 Jul 2007 00:35:58 +0000 (00:35 +0000)] 
Fix a memory leak in the Rename method of the echo test virtual table.
No changes to the core. (CVS 4166)

FossilOrigin-Name: e5c132fff3e8a0478622527a7e47d679594f899a

18 years agoCleanup unused function in pager.c. This is the conclusion of the fix
drh [Fri, 20 Jul 2007 00:33:36 +0000 (00:33 +0000)] 
Cleanup unused function in pager.c.  This is the conclusion of the fix
to ticket #2518. We believe the fix is complete and correct. (CVS 4165)

FossilOrigin-Name: 31dba1e933c523a47fdd007c2c7492133dfe72f2

18 years agoDisable tests that use the progress handler when the progress handler
drh [Thu, 19 Jul 2007 22:30:19 +0000 (22:30 +0000)] 
Disable tests that use the progress handler when the progress handler
is disabled at compile-time.  Followup to ticket #2497. (CVS 4164)

FossilOrigin-Name: cbc56fd4ec60d08a13a3aa181d044e726c49ef3c

18 years agoPreliminary fix for ticket #2518. Make sure the VACUUM command
drh [Thu, 19 Jul 2007 16:35:17 +0000 (16:35 +0000)] 
Preliminary fix for ticket #2518.  Make sure the VACUUM command
increments the change counter. (CVS 4163)

FossilOrigin-Name: 75263797e29af437290c09e85cd5fd2aea08694f

18 years agoClarify the documentation on the nByte parameter to sqlite3_prepare().
drh [Thu, 19 Jul 2007 12:41:39 +0000 (12:41 +0000)] 
Clarify the documentation on the nByte parameter to sqlite3_prepare().
Make it clear that nByte is a maximum string length.  Ticket #2516. (CVS 4162)

FossilOrigin-Name: d1ae3de4613d36b5352eb852f1951a09d4a92ac1

18 years agoGet the min/max optimization working with descending indices. Ticket #2514. (CVS...
drh [Wed, 18 Jul 2007 18:17:11 +0000 (18:17 +0000)] 
Get the min/max optimization working with descending indices.  Ticket #2514. (CVS 4161)

FossilOrigin-Name: a80a3c9d0a5e0a8a3d67bd841e2076893fd5e9aa

18 years agoAdditional diagnostics added to the "out" file generated by lemon. (CVS 4160)
drh [Wed, 18 Jul 2007 18:16:29 +0000 (18:16 +0000)] 
Additional diagnostics added to the "out" file generated by lemon. (CVS 4160)

FossilOrigin-Name: 7ef2aaf72a8a953df7a763dd94657bb4ff05294f

18 years agoFix annoying emacs warning about suspicious line. The change removes
shess [Tue, 17 Jul 2007 17:22:03 +0000 (17:22 +0000)] 
Fix annoying emacs warning about suspicious line.  The change removes
a leading space (emacs wants Makefiles to use leading tabs there). (CVS 4159)

FossilOrigin-Name: 4daadf659afe6b2524e1b37347247f233a211950

18 years agoAdd an extra integrity_check to the transaction test script. (CVS 4158)
drh [Fri, 13 Jul 2007 10:36:47 +0000 (10:36 +0000)] 
Add an extra integrity_check to the transaction test script. (CVS 4158)

FossilOrigin-Name: 5ea43b2db1f0263c5f0ab76351bc9ca940d1428a

18 years agoUpdate documentation to make it clear that VACUUM is free to
drh [Fri, 13 Jul 2007 10:35:14 +0000 (10:35 +0000)] 
Update documentation to make it clear that VACUUM is free to
change implicit rowids.  Ticket #2382. (CVS 4157)

FossilOrigin-Name: d111b1daa547fea51d9e1fbe49c0b1338298484e

18 years ago"extern" prototypes cause problems for the Digital Mars compiler. So
drh [Fri, 13 Jul 2007 10:26:08 +0000 (10:26 +0000)] 
"extern" prototypes cause problems for the Digital Mars compiler.  So
remove them.  Ticket #2502. (CVS 4156)

FossilOrigin-Name: f35fbf8070d770a603960b2a2afdeae91574ed5f

18 years agoFix for #2497. Set the database error code to the return value of sqlite3_step()...
danielk1977 [Thu, 12 Jul 2007 13:18:05 +0000 (13:18 +0000)] 
Fix for #2497. Set the database error code to the return value of sqlite3_step(). (CVS 4155)

FossilOrigin-Name: b01fda5f50e40b6122faf169c44486bde7ffe16c

18 years agoFix compilation warnings shown when using strict GCC options for os_os2.c. (CVS 4154)
pweilbacher [Tue, 3 Jul 2007 23:37:09 +0000 (23:37 +0000)] 
Fix compilation warnings shown when using strict GCC options for os_os2.c. (CVS 4154)

FossilOrigin-Name: 22277b7e1b3eb1678280de5d49a6613908ab4bff

18 years agoFix a memory leak in shell.c. Reported on the mailing list. This has only been inform...
danielk1977 [Tue, 3 Jul 2007 05:31:16 +0000 (05:31 +0000)] 
Fix a memory leak in shell.c. Reported on the mailing list. This has only been informally tested. (CVS 4153)

FossilOrigin-Name: a008905b39e7d4cd5b39db4906eb3b678e3ee8b7

18 years agoFix a comment typo reported on the mailing list. (CVS 4152)
drh [Mon, 2 Jul 2007 19:31:27 +0000 (19:31 +0000)] 
Fix a comment typo reported on the mailing list. (CVS 4152)

FossilOrigin-Name: 25e6df9cdd7d0cbb2bdee9ce76806cfd08314212

18 years agoModify handling of SQLITE_SCHEMA in fts2 code. An SQLITE_SCHEMA error may cause SQLit...
danielk1977 [Mon, 2 Jul 2007 10:16:49 +0000 (10:16 +0000)] 
Modify handling of SQLITE_SCHEMA in fts2 code. An SQLITE_SCHEMA error may cause SQLite to reload the internal schema, deleting and recreating v-table objects. So the sqlite3_vtab structure can be deleted out from under a v-table implementation. (CVS 4151)

FossilOrigin-Name: dee1a0fd28e8341af6523ab0c5628b671d7d2811

18 years agoRemove an unnecessary temporary variable for clarity of presentation in
drh [Sun, 1 Jul 2007 21:18:40 +0000 (21:18 +0000)] 
Remove an unnecessary temporary variable for clarity of presentation in
a loop that GCC 4.2.0 is miscompiling.  Ticket #2469.  GCC 4.2.0 miscompiles
this loop regardless of whether or not the temporary variable is used, but
by removing the variable, we hope to make it easier to explain the problem
to GCC maintainers.  The error only appears if -ftree-vrp is used (which
is turned on by -O2). (CVS 4150)

FossilOrigin-Name: 35ae398bd37e4abbe362b0b780fc51153145b43d

18 years agoChange OS/2 version of sqlite3Os2FullPathname() for cross-compiler compatibility:
pweilbacher [Sun, 1 Jul 2007 15:41:02 +0000 (15:41 +0000)] 
Change OS/2 version of sqlite3Os2FullPathname() for cross-compiler compatibility:
- allocate zBuff on demand (restricted stack space on old compilers)
- 2 bytes in zDrive in include '\0'
- pass drive number to DosQueryCurrentDir() instead of 0 to make EMX work
- zFull does not need to be preallocated (CVS 4149)

FossilOrigin-Name: cc2105176563c352a6dccef89a429a76b6f3adf5

18 years agoIncluding os2safe.h from os_os2.c is no longer necessary (now that it's including...
pweilbacher [Sat, 30 Jun 2007 16:30:39 +0000 (16:30 +0000)] 
Including os2safe.h from os_os2.c is no longer necessary (now that it's including from os.h) (CVS 4148)

FossilOrigin-Name: 6432bbe1c1db1d31bd0057d99a9d6b6a428d8ffc

18 years agoold emx/gcc sets __EMX__ (with double underscores) as builtin #define (CVS 4147)
pweilbacher [Sat, 30 Jun 2007 15:24:37 +0000 (15:24 +0000)] 
old emx/gcc sets __EMX__ (with double underscores) as builtin #define (CVS 4147)

FossilOrigin-Name: d69204fec718a5d6d95351ee7a0c068a1c59222d

18 years agoSet FD_CLOEXEC on all open files under Unix. Ticket #2475. (CVS 4146)
drh [Fri, 29 Jun 2007 12:04:26 +0000 (12:04 +0000)] 
Set FD_CLOEXEC on all open files under Unix.  Ticket #2475. (CVS 4146)

FossilOrigin-Name: f1e5fed8eb0fb92bd0f040666c017850afe3cf9f

18 years agoAdd a test case to verify that ticket #2470 has been fixed. (CVS 4145)
drh [Wed, 27 Jun 2007 23:52:18 +0000 (23:52 +0000)] 
Add a test case to verify that ticket #2470 has been fixed. (CVS 4145)

FossilOrigin-Name: b3f442698e01ad55666703025c4457445f2efc9b

18 years agoTest error handling when renaming fts2 tables. (CVS 4144)
danielk1977 [Wed, 27 Jun 2007 17:09:24 +0000 (17:09 +0000)] 
Test error handling when renaming fts2 tables. (CVS 4144)

FossilOrigin-Name: 57840eba6a4380a0b71dc9514cdda41e2c455bb0

18 years agoImplement xRename() for fts2 so that it is possible to rename fts2 tables. (CVS 4143)
danielk1977 [Wed, 27 Jun 2007 16:26:07 +0000 (16:26 +0000)] 
Implement xRename() for fts2 so that it is possible to rename fts2 tables. (CVS 4143)

FossilOrigin-Name: 488474fde753c5a7a14ed8f2fad7f16efd236491

18 years agoAllow ALTER TABLE on virtual tables. (CVS 4142)
danielk1977 [Wed, 27 Jun 2007 15:53:34 +0000 (15:53 +0000)] 
Allow ALTER TABLE on virtual tables. (CVS 4142)

FossilOrigin-Name: 37d1f9f37ea9d2e8a4dbe0ec67c0d6eb7fcc5f3f

18 years agorespect $LDFLAGS from env/configure (CVS 4141)
vapier [Wed, 27 Jun 2007 15:01:45 +0000 (15:01 +0000)] 
respect $LDFLAGS from env/configure (CVS 4141)

FossilOrigin-Name: 9c13fc0f4bf22c8e05b11ef5feaaf07d8a8b3f01

18 years agoFix for compiling with OMIT_VIRTUALTABLE defined. (CVS 4140)
danielk1977 [Wed, 27 Jun 2007 11:10:03 +0000 (11:10 +0000)] 
Fix for compiling with OMIT_VIRTUALTABLE defined. (CVS 4140)

FossilOrigin-Name: 850822e2904bc340afd0b7535ef51fbdf9e1f486

18 years agoFix typo in comments of the sqlite.h.in header file - comments from which
drh [Wed, 27 Jun 2007 10:21:38 +0000 (10:21 +0000)] 
Fix typo in comments of the sqlite.h.in header file - comments from which
documentation is automatically extracted and generated.  Ticket #2468. (CVS 4139)

FossilOrigin-Name: 53b526203c22961447b9c1cebbd885ecc8bc3e09

18 years agoMake sure auto_vacuum is turned off before running the tests in pragma2.test. (CVS...
drh [Wed, 27 Jun 2007 10:20:00 +0000 (10:20 +0000)] 
Make sure auto_vacuum is turned off before running the tests in pragma2.test. (CVS 4138)

FossilOrigin-Name: fc85c8aa160cc46419b9ce83d9eb47970c67118a

18 years agoSet the connection error code when sqlite3_blob_read() or
drh [Wed, 27 Jun 2007 00:36:13 +0000 (00:36 +0000)] 
Set the connection error code when sqlite3_blob_read() or
sqlite3_blob_write() fail.  Ticket #2464. (CVS 4137)

FossilOrigin-Name: 3bd990be3cb8a74be9eaa8d5710852be6733cb58

18 years agoUpdate the FAQ to describe how moving sqlite3 handles across threads is
drh [Wed, 27 Jun 2007 00:08:39 +0000 (00:08 +0000)] 
Update the FAQ to describe how moving sqlite3 handles across threads is
not safe with SQLITE_ENABLE_MEMORY_MANAGEMENT.  Tickets #2357 and #2463. (CVS 4136)

FossilOrigin-Name: 2640f518deba1d196201fac903ec4d3ab26d4bb3

18 years agoMake sure the TCL bindings always use Tcl_GetWideIntFromObj() even if the
drh [Tue, 26 Jun 2007 22:55:37 +0000 (22:55 +0000)] 
Make sure the TCL bindings always use Tcl_GetWideIntFromObj() even if the
reported type is "int" because on x86-64 and "int" type is 64-bits.
Ticket #2465. (CVS 4135)

FossilOrigin-Name: 5c93324b937b4d8394b0eb7d7fe74f7965623cbe

18 years agoFix a test case so that it (hopefully) works on x86-64. Ticket #2465. (CVS 4134)
drh [Tue, 26 Jun 2007 22:42:56 +0000 (22:42 +0000)] 
Fix a test case so that it (hopefully) works on x86-64.  Ticket #2465. (CVS 4134)

FossilOrigin-Name: 3daf7cae18ae2ee6404f770e69e4cd0c715615e5

18 years agoRemove vestigal code from Makefile.linux-gcc. Ticket #2466. (CVS 4133)
drh [Tue, 26 Jun 2007 22:10:12 +0000 (22:10 +0000)] 
Remove vestigal code from Makefile.linux-gcc.  Ticket #2466. (CVS 4133)

FossilOrigin-Name: 338c18791006bac3709410087316700aad3b332f

18 years agoReorganize comments in fts2_tokenizer.h. No code changes. (CVS 4132)
danielk1977 [Tue, 26 Jun 2007 12:54:07 +0000 (12:54 +0000)] 
Reorganize comments in fts2_tokenizer.h. No code changes. (CVS 4132)

FossilOrigin-Name: b331e30395e9fc90abe40ab802972a67648cf48e

18 years agoUse (((i64)1)<<63) instead of just (1<<63) to compute the most negative 64-bit intege...
danielk1977 [Tue, 26 Jun 2007 12:52:33 +0000 (12:52 +0000)] 
Use (((i64)1)<<63) instead of just (1<<63) to compute the most negative 64-bit integer. (CVS 4131)

FossilOrigin-Name: be2570c061e1e751d1a46450bd1186549146526e

18 years agoFix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions like...
danielk1977 [Tue, 26 Jun 2007 11:13:25 +0000 (11:13 +0000)] 
Fix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions like ((1<<63)/-1). (CVS 4130)

FossilOrigin-Name: c6dfd9e43449b0b3528281d9e2e4971c6ba86ab5

18 years agoRemove the unused EXTSRC variable from the non-configure makefile. (CVS 4129)
danielk1977 [Tue, 26 Jun 2007 10:56:40 +0000 (10:56 +0000)] 
Remove the unused EXTSRC variable from the non-configure makefile. (CVS 4129)

FossilOrigin-Name: bbdcf372c6f2144a62fba742b3f4bd6b2fe58593

18 years agoFix an unitialized variable in fts2. (CVS 4128)
danielk1977 [Tue, 26 Jun 2007 10:55:01 +0000 (10:55 +0000)] 
Fix an unitialized variable in fts2. (CVS 4128)

FossilOrigin-Name: c349cf942534357955f80fc2aa8c96206af97b78

18 years agoAllow virtual tables to mark columns as 'hidden'. Hidden columns do not show
danielk1977 [Tue, 26 Jun 2007 10:38:54 +0000 (10:38 +0000)] 
Allow virtual tables to mark columns as 'hidden'. Hidden columns do not show
up in "*" expansion, the implicit column list of an INSERT statement, or the results of a "PRAGMA table_info" statement. (CVS 4127)

FossilOrigin-Name: 7f887a6a00fdd6efc3740bd8a1731bb1abde087c

18 years agoTry to work around an MSVC compiler bug. Ticket #2457. (CVS 4126)
drh [Tue, 26 Jun 2007 01:04:48 +0000 (01:04 +0000)] 
Try to work around an MSVC compiler bug.  Ticket #2457. (CVS 4126)

FossilOrigin-Name: 4a7079a19ab5c36ed88cf597c21bf9f8b63bdf86

18 years agoModify the amalgamation generator to identify every API using the
drh [Tue, 26 Jun 2007 00:52:39 +0000 (00:52 +0000)] 
Modify the amalgamation generator to identify every API using the
SQLITE_API macro which is normally defined to nothing but which can
be overridden on the compiler command-line to be "static" if desired.
Ticket #2453. (CVS 4125)

FossilOrigin-Name: 474a52347d454ad499d7a78c88eb995c9d3254d1

18 years agoChange the name of sqlite3_atoi64 back to sqlite3Atoi64 so that it is clearly
drh [Tue, 26 Jun 2007 00:37:27 +0000 (00:37 +0000)] 
Change the name of sqlite3_atoi64 back to sqlite3Atoi64 so that it is clearly
and internal API.  Modify the amalgamation to use a macro SQLITE_PRIVATE
instead of the keyword "static" so the macro can be overridden to by nothing. (CVS 4124)

FossilOrigin-Name: 96190cf13dd7219f483308fea92d703328aac4c7

18 years agoRework the string to integer conversion logic to address tickets
drh [Mon, 25 Jun 2007 17:28:00 +0000 (17:28 +0000)] 
Rework the string to integer conversion logic to address tickets
#2344 and #2454. (CVS 4123)

FossilOrigin-Name: 5b3a490649ab88c168e3e5bf2efbc7f61b1b954d

18 years agoFix for #2445. A bug in the lookupName() logic that could cause a crash when a WHERE...
danielk1977 [Mon, 25 Jun 2007 16:29:33 +0000 (16:29 +0000)] 
Fix for #2445. A bug in the lookupName() logic that could cause a crash when a WHERE clause used an alias to refer to an expression in the result-set of the SELECT, and that expression was itself a reference to a table column. (CVS 4122)

FossilOrigin-Name: 044ca1c72a8f4632dc2e6a94690d164d3560ee38

18 years agoModify the non-configure build system to make it easier to build the library with...
danielk1977 [Mon, 25 Jun 2007 14:28:48 +0000 (14:28 +0000)] 
Modify the non-configure build system to make it easier to build the library with the fts2 or icu extensions linked in. (CVS 4121)

FossilOrigin-Name: 02b23c4394da7efb82e9318146f10818b0f68b1f

18 years agoPut #ifdefs in fts2_tokenizer so that the build works even when FTS2
drh [Mon, 25 Jun 2007 13:50:03 +0000 (13:50 +0000)] 
Put #ifdefs in fts2_tokenizer so that the build works even when FTS2
is omitted.  Add the SQLite blessing to the header comments on all FTS2
source files. (CVS 4120)

FossilOrigin-Name: c795e6fd8f01bcbc1967062632c13d4952abf4d8

18 years agoAll the use of MySQL-style quoting in the FTS modules. Ticket #2446. (CVS 4119)
drh [Mon, 25 Jun 2007 12:49:05 +0000 (12:49 +0000)] 
All the use of MySQL-style quoting in the FTS modules.  Ticket #2446. (CVS 4119)

FossilOrigin-Name: 3be2a6d1c342454d93b05c38f3d9a960ab15dae2

18 years agoAdd a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118)
danielk1977 [Mon, 25 Jun 2007 12:05:40 +0000 (12:05 +0000)] 
Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118)

FossilOrigin-Name: fbcf2d75cd2b88d175c122477aa483f0771870e5

18 years agoAdd some tests for the fts2 icu tokenizer. (CVS 4117)
danielk1977 [Mon, 25 Jun 2007 11:24:38 +0000 (11:24 +0000)] 
Add some tests for the fts2 icu tokenizer. (CVS 4117)

FossilOrigin-Name: b79ced3e0a26b0db13613073c847c2d2ba7e174e

18 years agoAdd some documentation for user-defined fts2 tokenizers. (CVS 4116)
danielk1977 [Mon, 25 Jun 2007 09:52:31 +0000 (09:52 +0000)] 
Add some documentation for user-defined fts2 tokenizers. (CVS 4116)

FossilOrigin-Name: 5a9eee86587219a68655d548864d129edec969ae

18 years agoMake the auto_vacuum mode peristent in all cases. (CVS 4115)
danielk1977 [Mon, 25 Jun 2007 08:16:58 +0000 (08:16 +0000)] 
Make the auto_vacuum mode peristent in all cases. (CVS 4115)

FossilOrigin-Name: 5b0408ddd0f1c825f402d0f5a3088a61b5ecd2c3

18 years agoFix for #2451. Code comment changes only. (CVS 4114)
danielk1977 [Sun, 24 Jun 2007 16:11:03 +0000 (16:11 +0000)] 
Fix for #2451. Code comment changes only. (CVS 4114)

FossilOrigin-Name: bc61dcbf64af56d4a1394c8ff46e91245dc16d15

18 years agoMake setting "PRAGMA auto_vacuum = incremental" persistent if it is executed before...
danielk1977 [Sun, 24 Jun 2007 10:14:00 +0000 (10:14 +0000)] 
Make setting "PRAGMA auto_vacuum = incremental" persistent if it is executed before the database file is created. (CVS 4113)

FossilOrigin-Name: c666fad151f25ab8365c497cd0967f4a5a2adb90

18 years agoAdd the "(database.)freelist_count" PRAGMA. For querying the size of the
danielk1977 [Sun, 24 Jun 2007 08:00:42 +0000 (08:00 +0000)] 
Add the "(database.)freelist_count" PRAGMA. For querying the size of the
database free-list. (CVS 4112)

FossilOrigin-Name: 1fb4251a707d0b79d250d6ea2022913b371d5f14

18 years agoWhen expanding '*' in the result set of a SELECT, quote the expanded identifiers...
danielk1977 [Sun, 24 Jun 2007 06:32:17 +0000 (06:32 +0000)] 
When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111)

FossilOrigin-Name: d5b7224f37db1729dd042d48765d7a79247e1bde

18 years agofix linking failure on OS/2 that happens with the amalgamation and the high memory...
pweilbacher [Fri, 22 Jun 2007 20:17:37 +0000 (20:17 +0000)] 
fix linking failure on OS/2 that happens with the amalgamation and the high memory option enabled (CVS 4110)

FossilOrigin-Name: f35e20e19633d7b114fdf145820ca5d61b5aa925

18 years agofix compilation failure on OS/2 with the amalgamation (CVS 4109)
pweilbacher [Fri, 22 Jun 2007 20:04:36 +0000 (20:04 +0000)] 
fix compilation failure on OS/2 with the amalgamation (CVS 4109)

FossilOrigin-Name: 12327ca049e62922bfb3c2a14e42554fd58265e8

18 years agoExtend fts2 so that user defined tokenizers may be added. Add a tokenizer that uses...
danielk1977 [Fri, 22 Jun 2007 15:21:15 +0000 (15:21 +0000)] 
Extend fts2 so that user defined tokenizers may be added. Add a tokenizer that uses the ICU library if available. Documentation and tests to come. (CVS 4108)

FossilOrigin-Name: 68677e420c744b39ea9d7399819e0f376748886d

18 years agoClarify documentation of the column metadata APIs. Make sure that the
drh [Thu, 21 Jun 2007 15:25:05 +0000 (15:25 +0000)] 
Clarify documentation of the column metadata APIs.  Make sure that the
new documentation claims are tested. (CVS 4107)

FossilOrigin-Name: 2dafe08a91b5328a9d0df5ab29c3ff2d94ad5f6f

18 years agoUpdate the URL to mailing list archives. (CVS 4106)
drh [Thu, 21 Jun 2007 13:30:39 +0000 (13:30 +0000)] 
Update the URL to mailing list archives. (CVS 4106)

FossilOrigin-Name: af4b914a2152ce021401b6f78bb88a5323aa6fc2

18 years agoUse NAWK everywhere in Makefile.in. Ticket #2437. (CVS 4105)
drh [Wed, 20 Jun 2007 16:20:36 +0000 (16:20 +0000)] 
Use NAWK everywhere in Makefile.in.  Ticket #2437. (CVS 4105)

FossilOrigin-Name: 314669b6cc76ab8984857c3591aa1910aac97694

18 years agoA column name preceded by a unary "+" operator is considered to be
drh [Wed, 20 Jun 2007 16:13:23 +0000 (16:13 +0000)] 
A column name preceded by a unary "+" operator is considered to be
a column name when computing the collating sequence to be used by
a comparison operator or ORDER BY clause. (CVS 4104)

FossilOrigin-Name: 99a20f6a427b5e0e0a793f59ebca9d17bc633437

18 years agoRemove the dependency on libm for isnan(). Ticket #2436. (CVS 4103)
drh [Wed, 20 Jun 2007 15:29:25 +0000 (15:29 +0000)] 
Remove the dependency on libm for isnan().  Ticket #2436. (CVS 4103)

FossilOrigin-Name: 406675bb1c954dae95b9059f7f533ed57e3947d9

18 years agoRemove an unused variable from btree.c. (CVS 4102)
drh [Wed, 20 Jun 2007 15:14:10 +0000 (15:14 +0000)] 
Remove an unused variable from btree.c. (CVS 4102)

FossilOrigin-Name: cb47a8297fd91becdc4e1c50fd84b3efedd3951f

18 years agoFix comment typo in analyze.c. Ticket #2434. (CVS 4101)
drh [Wed, 20 Jun 2007 13:37:31 +0000 (13:37 +0000)] 
Fix comment typo in analyze.c.  Ticket #2434. (CVS 4101)

FossilOrigin-Name: df9957b94737b76ed7b1de77bb22bb27c7ae2dcf

18 years agoFix a bug in the command-line shell that prevents the
drh [Wed, 20 Jun 2007 13:10:00 +0000 (13:10 +0000)] 
Fix a bug in the command-line shell that prevents the
reading of the ".sqliterc" file.  Ticket #2433. (CVS 4100)

FossilOrigin-Name: 6eaf29f5e1e99b066825a1ccf34c82c9da6da826

18 years agoDisallow empty GROUP BY clauses. Ticket #2431. (CVS 4099)
drh [Wed, 20 Jun 2007 12:18:31 +0000 (12:18 +0000)] 
Disallow empty GROUP BY clauses.  Ticket #2431. (CVS 4099)

FossilOrigin-Name: 9581e7a4a4d74b08ce5380b49862957c804e46bb

18 years agoAdditional changes for ticket #2426. (CVS 4098)
drh [Wed, 20 Jun 2007 11:56:51 +0000 (11:56 +0000)] 
Additional changes for ticket #2426. (CVS 4098)

FossilOrigin-Name: 79debf95cdccdc1f18b6f0fcd213f514e327181c

18 years agoFix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097)
danielk1977 [Wed, 20 Jun 2007 09:09:47 +0000 (09:09 +0000)] 
Fix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097)

FossilOrigin-Name: f025a745319486d858e2831178a86265fd5fcf32

18 years agoChange main.mk to make it easier to build testfixture and sqlite3 with the icu or...
danielk1977 [Wed, 20 Jun 2007 08:49:05 +0000 (08:49 +0000)] 
Change main.mk to make it easier to build testfixture and sqlite3 with the icu or fts2 extensions linked in. (CVS 4096)

FossilOrigin-Name: 91719cc8eaf62f64099ff9eb2b48cef6c9c688f7

18 years agoFix snippet generation when the left-most column of an fts2 table is used in the...
danielk1977 [Wed, 20 Jun 2007 06:23:54 +0000 (06:23 +0000)] 
Fix snippet generation when the left-most column of an fts2 table is used in the MATCH clause. Fix for ticket #2429. (CVS 4095)

FossilOrigin-Name: fec56ad2ede53e3e202d9ad869a059eeb315796f

18 years agoChange the TCL bindings so that @aaa always treats the variable aaa as
drh [Tue, 19 Jun 2007 23:01:41 +0000 (23:01 +0000)] 
Change the TCL bindings so that @aaa always treats the variable aaa as
a bytearray and binds the value as a BLOB.  This change is backwards
compatible since the $ behavior is unchanged and @ was not accepted
until the current round of changes. (CVS 4094)

FossilOrigin-Name: 6f7d55acedc92eeaf988425c719addd56209187f

18 years agoCleanup the TCL interface source code and add documentation for recently
drh [Tue, 19 Jun 2007 17:48:57 +0000 (17:48 +0000)] 
Cleanup the TCL interface source code and add documentation for recently
added methods on the SQLite object of TCL. (CVS 4093)

FossilOrigin-Name: d88b79818a6a9e0413b9560687ec3c79fcb3dacc

18 years agoIn the TCL bindings, if a TCL variable has a bytearray representation and
drh [Tue, 19 Jun 2007 17:15:46 +0000 (17:15 +0000)] 
In the TCL bindings, if a TCL variable has a bytearray representation and
the host parameter starts with @ instead of $, then always store the
content as a BLOB not as a string even if a string representation is also
available. (CVS 4092)

FossilOrigin-Name: dcb104bd41f5e992d4c84b8947cb5099ae746891

18 years agoChange the name of the "limits.h" source file to "sqliteLimit.h".
drh [Tue, 19 Jun 2007 15:23:48 +0000 (15:23 +0000)] 
Change the name of the "limits.h" source file to "sqliteLimit.h".
Ticket #2428. (CVS 4091)

FossilOrigin-Name: 64bcc41f12e902fd025c9ba36c09dd6e4cf25923

18 years agoDo not segfault even if sqlite is misused by requesting query results
drh [Tue, 19 Jun 2007 10:58:24 +0000 (10:58 +0000)] 
Do not segfault even if sqlite is misused by requesting query results
after the query has been reset.  ticket #2426. (CVS 4090)

FossilOrigin-Name: 783f19be387561fbca3ac7e223bdb7dedb5450c8

18 years agoCast the 2nd parameter of ftruncate to off_t to work around bugs in
drh [Tue, 19 Jun 2007 10:50:38 +0000 (10:50 +0000)] 
Cast the 2nd parameter of ftruncate to off_t to work around bugs in
some unix implementations.  Ticket #2425. (CVS 4089)

FossilOrigin-Name: 0b20a69609c64af922bedab381f7d075e9da4fc5

18 years agoAnother attempt to fix the build process for TCL windows bindings. (CVS 4088)
drh [Mon, 18 Jun 2007 17:44:16 +0000 (17:44 +0000)] 
Another attempt to fix the build process for TCL windows bindings. (CVS 4088)

FossilOrigin-Name: 1fd2a358d6361768981d0c7efbcf30b47c52a732

18 years agoBring the pager_datahash() macro into sync with its function definition.
drh [Mon, 18 Jun 2007 17:25:17 +0000 (17:25 +0000)] 
Bring the pager_datahash() macro into sync with its function definition.
Ticket #2422. (CVS 4087)

FossilOrigin-Name: ba967bbb62ccf29438db352c573773ae741d0daf

18 years agoFix the build scripts so that they generate Tcl bindings for windows
drh [Mon, 18 Jun 2007 16:06:20 +0000 (16:06 +0000)] 
Fix the build scripts so that they generate Tcl bindings for windows
correctly. (CVS 4086)

FossilOrigin-Name: c7be8b419fdfe6561331485f5f866610457e44ad

18 years agoVersion 3.4.0 (CVS 4085)
drh [Mon, 18 Jun 2007 13:33:58 +0000 (13:33 +0000)] 
Version 3.4.0 (CVS 4085)

FossilOrigin-Name: 2647980fba92a453ef8afb48c80405d023177ab6

18 years agoDocumentation updates prior to release 3.4.0. Enhanced support for
drh [Mon, 18 Jun 2007 12:22:43 +0000 (12:22 +0000)] 
Documentation updates prior to release 3.4.0.  Enhanced support for
soak testing in the test scripts. (CVS 4084)

FossilOrigin-Name: eec387103869940697487ec5226eaed0b51ede7a

18 years agoFix a faulty assert() in the pager. (CVS 4083)
drh [Sat, 16 Jun 2007 18:39:41 +0000 (18:39 +0000)] 
Fix a faulty assert() in the pager. (CVS 4083)

FossilOrigin-Name: 4cff47b06132768e92ba2235cab5c17d1082f8f9

18 years agoModify the tests in exclusive2.test to account for the fact that the pager cache...
danielk1977 [Sat, 16 Jun 2007 14:43:51 +0000 (14:43 +0000)] 
Modify the tests in exclusive2.test to account for the fact that the pager cache may be very small by default. These tests are only valid if the entire database fitting in the cache. (CVS 4082)

FossilOrigin-Name: 04a13fe43e61bd0dbff42c448e763078503b00bf

18 years agoAdd another scenario to the soak1.tcl script. (CVS 4081)
drh [Sat, 16 Jun 2007 14:19:36 +0000 (14:19 +0000)] 
Add another scenario to the soak1.tcl script. (CVS 4081)

FossilOrigin-Name: 10e6822d4f1e0a94d5033b7b9efc1d8ed1e957d1

18 years agoA minor logic correction in the previous check-in. Also added a lengthy
drh [Sat, 16 Jun 2007 11:17:45 +0000 (11:17 +0000)] 
A minor logic correction in the previous check-in.  Also added a lengthy
comment describing the meanings of various flags in the
{quote: PgHdr} structure. (CVS 4080)

FossilOrigin-Name: 57bf8204cde47dfeb31c064f2b128b9a8d94189f

18 years agoFix a database corruption problem that can occur in auto-vacuum mode when
drh [Sat, 16 Jun 2007 04:42:12 +0000 (04:42 +0000)] 
Fix a database corruption problem that can occur in auto-vacuum mode when
a malloc() failure causes a statement rollback, additional statements
are run in the same transaction, then the total transaction rolls back. (CVS 4079)

FossilOrigin-Name: c9dcf2b926c99ff9cee68589f364461ab2a1d11f

18 years agoAdditional debugging instrumentation added to the pager. (CVS 4078)
drh [Sat, 16 Jun 2007 03:06:27 +0000 (03:06 +0000)] 
Additional debugging instrumentation added to the pager. (CVS 4078)

FossilOrigin-Name: dcdb20f81ae923f6f56d75c7b8b89a0b3abff954

18 years agoMake arrangements to optionally print a debug message at the point
drh [Fri, 15 Jun 2007 20:29:20 +0000 (20:29 +0000)] 
Make arrangements to optionally print a debug message at the point
of a simulated malloc() failure when SQLITE_MEMDEBUG is defined. (CVS 4077)

FossilOrigin-Name: 7d3c1f08a34fcf2ca5c79d6e58f713ae6a4b34e8

18 years agoFix more documentation typos. Ticket #2416. (CVS 4076)
drh [Fri, 15 Jun 2007 18:59:08 +0000 (18:59 +0000)] 
Fix more documentation typos.  Ticket #2416. (CVS 4076)

FossilOrigin-Name: b55318b12d026abd5a32469a19c36abbd6250137

18 years agoRemove a C++ism from the test harness. Get the TCL interface working with
drh [Fri, 15 Jun 2007 18:53:14 +0000 (18:53 +0000)] 
Remove a C++ism from the test harness.  Get the TCL interface working with
older versions of TCL. (CVS 4075)

FossilOrigin-Name: c8beb8674e5a1effc2785f205124628fbdaf57e0

18 years agoAdd a script for "soak" testing. (CVS 4074)
drh [Fri, 15 Jun 2007 18:43:37 +0000 (18:43 +0000)] 
Add a script for "soak" testing. (CVS 4074)

FossilOrigin-Name: d4ea1287a8b013a97fcb55bb7f7feba427222bab