Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
126 events for the month beginning 2011-10-01 by user drh
Following month ↑|
2011-10-31
| ||
| 19:59 | Fix a problem with sqlite3_backup_step() that resulted from a faulty merge. (check-in: dacdec78 user: drh tags: apple-osx) | |
| 19:34 | Fix the os_unix.c source file so that it will build as part of an amalgamation on non-apple platforms. (check-in: b2f7639c user: drh tags: apple-osx) | |
| 18:46 | • Closed ticket [8290242b]: ALTER TABLE RENAME fails if the database encoding is not UTF8 (artifact: 10e1dd3e user: drh) | |
| 18:46 | • Closed ticket [3338b3fa]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause (artifact: 38e7c990 user: drh) | |
| 18:45 | • Closed ticket [f1c2a689]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. (artifact: 54d52170 user: drh) | |
| 18:44 | • Closed ticket [92bd6eaf]: Suggestion to revise clean rule in main.mk. (artifact: 20aa3c3b user: drh) | |
| 18:44 | • Closed ticket [57c971fc]: Some user defined string functions do not operate correctly on strings with embedded nuls (artifact: 6cae2ae2 user: drh) | |
| 14:42 | Pull the latest trunk changes into the apple-osx branch. (check-in: 4fa9ee79 user: drh tags: apple-osx) | |
| 14:34 | Merge in all changes found in the version 3.7.9 release candidate. (check-in: 23580718 user: drh tags: sessions) | |
| 12:25 | Fix a typo in a comment. No code changes. (check-in: 6635cd9a user: drh tags: trunk) | |
|
2011-10-29
| ||
| 12:42 | Fix some code formatting in sqlite3Ext.h to avoid lines longer than 80 characters. (check-in: 3ec20c30 user: drh tags: trunk) | |
| 01:33 | Avoid reporting a NOMEM error if a memory allocation fails while copying the error message from a prepared statement into the database connection. (check-in: dcb78793 user: drh tags: trunk) | |
|
2011-10-25
| ||
| 21:18 | Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil (check-in: 89d63a0e user: drh tags: branch-3.7.2) | |
| 20:36 | Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT (check-in: 14bc58ca user: drh tags: branch-3.7.2) | |
|
2011-10-22
| ||
| 21:00 | Avoid a harmless reference to an uninitialized variable following an error in FTS3. This is not a bug. The change is to silence a valgrind warning. (check-in: d980c5b2 user: drh tags: trunk) | |
|
2011-10-21
| ||
| 19:06 | Purge lingering references to SQLITE_STAT2 from the code and test scripts. (check-in: aed2bf7a user: drh tags: trunk) | |
| 17:24 | • Edit [df36ac948179f37b|df36ac94]: Mark "Closed". (artifact: 5a3e11e7 user: drh) | |
| 17:18 | Merge the latest trunk changes into the apple-osx branch. (check-in: be62ef05 user: drh tags: apple-osx) | |
| 17:08 | Merge the latest trunk enhancements into the sessions branch. (check-in: 8baef581 user: drh tags: sessions) | |
| 16:47 | Remove stale requirements marks from the query planner. (check-in: 76de9914 user: drh tags: trunk) | |
|
2011-10-20
| ||
| 18:23 | Fix an issue with finding the access permissions of journal files when 8+3 filenames are in use. (check-in: 2b35c514 user: drh tags: trunk) | |
| 00:55 | Enhancements to the omittest.tcl script used to verify that the SQLITE_OMIT compile-time options are working. (check-in: 4344483f user: drh tags: trunk) | |
|
2011-10-19
| ||
| 18:21 | Fix harmless compiler warnings in FTS4. (check-in: 1af4a256 user: drh tags: trunk) | |
| 17:13 | Fix comments on SQLITE_CONFIG_HEAP so that they do not interfere with the requirements scanner. (check-in: a3151ce1 user: drh tags: trunk) | |
|
2011-10-18
| ||
| 22:08 | • Fixed ticket [8290242b]: ALTER TABLE RENAME fails if the database encoding is not UTF8 plus 2 other changes (artifact: 10056736 user: drh) | |
| 22:07 | Fix the virtual table rename logic so that it works even if the database encoding is something other than UTF8. Ticket [8290242b2a9a81683] (check-in: d65f6353 user: drh tags: trunk) | |
| 21:31 | • New ticket [8290242b] ALTER TABLE RENAME fails if the database encoding is not UTF8. (artifact: 29bc8a6f user: drh) | |
| 19:14 | Fix an uninitialized variable in OR-clause processing. (check-in: 54aecd92 user: drh tags: trunk) | |
| 18:10 | • Fixed ticket [3338b3fa]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 1 other change (artifact: f3627349 user: drh) | |
| 18:10 | Improved handling of USING and NATURAL JOIN in 3-way and higher joins. Ticket [3338b3fa19ac4ab] (check-in: 551ce407 user: drh tags: trunk) | |
|
2011-10-17
| ||
| 23:15 | Change the OP_JournalMode implementation so that it works even if a substitute sqlite3PagerFilename() that might return NULL is used. (check-in: 491ff5fb user: drh tags: trunk) | |
| 20:41 | Avoid 32-bit integer overflow when evaluating the exponent of a floating point value during ascii to binary conversion. (check-in: 4becc47e user: drh tags: trunk) | |
| 12:14 | Performance improvement for ascii to floating-point conversions with very large exponents. (check-in: 59bb999c user: drh tags: trunk) | |
|
2011-10-15
| ||
| 00:16 | Added the tool/warnings-clang.sh script. Changes so that there are no warnings with either gcc or clang even including FTS4 and RTREE and both with and without SQLITE_THREADSAFE=0. (check-in: 39408702 user: drh tags: trunk) | |
|
2011-10-14
| ||
| 22:57 | Fix a few minor and harmless clang warnings in FTS3 and RTREE. (check-in: b3324f6c user: drh tags: trunk) | |
| 21:49 | Add assert() statements and eliminate needless variable assignments in order to get the clang scan-build utility to report zero problems against the SQLite core. Clang's static analysis did find one real problem - but it was in the command-line shell, not in the SQLite core. (check-in: 60fee957 user: drh tags: trunk) | |
|
2011-10-13
| ||
| 18:33 | • Fixed ticket [f1c2a689]: configure script ignores ``--with-tcl'' option when tclsh8.4 is installed. plus 3 other changes (artifact: b6fcb367 user: drh) | |
| 18:26 | • Closed ticket [d214d7b1]: FTS3 virtual table fails when names are quoted plus 3 other changes (artifact: db537fd8 user: drh) | |
| 18:25 | • Closed ticket [9861b74a]: Fts3 offsets() function may report SQLITE_CORRUPT with empty string. plus 3 other changes (artifact: ccd01a1d user: drh) | |
| 18:08 | • Fixed ticket [92bd6eaf]: Suggestion to revise clean rule in main.mk. plus 1 other change (artifact: 3fa6907f user: drh) | |
| 18:08 | Change the makefile to delete both plain and ".exe" variants of build tools. Ticket [92bd6eaf04e117] (check-in: 19536a38 user: drh tags: trunk) | |
| 18:01 | • Fixed ticket [57c971fc]: Some user defined string functions do not operate correctly on strings with embedded nuls plus 3 other changes (artifact: b5983b3d user: drh) | |
| 18:00 | Simplifications to the upper() and lower() SQL functions. Updates to documentation on sqlite3_bind_text() and sqlite3_result_text() to make it clear that users should not try to create strings with embedded NULs and that if they do the result of expression on those strings is undefined. Ticket [57c971fc74524a] (check-in: 9984cc20 user: drh tags: trunk) | |
| 17:09 | An improved fix for the page_count and quick_check problem previously patched at [150592b4b4d8637] (check-in: c3cb7f4f user: drh tags: trunk) | |
| 16:36 | Provide a complete prototype for isatty() in the command-line shell sources. (check-in: 8bf13b03 user: drh tags: trunk) | |
| 16:32 | • Closed ticket [4c9223e3]: Vacuum fails within transaction but also rolls it back plus 2 other changes (artifact: a34156cb user: drh) | |
| 16:30 | Change the command-line shell to do the ".dump" inside of a SAVEPOINT rather than a transaction, since this allows it to be run from within a transaction. (check-in: 6df7343b user: drh tags: trunk) | |
| 16:07 | • Closed ticket [ab7498f2]: 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause plus 1 other change (artifact: e275e420 user: drh) | |
| 16:05 | • Ticket [36712658] No error reporting on file open failure status still Open with 3 other changes (artifact: 79cac66c user: drh) | |
| 16:02 | • Fixed ticket [92af7da3]: shell won't import large files plus 2 other changes (artifact: 046edba7 user: drh) | |
| 16:02 | Enable large-file support for fopen() and friends in the command-line shell. Ticket [92af7da36b6fbd] (check-in: eeeba4f0 user: drh tags: trunk) | |
| 15:56 | • Fixed ticket [0c80ff9f]: Quickstart missing include of stdlib.h plus 2 other changes (artifact: 79a5d8d6 user: drh) | |
| 15:38 | • Fixed ticket [fa7bf5ec]: String literal case confusion in aggregate query plus 3 other changes (artifact: 6c4389fa user: drh) | |
| 15:35 | Make sure the query optimizer for aggregate queries knows that expressions (x='a') and (x='A') are different. Ticket [fa7bf5ec94801e7e] (check-in: e43da426 user: drh tags: trunk) | |
| 15:16 | • New ticket [fa7bf5ec] String literal case confusion in aggregate query. (artifact: 02e4c841 user: drh) | |
| 14:46 | • Closed ticket [b2d64a52]: pkgIndex.tcl is being deleted by 'make clean' but it is not created by 'make' plus 2 other changes (artifact: bc412bc8 user: drh) | |
| 14:44 | • Closed ticket [3338b3fa]: ambiguous column name when using multiple JOIN USING clauses and WHERE clause plus 2 other changes (artifact: 2040c0e5 user: drh) | |
| 14:41 | Make sure the page_count and quick_check pragmas work properly even when their names are capitalized. Fixes a problem reported on the mailing list. (check-in: 150592b4 user: drh tags: trunk) | |
| 14:23 | • Closed ticket [6e1086fb]: "create table as select" and "pragma *_column_names" plus 1 other change (artifact: f0f9668b user: drh) | |
| 14:18 | Adjust the symbols.sh script for STAT3. Add the symbols-mingw.sh script for testing on windows with MinGW. (check-in: c41d1d46 user: drh tags: trunk) | |
| 14:13 | • Ticket [af3450b7] Recursive virtual tables status still Open with 3 other changes (artifact: d9fd2463 user: drh) | |
| 14:12 | • Fixed ticket [991789d9]: ext/fts? code uses tolower() when parsing tokens, which is problematic when using certain locales, such as tr_TR.UTF-8. plus 1 other change (artifact: 026d5b36 user: drh) | |
| 14:12 | • Edit [b8b465ed2c56b23b|b8b465ed]: Edit check-in comment. (artifact: f3fb4a67 user: drh) | |
| 14:05 | • Fixed ticket [35c54c87]: Some os win symbols should be declared static plus 2 other changes (artifact: 1182526a user: drh) | |
| 14:05 | Make sure all non-API functions in os_win.c have file scope. Ticket [35c54c874987] (check-in: 17e4fde5 user: drh tags: trunk) | |
| 13:53 | • Fixed ticket [aa92c76c]: Problem with GROUP BY and the distinction between real and integer values plus 2 other changes (artifact: 9a2eee3d user: drh) | |
| 13:52 | • Closed ticket [43d2aa29]: H13015 needs to be completed plus 2 other changes (artifact: f32fc486 user: drh) | |
| 13:52 | • Closed ticket [4776dee0]: Documentation and code about registering functions plus 1 other change (artifact: ca1846da user: drh) | |
| 13:35 | • Closed ticket [ac55d88a]: H10336 is no longer applicable plus 2 other changes (artifact: ed1c3715 user: drh) | |
| 13:34 | • Fixed ticket [24666532]: Various dump issues plus 1 other change (artifact: 3fcbbe87 user: drh) | |
| 13:34 | Do the ".dump" command inside of a transaction to prevent other processes from modifying the database while the dump is underway. Ticket [2466653295e65] (check-in: 1c00d545 user: drh tags: trunk) | |
| 13:25 | • Fixed ticket [517e206a]: Fix sqlite3_analyzer plus 2 other changes (artifact: de2e5dae user: drh) | |
| 13:24 | • Closed ticket [54831703]: H35230 & H35240 refer incorrectly to H35230 - should be H35220 plus 2 other changes (artifact: c5cb2722 user: drh) | |
| 13:23 | • Closed ticket [cbd054fa]: "out of memory" in ANALYZE with SQLITE_ENABLE_STAT2 (artifact: c7d03710 user: drh) | |
| 13:22 | • Fixed ticket [9d68c883]: Database corruption following OOM fault plus 2 other changes (artifact: a5cd168d user: drh) | |
| 13:21 | • Fixed ticket [26ff0c82]: Incorrect result when using unnamed "?" bindings plus 2 other changes (artifact: f9fda6f1 user: drh) | |
| 13:20 | • Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 8a44239e user: drh) | |
| 13:19 | • Fixed ticket [fc62af45]: Executing "PRAGMA journal_mode" may delete journal file while it is in use. plus 1 other change (artifact: fe5973ee user: drh) | |
| 13:18 | • Ticket [f817a457] CantOpen doesn't include name of file that can't be opened status still Open with 3 other changes (artifact: 6864a995 user: drh) | |
| 13:16 | • Fixed ticket [54844eea]: Incorrect caching of sub-query results in the FROM clause of a scalar sub-query. plus 1 other change (artifact: 3894b502 user: drh) | |
| 13:15 | • Fixed ticket [e59bdf61]: Possible database corruption following EINTR on unix plus 2 other changes (artifact: 5384614f user: drh) | |
| 13:13 | • Fixed ticket [af95b8c6]: Vacuuming a WAL database resets the file header read and write versions to 1. plus 2 other changes (artifact: d2b24c04 user: drh) | |
| 01:01 | Fix a harmless compiler warning introduced into os_unix.c by one of the recent changes. (check-in: 4bf4d5eb user: drh tags: trunk) | |
| 00:42 | • Fixed ticket [ee19e690]: If shell is interrupted while dumping it still produces commit (and invalid dump) plus 2 other changes (artifact: 607efff6 user: drh) | |
| 00:41 | If errors are encountered while processing the ".dump" command in the command-line shell, print error messages as comments in the output and ROLLBACK at the end rather than committing. Ticket [ee19e690ec9a5a2] (check-in: 8a8dcd6b user: drh tags: trunk) | |
| 00:11 | • Fixed ticket [7d32c69b]: sqlite3LoadExtension truncates file names plus 2 other changes (artifact: d69605cf user: drh) | |
| 00:11 | Be sure to allocate plenty of space for error messages coming out of sqlite3_load_extension(), so that filenames and procedure names are not truncated. Ticket [7d32c69b50f89d] (check-in: af8bcdd9 user: drh tags: trunk) | |
|
2011-10-12
| ||
| 23:50 | • Fixed ticket [20f9d4fb]: sqlite3_overload_function ignores errors plus 2 other changes (artifact: 16e6acf2 user: drh) | |
| 23:49 | The sqlite3_overload_function() interface returns an error if it is unable to create the overload function. Ticket [20f9d4fbbff3a3] (check-in: d5b6b374 user: drh tags: trunk) | |
| 23:14 | • Fixed ticket [0b803bff]: Return (error code) of xCurrentTime is always ignored plus 2 other changes (artifact: 4120d6b5 user: drh) | |
| 23:13 | The date/time functions return NULL if the xCurrentTime or xCurrentTimeInt64 VFS methods fail. Ticket [0b803bff856c644c] (check-in: c96651dd user: drh tags: trunk) | |
| 19:04 | Suppress a compiler warning that occurs with SQLITE_OMIT_VIRTUALTABLE. (check-in: 6bedb49d user: drh tags: trunk) | |
| 18:52 | Clean up obsolete comments in printf.c. (check-in: 97ef4f50 user: drh tags: trunk) | |
| 17:00 | Clarify a comment and fix a code formatting issue in btree.c. (check-in: 4f1a558d user: drh tags: trunk) | |
|
2011-10-11
| ||
| 20:41 | Put in code to defend against signed/unsigned character problems in the command-line shell. (check-in: b94a80a8 user: drh tags: trunk) | |
| 20:14 | Add a couple of asserts trying to make the operation of sqlite3SelectNew() clearer. (check-in: b21b1c7b user: drh tags: trunk) | |
| 18:38 | Simplify the readonly_shm implementation so that it conforms to the implementation on trunk. Update the test cases to agree with the new behavior. (check-in: 9efb74ce user: drh tags: apple-osx) | |
| 18:18 | Change the behavior of the readonly_shm=1 query parameter so that it never attempts to open the -shm file read/write. (check-in: f1364004 user: drh tags: trunk) | |
| 17:54 | Remove all precision and width limits from formatting fields in the sqlite3_mprintf() family of functions. Malloc for space as necessary. The prevents a stack overflow on very large numbers using %f. (check-in: 1f843fb3 user: drh tags: trunk) | |
| 15:03 | Fix a locking error introduced when porting the new Apple locking code. (check-in: cce1f521 user: drh tags: apple-osx) | |
| 14:19 | Merge the latest trunk changes into the apple-osx branch. (check-in: 7e2c4898 user: drh tags: apple-osx) | |
| 12:58 | Merge all the latest trunk changes into the sessions branch - especially the SQLITE_ENABLE_STAT3 enhancements. (check-in: 403431ca user: drh tags: sessions) | |
| 12:39 | Fix requirements marks associate with STAT3. (check-in: 9325c1a8 user: drh tags: trunk) | |
| 00:09 | Patches to the apple-osx-377 branch so that it will compile and run on non-Mac unix platforms. (Leaf check-in: b431a634 user: drh tags: apple-osx-377) | |
|
2011-10-10
| ||
| 23:53 | Forward port the Apple-specific changes from [db5b7b778c] in the apple-osx-377 branch. Fix this up so that it will compile and run on Linux. (check-in: 6cb43f6c user: drh tags: apple-osx) | |
| 18:59 | • Edit [aef7945c423a8338|aef7945c]: Edit check-in comment. Cancel background color. (artifact: fe0f9bb6 user: drh) | |
| 18:59 | Cherrypick the sqlite_data_count() changes from [d4f95b3b6e] and [9913996e7b] into the apple-osx branch for version 3.7.7. (check-in: aef7945c user: drh tags: apple-osx-377) | |
| 16:06 | Enhance sqlite3_analyzer so that it is able to deal with multiplexed databases that have 8+3 filenames. (check-in: e5169f9a user: drh tags: trunk) | |
| 12:04 | Fix a typo in a comment for PRAGMA journal_mode. Also amplify that same comment. (check-in: c8ff2a48 user: drh tags: trunk) | |
|
2011-10-08
| ||
| 21:39 | All the soft_heap_limit to be exceeded by 10% in test cases. (check-in: 4be9dccc user: drh tags: trunk) | |
|
2011-10-07
| ||
| 23:52 | Change the ANALYZE command so that it no longer tried to delete unused sqlite_stat2 and sqlite_stat3 tables. Change the DROP TABLE command so that it is able to drop those tables. (check-in: 589f3f56 user: drh tags: trunk) | |
| 18:24 | Make sure sqlite3_data_count() behaves as documented, even for EXPLAIN QUERY PLAN queries. (check-in: d4f95b3b user: drh tags: trunk) | |
| 17:56 | • Edit [5c132592820e9dc2|5c132592]: Mark "Closed". (artifact: f78ac0f5 user: drh) | |
| 17:52 | Improved handling of OR terms in the WHERE clause with multi-column indexes. (check-in: b23ae131 user: drh tags: trunk) | |
| 17:45 | Add testcase() macros to ensure good test coverage. (Closed-Leaf check-in: 5c132592 user: drh tags: or-opt) | |
| 16:08 | More test cases for the OR optimization. (check-in: 4997d8b8 user: drh tags: or-opt) | |
| 14:40 | Prevent infinite recursion of in the query planner for some pathological test cases by disabling OR-clause processing upon first recursion. (check-in: 9fca05ea user: drh tags: or-opt) | |
| 13:33 | Begin an effort to enhance the query planner to do a better job with OR terms in the WHERE clause. This change allows ANDs outside of the OR to be factored into the OR terms if that is helpful in finding better indices. (check-in: 876bd21a user: drh tags: or-opt) | |
| 12:59 | Enhance the sqlite3_data_count() routine so that it can be used to determine if SQLITE_DONE has been seen on the prepared statement. (check-in: 9913996e user: drh tags: trunk) | |
|
2011-10-05
| ||
| 19:46 | Add the --pageinfo and --stats options to the sqlite3_analyzer utility. (check-in: baa80c7b user: drh tags: trunk) | |
| 18:18 | Update the sqlite3_analyzer utility program to provide more details about the compression performance of ZIPVFS database files. (check-in: fa5ed532 user: drh tags: trunk) | |
| 15:26 | When finding the appropriate file permissions for journal files with SQLITE_ENABLE_8_3_NAMES, ignore "-" characters in the name of the containing directory. (check-in: 328cc186 user: drh tags: trunk) | |
|
2011-10-03
| ||
| 17:58 | • Edit [eaf447ea87b0ff29|eaf447ea]: Mark "Closed". Edit check-in comment. (artifact: 44c3c5a9 user: drh) | |
| 17:57 | • Edit [a7e18468825622e5|a7e18468]: Mark "Closed". (artifact: ada7ff27 user: drh) | |
| 17:57 | • Edit [4a153f010037db83|4a153f01]: Mark "Closed". Edit check-in comment. (artifact: 29c0b3bb user: drh) | |
| 15:30 | Merge the STAT3 changes into trunk. (check-in: 774d0842 user: drh tags: trunk) | |