/ Timeline
Login

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

100 ancestors of [9605d008]

2015-05-22
18:40
Update with fixes and enhancements from trunk. check-in: 9605d008 user: drh tags: value-dup
17:29
The SRT_Table type for the SelectDest object is now just an SRT_EphemTab for which the ephemeral table has already been allocated. check-in: b9727e6b user: drh tags: trunk
16:08
Have r-tree prefer to use the constraint "col MATCH ?" over "rowid = ?". check-in: b9fb9519 user: dan tags: trunk
13:09
Fix two faulty assert statements discovered by fuzzing. check-in: 799817bf user: drh tags: trunk
12:37
Fix an assert in btree.c that can be false when using a corrupted database file. check-in: a6eb2a39 user: drh tags: trunk
11:38
Add the --database option to the fuzzershell test program. check-in: c6d5512f user: drh tags: trunk
2015-05-20
21:28
Add the sqlite3_value_dup() and sqlite3_value_free() interfaces. Use these interfaces to enhance R-Tree to add the sqlite3_rtree_query_info.apSqlParam field. check-in: a7ee40c4 user: drh tags: value-dup
17:36
Fix the initialization logic in CREATE TABLE AS so that the correct affinities are applied to all values being inserted into the new table, even if the RHS is a compound SELECT. Fix for ticket [f2ad7de056ab1dc9200]. check-in: 6a0cf3ce user: drh tags: trunk
17:25
Add a test case to verify that CREATE TABLE AS does not store INT values in TEXT columns. Ticket [f2ad7de056ab1dc92]. Closed-Leaf check-in: 0e45e8f1 user: drh tags: create-table-as-type-fix
17:18
Simplification of the initialization code for CREATE TABLE AS. check-in: 937f659e user: drh tags: create-table-as-type-fix
15:51
A proposed fix for the problem of CREATE TABLE AS generating a table that has INTEGER values in a TEXT column. Ticket [f2ad7de056ab1dc92]. check-in: d5e2c1fc user: drh tags: create-table-as-type-fix
00:15
Fix handling of queries with VALUES on the left and UNION ALL SELECT on the right and a LIMIT clause. check-in: c403502c user: drh tags: trunk
2015-05-19
23:56
Enhance the selecttrace display by showing Select.selFlags. check-in: 45d3893c user: drh tags: trunk
22:56
Fix the MSVC makefile so that it works with OTA. Fix a harmless compiler warning in FTS3. check-in: c7b16645 user: drh tags: trunk
22:20
Allow R-Tree geometry functions to take 8-byte BLOB arguments which are passed directly through to the underlying callback, and which can be used to pass pointers into the callback. check-in: b271ed56 user: drh tags: trunk
19:44
Ensure that when the VM applies TEXT affinity to a value it discards any existing REAL or INTEGER value. Fix for [34cd55d6]. check-in: f5d0ce80 user: dan tags: trunk
17:48
Remove the sqlite3ota_open_v2() API. Add a new parameter to sqlite3ota_open() instead. check-in: c74e0bc4 user: dan tags: trunk
16:50
Merge the ota-update branch with trunk. check-in: 08e2864e user: dan tags: trunk
16:26
Add a comment for SQLITE_FCNTL_OTA to sqlite.h.in. Closed-Leaf check-in: efa20f8e user: dan tags: ota-update
16:22
Allow OTA update state data to be stored in a database separate from the OTA update database. check-in: 5af8db56 user: dan tags: ota-update
14:14
Merge latest trunk changes with this branch. check-in: 6055a672 user: dan tags: ota-update
2015-05-18
12:28
Transitive constraints should only work if operands have compatible affinities and collating sequences. check-in: 5df40564 user: drh tags: trunk
12:18
Use an ALWAY() on conditionals in the transitive constraint logic that are always true as far as we know. Closed-Leaf check-in: 204e567f user: drh tags: transitive-constraints
11:34
Refinements to the determination of when an A==B term is an equivalence. Add test cases. check-in: 6bfaf525 user: drh tags: transitive-constraints
04:24
Make a hard copy of the results of a subquery lest the result of the subquery be referenced after a change to the table that generated the subquery result. check-in: 9c0d8090 user: drh tags: trunk
2015-05-16
20:51
Further restrictions on the use of the transitive property in WHERE clauses. check-in: 8c886c43 user: drh tags: transitive-constraints
19:17
Fix the transitive constraint processing to only allow transitivity if the operands of the == or IS operator have compatible affinities. check-in: a46a247f user: drh tags: transitive-constraints
18:31
Fix a typo in a comment. No changes to code. check-in: ee4b7425 user: drh tags: trunk
03:41
Improve the clean target in the MSVC makefile. check-in: 2c1039d4 user: mistachkin tags: trunk
2015-05-15
22:20
Update the README.md file at the top of the repository so that the homepage of Git mirrors of SQLite direct users to the official repository. check-in: 08f11980 user: drh tags: trunk
20:14
Minor coding style change, adjust new local variable casing for consistency. check-in: 1a4628c6 user: mistachkin tags: trunk
19:59
Do not assume that "col IS ?" matches at most a single row of a UNIQUE column unless the column is also NOT NULL. check-in: e038ce89 user: dan tags: trunk
04:13
Simplifications to error message processing. Fix a possible problem in error message formatting when vacuuming a database with a corrupt schema. check-in: 56ef98a0 user: drh tags: trunk
2015-05-14
15:39
Increase the version number to 3.8.11. Upgrade autoconf from 2.62 to 2.69. check-in: be438d04 user: drh tags: trunk
14:32
The IS operator can now use indexes the same as the == operator. check-in: 3428043c user: drh tags: trunk
14:03
A few more test cases for the IS operator. Closed-Leaf check-in: f397c862 user: drh tags: index-is-operator
13:41
More test cases. Remove some invalid testcase() macros. Rearrange some code for improved testability. check-in: b3676377 user: drh tags: index-is-operator
13:18
Add testcase() macros. Get transitive WHERE clause constraints on IS operators working again. check-in: d195d4a6 user: drh tags: index-is-operator
09:53
Merge changes from the index-is-operator branch into this one. Drop the partial support added for IS on this branch by [52e73eec]. check-in: 16ab9caf user: dan tags: ota-update
08:58
Merge latest trunk changes with this branch. check-in: 299ed55c user: dan tags: ota-update
01:05
A new implementation of indexing with the IS operator that works correctly when the IS operator is in the WHERE clause and the operands are from opposite sides of a LEFT JOIN. check-in: 4541688b user: drh tags: index-is-operator
2015-05-13
19:33
Simplified implementation of indexing with the IS operator. check-in: 95b1f9bf user: drh tags: index-is-operator
17:54
Add testcase() macros and comments and a few test-cases. check-in: 24263d08 user: drh tags: index-is-operator
15:24
An early attempt to get indexes to work with the IS operator. This code passes tests, but much more testing is needed to verify that it works on all corner cases. check-in: 6f7f1673 user: drh tags: index-is-operator
04:50
Enhancements to the MSVC makefile. check-in: 59e3e9e7 user: mistachkin tags: trunk
2015-05-12
19:53
Fix typo in Win32 VFS code enabled when the SQLITE_WIN32_USE_UUID compile-time option is used. check-in: b33f1bac user: mistachkin tags: trunk
19:10
Attempt to get DBSTAT to compile without warnings across all build configurations. check-in: c3cbe3b0 user: drh tags: trunk
14:22
Fix a compiler warning when building with tclsqlite3.c and without SQLITE_ENABLE_DBSTAT_VTAB. check-in: aad3ff25 user: drh tags: trunk
13:32
Improvements to documentation of the sqlite3_column_xxxxx() interfaces. No code changes. check-in: f1aa951a user: drh tags: trunk
12:24
Try to get recent sqlite3_analyzer and sqldiff tests working for all tested combinations of compile-time options, especially SQLITE_OMIT_VIRTUALTABLE and SQLITE_OMIT_LOAD_EXTENSION. check-in: 07c7d392 user: drh tags: trunk
00:46
Fix sqldiff.exe so that it always runs in single-thread mode. check-in: c223910e user: drh tags: trunk
2015-05-11
19:01
Add new fts3 matchinfo option 'b'. Also optimize existing option 'y'. check-in: 2e7679a1 user: dan tags: trunk
18:48
Add missing "finish_test" commands to the end of the two new test scripts for sqlite3_analyzer and sqldiff. check-in: 1d5e72b1 user: drh tags: trunk
18:46
Merge latest trunk changes into this branch. Closed-Leaf check-in: 82e5a6e0 user: dan tags: fts3-matchinfo-y
17:46
Test cases for sqlite3_analyzer and sqldiff. Fix a problem with sqlite3_analyzer related to the renaming of the initialization routine. check-in: 85a4a46c user: drh tags: trunk
16:27
Fix minor Makefile typos. Improve consistency of MSVC makefile. Add new targets to clean. check-in: f84fbe98 user: mistachkin tags: trunk
12:15
Build the sqlite3_analyzer.exe and sqldiff.exe programs on "make test" and "make smoketest" and other similar test targets. check-in: 1b83f2e7 user: drh tags: trunk
11:59
Revamp the way the DBSTAT virtual table is registered. check-in: 4e652015 user: drh tags: trunk
06:22
Change autoconf/Makefile.am to avoid building target sqlite3.o as part of both the shared library and shell tool. Doing so causes problems for parallel builds. check-in: 85bfa9a6 user: dan tags: trunk
2015-05-10
02:01
Fix the sqlite3_memory_used() and sqlite3_memory_highwater() interfaces so that they really do provide a 64-bit answer. check-in: 8a0d5d5e user: drh tags: trunk
2015-05-09
12:14
Version 3.8.10.1 check-in: 05b4b1f2 user: drh tags: trunk, release, version-3.8.10.1
10:27
Bump the version number to 3.8.10.1 check-in: 9c6bf0c1 user: drh tags: trunk
2015-05-08
01:04
Fix harmless compiler warning with MSVC. check-in: 902d0cb8 user: mistachkin tags: trunk
00:58
Remove a couple stray test breakpoint calls. check-in: 2860cebe user: mistachkin tags: trunk
2015-05-07
20:26
Add an entry to sqlite3_compileoption_used() for SQLITE_ENABLE_DBSTAT_VTAB. check-in: 480b4cb0 user: drh tags: trunk
18:29
Testing improvements and corner-case bug fixes for the dbstat virtual table. check-in: d51ce539 user: drh tags: trunk
14:41
Enhance the dbstat virtual table with the ability to analyze ATTACHed databases. check-in: 25ec0940 user: drh tags: trunk
11:53
Version 3.8.10 check-in: cf975957 user: drh tags: trunk, release, version-3.8.10
00:09
Remove a faulty assert() statement. check-in: 5f2539da user: drh tags: trunk
2015-05-06
18:15
Merge latest trunk changes with this branch. check-in: 8a13e1fd user: dan tags: fts3-matchinfo-y
17:51
Remove some dead code from fts3_snippet.c. check-in: 46b2d3ce user: dan tags: fts3-matchinfo-y
17:41
More optimization for the 'y' and 'b' matchinfo directives. check-in: 8c5b9fed user: dan tags: fts3-matchinfo-y
14:18
Have the autoconf package build the shell tool with SQLite linked in statically. check-in: 31834c3a user: dan tags: trunk
08:43
Further optimizations for the 'y' and 'b' matchinfo operators. check-in: fbd038bb user: dan tags: fts3-matchinfo-y
2015-05-05
20:39
Add the fts3 matchinfo 'b' flag. check-in: b9b77972 user: dan tags: fts3-matchinfo-y
19:37
Optimizations for the matchinfo() function, particularly the 'y' flag. check-in: dddd7e18 user: dan tags: fts3-matchinfo-y
18:52
Remove four lines of superfluous code identified by clang scan-build. check-in: 04afa3fe user: drh tags: trunk
16:57
Fix a minor coding inefficiency found during pre-release inspection. check-in: cc50883d user: drh tags: trunk
11:08
Add #ifdef statements to test_blob.c so that it will build with SQLITE_OMIT_INCRBLOB. check-in: b8f090e6 user: drh tags: trunk
10:46
Spell SQLITE_OMIT_VIRTUALTABLE correctly in a #if in dbstat.c. check-in: d2cb1bec user: drh tags: trunk
10:03
Fix a faulty assert() in the btree part of the "PRAGMA page_size = ?" code. check-in: 90b19748 user: dan tags: trunk
01:09
Fix a problem in Makefile.in that only comes up on Windows with MinGW. check-in: 5f3cd68b user: drh tags: trunk
00:48
Fix #ifdef problem in tclsqlite.c. check-in: fe723bb5 user: drh tags: trunk
2015-05-04
20:25
Automatically enable the dbstat virtual table on all new database connections with the SQLITE_ENABLE_DBSTAT_VTAB compile-time option is used. check-in: 1c9c6eaa user: drh tags: trunk
19:13
In the command-line shell, and the ".binary" command and additional C-style backslash escapes. check-in: 850c1186 user: drh tags: trunk
19:06
Add the "dbstat" virtual table as a standard component in the SQLite amalgamation, though turned off unless compiled with SQLITE_ENABLE_DBSTAT_VTAB. check-in: e7529705 user: drh tags: trunk
18:31
Rename the test_stat.c source file to dbstat.c and rework the makefiles to make dbstat.c a first-class source module. Closed-Leaf check-in: a24480a4 user: drh tags: dbstat-in-amalgamation
17:06
Include the "dbstat" virtual table in the amalgamation. check-in: fc6504aa user: drh tags: dbstat-in-amalgamation
16:09
Fix a faulty assert() in the SELECT code generator and add a test case to prevent regression. check-in: 1421c8ff user: drh tags: trunk
15:04
Fix a bug in --changeset output for sqldiff.exe for floating-point values. Also fix harmless compiler warnings in sqldiff.exe. check-in: 9f428530 user: drh tags: trunk
13:25
Add the --lib option to the sqldiff.exe command-line utility. check-in: a117e8f6 user: drh tags: trunk
12:29
Add the 'y' flag to the fts3/4 matchinfo() function. check-in: aef1e8f4 user: dan tags: trunk
2015-05-02
19:54
Improvements to fuzzershell: Avoid excess memory allocations when loading many files. Show the total runtime on final output. Show individual filenames as they are processed even if they are single test-case files. check-in: 34a722a2 user: drh tags: trunk
17:40
Add the ".limit" command to the command-line shell. check-in: 803cb60e user: drh tags: trunk
12:40
Reorganize some multi-threaded code in vdbesort.c so that full MC/DC test coverage does not depend on the outcome of a race condition. check-in: 78c7ec95 user: dan tags: trunk
11:45
Cleanup of the sqlite3StrAccumInit() function. No functionality changes. check-in: 7952c322 user: drh tags: trunk
09:44
Add the experimental matchinfo 'y' flag to fts3/4. Closed-Leaf check-in: 92941609 user: dan tags: fts3-matchinfo-y
2015-05-01
20:34
Enhance the fuzzershell --uniquecases option to output results in order of increasing runtime and to include the runtime in the comment separator of the output. check-in: 04630b98 user: drh tags: trunk
19:21
Enhance fuzzershell to accept multiple input files. Add the test/fuzzdata2.txt fuzz test content. check-in: ab5523aa user: drh tags: trunk
18:00
Fix an assert in RTREE that would fire if the rtree table is misdeclared. check-in: 9a45409c user: drh tags: trunk
16:57
Fix an assert() failure caused by setting "PRAGMA journal_mode=off" on an database in exclusive-mode that has already opened the journal file. check-in: 40db3e40 user: dan tags: trunk