/ Timeline
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

100 descendants of [dcb104bd]

2007-07-30
20:41
Make excess output from the CLI appear inside SQL comments so as not to interfere with generated SQL. Ticket #2544. (CVS 4192) check-in: 49a2e855 user: drh tags: trunk
18:55
Fix ticket #2439: the FTS1 and FTS2 extensions use the non-standard, unportable and highly deprecated <malloc.h> header on all platforms except Apple Mac OS X. The <malloc.h> actually is never required on any OS with an at least partly POSIX-conforming API as the malloc(3) & friends functions officially live in <stdlib.h> since over 10 years. Under some platform like FreeBSD the inclusion of <malloc.h> since a few years even causes an "#error" and this way a build failure. So, just get rid of the bad <malloc.h> usage in FTS1 and FTS2 extensions at all and stick with <stdlib.h> there only. (CVS 4191) check-in: 3f9a6661 user: rse tags: trunk
18:31
"extern" declarations inside function bodies are not every compiler's favorite, so move to global scope. Additionally, at least under Unix environment use <unistd.h> to get the proper prototype instead of using a K&R-style own declaration. (CVS 4190) check-in: 5955a77d user: rse tags: trunk
18:26
Get rid of the following compile-time warnings: tool/mkkeywordhash.c:353: warning: array subscript has type 'char' tool/mkkeywordhash.c:354: warning: array subscript has type 'char' (CVS 4189) check-in: c01d7944 user: rse tags: trunk
18:24
Get rid of the following compile-time warning: "src/shell.c:112: warning: 'iotracePrintf' defined but not used" (CVS 4188) check-in: 271e27fd user: rse tags: trunk
14:40
Fix a bug with explicit collation sequences attached to a column reference expression that is on the right-hand-side of a binary comparison operator. (CVS 4187) check-in: 7b699686 user: danielk1977 tags: trunk
2007-07-26
10:16
Test that an explicit collation sequence overrides an implicit one attached to a 'new' reference (it does). No code changes. (CVS 4186) check-in: a443b07e user: danielk1977 tags: trunk
06:50
Fix two obscure memory leaks that can follow a malloc() failure in sqlite3_set_auxdata(). Ticket #2534. (CVS 4185) check-in: b88af182 user: danielk1977 tags: trunk
2007-07-25
00:56
Implement xRename() for fts1 so that it is possible to rename fts1 tables. See http://www.sqlite.org/cvstrac/chngview?cn=4143 (CVS 4184) check-in: febf75f0 user: shess tags: trunk
00:38
Replicates http://www.sqlite.org/cvstrac/chngview?cn=4151 which modified fts2:    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 4183) check-in: f9020cff user: shess tags: trunk
00:28
Sorry, previous check-in included a last-minute "Did it really work?" change :-). (CVS 4182) check-in: 5db25e36 user: shess tags: trunk
00:25
Apply change 4095 to fts1. Fix snippet generation when the left-most column of an fts table is used in the MATCH clause. Fix for ticket #2429. (CVS 4181) check-in: c2ba3cc0 user: shess tags: trunk
2007-07-24
10:22
Remove the comment in the documentation that says that incremental vacuum mode is not persistent because as of 3.4.1 it is persistent. Ticket #2528. (CVS 4180) check-in: 6c404094 user: drh tags: trunk
2007-07-23
22:51
Detect nested aggregate functions even if the inner aggregate function is aliased using an AS clause. Ticket #2526. (CVS 4179) check-in: de000280 user: drh tags: trunk
19:39
The REPLACE conflict resolution falls back to FAIL when on a CHECK constraint violation. Ticket #2525. (CVS 4178) check-in: b213614a user: drh tags: trunk
19:31
Move prototypes for LEMON-generated parser functions into sqliteInt.h. Ticket #2521. (CVS 4177) check-in: bc02c7f1 user: drh tags: trunk
19:26
Check the return value of sqlite3PagerWrite() when autovacuuming. Ticket #2524. (CVS 4176) check-in: b4a5c62b user: drh tags: trunk
19:12
Rework the UTF8 reader logic in order to avoid the use of malloc(). Ticket #2523. (CVS 4175) check-in: 9a059cb6 user: drh tags: trunk
2007-07-22
19:10
Fix a bad sizeof in vdbe.c. Ticket #2522. (CVS 4174) check-in: 77ebc3fe user: drh tags: trunk
2007-07-21
19:41
Work around a bug in GCC. Ticket #2469. (CVS 4173) check-in: 1924ba52 user: drh tags: trunk
2007-07-20
20:25
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) check-in: b2ba3e81 user: aswift tags: trunk
13:42
Updates to build scripts. Added scripts for building FTS2 shared libraries. (CVS 4171) check-in: e269f6e9 user: drh tags: trunk
10:56
Version 3.4.1 (CVS 4170) check-in: 81a4dd07 user: drh tags: trunk
10:48
Keep sqlite3ext.h backwards compatible. This really should have been part of the previous check-in. (CVS 4169) check-in: 7cf15a5f user: drh tags: trunk
10:33
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) check-in: 63999349 user: drh tags: trunk
01:17
Documentation change in preparation for version 3.4.1. (CVS 4167) check-in: cf227766 user: drh tags: trunk
00:35
Fix a memory leak in the Rename method of the echo test virtual table. No changes to the core. (CVS 4166) check-in: e5c132ff user: drh tags: trunk
00:33
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) check-in: 31dba1e9 user: drh tags: trunk
2007-07-19
22:30
Disable tests that use the progress handler when the progress handler is disabled at compile-time. Followup to ticket #2497. (CVS 4164) check-in: cbc56fd4 user: drh tags: trunk
16:35
Preliminary fix for ticket #2518. Make sure the VACUUM command increments the change counter. (CVS 4163) check-in: 75263797 user: drh tags: trunk
12:41
Clarify the documentation on the nByte parameter to sqlite3_prepare(). Make it clear that nByte is a maximum string length. Ticket #2516. (CVS 4162) check-in: d1ae3de4 user: drh tags: trunk
2007-07-18
18:17
Get the min/max optimization working with descending indices. Ticket #2514. (CVS 4161) check-in: a80a3c9d user: drh tags: trunk
18:16
Additional diagnostics added to the "out" file generated by lemon. (CVS 4160) check-in: 7ef2aaf7 user: drh tags: trunk
2007-07-17
17:22
Fix annoying emacs warning about suspicious line. The change removes a leading space (emacs wants Makefiles to use leading tabs there). (CVS 4159) check-in: 4daadf65 user: shess tags: trunk
2007-07-13
10:36
Add an extra integrity_check to the transaction test script. (CVS 4158) check-in: 5ea43b2d user: drh tags: trunk
10:35
Update documentation to make it clear that VACUUM is free to change implicit rowids. Ticket #2382. (CVS 4157) check-in: d111b1da user: drh tags: trunk
10:26
"extern" prototypes cause problems for the Digital Mars compiler. So remove them. Ticket #2502. (CVS 4156) check-in: f35fbf80 user: drh tags: trunk
2007-07-12
13:18
Fix for #2497. Set the database error code to the return value of sqlite3_step(). (CVS 4155) check-in: b01fda5f user: danielk1977 tags: trunk
2007-07-03
23:37
Fix compilation warnings shown when using strict GCC options for os_os2.c. (CVS 4154) check-in: 22277b7e user: pweilbacher tags: trunk
05:31
Fix a memory leak in shell.c. Reported on the mailing list. This has only been informally tested. (CVS 4153) check-in: a008905b user: danielk1977 tags: trunk
2007-07-02
19:31
Fix a comment typo reported on the mailing list. (CVS 4152) check-in: 25e6df9c user: drh tags: trunk
10:16
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) check-in: dee1a0fd user: danielk1977 tags: trunk
2007-07-01
21:18
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) check-in: 35ae398b user: drh tags: trunk
15:41
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) check-in: cc210517 user: pweilbacher tags: trunk
2007-06-30
16:30
Including os2safe.h from os_os2.c is no longer necessary (now that it's including from os.h) (CVS 4148) check-in: 6432bbe1 user: pweilbacher tags: trunk
15:24
old emx/gcc sets __EMX__ (with double underscores) as builtin #define (CVS 4147) check-in: d69204fe user: pweilbacher tags: trunk
2007-06-29
12:04
Set FD_CLOEXEC on all open files under Unix. Ticket #2475. (CVS 4146) check-in: f1e5fed8 user: drh tags: trunk
2007-06-27
23:52
Add a test case to verify that ticket #2470 has been fixed. (CVS 4145) check-in: b3f44269 user: drh tags: trunk
17:09
Test error handling when renaming fts2 tables. (CVS 4144) check-in: 57840eba user: danielk1977 tags: trunk
16:26
Implement xRename() for fts2 so that it is possible to rename fts2 tables. (CVS 4143) check-in: 488474fd user: danielk1977 tags: trunk
15:53
Allow ALTER TABLE on virtual tables. (CVS 4142) check-in: 37d1f9f3 user: danielk1977 tags: trunk
15:01
respect $LDFLAGS from env/configure (CVS 4141) check-in: 9c13fc0f user: vapier tags: trunk
11:10
Fix for compiling with OMIT_VIRTUALTABLE defined. (CVS 4140) check-in: 850822e2 user: danielk1977 tags: trunk
10:21
Fix typo in comments of the sqlite.h.in header file - comments from which documentation is automatically extracted and generated. Ticket #2468. (CVS 4139) check-in: 53b52620 user: drh tags: trunk
10:20
Make sure auto_vacuum is turned off before running the tests in pragma2.test. (CVS 4138) check-in: fc85c8aa user: drh tags: trunk
00:36
Set the connection error code when sqlite3_blob_read() or sqlite3_blob_write() fail. Ticket #2464. (CVS 4137) check-in: 3bd990be user: drh tags: trunk
00:08
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) check-in: 2640f518 user: drh tags: trunk
2007-06-26
22:55
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) check-in: 5c93324b user: drh tags: trunk
22:42
Fix a test case so that it (hopefully) works on x86-64. Ticket #2465. (CVS 4134) check-in: 3daf7cae user: drh tags: trunk
22:10
Remove vestigal code from Makefile.linux-gcc. Ticket #2466. (CVS 4133) check-in: 338c1879 user: drh tags: trunk
12:54
Reorganize comments in fts2_tokenizer.h. No code changes. (CVS 4132) check-in: b331e303 user: danielk1977 tags: trunk
12:52
Use (((i64)1)<<63) instead of just (1<<63) to compute the most negative 64-bit integer. (CVS 4131) check-in: be2570c0 user: danielk1977 tags: trunk
11:13
Fix for #2444: Avoid SIGFPE on 64-bit platforms when evaluating expressions like ((1<<63)/-1). (CVS 4130) check-in: c6dfd9e4 user: danielk1977 tags: trunk
10:56
Remove the unused EXTSRC variable from the non-configure makefile. (CVS 4129) check-in: bbdcf372 user: danielk1977 tags: trunk
10:55
Fix an unitialized variable in fts2. (CVS 4128) check-in: c349cf94 user: danielk1977 tags: trunk
10:38
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) check-in: 7f887a6a user: danielk1977 tags: trunk
01:04
Try to work around an MSVC compiler bug. Ticket #2457. (CVS 4126) check-in: 4a7079a1 user: drh tags: trunk
00:52
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) check-in: 474a5234 user: drh tags: trunk
00:37
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) check-in: 96190cf1 user: drh tags: trunk
2007-06-25
17:28
Rework the string to integer conversion logic to address tickets #2344 and #2454. (CVS 4123) check-in: 5b3a4906 user: drh tags: trunk
16:29
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) check-in: 044ca1c7 user: danielk1977 tags: trunk
14:28
Modify the non-configure build system to make it easier to build the library with the fts2 or icu extensions linked in. (CVS 4121) check-in: 02b23c43 user: danielk1977 tags: trunk
13:50
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) check-in: c795e6fd user: drh tags: trunk
12:49
All the use of MySQL-style quoting in the FTS modules. Ticket #2446. (CVS 4119) check-in: 3be2a6d1 user: drh tags: trunk
12:05
Add a test that calls fts2_tokenizer() with an argument set via C code. (CVS 4118) check-in: fbcf2d75 user: danielk1977 tags: trunk
11:24
Add some tests for the fts2 icu tokenizer. (CVS 4117) check-in: b79ced3e user: danielk1977 tags: trunk
09:52
Add some documentation for user-defined fts2 tokenizers. (CVS 4116) check-in: 5a9eee86 user: danielk1977 tags: trunk
08:16
Make the auto_vacuum mode peristent in all cases. (CVS 4115) check-in: 5b0408dd user: danielk1977 tags: trunk
2007-06-24
16:11
Fix for #2451. Code comment changes only. (CVS 4114) check-in: bc61dcbf user: danielk1977 tags: trunk
10:14
Make setting "PRAGMA auto_vacuum = incremental" persistent if it is executed before the database file is created. (CVS 4113) check-in: c666fad1 user: danielk1977 tags: trunk
08:00
Add the "(database.)freelist_count" PRAGMA. For querying the size of the database free-list. (CVS 4112) check-in: 1fb4251a user: danielk1977 tags: trunk
06:32
When expanding '*' in the result set of a SELECT, quote the expanded identifiers. Fix for #2450. (CVS 4111) check-in: d5b7224f user: danielk1977 tags: trunk
2007-06-22
20:17
fix linking failure on OS/2 that happens with the amalgamation and the high memory option enabled (CVS 4110) check-in: f35e20e1 user: pweilbacher tags: trunk
20:04
fix compilation failure on OS/2 with the amalgamation (CVS 4109) check-in: 12327ca0 user: pweilbacher tags: trunk
15:21
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) check-in: 68677e42 user: danielk1977 tags: trunk
2007-06-21
15:25
Clarify documentation of the column metadata APIs. Make sure that the new documentation claims are tested. (CVS 4107) check-in: 2dafe08a user: drh tags: trunk
13:30
Update the URL to mailing list archives. (CVS 4106) check-in: af4b914a user: drh tags: trunk
2007-06-20
16:20
Use NAWK everywhere in Makefile.in. Ticket #2437. (CVS 4105) check-in: 314669b6 user: drh tags: trunk
16:13
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) check-in: 99a20f6a user: drh tags: trunk
15:29
Remove the dependency on libm for isnan(). Ticket #2436. (CVS 4103) check-in: 406675bb user: drh tags: trunk
15:14
Remove an unused variable from btree.c. (CVS 4102) check-in: cb47a829 user: drh tags: trunk
13:37
Fix comment typo in analyze.c. Ticket #2434. (CVS 4101) check-in: df9957b9 user: drh tags: trunk
13:10
Fix a bug in the command-line shell that prevents the reading of the ".sqliterc" file. Ticket #2433. (CVS 4100) check-in: 6eaf29f5 user: drh tags: trunk
12:18
Disallow empty GROUP BY clauses. Ticket #2431. (CVS 4099) check-in: 9581e7a4 user: drh tags: trunk
11:56
Additional changes for ticket #2426. (CVS 4098) check-in: 79debf95 user: drh tags: trunk
09:09
Fix for #2432 and partial fix for #2427 (documentation change only). (CVS 4097) check-in: f025a745 user: danielk1977 tags: trunk
08:49
Change main.mk to make it easier to build testfixture and sqlite3 with the icu or fts2 extensions linked in. (CVS 4096) check-in: 91719cc8 user: danielk1977 tags: trunk
06:23
Fix snippet generation when the left-most column of an fts2 table is used in the MATCH clause. Fix for ticket #2429. (CVS 4095) check-in: fec56ad2 user: danielk1977 tags: trunk
2007-06-19
23:01
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) check-in: 6f7d55ac user: drh tags: trunk
17:48
Cleanup the TCL interface source code and add documentation for recently added methods on the SQLite object of TCL. (CVS 4093) check-in: d88b7981 user: drh tags: trunk
17:15
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) check-in: dcb104bd user: drh tags: trunk