/ 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 check-ins occurring around 28c9e7fdee2471a3.

2013-05-15
16:24
Extra test for commit [6dae62c4e5]. check-in: b10b9e75 user: dan tags: trunk
16:16
Add main.c to the list of files compiled with SQLITE_TEST defined when building testfixture. check-in: a58af814 user: dan tags: trunk
16:08
Fix the sharedA.test module so that it does not attempt to run TCL callbacks on a different thread from where the interpreter was originally created. Closed-Leaf check-in: 65ff754e user: drh tags: shared-cache-fixes
15:53
Do not run sharedA.test if the system is not threadsafe. check-in: d484eaf8 user: dan tags: shared-cache-fixes
15:42
Merge latest trunk changes with this branch. check-in: 47dd65a8 user: dan tags: shared-cache-fixes
15:16
When loading a database schema that contains an index definition that includes a COLLATE clause for which the collation sequence is unavailable, do not assume that that index uses BINARY instead. Fix for [0fc59f908b]. check-in: 6dae62c4 user: dan tags: trunk
13:05
Add the rot13.c loadable extension. check-in: 8f9bd8e7 user: drh tags: trunk
10:21
When closing a connection, avoid tripping active cursors belonging to a different shared-cache client. Also, if sqlite3_close() is called while there are still active statements belonging to the connection, return SQLITE_BUSY and do not roll back any active transaction. Proposed fix for ticket [e636a050b709]. check-in: 6071b7cc user: dan tags: shared-cache-fixes
08:00
Merge updates from trunk. check-in: 6fbad957 user: mistachkin tags: toTypeFuncs
2013-05-14
23:13
Merge together the fork in this branch. check-in: 164e3d4d user: drh tags: shared-cache-fixes
23:12
Fix an assert() in unlockBtreeIfUnused() so that it checks for the existance of an untripped cursor, not for the existance of any cursor at all. check-in: a6f851d0 user: drh tags: shared-cache-fixes
20:36
Avoid deleting a b-tree "has-content" vector belonging to another shared-cache connection from within sqlite3_close(). check-in: 93462df7 user: dan tags: shared-cache-fixes
15:31
First attempt to get ORDER BY optimization working in NGQP. check-in: 9fe20292 user: drh tags: nextgen-query-plan-exp
2013-05-13
18:23
Candidate fixes for problems revealed by notify2.test. Notify2.test is still failing at this point. check-in: ea0428f9 user: dan tags: shared-cache-fixes
2013-05-11
00:06
Minor fixes to the OR-clause processing in the NGQP. check-in: d6946f33 user: drh tags: nextgen-query-plan-exp
2013-05-10
20:26
Now generating OR-clause plans. check-in: e17003fc user: drh tags: nextgen-query-plan-exp
15:16
Update the NGQP so that it can produce plans that include automatic indices. check-in: 586b55d8 user: drh tags: nextgen-query-plan-exp
03:30
Factor out common operations into whereLoopAddAll(). Add stubs for missing features. check-in: 0278e420 user: drh tags: nextgen-query-plan-exp
02:11
Merge in the latest trunk changes. check-in: 5ed31c82 user: drh tags: nextgen-query-plan-exp
02:00
Free up bits of wsFlags for reuse. Install the ORDER BY optimization infrastructure for the NGQP. check-in: 82d50e19 user: drh tags: nextgen-query-plan-exp
2013-05-09
23:40
Merge trunk changes into the sessions branch. check-in: 512f8a1e user: drh tags: sessions
18:12
Add assert()s to the implementation of xRead() in the built-in VFSes to verify that the offset parameter is always non-negative. check-in: cf5c3642 user: drh tags: trunk
14:20
Do not move WHERE clause terms inside OR expressions that are contained within an ON clause of a LEFT JOIN. Fix for ticket [f2369304e47167e3e]. check-in: 1128575d user: drh tags: trunk
00:40
Refine and reform all Windows OSTRACE macro usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. check-in: 610425f1 user: mistachkin tags: trunk
2013-05-08
20:05
Fix memory leaks in the NGQP logic for virtual tables. check-in: 3c2e83a4 user: drh tags: nextgen-query-plan-exp
18:50
Merge all recent trunk changes into the sessions branch. check-in: ae6c4a09 user: drh tags: sessions
17:06
Fix a couple of harmless compiler warnings in the fts3_tokenize virtual table. check-in: 1fa8c457 user: drh tags: trunk
16:57
Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Fix for ticket [6709574d2a8d8]. check-in: ce853a75 user: drh tags: trunk
14:20
Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. Cherrypick from [ceff8955020cd13]. check-in: 7227b615 user: drh tags: trunk
14:14
NGQP working with virtual tables, though many legacy tests fail and there are yet some memory leaks. check-in: bd9327a9 user: drh tags: nextgen-query-plan-exp
14:13
Fix the wholenumber virtual table so that it returns higher costs for unconstrained usage. check-in: ceff8955 user: drh tags: nextgen-query-plan-exp
04:22
More bug fixes to the WhereLoop generator and the solver in NGQP. Now finds the best plan for TPC-H Q8. This seems to prove the concept, but there is still much work to be done. check-in: 8e5aad37 user: drh tags: nextgen-query-plan-exp
03:22
Bug fixes in the solver. check-in: b36034bb user: drh tags: nextgen-query-plan-exp
03:05
Add the NGQP solver. check-in: 5d37587c user: drh tags: nextgen-query-plan-exp
2013-05-07
23:06
Continued progress on generating good WhereLoop objects for the new query planner. check-in: 15cc8a16 user: drh tags: nextgen-query-plan-exp
19:44
Inserting a few WhereLoop objects without leaking memory. Costs are not correct. Inequality and IN constraints are not implemented. check-in: e8881a8b user: drh tags: nextgen-query-plan-exp
17:49
Make sure the ORDER BY collating sequences are compatible with the comparison collations before using the merge algorithm for compound SELECT statements. Candidate fix for ticket [6709574d2a8d8]. Closed-Leaf check-in: fc3630cd user: drh tags: tkt-6709574
12:16
Modify the fts3tokenize table implementation so that it does not use the SQL function fts3_tokenizer. The user may have installed an authorizer callback that prohibits this. check-in: 0ba67b64 user: dan tags: trunk
2013-05-06
21:01
In the command-line shell, output the elements of the schema in the order that they appear in the sqlite_master table. This is necessary in some cases to make the schema parsable. check-in: e5b3cd74 user: drh tags: trunk
20:28
In the command-line shell, make sure the output of dot-commands goes to the same redirected output stream as the result of queries. Ticket [2f96536e7ff7dba] check-in: b72d3659 user: drh tags: trunk
14:57
Add an assert() to fts3_expr.c in order to silence a clang warning. check-in: d8dc2c5f user: drh tags: trunk
13:22
Make sure the authorizer callback gets a valid pointer to "ROWID" for the column-name parameter when doing an UPDATE that changes the rowid. Fix for ticket [0eb70d77cb05bb2272]. check-in: 26a59bb8 user: drh tags: trunk
2013-05-04
20:25
In where.c, make findTerm() a wrapper around methods to a new WhereScan object which is capable of finding all suitable matching terms, not just the first. This check-in includes some prototype functions for building WhereLoop objects. check-in: dd92b8fa user: drh tags: nextgen-query-plan-exp
2013-05-03
20:08
Add magic numbers for Bentley Systems application files. check-in: 9314b080 user: drh tags: trunk
18:29
Merge all recent trunk changes into the sessions branch. check-in: 3879ab1b user: drh tags: sessions
15:23
Allocate meta(8) in the header as the "application ID" and add the "PRAGMA application_id" command to query and set it. check-in: b2efe4f2 user: drh tags: trunk
2013-05-02
17:37
Minor fixes for compilation with SQLITE_OMIT_WAL defined. check-in: b81e87e7 user: dan tags: trunk
00:15
Begin inserting some experimental code for the next generation query planner. check-in: ccaf4c3f user: drh tags: nextgen-query-plan-exp
2013-05-01
20:40
Fix comments in the magic number file. Closed-Leaf check-in: 5a500848 user: drh tags: application-id
20:36
Preserve the application-ID across VACUUM. Updates to the magic number file. check-in: 4a190bea user: drh tags: application-id
19:49
Allocate 4 bytes of unused header space for an "Application ID". Add the "PRAGMA application_id" command to set and query this identifier. Add the "magic.txt" file to show how the posix file command might use this application id. check-in: 28c9e7fd user: drh tags: application-id
17:58
Do not use a transitive constraint to an IN operator where the RHS is a constant if there exists a direct == operator to another table in an outer loop. check-in: faedaeac user: drh tags: trunk
17:22
Avoid redundant constraint checking due to transitive constraints. check-in: 329478cb user: drh tags: trunk
2013-04-30
14:25
Update the documentation to explain that when the 3rd parameter to sqlite3_bind_text() and friends is NULL the result is to bind a NULL SQL value. Ticket [19b44e35753ba] check-in: bd92de0e user: drh tags: trunk
14:06
Make sure extra parentheses around subqueries in the FROM clause are harmless. Ticket [28c6e830f239ea5]. check-in: 1c795692 user: drh tags: trunk
07:58
Add the #ifdefs for sqlite3ErrName() to sqliteInt.h as well. Closed-Leaf check-in: 400fc4c3 user: mistachkin tags: winOsTrace
07:54
Define the sqlite3ErrName() function only when necessary. More robust handling of unknown return codes. check-in: e47cd314 user: mistachkin tags: winOsTrace
2013-04-29
18:07
Improve the error message issued when an FTS query exceeds the maximum allowable tree depth. check-in: f480b1fe user: dan tags: trunk
17:12
Fix an off-by-one in the code for limiting the depth of FTS expression trees. check-in: 72ac7318 user: dan tags: trunk
09:20
Merge mmap test fix from trunk. check-in: 95811877 user: mistachkin tags: winOsTrace
09:17
Fix mmap1.test so that it passes on windows as well as unix. check-in: 52417eac user: dan tags: trunk
08:58
Adjust a WAL test result due to changes in the corresponding return code name. check-in: 9272009f user: mistachkin tags: winOsTrace
08:56
Merge updates from trunk. check-in: 3a245a83 user: mistachkin tags: winOsTrace
07:01
Update 'fuzzerfault' test for its new module loading command. Fix several test names in 'io.test' and make sure the database gets closed between tests. check-in: e81e9ca1 user: mistachkin tags: trunk
03:09
More refinements to Windows OSTRACE usage. Replace all usage of sqlite3TestErrorName() with sqlite3ErrName() and add missing return codes. check-in: 05ba5e23 user: mistachkin tags: winOsTrace
2013-04-28
01:44
Initial work on reforming usage of OSTRACE by the Windows VFS. check-in: b347b5d1 user: mistachkin tags: winOsTrace
2013-04-27
18:06
Remove spellfix virtual table documentation from the source tree. Reference the separate documentation on the website instead. check-in: adcf7890 user: drh tags: trunk
12:13
Untested fix for building on VxWorks. check-in: f14d55cf user: drh tags: trunk
2013-04-26
19:33
Fix a formatting typo in a comment. No changes to code. check-in: 7a97226f user: drh tags: trunk
18:36
Avoid unnecessarily reseting the pager cache after committing a transaction that takes advantage of the SQLITE_IOCAP_ATOMIC related optimization. check-in: c47144e9 user: dan tags: trunk
17:00
Avoid using posix_fallocate() in WAL mode, as it is not supported by all file-systems. check-in: 1bbb4be1 user: dan tags: trunk
16:09
Avoid using posix_fallocate() in WAL mode, as it is not supported by all file-systems. Closed-Leaf check-in: 9c7523da user: dan tags: avoid-fallocate
15:55
Update documentation with new hyperlinks. No changes to code. check-in: 640eb54a user: drh tags: trunk
14:13
Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit (currently 12) on the depth of an expression tree. check-in: 49d23ef6 user: dan tags: trunk
14:04
Merge another trunk change. Closed-Leaf check-in: 2648966f user: dan tags: fts3-expr-rebalance
13:14
Fix harmless compiler warnings in the FTS expression parser. check-in: 3c78af8c user: drh tags: fts3-expr-rebalance
12:08
Reduce the default SQLITE_MAX_MMAP_SIZE slightly so that it fits in a signed 32-bit integer. check-in: 460752b8 user: drh tags: trunk
06:58
Merge latest trunk changes. check-in: 4d08e74d user: dan tags: fts3-expr-rebalance
2013-04-25
20:34
Rebalance FTS expressions after parsing to limit recursion during evaluation. Avoid recursion when deleting FTS expression trees. Enforce a limit on the depth of an expression tree. check-in: f968d43f user: dan tags: fts3-expr-rebalance
19:31
Added the nextchar.c extension. Minor changes to the spellfix.c extension so that it can be appended to an amalgamation and compiled without duplicating symbols. check-in: 56b9a417 user: drh tags: trunk
17:27
Fix the tool/build-shell.sh script to remove references to files that are now loadable extensions. check-in: aabeea98 user: drh tags: trunk
17:07
Add wiki documentation files for the spellfix1 virtual table. check-in: 381564e9 user: drh tags: trunk
16:52
Merge the std-ext branch into trunk. This merge adds several new extensions to the ext/misc folder, including transitive_closure, ieee754, and amatch, and it converts some older src/test_*.c file into extensions in the ext/misc folder. check-in: bbe607c7 user: drh tags: trunk
16:42
Added the transitive_closure, ieee754, and amatch extensions. Closed-Leaf check-in: 84018099 user: drh tags: std-ext
14:59
Move the test_spellfix.c module to ext/misc/spellfix.c. check-in: de556add user: drh tags: std-ext
14:36
Fix the MSVC makefile so that it works with the ext/misc/*.c extensions. check-in: 680822e8 user: drh tags: std-ext
14:31
Convert the fuzzer virtual table into a loadable extension and move it to the ext/misc/fuzzer.c file. check-in: c8c69307 user: drh tags: std-ext
11:58
Make test_wholenumber.c into a loadable extension and move it to ext/misc/wholenumber.c. check-in: efcc9dd0 user: drh tags: std-ext
00:57
Make sure the affinity and datatype of sub-subqueries are initialized prior to subqueries as the latter relies on the former. check-in: 39b4e6ff user: drh tags: trunk
2013-04-24
13:50
Fix a simple comment typo. No changes to code. check-in: f136bd95 user: drh tags: trunk
2013-04-23
20:10
Make "test_regexp.c" into a loadable extension and move it over to ext/misc/regexp.c. Add the "load_static_extension" command for testing purposes. check-in: 860fc393 user: drh tags: std-ext
2013-04-22
23:59
Merge the latest trunk changes into the sessions branch. check-in: 6994826c user: drh tags: sessions
23:38
Fix harmless compiler warnings. check-in: 1a1cf5aa user: drh tags: trunk
19:56
Do not allow a virtual table to cancel the ORDER BY clause unless all outer loops are guaranteed to return no more than one row result. Candidate fix for ticket [ba82a4a41eac1]. check-in: 49cfa14f user: drh tags: trunk
17:07
Update MSVC makefile for the fts3tokenize virtual table. Clear some harmless compiler warnings in the fts3tokenize code. check-in: 2b3fed09 user: drh tags: trunk
15:30
Add virtual table module 'fts3tokenize' to fts3. fts3tokenize provides SQL access to FTS tokenizer implementations. check-in: c5a4b21a user: dan tags: trunk
13:51
Enhanced documentation for the SQLITE_CONFIG_SQLLOG mechanism and the test_sqllog.c demonstration file. No changes to code. check-in: 206caf21 user: drh tags: trunk
02:39
Use transitivity to move constraints into the outer loops of a join whenever possible, thereby reducing the amount of work that needs to occur in inner loops. check-in: 5f4907e1 user: drh tags: trunk
2013-04-19
12:32
Add the "warning" command to the TCL test infrastructure. Fix problems with the loadext.test module. check-in: 514adbbd user: drh tags: trunk
02:47
Enhance the extension loading mechanism so that the same source code can be used for run-time loadable extensions and statically linked extensions, and to mask architectural differences in shared libraries. check-in: a85b6ece user: drh tags: trunk